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博客

业务中出现plsql打头的表_plsql_profilter_runs

最新文章