Hi All,

I am using Oracle 11g. I am doing a testing on Reference Partition.
I found the child table partition tablespace is using default TBSP_ORDER.

Is there a command can append somewhere so that child partition tablespace can match with parent partition tablespace?

Below is the code.
Hope any of you can help. Thanks.

CREATE TABLE CAR_TYPE (
CAR_ID VARCHAR2(50) NOT NULL,
CAR_MDL VARCHAR2(500) NOT NULL,
DT_CRT TIMESTAMP(6) DEFAULT SYSTIMESTAMP NOT NULL,
CRT_BY VARCHAR2(50) DEFAULT 'AUTO' NOT NULL,
CONSTRAINT CAR_ID PRIMARY KEY (CAR_ID)
) TABLESPACE TBSP_CAR
PARTITION BY RANGE(DT_CRT) (
PARTITION CAR_201501 VALUES LESS THAN (TO_DATE('01-02-2015' ,'DD-MM-YYYY')) TABLESPACE TBSP_CAR_201501,
PARTITION CAR_201502 VALUES LESS THAN (TO_DATE('01-03-2015' ,'DD-MM-YYYY')) TABLESPACE TBSP_CAR_201502,
PARTITION CAR_201503 VALUES LESS THAN (TO_DATE('01-04-2015' ,'DD-MM-YYYY')) TABLESPACE TBSP_CAR_201503,
PARTITION CAR_201504 VALUES LESS THAN (TO_DATE('01-05-2015' ,'DD-MM-YYYY')) TABLESPACE TBSP_CAR_201504,
PARTITION CAR_201505 VALUES LESS THAN (TO_DATE('01-06-2015' ,'DD-MM-YYYY')) TABLESPACE TBSP_CAR_201505,
PARTITION CAR_MAX VALUES LESS THAN (MAXVALUE) TABLESPACE TBSP_CAR_MAX)
);

ALTER TABLE CAR_TYPE
ADD ( CONSTRAINT UK_CAR_TYPE#CAR_MDL
UNIQUE (CAR_MDL) USING INDEX TABLESPACE TBSP_CAR_IDX);

CREATE TABLE ORDER_CAR (
ORDER_ID VARCHAR2(50) NOT NULL,
CAR_ID VARCHAR2(50) NOT NULL,
DESC VARCHAR2(100),
DT_CRT TIMESTAMP(6) DEFAULT SYSTIMESTAMP NOT NULL,
CRT_BY VARCHAR2(50) DEFAULT 'AUTO' NOT NULL,
CONSTRAINT PK_ORDER_CAR PRIMARY KEY (ORDER_ID)
CONSTRAINT FK_ORDER_CAR#CAR_TYPE FOREIGN KEY (CAR_ID) REFERENCES CAR_TYPE (CAR_ID)
) TABLESPACE TBSP_ORDER
PARTITION BY REFERENCE (FK_ORDER_CAR#CAR_TYPE)
ENABLE ROW MOVEMENT;