Import & Export database oracle

Import & Export database oracle

Export database

C:\>exp old_user/password file=dbFileName

Create new user:
Go to the SQL plush and execute following query

SQL> create user new_user identified by password

Grant DBA role to this user

SQL> grant DBA to new_user;

Import database

C:\>imp new_user/password file=dbFileName fromuser=old_user touser=new_user