Обсуждение: How to move BLOB partitions to a different tablespace?
How to move BLOB partitions to a different tablespace?
От
sandeep_g25@rediffmail.com (sandeep G)
Дата:
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 ) ) );