Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Row-chained Tables

Row-chained Tables

From: NetComrade <andreyNSPAM_at_bookexchange.net>
Date: Wed, 28 Jul 1999 22:11:45 GMT
Message-ID: <379f7f83.29983618@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 - 17:11:45 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US