Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.tools -> disabling foreign keys
I want to write a script that disables all foreign keys at once. I have tried the following
update
user_constraints
set
status = 'DISABLED'
where
constraint_name like 'ITX%FK_' ;
(all foreign key names follow a regular pattern) This produces an error message : insufficient privileges.
I think the problem is that I have insufficient priveliges set to do this. Our sysadmin says that it can't be done at all. Is he right? If so, is there any other way of doing it?
-- _____________________________ /___________________________(_) | ___________________________ email to | | |________________________(_) Peter_Morris_1 | |/__________________________ at Hotmail dot com |___________________________(_)Received on Wed May 30 2001 - 07:05:15 CDT
![]() |
![]() |