CODEWITHSUNDEEP
oracle-databaseimpdpexpdpimp
user18224164
user18224164

Reputation: 3

ORA-39166: Object owner.table_name was not found or could not be exported or imported

im contacting you please because i have a problems with import/export schema. first step i exported the Schema1 to another database using this script :

cat imp_Schema_AAAA.par

userid='/ as sysdba'

directory=MIGEXPORT

dumpfile=Schema_Schema1_%U.dmp

logfile=impdp_Schema_Schema1.log

TRACE=1ff0300

METRICS=Y

REMAP_SCHEMA=Schema1:Schema2

logtime=all

the export/import passed successfuly but when i compared the schemas tables on the two databases i fount that the number on destination database less than source database. so i tried to export missing tables by expdp/impdp and exp/imp, but i have the below error: ORA-39166: Object shema1.table1 was not found or could not be exported or imported. ORA-39166: Object shema1.table2 was not found or could not be exported or imported. ORA-31655: no data or metadata objects selected for job FYI: i checked on the source db these tables exist

i need you help please

Thank You

Upvotes: 0

Views: 2132

Answers (1)

Londi Tangu
Londi Tangu

Reputation: 1

What Oracle version is this? Please verify DDL of the tables that fail to export/import. Do they contain sharing=none in the DDL?

What's the output when you run the following?

SQL> COL BASE_OBJ.OWNER_NAME FOR A40

SELECT KU$.BASE_OBJ.OWNER_NAME, count(*)
FROM SYS.KU$_TABLE_OBJNUM_VIEW KU$
WHERE (BITAND(KU$.SCHEMA_OBJ.FLAGS,134217728)=134217728)
GROUP BY KU$.BASE_OBJ.OWNER_NAME
ORDER BY 1;


SQL> select APP_STATUS from fed$apps where APP_NAME = '_CURRENT_STATE';
SQL> select count(*) from obj$ where flags=134217728;

Upvotes: 0

Related Questions