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