OraFAQ Forum: Server Utilities » ORA-01555..during export

Home » RDBMS Server » Server Utilities » ORA-01555..during export (8.1.7.0.0.)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-01555..during export [message #391085]

Tue, 10 March 2009 21:56

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

Report message to a moderator

Re: ORA-01555..during export [message #391086 is a reply to message #391085]

Tue, 10 March 2009 22:09

BlackSwan
Messages: 26766
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

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

Report message to a moderator

Re: ORA-01555..during export [message #391361 is a reply to message #391085]

Wed, 11 March 2009 23:06

BlackSwan
Messages: 26766
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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 23 19:53:14 CST 2024