Home » RDBMS Server » Server Utilities » ORA-01555..during export (8.1.7.0.0.)
ORA-01555..during export [message #391085] Tue, 10 March 2009 21:56 Go to next message
ajaysharma2907
Messages: 14
Registered: June 2008
Location: Delhi
Junior Member

Dear Sir,


Please review my error during export of my schema.
+++++++++++++++++++++++++++++++++++++++++++++++++
EXP-00056: ORACLE error 1555 encountered
ORA-01555: snapshot too old: rollback segment number 2 with name "RBS1" too small
. . exporting table SAL_LNCD_P.................................
++++++++++++++++++++++++++++++++++++++++++++++++++

Sir as the rollback segments created in 8i by dbca are small ,i created another bigger size RBS and made them online.

But still i face the same problem.
Is there any way to resize these already craeted rollback segments.becuase i cud not be able to resize them or drop them.

what should be the solution.

please help.

regards,
ajay


Re: ORA-01555..during export [message #391086 is a reply to message #391085] Tue, 10 March 2009 22:09 Go to previous messageGo to next message
BlackSwan
Messages: 25038
Registered: January 2009
Location: SoCal
Senior Member
>Please review my error during export of my schema.
Please post complete command line doing the export.

The ORA-01555 is not caused by the export, but by different session doing lots of DML & COMMIT.

Stop this other process while export is running or increase size of Roll Back Segments.

V8.1.7 is very old & should be replaced ASAP.

This thread should be moved to Utilities sub-forum.

[Updated on: Tue, 10 March 2009 22:10]

Report message to a moderator

Re: ORA-01555..during export [message #391360 is a reply to message #391085] Wed, 11 March 2009 22:57 Go to previous messageGo to next message
ajaysharma2907
Messages: 14
Registered: June 2008
Location: Delhi
Junior Member

Dear Sir,

I am Planning the migration from 8i to 9.2,
but for my knowledge sake, i wanted to know how can the "size" of the automatically created rollback segments(RBS0,RBS1,RBS2..RBS6) be altered.

Regards,
Ajay Sharma
Re: ORA-01555..during export [message #391361 is a reply to message #391085] Wed, 11 March 2009 23:06 Go to previous message
BlackSwan
Messages: 25038
Registered: January 2009
Location: SoCal
Senior Member
>I am Planning the migration from 8i to 9.2,
Upgrading from 1 obsoleted version to another obsoleted version. WHY?


>but for my knowledge sake, i wanted to know how can the "size" of the automatically created rollback segments(RBS0,RBS1,RBS2..RBS6) be altered.
I suggest when you get to any version V9.2 or newer, that you discard OLD style ROLLBACK SEGEMENTS (RBS*) & start using "newer" UNDO segments.

When all else fails, you should Read The Fine Manuals found at http://tahiti.oracle.com


Previous Topic: dp import with tablespaces
Next Topic: IMP Datapump error
Goto Forum:
  


Current Time: Mon Dec 05 12:51:11 CST 2016

Total time taken to generate the page: 0.05231 seconds