SQL Developer

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!

SQL Server to Oracle migration : column semantics

user12017111May 13 2014 — edited May 16 2014

I am testing a migration from SQL Server 2012 to Oracle 12c using migration wizard of SQL Developer 4.0.0.13. The problem that I am facing is all the generated table creation scripts have CHARACTER semantics for character columns. I would like the semantics to be BYTES. As the generated tables and columns are several thousand its not possible to manually change the semantics.

CREATE TABLE account_dod (

account_id VARCHAR2(16 CHAR) NOT NULL,

I cant seem to find any option to change the semantics during generation. Does anyone know of any option that I can set so that migration wizard will generate all columns as BYTES ?

Many Thanks

This post has been answered by Dermot ONeill-Oracle on May 16 2014

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 13 2014

Added on May 13 2014

#sql-developer

6 comments

2,516 views