.回收用户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;
如何把数据导入不同的表空间?
最新推荐文章于 2024-09-02 07:02:10 发布