Ora-14095:

[balajiyes]

Hi All,

Doubts in Exchanging a Hash-Partitioned Table with a Range-Hash Partition.

I was working with example...

CREATE TABLE t1 (i NUMBER, j NUMBER)
PARTITION BY HASH(i)
(PARTITION p1, PARTITION p2);

CREATE TABLE t2 (i NUMBER, j NUMBER)
PARTITION BY RANGE(j)
SUBPARTITION BY HASH(i)
(
PARTITION p1 VALUES LESS THAN (10)
(SUBPARTITION t2_pls1,
SUBPARTITION t2_pls2)
,
PARTITION p2 VALUES LESS THAN (20)
(SUBPARTITION t2_p2s1,
SUBPARTITION t2_p2s2)
);

When I run this COMMAND --
ALTER TABLE t1 EXCHANGE PARTITION p1 WITH TABLE t2 WITH VALIDATION;

I am getting this ERROR MESSAGE...

ERROR at line 1:
ORA-14095: ALTER TABLE EXCHANGE requires a non-partitioned, non-clustered table

Can you geme the cause for this problem.

This is an example given in "Oracle9i Database Administrator’s Guide" page-567

Thanks in Advance

[balajiyes]

Thanks guys
got a solution.

[kris109]

See.. sometimes no response to the post is also beneficial.