Trancate Table

I want to truncate the table log3 which contains milions of records so I did the following;
>trucate table log3;

the error message was>ORA-02266 unique/primary keys in table referd by enabled forign keys.
then I issued;
>alter table log3 disable primary key cascade;
table alterd

now I was able to truncate the table.

Now when I want to enable the primary keys I had error masage for the command I issued;
>alter table log3 enable primary key;

The error was, ora-01630:max # extents (135) reached in temp segment in table TEMP,
Then I increased the MAX parameters to maxextent 5000 and isue the
>alter table log3 enable primary key;

and got the following error ora-01652:unable to extend temp segmant by 128 table space TEMP.

I am only tryng to enable the primery keys which I disabled it to do the trucation, Please help

Kumar

--
Posted via http://dbforums.com