Below are some small diffs. BTW my SQL is rusty but why are you converting scrips.template to a string when its a reference to templates.id? John groenv...@acm.org
--- etc/upgrade/4.1.1/schema.Oracle Sat Oct 5 15:05:15 2013 *************** *** 11,17 **** LastUpdatedBy NUMBER(11,0) DEFAULT 0 NOT NULL, LastUpdated DATE ); ! ALTER TABLE Scrips ADD COLUMN Disabled int2 NOT NULL DEFAULT 0; INSERT INTO ObjectScrips( id, Scrip, Stage, ObjectId, --- 11,17 ---- LastUpdatedBy NUMBER(11,0) DEFAULT 0 NOT NULL, LastUpdated DATE ); ! ALTER TABLE Scrips ADD ( Disabled NUMBER(11,0) DEFAULT 0 NOT NULL ); INSERT INTO ObjectScrips( id, Scrip, Stage, ObjectId, --- etc/upgrade/4.1.5/schema.Oracle Sat Oct 5 15:49:16 2013 *************** *** 1,5 **** # Template column ALTER TABLE Scrips RENAME COLUMN Template TO TemplateOld; ! ALTER TABLE Scrips ADD COLUMN Template VARCHAR2(200) NOT NULL; ! UPDATE TABLE Scrips SET Template = CAST(TemplateOld AS varchar2); ALTER TABLE Scrips DROP COLUMN TemplateOld; --- 1,6 ---- # Template column ALTER TABLE Scrips RENAME COLUMN Template TO TemplateOld; ! ALTER TABLE Scrips ADD ( Template VARCHAR2(200) ); ! UPDATE Scrips SET Template = CAST(TemplateOld AS varchar2(200)); ! ALTER TABLE Scrips MODIFY ( Template VARCHAR2(200) NOT NULL ); ALTER TABLE Scrips DROP COLUMN TemplateOld; --- etc/upgrade/4.1.22/schema.Oracle Sat Oct 5 15:34:26 2013 *************** *** 1 **** ! ALTER TABLE Users ADD COLUMN SMIMECertificate CLOB; --- 1 ---- ! ALTER TABLE Users ADD ( SMIMECertificate CLOB ); -- RT Training in New York, October 8th and 9th: http://bestpractical.com/training