Problem Creating SQL*Developer Migration Repository - SQL Error on Script Execution
(Doc ID 1680644.1)
Last updated on SEPTEMBER 20, 2019
Applies to:Oracle SQL Developer - Version 4.0 and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.
*** Checked for relevance on 10/27/2014 ***
Trying to create a SQL*Developer Migration Repository using an Oracle account (Oracle Database 11gR2 and 12c ) fails with the following message:
Try deleting repository before Creating Repository"
Following the tutorial from the Oracle documentation:
- the system privileges have been granted:
RESOURCE, CREATE SESSION, CREATE VIEW
Before running "Associate Migration Repository" it was checked that there were no tables or packages created.
Trying to truncate and delete repository also gives error. When trying to delete it gives an error, because the repository is not created.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document