Re: consistent export gives ora-01466

From: Ronald <ronr_at_wxs.nl>
Date: Thu, 18 Mar 1999 20:20:13 +0100
Message-ID: <01HW.B317107D000B636B11C40B70@news.wxs.nl>

On Wed, 17 Mar 1999 20:49:36 +0100, benkrug_at_my-dejanews.com wrote (in message <7cp10d$vk6$1_at_nnrp1.dejanews.com>):
>
> 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:
>

snip
> 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

snip

You probably have been running with fixed_date in the future. During that period someone has created/altered a table.... Just drop and recreate those objects and retry.

--
Ronald.

---

http://home.wxs.nl/~ronr/RonR.html
The best way to accelerate your computer running windows is at 9.8 m/s^2 ! Received on Thu Mar 18 1999 - 13:20:13 CST