Re: HELP ! PO8 canīt get primary Index with user System (ODBC-Delphi)

Hmm perhaps there is a little problem with primary key.

All of columns that is a part of primary will be declared with NOT NULL attribute.
Oracle doesn't verify it. Try it if it's possible.

ELN (DBA since 1989)

1078-939 wrote:

> hi folks,
>
> i have i serious problem using this table :
>
> -----------------------------------
> create table gu_X
> (
> KST varchar2(10),
> stp number(3),
> prozent number(8,4),
> bezeichnung varchar2(30),
> komplett char(1)
> );
>
> alter table gu_X
> add constraint gu_X primary key (KST,stp);
>
> ----------------------------
>
> if i create this table under SQL-Plus (logged in as a normal user) my
> Application (Delphi3 using ODBC)
> is running fine. Now i need to create this table with the owner SYSTEM. If i
> do this my Application
> getīs a BDE-Error. Errortext is something like "Table has no primary Index".
>
> What do i have to change ? I tried to alter the rights from SYSTEM-User to
> the same level as the normal User-Account (no DBA-Admin etc.), but this has
> no effect.
>
> Please can somebody help me. ?
> Juergen Mutz
Received on Mon Jun 28 1999 - 11:15:31 CDT