Question : I need to export and import data from a Oracle 9i to Oracle 12.2 database. This old app […]
Tag: oracle-9i
Is it possible to connect to Oracle 9i data source in SSIS?
Question : We’re doing a migration from Oracle 9i to SQL Server 2008. So I’m thinking of a way to […]
What is preventing ORA-00376 errors appearing in the alert log?
Question : An overnight hard drive failure had various side-effects, including leaving a single datafile needing recovery: SQL> select count(*) […]
inconsistent type after querying search_condition column in all_constraints table Oracle
Question : I’m trying to get the not null constraints in my tables, so I’m using the following sql request […]
Reason of poor performance of ANSI joins in Oracle 9i
Question : Please before flagging as duplicate, read the last paragraphs. In an Oracle 9i database this query runs in […]
Executing stored procedures in oracle inside a package using dbms_job
Question : I am trying to execute multiple stored procedures through package using DBMS_JOB. Even if the job is getting […]
Oracle get sql redo from log_history
Question : I run into a problem with a customer which had no proper backup. His last backup (meaning exp-dump) […]
How force specific table to not logging (for all DML)?
Question : We using Oracle 9i . I’m still learn about admin Oracle (I’m DBA but other vendor). We implement […]
ORA-00905: missing keyword when trying to create a synonym
Question : 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; […]
Oracle TNS Permission denied when creating database
Question : I hope you can help me. I need to restore an Oracle 9i (9.2.0.6.0) database on a Windows […]