Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Ignore ORA 942 Error

Ignore ORA 942 Error

From: Neil <nmdavies1104_at_hotmail.com>
Date: 12 Oct 2004 03:07:52 -0700
Message-ID: <caef6318.0410120207.4ae42d2a@posting.google.com>


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? Received on Tue Oct 12 2004 - 05:07:52 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US