Re: create database

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Thu, 26 Apr 2001 23:48:34 +0200
Message-ID: <en5het8opd8oq88rbhndeahbh634hit74v_at_4ax.com>

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 - 23:48:34 CEST

This message: [ Message body ]
Next message: Hans Forbrich: "Re: performance question"
Previous message: Thomas Vatter: "create database"
In reply to: Thomas Vatter: "create database"
In reply to Thomas Vatter: "create database"
Next in thread: Eric from Speco: "Re: Where do I start?"
Reply: Thomas Vatter: "Re: create database"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message