RE: Deleting database

That's right - you would have to drop all schema owners. In my opinion it is simpler and easier task to automate dropping of all owners followed by one full import compared to task of automating database deletions followed by database creations then doing full import in very last step.

DOS environment offers weak (better word is miserable) error handling, so unless you resort to non M$ scripting languages to do this task for you I believe you'd be better off to stick with simpler of two approaches.

Another reason to try avoiding tearing/re-creating databases lies in the fact that when you create new database on WinXYZ platform, newly created data files are always fragmented at file level (which may not be overly fact important for your test database but it is an ugly site to look at nevertheless).

Branimir

>
> Branimir,
>
> Correct me if I am wrong, but if I used your approach of
> dropping schema
> owner then if I have 25 schemas on my test db, I would have
> to drop ALL
> of them? I would think that dropping ALL schemas would equal removing
> entire database.
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Branimir Petrovic
  INET: BranimirP_at_cpas.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).