Home » RDBMS Server » Server Utilities » ORA-39166 error (Oracle 10g ,windows 7)
ORA-39166 error [message #632416] Fri, 30 January 2015 02:13 Go to next message
hdba
Messages: 16
Registered: January 2015
Location: INDIA
Junior Member
i have one scenario

i am taking full backup using expdp in system schema

and from that i want to import one table to same schema

i tried using impdp

but giving following error

ORA-39002: invalid operation
ORA-39166: Object SYS_TEMP was not found.
  • Attachment: Capture.JPG
    (Size: 29.71KB, Downloaded 298 times)
Re: ORA-39166 error [message #632417 is a reply to message #632416] Fri, 30 January 2015 02:21 Go to previous messageGo to next message
Michel Cadot
Messages: 66437
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

1/ Post the command you execute
2/ Post your version with 4 decimals (in the title)
3/ Do NOT post an image to post simple text, just copy and paste the text inside your post but, before, Please read How to use [code] tags and make your code easier to read.
4/ Copy and paste the WHOLE session.

Re: ORA-39166 error [message #632419 is a reply to message #632417] Fri, 30 January 2015 04:54 Go to previous messageGo to next message
hdba
Messages: 16
Registered: January 2015
Location: INDIA
Junior Member
sir done with the practical thanx for guidence
Re: ORA-39166 error [message #632420 is a reply to message #632419] Fri, 30 January 2015 05:44 Go to previous messageGo to next message
hdba
Messages: 16
Registered: January 2015
Location: INDIA
Junior Member
sir one question when i delete the table and want back using expdp and impdp command its necessary to use command table_exists_action ?
if i am not use this command i coud not get my table data
and i specify this command with replace and append i get my data back.

is there any another method to get data back from table which is deleted?
Re: ORA-39166 error [message #632422 is a reply to message #632420] Fri, 30 January 2015 05:52 Go to previous message
Michel Cadot
Messages: 66437
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

If the table does not exist is it necessary to use "table_exists_action" parameter?
What is your opinion?

Please read the documentation.
Forum is to help people but not to replace the documentation.
You must first read it and then if you can't do something ask.
You take the time that others need to real problem which can't be solved just reading the documentation.

Previous Topic: EXPDP/IMPDP
Next Topic: ORA-31694: master table "SYSTEM"."SYS_IMPORT_SCHEMA_01" failed to load/unload
Goto Forum:
  


Current Time: Tue Jun 18 17:43:46 CDT 2019