Yep, that is it. Stupid me! thank you Gene Gurevich Oracle MySQL Operations - OMO 224-405-4079 Maxim Demenko <mdemenko@xxxxxxx om> To genegurevich@xxxxxxxxxxxxxxxxxxxxx 06/07/2007 12:58 cc PM oracle-l@xxxxxxxxxxxxx Subject Re: ORA-14098 - can anyone see what Please respond to is wrong here mdemenko@xxxxxxxx m Your index XCHG_DLY_CPB_PK has to be local as well. SQL> drop TABLE DLY_CPB ; drop TABLE DLY_CPB * ERROR at line 1: ORA-00942: table or view does not exist SQL> CREATE TABLE DLY_CPB ( 2 ACCT_KEY NUMBER(10, 0) NOT NULL, 3 PROC_DT_VAL NUMBER(8, 0) NOT NULL, 4 EXT_STAT_CHNG_DT DATE 5 ) 6 NOLOGGING 7 PARTITION BY RANGE (PROC_DT_VAL) 8 SUBPARTITION BY HASH (ACCT_KEY) 9 SUBPARTITIONS 16 10 ( 11 PARTITION P200703 12 VALUES LESS THAN (20070401) 13 NOLOGGING, 14 PARTITION P200704 15 VALUES LESS THAN (20070501) 16 NOLOGGING 17 ) 18 ; Table created. SQL> CREATE UNIQUE INDEX DLY_CPB_PK ON DLY_CPB(ACCT_KEY, PROC_DT_VAL) 2 NOLOGGING 3 LOCAL 4 ; Index created. SQL> ALTER TABLE DLY_CPB ADD 2 CONSTRAINT DLY_CPB_PK PRIMARY KEY (ACCT_KEY, PROC_DT_VAL) 3 USING INDEX 4 ; Table altered. SQL> Drop TABLE XCHG_DLY_CPB ; Drop TABLE XCHG_DLY_CPB * ERROR at line 1: ORA-00942: table or view does not exist SQL> CREATE TABLE XCHG_DLY_CPB ( 2 ACCT_KEY NUMBER(10, 0) NOT NULL, 3 PROC_DT_VAL NUMBER(8, 0) NOT NULL, 4 EXT_STAT_CHNG_DT DATE 5 ) 6 NOLOGGING 7 PARTITION BY HASH (ACCT_KEY) 8 PARTITIONS 16 9 ; Table created. SQL> CREATE UNIQUE INDEX XCHG_DLY_CPB_PK ON XCHG_DLY_CPB(ACCT_KEY, PROC_DT_VAL) LOCAL 2 ; Index created. SQL> ALTER TABLE XCHG_DLY_CPB ADD 2 CONSTRAINT XCHG_DLY_CPB_PK PRIMARY KEY (ACCT_KEY, PROC_DT_VAL) 3 USING INDEX 4 ; Table altered. SQL> alter table dly_cpb exchange partition p200704 with table xchg_dly_cpb including indexes; Table altered. Best regards Maxim -- //www.freelists.org/webpage/oracle-l