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: truncate problem

Re: truncate problem

From: kev <kevin.porter_at_fast.no>
Date: Wed, 27 Oct 1999 14:23:50 +0100
Message-ID: <3816FCE6.1AA6DB46@fast.no>


Peter Marksteiner wrote:

> 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?

No. I have only created one user.

>
> Check (as SYSTEM) the all_constraints view.
>

OK, as SYS I did:

SELECT * FROM all_constraints where table_name = 'user1.headline'.

That returned an empty data set too.

Received on Wed Oct 27 1999 - 08:23:50 CDT

Original text of this message

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