Re: Odp: How to drop an nonexist table without the error message?

In article <TqSS4.56026$O4.1163700_at_news.tpnet.pl>, "AW" <wysza_at_polbox.com> writes:

>Try to use:
>"create or replace table ....."
>this way you :
>* you don't have to recreate all grants etc. - Oracle remembers it and
>doesn't destroy it
>* if the table doesn't exists Oracle creates it without an error,
>* if the table exists Oracle replaces it without an error
>good luck
>AW
>

CREATE OR REPLACE TABLE????
Which ORACLE are you using???
Paul in VT Received on Thu May 18 2000 - 00:00:00 CDT