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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Error in hotbackup script executed by other user then SYS

Re: Error in hotbackup script executed by other user then SYS

From: Miguel Urosa Ruiz <mur16_at_tid.es>
Date: Tue, 31 Oct 2000 09:59:34 +0100
Message-Id: <10666.120648@fatcity.com>

    What about to execute catdbsyn.sql script?

    HTH     Regards, Miguel.

Skurský Michal wrote:

> Hello,
> I have a script (hotbackup from
> http://ora.dbasupport.com/oracle/scripts/Detailed/148.shtml) in which cursor
> is (for example) declared:
>
> ....
> cursor sidname is
> select name
> from v$database;
> ...
> ...
> begin
> open sidname;
> loop
> fetch sidname into zsidname;
> exit when sidname %notfound;
> end loop;
> ...
> ...
>
> This script can be executed only from user SYS. With other users (with DBA
> role, for example system) generates a series of errors, for example:
>
> Creating hotbackup script...
> from v$database;
> *
> ERROR on row 5:
> ORA-06550: row 5, column 6:
> PLS-00201: identificator 'SYS.V$DATABASE' must be declared
>
> What privilege have to be granted to the user or where is the problem.
>
> Thanks Michal
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: =?iso-8859-2?Q?Skursk=FD_Michal?=
> INET: skursky_at_brn.pvt.cz
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Tue Oct 31 2000 - 02:59:34 CST

Original text of this message

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