| error while paritioning an index?? Very Urgent!! [message #18572] |
Tue, 05 February 2002 09:31  |
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  |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
