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脚本可以在数据库运行的状态下执行以编译、数据库中的invalid对象. oracle建议在对数据库进行迁移、升级、降级后都运行一遍utlrp.sql以编译无效对象。 --打完patch后重建数据字典视图脚本catpatch.sql 为了保证系统的的数据词典的完整性和有效性,最好的打patch后在migrate状态下运行catpatch.sql 【F:/oracle/...
when migrating a 32 bit database to a 64 bit database or vice-versa. THIS IS THE ACTUAL SCRIPT WHICH DOES THE REGENERATION OF COMPILED CODE. The actual series of steps can be checked reading the script which
The ultrp.sql script encounters the following error:CauseSign In To view full details, sign in with your My Oracle Support account. Register Don't have a My Oracle Support account? Click to get started!In this DocumentSymptomsCause