Home » RDBMS Server » Server Utilities » oracle impdp command issue (oracle 11g)
oracle impdp command issue [message #666228] Sun, 22 October 2017 04:04 Go to next message
POGAKU_SANTHOSH
Messages: 39
Registered: April 2017
Member
I have two oracle database "orcl" and "orcl1" and each database i have two schemas( hr&log ) in the two databases with the same schema name . Now i have two tables table := A AND table := B . These tables are present in the database "orcl" in "HR" schema ,i want to import the data of the tables(A,B) from hr schema in orcl database to "log schema " in orcl1 database.Here i have created the structure of the tables (A & B) in hr schema in orcl1 database. When i use impdp command it is throwing error.

impdp hr/user@orcl1 tables=a,b directory=sys dumpfilename=a_b.dmp logfile=a_b.log
"table or object not found"

I have created both the objects in the orcl1 database and given necessary grants to the tables like select,insert to public

Can any one suggest me and approach .

Thank you.
Re: oracle impdp command issue [message #666231 is a reply to message #666228] Sun, 22 October 2017 05:12 Go to previous messageGo to next message
Solomon Yakobson
Messages: 3269
Registered: January 2010
Location: Connecticut, USA
Senior Member
And what command did you use to export tables A & B? Please provide exact command with actual table names.

SY.
Re: oracle impdp command issue [message #666232 is a reply to message #666228] Sun, 22 October 2017 07:42 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
https://docs.oracle.com/database/122/SUTIL/datapump-import-utility.htm#SUTIL927
Re: oracle impdp command issue [message #666539 is a reply to message #666232] Sun, 12 November 2017 11:01 Go to previous messageGo to next message
POGAKU_SANTHOSH
Messages: 39
Registered: April 2017
Member
Thank you .It works for me
Re: oracle impdp command issue [message #666540 is a reply to message #666539] Sun, 12 November 2017 11:02 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
What worked for you?
Re: oracle impdp command issue [message #666933 is a reply to message #666540] Fri, 01 December 2017 12:40 Go to previous message
ctvarner
Messages: 11
Registered: August 2017
Junior Member
With no answer to either of the questions asked above, my best guess is that the export was wrong somehow, so the dump file did not contain both A and B, so when you specified "tables=a,b" on the import, one or the other (or both) were not found in the specified dump file.
Previous Topic: Re: Load WKT using sql*loader (split from http://www.orafaq.com/forum/t/155866/ by bb)
Next Topic: loading data from twitter with sqlldr
Goto Forum:
  


Current Time: Thu Mar 28 10:01:09 CDT 2024