Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

Version 1 Next »

ORACLE

  1. Pass the Upgrade VMCLASSROOTGUID

INSERT INTO "VMCLASSROOTGUID"
("BOLD_ID"

,"BOLD_TYPE"

,"CREATEDATE"

,"CREATEUSER"

,"MODIFDATE"

,"MODIFUSER"

,"OBJSTATUS"

,"STOREDGUID")

select "BOLD_ID"

,"BOLD_TYPE"

,SYSDATE

,' '

,SYSDATE

,' '

,'1'

,' '

--SELECT *

from "ABSECUREITEM"

where BOLD_ID NOT IN (SELECT DISTINCT BOLD_ID FROM "VMCLASSROOTGUID")

Commit;

-- Update VmPackage

UPDATE VMPACKAGE SET PACKAGEKIND = 5 WHERE PACKAGEKIND = 4;

Commit;

  • No labels

0 Comments

You are not logged in. Any changes you make will be marked as anonymous. You may want to Log In if you already have an account.