Oracle Table : Cluster for Jentrata DB

[urspraveen2001]

Hi Team,

We are trying to test Jentrata with the Oracle DB and trying to create the schema using script "https://github.com/jentrata/jentrata-msh/blob/master/Dist/src/main/scripts/sql/oracle_ebms.sql" there was a table "Cluster" which is actually a reserved keyword in Oracle and we couldn't create a table with that. Can you please let us know how to proceed further using Jentrata with Oracle DB. We have a hard requirement to use Oracle alone.

Much appreciate your response here.

Thanks
Praveen Kalagarla

[aaronwalker]

@urspraveen2001 have you tried putting the table name in in double quotes?

CREATE TABLE "cluster" (
	hostname varchar2(255),
	status varchar2(12),
	timestamp number,
	PRIMARY KEY (hostname)
);

[kumarkshiva]

All reserved words of Oracle can be seen in the Oracle view V$RESERVED_WORDS
for more information: https://docs.oracle.com/cd/B28359_01/appdev.111/b31231/appb.htm#CJHIIICD

Putting the table name in double quotes is the best option if you can not change the name.