Rem drv: <create type="tables" pos="esm/esm_tables.sql-" condition="EM_REPOS_MODE=CENTRAL"/>
Rem
Rem $Header: esm_tables_gc.sql 03-apr-2007.22:59:58 jsadras Exp $
Rem
Rem esm_tables_gc.sql
Rem
Rem Copyright (c) 2007, Oracle. All rights reserved.  
Rem
Rem    NAME
Rem      esm_tables_gc.sql - <one-line expansion of the name>
Rem
Rem    DESCRIPTION
Rem     This tables will be created in gc mode only. For DBSA mode
Rem     the same tables will be created by em_tables_db.sql ( without IOT)
Rem     to avoid running into ORA-01429/1450 on 2k block size db
Rem
Rem     Please update both files on change
Rem
Rem    NOTES
Rem      <other useful comments, qualifications, etc.>
Rem
Rem    MODIFIED   (MM/DD/YY)
Rem    jsadras     04/03/07 - Bug:5964364
Rem    jsadras     04/03/07 - Created
Rem
Rem
CREATE TABLE "ESM_COLLECTION" (
  "ECM_SNAPSHOT_ID" RAW(16) NOT NULL CONSTRAINT "ESM_COLLECTION0" REFERENCES "MGMT_ECM_GEN_SNAPSHOT" ("SNAPSHOT_GUID") ON DELETE CASCADE,
  "PROPERTY" VARCHAR2(64),
  "VALUE" VARCHAR2(512),
  "VALUE2" VARCHAR2(512) DEFAULT 'NA',
  CONSTRAINT "ESM_COLLECTION_PK" PRIMARY KEY ("ECM_SNAPSHOT_ID", "PROPERTY", "VALUE", "VALUE2")
)
ORGANIZATION INDEX --Amir Najmi: we want an index organized table
COMPRESS 2
MONITORING;


-- Create tables
CREATE TABLE "MGMT_ESA_REPORT" (
  "ECM_SNAPSHOT_ID" RAW(16) NOT NULL CONSTRAINT "MGMT_ESA_REPORT0" REFERENCES "MGMT_ECM_GEN_SNAPSHOT" ("SNAPSHOT_GUID") ON DELETE CASCADE,
  "PRINCIPAL" VARCHAR2(512),
  "OBJECT_NAME" VARCHAR2(512),
  "REPORT_NAME" VARCHAR2(256),
  CONSTRAINT "MGMT_ESA_REPORT_PK" PRIMARY KEY ("ECM_SNAPSHOT_ID", "PRINCIPAL", "OBJECT_NAME", "REPORT_NAME")
)
ORGANIZATION INDEX --Amir Najmi: we want an index organized table
COMPRESS
MONITORING;