Hi,

I want to do this.

sqlplus login/password < dropandcreatetable.sql.

Sample dropandcreatetable.sql:

DROP TABLE TEST;

CREATE TABLE TEST
(
  ID            CHAR
);

Can someone suggest a way to do this without getting table exists errors.
This means i need to check if table exists and then drop table.
conditions:

i do not want to create a seperate proc to check if table exists.
i do not want to turn of exception checking.

So basically it needs to run with all the code in the sql file from command line.

Any ideas?

---

Request for Question Clarification by mathtalk-ga on 27 Oct 2004 19:50 PDT

Hi, wag-ga:

What version of Oracle are you on?

regards, mathtalk-ga