1 CREATE DATABASE numismatics; /*+ CACHESIZE = 16m */
3 CREATE TABLE coin (cid INT(8) PRIMARY KEY,
5 value NUMERIC(8,2), -- just a comment here
8 CONSTRAINT mint_id_fk FOREIGN KEY(mint_id)
11 CREATE TABLE mint (mid INT(8) PRIMARY KEY,
13 city VARCHAR2(20)); --+ DBTYPE = HASH
15 CREATE INDEX unit_index ON coin(unit); /*+ DBTYPE = HASH */
17 CREATE TABLE random (rid VARCHAR2(20) PRIMARY KEY,