My Oracle Support Banner

Unable To Migrate A View From Mysql To Oracle Using Sql Developer Workbench 2.1.1 - Generate Error (Doc ID 1195077.1)

Last updated on FEBRUARY 05, 2019

Applies to:

Oracle SQL Developer - Version 2.1.0 to 2.1.2
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.


A view is not being migrated using Sql*Developer Workbench 2.1.1 while migrating from Mysql to Oracle.
After capturing the MySQL database the following error is given after choosing the the 'Generate' option on the converted model -

View 'view_name' has a language id of 'MySQL' so will not output for generation.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.