문서의 이전 판입니다!
SQL> SELECT * FROM dba_objects WHERE object_type = 'INDEX' AND owner='BEFLYDBA' ORDER BY created DESC
SQL> SELECT * FROM user_ind_columns WHERE index_name LIKE 'DR%';
SQL> SELECT comp_name, version, STATUS FROM dba_registry; COMP_NAME VERSION STATUS ------------------------------ --------------- ---------------------- Oracle Enterprise Manager 10.2.0.1.0 VALID Spatial 10.2.0.1.0 VALID Oracle interMedia 10.2.0.1.0 LOADING OLAP Catalog 10.2.0.3.0 VALID Oracle XML DATABASE 10.2.0.3.0 VALID Oracle Text 10.2.0.3.0 VALID Oracle Expression FILTER 10.2.0.1.0 VALID Oracle Rules Manager 10.2.0.1.0 VALID Oracle Workspace Manager 10.2.0.1.0 VALID Oracle DATA Mining 10.2.0.3.0 VALID Oracle DATABASE Catalog Views 10.2.0.3.0 VALID Oracle DATABASE Packages AND T 10.2.0.3.0 VALID ypes JServer JAVA Virtual Machine 10.2.0.3.0 VALID Oracle XDK 10.2.0.3.0 VALID Oracle DATABASE Java Packages 10.2.0.3.0 VALID OLAP Analytic Workspace 10.2.0.3.0 VALID Oracle OLAP API 10.2.0.3.0 VALID 17 ROWS selected.