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.