Oracle Database Discussions

I am performing a conversion between DB2  to Oracle 11 XE, using the SQL Developer Migration Wizard. Specifically I am trying to migrate the DB2User schema over to Oracle.

Using the migration wizard, when I pick the Oracle target connection to be the same schema ( DB2User schema ) the migration is successful and all data is converted.

However if I pick a different Oracle target connection ( say OracleUser ) , I run into issues.

Firstly , the table schema is not created. When I check the project output directory, the .out file has the following errors:

   CREATE USER DB2User IDENTIFIED BY DB2User DEFAULT TABLESPACE USERS TEMPORARY TABLESPACE TEMP

        SQL Error: ORA-01031: insufficient privileges

        01031. 00000 -  "insufficient privileges"

    connect DB2User/DB2User

    Error report:

    Connection Failed

    Commit

    Connection created by CONNECT script command disconnected

I worked around this by manually executing the .sql in the project output directory using the OracleUser id  in the new DB.

Then I continue with the migration wizard and perform the Move Data step.

Now - the message appears as succuessful, however, when I review the Migrationlog.xml file, i see errors as follows:

<level>SEVERE</level>

  <class>oracle.dbtools.migration.workbench.core.logging.MigrationLogUtil</class>

  <message>Failed to disable constraints: Data Move</message>

  <key>DataMove.DISABLE_CONSTRAINTS_FAILED</key>

  <catalog>&lt;null&gt;</catalog>

  <param>Data Move</param>

  <param>oracle.dbtools.migration.workbench.core.logging.LogInfo@753f827a</param>

  <exception>

    <message>java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist</message>

  <level>WARNING</level>

  <class>oracle.dbtools.migration.datamove.online.TriggerHandler</class>

  <message>ORA-01031: insufficient privileges

</message>

I think what is happening is that the wizard is attempting to perform the 'move data' process using the DB2User id.

How do I tell the wizard that the target schema is different than my source schema.

My requirement is that I need to be able to migrate the DB2User schema to different schemas in the same Oracle database

( since we will have multiple test environments under the same database ) .

Thanks in advance .

K.