1CREATE DATABASE numismatics; /*+ CACHESIZE = 16m */ 2 3CREATE TABLE coin (cid INT(8) PRIMARY KEY, 4 unit VARCHAR2(20), 5 value NUMERIC(8,2), -- just a comment here 6 mintage_year INT(8), 7 mint_id INT(8), 8 CONSTRAINT mint_id_fk FOREIGN KEY(mint_id) 9 REFERENCES mint(mid)); 10 11CREATE TABLE mint (mid INT(8) PRIMARY KEY, 12 country VARCHAR2(20), 13 city VARCHAR2(20)); --+ DBTYPE = HASH 14 15CREATE INDEX unit_index ON coin(unit); /*+ DBTYPE = HASH */ 16 17CREATE TABLE random (rid VARCHAR2(20) PRIMARY KEY, 18 chunk bin(127)); 19