Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2003
    Location
    kualalumpur
    Posts
    89

    Unhappy problem with SQL*PLUS

    Hi all Iam sridhar here..
    When Iam trying to open editor in sqlplus on solaris..
    it says..
    "SQL> ed
    Wrote file afiedt.buf
    65
    /
    ?
    q

    1 select tablespace_name ,lpad(file_name,50)
    2* from dba_data_files
    SQL>
    "
    It cant open vi editor..
    Pls.help me out..
    thanks in advance..

  2. #2
    Join Date
    Apr 2003
    Location
    Minneapolis, MN
    Posts
    273
    (1) go to login.sql or glogin.sql and Include the following line at top.

    define _editor=vi

    You can also define at the start of SQLPLUS session.

    (2) also include the following line into your bash_profile (if You use B/K shell)

    export EDITOR=vi

    (3) If you use C-shell. then "setenv EDITOR=vi".

    HTH
    Bhavin

    MS Computer Science
    OCP DBA 9i/8i

  3. #3
    Join Date
    Nov 2003
    Location
    kualalumpur
    Posts
    89
    Originally posted by Hings
    (1) go to login.sql or glogin.sql and Include the following line at top.

    define _editor=vi

    You can also define at the start of SQLPLUS session.

    (2) also include the following line into your bash_profile (if You use B/K shell)

    export EDITOR=vi

    (3) If you use C-shell. then "setenv EDITOR=vi".

    HTH
    Thank u very much Hings..

Posting Permissions

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