Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: renaming Constraints
<SPAN
class=451574413-19112001>Presumably if it is development then the developers
should be preparing proper scripts to create the objects once the names and
definitions are finalised.
Just
ask them for the latest set of scripts and then write some dynamic sql to drop
the constraints and then run the scripts to recreate the
objects.
<SPAN
class=451574413-19112001>
I
would not start updating the data dictionary directly if I were you. Totally
unsupported, undesirable and unnecessary in this (and most )
cases.
<SPAN
class=451574413-19112001>
<SPAN
class=451574413-19112001>John
<FONT face="Times New Roman"
size=2>-----Original Message-----From: Arslan Dar
[mailto:arslandar_at_skm.org.pk]Sent: 19 November 2001
11:11To: Multiple recipients of list ORACLE-LSubject:
renaming Constraints
Hi list, <FONT
face="Courier New" size=2>is there any easiar way to rename a constraint other
then dropping and then recreating it, <FONT face="Courier New"
size=2>cuz in our environment, developers mess up the constraints with naming
them using system assigned names and then after finilizing the tables and
relations, i have to drop/recreate all the constraints following the naming
convetion for them.
is there any easiar way, like updating the
data dictionary directly, any harm in that, if not, which are the key tables i
am supposed to play with?
Thanks in Advance
Arslan
![]() |
![]() |