OraFAQ Forum: SQL & PL/SQL » Add Check Constraints to table

Home » SQL & PL/SQL » SQL & PL/SQL » Add Check Constraints to table (10.2.0.4.0 ,windows)

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

Add Check Constraints to table [message #423681]

Sat, 26 September 2009 08:05

Mohan10g
Messages: 159
Registered: May 2009
Location: INDIA

Senior Member

Hi All,

I dropped following check constraints for table rebuild.Can anyone let me know
how to add again these check constraints to columns?

Alter table test_2 drop constraint SYS_D006190;
Alter table test_2 drop constraint SYS_D006190;

Regards,

Report message to a moderator

Re: Add Check Constraints to table [message #423685 is a reply to message #423681]

Sat, 26 September 2009 08:53

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Flashback Recovery, Recycle Bin, or LOGMINER might be able to save you.
The problem is nobody know what the Constraints really were & on which columns they existed.

Ready, Fire, Aim!

[Updated on: Sat, 26 September 2009 08:54]

Report message to a moderator

Re: Add Check Constraints to table [message #423688 is a reply to message #423681]

Sat, 26 September 2009 08:59

ebrian
Messages: 2794
Registered: April 2006

Senior Member

ALTER TABLE <table_name> ADD (CHECK (<column_name> <condition>);

Report message to a moderator

Re: Add Check Constraints to table [message #423694 is a reply to message #423688]

Sat, 26 September 2009 10:26

Mohan10g
Messages: 159
Registered: May 2009
Location: INDIA

Senior Member

Thanks for your response and was useful.

Regards,

Report message to a moderator

Re: Add Check Constraints to table [message #423698 is a reply to message #423694]

Sat, 26 September 2009 12:45

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

Senior Member
Account Moderator

Mohan10g wrote on Sat, 26 September 2009 17:26

Thanks for your response and was useful.
Regards,

So maybe a link to Database SQL Reference would also be.
To read before your next question.

Regards
Michel

Report message to a moderator

Re: Add Check Constraints to table [message #423700 is a reply to message #423698]

Sat, 26 September 2009 14:17

Mohan10g
Messages: 159
Registered: May 2009
Location: INDIA

Senior Member

Thanks michel....

Report message to a moderator

Re: Add Check Constraints to table [message #424146 is a reply to message #423694]

Wed, 30 September 2009 06:00

lakshmi veena
Messages: 4
Registered: March 2009
Location: Bangalore

Junior Member

Can you please let us know how you recovered the deleted constraints. So it will be useful for the learners.

[Updated on: Wed, 30 September 2009 06:05]

Report message to a moderator

Re: Add Check Constraints to table [message #424151 is a reply to message #424146]

Wed, 30 September 2009 06:08

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

Senior Member
Account Moderator

You cannot recover a dropped constraint, you can just recreate it (unless you want to recover the whole database up to before drop).

Regards
Michel

Report message to a moderator

Re: Add Check Constraints to table [message #424155 is a reply to message #424151]

Wed, 30 September 2009 06:19

lakshmi veena
Messages: 4
Registered: March 2009
Location: Bangalore

Junior Member

Thanks Michel,

I have one more question,
If we drop a table from the database, it will drop all the (say dependent objects like views,constraints,Indexes) on that table also. I hope we can recover a dropped table by using 10g. If so, will it recovers the dependent objects also.

Please correct me If I am wrong

[Updated on: Wed, 30 September 2009 06:24]

Report message to a moderator

Re: Add Check Constraints to table [message #424160 is a reply to message #424155]

Wed, 30 September 2009 06:27

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

Senior Member
Account Moderator

Yes, if you drop a table then you drop the constraint and can recover both of them using recycle bin (if it is active).

Regards
Michel

Report message to a moderator

Re: Add Check Constraints to table [message #424161 is a reply to message #424160]

Wed, 30 September 2009 06:28

lakshmi veena
Messages: 4
Registered: March 2009
Location: Bangalore

Junior Member

Thanks Michel....

Report message to a moderator

Previous Topic:	ora 00600 internal error
Next Topic:	Extract a Specific Pattern From Random Data

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Feb 08 16:54:33 CST 2025