Oracle – New Partitions Created in Original Tablespace After ALTER TABLE MOVE PARTITION

oracle

I moved all objects from one tablespace (hereinafter A) to another (B) .. but when a new partition is created it resises in the original one ..

How can I fix it? I have no idea what to do because everything is moved already

DDL:

CREATE TABLE OWNER_PUBLIC.T_NO_CONNECT_CONTRACTS 
   (    
      CALL_DATE DATE, 
        CONTRACT_ID VARCHAR2(10), 
        FLAG_WF VARCHAR2(3 CHAR)
   ) 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
  STORAGE( BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE OWNER_PUBLIC 
  PARTITION BY RANGE (CALL_DATE) INTERVAL (NUMTODSINTERVAL(1,'DAY')) 
    (PARTITION "P0"  VALUES LESS THAN (TO_DATE(' 2018-01-31 00:00:00', 'SYYYY-MM-DD HH24:MI:SS', 'NLS_CALENDAR=GREGORIAN')) SEGMENT CREATION DEFERRED 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 
  NOCOMPRESS LOGGING 
  STORAGE( BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE OWNER_PUBLIC

Best Answer

Moving existing partitions to a new tablespace does not change the default tablespace at the table level.

To do that:

alter table OWNER_PUBLIC.T_NO_CONNECT_CONTRACTS modify default attributes tablespace tablespaceB;

ALTER TABLE

enter image description here

enter image description here

Related Question