如何把数据导入不同的表空间?

来源:互联网 发布:英伦风衣 知乎 编辑:程序博客网 时间:2024/04/28 22:40
.回收用户unlimited tablespace权限这样就可以导入到用户缺省表空间SQL> create user bjbbs identified by passwd 2 default tablespace bjbbs 3 temporary tablespace temp 4 /User created.SQL> grant connect,resource to bjbbs;Grant succeeded.SQL> grant dba to bjbbs;Grant succeeded.SQL> revoke unlimited tablespace from bjbbs;Revoke succeeded.SQL> alter user bjbbs quota 0 on users;User altered.SQL> alter user bjbbs quota unlimited on bjbbs;