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:
Message was edited by: dbcapoeira. Added database diff report.
I would say the database user did not have space privileges on the tablespace.
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.