Re: ORA-14098 - can anyone see what is wrong here
- From: genegurevich@xxxxxxxxxxxxxxxxxxxxx
- To: mdemenko@xxxxxxxxx
- Date: Thu, 7 Jun 2007 14:42:37 -0500
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
Other related posts:
