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: 18
Registered: April 2017
Junior 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: 2676
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: 7150
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: 18
Registered: April 2017
Junior 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 message
John Watson
Messages: 7150
Registered: January 2010
Location: Global Village
Senior Member
What worked for you?
Previous Topic: Exp in Oracle 12c
Next Topic: Re: Load WKT using sql*loader (split from http://www.orafaq.com/forum/t/155866/ by bb)
Goto Forum:
  


Current Time: Sat Nov 25 03:14:41 CST 2017

Total time taken to generate the page: 0.01938 seconds