Re: Help: Re-Oraganizing a table

Hi, Daniel Morgan

Here is my result

SQL> truncate table direction;
truncate table direction

               *
ERROR at line 1:
ORA-02266: unique/primary keys in table referenced by enabled foreign keys

That is why I have to disable those child table foreign keys first.

And I need to drop and re-create some indexes because for some table,

INSERT INTO mytable
SELECT *
FROM temp
ORDER BY primary_key_fields_or_whatever;

will be extremely slow, so slow that you can not bear it.

Any better idea?

Thanks  

-- 
Sent  by dbadba62 from hotmail part  of  com
This is a spam protected message. Please answer with reference header.
Posted via http://www.usenet-replayer.com/cgi/content/new