This content has been marked as final. Show 1 reply
SQL Developer requires a migration repository to migrate a third-party database to an Oracle database. To use an Oracle database for the migration repository, you must have access to that database using a database user account. Oracle recommends that you use a specific user account for migrations, For example, you may want to create a user named MIGRATIONS, create a database connection to that user, and use that connection for the migration repository; and if you wish, you can later delete the MIGRATIONS user to remove all traces of the migration from the database.
When you create a user for migrations, specify the tablespace information as in the following example, instead of using the defaults for tablespaces:
CREATE USER migrations IDENTIFIED BY password
DEFAULT TABLESPACE users TEMPORARY TABLESPACE temp,
Do not use a standard account (for example, SYSTEM) for migration
So essentially you create an Oracle user whose schema is to be used as the destination for the objects to be migrated,
or use an existing Oracle user and schema.
Oracle® SQL Developer User's Guide
Part Number E17472-05
There is also SQL Server specific documentation
Oracle® SQL Developer Supplementary Information for Microsoft SQL Server and Sybase Adaptive Server Migrations
Part Number E18462-03