select 'alter table '||table_name||' modify default attributes tablespace TABSPACE ' from dba_tables where table_name in ('A');
alter table BDWEBSERVICE_DATAALYSIS modify default attributes tablespace A
Oracle修改分区表中默认表空间属性方法
![](https://img-home.csdnimg.cn/images/20240711042549.png)
select 'alter table '||table_name||' modify default attributes tablespace TABSPACE ' from dba_tables where table_name in ('A');
alter table BDWEBSERVICE_DATAALYSIS modify default attributes tablespace A