Home » Infrastructure » Unix » Help for writing Unix Script for selecting oracle tables
Help for writing Unix Script for selecting oracle tables [message #97670] Wed, 30 October 2002 03:43 Go to next message
Dev
Messages: 28
Registered: May 2001
Junior Member
Hi All,

I am trying to query on oracle v$archived_log table from unix script. But as $ is a special character in unix script, I am getting error table or view does not exists. (it just takes v and ignores other part). COuld any one let me know how this can be done.

Also, I am performing online backup of database once in a day and want to copy archived logs on hourly basis. How can I copy the logs which are created on hourly basis and not the all archived logs.

Thanks in advance .

Regards,
-D

Report message to a moderator

Re: Help for writing Unix Script for selecting oracle tables [message #97671 is a reply to message #97670] Wed, 30 October 2002 11:24 Go to previous message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
Just escape it:
select * from v$archived_log

Report message to a moderator

Previous Topic: Unixware 7 tar utility
Next Topic: calculate time in seconds
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Apr 23 10:48:20 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.