DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: i want to conncet to sqlplus with run sql..

  1. 05-14-2006, 01:32 PM #1
    lvikel2
    lvikel2 is offline Junior Member
    Join Date
    May 2006
    Posts
    11

    i want to conncet to sqlplus with run sql..

    i write

    sqlplus sys/manager as sysdba@dropcr.sql

    and he cant do it

    he connect and didnt run my sql
    and i didnt want to run @dropcr.sql from sql prompt

    i want to di this is one line

    plz help
    Reply With Quote Reply With Quote
  2. 05-14-2006, 04:12 PM #2
    davey23uk
    davey23uk is offline Senior Advisor
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    your statements contradict themselves - what do you actualy want?

    sqlplus "sys/manager as sysdba" @dropcr.sql
    Reply With Quote Reply With Quote
  3. 05-14-2006, 04:14 PM #3
    DaPi's Avatar
    DaPi
    DaPi is offline Old Cranky Philosopher
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    I think you have omitted a space before the @
    "The power of instruction is seldom of much efficacy except in those happy dispositions where it is almost superfluous" - Gibbon, quoted by R.P.Feynman
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width