Exp-00008 Oracle Error 1555 Encountered
05 Member No.: 3,345 How to confirm that there is sufficient undo segment space to avoid the export session getting the exp 00008 oracle error 904 encountered ORA-1555 Snapshot too old error. I am getting the below error while taking the export: exp 00008 oracle error 6552 encountered EXP-00008: ORACLE error 1555 encountered ORA-01555: snapshot too old: rollback segment number 3 with name "_SYSSMU3$" too small EXP-00056: ORACLE error 1555 encountered ORA-01555: snapshot too old: rollback segment number 3 with name "_SYSSMU3$" too small EXP-00000: Export terminated unsuccessfully I am using oracle 10g. dave View Member Profile Dec 21 2006, 03:25 AM Post #2 Advanced Member Group: Members Posts: 5,208 Joined: 8-October 04 Member No.: 785 configure undo_retention properly murtuja_oracle View Member Profile Dec 21 2006, 06:56 AM Post #3 Newbie Group: Members Posts: 2 Joined: 1-December 05 Member No.: 3,345 Sir,Is there any way to check whether current UNDO_RETENTION is not enough for DB.I am just curious to know.How I can decide proper UNDO_RETENTION value that will privent me from Ora-1555. dave View Member Profile Dec 21 2006, 07:06 AM Post #4 Advanced Member Group: Members Posts: 5,208 Joined: 8-October 04 Member No.: 785 you are getting a 1555, therefore it is not enoughyou need to set it to longer than your longest running query burleson View Member Profile Dec 21 2006, 11:28 AM Post #5 Advanced Member Group: Members Posts: 13,227 Joined: 26-January 04 Member No.: 13 Hi Murtuja,>> Is there any way to check whether current UNDO_RETENTION is not enoughYes, check here:http://www.dba-oracle.com/t_ora_01555_snapshot_old.htmYou can use the 10g UNDO advisor to find out how large this tablespace should be given a desired UNDO retention, or look online for some scripts…just Google for: oracle undo sizeSee here:http://www.dba-oracle.com/t_undo_tablespace_size_shrink.htm -------------------- Hope this helps. . . Donald K. BurlesonOracle Press authorAuthor of Oracle Tuning: The Definitive Reference « Next Oldest · Oracle Forum · Next Newest » 1 User(s) are reading this topic (1 Guests and 0 Anonymous Users) 0 Members: Forum Home Search Help Oracle |-- Oracle Forum Display Mode: Standard · Switch to: Linear+ · Switch to: Outline Track this topic · Email this topic · Print this topic · Subscribe to this forum Lo-Fi Version Time is now: 15th October 2016 - 04:53 AM Powered By Invision IPB © 2016 IPS, Inc.
Wed, 15 June 2005 10:45 oskarthik Messages: 26Registered: March 2005 Junior Member hi, Please advise as to what you think may be the problem here. The exports have failed many times showing this error. EXP-00008: ORACLE error 1555 encountered ORA-01555: snapshot too old: rollback segment number 4 with name "RBS3" too small EXP-00000: Export terminated unsuccessfully thanks, karthik Report message to a moderator Re: ora-01555 during export. [message #123929 is a reply to message #123926] Wed, 15 June 2005 10:59 macdba Messages: 27Registered: May 2005 Location: US Junior Member Hi, Pls check http://dbaforums.org/oracle/index.php?showtopic=5356 whether u have given consistent=Y while exporting. rgds --Mak Report message to a moderator Re: ora-01555 during export. [message #123932 is a reply to message #123926] Wed, 15 June 2005 11:05 Mahesh Rajendran Messages: 10672Registered: March 2002 Location: oracleDocoVille Senior MemberAccount Moderator Seems the other sessions are updating the database during your export. So use CONSISTENT=N ( which is default). Dont http://www.orafaq.com/forum/t/47471/0/ specify CONSISTENT=Y. Else Increase your RBS(in 8i) and look into undo Management in 9i. There is a long running transaction that needs more undo space than the available one. Report message to a moderator Re: ora-01555 during export. [message #123991 is a reply to message #123932] Wed, 15 June 2005 16:11 oskarthik Messages: 26Registered: March 2005 Junior Member mahesh, here there are about 8 datafiles in the RBS tablespace and about 6 rollback segment online. here there is no any parameter related to undo when i prompted "show parameter undo". so what to do to resolve..? oracle-->9i os-->linux karthik Report message to a moderator Re: ora-01555 during export. [message #123996 is a reply to message #123991] Wed, 15 June 2005 16:25 Mahesh Rajendran Messages: 10672Registered: March 2002 Location: oracleDocoVille Senior MemberAccount Moderator are you using Rollback segments intead of Undo tablespace in 9i!!? Confirm this first. Your UNDO RETENTION or RBS is too small. Increase it!. Switch to Undo Tablespaces and increase the undo_retention scott@9i > show parameter undo NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ undo_management string AUTO undo_retention integer 0 undo_supp