My 'problem' is simple in that there are no keys or constraints at all ;-)
Jan
"Thomas Kellerer" <WVIJEVPANEHT_at_spammotel.com> wrote in message
news:40nifiF1ajnf2U1_at_individual.net...
> On 19.12.2005 10:21 sybrandb_at_yahoo.com wrote:
> > You can't.
> > You can of course
> > begin
> > for tab in (select table_name from dba_tables where owner= 'UserName' )
> > loop
> > execute immediate 'drop table Username.'||tab.table_name||' cascade
> > constraints';
> > end loop;
> > end;
> > /
> > But you would need to make sure there are no foreign keys or drop the
> > tables in the right order.
>
> Hmm, this confuses me a bit.
>
> A "DROP TABLE xyz CASCADE CONSTRAINTS" will remove all constraints on
> the table as well, including foreign keys.
>
> So the order shouldn't actually matter in that case, shouldn't it?
>
> Thomas
>
>
> --
> It's not a RootKit - it's a Sony
Received on Mon Dec 19 2005 - 05:51:27 CST
