Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Ora-01555 error from a consistent export

Ora-01555 error from a consistent export

From: Schauss, Peter <peter.schauss_at_ngc.com>
Date: Tue, 10 Jul 2007 11:36:19 -0400
Message-ID: <6591F529444E9748A546718B3D1A670108FD6C80@xcgv2605.northgrum.com>


(Oracle 8.1.7.4/SunOs 5.9)

A full export (consistent=y) from time to time gives me an Ora-01555. I have read two documents in Metalink(10630.1 and 1011108.6), both of which seem to be telling me to use a larger rollback segmnet. Now I have two questions:

  1. Why doesn't the rollback segment grow when it runs out of space? The segment listed in the error message currently has only 12 extents when the maximum number was set to 32765. The db_block size is 16k which, based on Metalink doc 1011108.6, should limit the number of extents to about 1000. The rollback tablespace has about 1 gb of free space. All of this would seem to suggest that the rollback segment shown in the error message had room to grow.
  2. Assuming that I need to assign a specific, large rollback segment to my export job, how do I do that?

Thanks,
Peter Schauss

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Jul 10 2007 - 10:36:19 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US