Creating a table in Oracle DB if it does not exist, using SQL

From: google_user <chaitanya.nuguri_at_three.co.uk>
Date: 13 Sep 2004 05:24:30 -0700
Message-ID: <84147aa6.0409130424.111fa2bc@posting.google.com>

Hi,

I need to create a table in Oracle DB using SQL before which I need to check if it exists or not, where the dbuser will have CONNECT and RESOURCE privileges granted.

All this needs to be in a .sql file so that it can be included in the release.

I tried writing a Stored Procedure using DBMS_SQL.parse etc., but looks like, the above stated privileges are not enough. Is there a way that serves my purpose without anymore privileges given ?

If someone can take time to write a running sample and send me, I would be Grateful.

Thanks,
Chaitanya. Received on Mon Sep 13 2004 - 07:24:30 CDT