脚本utlrp.sql主要用于编译无效包。执行期间主要调用utlprp.sql脚本。相关代码如下所示:Rem ===...
$ sqlplus '/as sysdba' @?/rdbms/admin/utlrp.sql 【F:/oracle/product/10.2.0/db_1/RDBMS/ADMIN】 utlrp.sql脚本可以在数据库运行的状态下执行以编译、数据库中的invalid对象. oracle建议在对数据库进行迁移、升级、降级后都运行一遍utlrp.sql以编译无效对象。 --打完patch后重建数据字典视图脚本catpatch.sql...
-> UTLRP.SQL - Validates all invalid objects and can be run anytime.(this in-turn is called by utlirp.sql)-> UTLIRP.SQL - Simply calls utlip.sql and utlrp.sql(9i only)which MUST be run during WORD-SIZE conversion(If utlip.sql is not run manually)and during normal validating of inv...
Oracle Database Cloud Service - Version N/A and later: UTLRP.SQL Encounters ORA-32044 ORA-06512
I'im getting bellow error while running utlrp.sql Windows 7 Professional 64bit SP1 64bit Oracle database is 64bit 11.2.1.0.4, duplicated from a 32bit database 11.2.0.4 I tried bouncing database but same error.Anyone had this error before or any idea what to do?
Running utlrp.sql for validating objects, the script may fail with Changes In the session running utlrp.sql script , "set scan off" was previously set. Cause Sign In To view full details, sign in with your My Oracle Support account. Register Don't have a My Oracle Support account?
Running the UTLRP.SQL Script Quick question, is it OK to run this script while the database is up and running and users are accessing it? This is an HP-UX 11.00 OS running an Oracle 8.1.7 database. Long time dabbler, first time Admin / DBA Solved! Go to Solution....
utlrp.sql和catpatch.sql两个脚本的作用 --打完patch后重建数据字典视图脚本catpatch.sql 为了保证系统的的数据词典的完整性和有效性,最好的打patch后在migrate状态下运行catpatch.sql sql> shutdown immediate sql> shutdown immediate sql> startup 为加快速度,可临时调大这2个参数:...
每次Mac版的火狐浏览器有新版,我都是第一时间更新,但是依然没有解决经常打不开网页的问题,尝试了很多办法都没解决[允悲]
医生,我用了两三天甲硝锉栓感觉有好转的迹象,网上买的柑橘黄酮片还没到。 我这两天晚上便后用高锰酸钾片兑水注射进肛门去停留一下然后拉出来(听说这个有腐蚀性,已经用了三天,考虑要不要再用几天),接着还在用盐水坐浴,最后睡前塞一个甲硝锉栓,现在塞了三天了。 白天不大便的话坠胀感基本没有了(由于这几天...