Hi! I am currently migrating a database from MS SQL Server 2000 to Oracle 11g. Using:
SQL Developer Version 4.0.2.15 Build 15.21
jdk1.7.0_65
I have sysad account in MS SQL Server 2000 but have limited privilege with the Oracle 11g as we have another IT group governing them. Reading the documentation of the said migration in the tutorial Migrating a Microsoft SQL Server Database to Oracle Database 11g, I asked our IT to create the user using the following script:
CREATE USER MWREP
IDENTIFIED BY mwrep
DEFAULT TABLESPACE MWREP_DATA
TEMPORARY TABLESPACE TEMP;
GRANT CONNECT, RESOURCE, CREATE SESSION, CREATE VIEW TO MWREP;
Using the defined MWREP user, I tried creating the migration repository using the SQL Developer, but it returned an error:
SQL Error on Script Execution
Try deleting repository before Creating Repository
I tried deleting the repository but it returned an issue information:
Removal of migration repository is complete, however, there was an issue with the removal. There can be several reasons for this. (1)The connection is not open. (2)The repository has been corrupted. (3)There was no repository in this connection. The db objects may not have been removed. The registered connection has been removed from the list of migration repositories
Upon further reading, I stumbled upon these threads: How to delete a repository, How to get Associate Migration Repository when using the tool, and https://blogs.oracle.com/OCP10to11/entry/sqldeveloper_try_deleting_repo, and learned that it is caused by a limited tablespace. Given that, our IT run the following script to alter the MWREP user:
ALTER USER MWREP QUOTA UNLIMITED ON MWREP_DATA;
But I am still encountering the same error upon association of migration repository. Do I need a sysad privilege to continue with the association? (The generated code will be run by the IT after conversion and translation). Does altering the user quota on the tablespace still not enough?
All help are appreciated. Thank you in advance!
Message was edited by: GreenApple101 20140818 GMT +08 Changes: 1. Subject from "SQL Developer: Error on Association of Migration Repository" to "MSSQL Server 2000 to Oracle 11g: Error on Association of Migration Repository" 2. Some grammar corrections