| exp error, please help, urgent [message #54422] |
Sun, 17 November 2002 05:04  |
shareef
Messages: 72
Registered: November 2002
|
Member |
|
|
i am geting an error while exp (export)the following error message is
Exp-00056: Oracle error 1555 encountered
ORA-01555:SanpShot too old:rollback segment number 2 with name "R01" too samll
Exp-00008:Oralce error 1555 encounter
ORA-01555:Snapshot too old:rollback segment number 5 with name "R02" too small
Exp-00008:Export terminated unsucessfully
Help, i will be great full to u.
|
|
|
|
|
|
|
|
| Re: exp error, please help, urgent [message #54438 is a reply to message #54422] |
Mon, 18 November 2002 11:17  |
Trifon Anguelov
Messages: 514
Registered: June 2002
|
Senior Member |
|
|
There are many fixes to this problem:
- increase the offending RBS;
- offline the small RBS's and create huge RBS just for the import, then offline the huge RBS and online the small RBS's
- set OPTIMAL=NULL to your RBS's
- use commit=y in your import parameter file.
If you want to read more about the reason and fixes of this ORA-01555 error Click Here
Hope that helps,
clio_usa
OCP - DBA
Visit our Web site
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
