Re: Restructuring Data Tables

From: John Durst <jdurst_at_sky.net>
Date: Tue, 29 Sep 1998 23:18:23 -0500
Message-ID: <3611B10F.53FA24BD@sky.net>

You could do a create table as select (with nologging and in parallel if necessary), drop the original table, and then rename the new table. Of course, as always any referential constraints could be a problem, and you would have to recreate other constraints, indexes, triggers, etc. on the new table...What exactly is the reasoning for avoiding export/import?

deharo_at_my-dejanews.com wrote:

> Is it possible to differently restructure a data table than by an export of
> the table then importation of this same table?
>
> Thanks for forwarding me your suggestions.
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
Received on Tue Sep 29 1998 - 23:18:23 CDT