EXP-00008 ORA-01410



Connected to: Oracle9i Enterprise Edition Release 9.2.0.6.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.6.0 - Production
Export done in US7ASCII character set and AL16UTF16 NCHAR character set
server uses WE8ISO8859P1 character set (possible charset conversion)

About to export the entire database ...
. exporting tablespace definitions
. . exporting table          ORG_SUBSCRIBER_MASTER          0 rows exported
. . exporting table               OS_BILLDATE_STAT       9571 rows exported
. . exporting table                        OS_LIST
EXP-00008: ORACLE error 1410 encountered
ORA-01410: invalid ROWID
. . exporting table                 OS_LIST_ERRORS     894001 rows exported
. . exporting table             OS_LIST_ERRORS_PTS      34944 rows exported
 



ALTER TABLE OS_LIST MOVE TABLESPACE TRADATA1;

And then rebuild all the indexes on the table OS_LIST

This solved the problem
 

Post a Comment

And that's all there is to it!

If anyone has any other questions or requests for future How To posts, you can either ask them in the comments or email me. Please don't feel shy at all!

I'm certainly not an expert, but I'll try my hardest to explain what I do know and research what I don't know.

Previous Post Next Post