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

1
vote
1answer
64 views

There is an equivalent of login.sql on PostgresSQL?

When you log on Oracle database with SQLplus, it looks for a login.sql file in the current directory. If the file exists, it's executed. It's usefull to set preferences... There is an equivalent ...
4
votes
1answer
938 views

Oracle extract slow function call from a WHERE clause

I have an oracle table in which dates are stored as the number of minutes since a specific date. It looks something like this: CREATE TABLE MY_TABLE ( SOMETHING NUMBER(15,1) NOT NULL, ...
2
votes
0answers
79 views

Oracle 10g weird behaviour

We have a thick client application using an Oracle 10g database. We recently upgraded the application and in the process migrated the database tables from a latin to unicode character set. After the ...
3
votes
2answers
139 views

How to retrieve disk spaces by removing tables from tablespaces in Oracle 10g?

I'm using a Oracle 10g database. I have a big tablespace MYTBS made of a dozen data files (MYTBS_01, MYTBS_02, ...) of different sizes which have been added through the years. Now i have removed very ...
1
vote
1answer
66 views

Oracle and TimesTen - Can you bind it?

I have some questions, that I like to know to my MSc research. Lets consider following situation: I have two small tables A and B. And two big tables C and D. I want to put A and B in TimesTen and C ...
6
votes
1answer
425 views

Package state not re-intialized on raise_application_error

When a package has state and the header is changed, the first call gets an error stack something like this: ORA-04068: existing state of packages has been discarded ORA-04061: existing state of ...
0
votes
1answer
2k views

How to connect to a Database made by Oracle SQL Database?

So I am fairly new at this, so if you could keep that in mind in your answers, it would be much appreciated. I installed Oracle SQL Database on my Windows PC. It came in two zip files. I installed it ...
0
votes
0answers
70 views

SYS_CONTEXT INSTANCE changing on failover?

When using Oracle RAC with either Fast Connection Failover or TAF (Transparent Application Failover), for a given database connection, is SYS_CONTEXT('USERENV', 'INSTANCE') going to change when ...
1
vote
2answers
640 views

Factoring out subselect (with clause) ends in ORA-00904

I am trying fo factor a repetitive subquery with with but getting ORA-00904 over and over again. This is my base query which works quite well: select tka.id, tka.name, txt.text as langname, ...
3
votes
1answer
737 views

Why ORA-00932: Inconsistent Types error?

Sorry for the meaningless title, but I couldn't think up a better one. I'm using Oracle 11g r2. The following query raise ORA-00932 error: SELECT BBB.FIELD1 FROM TABLE0 AAA JOIN (SELECT * FROM ...
2
votes
1answer
801 views

Archiving fga_log$: sys.dbms_audit_mgmt.clean_audit_trail doesn't delete anything

I am having a problem to archive and then delete portions of the fga_log$ table. Here's what a script basically does insert into fga_log_archive select ... from sys.fga_log$; begin ...
1
vote
0answers
383 views

What is the nature of “LGWR: Setting 'active' archival for destination LOG_ARCHIVE_DEST_2”?

I'm not sure when this started, but for the time being the primary database instances in a physical standby configuration logs this message on every redo log switch. ...
4
votes
1answer
526 views

Is there a way to export an Oracle database to a CREATE DATABASE command?

I have an existing Oracle 11 instance, I want to export the database (which was created via DBCA) to an equivalent "CREATE DATABASE" command, handling the character set, etc. I'd also like to get a ...
2
votes
0answers
1k views

Access 2010 linked table - solve the “decimal field's precision” error

I have an Access 2003 database (running on Win 7 64-bit, Office is also 64-bit) that has many linked tables pointing to an Oracle 11g instance through 64-bit Oracle ODBC driver. Most of the tables ...
1
vote
2answers
2k views

Oracle RAC with single node Data Guard physical standby

Best practices for Oracle 11gR2 Data Guard implies that the primary and standby databases should have the same layout, eg. RAC to RAC. What special considerations would one need to take into account ...
3
votes
2answers
455 views

Verifying Oracle*Net network encryption

I've been struggling to implement Oracle's network encryption between two of my test boxes. I think I've finally been able to do it, but I can't seem to find a way to verify that it is indeed ...
2
votes
2answers
144 views

What to call a column that references another row in the same table?

I have inherited a table that contains a column that is used to "chain" between various related rows within the same table. For instance: id, bar, reference_id 1, 'foo', 2 2, 'foo', 3 3, 'foo' ...
0
votes
1answer
65 views

Database can be accessed by all

I have installed Oracle 10g Lite on an administrative system with 32-bit Windows XP as the OS. I have N client systems with a mix of 32/64-bit Windows 7/8 OSes. How can I configure the server as ...
1
vote
1answer
252 views

Change a partitioned global non-unique index that is the primary key to a non-partitioned unique index

One of the largest tables in our system has its primary key setup as a globally ranged partitioned (in huge, useless, multi-billion value ranges) non-unique index. Its values are just a sequence ...
4
votes
2answers
129 views

Is there a bug with PL/Scope in combination with associative arrays?

I believe I stumbled upon a bug with PL/Scope in combination with associative arrays, but perhaps I overlook something. I have the following package create or replace package tq84_pkg_c as ...
1
vote
1answer
420 views

Oracle delete technique for table's segment size (data compactness)

I would like to ask if there is any effect on the following deletion technique of a database to the tablespace size. The existing code for clearing the data has the following style of code before: ...
0
votes
0answers
279 views

How to resolve TNS error in Oracle when using an ODBC DSN

I have come across this error when I was trying to insert data from front end (using JSP) to back end (Oracle 10g): java.sql.SQLException: [Oracle][ODBC][Ora]ORA-12154: ...
2
votes
1answer
255 views

Parsing and binding variables for SELECT .. WHERE column IN ( .. ) queries

I'm looking to make sure that all queries in a php web application have proper use of bind variables to minimize parsing of the queries. I'm wondering how Oracle parses queries that compares a ...
0
votes
0answers
46 views

How can I backup Oracle with Listener error

On my server that I have installed Oracle, I encounter a TNS Listener error and i couldn't connect Oracle. Is it possible to backup database with Only my user and password, without listener?
0
votes
1answer
983 views

Oracle Express edition on Ubuntu - control file missing

I have installed the Oracle Express edition on Ubuntu as mentioned here. I am facing issues when I try to create a sample table. Started oracle $ sudo service oracle-xe start Starting Oracle ...
1
vote
0answers
59 views

Oracle update query sequence of actions on DB side

I searched online but could not find particularly consolidated source of what happens when you execute an update query. I know that there are a few actions happening like create redo data and logs ...
-1
votes
1answer
1k views

how to connect remotely to oracle database [closed]

I've installed oracle 11g express edition and sql developer. I don't know ho to connect to a database on remote server. Can anyone help please. Note that I didn't installed any other software like ...
0
votes
2answers
191 views

RMAN backup script failing

I have a few linux machines and each of them have a few Oracle databases. On each machine we have 2 shell scripts to run the backups. The TSM scheduler calls a script which calls a different backup ...
1
vote
1answer
156 views

Is there a way to export Oracle's UNDO?

I tried exp utility to dump all database. Looks like this exports only the last version of data skipping undo log. Using flashback queries I see: 01466. 00000 - "unable to read data - table ...
1
vote
1answer
919 views

How to open Oracle listener for three database instances?

I have 3 database instances: orcl JIP02T JIP04T When I start the database, does it start all 3 instances? When I start the Oracle listener, does it start a listener for all 3 instances? When I ...
2
votes
1answer
276 views

oracle streams apply: how to get a reason why LCR message was not applied

I've set up bidirectional oracle streams replication (11gR1) using identical scripts on both machines (DB1 and DB2). Although changes from DB1 are being applied to DB2, changes from DB2 to DB1 aren't. ...
0
votes
2answers
2k views

How to find Oracle error log in 11gR2?

I am facing issues with Oracle log files. My application inserts data from xml file into Oracle. I started my application last day and went home. It stopped unexpectedly at 8PM. There is no log in ...
0
votes
1answer
62 views

Oracle database migration or copy

I need to do migrate or copy the oracle 10g database from sun solaris to another sun solaris server (oracle 11g). I was tried with SQL Developer tool. But It is not able copy all the objects in the ...
2
votes
2answers
432 views

How well, if at all, does Oracle NoSQL database integrate with Oracle RDBMS?

I currently have an application which runs on Oracle RDBMS and an area of new functionality which would be better supported by a NoSQL store. I am wondering if Oracle NoSQL Database may be a good ...
2
votes
1answer
169 views

Generating an arithmetic sequence

I would like to generate a named table in a WITH clause which will contain this arithmetic progression: ╔══════════╗ ║ mynumber ║ ╠══════════╣ ║ 0 ║ ║ 30 ║ ║ 60 ║ ║ 90 ║ ║ ...
6
votes
0answers
137 views

9i streams capture doesn't evaluate rules

I have a streams replication set up between two oracle 9.2.0.8 instances as sources and an 11g instance as a destination, processing a small subset of data from each database (let it be one table ...
0
votes
2answers
1k views

Create a “barrier” (prevent parallel execution) in Oracle PL/SQL?

I'm maintaining some stored procedures in an Oracle 11g RAC environment that are part of the pipeline of steps for data-interchange with other systems. One in particular has been producing duplicate ...
2
votes
1answer
889 views

Changing a materialized view column's length after a change in the base table?

We changed the underlying table column size (length). So the materialized view which is built on that table throws an error now since the MV column still has the old size. This is an Oracle 11gR2 ...
1
vote
1answer
189 views

Deleting folders after Oracle upgrade

I upgraded from Oracle 10g to Oracle 11g in Windows Server 2003. New Oracle home : C:\app\oracle\product\11.2.0\db_1 Old Oracle 10g was installed on: C:\oracle\product\10.2.0\ Questions Is the ...
0
votes
1answer
1k views

More than 4000 chars gives string literal too long error on oracle

While updating a field that will have more than 4000 chars, I was given a error : ORA-01704: string literal too long So, going through few blogs, I got this: declare vClobVal varchar2(32767) ...
0
votes
0answers
3k views

Oracle XE TNS Listener fails to start

I freshly installed Oracle XE 11.2.0.2.0 and found out that the TNS Listener service fails to start. At first I tried to start the Windows service by hand. After the failure this is the entry in the ...
8
votes
2answers
105 views

Read ancient Oracle database into current Oracle version

An old computer with Oracle 8i is dead. We have the daily backup of the database (C:\oradata). We are unable to install this old Oracle version anywhere because we don't have the install CDs for it. ...
2
votes
1answer
4k views

Expanding system tablespace

I need to add new data file into the system tablespace because its running out of space. Are there any precautionary measures I should consider since this is a production environment?
-1
votes
2answers
302 views

Oracle SQL Query/SubQuery Single column with mutilple data [closed]

Id File-Name Descrption 1 yyyy Started 2 yyyy incompleted 3 rrrr Started 4 tttt started 5 uuuu started 6 rrrr completed 7 tttt completed 8 uuuu ...
1
vote
1answer
5k views

Difference between database dump (export) and database backup?

What is the drawback using only EXP command for a database dump (and considering it as a backup) instead of taking backups using BACKUP DATABASE command (via RMAN)? What is a difference between ...
4
votes
1answer
14k views

How to transfer data using expdp and impdp commands?

I'm Oracle noob, and my intention is to transfer all data and metadata from one schema to another schema within an Oracle database. I'm planning to use datapump expdp and impdp commands. I have ...
2
votes
1answer
520 views

How to Recover My Oracle 9i Database From Just The Datafiles

The state of the system when I started was that there was a single, working instance of Oracle Database 9i. I proceeded to install Oracle 11g choosing to Install Software Only. Upon completion, ...
5
votes
2answers
490 views

Cardinality rule for bitmap indexes

The Oracle documentation includes the following advice: A bitmap index should be built on each of the foreign key columns of the fact table or tables In that reference, there is even a bitmap ...
0
votes
1answer
366 views

Where to put login.sql in Windows environment to configure SQL Plus?

I installed Oracle 10g XE on my Windows Server 2008 R2. Now I would like to configure SQL Plus to use login.sql for login settings. I created a login.sql file and put it into a C:\users\myname ...
1
vote
1answer
240 views

Force chain to start immediately after completion instead of on a timer

Is it possible to force an Oracle chain to restart immediately after it finishes executing, instead of on a timer? I have only found ways to do a temporal restart, which doesn't really work for me as ...