创建新的表空间tablespace_b;
创建新的方案/用户user_tmp;
赋予相关权限;create table_small_1
as select * from user_old.table_a ....;
创建新的方案/用户user_tmp;
赋予相关权限;create table_small_1
as select * from user_old.table_a ....;
as select * from table_a ……
alter user uname quota unlimited on tablespace_b;
或者修改默认表空间alter user uname default tablespace tablespace_b;然后直接创建就行了。