Database Administration (MOSC)

MOSC Banner

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center