Oracle 更改分区表中LOB的默认表空间

SQL> create table t (pk number primary key, x clob)
  2  lob (x ) store as ( tablespace largets )
  3      partition by range (pk)
  4      interval (1)
  5      (partition p1 values less than (2)
  6      );

Table created.

SQL>
SQL> insert into t values (1,rpad('x',32000,'x'));

1 row created.

SQL> insert into t values (2,rpad('x',32000,'x'));

1 row created.

SQL> insert into t values (3,rpad('x',32000,'x'));

1 row created.

SQL>
SQL> select table_name, partition_name, tablespace_name
  2  from user_lob_partitions
  3  order by partition_position;

TABLE_NAME                     PARTITION_NAME                 TABLESPACE_NAME
------------------------------ ------------------------------ ------------------------
T                              P1                             LARGETS
T                              SYS_P16751                     LARGETS
T                              SYS_P16754                     LARGETS

3 rows selected.

SQL>
SQL> alter table t modify default attributes lob (x ) ( tablespace users );

Table altered.

SQL>
SQL> insert into t values (4,rpad('x',32000,'x'));

1 row created.

SQL>
SQL> select table_name, partition_name, tablespace_name
  2  from user_lob_partitions
  3  order by partition_position;

TABLE_NAME                     PARTITION_NAME                 TABLESPACE_NAME
------------------------------ ------------------------------ ------------------------
T                              P1                             LARGETS
T                              SYS_P16751                     LARGETS
T                              SYS_P16754                     LARGETS
T                              SYS_P16757                     USERS

4 rows selected.

SQL>
SQL>
SQL>
SQL>