Re: Disable All constraints from application

From: Davide Gurgone <mortecerta_NOSPAM__at_libero.it>
Date: Wed, 22 Oct 2003 18:40:25 GMT
Message-ID: <taAlb.332997$R32.10979131@news2.tin.it>

> Don't ever EVER try to modify anything in the SYS or SYSTEM schema. You
> are lucky
> your SQL statement didn't work, it couldn't because it is totally
> unrelated to the issue at
> hand. If it had worked you'd have corrupted the database.
>
> I can help you disable constraints ... as can others ... but what
> bothers me is that anyone
> that would have tried what you tried should under no conditions be
> disabling any constraints
> anywhere: You just are not qualified to make that kind of decision or to
> understand the
> implications.
>
> Please post the reason why you want to disable the constraints. And if
> it seems reasonable
> someone will help you. Otherwise ... I would suggest that you should be
> protected from yourself.

Ok.

I whant to empty my database, using the truncate function. To do this I have to temporally disable the foreign key and constraints.

I whant to use truncate to have the same result as I Drop and recreate the table.

What can I do to do this??? Received on Wed Oct 22 2003 - 13:40:25 CDT