Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Alter Database Question

Re: Alter Database Question

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Wed, 06 Apr 2005 19:38:17 +0200
Message-ID: <ch7851p6v2k50lbq426e8pu8iajvgelq2q@4ax.com>


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 DBA
Received on Wed Apr 06 2005 - 12:38:17 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US