if you're like me you do a lot of local sqlplus work and end up with afiedt.buf files all over your filesystem(s). I've been pretty lazy about this and occasionally would run a find to hunt them down but finally got off my rear and fixed the root (pardon the pun) problem:
simply vi (,emacs or whatever editor you prefer for religous reasons) $ORACLE_HOME/sqlplus/admin/glogin.sql and insert the following line:
set editfile /tmp/afiedt.buf
it also works with shell variables so you can do:
--let each user have their own in their home directory
set editfile $HOME/afiedt.buf
or
--one per version if you have multiple on same host
set editfile $ORACLE_HOME/afiedt.buf
or
--one per PID im /tmp
set editfile /tmp/afiedt.$$
or wherever your imagination takes you (anything is better than "." wherever you happened to be)
this is certainly not a big deal and maybe I need more fiber but it is annoying when you're doing ls, can cause for loops in shell scripts to do stupid things and is a simple one line fix.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.