2 Replies Latest reply: Jul 15, 2013 2:49 PM by dbcapoeira RSS

    Associate Migration Repository SQLDev 4.0 EA1

    dbcapoeira

      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.

        • 1. Re: Associate Migration Repository SQLDev 4.0 EA1
          Turloch O'Tierney-Oracle

          Hi

          I would say the database user did not have space privileges on the tablespace.

          Something like:

                    drop and create the user from a sql prompt then  "Grant unlimited tablespace to <user>" as dba. then associate the repository

                    (associate should do all the creates and inserts)

          (Granting "resource" used to give space privileges on the tablespace, not in 12c.)

           

          You can create a table in the tablespace with no data in 12c as that is a metadata operation - no blocks are touched in the target tablespace.

          An 'empty' starting repository has a few data entries such as its version number.

           

          -Turloch

          SQLDeveloper Team

          • 2. Re: Associate Migration Repository SQLDev 4.0 EA1
            dbcapoeira

            Thanks!  That was the issue.  I was using documentation from OTN.  Made the suggestion to update that to include this: "Grant unlimited tablespace to <user>" as dba since it looks like it is unique to 12c.  Thanks again.