recreating a DB

[innerebner]

Hello,

I want to know, how it is possible to recreate an existing DB.
(oracle9i). The stored tables in this db should also be deleted.

When i try to create an existing database I get an error message that
this db already exists.

can somebody help me please

regards Markus Innerebner

[Jan Gelbrich]

"innerebner" <markusin@yahoo.de> schrieb im Newsbeitrag
news:2rvfc8F1e9p4mU1@uni-berlin.de... Hello, I want to know, how it is possible to recreate an existing DB. (oracle9i). The stored tables in this db should also be deleted. When i try to create an existing database I get an error message that this db already exists. can somebody help me please regards Markus Innerebner

Markus,

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.

This is all I can give You from my Crystal Ball.

Next time You post, please:
Your version (9i R? or patch level), OS, and most important:
Your background and target.

HTH, Jan

[innerebner]

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

[Sybrand Bakker]

On Wed, 29 Sep 2004 14:56:21 +0200, innerebner <markusin@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 userand then (re)create him, or is there another way?(oracle 9i, os Linux)thanksMarkus

drop user ... cascade;

create user ...



--
Sybrand Bakker, Senior Oracle DBA