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;