SQL> desc assignment_submission
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 SUBMISSION_ID                             NOT NULL VARCHAR2(99)
 CONTEXT                                   NOT NULL VARCHAR2(99)
 SUBMITTER_ID                              NOT NULL VARCHAR2(99)
 SUBMIT_TIME                                        VARCHAR2(99)
 SUBMITTED                                          VARCHAR2(6)
 GRADED                                             VARCHAR2(6)
 XML                                                LONG

SQL> 
SQL> alter table assignment_submission modify xml clob;

Table altered.

SQL> desc assignment_submission
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 SUBMISSION_ID                             NOT NULL VARCHAR2(99)
 CONTEXT                                   NOT NULL VARCHAR2(99)
 SUBMITTER_ID                              NOT NULL VARCHAR2(99)
 SUBMIT_TIME                                        VARCHAR2(99)
 SUBMITTED                                          VARCHAR2(6)
 GRADED                                             VARCHAR2(6)
 XML                                                CLOB

SQL> @/net/oracle/admin/SAKAITST/create/sakai_2_6_0-2_6_1_oracle_conversion.sql

75 rows updated.


75 rows updated.


75 rows updated.


75 rows updated.


75 rows updated.


75 rows updated.


75 rows updated.


75 rows updated.


75 rows updated.


75 rows updated.


75 rows updated.


75 rows updated.


75 rows updated.


75 rows updated.


75 rows updated.


75 rows updated.


0 rows merged.


0 rows updated.

SQL> spool off