Document Type | Troubleshooting
Category | Migration
Applicable Product Version | 6FS06, 6FS07, 7FS02
Document Number | TMITS010
Issue
When migrating from another DBMS (Oracle) to Tibero, comments may not be displayed correctly.
Cause
Comments may not be properly recorded due to Korean character issues during data migration.
Solutions
Use the query below to extract comments from the other DBMS (Oracle) and re-migrate them to Tibero.
table comment
select 'COMMENT on TABLE '||owner||'.'||table_name||' IS '''||comments||''';' from dba_tab_comments where owner='**SYSCAT**' <= Change to the user name to be migrated and comments is not null;
column comment
select 'COMMENT on COLUMN '||owner||'.'||table_name||'.'||column_name||' IS '''||comments||''';' from dba_col_comments where owner='SYSCAT' and comments is not null;