\u5982\u679c\u8bf4\u7248\u672c\u5f71\u54cd\u5f53\u524d\u7528\u6237\u53ef\u4ee5\u8bbf\u95ee\u7684\u5bf9\u8c61\u662f\u6b63\u5e38\u7684\uff0c\u4f46\u662f\u5bf9\u4e8eDBA_OBJECTS\u800c\u8a00\uff0c\u540c\u4e00\u4e2a\u7528\u6237\u4e0b\uff0c\u5728\u4e0d\u540c\u7248\u672c\u4e0b\u770b\u5230\u7684\u7ed3\u679c\u4e5f\u662f\u4e0d\u4e00\u6837\u7684\u3002
\n\u770b\u4e00\u4e2a\u7b80\u5355\u7684\u4f8b\u5b50\uff1a<\/p>\n
-bash-3.2$ sqlplus test\/test\r\nSQL*Plus: Release 11.2.0.2.0 Production on Thu Sep 15 21:04:58 2011\r\nCopyright (c) 1982, 2010, Oracle. All rights reserved.\r\nConnected to:\r\nOracle Database 11g Enterprise Edition Release 11.2.0.2.0 - Production\r\nWith the Partitioning, OLAP, Data Mining and Real Application Testing options\r\nSQL> set pages 100 lines 120\r\nSQL> create user u1 identified by u1 default tablespace users enable editions;\r\nUser created.\r\nSQL> grant connect, resource, dba to u1;\r\nGrant succeeded.\r\nSQL> conn u1\/u1\r\nConnected.\r\nSQL> select sys_context('USERENV', 'CURRENT_EDITION_NAME') from dual;\r\nSYS_CONTEXT('USERENV','CURRENT_EDITION_NAME')\r\n------------------------------------------------------------------------\r\nORA$BASE\r\nSQL> create or replace procedure p1 as \r\n 2 begin\r\n 3 null;\r\n 4 end;\r\n 5 \/\r\nProcedure created.\r\nSQL> create or replace procedure p2 as\r\n 2 begin\r\n 3 null;\r\n 4 end;\r\n 5 \/\r\nProcedure created.\r\nSQL> create or replace procedure p3 as\r\n 2 begin\r\n 3 null;\r\n 4 end;\r\n 5 \/\r\nProcedure created.\r\nSQL> create edition e2;\r\nEdition created.\r\nSQL> select count(*) from dba_objects;\r\n COUNT(*)\r\n----------\r\n 13565\r\nSQL> select object_name, edition_name \r\n 2 from dba_objects\r\n 3 where owner = user\r\n 4 and object_name like 'P_';\r\nOBJECT_NAME EDITION_NAME\r\n------------------------------ ------------------------------\r\nP3 ORA$BASE\r\nP2 ORA$BASE\r\nP1 ORA$BASE\r\nSQL> alter session set edition = e2; \r\nSession altered.\r\nSQL> select count(*) from dba_objects;\r\n COUNT(*)\r\n----------\r\n 13565\r\nSQL> drop procedure p2;\r\nProcedure dropped.\r\nSQL> create or replace procedure p1 as\r\n 2 begin\r\n 3 dbms_output.put_line('e2');\r\n 4 end;\r\n 5 \/\r\nProcedure created.\r\nSQL> select count(*) from dba_objects;\r\n COUNT(*)\r\n----------\r\n 13564\r\nSQL> select object_name, edition_name \r\n 2 from dba_objects\r\n 3 where owner = user\r\n 4 and object_name like 'P_';\r\nOBJECT_NAME EDITION_NAME\r\n------------------------------ ------------------------------\r\nP3 ORA$BASE\r\nP1 E2\r\nSQL> create or replace procedure p4 as\r\n 2 begin\r\n 3 null;\r\n 4 end;\r\n 5 \/\r\nProcedure created.\r\nSQL> select count(*) from dba_objects;\r\n COUNT(*)\r\n----------\r\n 13565\r\nSQL> select object_name, edition_name\r\n 2 from dba_objects\r\n 3 where owner = user\r\n 4 and object_name like 'P_';\r\nOBJECT_NAME EDITION_NAME\r\n------------------------------ ------------------------------\r\nP3 ORA$BASE\r\nP4 E2\r\nP1 E2\r\nSQL> alter session set edition = ora$base;\r\nSession altered.\r\nSQL> select count(*) from dba_objects;\r\n COUNT(*)\r\n----------\r\n 13565\r\nSQL> select object_name, edition_name\r\n 2 from dba_objects\r\n 3 where owner = user\r\n 4 and object_name like 'P_';\r\nOBJECT_NAME EDITION_NAME\r\n------------------------------ ------------------------------\r\nP3 ORA$BASE\r\nP2 ORA$BASE\r\nP1 ORA$BASE\r\nSQL> conn test\/test\r\nConnected.\r\nSQL> select count(*) from dba_objects;\r\n COUNT(*)\r\n----------\r\n 13565\r\nSQL> select object_name, edition_name\r\n 2 from dba_objects\r\n 3 where owner = 'U1'\r\n 4 and object_name like 'P_';\r\nOBJECT_NAME EDITION_NAME\r\n------------------------------ ------------------------------\r\nP3 ORA$BASE\r\nP2 ORA$BASE\r\nP1 ORA$BASE<\/pre>\n\u53ef\u4ee5\u770b\u5230\uff0cDBA_OBJECT\u89c6\u56fe\u662f\u7248\u672c\u5316\u7684\u89c6\u56fe\uff0c\u5373\u4f7f\u662f\u62e5\u6709DBA\u6743\u9650\u7684\u7528\u6237\u5728\u67e5\u8be2\u8fd9\u4e2a\u89c6\u56fe\u7684\u65f6\u5019\u4e5f\u53ea\u80fd\u770b\u5230\u5f53\u524d\u7248\u672c\u53ef\u89c1\u7684\u89c6\u56fe\uff0c\u56e0\u6b64DBA_OBJECTS\u89c6\u56fe\u4e0d\u5728\u5305\u62ec\u6570\u636e\u5e93\u4e2d\u6240\u6709\u7684\u5bf9\u8c61\uff0c\u5982\u679c\u60f3\u8981\u83b7\u53d6\u6570\u636e\u5e93\u4e2d\u5404\u4e2a\u7248\u672c\u7684\u6240\u6709\u5bf9\u8c61\uff0c\u67e5\u8be2DBA_OBJECTS_AE\u89c6\u56fe\uff1a<\/p>\n
SQL> select object_name, edition_name\r\n 2 from dba_objects_ae\r\n 3 where owner = 'U1'\r\n 4 and object_name like 'P_';\r\nOBJECT_NAME EDITION_NAME\r\n------------------------------ ------------------------------\r\nP3 ORA$BASE\r\nP2 ORA$BASE\r\nP1 ORA$BASE\r\nP4 E2\r\nP2 E2\r\nP1 E2\r\n6 rows selected.<\/pre>\n","protected":false},"excerpt":{"rendered":"\u5982\u679c\u8bf4\u7248\u672c\u5f71\u54cd\u5f53\u524d\u7528\u6237\u53ef\u4ee5\u8bbf\u95ee\u7684\u5bf9\u8c61\u662f\u6b63\u5e38\u7684\uff0c\u4f46\u662f\u5bf9\u4e8eDBA_OBJECTS\u800c\u8a00\uff0c\u540c\u4e00\u4e2a\u7528\u6237\u4e0b\uff0c\u5728\u4e0d\u540c\u7248\u672c\u4e0b\u770b\u5230\u7684\u7ed3\u679c\u4e5f\u662f\u4e0d\u4e00\u6837\u7684\u3002 \u770b\u4e00\u4e2a\u7b80\u5355\u7684\u4f8b\u5b50\uff1a -bash-3.2$ sqlplus test\/test SQL*Plus: Release 11.2.0.2.0 Production on Thu Sep 15 21:04:58 2011 Copyright (c) 1982, 2010, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 – Production With the Partitioning, OLAP, Data Mining … Continue reading