Before the source database is exported, you must modify the database as described below. The statement must only be executed as M_SYS!
-
Launch a SQL*Plus session and connect as m_sys.
-
set linesize 2000
-
set heading off
-
spool alter_table_run.sql
-
select ' alter table ' || table_name || ' modify ' || column_name || ' varchar2 (' || CHAR_LENGTH || ' char);'
FROM user_tab_columns c
where data_type = 'VARCHAR2'
and CHAR_USED = 'B'
and table_name LIKE 'M+_%' ESCAPE '+';
-
spool off
-
@alter_table_run.sql