Re: desc SQL*PLUS

We had a similar thing when we upgraded OS last weekend. Re-linking sqlplus from the correct (i.e. new) ORACLE_HOME resolved our problem.

HTH
Stephen

>>> siqbal_at_vianetworks.co.uk 05/11/01 01:35AM >>>
Hello DBA's

I have recently upgraded from 8.1.6.0 to 8.1.6.3.

I seem to be having a weird problem in sql*plus, in that whenever I do a describe on a table it comes up with the following error :-

SQL> desc emp;
ERROR:
ORA-03113: end-of-file on communication channel

I can run select statements without any problems !

TIA Sajid Iqbal

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
-- 
Author: Sajid Iqbal
  INET: siqbal_at_vianetworks.co.uk 

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Stephen Andert
  INET: StephenAndert_at_firsthealth.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).