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:
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 (126.96.36.199 and 188.8.131.52) but both give the same error.
However, I have noticed that the 184.108.40.206 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:
Capturing Constraint Details : FAILED : Database Migration : FAILED
I am attempting to migrate into an Oracle 220.127.116.11.0 Enterprise Edition database.
Any ideas would be much appreciated