0 Replies Latest reply: Dec 17, 2013 3:10 PM by Homerc RSS

    Errors migrating MS Access 2003 database to Oracle

    Homerc

      Hi,

       

      I wonder if anyone could give me some pointers with some errors I am encountering whilst migrating an MS Access 2003 database

      to Oracle through SQL Developer.

       

      The migration of the offline xml file fails with the following error:

       

      Offline Capture

      ORA-06550: line 1, column 14:

      PLS-00201: identifier 'MIGRATION.GATHERCONNECTIONSTATS' must be declared

      Capturing Stored Procedure zztestexport: FAILED : Database Migration : FAILED

       

      I have tried the migration with two versions of SQL Developer (3.0.0.4 and 4.0.0.13) but both give the same error.

      However, I have noticed that the 4.0.0.13 version in addition also displays the following exception with oracle.ide.IdeCore:

       

      Exception firing mainWindowOpened to oracle.dbtools.migration.workbench.plugin.MSAccessPlugin$1@a3065a8

       

      The other thing I've tried is migrating the Northwind MS Access migration tutorial xml file which gives a very

      similar error on both SQL Developer versions:

       

      Off line Capture

      ORA-06550: line 1, column 7:

      PLS-00201: identifier 'MIGRATION.GATHERCONNECTIONSTATS' must be declared

      Capturing Constraint Details : FAILED : Database Migration : FAILED

       

      I am attempting to migrate into an Oracle 11.2.0.2.0 Enterprise Edition database.

       

      Any ideas would be much appreciated

       

      Regards

       

      Colin