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

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

Data pump user level importing

SQL> drop user scott cascade;

oracle> impdp dumpfile=user.dmp remap_schema=scott:scott directory=dp

                username : / as sysdba

                We no need to create the skeleton user before importing the data like logical traditional importing.

SQL> alter user scott account unlock indentifed by scott;

SQL> conn scott/tiger

scott> select * from tab;

 

oracle> impdp dumpfile=user.dmp remap_schema=scott:u1 directory=dp

                If there is no u1 user,it creates.

                u1 takes tiger as password.

No comments:

Post a Comment

Related Posts Plugin for WordPress, Blogger...

Flag Counter