Uploaded image for project: 'Sakai'
  1. Sakai
  2. SAK-31529

oracle 10.5 conversion script - cannot alter column type because it contains data

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Awaiting Review
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 11.0, 12.0
    • Fix Version/s: None
    • Component/s: Reference
    • Labels:
      None

      Description

      When testing the database conversion scripts we need to run from Sakai 2.9.1 to 11, the script sakai_10_3-10_5_oracle_conversion.sql contains the following line, which fails on our DB because the column is not empty:

      > ALTER TABLE SAM_QUESTIONPOOLITEM_T MODIFY ( ITEMID NUMBER(19) );

      SQL Error: ORA-01439: column to be modified must be empty to change datatype

      The workaround I'm testing is to create a new column, copy the existing data, drop the existing column, rename the new column with the correct data type, and finally recreate the indexes/constraints that existed.

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Assignee:
                maintenanceteam Core Team
                Reporter:
                curtisvo Curtis van Osch
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:

                  Git Source Code