Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: recreating a DB

Re: recreating a DB

From: Sybrand Bakker <gooiditweg_at_nospam.demon.nl>
Date: Wed, 29 Sep 2004 22:48:57 +0200
Message-ID: <fs7ml0960fobta4j5j8f82r8o6cuckdnkh@4ax.com>


On Wed, 29 Sep 2004 14:56:21 +0200, innerebner <markusin_at_yahoo.de> wrote:

>
>> 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
>
>

drop user ... cascade;

create user ...

--
Sybrand Bakker, Senior Oracle DBA
Received on Wed Sep 29 2004 - 15:48:57 CDT

Original text of this message

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