Home » RDBMS Server » Server Utilities » Oracle Data Pump (Windows)
Oracle Data Pump [message #474838] Thu, 09 September 2010 04:55 Go to next message
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
Re: Oracle Data Pump [message #474843 is a reply to message #474838] Thu, 09 September 2010 05:09 Go to previous messageGo to next message
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 Go to previous message
Michel Cadot
Messages: 58605
Registered: March 2007
Location: Nanterre, France, http://...
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
Previous Topic: A DATE datatype question (SQL*Loader)
Next Topic: Trim date characters within sql loader
Goto Forum:
  


Current Time: Mon Jul 28 18:18:05 CDT 2014

Total time taken to generate the page: 0.14218 seconds