Test sakai-2.7.2 Oracle conversion scripts

Re-ran the conversion with the fixed SAK-20926, it was happier.

Unexpected Tables:
SEARCH_JOURNAL
SEARCH_NODE_STATUS
SEARCH_TRANSACTION
Missing Views: NONE
Unexpected Views: NONE
Changed Views: NONE
Missing Columns: NONE
Unexpected Columns: NONE
Changed Columns:
SAKAI_CLUSTER.UPDATE_TIME
WARNING 8/4/11 3:47 PM:liquibase: Unknown Data Type: -101 (TIMESTAMP(6) WITH TIME ZONE). Assuming it does not take parameters
from TIMESTAMP(6) WITH TIME ZONE to DATE

Running the conversion script on an auto.ddl 2.7.1 at : https://source.sakaiproject.org/svn/reference/trunk/docs/conversion/sakai_2_7_1-2_7_2_oracle_conversion.sql
as of today (07/29) gives these errors:

FAILURE: ORA-01442: column to be modified to NOT NULL is already NOT NULL
– failed command:
alter table PROFILE_IMAGES_T modify RESOURCE_MAIN varchar2(4000) not null;
FAILURE: ORA-01442: column to be modified to NOT NULL is already NOT NULL
– failed command:
alter table PROFILE_IMAGES_T modify RESOURCE_THUMB varchar2(4000) not null;
FAILURE: ORA-01442: column to be modified to NOT NULL is already NOT NULL
– failed command:
alter table PROFILE_IMAGES_EXTERNAL_T modify URL_MAIN varchar2(4000) not null;
6 commands in 307 msec; avg. time 51.166 msec; 19 per second (sakai_2_7_1-2_7_2_oracle_conversion.sql)

It does not run the conversion, liquibase has these errors: (Not sure what's up with search?)

Unexpected Tables:
SEARCH_JOURNAL
SEARCH_NODE_STATUS
SEARCH_TRANSACTION
Missing Views: NONE
Unexpected Views: NONE
Changed Views: NONE
Missing Columns: NONE
Unexpected Columns: NONE
Changed Columns:
PROFILE_IMAGES_T.RESOURCE_MAIN
from VARCHAR2(255 CHAR) to VARCHAR2(4000 BYTE)
PROFILE_IMAGES_T.RESOURCE_THUMB
from VARCHAR2(255 CHAR) to VARCHAR2(4000 BYTE)
SAKAI_CLUSTER.UPDATE_TIME
WARNING 7/29/11 6:04 PM:liquibase: Unknown Data Type: -101 (TIMESTAMP(6) WITH TIME ZONE). Assuming it does not take parameters
from TIMESTAMP(6) WITH TIME ZONE to DATE
Missing Foreign Keys: NONE
Unexpected Foreign Keys: NONE
Missing Primary Keys: NONE
Unexpected Primary Keys:
SYS_C00687005 on SEARCH_JOURNAL(TXID)
SYS_C00687009 on SEARCH_NODE_STATUS(SERVERID)
SYS_C00687000 on SEARCH_TRANSACTION(TXNAME)

Procedure :
1) Bring up 2.7.1 auto.ddl in DB1
2) Run conversion script on 2.7.1 in DB1
3) Bring up 2.7.x auto.ddl in DB2
4) Run liquibase comparision against DB1 and DB2
5) Clean DB1 & DB2