Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: truncate problem
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.