Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Disable All constraints from application
Hi All,
I hope I'm not OT :o!
I've got a problem, I need to disable temporally all constraints in one specific schema, but the script I do doesn't work:
UPDATE USER_CONSTRAINTS
SET STATUS = 'DISABLED'
WHERE R_OWNER = 'OWNER'
COMMIT;
I need it to Truncate every table in my shema.
If someone has got another idea, I'm happy to implement it!!!
Thanks all!
Davide Received on Wed Oct 22 2003 - 10:02:41 CDT