The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
1answer
834 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 ...
-1
votes
1answer
155 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?
6
votes
0answers
136 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
354 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 ...
0
votes
0answers
97 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
0answers
149 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 ...