ORACLE数据导入到指定的表空间

create user 用户名 identified by 密码 default tablespace 缺省表空间　Temporary tablespace 临时表空间;­
­
grant connect,resource,dba to 用户名;­
　　­
revoke unlimited tablespace from 用户名;­
　　­
alter user 用户名 quota 0 on Users;­
­
alter user 用户名　quota unlimited on 用户缺省表空间;­
­
--关键是后面3行命令，必须执行。­
­
--接着使用IMP工具导入数据即可导入到用户缺省表空间. ­
 
--EXAMPLE:    USER NAME: GROUPCMS;     tablespace:GROUPCMS
--DROP USER GROUPCMS CASCADE;
create user GROUPCMS identified by ABC123 default tablespace GROUPCMS　 ;
grant connect,resource,dba to GROUPCMS;
revoke unlimited tablespace from GROUPCMS;
alter user GROUPCMS quota 0 on Users;
alter user GROUPCMS　quota unlimited on GROUPCMS;