Re: Which rights to create database ?

From: Howard J. Rogers <dba_at_hjrdba.com>
Date: Tue, 2 Apr 2002 04:25:07 +1000
Message-ID: <a8a8on$5m4$1@lust.ihug.co.nz>

That sounds like sql server, right?

In which case, the first thing you have to appreciate is that what Oracle calls a database is not the same thing that SQL Server calls a database.

The nearest equivalent in Oracle to SQL Server's 'create database' command is 'create user'. Or possibly 'create tablespace', depending on how you look at things. Databases in SQL Server are used to separate out sets of tables & indexes from each other. Oracle uses the 'schema' to do that logically (and a schema, sort of, is just a user). And to do it physically, it uses the tablespace.

Have fun learning!
Regards
HJR

--
------------------------------------------
Resources for Oracle : www.hjrdba.com
============================


"Theo Klein" <theoklein77_at_hotmail.com> wrote in message
news:a8a8db$qmoqu$1_at_ID-124047.news.dfncis.de...


>

> "Chris Leonard" <chris_at_databaseguy.com>

> wrotenews:0C0q8.48$xj2.69285_at_news.uswest.net...

> > Since the database will not exist yet, you need to do one of two things.

> > You can either create a password file, and use the password associated

> with

> > it, or you can create an operating system group (called dba in Unix or

> > ora_dba in Windows) and add the appropriate operating system user to

that


> > group.

> >

> > Hope this helps!

> > Chris

>

> Thank you for answer.

> It seems to be very complicated to create a new database manualy

> with Oracle.I think I haven't enough experience with Oracle yet.

> Up to now I worked with a database where you could use simply the "create

> database" command.

>

> Theo Klein

>

>

Received on Mon Apr 01 2002 - 12:25:07 CST