$table handle in Shell script
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: $table handle in Shell script

  1. #1
    Join Date
    Dec 2001
    Posts
    203
    Hi ,

    I just want to write the following shell script.

    Shell Script
    ========
    sqlplus system/manager < select * from v$logfile;
    EOF


    But when I am executing the same , getting error for : table v does not exist.

    Because unix is understanding "$logfile" as a PARAMETER.

    How to overcome this problem?

    Thanks

    sumit

  2. #2
    Join Date
    Dec 2001
    Posts
    203
    Hi all,

    Sorry ......

    Read it as

    sqlplus system/manager < < EOF

    select * from v$logfile;

    EOF


    Thanks
    sumit

  3. #3
    Join Date
    Jul 2002
    Location
    Washington DC
    Posts
    110
    HI,

    select * from v\$logfile.

    Manoj

  4. #4
    Join Date
    Dec 2001
    Posts
    203
    Hi Monoj,

    Thanks

    Sumit
    sumit

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width