DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Ora-1466

Hybrid View

  1. #1
    Join Date
    Jan 2001

    Question Ora-1466

    Hi i'm using 9.2 under W2K and get this message when i use export utility evene when there is no activity in database.

    EXP-00056: ORACLE error 1466 encountered
    ORA-01466: unable to read data - table definition has changed
    . . exporting table ROUT_EXP 0 rows exported

    but i don't understand the oracle error book and also EXP-0056 doesn't exist in alarms list.
    thanks for help what should i do to get a complete backup
    A good bug is a fixed bug

  2. #2
    Join Date
    Aug 2002
    Colorado Springs
    Are you performing a consistent export? If do, the table ROUT_EXP may have a creation date in the future. This can also be a problem when the server is configured to a fixed_date in the past.

    You will have to drop and recreate the ROUT_EXP table if it does have a futuredate, but you can do this through a consistent=n export i believe.
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  3. #3
    Join Date
    Jan 2001


    thanks for that it works!

    but 2 questions
    how a table could be in the future? a modification done on this table since the beginning of the export?

    and what is the problem to do an unconsistant backup instead of a consistant? only unfinish transaction.

    A good bug is a fixed bug

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.