Alter function <owner>.<function_name> compile; Alter view <owner>.<view_name> compile; Alter package <owner>.<package_name> compile; Alter package <owner>.<package_name> compile body; Alter materialized view <owner>.<Package_name> Compile; In case you have lots of invalid objects,you ca...
Alter function <owner>.<function_name> compile; Alter view <owner>.<view_name> compile; Alter package <owner>.<package_name> compile; Alter package <owner>.<package_name> compile body; Alter materialized view <owner>.<Package_name> Compile; In case you have lots of invalid objects,you ca...
select owner,object_name,object_type,status from dba_objects where STATUS='INVALID'; 1. Compile all the objects of the database using UTLRP.SQL. This script may take some time, depending on the number of objects. @$ORACLE_HOME/rdbms/admin/utlrp.sql 2. Compile objects of a particular sche...
2.Build-in scripts to recompile the invalid objects. We now have a supported script utlrp.sql located in the $ORACLE_HOME/rdbms/admin/utlrp.sql to do recompile for us. Below code will list out all the current invalid object and run utlrp.sql to compile all of them. COLUMNowner format ...
SQL> select * from dba_objects t where t.status = 'INVALID' order by 1; 1. 2.编译无效对象 select 'alter '||object_type||' '||owner||'.'||object_name||' compile;' from dba_objects t where t.status = 'INVALID' order by 1; ...
也就是说,这个脚本的作用是使数据库中的PL/SQL对象INVALID,然后通过utlrp.sql的重新编译,消除跨平台的兼容性影响。按照transport.sql脚本提示的步骤,我们可以重新启动数据库来执行utlrp.sql脚本(由于本例涉及到版本迁移,需要再次启动数据库到UPGRADE模式,如果数据库版本相同,则可以直接启动数据库,执行utlrp.sql脚本完成...
Compile invalid objects Rebuild unusable indices Refresh materialized view (conditional) Back up the database (recommended) Drop MRC schema (conditional) Disable database auditing (recommended) Ensure that Maintenance Mode is enabled (Required) Apply AD Release 12.2 upgrade driver (Required) ...
2. Otherwise, execute the script utlrp.sql.The script will compile all invalid objects in the database.SQL> @?/rdbms/admin/utlrp.sql Verify that there are no invalid objects:SQL> select count(*) from dba_objects where status <> 'VALID' and owner='PLM'; ...
Recompile INVALID Objects Step 7: Post-upgrade Setting Environment variables on Linux and Unix Update oratab entries Post-upgrade fixup script Create or Migrate Your Password File with ORAPWD Recovery Catalog Upgrade Upgrade the Time Zone File Version After Upgrading Oracle Database ...
Re-compile Invalid Objects Run the script to recompile all invalid PL/SQL packages now instead of when the packages are accessed for the first time. This step is optional but recommended. Enabling Archive Logs in a RAC Environment Whether a single instance or clustered database, Oracle tracks...