Problem Creating SQL*Developer Migration Repository - SQL Error on Script Execution
Last updated on NOVEMBER 07, 2014
Applies to:Oracle SQL Developer - Version 4.0 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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms