Please send your Questions & Answers or Feedback to "dvmadhavreddy@javabook.org"

Please send your Questions & Answers or Feedback to "mohan@javabook.org"

Data pump table level importing

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

Related Posts Plugin for WordPress, Blogger...

Flag Counter