Hi, I have a table that is partitioned and has a lob column. I have moved the partitions to a different tablespace and the DDL for the table shows that the partitions are in the new tablespace, however the ddl still shows the lob definition in the old tablespace:
CREATE TABLE OEM_USR.PS_D_EX_ADV_HDR_S
LOB (COMMENTS) STORE AS (
PARTITION BY RANGE (D_LAST_CHNG_TMSTMP)
PARTITION P20110300 ...
LOB (COMMENTS) STORE AS SECUREFILE (
As can be seen the table partitions are in the new ZTEST_DATA tablespace, and even the LOB partitions show the tablespace as ZTEST_DATA. However, the main LOB definition still shows the older ZTES_DATA_XXX tablespace.
How can I change that tablespace?