Rem drv: <migrate type="schema_upgrade" version="11.0.0.0"/>
Rem
Rem $Header: stgAdv_tables.sql 21-mar-2007.07:34:52 mnihalan Exp $
Rem
Rem stgAdv_tables.sql
Rem
Rem Copyright (c) 2007, Oracle. All rights reserved.  
Rem
Rem    NAME
Rem      stgAdv_tables.sql - <one-line expansion of the name>
Rem
Rem    DESCRIPTION
Rem      <short description of component this file declares/defines>
Rem
Rem    NOTES
Rem      <other useful comments, qualifications, etc.>
Rem
Rem    MODIFIED   (MM/DD/YY)
Rem    mnihalan    03/19/07 - Upgrade for storage advisor tables
Rem    mnihalan    03/19/07 - Created
Rem

Rem
Rem Bug 5937135
Rem Change the size of the col obj_lob_col to 500 from 4000 because in 
Rem some environments we get an error if the key column is very long

CREATE TABLE "MGMT_TE_RECSEGMENTSETTINGS_ECM" as (
	select ecm_snapshot_id, obj_type, obj_owner, obj_name, obj_partition, 
	    substr(obj_lob_col, 0, 500) obj_lob_col, tablespace, segment_type,
            problem_code 
       from "MGMT_DB_RECSEGMENTSETTINGS_ECM");
DROP TABLE "MGMT_DB_RECSEGMENTSETTINGS_ECM";
ALTER TABLE "MGMT_TE_RECSEGMENTSETTINGS_ECM" rename to "MGMT_DB_RECSEGMENTSETTINGS_ECM";
ALTER TABLE "MGMT_DB_RECSEGMENTSETTINGS_ECM" ADD 
	( CONSTRAINT "MGMT_DB_RECSEGMENTSETTINGS_PK" 
        	PRIMARY KEY (ECM_SNAPSHOT_ID, 
		OBJ_TYPE, OBJ_OWNER, OBJ_NAME, OBJ_PARTITION, 
		OBJ_LOB_COL, SEGMENT_TYPE, PROBLEM_CODE) VALIDATE ) ;
ALTER TABLE "MGMT_DB_RECSEGMENTSETTINGS_ECM" ADD 
	( CONSTRAINT "MGMT_DB_RECSEGMENTSETTINGS_0" 
		FOREIGN KEY ("ECM_SNAPSHOT_ID") 
	REFERENCES "MGMT_ECM_GEN_SNAPSHOT" ("SNAPSHOT_GUID") VALIDATE );

COMMIT;