Database ORA-600 / ORA-7445 Analysis , Diagnostic Repository (ADR) & Packaging (MOSC)

MOSC Banner

ORA-00600: internal error code, arguments: [12869], [287961], [288187], [], [], [], [], [], [], [],

Hello!
I have a such an fun problem..

I was supposed to create a table
CREATE TABLE pn10_syndmus
(
    ID NUMBER(*,0) NOT NULL primary key,
    kasutaja_id NUMBER(19,0) NOT NULL references pn_kasutaja(ID),
    start_date DATE NOT NULL,
    end_date DATE NOT NULL,
    text NVARCHAR2(2000),
    aet_nimetus NVARCHAR2(250),
    kalendri_nimetus NVARCHAR2(250),
    asukoht NVARCHAR2(250),
    onMeeldetuletus NUMBER(1,0) NOT NULL,
    etoimik_oid NUMBER
);

But it failed to create it like that "ORA-00904: "ID": invalid identifier". Apparently the error comes from "primary key" in the table creation script.. So i made a table without this ID and tried to add coloumn ID using different datatypes.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center