Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Alter Database Question
On 6 Apr 2005 10:22:48 -0700, amerar_at_iwc.net wrote:
>We are using 8.1.7.3. Here are my results from running those scripts.
>I still must be missing something.
Did you run them *connected as internal* (which David already stated)
If you run
select object_name, owner from dba_objects where object_name =
'DBMS_OUTPUT'
who is the owner?
If SYS is not the owner you have a screwed datadictionary and nothing
will work, not only dbms_output.
-- Sybrand Bakker, Senior Oracle DBAReceived on Wed Apr 06 2005 - 12:38:17 CDT