tag:blogger.com,1999:blog-2447545383063131991.post7691771122555720729..comments2024-03-16T04:44:36.904+01:00Comments on Arjan's Oracle knowledge: ORA-39165: Schema TMP was not found and ORA-31655: no data or metadata objects selected for jobArjan Gooshttp://www.blogger.com/profile/04234695404025210237noreply@blogger.comBlogger1125tag:blogger.com,1999:blog-2447545383063131991.post-77811959861940009502009-11-19T17:53:56.219+01:002009-11-19T17:53:56.219+01:00ORA-39165: Schema [TMP] was not found. can also ca...ORA-39165: Schema [TMP] was not found. can also can also come for without option "content=DATA_ONLY" .. <br /><br />didn't worked in my case.<br /><br />expdp USERID=system DUMPFILE=xxx.sql LOGFILE=xxx.log SCHEMAS=XXX<br /><br />impdp system DUMPFILE=xxx.sql LOGFILE=xxxx.log schemas=YYY remap_schema=XXX:YYY table_exists_action=REPLACE<br /><br />let me know if have any idea..yumhttps://www.blogger.com/profile/05791647606471977444noreply@blogger.com