have this in your login.sql define_editor=vi or export EDITOR=vi in your linux profile On 10/11/06, Sandra Becker <sbecker6925@xxxxxxxxx> wrote:
One of the problems I've encountered is editing while in sqlplus. I copied my .bash_profile and .bashrc files from the current production node and made the appropriate changes since I made the ORACLE_HOME a more generic name. (was 9.2.0.4.0, made it 920) I key in my query and after I get the results I want to change something in the query so I type in edit. What I get back is the following: Wrote file /u01/app/oracle/product/920/rdbms/admin/afiedt.buf 277