Re: Disabling/enabling all constraints/triggers for a schema

Jeremy wrote:
> There are plenty of home-grown scripts for reading the data dictionary
> and then generating a "disable" or "enable" constraints script - is
> there any native functionality in Oracle though to do this?
>
> 9iR2 plus...
>
> --
> jeremy
>
> We use Oracle 9iR2 on Solaris 8 with the Oracle HTTP Server and
> mod_plsql

Depending on what exactly you want to accomplish, there's imp with constraints=n, or indexfile with constraints=y, see the utilities manual.

jg

--
@home.com is bogus.
"At this point, I get into a bag end. There must be some Oracle bug,
but I can't find where area problem lie. " - bug 3891092