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

Home -> Community -> Usenet -> c.d.o.server -> Re: export with consistent=y raise snapshot too old error.

Re: export with consistent=y raise snapshot too old error.

From: yoke wang <cnwy_at_263.net>
Date: 20 Apr 2005 17:34:16 -0700
Message-ID: <42c18ceb.0504201634.192a95c1@posting.google.com>


"casz69_at_gmail.com" <casz69_at_gmail.com> wrote in message news:<1114015733.745134.145650_at_z14g2000cwz.googlegroups.com>...
> I think you need to increase parameter undo_retention to the number of
> seconds that run export. If you do this maybe, you need to increase
> undots too.

Oracle9204.
The relative parameters:
undo_retention=10800(default value)
undo_retention is larger than the seconds run export(only 1800 seconds),so I think the default value is enough. undo_management=auto(default value)
I think oracle should increase the size of datafile in this mode. undo_tablespace=undotbs1
undo_suppress_errors=false

I think I must miss something. Received on Wed Apr 20 2005 - 19:34:16 CDT

Original text of this message

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