Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: export with consistent=y raise snapshot too old error.
"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