Re: Simple Export Question

When you export constraints [PK, UK, FK] are exported with the table unless you specifiy constraints=n on the export.

When you import Oracle will attempt to re-establish the constraints. If it is unable to do so the imp will issue error messages. For FK that reference tables that do not exist in the new instance Oracle will not automatically try to create the referenced table. It will have to be part of the export set or the constraint will not be re-established.

If you are exporting related tables with database defined referential integrity constraints on them you may want to use the consistent=y parameter on the export.

• Sent from RemarQ http://www.remarq.com The Internet's Discussion Network * The fastest and easiest way to search and participate in Usenet - Free!