I've a table which has a number & a blob column, both of which are NOT
NULL type. This table is composite partitioned using range & hash on
the same column.
Each partition is sub partitioned into two. I'm using ORACLE VERSION 9.0.2.
Now if I try to move the partitions to a different tablespace I get an
oracle error sayiing that ERROR: ORA_14257 cannot move partition other
than a Range or Hash partition
Now is there any other way to move the partition to another
tablespace. Here is the code
CREATE TABLE temp1
(
col1 INTEGER NOT NULL ,
col2 BLOB NOT NULL
)
TABLESPACE space
LOB (col2) STORE AS
(
DISABLE STORAGE IN ROW
PCTVERSION 10
NOCACHE
)
NOPARALLEL
NOCACHE
PARTITION BY RANGE (col1)
SUBPARTITION BY HASH (col1)
(
PARTITION p1 VALUES LESS THAN (10)
TABLESPACE space
LOB (col2) STORE AS
(
TABLESPACE space
PCTVERSION 10
NOCACHE
)
(
SUBPARTITION sp1 TABLESPACE space
LOB (col2) STORE AS
( TABLESPACE space )
,SUBPARTITION sp2 TABLESPACE space
LOB (col2) STORE AS
( TABLESPACE space )
)
,PARTITION p2 VALUES LESS THAN (20)
TABLESPACE space
LOB (col2) STORE AS
(
TABLESPACE space
PCTVERSION 10
NOCACHE
)
(
SUBPARTITION sp3 TABLESPACE space
LOB (col2) STORE AS
( TABLESPACE space )
,SUBPARTITION sp4 TABLESPACE space
LOB (col2) STORE AS
( TABLESPACE space )
)
);