1.建一个用户
-- Create the user
create user MHCA
i dentified by ""
default tablespace USERS
temporary tablespace TEMP
profile DEFAULT;
-- Grant/Revoke role privileges
grant connect to MHCA;
grant dba to MHCA;
-- Grant/Revoke system privileges
grant analyze any to MHCA;
grant create any trigger to MHCA;
grant unlimited tablespace to MHCA;
2.Export dmp
exp user/psw@server file=d:/db.dmp log=d:/expdb.log;
3.Import dmp
imp user2/psw2@server fromuser=user1 touser=user2 file=d:/db.dmp log=d:/expdb.log;
某些时候可能当前用户没有建user的权限,可以通过下面的sql来修改权限
grant create any table,create any sequence to user;