Re: Exp / Imp table

From: Daniel Dai <daijy_at_portal.com>
Date: Sat, 14 Apr 2001 12:58:06 +0800
Message-ID: <9b8le9$2b5j$1@news.cz.js.cn>

You can specify ignore=y in command line param so that you need not drop the table. But you must ensure the table existing is empty, or duplicate records may exists.
index, foreign key constraints are imported as the table import, you can specify indexes=n to suppress the indexes to be imported. So the command line maybe:

imp userid=.../...@... tables=... indexes=n ignore=y

"Steve" <schen_at_prodigy.net> wrote in message news:9b7rq7$65ji$1_at_newssvr06-en0.news.prodigy.com...
> 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 - 23:58:06 CDT