Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Pause or suspend an import

626981Mar 18 2008 — edited Mar 18 2008
Hi,
I'm doing a huge import of about 110 gb .
I am not sure but i suppose there is a way where we can suspend or pause the import for a specified amount of time, in case the tablespace gets full

I need to know this because while doing an import this did happen with me and at the end of a table import of about 250 million records the import failed because all the datafiles in the tablespace where full.
The log showed me that unable to extend size and terminated the import.
If i had a way where the import would paused or suspended when the tablespace got full, instead of terminating, then i could have saved the whole week of my time from going in vain..
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 15 2008
Added on Mar 18 2008
20 comments
5,415 views