The oracle-9i tag has no wiki summary.
0
votes
0answers
21 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
18 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');
...
2
votes
1answer
185 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...
...
5
votes
0answers
97 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
3answers
367 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 ...
0
votes
0answers
63 views
Oracle form 10 g “RUN” Error
I have built a form from the employees table and trying to run it.But nothing is showing except for some text in the web browser with address being my local documents location instead of
...
2
votes
1answer
1k 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
64 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 ...
2
votes
2answers
5k 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
211 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
880 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
425 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 ...
5
votes
3answers
462 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 ...
