-- Oracle does not support `IF NOT EXISTS` syntax when creating indexes.
-- You should review your database for any of the indexes described here that pre-exist,
-- and omit them from what you apply to your Oracle database.

CREATE UNIQUE INDEX UK7IEGJT4GOJV24Q9BW8K0I4J0C ON BLC_RESOURCE_LOCK(CONTEXT_ID, TYPE_ALIAS, SANDBOX_ID, CONCEPT_KEY) ONLINE;
CREATE INDEX FKKPUCBCMXK6J1CI1DNPQJOSF9BIX ON BLC_TRANSACTION(CREDIT_ACCOUNT_ID) ONLINE;
CREATE INDEX IDX7I0I5VCL1DKKWUQ5DYC88WEM5 ON BLC_NOTIFICATION_STATE(ACKED) ONLINE;
CREATE INDEX IDXD5P9GMS1OXIAEOPHBHXGH5KB6 ON BLC_TRANSACTION(SOURCE_ENTITY_ID) ONLINE;
CREATE INDEX IDXG339LTARHJLB53KIE6I4WHU91 ON BLC_TRANSACTION(TRANSACTION_REFERENCE_ID) ONLINE;
CREATE INDEX IDXGFAQE3XMQ5Q4YH78MIX1G04FY ON BLC_NOTIFICATION_STATE(CONTAINER) ONLINE;
CREATE INDEX IDXKHW3ABX99ME0GVYGY8F9WNRU8 ON BLC_CREDIT_ACCOUNT(OWNING_USER_REF) ONLINE;
CREATE INDEX IDXKM4Y3QJ3JH2MPT0RT6L6VSCL8 ON BLC_RESOURCE_LOCK(TOKEN) ONLINE;
CREATE INDEX IDXN4J14MY27TSAU5WG9F8R4R05X ON BLC_TRANSACTION(REQUEST_ID) ONLINE;
CREATE INDEX IDXOV0VI6LBUE0LBVDEW039HX3UQ ON BLC_CREDIT_ACCOUNT(ACCOUNT_NUMBER) ONLINE;
