Newbie question

New to Oracle and having an apparent RI problem in SQL PLus.

Ran a script to create some tables. When I began to drop them (this is for a class) one would not drop citing an RI constraint.

I have a problem with a table in SQL Plus.

When I try to drop this table (Product), I get this

SQL> drop table Product;
drop table Product

           *
ERROR at line 1:
ORA-02449: unique/primary keys in table referenced by foreign keys

I thought I understood RI, but in this case......there are no other tables still existing. I went through the script that created the tables and checked every reference to this one.

Is there a command I can issue to determine what its talking about?

A describe yields this

SQL> describe Product

 Name                    Null?    Type
 ----------------------------------------- -------- 
 PROD_NUM          NOT NULL NUMBER
 ARTISTS_NAME               VARCHAR2(40)
 PROD_NAME                  VARCHAR2(40)
 PROD_TYPE                  VARCHAR2(10)
 YEAR_REL                   DATE

Any thoughts?

Thanks in advance. Received on Thu Sep 30 2004 - 15:49:15 CDT