... --drop table AIS; create table AIS( SEARCH_ID NUMBER(22) NOT NULL, USER_ID VARCHAR2(9) NOT NULL, DATE_STAMP DATE NOT NULL, CII VARCHAR2(8), CDC VARCHAR2(9), MISC_NUMBER VARCHAR2(20), OCA VARCHAR2(20), NUM_TYPE VARCHAR2(2), FCN VARCHAR2(13), CYA VARCHAR2(9), OLN VARCHAR2(20), OLN_STATE VARCHAR2(2), FBI VARCHAR2(15), SSN VARCHAR2(9), NUM_MATCHES NUMBER(6)) tablespace VCIN_COMM storage (initial 4M next 1M pctincrease 0 maxextents 200); --drop table ALL_LOCATION_SEARCHES; create table ALL_LOCATION_SEARCHES( SEARCH_ID NUMBER(22) NOT NULL, USER_ID VARCHAR2(9) NOT NULL, DATE_STAMP DATE NOT NULL, SOURCE VARCHAR2(3), LOCATION_TYPE VARCHAR2(3), LOCATION_NAME VARCHAR2(50), APARTMENT_NUMBER VARCHAR2(10), CITY VARCHAR2(50), COUNTY VARCHAR2(50), COORDINATE VARCHAR2(6), PAGE VARCHAR2(4), STATE_ID VARCHAR2(2), STREET VARCHAR2(35), STREET_NUMBER VARCHAR2(10), ZIP VARCHAR2(9), NUM_MATCHES NUMBER(6)) tablespace VCIN_COMM storage (initial 64K next 64K pctincrease 0 maxextents 200); --drop table ALL_PERSON_SEARCHES; create table ALL_PERSON_SEARCHES( SEARCH_ID NUMBER(22) NOT NULL, USER_ID VARCHAR2(9) NOT NULL, DATE_STAMP DATE NOT NULL, LAST VARCHAR2(25), FIRST VARCHAR2(25), MIDDLE VARCHAR2(25), SEX VARCHAR2(1), AGE NUMBER(22), DOBIRTH DATE, RACE VARCHAR2(1), HGT VARCHAR2(3), HAIR VARCHAR2(3), EYE VARCHAR2(3), NUM_MATCHES NUMBER(6)) tablespace VCIN_COMM storage (initial 8M next 4M pctincrease 0 maxextents 200); --drop table ALL_VEHICLE_SEARCHES; create table ALL_VEHICLE_SEARCHES( VEH_SEARCH_ID NUMBER(22) NOT NULL, USER_ID VARCHAR2(9) NOT NULL, DATE_STAMP DATE NOT NULL, LICENSE VARCHAR2(20), LICENSE_STATE VARCHAR2(2), VIN VARCHAR2(20), NUM_MATCHES NUMBER(6)) tablespace VCIN_COMM storage (initial 64K next 64K pctincrease 0 maxextents 200); ...