sqlplus default script directory

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • massimo874

    sqlplus default script directory

    Please some one can tell me wich is the SQLPlus default script directory an
    how I can set it.
    I tryed by 'Define' but SQLPlus don't find the scripts I give it in input.

    WinXP, ORACLE 9i.


  • Douglas Hawthorne

    #2
    Re: sqlplus default script directory

    "massimo874 " <massimo874@_SP AMMATUAMAMMA_in wind.it.invalid wrote in message
    news:A1plc.3373 6$eR5.21687@tor nado.fastwebnet .it...
    Please some one can tell me wich is the SQLPlus default script directory
    an
    how I can set it.
    I tryed by 'Define' but SQLPlus don't find the scripts I give it in input.
    >
    WinXP, ORACLE 9i.
    >
    >
    See p.A-2 of the "Oracle 9i Windows SQL*Plus Getting Started" manual.
    (A92157-01)

    The default SQLPlus directory is %ORACLE_HOME%\d bs

    The following method works as well:
    Open 'CONTROL PANEL'
    Open 'System'
    Select 'Advanced' tab
    Click on 'Environment Variables'
    Click on 'New' under 'System Variables'
    Variable Name is 'SQLPATH' and the value is a list of directories separated
    by semicolons ';'.

    Douglas Hawthorne


    Comment

    • massimo874

      #3
      Re: sqlplus default script directory

      thank you

      "Douglas Hawthorne" <douglashawthor ne@yahoo.com.au ha scritto nel messaggio
      news:wzplc.9488 $TT.1474@news-server.bigpond. net.au...
      "massimo874 " <massimo874@_SP AMMATUAMAMMA_in wind.it.invalid wrote in
      message
      news:A1plc.3373 6$eR5.21687@tor nado.fastwebnet .it...
      Please some one can tell me wich is the SQLPlus default script directory
      an
      how I can set it.
      I tryed by 'Define' but SQLPlus don't find the scripts I give it in
      input.

      WinXP, ORACLE 9i.
      >
      See p.A-2 of the "Oracle 9i Windows SQL*Plus Getting Started" manual.
      (A92157-01)
      >
      The default SQLPlus directory is %ORACLE_HOME%\d bs
      >
      The following method works as well:
      Open 'CONTROL PANEL'
      Open 'System'
      Select 'Advanced' tab
      Click on 'Environment Variables'
      Click on 'New' under 'System Variables'
      Variable Name is 'SQLPATH' and the value is a list of directories
      separated
      by semicolons ';'.
      >
      Douglas Hawthorne
      >
      >

      Comment

      Working...