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

Ciprian Pop

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

juergen d

Remove to in

references to medici(marca)

Collected from the Internet

Please contact [email protected] to delete if infringement.

edited at
0

Comments

0 comments
Login to comment

Related

From Dev

Ora-00903 invalid table name

From Dev

java.sql.SQLSyntaxErrorException: ORA-00903: invalid table name

From Dev

Unable to create table. Invalid object name 'master.dbo.DDLevents' when creating a new object

From Dev

SQL give query result table name without creating new table

From Dev

"Invalid object name" when referring to a table

From Dev

ORA-00907: missing right parenthesis when creating a table

From Dev

ORA-00903 when merging on an updatable view

From Dev

Creating a row for table name

From Dev

Entity Framework Invalid column name when adding property that is not in db table

From Dev

EF Requiring primary key when creating a new entry in sql table

From Dev

PhpMyAdmin SQL code not showing up when creating new database and table

From Dev

nftables: flush/delete when changing or creating new table

From Dev

Invalid object name LocalDb Table

From Dev

Updating table on creating a new row in another table

From Dev

Creating new records in MSACCESS Table

From Dev

Qt MySQL - Creating New Table

From Dev

ORA-00907: missing right parenthesis when creating a table in Oracle 11G

From Dev

SQL Error: ORA-00907: missing right parenthesis when trying to creating table

From Dev

In SQL when we join tables, is there a name for the new table?

From Dev

Invalid object name when creating stored procedure

From Dev

Getting error while creating trigger- PL/SQL: ORA-01747: invalid user.table.column, table.column, or column specification

From Dev

"ERROR 1031 (HY000) at line ###: Table storage engine for '<table_name>' doesn't have this option" when creating table

From Dev

error when creating a partitioned table

From Dev

SQL Error when creating a table

From Dev

error when creating table in hive

From Dev

Run-time error '3001': Invalid Argument when creating a table in Access VBA

From Dev

'invalid for creating a default constraint' error when trying to add a constraint to an existing table

From Dev

When creating new User with ASP.Net Identity 2 new row is inserted into parent table

From Dev

Creating a new version of data table with same column name and column data type

Related Related

  1. 1

    Ora-00903 invalid table name

  2. 2

    java.sql.SQLSyntaxErrorException: ORA-00903: invalid table name

  3. 3

    Unable to create table. Invalid object name 'master.dbo.DDLevents' when creating a new object

  4. 4

    SQL give query result table name without creating new table

  5. 5

    "Invalid object name" when referring to a table

  6. 6

    ORA-00907: missing right parenthesis when creating a table

  7. 7

    ORA-00903 when merging on an updatable view

  8. 8

    Creating a row for table name

  9. 9

    Entity Framework Invalid column name when adding property that is not in db table

  10. 10

    EF Requiring primary key when creating a new entry in sql table

  11. 11

    PhpMyAdmin SQL code not showing up when creating new database and table

  12. 12

    nftables: flush/delete when changing or creating new table

  13. 13

    Invalid object name LocalDb Table

  14. 14

    Updating table on creating a new row in another table

  15. 15

    Creating new records in MSACCESS Table

  16. 16

    Qt MySQL - Creating New Table

  17. 17

    ORA-00907: missing right parenthesis when creating a table in Oracle 11G

  18. 18

    SQL Error: ORA-00907: missing right parenthesis when trying to creating table

  19. 19

    In SQL when we join tables, is there a name for the new table?

  20. 20

    Invalid object name when creating stored procedure

  21. 21

    Getting error while creating trigger- PL/SQL: ORA-01747: invalid user.table.column, table.column, or column specification

  22. 22

    "ERROR 1031 (HY000) at line ###: Table storage engine for '<table_name>' doesn't have this option" when creating table

  23. 23

    error when creating a partitioned table

  24. 24

    SQL Error when creating a table

  25. 25

    error when creating table in hive

  26. 26

    Run-time error '3001': Invalid Argument when creating a table in Access VBA

  27. 27

    'invalid for creating a default constraint' error when trying to add a constraint to an existing table

  28. 28

    When creating new User with ASP.Net Identity 2 new row is inserted into parent table

  29. 29

    Creating a new version of data table with same column name and column data type

HotTag

Archive