How to drop all of a user's data?

From: <andrew.fabbro_at_gmail.com>
Date: 21 Jul 2006 13:37:01 -0700
Message-ID: <1153514221.715473.214990@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... Received on Fri Jul 21 2006 - 15:37:01 CDT

This message: [ Message body ]
Next message: Ed_Zep: "Forms 9.0.4.2"
Previous message: Charles Hooper: "Re: using select to concatenate into a string?"
Next in thread: Robbert van der Hoorn: "Re: How to drop all of a user's data?"
Reply: Robbert van der Hoorn: "Re: How to drop all of a user's data?"
Reply: Michel Cadot: "Re: How to drop all of a user's data?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US