oracle添加用户并指定数据库

imp cmsuser/password@orcl file=bubpdmp fromuser=cmsuser touser=cmsuser

SQL> create user uumcuser identified by password;

User created

SQL> grantgrant connectdba to uumcuser; SP: unknown command beginning grantgrant rest of line ignored SQL> grant connectdba to uumcuser;

Grant succeeded

SQL> grant exp_full_databaseimp_full_databaseresourcecreate any sequence to cmsuser;

Grant succeeded

SQL> grant create any triggercreate any viewcreate tabledrop any view to uumcuser;

Grant succeeded

SQL> grant exp_full_databaseimp_full_databaseresourcecreate any sequence to uumcuser;

Grant succeeded