Forum Stats

  • 3,815,361 Users
  • 2,259,005 Discussions
  • 7,893,053 Comments

Discussions

lb genschema ignores COLLATION_CLAUSE

rode_mb
rode_mb Member Posts: 2 Green Ribbon

when exporting a schema all tables are generated with unnecessary collation clause, e.g.

 CREATE TABLE "SOME_TABLE"  (   "ID" NUMBER,   "SOME_TEXT" VARCHAR2(400) COLLATE "USING_NLS_COMP"  ) DEFAULT COLLATION "USING_NLS_COMP";

using dbms_metadata or "sqlcl ddl" everything works fine after calling:

dbms_metadata.set_transform_param(dbms_metadata.SESSION_HANDLE, 'COLLATION_CLAUSE', 'NEVER');

is there a workaround to make it work with lb genschema?

Answers