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-l

Other related posts: