业务中出现plsql打头的表_plsql_profilter_runs

SQL> select * from tab where tname like 'PL%';
TNAME                          TABTYPE  CLUSTERID
------------------------------ ------- ----------
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

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>
请使用浏览器的分享功能分享到微信等