Re: Row-chained Tables

Hi
Easy thing to do is
copy a data to some temp table then truncate the actual table then insert back.
create table temp_table as select * from <actual_table>; Truncate table <actual_table>
insert into <actual_table> select * from temp_table; commit;
This will keep the all the table dependent objects like constraint, indexes and triggers and et al intact.

If in the actual table the update is carried out with various lengh of data then chances of getting chained row is more ... for that reason leave the pctfree little high and only works or dropping and recreating table.

HTH
Pradhan

NetComrade wrote in message <379f7f83.29983618_at_news.earthlink.net>...
>Hi,
>
>Here's the problem.
>
>I have a table which is 90% chained, there is no point really do
>delete those rows and then insert them back. What I would think would
>be appropriate is dropping the table and recreating it (something like
>create table2 as select * from table1)
>drop table1
>alter database rename .... (or whatever the syntax is), but then
>again, there is a problem with constraints.
>
>Thanx
>
Received on Wed Jul 28 1999 - 18:36:58 CDT