Help With exp and DRI

From: Rob Forster <robertf_at_inforamp.net>
Date: 12 Oct 1998 18:17:12 GMT
Message-ID: <6vth38$760@news.inforamp.net>

I have some questions related to using the export utility.

When using the export utility to rebuild a table with child tables (ie. foreign key references), how is this done?

Can I export the parent table only and then rebuild the primary key and all its non-unique indexes or do I have to export the parent and all its children and their indexes.

Also, is there a way to do this while the database is open and available to users. How would one go about this using a lock table command and then invoking export?

Thanks,
Rob. Received on Mon Oct 12 1998 - 13:17:12 CDT