Thursday, January 5, 2012

Change the location of afiedt.buf generated by SQL Plus

By default, when using ed in SQL Plus, the file afiedt.buf is created in current directory. This can be a problem because there may be generated multiple files, depending from where you launch SQL Plus.
To override this, just put following lines


SET EDITFILE "/tmp/afiedt.buf"
DEFINE _EDITOR='vi'


in $ORACLE_HOME/sqlplus/admin/glogin.sql, and there will be just on file generated.
The second line specifies that default editor for editfile is VI.

No comments:

Post a Comment