Re: Exp / Imp table

On Fri, 13 Apr 2001 17:45:56 -0400, "Steve" <schen_at_prodigy.net> wrote:

You could export the table.

disable constraints

Truncate table

Import table

Reenable constraints.

Or

Export table

Drop table cascade constraints

Redefine everything including grants

Reimport everything.

alter table xxx move in 8i works pretty good if not IOT.

>Do we have to drop a table first when exp/imp that table is involved?
>What if the table has index, foreign key constraints...? Would imp take
>care of all back?
>
>Thanks,
>
>Steve
>
>
Received on Fri Apr 13 2001 - 21:23:46 CDT