-- -------------------------------------------------- -- Description : Compiles all invalid views for specified schema,or all schema. -- Call Syntax : @compile_all_views (schema-name or all) -------------------------------------------------------------- SET PAGESIZE 0 SET FEEDBACK OFF SET VERIFY OFF SPOOL temp.sql SELECT 'ALTER VIEW ' || a.owner || '.' || a.object_name || ' COMPILE;' FROM all_objects a WHERE a.object_type = 'VIEW' AND a.status = 'INVALID' AND a.owner = Decode(Upper('&&1'), 'ALL',a.owner, Upper('&&1')); SPOOL OFF -- Comment out following line to prevent immediate run @temp.sql SET PAGESIZE 14 SET FEEDBACK ON SET VERIFY ON
Compiles all invalid views for specified schema
Subscribe to:
Post Comments (Atom)
ORA-01552: cannot use system rollback segment for non-system tablespace 'TEMP'
ORA-01552: cannot use system rollback segment for non-system tablespace "string" Cause: Used the system rollback segment for non...
-
CONCURRENT MANAGER ISSUES IN APPS R12 Status code and Phase code for Concurrent requests Here is what the abbreviation for ...
-
How to clean FND_NODES table in R12.2.4 Step 1: Always apply the latest cloning patches to avoid all the bugs and fixes Step 2: ...
-
ora-00257: archiver error. connect as sysdba only until resolved. Error While Connecting db through SQL Developer... Cause The ...
No comments:
Post a Comment