Re: truncate problem

From: -=< a q u a b u b b l e >=- <aquabubble_at_Remove.No.Parma.Ham.Remove.geocities.com>
Date: Thu, 28 Oct 1999 00:28:07 +0100
Message-ID: <7v83mh$e12$1@news6.svr.pol.co.uk>

kev <kevin.porter_at_fast.no> wrote in message news:3816E7CE.D4DDAD11_at_fast.no...
> I forgot to mention that I have followed the 'Action' instructions from
> the 'oerr ora 02266' statement:
>
> *Action: Before performing the above operations the table, disable the
> // foreign key constraints in other tables. You can see what
> // constraints are referencing a table by issuing the following
> // command:
> // SELECT * FROM USER_CONSTRAINTS WHERE
> TABLE_NAME = "tabnam";

You should equate table_name to a string of upper case characters...

i.e. TABLE_NAME = 'TABNAM';

This should help. Received on Wed Oct 27 1999 - 18:28:07 CDT