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

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

Error in hotbackup script executed by other user then SYS

From: Skurský Michal <skursky_at_brn.pvt.cz>
Date: Tue, 31 Oct 2000 08:49:17 +0100
Message-Id: <10665.120640@fatcity.com>


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. Received on Tue Oct 31 2000 - 01:49:17 CST

Original text of this message

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