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 previous 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.
 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
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: Fri Mar 29 00:49:15 CDT 2024