Home » SQL & PL/SQL » SQL & PL/SQL » error while paritioning an index?? Very Urgent!!
error while paritioning an index?? Very Urgent!! [message #18572] Tue, 05 February 2002 09:31 Go to next message
CATHYBEE
Messages: 20
Registered: January 2002
Junior Member
GLOBAL PARTITIONED INDEX MUST BE PREFIXED..
WHAT DOES THAT MEAN?
my TABLE
SQL> desc tbl_claimtrack;
Name Null? Type
------------------------------- -------- ----
HOSTKEY NOT NULL TIMESTAMP(4)
CLAIMID NOT NULL RAW(32)
TRANSMITTIME NOT NULL TIMESTAMP(4)

WHERE

HOSTKEY PK/FK
CLAIMID PK/FK
TRANSMITTIME REGULAR COLUMN

MY INDEX:
CREATE UNIQUE INDEX idxAK_ClaimTrack2 ON tbl_ClaimTrack
(HostKey,ClaimID,TransmitTime)
GLOBAL PARTITION BY RANGE(TramsmitTime)
(PARTITION D0200201
VALUES LESS THAN(TO_DATE('FEB-2002','MON-YYYY')),
PARTITION D0200202
VALUES LESS THAN(TO_DATE('MAR-2002','MON-YYYY')),
PARTITION D0200212 VALUES LESS THAN(MAXVALUE));

ERROR:
gLObAL PARTITION BY RANGE(TransmitTime)
*
ERROR at line 7:
ORA-14038: GLOBAL partitioned index must be prefixed

ANY HELP IS APPRECIATED.
THANX!
Re: error while paritioning an index?? Very Urgent!! [message #18580 is a reply to message #18572] Wed, 06 February 2002 05:36 Go to previous message
pratap kumar tripathy
Messages: 660
Registered: January 2002
Senior Member
hi,

try this

CREATE UNIQUE INDEX idxAK_ClaimTrack2 ON part_test
(TransmitTime,HostKey,ClaimID)
GLOBAL PARTITION BY RANGE(TransmitTime)
(PARTITION D0200201
VALUES LESS THAN(TO_DATE('FEB-2002','MON-YYYY')),
PARTITION D0200202
VALUES LESS THAN(TO_DATE('MAR-2002','MON-YYYY')),
PARTITION D0200212 VALUES LESS THAN(MAXVALUE)
)

remember in the index column_list transmittime should go first.

cheers
pratap
Previous Topic: Protect Operations with additional Passwords
Next Topic: Error while partitioning the Index: GLOBAL partitioned index must be prefixed??
Goto Forum:
  


Current Time: Mon Sep 27 18:39:29 CDT 2021