Home » Infrastructure » Unix » script not recognising charcters after $
script not recognising charcters after $ [message #357257] Tue, 04 November 2008 08:32 Go to next message
diamond
Messages: 26
Registered: July 2008
Junior Member
hi,

my script is running an SQL command and is givin an error as.. it is not recognising the history after $:

select * from registry$history;

the error states:

no such view or table as registry


same error seen when queried for

V$tablespace

as no table or view by the name V
Re: script not recognising charcters after $ [message #357264 is a reply to message #357257] Tue, 04 November 2008 08:52 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Just escape the "$" inside your shell script.
Something like
v\$tablespace
Re: script not recognising charcters after $ [message #357362 is a reply to message #357264] Wed, 05 November 2008 01:13 Go to previous messageGo to next message
diamond
Messages: 26
Registered: July 2008
Junior Member
i have done that. but stil the same error:


in the script...
select * from registry\$history;

output...

select * from registry
*
ERROR at line 1:
ORA-00942: table or view does not exist
Re: script not recognising charcters after $ [message #357368 is a reply to message #357362] Wed, 05 November 2008 01:27 Go to previous message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Without the actual script and what you did with it, how can one help you?

Regards
Michel
Previous Topic: unix shell script to execute procedure with passing parameters
Next Topic: How to see status of instances (up / down / open)
Goto Forum:
  


Current Time: Thu Mar 28 06:41:07 CDT 2024