Re: How can I create a new database ?

"Jim Kennedy" <kennedy-family_at_attbi.com> wrote
> A tablespace and a database are not the same thing. If you were able to
> logon and grant scott a privlidge they you already have a database. In
> Oracle each instance is 1 database. Each database can have multiple
schemas
> which is what you want.
> Jim

No, sorry, I don't want schemas,I want a new database. I'm new to oracle and thought it could be that I could create a new database if I have the right to create tablespace.But now I read it's only to divide an existing database in logical areas.I really want to execute the "create database" command
in SQL*Plus. Which rights need I to do it ? You wrote "If you were able to logon ... you already have a database". Yes, I want only to logon to the existing database to start SQL*Plus to create a new database. And I want to know it how to do it with command lines for the case that I can't use the "database configuration assistent".

1)Is it possible to start SQL*Plus without an existing database only for creating a new database ?
When it is possible what are the logon data ?

2)Which rights need I to use the CREATE DATABASE command ?

Theo Klein Received on Mon Apr 01 2002 - 08:52:34 CST