Import in a precreated schema: triggers and foreign keys question

Oracle 8174

I want to export a schema in order to rebuild it's segments in a locally managed tablespace (autoallocate)

I also want to remove the "initial" extent of the segments so that is defaults to the locally managed tablespace allocation mechanism (It's actually a messy bunch of various initial extents sizes, mostly wrong)

Here's what I plan to do:

export schema
import show=y row=n then remove storage specs and change tablespace names for tables and indexes from the log
run the modified log to precreate the tables (Tables + indexes only) disable all constraints and triggers in destination schema reimport with ignore=y
re-enable constraints and triggers

Is this OK or is there a better way ?

My problem lies with integrity constraints and triggers. I presume that the triggers and constraints will be active when I import with ignore=y and that's why I need to disable them. Received on Thu Oct 21 2004 - 12:39:15 CDT