Now I am using all RBs present in LMT and DMT. But now exp with the same parameters hangs at big tables (around 20 million rows) for more than six hours. An earlier export was successful with six RBs and tablespace size 500m. Now I am using 12 RBs and size 2 GB. The earlier exp duration was two to three hours (running in cron). Now I am not able to take exp either through cron or manually. After 24 hours the exp was not completed. When I start exp initially it can be seen using the top command but later it disappears, but it can be traced using ps -ef. I tried all options. How can I proceed?
You do have a few options in Oracle 8i. One, create more rollback segments and make them larger as well. That can eliminate your ORA-1555 errors, but depending on your database changes, you may still hit these errors. If you were using Oracle 9i or 10g, then using Automated Undo would help greatly. Unfortunately, that is not an option for you.
Another option is to perform your export when you can guarantee that the database is not undergoing changes. Start your database in restricted mode and then perform the export as a user who can sign on to the database (like SYS or SYSTEM) when in restricted mode.
Dig Deeper on Oracle database design and architecture
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.