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 )
  )
  );

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

               http://www.postgresql.org/docs/faqs/FAQ.html

Reply via email to