Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Usenet -> c.d.o.server -> Re: create database

Re: create database

From: Thomas Vatter <>
Date: 27 Apr 2001 17:36:56 +0100
Message-ID: <Xns9090A858F67C8thomasvatter@>

On 27 Apr 2001, you wrote in

>On 27 Apr 2001 11:07:38 +0100, (Thomas Vatter)
>>On 26 Apr 2001, you wrote in
>>>On 27 Apr 2001 00:30:17 +0100, (Thomas Vatter)
>>>>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*
>>thanks a lot for your answer! I had checked the online manuals, for
>>"create database" but couldnt find this info. So I wont create the
>>database remotely. But I wonder if it is the right way if network
>>applikations cant create the database to save their data. Thus
>>installation will be more complicated and customers dont like that.
>>Sure dbas want to keep their job, but perhaps today this is not
>>creating databases but administrating, configuring, tuning etc. Am I
>Yes you are wrong.
>In several ways:
>a as a dba you don't want end-users to create databases. Try to read
>the Oracle Concepts Manual and you will know why. What is a database
>in sqlserver is a schema in Oracle. Evidently you have been exposed to
>sqlserver. "Network applications can't create the database to save
>their data' If that would be the situation in someone's firm:
>end-users do create their own databases, I would quit immediately, as
>in my function as DBA I can't exercise control.
>b This is not because DBAs want to keep their job, this is because
>end-users don't have the correct expertise to do it correctly. And of
>course they don't as they are hired for other purposes.
>And of course after creating the databas there will be a lot of
>administrating and tuning, that is the life of a DBA
>Sybrand Bakker, Oracle DBA

i agree that it is better to have a dba that controls database situation. i come from informix database where creation was possible with java. i only fear that oracle could have some disadvantage if it has constraints that for instance sqlserver has not. i dont want that microsoft controls everything. i think that the decison which enterprise database is created is made by the management, not by application developers and not by dbas. we only can tell them what would be the best and do the job. reason is that only managers and users know what data the enterprise needs. in my opinion at least. Received on Fri Apr 27 2001 - 11:36:56 CDT

Original text of this message