Problem Creating SQL*Developer Migration Repository - SQL Error on Script Execution (Doc ID 1680644.1)

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 ***

Goal

Trying to create a SQL*Developer Migration Repository using an Oracle account (Oracle Database 11gR2 and 12c ) fails with the following message:

"SQL Error on Script Execution.
Try deleting repository before Creating Repository"


Following the tutorial from the Oracle documentation:

http://www.oracle.com/technetwork/database/migration/omwb-getstarted-093461.html

- 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.
 

Solution

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