Forum Stats

  • 3,826,750 Users
  • 2,260,703 Discussions
  • 7,897,071 Comments

Discussions

Associate Migration Repository SQLDev 4.0 EA1

dbaOnTap
dbaOnTap Member Posts: 58 Bronze Badge
edited Jul 15, 2013 3:49PM in SQL Developer

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.

Best Answer

  • Turloch O'Tierney-Oracle
    Turloch O'Tierney-Oracle Member Posts: 1,041 Employee
    Answer ✓

    Hi dbcapoeira 


    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

Answers

  • Turloch O'Tierney-Oracle
    Turloch O'Tierney-Oracle Member Posts: 1,041 Employee
    Answer ✓

    Hi dbcapoeira 


    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

  • dbaOnTap
    dbaOnTap Member Posts: 58 Bronze Badge

    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.

This discussion has been closed.