1 2 3 4 5 6 7 8 | SQL> select * from v$version; BANNER ---------------------------------------------------------------- Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bi PL/SQL Release 10.2.0.5.0 - Production CORE 10.2.0.5.0 Production TNS for 64-bit Windows: Version 10.2.0.5.0 - Production NLSRTL Version 10.2.0.5.0 – Production |
1 | SQL> select * from dba_registry_history; |
1 | SQL> SELECT sum(OBJECT_NAME)N1 FROM DBA_OBJECTS WHERE STATUS= 'INVALID'; |
1 | Sql >@?/rdbms/admin/utlrp.sql |
1 | SQL> SELECT sum(OBJECT_NAME)N2 FROM DBA_OBJECTS WHERE STATUS= 'INVALID'; |
1 | sql>@E:\13460968\files\Bundle\Patch14\catcpu.sql |
1 | Sql >@?/rdbms/admin/utlrp.sql |
1 | SQL> SELECT sum (OBJECT_NAME)N3 FROM DBA_OBJECTS WHERE STATUS='INVALID'; |
1 | select * from dba_registry_history; |
1 | Sql>@E:\13460968\files\Bundle\Patch14\ catcpu_rollback.sql |
张兴康 发表于 2016-10-31 14:04
干货,不错,已收藏
张兴康 发表于 2016-10-31 14:04
干货,不错,已收藏
欢迎光临 度量快速开发平台-专业、快速的软件定制快开平台 (http://p.delit.cn/) | Powered by Discuz! X3.2 |