Re: Which rights to create database ?

Theo,

This is not sybase. You cannot create multiple databases. You can create multiple schemas in a database. In your case, you create tables under the schema scott.

"Ron Reidy" <rereidy_at_indra.com> wrote in message news:3CAA927F.210440F_at_indra.com...
> Theo Klein wrote:
> >
> > I executed this commands:
> > connect SYS/Password_at_datenban as sysdba;
> > grant sysdba to scott;
> > disconnect;
> >
> > Now I tried this:
> > connect scott/tiger_at_datenban as sysdba;
> > create database test;
> >
> > But instead to create the database I get this error messages:
> >
> > ORA-01501: CREATE DATABASE not successfull
> > ORA-01100: Database already joined with MOUNT
> >
> > What's wrong ?
> >
> > Theo Klein
> $ oerr ora 1100
> 01100, 00000, "database already mounted"
> // *Cause: A database is already mounted in this instance.
> // *Action:
>
> As the cause above shows, an instance is already running for this SID.
> Have you read the concepts manual, DBA guide, etc.?
>
> --
> Ron Reidy
> Oracle DBA
Received on Thu Apr 04 2002 - 21:52:24 CST