Oracle User Create .dmp Export -Import

 New User Create: 

SQL> conn / as sysdba

Connected.

SQL> drop user NewUserName cascade ;

User dropped.

SQL> create user NewUserName identified by NewUserPassword ;

User created.

SQL> grant dba to NewUserName ;

Grant succeeded.

.dmp Export: 

$exp OldUserName/OldUserPassword owner=OldUserName

file=C:\locationPath\Name.dmp ;

Import: 

$imp NewUserName/NewUserPassword  file=D:\locationPath\Name.dmp fromuser=OldUserName 

touser=NewUserName ;