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 -> Re: Disable All constraints from application

Re: Disable All constraints from application

From: Brian Peasland <dba_at_remove_spam.peasland.com>
Date: Wed, 22 Oct 2003 16:02:19 GMT
Message-ID: <3F96AA0B.DEC8A804@remove_spam.peasland.com>


Niall gave you the answer. You have to create a script to disable your constraints, then run that script. He gave you the SQL statement required to create the script.

HTH,
Brian

Davide Gurgone wrote:
>
> > Updating the data dictionary directly is a terrible terrible idea. You
> > wouldn't hex edit the file allocation table on a windows system to delete
> a
> > file would you?
>
> No I only whant to zero my database, having only void table.
>
> What can I do this???

-- 
===================================================================

Brian Peasland
dba_at_remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
 the three"
Received on Wed Oct 22 2003 - 11:02:19 CDT

Original text of this message

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