Oracle is a RDBMS (Relational Database Management System) created by Oracle Corporation. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java. Also included is support for C (Pro*C, OCI and EXTPROC), C++ (OCCI) and Java (JDBC) ...
2
votes
0answers
109 views
Create Oracle ASM Disks Without Installing Oracle
I have been asked to setup workstations (VMs) for an instructor's Oracle 11g R2 Workshop. I am finding the documentation that was downloaded from the Oracle Academy site extremely underwhelming. I am ...
3
votes
1answer
116 views
Why is truncate DDL?
I have an interview question, which being asked during my interview. I answered the question, but interviewer was not convinced with my answer. So, please let me know the what would be the correct ...
3
votes
1answer
89 views
Where's my Network Alias list in Oracle?
I can't select any Network Alias from the Network Alias Drop-down.
My TNSNames.ora file is in C:\Oracle
My other machine that is a fresh install doesn't have this problem.
I get an error when I ...
1
vote
1answer
355 views
How to Install/Configure Oracle Instant Client on Ubuntu
Installing the Oracle Instant Client on Ubuntu/Debian based systems is awkward since Oracle is RPM centric regarding its Linux support.
What's the best way to easily install and configure the Instant ...
0
votes
2answers
56 views
oracle null value in quotes - yet another newbie question
I have a where clause like
"and uc.completion_status in ('[P....]') "
here ('[P....]') is the user input from taken a dropdown list in the user interface. and dropdown list consists three options ...
3
votes
1answer
392 views
How to find the schema name of a data pump dmp file?
I have been given a DMP data pump export file to import into my local Oracle instance. I've tried running this command line:
impdp full=Y directory=DATA_PUMP_DIR dumpfile=MyDumpFile.dmp ...
2
votes
1answer
368 views
Oracle startup error (could not open parameter file)
I installed the Oracle 11g server on Ubuntu 12.10. But I can't start the server. When I start up the server, the following error occurs.
SQL> startup
ORA-01078: failure in processing system ...
1
vote
1answer
94 views
Specify Server for DBMS_Scheduler Job in Policy Managed RAC
A unit test requires a dbms_scheduler job to run on the same RAC node as the unit test is being run from. I know that with an Admin managed database this could be done by creating a service that ...
0
votes
0answers
57 views
Are there any good open source tools for DB objects end user manipulation?
I've been recently tasked to provide some object adjustment features for our end users, simple thing like changing the value of two or three fields in some specific business know tables without the ...
3
votes
3answers
73 views
Sum Up values in a query based on other information
I am trying to grab the sum of 2 columns if 1 column is the same. I currently have a record-set that looks like this:
I get these results by running this statement:
select distinct a.eventnum, ...
0
votes
0answers
46 views
MS Access client: store (OLE) documents in Oracle table [closed]
I would like to try storing documents in an attached Oracle table from MS Access, exactly like one can do with OLE Object fields in Access tables.
Is that working ?
Which field type can be used in ...
2
votes
1answer
61 views
Blocking incoming database links
Let's say there is an Oracle database A and another Oracle database B. Our database is A.
Is there a way to block database links from B to A?
7
votes
1answer
230 views
Is there an execution difference between a JOIN condition and a WHERE condition?
Is there a performance difference between these two example queries?
Query 1:
select count(*)
from table1 a
join table2 b
on b.key_col=a.key_col
where b.tag = 'Y'
Query 2;
select ...
1
vote
2answers
790 views
“ORA-01950: no privileges on tablespace 'SYSTEM' ” : What error is it?
Earlier I created a user :
SQL>create user suhail identified by password
SQL>User created.
SQL>Grant create session,create table to suhail;
SQL>Grant Succeeded.
but when I login as ...
4
votes
1answer
874 views
Oracle 11g listener fails with ORA-12514 and ORA-12505 errors
I run an instance of Oracle 11g locally on my development machine and can connect to the local instance directly via SqlPlus:
c:\>sqlplus ace
SQL*Plus: Release 11.2.0.2.0 Production on Mon Mar ...
1
vote
0answers
201 views
Oracle 11g R2 - same query sometimes fast, sometimes slow
I have a simple update query on a table with about 100 rows in it:
UPDATE RESULTS_DATA
SET IMAGE_BLOB=:myBlob
WHERE MEASUREMENT_INDEX=:mIndex
AND BATCH_ID=:batchId
AND SYSTEM_ID=:sysId
...
0
votes
2answers
435 views
“ORA-01017: invalid username/password” : Why is that?
What is the difference between the two :
SQLPLUS / AS SYSDBA
and
SQLPLUS
Enter user-name: SYSDBA
Enter password:
If I use the first command I get connected and see the prompt SQL> but upon ...
2
votes
1answer
65 views
Fast paginated result, for various filter clauses
I have been working on obtaining a paginated result from a table in my database (11g). While I have a query that does work (ie, the result is correct) it does not perform as well as I'd like to and I ...
1
vote
1answer
50 views
Update field1.table1 based on compound join between table1 and table2 - Oracle
I want to run update statement on Oracle 11g, but it fails with the following error:
SQL Error: ORA-01427: single-row subquery returns more than one row
01427. 00000 - "single-row subquery ...
0
votes
0answers
55 views
TimesTen performance as compared to 10g
I am new here, so please be nice...
I have a question regarding TimesTen & Oracle. I have attempted an experiment with both pieces of software, and realize that the query speed on a table is ...
1
vote
1answer
136 views
Possible reasons for slow BLOB updates in Oracle?
We have an application that transfers .bmp images as BLOBs to an Oracle table. One of the users of the app has complained that it is taking 2-3 seconds to transfer each image. Each image is ~1.2Mb. ...
3
votes
1answer
128 views
Oracle Illegal use of long datatype when moving tablespace to bigfile
I am currently migrating all the tables in my database to a bigfile tablespace. I have written a script to do this and all tables are migrated successfully except one. I am given the error:
Error ...
2
votes
2answers
77 views
SQL Max() revision number
This SQL returns a table with everything unique, which is what I want. However, if there are two (or more) event numbers, I need it to return the line with the highest rev_num for that eventnum.
I ...
0
votes
1answer
67 views
Logging and saving user activity
Database:Oracle 11gR2
OS: Windows 2008 Server R2
I'm not trained DBA, just have to run things on an Oracle database temporarily, which is used to perform OLAP processes.
I need to automatize user ...
0
votes
1answer
148 views
Set encoding from within SQL*Plus
I have a large set of files with SQL commands that I run with a SQL*Plus script that uses the @@ operator. I run the script on third-party computers (or even send it by e-mail) so I'd like to make it ...
1
vote
1answer
382 views
How to monitor space usage on ASM diskgroups
Last night the recovery area on one of our Oracle Database Appliances went full. This was reported in one of the database alert logs, and we were able to clear out some space before the next log ...
0
votes
3answers
196 views
I killed a session and it is still running?
I have Oracle 9.2
I view my running session with the query:
SELECT S92700.SYSUSR_VW."NAME", SID,SERIAL#, AUDSID
FROM v$session, S92700.SYSUSR_VW, S92700.SECUSR
WHERE S92700.SYSUSR_VW.SESSIONID = ...
0
votes
0answers
38 views
How we can synchronize a MySQL database to an Oracle database?
How we can synchronize a MySQL database to an Oracle database?
The Oracle database is in secure zone that can only be accessed by application servers. We have multiple MySQL databases in different ...
1
vote
1answer
120 views
ORA-16000 when trying to perform select on read only access ORACLE database
My application's SQL encounters ORA-16000 when trying to access read only Oracle Database
ORA-16000: database open for read-only access ORA-06512: at "SYS.XMLTYPE",
line 272 ORA-06512: at line 1 ### ...
0
votes
0answers
45 views
Database too slow after CHARSET Conversion
I have an Oracle database which runs on version 9.0.1 with WE8859P1 charset and i'm trying to migrate it to the version 9.2i which has the WE8MSWIN1252 charset.
The conversion is made without any ...
1
vote
2answers
48 views
Oracle Case when problem
I Have a table like fallowing
work_id group effort
----------- ----- --------
1 A 10
1 B 5
2 A 7
2 ...
0
votes
1answer
117 views
Migrating Oracle smallfile to bigfile tablespace
I am wanting to migrate all tablespaces in an existing db to use bigfile tablespace rather than the smallfile tablespace. The Oracle documentation hints that this is possible but doesn't explicitly ...
0
votes
1answer
228 views
ORA-00990 error while trying to grant priviliges: Why is that? [closed]
After creating a user named suhail I am trying to grant that user some privileges. But I am getting an error saying missing or invalid privilege . Why is that ?
C:\Windows\system32>SQLPLUS / AS ...
0
votes
0answers
194 views
How to display Oracle Enterprise Manager 11g (OEM) alerts and reports in Nagios?
I am working on a project that requires an unobtrusive integration of OEM data into a Nagios front-end. I know there are ways to use SNMP traps to do this, but I am not completely familiar with how ...
1
vote
1answer
58 views
Question about Oracle's interpretation of “host cpu utilization” in v$sysmetric view
I am studying the v$sysmetric view from Oracle and trying to understand what is Oracle's interpretation of "Host CPU Utilization"
It says in the metric_unit as % busy/(idle + busy), but what is busy? ...
1
vote
2answers
194 views
A database in MySQL is a schema in Oracle : I do not understand this statement
Please help me understand this statement:
A database in MySQL is a schema in Oracle.
I have just started to use Oracle and I find it different from other RDBMS softwares I have used like MSSQL, ...
1
vote
1answer
226 views
SSMS Oracle import using OpenQuery over LinkedServer (Oracle Provider for OLEDB) - XML Parsing: unable to switch encoding
I am trying to migrate the data from an OracleDB to an SQL Server Express database. I'm doing this by openquerying a linked server (data provider based on Oracle Provider for OLEDB). Everything works ...
1
vote
2answers
135 views
What's the best way to backup DB files via network on Linux and Solaris machines?
I wonder what the best way to backup files via the network.
I have Solaris machines with Oracle 10i on a Veritas cluster. Machines are connected to EMC storage.
The /data/oracle directory is mounted ...
1
vote
2answers
87 views
PreparedStatement caching size on Oracle and SQL Server
I understand that PreparedStatements are complied and cached by database servers.
I would like to know if all the preparedStatements are complied and cached on the server, in which case what is the ...
0
votes
2answers
235 views
Advice for ETL from Oracle to SQL Server?
I'm building a data mart in SQL Server which needs to extract each month from an Oracle database. Currently this is done by exporting to flat files, then running all the inserts/updates in SQL ...
0
votes
0answers
90 views
implementing DAC and MAC in Oracle
I want an example that might help me implement a dynamics modes of an access mode model.
From from page 58 of Secured Database Application Development:
Static Access Modes are:
use 1 ...
-3
votes
2answers
170 views
Versioning data in Databases [closed]
Is there any ready mechanism in Oracle, SQL Server, PostgreSql or OR framework (C#), which can version information in a database? By versioning informartion I mean that e.g. I have table Person (id, ...
0
votes
0answers
111 views
Unable to configure Informatica sources with ODBC 64 bit drivers
I have an Oracle database installed on my local system (64 bit) and am trying to use Informatica as an ETL tool.
My problem is that my database is working fine (I am able to connect to it via ...
4
votes
3answers
62 views
STARTUP command fails : Why is that?
I just installed Oracle Database Express Edition 11g Release 2.This is the first time I am using Oracle. Earlier I have used MySql and MSSql and I bet this one is a lot different !
These are the ...
3
votes
1answer
383 views
What queries is Oracle executing, how frequently, and time-taken?
I have a (Java) web-application, that of course executes many queries (selects, inserts, updates, deletes) to the Oracle Database.
I want to find out the following for last 7 days:
SQLQuery ...
1
vote
0answers
37 views
How open oracle DB Linux (After installation)
I have just installed Oracle 11gR2 on my Linux Mint Distro (xfce). All worked fine, and I was able to acces to
https://localhost:1158/em [Erreur 102 (net::ERR_CONNECTION_REFUSED) ]
I rebooted my ...
1
vote
1answer
70 views
Unable to start Oracle Database Server : Get an error as I try to start it
I just installed Oracle Database Express Edition 11g Release 2 for windows.It created a short cut icon on the desktop :
but as I click this icon I see this dialog box :
What is it ? How do I ...
1
vote
1answer
35 views
Hard Parse on Non-Identical Statements?
Let's say I have this query :
SELECT X FROM Y
If I run it for the first time then it would do a hard parse.
After that, I run this query :
select x from y
With just a difference in alphabetical ...
6
votes
1answer
159 views
When a record is locked in Oracle, can we know which record is locked?
When a record is locked ,can we know which one is locked?
How can I get the record rowid or something else info?
I can get some info by this sql
SELECT ...
1
vote
1answer
54 views
In Oracle, will certain users only be able to see certain data in the privileges tables?
I can view data in the table_privileges view logged in as a particular user, but it seems to be missing or different information when logged in as a different user.
For the privileges views (data ...
