Episode #125 of the Stack Overflow podcast is here. We talk Tilde Club and mechanical keyboards. Listen now

Questions tagged [oracle-9i]

Oracle Database 9i. Please also tag oracle for search purposes.

Filter by
Sorted by
Tagged with
0
votes
2answers
27 views

Oracle 9i to 12c Replication

I have an old Oracle Forms solution that accesses a 9i database and I have been asked if it's possible to replicate to an Oracle 12c database server, with the intention of using Fusion until a new ...
0
votes
2answers
476 views

Oracle - Extract user DDL for migration

I need to export and import data from a Oracle 9i to Oracle 12.2 database. This old app doesn't log in as one privileged user - it logs in for each user. I have hundreds of users with nothing but ...
3
votes
2answers
672 views

Why are backups of a previous incarnation marked obsolete without regard to redundancy?

After incomplete recovery and opening a 9i database with resetlogs we ran a full backup which completed successfully. The backup includes a command to delete obsolete backups after it finishes: ...
1
vote
1answer
589 views

Restoring RMAN backup in Oracle 9i to another server

I'm trying to do a restore of a cold backup made with rman in oracle 9i, the question is that I managed to successfully restore the pfile and the controlfile but when I try to give: RMAN> restore ...
1
vote
1answer
3k views

Oracle 12c Client Compatible with 9i Server?

I'm developing on a new .NET application that needs to read/write data from an Oracle 9i database. I've got it working with ODAC 11.2.0.4 which comes with Instant Client 11.2. I had selected this ...
2
votes
1answer
215 views

Does REDUNDANCY retention policy guarantee PITR from the earliest backup?

From ORACLE-BASE: CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS; CONFIGURE RETENTION POLICY TO REDUNDANCY 5; … The recovery window is used to make sure that there are always ...
0
votes
1answer
4k views

How to copy a schema with another name but with same data?

I want to copy all the objects of Scott schema to another schema. I can not understand what the code should be. Like bellow one? create user scott1 identified by tiger1;
0
votes
1answer
724 views

Executing stored procedures in oracle inside a package using dbms_job

I am trying to execute multiple stored procedures through package using DBMS_JOB. Even if the job is getting submitted and is showing in USER_JOBS its not getting started for some reason. I have tried ...
0
votes
1answer
63 views

Magic number in optimal redo size query in Oracle 9i

I got this query from this blog post to determine the optimal online redo log size in pre-Oracle10 databases. I'm stuck with Oracle 9i for that particular instannce for reasons beyond my pay grade ...
4
votes
1answer
575 views

What is preventing ORA-00376 errors appearing in the alert log?

An overnight hard drive failure had various side-effects, including leaving a single datafile needing recovery: SQL> select count(*) from v$datafile where status='RECOVER'; COUNT(*) ---------- ...
0
votes
0answers
15 views

Any way to view the list of commited transactions in a period of time?

I want to view the list of commited transactions to my oracle database that users have issued today for exemple. Is that possible ?
1
vote
1answer
2k views

Oracle TNS Permission denied when creating database

