Sql-server – Migrate SQL Server to Oracle 11G Offline (OMWB)

migrationoraclesql server

So, I'm having some difficult to migrate SQL Server to Oracle. This time there appears a new error message:

Migration actions have failed check the migration reports for details. :
Capture 
Offline Capture 
ORA-00942: table or view do not exist.

I executed the OMWB_OFFLINE_CAPTURE.bat, I passed the parameter to batch and generated the directory with database related.

After, I executed "Migrate To Oracle" I caught the sqlserver2008.ocp file, I finalized, and that error mentioned above appeared. And it does not show the table or view nonexistent.

How do I fix it?

Best Answer

The resolution is:

GRANT CONNECT, RESOURCE, CREATE VIEW, CREATE MATERIALIZED VIEW, CREATE SESSION TO YOUR_USER

Or grant DBA Privilege

Before you granted the privileges, delete the repository associate and create again with new privileges or create the repository before you grant the privilege.

This way resolve the problem.

Related Question