000028886 - KB-1230 Rebuilding Views and Triggers

Document created by RSA Customer Support Employee on Jun 14, 2016Last modified by RSA Customer Support Employee on Apr 21, 2017
Version 2Show Document
  • View in full screen mode

Article Content

Article Number000028886
Applies ToAffected Versions: All Versions
ResolutionThe attached document covers how to rebuild Views and Triggers
To Rebuild Invalid Views:
1. Become the oracle user
2. Change directories to /home/oracle/database
3. Invoke sqlplus (sqlplus avuser/secret)
4. Run this command
SQL>@Recompile_Invalid_Views.sql
For Invalid Packages:
1. Become the oracle user
2. Change directories to /home/oracle/database
3. Invoke sqlplus (sqlplus avuser/secret)
4. Run this command
SQL>@Rebuild_Packages.sql

For Invalid Triggers:
1. Become the oracle user
2. Invoke sqlplus (sqlplus avuser/secret)
3. Run this command to determine the invalid triggers:
SQL> select object_type, object_name, status from user_objects where status = 'INVALID';
4. Recompile each invalid trigger using this sql:
SQL> ALTER TRIGGER <TRIGGER_NAME_REPLACE_WITH_INVALID_TRIGGER> COMPILE;


The attached script can be used to automate the process of recompling the packages, triggers and views.
The script is provided "AS IS"
 

Attachments

    Outcomes