Re: Ignore ORA 942 Error

On Tue, 12 Oct 2004 07:32:32 -0400, Brian Dick <bdick_at_cox.net> wrote:

>On 12 Oct 2004 03:07:52 -0700, Neil wrote:
>
>> I have a unix script that includes a DROP TABLE and CREATE TABLE
>> command in SQL Plus.it works fine if the table to drop is there. If
>> not the script ends. Can anyone advise how I can ignore the
>> "ORA-00942: table or view does not exist" error and continue to the
>> next command?
>
>Rather than ignore the error, why don't you avoid the error. Query
>user_tables or dba_tables instead. If the table doesn't exist, then create
>it. Otherwise, skip the create.

Why would Oracle have implemented then whenever sqlerror in catalog.sql?

--
Sybrand Bakker, Senior Oracle DBA