Oracle creates a new user and guides a user's table in

Enter Sqlplus (as Administrator)

Sqlplus/as Sysdba;

Create user user1 identified by User1; Create a user name and specify a password

Grant the appropriate permissions

Grant create session to User1;

Grant CREATE table to User1;

Grant unlimited tablespace to User1;

Grant connect to User1;

Grant resource to User1;

Grant DBA to User1;

Old user Data everywhere

The EXP IMP command is supported in the shell environment

Exp Userold/userold FILE=/TMP/DATA.DMP

Userold data everywhere to the specified directory

Imp userold/userold file=/tmp/data.dmp fromuser=userold touser=user1

In the old user's data into the new user

Oracle creates a new user and guides a user's table in