OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » Export error

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

Export error [message #177869]

Sat, 17 June 2006 04:07

gajini
Messages: 262
Registered: January 2006

Senior Member

while doing export,i got the following error,

. exporting synonyms
. exporting views
EXP-00056: ORACLE error 1555 encountered
ORA-01555: snapshot too old: rollback segment number 1 with name "_SYSSMU1$" too small
EXP-00000: Export terminated unsuccessfully

What i've to do complete the export successfully?

Is there anyway to do export with nologging option so that this error can be avoided?

Report message to a moderator

Re: Export error [message #177875 is a reply to message #177869]

Sat, 17 June 2006 05:03

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

>> Is there anyway to do export with nologging option so that this error can be avoided?
What makes you think so? You know the drill Smile

Search the forum for "ORA-01555: snapshot too old".
What is the Oracle version.
Are you using consistent=y.
Is there a lob column?

Report message to a moderator

Re: Export error [message #177881 is a reply to message #177869]

Sat, 17 June 2006 06:40

gajini
Messages: 262
Registered: January 2006

Senior Member

oracle version is 9i
yes i used consistent=y
and there is a table with CLOB column

Report message to a moderator

Re: Export error [message #177885 is a reply to message #177881]

Sat, 17 June 2006 07:15

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Try with consistent=n

Report message to a moderator

Re: Export error [message #179038 is a reply to message #177869]

Sat, 24 June 2006 02:22

gajini
Messages: 262
Registered: January 2006

Senior Member

Thanks Mahesh Rajendran,

If it's must to set consistent=y option,what other methods i've to follow to avoid this error?

Report message to a moderator

Re: Export error [message #179057 is a reply to message #179038]

Sat, 24 June 2006 05:58

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

>>what other methods i've to follow to avoid this error?
Did you ever try to search the forum?
Had you ever tried to run a search on ORA-01555, you might have found that either committing less or having a bigger RBS is the solution.

Report message to a moderator

Previous Topic:	database writers and async I/O
Next Topic:	only sys

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 12:46:35 CDT 2024