I do not understand the reason to drop/rebuild the entire database, but if that's what you have
decicdd to do, then look into using Export/Import utilities.
I also assume that you do not need to preserve the data.
Exporting with rows=n will export all database structures etc. without any table data.
You can then then build an empty database and Import from the dump file.

- Kirti


--- Moovarkku Mudhalvan <moovarkku.[Email Address Removed] wrote:
>
>
>
>
> Dear DBAs
>
> My database size was around 40GB. We have 5 Differenet tablespace for
> only Data. Since i was planning to drop the database and create the same. I
> have only 50 to 60 tables. Tablesizes are from 2GB to 500MB.
> I am not going to consider the INDEX Spaces. Could any one have the
> step by Step Document to Drop and Recreate the database as as what we
> already have. I got some pakages,sequences and procedures.
> Could you also can give the scripts to do the same will help me a
> lot.
>
> Thank you
>
> Mudhalvan M.M
>
>

__________________________________
Do you Yahoo!?
Yahoo! Calendar - Free online calendar with sync to Outlook(TM).
http://calendar.yahoo.com
Oracle LazyDBA home page