| urgent help required [message #103794] |
Tue, 16 March 2004 05:39 |
Kaushik Choudhury
Messages: 2
Registered: March 2004
|
Junior Member |
|
|
Hi,
Please help. I have a script which inserts some records from data tables into temporary tables, and then using join statements on the temporary tables, the data tables are deleted(this is because the data tables have some complex referential integrity issues and is cumbersome to delete without the temporary tables). But the problem is the script hangs after inserting into the temporary tables and after executing the first delete statement. The number of records here are large(1-2million) and for smaller tables the whole script runs fine. We have disabled redo log, and decreased the undo time to 3 sec from 3 hours. Still, it seems the system runs out of tablespace. Any suggestions what the problem could be?????
P.S.-I am using oracle 9i
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
