EXP-00056: ORACLE error 6502 encountered

I got ” EXP-00056: ORACLE error 6502 encountered ”  error in Oracle database.

EXP-00056: ORACLE error 6502 encountered

Details of error are as follows.

You started an export (exp) with parameter CONSISTENT=Y and this failed with errors:

EXP-00056: ORACLE error 1466 encountered
ORA-01466: Unable to read data - table definition has changed

ORACLE error 1466 encountered

This EXP-00056 error is related to the object creation date is in the future. There are objects inside the database that have a object creation timestamp that is greater than the current system time. Probable this happened by once setting a wrong system date/time.

To find out the affected objects run the following command:

select to_char (created, 'dd-mm-yyyy hh24:mi:ss') "CREATION TIME",
       object_name, object_type, object_id
from   dba_objects
where  created > sysdate;

CREATION TIME       OBJECT_NAME     OBJECT_TYPE    OBJECT_ID
------------------- --------------- ------------- ----------
22-05-2006 10:55:35 PK_T1C1         INDEX              25490
22-05-2006 10:56:10 PK_T2C1         INDEX              25491
22-05-2006 10:56:10 PK_T3C1         INDEX              25492
22-05-2006 10:56:10 PK_T4C1         INDEX              25493
22-05-2006 10:56:56 PK_T5           INDEX              25494
22-05-2006 10:49:55 TAB1            TABLE              25485
22-05-2006 10:51:13 TAB2            TABLE              25486
22-05-2006 10:51:36 TAB3            TABLE              25487
22-05-2006 10:51:57 TAB4            TABLE              25488
22-05-2001 10:53:45 TAB5            TABLE              25489

The CONSISTENT=YES parameter is used to ensure that the data seen by Export is consistent to a single point in time and doesn’t change during the execution of the export command.

If the object creation timestamp is still greater than the system time, then export the object’s data without using the CONSISTENT=YES parameter, drop the object, recreate the object so it has a new creation timestamp, import the object’s data, and resume work.

Do you want to learn Oracle Database for Beginners, then read the following articles.