create sequence mmmseq start with 1 increment by 1;

create table InputFcos 
(
    seq NUMBER(9),
    fco NUMBER(9),
    ClassName VARCHAR2(255),
    UOID VARCHAR2(255),
    constraint IDX_INPUT_SEQ primary key (seq, fco) using index tablespace %tndex
);

alter  table InputFcos NOLOGGING;
alter  index IDX_INPUT_SEQ NOLOGGING;

create table TempProperties (
    elementId NUMBER(9),
    ptype NUMBER(1),
    constraint TEMPPROPERTIES_PK primary key (elementId, ptype)
) organization index overflow tablespace %tndex;
create index IDX_PROPERTIES_ELEMENTID on TempProperties(elementId) tablespace %tndex;