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
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
![]() |
![]() |