Re: How to drop all of a user's data?

From: Robbert van der Hoorn <removetheXinR.Xvanderhoorn_at_osait.nl>
Date: Sat, 22 Jul 2006 00:59:00 +0200
Message-ID: <44c15d67$0$31656$e4fe514c@news.xs4all.nl>

<andrew.fabbro_at_gmail.com> wrote in message news:1153514221.715473.214990_at_s13g2000cwa.googlegroups.com...
> I have user joeschmo in a 10g database. I have a script that creates a
> bunch of tables, sequences, packages, etc. under that user (called
> joeschmo.table1, etc.)
>
> How can I delete all the tables, sequences, packages, etc. for user
> joeschmo - without deleting the user? I can do a lot of drop table x,
> drop sequence y, but I was hoping for something in a single statement.
>
> I'm probably missing something obvious...
>

Drop user, (re)create user? Received on Fri Jul 21 2006 - 17:59:00 CDT