Re: create db insufficient privileges

"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
Besides what everyone else said, you should avoid US7ASCII. It is a 7 bit character set, and should you use 8 bit characters (which many tools and programs let you do irrespective of the database character set) and then later export and import into an 8 bit database, Oracle will politely convert the bits for you. Except it might not be so nice if you don't want them converted.

You might consider a ...P15 set.

jg

--
@home.com is bogus.
http://www.siliconvalley.com/mld/siliconvalley/7130206.htm