业务中出现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>

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/9240380/viewspace-666792/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/9240380/viewspace-666792/