From: | sandeep_g25(at)rediffmail(dot)com (sandeep G) |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | How to move BLOB partitions to a different tablespace? |
Date: | 2003-09-29 04:10:03 |
Message-ID: | e8975eb.0309282010.78e36868@posting.google.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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 )
)
);
From | Date | Subject | |
---|---|---|---|
Next Message | Rudi Starcevic | 2003-09-29 07:01:14 | 7.3.4 - pg_relcheck |
Previous Message | Gaetano Mendola | 2003-09-28 22:23:38 | Re: postgresql.conf.... virtualhost ??? |