Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Problem in Migrating SQL Server to Oracle

578113May 17 2007 — edited Jul 6 2007

I am able to create a connection to both the SQL Server and Oracle and also create a Repository.
But when I right click on SQL Server connection and Capture the MS SQL Server I am getting below Error:
"oracle.dbtools.metadata.persistence.PersistenceException: ORA-04098: trigger 'TestDB.MD_PROJECTS_TRG' is invalid and failed re-validation"

Plz help me with this error.

Thanx in advance.

Regards,
Nirav Patel.

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 3 2007

Added on May 17 2007

#database-and-application-migrations

16 comments

3,731 views