I hope you can help me. I need to restore an Oracle 9i (9.2.0.6.0) database on a Windows Server 2003 R2 x64 from a cold backup. I managed to get the 9i installer and the version patch (since I was ...
0
votes
1answer
94 views

oracle conversion variable value to sequence name

please can someone help me? I want to call a sequence from a variable (seq_x) as in the code but I cannot. if :op.qt is not null then select BATCH_X_SEQ into seq_x from kbatchseq where ...
-2
votes
1answer
208 views

Display Error getting while installing oracle 9i on centos 64 bit

I want to install Oracle 9i on Centos using only command line. I tried to run installer using command line by silent but getting error as below. [oracle@XXXXX]$ ./runInstaller -silent DISPLAY not ...
3
votes
0answers
1k views

Querying Oracle via Linked Server crashes SQL Server

A bit of an odd one this. I have a couple of instances of SQL Server 2012, SP1, one being Dev Edition and the other Standard Edition and both are VMs running under VMWare. When executing a Stored ...
0
votes
1answer
90 views

Reason of poor performance of ANSI joins in Oracle 9i

Please before flagging as duplicate, read the last paragraphs. In an Oracle 9i database this query runs in 0.18 seconds: select count(*) from dba_synonyms s,dba_objects t where s....
5
votes
1answer
585 views

Oracle Audit: Why Logons are less than 0.1% of logoffs?

I see the following quantities of logins versus logoffs vs logoffs by cleanup in a database: SQL> select action_name, count(*) qty from Dba_audit_session group by action_name order by 1; 2 3 ...
2
votes
0answers
2k views

TNS-12500: TNS:listener failed to start a dedicated server process Oracle9i Database on Windows 2003 64x server

My client wants to move his database from Windows 2000 server to Windows 2003 Enterprise Edition 64x server. I have created the Windows servers in VMware and installed the Oracle 9i databases on it. ...
0
votes
1answer
8k views

Oracle audit: Only 'SESSION REC' in ACTION_NAME column

I was asked to generate a report of operations performed on certain Oracle 9i tables in a given period of time. When I query the DBA_AUDIT_TRAIL table I only get SESSION REC in the ACTION_NAME ...
0
votes
3answers
773 views

Is it possible to connect to Oracle 9i data source in SSIS?

We're doing a migration from Oracle 9i to SQL Server 2008. So I'm thinking of a way to move the data from Oracle and I thought about SSIS. I'm new to this Microsoft's technology and I would like to ...
1
vote
1answer
767 views

Installation of Oracle 9.2.4.0 stalled

I'm installing Oracle 9.2.4.0 (I know, I know...) on Red Hat Enterprise Linux AS release 4 (Nahant Update 8) 64 bits using an Oracle 32 bit installer. It appears to be stalled or hanged at 17% while "...
2
votes
3answers
15k views

exporting DDL of all views Oracle

How can I go about exporting DDL of all my schema views in single .sql file ? I've read there is a function DBMS_METADATA.GET_DDL But I can't figure out how to use it for my case. I know how to ...
1
vote
2answers
5k views

Script for listing tables having no primary key oracle 9i [closed]

I'm looking for a script to find tables within my database that have no primary key.
1
vote
1answer
5k views

num_rows in dba_tables not reflecting the real number of rows in tables Oracle 9i

I'm querying dba_tables in order to get a listing of tables and their rowcount with following sql request : select * from dba_tables where owner='dbSID'; But I notice that even for some non empty ...
0
votes
1answer
239 views

Drastic change in query speed when changing from Oracle 9i to ANSI outer join syntax

I am working on simplifying a query originally written for Oracle 9i. In the process I changed the join syntax from the Oracle 9i syntax to ANSI. The names of the tables and columns have been changed ...
0
votes
2answers
1k views

inconsistent type after querying search_condition column in all_constraints table Oracle

I'm trying to get the not null constraints in my tables, so I'm using the following sql request : select * from all_constraints where owner='userx' and constraint_type='C' and ...
0
votes
1answer
124 views

equivalent of oracle sql administration query in SQL Server 2008

I'm new to SQL Server administration, and I would like to get the equivalent of this Oracle 9i administration query : select object_type,count(*) as number from all_objects where owner='ownerSID' ...
2
votes
2answers
3k views

Restoring a tablespace to a different database

Any ideas as to how we can re-create a tablespace on a different server? We have a cold backup, so we can copy the datafiles to the target server. Can we just create a new instance on the target ...
1
vote
0answers
286 views

ora-03113 end-of-file on communication channel on creation of database

I'm trying to create an oracle database in my local machine via Database Configuration Assistant tool. At the last step, when I lunch the creation, I'm having this issue of : ORA-03113 end-of-file ...
0
votes
1answer
35k views

Oracle Triggers - Before Update and Before Insert - Separate or Combined?

I'm running Oracle DB 9i. I have a table with various constraints to ensure data integrity. In addition to the constraints, I have triggers on BEFORE INSERT and BEFORE UPDATE to ensure that ...
1
vote
1answer
11k views

ORA-00933: SQL command not properly ended

I have created a database link to a remote database, MIGRERDOSSIER.US.ORACLE.COM, then I use it to insert records in a table in a local database. Here is the request I am trying to execute: insert ...
0
votes
0answers
25 views

Is it possible to use two parameter files for same export command Oracle 9i

I want to export my database with the export exp command using a parameter file. My constraint is that there is some tables I want to export without data, others with. I'm having the idea of using ...
0
votes
0answers
213 views

Oracle 9i Low performance on Windows Server Enterprise 2003

I'm facing some problems with performance with my Oracle database running on a virtual machine with Microsoft Windows Server Enterprise 2003 with 8GB RAM. It works pretty well after the database is ...
0
votes
2answers
4k views

Connect to Oracle DB 9i using SSH TUNNEL via putty [closed]

I am trying to connect to an Oracle database behind NAT. Therefore I create an ssh tunnel using putty. This is the network information: global IP example: 122.54.34.12 LAN IP example: 192.168.3.103 ...
1
vote
4answers
9k views

Which SQL Developer Version will be compatible with Oracle 9i

My Company is using Oracle 9i. I want to connect to the database. I'm planning to use SQL Developer. Which version will be compatible Oracle 9i?
-1
votes
1answer
1k views

Inserting dates before year 1950 in Oracle

How can I insert date which is before 1950? update up_sif.tb_person set dateB =to_date('18.10.1949','DD.MM.YYYY') where ID = '123345'; It keeps update with date 18.19.2049. Any ideas?
-1
votes
1answer
44 views

Is there any way to know all the tables(and/or views, triggers, functions) present in the Oracle 9i database?

I want to know this because I forgot the name of the table I created. i am using Oracle 9i.
2
votes
2answers
14k views

Oracle: Truncate large table takes forever

Problem I'm truncating a very large table ( 210+ million rows ). It's been hours since it started and I have no idea when it will be done. There're several tables like that, that I want to truncate. ...
3
votes
2answers
4k views

Import Oracle schema data without losing modifications of stored procedures

I have this scenario: One huge (thousands of tables), complex, Oracle 8 production database, One huge (thousands of tables), complex, Oracle 9 development database, (same structure as production) ...
0
votes
1answer
294 views

Error wile debugging (signature buffer too small)

I'm trying to debug a package in SQL Developer, but I keep getting error: ORA-00600: internal error code, arguments: [15419], [severe error during PL/SQL execution], [], [], [], [], [], [] ORA-06544: ...
0
votes
2answers
769 views

How force specific table to not logging (for all DML)?

We using Oracle 9i . I'm still learn about admin Oracle (I'm DBA but other vendor). We implement manually at our databases a trigger over LOGON and LOGOFF to save some information about our users ...
1
vote
1answer
52 views

