OraFAQ Forum: Unix » script not recognising charcters after $

Home » Infrastructure » Unix » script not recognising charcters after $

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

script not recognising charcters after $ [message #357257]

Tue, 04 November 2008 08:32

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

Report message to a moderator

Re: script not recognising charcters after $ [message #357264 is a reply to message #357257]

Tue, 04 November 2008 08:52

Mahesh Rajendran
Messages: 10706
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Just escape the "$" inside your shell script.
Something like
v\$tablespace

Report message to a moderator

Re: script not recognising charcters after $ [message #357362 is a reply to message #357264]

Wed, 05 November 2008 01:13

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

Report message to a moderator

Re: script not recognising charcters after $ [message #357368 is a reply to message #357362]

Wed, 05 November 2008 01:27

Michel Cadot
Messages: 68415
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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Mar 21 13:36:43 CDT 2023