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.

Oracle Tutorial | Oracle Database Tutorials for Beginners ( Junior Oracle DBA )

 

 169 views last month,  4 views today

About Mehmet Salih Deveci

I am Founder of SysDBASoft IT and IT Tutorial and Certified Expert about Oracle & SQL Server database, Goldengate, Exadata Machine, Oracle Database Appliance administrator with 10+years experience.I have OCA, OCP, OCE RAC Expert Certificates I have worked 100+ Banking, Insurance, Finance, Telco and etc. clients as a Consultant, Insource or Outsource.I have done 200+ Operations in this clients such as Exadata Installation & PoC & Migration & Upgrade, Oracle & SQL Server Database Upgrade, Oracle RAC Installation, SQL Server AlwaysOn Installation, Database Migration, Disaster Recovery, Backup Restore, Performance Tuning, Periodic Healthchecks.I have done 2000+ Table replication with Goldengate or SQL Server Replication tool for DWH Databases in many clients.If you need Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS Consultancy and Training you can send my email adress [email protected].-                                                                                                                                                                                                                                                 -Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS ve linux Danışmanlık ve Eğitim için  [email protected] a mail atabilirsiniz.

Leave a Reply