Oracle Add user and specify database

Create user Cmsuser identified by "Cmsuser";

Sql> create user Uumcuser identified by "password";

User created.

Sql> Grant CONNECT,DBA to Uumcuser;

Grant succeeded.

Sql> Grant Exp_full_database,imp_full_database,resource,create any sequence to cmsuser;

Grant succeeded.

Sql> Grant Create any trigger,create any view,create table,drop any view to Uumcuser;

Grant succeeded.

Sql> Grant Exp_full_database,imp_full_database,resource,create any sequence to uumcuser;

Grant succeeded.

Imp CMSUSER/PASS@ORCL file=bubp20080708.dmp fromuser=cmsuser touser=cmsuser