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 .