ORA-02266: unique/primary keys in table referenced by enabled foreign keys

select OWNER, TABLE_NAME, CONSTRAINT_NAME from dba_constraints
  where R_CONSTRAINT_NAME in
    (select CONSTRAINT_NAME from dba_constraints
      where TABLE_NAME='SYSTEMTRACE' and CONSTRAINT_TYPE in ('P','U'));

SQL> desc SYSTEMTRACE
 Name                                 Null?    Type                                                                             
 ------------------------------------ -------- ---------------
 RNO                                  NOT NULL NUMBER(10)                                                                             
 DBDATETIMESTAMP                      NOT NULL TIMESTAMP(2)                                                                             
 DBUSERID                                      VARCHAR2(30)                                                                             
 DBSESSIONID                                   NUMBER                                                                             
 DBSESSIONSERIALNUM                            NUMBER                                                                             
 DBINSTANCE                                    NUMBER                                                                             
 DBSCHEMA                                      VARCHAR2(30)                                                                             
 DBLOGGROUPKEY                                 NUMBER                                                                             
 DBLOGGROUPKEYSOURCE                           NUMBER(2)                                                                             
 SOURCEPACKAGENAME                             VARCHAR2(100)                                                                             
 SOURCEPACKAGEVERSION                          VARCHAR2(100)                                                                             
 SOURCEOBJECTDESCRIPTION                       VARCHAR2(255)                                                                             
 SOURCETYPE                                    NUMBER(5)                                                                             
 LOGCODE                                       VARCHAR2(10)                                                                             
 LOGMSG                                        VARCHAR2(4000)                                                                             
 ERRSTACK                                      VARCHAR2(4000)                                                                             
 LOGTRACE                                      TYPTRACE

SQL> desc TYPTRACE
 TYPTRACE TABLE OF TRACERECORD
 Name                           Null?    Type                                                                                   
 --------------------------------------- ----------------------------------------------------------------------------------------------- ---------------------------------------------------------------
 VAR                                     VARCHAR2(30)                                                                                   
 EXP                                     VARCHAR2(255)                                                                                   
 REM                                     VARCHAR2(50)                                                                                   
 TRACENO                                 NUMBER(10)                                                                                   

METHOD
------
 FINAL CONSTRUCTOR FUNCTION TRACERECORD RETURNS SELF AS RESULT
 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 VAR                            VARCHAR2                IN
 EXP                            VARCHAR2                IN
 REM                            VARCHAR2                IN     DEFAULT

SQL> create table qwe (dat date, s TYPTRACE) nested table s store as sss
partition by list (dat)
(PARTITION one VALUES (TO_DATE('1-7-2007', 'DD-MM-YYYY')),
PARTITION two VALUES (TO_DATE('2-7-2007', 'DD-MM-YYYY')));

Table created.

SQL> insert into qwe select TO_DATE('1-7-2007', 'DD-MM-YYYY'), null from dual;

1 row created.

SQL> insert into qwe select TO_DATE('2-7-2007', 'DD-MM-YYYY'), null from dual;

1 row created.

SQL> commit;

Commit complete.

SQL> alter table qwe drop partition two;

Table altered.

SQL> drop table tctdbs.qwe;

Table dropped.

SQL> create table qwe (dat date, s tctdbs.TYPTRACE) nested table s store as sss
(( PRIMARY KEY ("NESTED_TABLE_ID", "TRACENO") ENABLE) ORGANIZATION INDEX) RETURN AS VALUE
partition by list (dat)
(PARTITION one VALUES (TO_DATE('1-7-2007', 'DD-MM-YYYY')),
PARTITION two VALUES (TO_DATE('2-7-2007', 'DD-MM-YYYY')));

Table created.

SQL> insert into qwe select TO_DATE('1-7-2007', 'DD-MM-YYYY'), null from dual;

1 row created.

SQL> insert into qwe select TO_DATE('2-7-2007', 'DD-MM-YYYY'), null from dual;

1 row created.

SQL> commit;

Commit complete.

SQL> alter table qwe drop partition two;
alter table tctdbs.qwe drop partition two
*
ERROR at line 1:
ORA-02266: unique/primary keys in table referenced by enabled foreign keys