dbUpgrade7_0034-to-7_0035_oracle.sql 430 B

12345678910111213141516
  1. -- Licensed Materials - Property of IBM
  2. --
  3. -- BI and PM: CM
  4. --
  5. -- (C) Copyright IBM Corp. 2016
  6. --
  7. -- US Government Users Restricted Rights - Use, duplication or disclosure
  8. -- restricted by GSA ADP Schedule Contract with IBM Corp.
  9. CREATE TABLE CMOBJPROPS87 (
  10. CMID number(10) NOT NULL ,
  11. EXT clob null,
  12. CONSTRAINT PK_CMOBJPROPS87 PRIMARY KEY (CMID)
  13. );
  14. insert into CMOBJPROPS87 (CMID) select CMID from CMOBJECTS;