Hi
I created the following table in Toad/Oracle 11g with no problem but generating the script back with toad has syntax error.
I am using Toad for Oracle Expert 11.0.0.116
CREATE TABLE junk
(
id NUMBER (20) NULL,
status NUMBER (5) DEFAULT 0 NULL,
enc_dt DATE NULL,
rec_type VARCHAR2 (5) NULL,
activity_type_cd VARCHAR2 (2) NULL
)
TABLESPACE users
PARTITION BY RANGE (id)
INTERVAL ( 20000000 )
SUBPARTITION BY HASH (id)
SUBPARTITION TEMPLATE (SUBPARTITION p003sp01
TABLESPACE users,
SUBPARTITION p003sp02
TABLESPACE users,
SUBPARTITION p003sp03
TABLESPACE users,
SUBPARTITION p003sp04
TABLESPACE users,
SUBPARTITION p003sp05
TABLESPACE users,
SUBPARTITION p003sp06
TABLESPACE users,
SUBPARTITION p003sp07
TABLESPACE users,
SUBPARTITION p003sp08
TABLESPACE users
)
(PARTITION p001 VALUES LESS THAN (700000000)
NOLOGGING
NOCOMPRESS
TABLESPACE users,
PARTITION p002 VALUES LESS THAN (1000000000)
NOLOGGING
NOCOMPRESS
TABLESPACE users
);
– Toad generated scrip for junk table is copied below. This script has a syntax error, “INTERVAL( 20000000)” should be after “PARTITION BY RANGE (ID)” clause and before SUBPARTITION section.
CREATE TABLE JUNK
(
ID NUMBER(20) NULL,
STATUS NUMBER(5) DEFAULT 0 NULL,
ENC_DT DATE NULL,
REC_TYPE VARCHAR2(5) NULL,
ACTIVITY_TYPE_CD VARCHAR2(2) NULL
)
TABLESPACE USERS
PARTITION BY RANGE (ID)
SUBPARTITION BY HASH (ID)
SUBPARTITION TEMPLATE
(SUBPARTITION P003SP01 TABLESPACE USERS,
SUBPARTITION P003SP02 TABLESPACE USERS,
SUBPARTITION P003SP03 TABLESPACE USERS,
SUBPARTITION P003SP04 TABLESPACE USERS,
SUBPARTITION P003SP05 TABLESPACE USERS,
SUBPARTITION P003SP06 TABLESPACE USERS,
SUBPARTITION P003SP07 TABLESPACE USERS,
SUBPARTITION P003SP08 TABLESPACE USERS
)
INTERVAL( 20000000)
(
PARTITION P001 VALUES LESS THAN (700000000)
NOLOGGING
NOCOMPRESS
TABLESPACE USERS
( SUBPARTITION P001_P003SP01 TABLESPACE USERS,
SUBPARTITION P001_P003SP02 TABLESPACE USERS,
SUBPARTITION P001_P003SP03 TABLESPACE USERS,
SUBPARTITION P001_P003SP04 TABLESPACE USERS,
SUBPARTITION P001_P003SP05 TABLESPACE USERS,
SUBPARTITION P001_P003SP06 TABLESPACE USERS,
SUBPARTITION P001_P003SP07 TABLESPACE USERS,
SUBPARTITION P001_P003SP08 TABLESPACE USERS ),
PARTITION P002 VALUES LESS THAN (1000000000)
NOLOGGING
NOCOMPRESS
TABLESPACE USERS
( SUBPARTITION P002_P003SP01 TABLESPACE USERS,
SUBPARTITION P002_P003SP02 TABLESPACE USERS,
SUBPARTITION P002_P003SP03 TABLESPACE USERS,
SUBPARTITION P002_P003SP04 TABLESPACE USERS,
SUBPARTITION P002_P003SP05 TABLESPACE USERS,
SUBPARTITION P002_P003SP06 TABLESPACE USERS,
SUBPARTITION P002_P003SP07 TABLESPACE USERS,
SUBPARTITION P002_P003SP08 TABLESPACE USERS )
)
NOCOMPRESS
NOCACHE
NOPARALLEL
MONITORING;
Thanks,
Ben