create index OWBNS_sessID_IDX on Reservation_Store(sessID) nologging compress tablespace %tndex ;
create index OWBNSClass_domainName_IDX on Classification_Store(domainName)tablespace %tndex ;

--gggraham: 25Jun2006. Add WorkspaceID for all FCOFOLDERNamespace indexes, including its primary key.
create index OWBCMPNS_parentID_IDX on FCOFOLDERNamespace(workspaceID,parentID) nologging compress tablespace %tndex ;
create index OWBCMPNS_elementid_IDX on FCOFOLDERNamespace(workspaceID,elementid) nologging compress tablespace %tndex ;
create index OWBCMPNS_aggregateParent_IDX on FCOFOLDERNamespace(workspaceID,aggregateParent) nologging compress tablespace %tndex ;
create index FCOFOLDERNS_PK on FCOFOLDERNamespace(workspaceID,parentID,domain,name,isPhys,languageISOID) tablespace %tndex ;

--gggraham: 25Jun2006. Add primary key constraint after index is declare local, partitioned
alter table FCOFOLDERNamespace
  add constraint FCOFOLDERNS_PK primary key
  (workspaceID,parentID,domain,name,isPhys,languageISOID) ;