Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: to avoid errors while dropping not existing objects
fireball wrote:
> 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?
Yeah, why not. It's 'cascade constraints' btw.
> - 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)?
No, you can't do this - the script name is not right :) Sure you can write a similar script to drop users, exception would be different of course (ORA-01918: user 'XXX' does not exist).
> thx.
Na zdrawie,
Igor
Received on Wed Oct 11 2006 - 19:47:17 CDT