Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Querying V$ views within scripts
> it seems to work fine and do what it's supposed to do. The problem is
> that if I try to query a v$view at anytime in the script (e.g. select
> * from v$backup; to confirm that the tablespaces are in backup mode)
> it reports that the view does not exist. If I run exactly the same
> commands interactively then the select from the v$ view works
> perfectly.
>
> I've tried specifying, for example, sys.v$backup but still get the same error.
>
> Presumably there's something blatantly obvious that I'm missing.
> Anyone come accross this or have any thoughts on what it might be?
probably you've missed "\" before $.
i.e. you need to write v\$backup instead of v$backup in your shell script.
Egor
http://www.oracledba.ru/orasrp/
Free Oracle Session Resource Profiler
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Dec 14 2004 - 06:40:59 CST
![]() |
![]() |