Oracle 创建Schema

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;