Re: create db insufficient privileges

On Tue, 28 Oct 2003 15:14:15 GMT, "mercurio" <mercurio_at_tiscali.it> wrote:

>Hello,
>I connect as System Manager to create a database but I get " Insufficient
>Privileges"
> "create database mydb
> controlfile REUSE
> maxlogfiles 5
> maxinstances 2
> archivelog
> character set US7ASCII;"
>
>which privileges should have the user "System" ?
>
>
>
>TIA
>
>

As the owner of the database is SYS, why are you connecting as SYSTEM. Apart from that, a quick read of the create database command in the sql reference manual would have provided you the answer.

--
Sybrand Bakker, Senior Oracle DBA