exp/imp util. against a table with constraints...

Hello,

I have to perform a few export/import tasks for a table that's extremely fragmented. But this table has 2 triggers, a primary keym and foreign keys point towards it. 1- First I'd like to know what I must do before exporting:

   "ALTER TABLE .. DISABLE .." etc etc. so that I won't    encounter problems when truncating it and reloading it,    and thus I'll keep my ID's (coming from a sequence) the    same. What SQL statement(s) should I issue before doing    my export ?

2- My instance has to stay up of course: in which state

   should I put it in order to be able to perform my export,    but at the same time to prevent users from connecting ?    Is there a particular "ALTER SYSTEM .." or "ALTER DB .."    statement for that purpose ??

Thanks a lot for any enligtenment !

Regards,
Seb

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Mar 09 2000 - 02:15:39 CST