Re: Set set serveroutput on , Dbms_output.put_line do not work when database is not open

On 21 Mar 2007 19:38:22 -0700, dbaplusplus_at_hotmail.com wrote:

>For quite some time, I had no idea why these error messages come,
>finally I figured out it is because database is not open. What is work
>around? I ended up only using sql statements instead of PL/SQL (seems
>a serious limitation). I could probably open database in read only
>mode and then switch to standby mode but that is cumbersome.
>
>Any pointers are welcome.

As 'dbaplusplus' you should know 8.1.6 was *extreemly* buggy, so that it was withdrawn by Oracle in less than a year. So I could see several workarounds
- stop trying to hack yourself out and use managed recovery - state clearly to your management what the consequences are of continuing to use 8.1.6
- Drop the 'dbaplusplus' nick and stop bothering us with problems that only Oracle could, but won't, resolve.

-- 
Sybrand Bakker
Senkior Oracle DBA