SQL> select * from tab where tname like 'PL%';
TNAME TABTYPE CLUSTERID
------------------------------ ------- ----------
PLSQL_PROFILER_DATA TABLE
PLSQL_PROFILER_RUNS TABLE
PLSQL_PROFILER_UNITS TABLE
------------------------------ ------- ----------
PLSQL_PROFILER_DATA TABLE
PLSQL_PROFILER_RUNS TABLE
PLSQL_PROFILER_UNITS TABLE
SQL> drop table PLSQL_PROFILER_DATA purge;
Table dropped.
SQL> drop table PLSQL_PROFILER_RUNS purge;
drop table PLSQL_PROFILER_RUNS purge
*
ERROR at line 1:
ORA-02449: unique/primary keys in table referenced by foreign keys
drop table PLSQL_PROFILER_RUNS purge
*
ERROR at line 1:
ORA-02449: unique/primary keys in table referenced by foreign keys
SQL> drop table PLSQL_PROFILER_RUNs purge;
drop table PLSQL_PROFILER_RUNs purge
*
ERROR at line 1:
ORA-02449: unique/primary keys in table referenced by foreign keys
SQL> drop table PLSQL_PROFILER_UNITS purge;
Table dropped.
SQL> drop table PLSQL_PROFILER_RUNs purge;
Table dropped.
SQL>