Re: create database
Date: Fri, 27 Apr 2001 15:58:18 +0200
Message-ID: <1duiet0kd9l0t84ql1k7qcq8lqj75430gb_at_4ax.com>
On 27 Apr 2001 11:07:38 +0100, thomas.vatter_at_blinx.de (Thomas Vatter)
wrote:
>On 26 Apr 2001, you wrote in comp.databases.oracle.server:
Yes you are wrong.
>
>>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,
>
>
>
>
>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 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 Received on Fri Apr 27 2001 - 15:58:18 CEST