My Oracle Support Banner

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

Last updated on JANUARY 30, 2022

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.

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

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
Goal
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.