drop table run_crates cascade constraints;
commit;
CREATE TABLE RUN_CRATES 
 (CRATE_NAME VARCHAR2(48) NOT NULL
 ,CRATE_DEC NUMBER(32)
 ,EG_NUM VARCHAR2(32)
 ,ATTRIBUTES VARCHAR2(256)
 ,RUN_NUMBER NUMBER(38) NOT NULL
 );

CREATE INDEX RCRATE_RUN_2_FK_I ON RUN_CRATES (RUN_NUMBER);

commit;

insert into run_crates select * from runs.run_crates where run_number<111000;

commit;




