Modify default storage for Partitioned Table when using STORE IN clause
Hello,
I'm using Oracle EE 19.18 on an Exadata. I have a date interval partitioned table that I now want to adjust the storage so that new partitions get created in a new tablespace. Typically I would do something like:
alter table <tablename> modify default attributes tablespace <tablespaceName>;
However after making this adjustment, and even inserting some rows that resulted in new partitions being created, the partitions are getting created in the original tablespaces. I suspect it has something to do with the STORE IN clause but not sure.
/* Table DDL */
create table my_tab
( insert_date date not null,
val varchar2(10) not null