Associate Migration Repository SQLDev 4.0 EA1

dbaOnTap

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.

Turloch O'Tierney-Oracle

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

Turloch O'Tierney-Oracle

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

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.