SQL Error: ORA-00903: invalid table name

Question

CREATE TABLE Group
(
group_name VARCHAR2(50) NOT NULL,
date_joined DATE NOT NULL,
refersTo VARCHAR2(40),
CONSTRAINT g_group_name_pk PRIMARY KEY(group_name),
CONSTRAINT g_refersTo_fk FOREIGN KEY(refersTo) REFERENCES Artist(artistic_name));

This gives "ERROR at line 1: ORA-00903: invalid table name":

CREATE TABLE Group
             *

_Is_ `Group` a valid table name? Perhaps you need some escaping, like `"Group"`? — CodeCaster, Nov 10 '14 at 21:47
Group is a reserved word in Oracle. See here for the full list: https://docs.oracle.com/cd/B19306_01/appdev.102/b14354/appb.htm — Chief Wiggum, Nov 10 '14 at 21:48
`Group` is a reserved word in Oracle (and basically every other database). Choose a different name for your table. Perhaps `groups`? — Gordon Linoff, Nov 10 '14 at 21:48

score 4 · Answer 1 · answered Nov 10 '14 at 21:52

4

Since Group is a reserved word you have to escape it with ". Give the following a try or rename your table to something else:

CREATE TABLE "Group"
(
group_name VARCHAR2(50) NOT NULL,
date_joined DATE NOT NULL,
refersTo VARCHAR2(40),
CONSTRAINT g_group_name_pk PRIMARY KEY(group_name),
CONSTRAINT g_refersTo_fk FOREIGN KEY(refersTo) REFERENCES Artist(artistic_name));

answered Nov 10 '14 at 21:52

Chief Wiggum

2,784
2
31
44

2

Double quotes cause all sorts of trouble in applications. Why not just choose a different/better name? – APC Nov 10 '14 at 21:55
True, it's better to use different name. – user3834262 Nov 10 '14 at 21:57

SQL Error: ORA-00903: invalid table name

1 Answers1