Re: truncate problem

From: Peter Marksteiner <Peter.Marksteiner_at_univie.ac.at>
Date: 27 Oct 1999 13:01:08 GMT
Message-ID: <7v6t2k$2hp2$1@www.univie.ac.at>

In comp.databases.oracle.misc kev <kevin.porter_at_fast.no> wrote:
: 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";

: but the above query returns an empty set of data.

Possibly there is a constraint referencing this table in some other user's schema. Did you "grant references" on this table to somebody? Check (as SYSTEM) the all_constraints view.

Peter
--
Peter Marksteiner
Vienna University Computer Center Received on Wed Oct 27 1999 - 08:01:08 CDT