Database Software

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;ORA-02354;ORA-39826

3035820Mar 23 2016 — edited Apr 6 2016

Hi,

I found following errors in the export log file. Could you please comment on this issue?

ORA-31693: Table data object "WHSUSR"."TEMP_ATB_14423589" failed to load/unload and is being skipped due to error:

ORA-02354: error in exporting/importing data

ORA-39826: Direct path load of view or synonym (WHSUSR.TEMP_ATB_14423589) could not be resolved.

ORA-31693: Table data object "USR"."TEMP_ATB_14423219" failed to load/unload and is being skipped due to error:

ORA-02354: error in exporting/importing data

ORA-39826: Direct path load of view or synonym (USR.TEMP_ATB_14423219) could not be resolved.

my findings

SQL> select owner, object_name, object_type, last_ddl_time
from   dba_objects
where  owner = 'USR' and object_name in ('TEMP_ATB_14423589');  2    3

no rows selected

Oracle -- 11.2.0.3.0

OS -- AIX

This is prod

This is standalone DB

Regards,

Bala

Locked Post

New comments cannot be posted to this locked post.

Locked on May 4 2016

Added on Mar 23 2016

#database-key-features, #export-import-sql-loader-external-tables

9 comments

4,804 views