David, What happens if you do: SQL> !sh (or bash, or ksh, or whatever your preferred shell is?) -Mark -- Mark J. Bobak Senior Database Administrator, System & Product Technologies ProQuest 789 E. Eisenhower, Parkway, P.O. Box 1346 Ann Arbor MI 48106-1346 +1.734.997.4059 or +1.800.521.0600 x 4059 mark.bobak@xxxxxxxxxxxx<mailto:mark.bobak@xxxxxxxxxxxxxxx> www.proquest.com<http://www.proquest.com> www.csa.com<http://www.csa.com> ProQuest...Start here. From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of David Barbour Sent: Monday, November 03, 2008 11:00 AM To: alever@xxxxxxxxx Cc: oracle-l Subject: Re: Somewhat Perplexed - Very Sheepish - Totally Ignorant:SQPLUS after 10.2.0.4 Upgrade Thanks, but the directory has both files and directories. But I just don't get a list. So I decided to see if other commands which should return output might work. I tried the cat command. SQL> !cat arch.txt Guess what, no output. Simply came back to a prompt. On Mon, Nov 3, 2008 at 10:34 AM, Alessandro Vercelli <alever@xxxxxxxxx<mailto:alever@xxxxxxxxx>> wrote: Sorry, I was wrong: the directory in which you run the command needs to be empty (no files and no directories). Alessandro >The "ls" command can give also a null response, if you are placed in a >directory which has non files (i.e. an empty directory or containing only >directories). > >If the returned prompt is SQL>, that colud be the right behaviour. > >Alessandro > > >>Morning, >> <cut> >>session and type (for instance) SQL>!ls - it returns to a prompt without >>listing the files in the directory. Anybody had this happen to them >>before? I tried searching on Metalink, but I don't even know how to phrase <cut> -- //www.freelists.org/webpage/oracle-l