Re: Problem with Personal Oracle fpr Win95

From: Keith Majkut <kmajkut_at_netcom.com>
Date: 1996/11/10
Message-ID: <kmajkutE0o855.Cqo_at_netcom.com>#1/1


In article <55i6ak$jlm_at_news00.btx.dtag.de>, Stefanos Tzigiannis <S.Tzigiannis-DATA-TEAM_at_t-online.de> wrote:
>Hi, we are using Personal Oracle 7.2 for Win95 under Win95 and have the
>following problem:
>
>Every time we want to create a new database with "create database"
>with SQL*Plus 3.2 (connected as user "SYS" or "SYSTEM") we get the error:
>"ORA-01031 ..." (no trustee).
>
>On the other side it is not possible to give any user the privilege
>"SYSDBA" which we think is necessary to create a database. None of the
>standard users like SYS, SYSTEM or PO7 has this privilege. When we try to
>give this privilege to any user we get the same error "ORA-01031".
It is definitely possible - a sample database can be created during installation. I'm thinking that a prvileged connection to create the database can only be done it sqldba/svrmgr, not sqlplus. Try that.

>
>Has anyone a solution? Is it possible to create a database with Peronal
>Oracle7?
>
>Thanks
>
>Stefanos
>
>Stefanos Tzigiannis E-Mail: S.Tzigiannis-DATA-TEAM_at_T-Online.de
>DATA-TEAM GmbH
>Duesseldorferstr. 15
>D-71332 Waiblingen
>Germany
Received on Sun Nov 10 1996 - 00:00:00 CET

Original text of this message