Re: create database

Thomas Vatter wrote:

> When I try sql "create database" with jdbc 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"?

I've never tried it but I sincerely hope it is absolutely impossible to do what you are trying to do.

To run the create database command you need the following. You need to be in either server manager or SQL*Plus (most recent version only). You need to have an init.ora file. If you are on Windows NT you must have already created the Oracle services using oradim.exe. And you must either be logged on as sys (internal) or with equivalent privileges.

The group ora_dba, is irrelevant to the process. I've probably built 50-60 Oracle servers on NT and never had any need to create that group.

My advice to you would be to forget Java until you know how to do it manually. And as I said above, I sincerely hope that what you are trying to do is impossible.

Daniel A. Morgan Received on Fri Apr 27 2001 - 01:02:07 CDT