Re: Building a Partitioned Primary Key index on a VLDB?

Hi,
I'm afraid you're further along than I am. I was looking for related assistance I'm not sure I have the proper syntax for creating a partitioned primary key. I tried:
alter table t add constraint t_pk primary key (TDATE,TID , TSCHEME) using index local
tablespace T_space;

and received the following message:
ERROR at line 1:
ORA-00600: internal error code, arguments: [12851], [], [], [], [], [], [], []

The partition key is TDATE.
Is the syntax correct (using local?).

Thanks in advance,
Steve

doid_at_usa.net wrote:

> Fellow users,
>
> ...
> To recapitulate, I am seeking a way to build a primary key index, using an
> equipartitioned index, on a very large table, without doing a full table scan.
> I wish to build this index one partition at a time.
>
> If any of you have any experience or insights you could share, I would love to
> hear from you.
>
> thank you,
>
> doid.
Received on Thu Oct 08 1998 - 12:20:39 CDT