Database Administration (MOSC)

MOSC Banner

Recompilation of all database views really necessary after apply CPU with view_recompile_jan2008cpu.

edited Jan 20, 2009 3:47AM in Database Administration (MOSC) 1 comment
Hi all,
is it really necessary to apply the view_recompile_jan2008cpu.sql patch, after a CPUJAN2008 apply?
Please correct me, but i think this is only necessary to fix the possible security holes in views, not for functionality reasons. Correct?

Why i ask? Simple, if i have a RAC cluster and want to do a update, i cant apply this CPU's as a rolling upgrade. 
view_recompile_jan2008cpu.sql wants the database in upgrade mode.

Best Regards,
Jens

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center