Re: How to disable ALL constraints ?

From: Jerry Gitomer <jgitomer_at_erols.com>
Date: Mon, 24 Jan 2000 00:13:30 -0500
Message-ID: <388BDF7A.BC8AAA01@erols.com>

Jannette wrote:
>
> From Oracle documentation:
> "Suggestion: ... it is a good idea to disable referential constraints
> when importing into an existing table. You can then re-enable the
> constraints after the import is completed."
>
> How do you disable contraints on ALL tables in one shot ?
> Can you do this through one of Ent. Manager tools or you have to do it
> in SQL+ ?
>
> Thanks
> jannette
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.

Regardless of how you disable them be sure to check for inalid constraints before you start and fix them before you do your import. Also after you enable constraints after the import check for valid constraints again since Oracle will not enable a constraint that is invalid. So if you find one you have to fix it.

--
Jerry Gitomer
Once I learned how to spell DBA, I became one. Received on Sun Jan 23 2000 - 23:13:30 CST