Toad bug report for 11.0.0.116

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





------------------------------------

Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/toad/

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    http://groups.yahoo.com/group/toad/join
    (Yahoo! ID required)

<*> To change settings via email:
    [email protected] 
    [email protected]

<*> To unsubscribe from this group, send an email to:
    [email protected]

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/