Re: create db insufficient privileges

From: mcstock <mcstock_at_enquery.com>
Date: Tue, 28 Oct 2003 17:45:47 -0500
Message-ID: <7-KdnQiVyKdfbAOiRVn-ig@comcast.com>

creating a database requires partially starting the oracle instance (the background processes) -- it cannot be done while already connected to a running database

you'll need to read up on the STARTUP command and the CREATE DATABASE command.

there's also sections in the DBA manuals about creating new databases -- oracle provides some wizard-y tools, plus the manual procedure is also documented

-- 
----------------------------------------
Mark C. Stock
www.enquery.com
(888) 512-2048


"mercurio" <mercurio_at_tiscali.it> wrote in message
news:bJvnb.72388$vO5.2645484_at_twister1.libero.it...


> 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

>

>

>

Received on Tue Oct 28 2003 - 16:45:47 CST