Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: create database
On 27 Apr 2001 00:30:17 +0100, thomas.vatter_at_blinx.de (Thomas Vatter) wrote:
>When I try sql "create database" there is the error "01031
>unsufficient priviliges". I have connect before to an existing
>database with the ora thin driver. I tried with the accounts
>"system", "sys" and "internal".
>I have Oracle running on NT and there is a user group "ora_dba". The
>client logs in as "system" or "sys". Do I have to create a user "system"
>or "sys" on NT and put them in the group "ora_dba"?
Question: did you create an instance and start it? If not, it is not
surprising it doesn't work.
Also, in a default config *you won't be able to create a database from
a remote system*, and I wouldn't recommend you to configure Oracle in
such a way it is possible.
In Oracle, 'create database' is definitely not the same as in
sqlserver. For one thing, sqlserver guys never read any manual, in
Oracle you *must*
Regards,
Sybrand Bakker, Oracle DBA Received on Thu Apr 26 2001 - 16:48:34 CDT