Updating TNS Entry across multiple terminals

Is there anyway I could update Host in a specific TNS entry, by way of an Batch File(sqlplus via command prompt)? A change in the IP address have been raised and we need to update the TNS across ...
0
votes
3answers
4k views

Sync two Oracle production server databases

I have an Oracle database that runs a 6 hours batch job every day. This process slows down performance during the 6 hours timeframe. Is there any method that I could use to build another server that ...
0
votes
0answers
1k views

Error PLS-00436: implementation restriction: cannot reference fields of BULK In-BIND table of records

i've problem here. i wanna create a Stored procedure like below, but i encountered error PLS-00436: implementation restriction: cannot reference fields of BULK In-BIND table of records. create or ...
1
vote
1answer
125 views

double date conversion when adding partition

I want to create a procedure that adds new partition in a table partitioned by time. For this purpose I use following commands: s_until := to_char(sysdate+1,' SYYYY-MM-DD HH24:MI:SS'); ...
3
votes
1answer
16k views

Why do I get an incorrect error “ORA-01775: looping chain of synonyms”, when the base table does not existing?

I use Informatica for managing some ETL process that load data into an Oracle 9i Data-warehouse. Today I got the below error in the Informatica session logs: Message: Database driver error... ...
0
votes
3answers
5k views

ORA-00905: missing keyword when trying to create a synonym

I have a problem when I try to create a synonym like this: CREATE SYNONYM B2H.BILLING_USER_ACTIVITY@PACOMNET FOR B2H.BILLING_USER_ACTIVITY@PACOMNET.US.ORACLE.COM; Why does this happen and how can ...
3
votes
1answer
3k views

How do I have RMAN treat my restored data files like they are originals?

I am planning a migration for this ancient-but-critical Oracle database from one Windows Server 2003 cluster to another. The database has many data files and they are all getting new paths on the ...
2
votes
1answer
115 views

Why does connecting to a database use tempspace?

Earlier today we had a problem logging into a database that had just been created automatically. When on the actual box (Linux) sqlplus schema/pw, i.e. a local connection, was fine, though, it was ...
4
votes
2answers
70k views

What do the columns in SYS.USER$ represent?

In the SYS.USER$ view, what do the CTIME, PTIME, and LTIME columns represent? Where can I find Oracle's documentation for this and other system views?