Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Error in hotbackup script executed by other user then SYS
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