Re: [?] sqlplus error

Guessing that you are using Unix and a C-shell, to kill the 'host' c-shell you need type:

        exit
Or sometimes you can try control-D.
Since you wrote that your error says

        "Not login shell"
I guess you tried to type 'logout'. The c-shell is trying to tell you that you are in a subshell off your login shell, hence the sub shell cannot 'logout', but it can die if you 'exit' from it.

Perhaps you would like to experiment with Cshell without going anywhere near Oracle as so:

	login to your unix box
	now run the command "csh" (without the quotes :-)
	now type 'logout', which shouldn't work
	now try 'exit', and you will kill the sub-cshell and get
	back to your login shell which WILL accept either 'exit' or 'logout'

Hope this helps.
Mungo

-- 
Mungo Henning - it's a daft name but it goes with the face...
mungoh_at_itacs.strath.ac.uk