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