By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,948 Members | 1,595 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,948 IT Pros & Developers. It's quick & easy.

Move BLOB partitions to a different tablespace

P: n/a
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
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.