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 -> Re: to avoid errors while dropping not existing objects

Re: to avoid errors while dropping not existing objects

From: fireball <fireball_at_onet.kropka.eu>
Date: Wed, 11 Oct 2006 12:55:45 +0200
Message-ID: <egiiq9$bk3$1@atlantis.news.tpi.pl>


Uzytkownik <ivl5_at_hotmail.com> napisal w wiadomosci news:1160535576.460887.81460_at_i3g2000cwc.googlegroups.com...

I 've found approach you proposed useful
> execute immediate 'drop table "&1"."&2"';

qustetions:
- is that ok putting in your script 'cascade' statement? - is that ok putting 'drop user' to drop all objects in the schema? assuming I want to create a new version of my dbase (from new version of script)?

thx. Received on Wed Oct 11 2006 - 05:55:45 CDT

Original text of this message

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