Skip to Main Content
Forums

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Associate Migration Repository SQLDev 4.0 EA1

dbaOnTapJul 13 2013 — edited Jul 15 2013

Currently getting the following error when running the Associate Migration Repository with DB12c:

SQL Error on Script Execution

Try deleting repository before Creating Repository

IT appears as though the process completes, as the database object are created.  However I don't get this in 11gR2 or XE.  Any ideas.

Did a DatabaseDiff and here are the results:

Types:

MIGR_REPORT_DETAIL_ROW

MIGR_REPORT_DETAIL_TABLE

MIGR_REPORT_SUM_ROW

MIGR_REPORT_SUM_TABLE

Indexes:

MD_STORED_PROGRAS_IDX2

MD_DERIVATIVES_PERF_IDX1

MIGRLOG_PERF_IDX

MD_ADDITIONAL_PROPERTIES_IDX

MD_DERIVATIVES_PERF_IDX3

MD_DERIVATIVES_PERF_IDX2

MD_TABLES_PERF_IDX2

MD_TABLES_PERF_IDX1

MD_DERIVATIVES_PERF_IDX4

MD_COLUMNS_PERF_IDX

MD_DERIVATIVES_PERF_IDX

Packages:

MIGRATION

MIGRATION_REPORT

MIGRATION_TRANSFORMER

Packages Bodies:

MIGRATION

MIGRATION_REPORT

MIGRATION_TRANSFORMER

Message was edited by: dbcapoeira.  Added database diff report.
This post has been answered by Turloch O'Tierney-Oracle on Jul 15 2013
Jump to Answer

Comments

Erik Janssen-Oracle
Keep in mind that WebLogic is a replacement of OC4J in the Application Server stack. What do you intend to use it for ?
10574
We want to migrate from Application server to WebLogic.
Erik Janssen-Oracle
Sure, but what kind of environment are you migrating? Custom J2EE application, Oracle Forms, Portal ?
10574
Custom J2EEE Applications and portal.
10574
Windows Environment, Custom J2EE applications and Portal
Erik Janssen-Oracle
WebLogic is fine for J2EE. Should be faster than OC4J especially if you use JROCKET.

Assuming that you use Oracle Portal :

The latest Oracle Portal version (11g) utilizes WebLogic. Older versions use OC4J. I'd go for the latest version. Oracle might desupport the 10g version end of 2011.

Thanks,
EJ
1 - 6
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Aug 12 2013
Added on Jul 13 2013
#database, #developer, #migration, #repository, #sql, #sql-developer, #sqldeveloper
2 comments
2,367 views