Re: Exp / Imp table

You can import into a table that already exists. You only need to disable your constraints if they are going to be broken during the load, so it is a good idea to disable them.

You might care to read the manual.... it is now on-line on the Oracle website http://otn.oracle.com/docs/index.htm, you will need to register at no cost. I have found the on-line documentation very useful. It prevents me from referring back to my old manuals (a version out of date, but still quite useful) or running around the client's office trying to locate their manuals.

"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 Sat Apr 14 2001 - 11:24:33 CDT