Re: Oracle ORA-00942 message gives no table name

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Fri, 18 Jan 2002 15:47:56 -0000
Message-ID: <3c4843ae$0$237$ed9e5944@reading.news.pipex.net>

"Aleksey Burdakov" <burdakov_at_vesco.ru> wrote in message news:9292180b.0201180424.3b7594d8_at_posting.google.com...
> Is that true that there is no way to get table/view name for ORA-00942
> error from Oracle DBMS ?

No. Sqlplus will note this bad tablename with an asterisk.

--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer

******************************************

Received on Fri Jan 18 2002 - 09:47:56 CST