Re: Huge primary key creation

On 8 Jan 2003 08:08:49 -0800, rickraster_at_hotmail.com (RR) wrote:

>Hi all, I'm having a brain freeze on this one here. I had some
>corruption on my primary key (in the datafile), so dropped it. That
>table currently holds about 65 million rows, so it takes a while to do
>things. I ran the command:
>
>alter table <table> add constraint <tableid>_pk primary key
>(<tableid>) parallel;
>
>but ran into:
>*
>ERROR at line 1:
>ORA-01652: unable to extend temp segment by 16 in tablespace TEMP
>
>(after about 20 hours or so)
>
>I've added another 2 gig temp file, but will that solve my problems
>and allow me to create this primary key successfully??
>
>Thanks for any insight,
>
>Cheers,
>

The temp space needed is roughly 2 times the average length of a key times the number of records.

>Rick
>
>8.1.7 on linux

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Wed Jan 08 2003 - 12:04:05 CST