Export Problem [message #71363] |
Tue, 22 October 2002 10:08 |
Giri Gajjela
Messages: 14 Registered: June 2002
|
Junior Member |
|
|
Hi,
I have a huge table which takes around 5-7 hrs to export this table. And while exporting this table, after some time its giving ORA-1555 snapshot too old error.
Oracle Ver is 7.3. I cannot afford to do lot of experiments on this, because its very urgent and on top of it, its taking a lot of time.
Is there any way of doing this without getting this error. Do increasing the SORT_AREA, and direct exporting help me?
Thanks & Regards,
Giri Gajjela
|
|
|
|
Re: Export Problem [message #71435 is a reply to message #71363] |
Thu, 31 October 2002 18:23 |
Trifon Anguelov
Messages: 514 Registered: June 2002
|
Senior Member |
|
|
Few things to do here:
1. Use commit=y in your import parameter file. That will eliminate the need for huge rollback segment, since you will be commiting more frequently.
2. Create large rollback segments, and offline the small ones during the import.
3. Setup the OPTIMAL parameter to NULL for the large rollback segmnents to avoid shrinking to the OPTIMAL size.
SORT_AREA_SIZE doesn't affect the rollback segments. Don't bother.
Hope that helps,
clio_usa
OCP - DBA
Visit our Web site
|
|
|