Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> consistent export gives ora-01466
Hi all -
I have a database (7.3.4 on Solaris 2.6) that is running fine. BUT...
If I do a normal export, it's fine. If I try to do a consistent mode export (consistent=Y), I immediately (1/10 of a second) get:
Export: Release 7.3.4.0.1 - Production on Wed Mar 17 11:44:58 1999
Copyright (c) Oracle Corporation 1979, 1996. All rights reserved.
Connected to: Oracle7 Server Release 7.3.4.0.1 - Production
PL/SQL Release 2.3.4.0.0 - Production
Export done in US7ASCII character set
About to export the entire database ... . exporting tablespace definitions
EXP-00008: ORACLE error 1466 encountered ORA-01466: unable to read data - table definition has changed EXP-00000: Export terminated unsuccessfully
ORA-01466 means:
01466, 00000, "unable to read data - table definition has changed"
// *Cause: Query parsed after tbl (or index) change, and executed
// w/old snapshot
// *Action: commit (or rollback) transaction, and re-execute
Any suggestions or explanations?
Thanks,
Ben Krug
benkrug_at_yahoo.com
-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Wed Mar 17 1999 - 13:49:36 CST