Re: Ignore ORA 942 Error

From: Brian Dick <bdick_at_cox.net>
Date: Tue, 12 Oct 2004 07:32:32 -0400
Message-ID: <1wrs2lbbux51f.m0l98oc0fjd3.dlg@40tude.net>

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. Received on Tue Oct 12 2004 - 06:32:32 CDT