| oracle impdp command issue [message #666228] |
Sun, 22 October 2017 04:04  |
 |
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 #666933 is a reply to message #666540] |
Fri, 01 December 2017 12:40  |
 |
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
