Oracle 11g DBA Concepts
u1> drop table emp purge;
u1> drop table dept purge;
user should exist in table level import.
oracle> impdp dumpfile=table.dmp remap_schema=scott:u1 directory=dp
username : / as sysdba
u1> select * from tab;
No comments:
Post a Comment