業務中出現plsql打頭的表_plsql_profilter_runs

wisdomone1發表於2010-07-01
SQLFilter
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/，如需轉載，請註明出處，否則將追究法律責任。

相關文章