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) ...

learn more… | top users | synonyms

0
votes
1answer
45 views

rownum won't return records above 100

I have this query: SELECT * FROM ( SELECT v.*, ROWNUM recnum FROM ( SELECT hostaddress, modulename, severity, escalation, classification, ...
0
votes
1answer
36 views

How to organize a development environment using Oracle XE 11g?

I started developing small applications using Oracle XE 10g/11g using APEX. They are intented to be run on desktop computers that acts as a server in small offices. Oracle XE is well suited for those ...
0
votes
0answers
46 views

ORA-01658 on index tablespace when trying to insert into empty table of new database

We are getting ORA-01658 (Error :ORA-01658: unable to create INITIAL extent for segment in tablespace MYDATA_LDATA_INDEX) in our application logs. This happens when application is trying to insert ...
0
votes
1answer
52 views

VS 2012 SSIS Data Flow Designer Source Assistant Error: [SSIS.Pipeline]: Component ", clsid {4CAC … Could not be created

I am creating my first SSIS package to support the E of our ETL from an external Oracle database to our internal SQL Server 2012 databse. Using Visual Studio 2012 and I have installed the Microsoft ...
0
votes
1answer
62 views

Is RMAN backup platform independent?

I have RMAN backup from AIX server and want to restore on Linux OS. Could you please let me know if there is a way to do it? Thanks a lot for help in this regard.
0
votes
2answers
43 views

Oracle tables partition related

Here is my doubt. Is it possible to apply a partition to one table depending in the partitions values of another one? Why I am asking? I have one table where information headers are persisted, and ...
1
vote
2answers
50 views

Trunc sytax problem

If any one could help me with the syntax issues which I am facing here. sqlshipped := ' and a.ORDS_COMPLETED_DATE between ' ||shippedfrom ||' and trunc(' ...
0
votes
1answer
54 views

Slowness after migration to RAC 11gr2

we are getting slowness after migrate from ORacle 10gr2 single db to Oracle 11204 oracle rac (standard ed) with asm, on oracle solaris 11. at this momento we have only one node. In the next days we ...
0
votes
0answers
47 views

ORA-15321: cannot set attribute with connected clients

I need to set an attribute on my ZFS Storage Appliance. I have shutdown all attached databases but still I get this message: SQL> alter diskgroup DATA_ZFS02 set attribute 'storage.type'='ZFSSA'; ...
0
votes
1answer
34 views

Defining the host on a new installation of Oracle 12c Enterprise Manager

I just started working with Oracle's products, and I downloaded the "Developer Day" VM from the following link: ...
-1
votes
1answer
39 views

How to compare a result of a query to a number? [closed]

I have a query that return selects a table and returns one column with a number, and I want to know if the result is > 0. SELECT * FROM Table WHERE (SELECT amount from Table2) > 0 ...
0
votes
0answers
30 views

dynamic query manupulation

I am trying to append a dynamic query given below to a non-dynamic query. Given below is the dynamic query. sqlFilter1 := ' and (g.STSL_USRS_ID = ' || User_ID || 'OR (dept.DEPT_NAME IN (select ...
0
votes
1answer
321 views

ORA-15081: failed to submit an I/O operation to a disk

I have a test environment for Oracle single instance on ASM 11.2.0.3. I have restored database from tape and during the recovery, the system crashed by some I/O error. I restarted the server, ...
0
votes
0answers
41 views

How to forwarding connection between 2 Oracle Database?

I have 2 Databases on independent 2 Linux server. I'm using Oracle 10G and 11G. I have this stage: client -> connect to Server A -> check Database A (check specific tablespace or database A is ...
0
votes
0answers
40 views

Oracle data obfuscation on specific columns with set field sizes

Would like to obfuscate data held in Oracle tables, but: Requirements only apply to specific columns e.g. personal data obfuscated value should not be longer then column size possibly only ...
0
votes
0answers
50 views

EMCA port Issue on Installing Oracle on Windows Server 2008 guested on VMware

I am trying to install Oracle 11gR2 on Windows Server 2008 guested on VMware Workstation 10 but I am getting this error on Enterprise Manager Configuration. I also tried to login to the database ...
0
votes
1answer
30 views

Implement a deduplication trigger in Oracle

I am new in Oracle DB. We are using Toad for Oracle. I need to implement a deduplication trigger for our table. It's an alarms table and a third party vendor will be sending alarms to our database. ...
0
votes
0answers
35 views

Why we usually have UNIFORM Allocation type for creating Temporary tablespaces in ORACLE?

Actually i'm a new to Oracle DBA field , when i was going through my database i saw that for temporary tablespaces we have UNIFORM allocation type . So i just want to know the exact reason for this .
1
vote
1answer
86 views

table or view does not exist

am trying execute this lines in procedure : FOR I IN (SELECT * FROM TBL_MT_MOATA WHERE MT_RECEIVED_TIME between TO_CHAR(TRUNC(SYSDATE,'Month' )) AND LAST_DAY(TRUNC(SYSDATE, 'Month'))) LOOP ...
0
votes
1answer
50 views

12c Shell to Linux

I am replacing two Oracle 11g servers with 12c TL/DR - when shelling out to a run an O.S. file, the PATH environmental variable is not being set. On the old servers we use an external library to ...
0
votes
0answers
19 views

How to display '0' against an empty database field (number) with defined fomat mask [duplicate]

I have an Oracle Report (11g) in which I have selected a number field containing amount and have mentioned the format mask as 999,999,999,999. The data is displayed as follows. Data1 25,000 Data2 ...
1
vote
0answers
65 views

How to display '0' where no data found in PL/SQL Oracle Reports

I have an Oracle Report (11g) in which I have selected a number field containing amount and have mentioned the format mask as 999,999,999,999. The data is displayed as follows. Data1 ...
0
votes
1answer
46 views

Recover data from bak Oracle 9i file

Our customer gave us a .bak archive with name file_decrypted_379299.bak which we know was created with Oracle 9i in "hot" style. We tried to recover the bak file with Oracle 9i RMAN but we don't know ...
2
votes
1answer
54 views

Oracle idle connections lost

I have a problem with an Oracle 11g instance. Every connection that has been idle for about 20 minutes are lost. I get the following error ORA-03135: connection lost contact I did the following ...
0
votes
0answers
115 views

“ORA-19599: block number 1 is corrupt in archived log” while doing active duplication of database

I am attempting for Active database Duplication and facing the ORA-19599 error. Script used and error are below:- duplicate database to reynolds from active database nofilenamecheck spfile set ...
0
votes
1answer
125 views

Oracle strong ref cursor with dynamic sql

I'm using Oracle 10g. I have a query in a stored procedure that selects entire rows from a table. Currently it returns a strongly typed ref cursor (tablename%rowtype). Now I have to add some dynamic ...
0
votes
1answer
129 views

How index work in oracle? [duplicate]

I want to understand : How index work in oracle. How they are stored in the disk. How they increase the efficiency of a query? By third point I means how Index contribute to the efficiency of ...
0
votes
2answers
49 views

How to store a database table in multiple disks with assigned ratio?

I am going to deploy database tables to multiple disks. My database layout would be like following example: There are 3 tables (Customer, Order, Product) and 4 disks (disk_A, B, C, D). Customer: 5% ...
0
votes
1answer
65 views

Installing Oracle 11g on Windows SBS 2011 64 bit

In the Oracle web site, I found the following requirements: http://docs.oracle.com/cd/B28359_01/install.111/b32006/reqs.htm#CHDHGGFE Oracle Database for x64 Windows is supported on the following ...
0
votes
1answer
86 views

query to search a particular word/string in toad/oracle

I trying to find out a word/string named 'audapro_ind' in oracle database in toad. This word can be present anywhere in column of table, function, procedure etc. in oracle database I tried few ...
0
votes
2answers
73 views

Tips on using SQL access advisor in Oracle

Please share how to use oracle SQL access adviser for single or multiple queries. you can assume that we know the sql ids for the queries we are interested in.
0
votes
1answer
97 views

ORA-30009: Not enough memory for CONNECT BY operation

I have a Linux VM (with CentOS 64 bit) where I installed Oracle Database 11g Express Edition. The database is running, I can use sqlplus and I can create tables and stuff. However, when I run a ...
0
votes
1answer
64 views

Oracle silent install on Redhat Linux (The Global database name was left blank.)

I am installing Oracle 11g in silent mode using the response file that is in the database/response directory. It is three response files in that directory(i.e. dbca.rsp, db_install.rsp and netca.rsp). ...
1
vote
1answer
74 views

What useful information can I get from ASH report which I cannot get from AWR report?

What useful information can I get from ASH report which I cannot get from AWR report? What are the common scenarios in which its better to get information from ASH than from AWR?
0
votes
1answer
106 views

Oracle error: UDI-00018: Data Pump client is incompatible with database version 11.01.00.06.00

I'm trying to use data pump to move the database to a different server with this command: impdp dbuser/dbpsw@dbserver directory=data_pump_dir network_link=sourceDB schemas=EMP But I got this error: ...
1
vote
2answers
75 views

Bad bind variable in audit trail trigger in Oracle 11g R2

I have been trying to construct audit trail triggers and procedures in oracle and I am facing a problem with bind variables. Following is the code create or replace trigger trg_audit_trail for insert ...
0
votes
1answer
58 views

What index(es) should I use for three columns join?

I have a table which has the following columns: CREATE TABLE example ( exid INT, extype INT, studentid INT, (more columns) ) The table will have hundreds of thousands rows, and each ...
1
vote
1answer
159 views

ORA-29339: tablespace block size 16384 does not match configured block sizes

My box is RHEL 6.2, and file system BLOCK SIZE is 1024. # tune2fs -l /dev/sda1 ... Block size: 1024 ... My Oracle is 11g, and database block size is 8192. SQL> show parameters ...
0
votes
0answers
29 views

Slow exporting SAP Data Services to MySQL (Oracle is faster)

We've a MySQL 5.1 server and we are trying to import data from SAP Data Services from another server. It works but it takes 3h! We tried to setup an Oracle XE server to test the same operation and it ...
1
vote
1answer
48 views

Oracle - Date of Selection on table

how to get last date when someone perform selection on table? Last accessed in terms of select statement only not last updated date
0
votes
0answers
154 views

Oracle installation requires old rpm versions, what to do?

I am installing Oracle 11g R2 on OEL6. I run the following command, for to check only prerequisites ./runInstaller -silent -responseFile /0/grid/response/crs_install_mk.rsp -executePrereqs It ...
0
votes
1answer
75 views

Exporting from Oracle enterprise edition to standard edition reaches schemas limit

So, I'm trying to export an oracle database(10.2) from EE to SE over a networklink. It all works fine except that I'm hitting a limit. The database has 1335 schemas and it seems that I can't transfers ...
1
vote
1answer
111 views

Check only prerequisites when running runInstaller in silent mode

I want to check just prerequisites and generate a log without installing Oracle database. When I run the following command: ./runInstaller -silentvalidate -responseFile ...
0
votes
2answers
154 views

Finding all sql id, sql text, number of executions,execution time between two AWR snap ids in oracle

AWR report provide the SQL information for top 10-20 SQLs, is it possible to get information on SQLs that do not make it to the top list. How do we find all sql id, sql text, number of ...
1
vote
4answers
55 views

What does SQLCODE = -00942 signify?

I am very sorry if I am asking a very basic question, but I googled for this and found no useful info.. Please help me under what sql code -00942 stands for.. thanks in advance.
0
votes
0answers
26 views

Where to get the old version oracle service?

I want to do some work with the existing long-run-time of Oracle database, such as 8, 9 or 10, because the newest Oracle's TNS protocol has changed(and always between different release), so Wireshark ...
2
votes
1answer
51 views

Does Windows Server File Compression slow Oracle DB performance?

I'm starting a new a new contract and I get to troubleshoot their Oracle instance... I'm more apps and sql, but I'll be trying to figure out their crashes and slow performance. Go figure. I can ...
-1
votes
1answer
114 views

How to set up a connection in Pentaho Kettle for Oracle using a SERVICE NAME instead of SID?

This error shows up when I try to connect to database string host:port/servicename.
0
votes
2answers
166 views

exporting oracle tables on command line as sql files

I use exp and expdp to export database tables on command line but it generates binary .dmp files. I want to export/import tables as .sql* files on command line like pl/sql developer app can do. Is ...
0
votes
2answers
63 views

How to make a trigger work after a certain UPDATE

I would like to know if it's possible to create a trigger on Oracle that is invoked only when a certain UPDATE is done. For example: UPDATE colors SET tastes_good = y WHERE color_name = 'Apple'; ...