Re: recreating a DB
From: innerebner <markusin_at_yahoo.de>
Date: Wed, 29 Sep 2004 14:56:21 +0200
Message-ID: <2rvporF1fpscnU1_at_uni-berlin.de>
Date: Wed, 29 Sep 2004 14:56:21 +0200
Message-ID: <2rvporF1fpscnU1_at_uni-berlin.de>
> maybe You confuse DB with Schema. In MySQL it means the same, in Oracle not.
> There is AFAIK no purpose to recreate an Oracle DB.
> You seem to want to purge a Schema (with tables and all the contents).
> Just create another Schema (that is: another User with tablespace quota and
> the appropriate priviliges)
> and "re"create the tables there.
>
exactly, this is what I wanna do. After purging the Schema.
If I still want reuse the same Schema name, do I need to drop the user
and then (re)create him, or is there another way?
(oracle 9i, os Linux)
thanks
Markus Received on Wed Sep 29 2004 - 14:56:21 CEST