OraFAQ Forum: Server Utilities

Home » RDBMS Server » Server Utilities » ORA-39166 error (Oracle 10g ,windows 7)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-39166 error [message #632416]

Fri, 30 January 2015 02:13

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 1865 times)

Report message to a moderator

Re: ORA-39166 error [message #632417 is a reply to message #632416]

Fri, 30 January 2015 02:21

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

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.

Report message to a moderator

Re: ORA-39166 error [message #632419 is a reply to message #632417]

Fri, 30 January 2015 04:54

hdba
Messages: 16
Registered: January 2015
Location: INDIA

Junior Member

sir done with the practical thanx for guidence

Report message to a moderator

Re: ORA-39166 error [message #632420 is a reply to message #632419]

Fri, 30 January 2015 05:44

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?

Report message to a moderator

Re: ORA-39166 error [message #632422 is a reply to message #632420]

Fri, 30 January 2015 05:52

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

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.

Report message to a moderator

Previous Topic:	EXPDP/IMPDP
Next Topic:	Export Statistics of schema from the database

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Mar 03 16:10:26 CST 2025