Home » RDBMS Server » Server Utilities » ORA-01466: unable to read data - table definition has changed (10g, 10.2.0.4, window server 2003)
ORA-01466: unable to read data - table definition has changed [message #581107] Tue, 02 April 2013 04:26 Go to next message
ishika_20
Messages: 339
Registered: December 2006
Location: delhi
Senior Member
Dear All,

My job is running at 2 am and that time no application user is connected. Even though, my exp utility shows error on 3 tables (2 are temp tables), everyday. But when expdp is running without error, which was scheduled at 4 am.

Below are the error -

Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set




. . exporting table                  DW_TEST_MOTOR
EXP-00056: ORACLE error 1466 encountered
ORA-01466: unable to read data - table definition has changed
. . exporting table                DW_TEST_MOTOR_1          0 rows exported
. . exporting table                    DW_TEST_TAC          0 rows exported
. . exporting table      DW_TMP_ACC_GENERAL_LEDGER          0 rows exported
. . exporting table       DW_TRF_AGG_SCHEDULE_DTLS       6174 rows exported
. . exporting table  DW_TRF_AGG_SCHEDULE_DTLS_0112          0 rows exported
. . exporting table  DW_TRF_AGG_SCHEDULE_DTLS_1612          0 rows exported
. . exporting table  DW_TRF_AGG_SCHEDULE_DTLS_2402          0 rows exported
. . exporting table            DW_TXT_FILE_GEN_LOG          0 rows exported
. . exporting table            DW_UIIC_GEN_GC_PROV          0 rows exported
. . exporting table          DW_UIIC_GEN_GC_PROV_1          0 rows exported
. . exporting table            DW_UNEARNED_PREMIUM          0 rows exported
. . exporting table        DW_UNEARNED_PREMIUM_LOG          0 rows exported
. . exporting table  DW_VEHICLE_DATA_NOT_FOUND_LOG          0 rows exported
. . exporting table                         EMP_11          0 rows exported
. . exporting table                        ERR_LOG          0 rows exported
. . exporting table            GC_CLM_GEN_INFO_TAC          0 rows exported
. . exporting table                  GC_CLM_OS_TAC          0 rows exported
. . exporting table     GC_CLM_PAYMENT_DETAILS_TAC          0 rows exported
. . exporting table     GC_CLM_PROVISION_INFO_TEMP
EXP-00056: ORACLE error 1466 encountered
ORA-01466: unable to read data - table definition has changed
. . exporting table   GC_CLM_PROVISION_INFO_TEMP_F
EXP-00056: ORACLE error 1466 encountered
ORA-01466: unable to read data - table definition has changed




Eager to know the solution for this.

Regards,
Ishika
Re: ORA-01466: unable to read data - table definition has changed [message #581112 is a reply to message #581107] Tue, 02 April 2013 04:54 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ORA-01466: 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


The tables have changed between the beginning of the export and the moment they are queried by the export.

Regards
Michel
Re: ORA-01466: unable to read data - table definition has changed [message #581114 is a reply to message #581112] Tue, 02 April 2013 05:08 Go to previous messageGo to next message
ishika_20
Messages: 339
Registered: December 2006
Location: delhi
Senior Member
Dear Michel,

Everyday, its showing same error on the same 3 tables. Can i query to database, who is doing the changes at that time?

Regards,
Ishika
Re: ORA-01466: unable to read data - table definition has changed [message #581115 is a reply to message #581114] Tue, 02 April 2013 05:16 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Does this help? (Says that you shouldn't use FLASHBACK_TIME parameter. Do you use it?)
Re: ORA-01466: unable to read data - table definition has changed [message #581116 is a reply to message #581115] Tue, 02 April 2013 05:22 Go to previous messageGo to next message
ishika_20
Messages: 339
Registered: December 2006
Location: delhi
Senior Member
Dear Littlefoot,

My expdp is having no problem. It's run successfully without any error.
Exp command doesn't contain Flashback_time parameter. My undo_retention value is 900.

Regards
Re: ORA-01466: unable to read data - table definition has changed [message #581118 is a reply to message #581116] Tue, 02 April 2013 05:55 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Does not use CONSISTENT=Y parameter.

Regards
Michel
Re: ORA-01466: unable to read data - table definition has changed [message #581124 is a reply to message #581118] Tue, 02 April 2013 06:21 Go to previous messageGo to next message
ishika_20
Messages: 339
Registered: December 2006
Location: delhi
Senior Member
Dear Michel,

You are right. We are using consistent=Y. Do we come to know by script, who is updating / modifying those tables at that time?

Regards
Ishika
Re: ORA-01466: unable to read data - table definition has changed [message #581132 is a reply to message #581124] Tue, 02 April 2013 06:49 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No unless you use Log Miner.
Now you can audit DDL on your tables for the next time:
AUDIT ALTER, AUDIT, COMMENT, FLASHBACK, GRANT, INDEX, LOCK, RENAME on mytable BY ACCESS;

Before, check the audit_trail parameter is set to DB.

Regards
Michel
Re: ORA-01466: unable to read data - table definition has changed [message #581182 is a reply to message #581132] Wed, 03 April 2013 00:48 Go to previous messageGo to next message
ishika_20
Messages: 339
Registered: December 2006
Location: delhi
Senior Member
Dear Michel,

Thank you very much...

I checked the Audit_trail parameter, it's value is NONE. So, we can make it true and use your provided command to know
the changes on tables.

Regards,
Ishika
Re: ORA-01466: unable to read data - table definition has changed [message #581184 is a reply to message #581182] Wed, 03 April 2013 01:09 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You have to restart the database after changing this parameter.
Note: Use DB, TRUE is obsolete.

Regards
Michel
Previous Topic: Dump file determination [merged 2 by jd]
Next Topic: Execution of Oracle 11g wrapped procedure gives ora-00900 error
Goto Forum:
  


Current Time: Thu Mar 28 17:40:04 CDT 2024