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

learn more… | top users | synonyms

0
votes
1answer
35 views

How do i connect to remote oracle isql server using ODBC?

I have access to a public oracle iSQL*Plus Release 9.2.0.1.0 server (ex url : 1xx.1xx.1x.200/isqlplus). I need to set up an ODBC Data Source using this isql server. Please help me to setup an ODBC ...
2
votes
3answers
1k 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 ...
0
votes
0answers
10 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 ?
0
votes
2answers
3k 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....
2
votes
2answers
3k 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) ...
1
vote
1answer
135 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
69 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
52 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 ...
5
votes
3answers
1k views

Alternative for OPTIMIZER_FEATURES_ENABLE

I've installed a PHP driven application in a client's 9i server (Oracle9i Release 9.2.0.1.0 - 64bit Production). Certain queries are having an awful performance (it can use from 15 minutes to hours ...
1
vote
0answers
297 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
0answers
28 views

Decode html containing html entities in Oracle 9i

I'm trying to decode html containing html entities. I've tried utl_i18n.unescape_reference and it works great in Oracle 11g but I need to use the same functionality also in 9i where utl_i18n was not ...
0
votes
0answers
10 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....
2
votes
1answer
7k 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... ...
1
vote
3answers
3k 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?
0
votes
2answers
502 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.
4
votes
1answer
119 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 ...
0
votes
1answer
2k 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 ...
9
votes
0answers
238 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 ...
1
vote
0answers
546 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
0answers
395 views

Installing oracle 9i on windows 7

Is it possible to install oracle 9i on windows 7 32 bit? And where can i download the standalone oracle http server?
0
votes
2answers
274 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
115 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 "...
1
vote
1answer
1k 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
2answers
591 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
89 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
1answer
48 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
902 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
2answers
7k 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....
0
votes
0answers
91 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
11k 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
7k 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
22 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
111 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 ...
-1
votes
1answer
458 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?
0
votes
2answers
382 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 ...
0
votes
1answer
220 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: ...
1
vote
1answer
50 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
2k 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
754 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
118 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'); ...
0
votes
3answers
3k 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
2k 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
96 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 ...
3
votes
2answers
36k 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?
1
vote
0answers
719 views

FATAL ERROR IN TWO-TASK SERVER: error = 12571

oracle9i/windows2003,java application. oracle crash, alert log file contains sdh_ora_4636.trc which contains: *** 2012-05-05 13:53:32.000 *** SESSION ID:(100.50539) 2012-05-05 13:53:32.000 FATAL ...
3
votes
2answers
4k views

How do I limit Oracle to use specific ports?

I've built a new Oracle 9iR2 instance on a Windows 2003 32-bit cluster. Of course, it's version 9i for reasons out of my control. Several application servers connect to this instance, and each opens ...
2
votes
3answers
937 views

Oracle get sql redo from log_history

I run into a problem with a customer which had no proper backup. His last backup (meaning exp-dump) is from 1st Aug 2011. However he lost due to batch DELETE statements all data. My plan was now to ...