Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-31693: ... failed to load/unload / ORA-02354: error in exporting/import

641067Sep 8 2009 — edited Sep 9 2009
Hi All,
I have these two errors on a LOG file from an import process.

ORA-31693: Table data object "GPORA"."GPY_REASADMI4341546" failed to load/unload
and is being skipped due to error:
ORA-02354: error in exporting/importing data
ORA-00942: table or view does not exist
ORA-31693: Table data object "GPORA"."GPY_RSOSADMI4341489" failed to load/unload
and is being skipped due to error:
ORA-02354: error in exporting/importing data
ORA-00942: table or view does not exist

I checked the dba_objects table and I couldn't find any of them. Why the import process is trying to collect them? And from where?

I will appreciate any help about this issue.

Thanks

Martin

P.S.:

SQL> select * from v$version;

BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi
PL/SQL Release 10.2.0.4.0 - Production
CORE 10.2.0.4.0 Production
TNS for HPUX: Version 10.2.0.4.0 - Production
NLSRTL Version 10.2.0.4.0 - Production
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 7 2009
Added on Sep 8 2009
8 comments
8,949 views