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

Thread: Ora-1466

  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