analytics/configuration/schemas/content/oracle/dbUpgrade6_0023-to-7_0001_oracle.sql

-- Licensed Materials - Property of IBM
--
-- BI and PM: CM
--
-- (C) Copyright IBM Corp. 2011, 2013
--
-- US Government Users Restricted Rights - Use, duplication or disclosure
-- restricted by GSA ADP Schedule Contract with IBM Corp.

create table TEMPCMREFORD2 (
	CMID      number(10) not null,
	ORD       number(10) not null,
	REFCMID   number(10) not null);

insert into TEMPCMREFORD2 select CMID, ORD, REFCMID from CMREFORD2;

drop table CMREFORD2;

alter table TEMPCMREFORD2 rename to CMREFORD2;