Create PARTITION BY HASH SUBPARTITION BY HASH problem
771073Jan 4 2012 — edited Jan 5 2012Hi-
I am facing a problem with creating a simple table PARTITION BY "HASH" & has SUBPARTITION of type "HASH"
SQL:
CREATE TABLE TEST_TABLE
( X NUMBER,
Y NUMBER,
Z number)
PARTITION BY HASH (x) SUBPARTITION BY HASH (Y) PARTITIONS 16 SUBPARTITIONS 4;
when i tried to run this SQL against oracle with edition "Oracle Database 11g Enterprise Edition Release _11.2.0.1.0_ - 64bit Production" it ran sucessfully
BUT when i tried to run it against oracle with edition "Oracle Database 11g Enterprise Edition Release _11.1.0.7.0_ - 64bit Production" it fail with the following error
Error report:
SQL Error: ORA-00922: missing or invalid option
The Question here :_ why is this error message showed up with oracle 11g R1 and not with R2 ?.... is it because there are another syntax that Oracle 11g R1 supports or building Hash PARTITION with another Hash SUBPARTITION isnt supported in oracle 11g R1?