OraFAQ Forum: Server Utilities

Home » RDBMS Server » Server Utilities » Oracle Data Pump (Windows)

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

Oracle Data Pump [message #474838]

Thu, 09 September 2010 04:55

maniatniit
Messages: 49
Registered: June 2010
Location: Mumbai

Member

Hi
Please look at below session
we are using datapump and we face a following error
in below session

We want to import a dump in TESTIMP Schema
=============================================================

D:\>impdp TESTIMP/TESTIMP TABLES=ENVDB DIRECTORY=Rini DUMPFILE=envdb_11g.dmp REM
AP_SCHEMA=TESTIMP:STP11G REMAP_TABLESPACE=TBS_TESTIMP:TBS_STP11G;

Import: Release 11.2.0.1.0 - Production on Thu Sep 9 15:16:45 2010

Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Produc
tion
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORA-39002: invalid operation
ORA-39166: Object TESTIMP.ENVDB was not found.

===========================================================

Thanks & Regards
Manish Hemnani

Report message to a moderator

Re: Oracle Data Pump [message #474843 is a reply to message #474838]

Thu, 09 September 2010 05:09

S.Rajaram
Messages: 1027
Registered: October 2006
Location: United Kingdom

Senior Member

Could you post the log file of your expdp? As far as I can see the object you are trying to import using impdp doesn't exist in the dump file.

Quote:

ORA-39166: Object string was not found. Cause: If exporting or importing over the network, either the user specified an object name that was not found in the source database or else the user lacked the proper EXP_FULL_DATABASE or IMP_FULL_DATABASE role that would allow them to access the object another in another schema. For importing from files, the user specified an object name not found in the dump file set.
Action: Retry the operation using the correct object name.

If you could format your post it will be much appreciated.

Regards

Raj

[Edit: ] Include the quote for the error message

[Updated on: Thu, 09 September 2010 05:12]

Report message to a moderator

Re: Oracle Data Pump [message #474844 is a reply to message #474838]

Thu, 09 September 2010 05:10

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

Senior Member
Account Moderator

ORA-39166: Object %s was not found.
 *Cause:  If exporting or importing over the network,  either the user
          specified an object name that was not found in the source database
          or else the user lacked the proper EXP_FULL_DATABASE or
          IMP_FULL_DATABASE role that would allow them to access the object
          another in another schema.  For importing from files, the user
          specified an object name not found in the dump file set.
 *Action: Retry the operation using the correct object name.

Regards
Michel

Report message to a moderator

Previous Topic:	A DATE datatype question (SQL*Loader)
Next Topic:	Trim date characters within sql loader

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jan 11 01:47:44 CST 2025