470,602 Members | 1,496 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,602 developers. It's quick & easy.

Move BLOB partitions to a different tablespace

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.

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 )
)
);
Jul 19 '05 #1
0 7154

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

7 posts views Thread by Steve | last post: by
2 posts views Thread by Markus Neifer | last post: by
1 post views Thread by Prince Kumar | last post: by
4 posts views Thread by Yaro | last post: by
4 posts views Thread by aaggarwal | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.