OraFAQ Forum: Server Administration » disabled triggers and constraints

Home » RDBMS Server » Server Administration » disabled triggers and constraints (Oracle 10g R2, Solaris 10)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

disabled triggers and constraints [message #481003]

Fri, 29 October 2010 02:10

reym21
Messages: 241
Registered: February 2010
Location: Philippines

Senior Member

Sirs/ Madame:

What should I do with those disabled CONSTRAINTS (most were those file starts with LOGMNR) & TRIGGERS found on our production dB? Are there any impact once I enable those?

Thanks in advance.

Report message to a moderator

Re: disabled triggers and constraints [message #481005 is a reply to message #481003]

Fri, 29 October 2010 02:24

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

select 'alter table '||owner||'.'||table_name||' modify constraint '||constraint_name||' disable;' 
from dba_constraints
where ...

select 'alter trigger '||owner||'.'||trigger_name||' disable;' 
from dba_triggers
where ...

And execute the result.

Regards
Michel

Report message to a moderator

Re: disabled triggers and constraints [message #481006 is a reply to message #481005]

Fri, 29 October 2010 02:26

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

Are there any impact once I enable those?

It will take time and maybe some will not be able to be enabled if some modifications have been made that violate them.

Regards
Michel

Report message to a moderator

Previous Topic:	Need help in 'Gather Stats'
Next Topic:	Index rebuild grows database size

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 23 18:07:49 CST 2025