This worked! Thank you. ________________________________ From: Allen, Brandon [mailto:Brandon.Allen@xxxxxxxxxxx] Sent: Monday, October 06, 2008 11:07 AM To: Blanchard William; oracle-l@xxxxxxxxxxxxx Subject: RE: Deprecated parameter Does this work? alter system reset plsql_compiler_flags scope=spfile sid='*'; You can try scope=memory too, but I'm not sure if that works or not - probably depends on whether or not it's a dynamic parameter, but I'm not sure if that always applies in the case of reset as it does for set. Regards, Brandon