Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Generating SQL to recreate constraints.

Generating SQL to recreate constraints.

From: NetComrade <andreyNSPAM_at_bookexchange.net>
Date: Mon, 04 Oct 1999 18:35:55 GMT
Message-ID: <37f8f33a.524585683@news.earthlink.net>


Hi,

Anybody has a nice script to regenerate all constraints on a table? Dealing with CHECK constraint is a bitch, it is stored in LONG. (SEACH_CONDITION)
Also dealing with catentated indexes/constraints is tough, b/c of position.

Thanx.


Andrey Dmitriev	 eFax: (978) 383-5892  Daytime: (917) 373-5417
AOL: NetComrade	 ICQ: 11340726 remove NSPAM to email

Received on Mon Oct 04 1999 - 13:35:55 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US