ORA-00903: invalid table name when creating a new table

I'm trying to create the following table

create table asistenti
    marca Number(2) not null,
    nume Varchar2(30),
    prenume Varchar2(30),
    experienta Varchar2(30),
    marca_medic Number(2) not null,

    primary key (marca),

    foreign key(marca_medic) references to medici(marca)

But I get an error

ORA-00903: invalid table name error

This is a new database, and I have created only one other table, medici

1 answer

  • answered 2018-01-14 11:32 juergen d

    Remove to in

    references to medici(marca)