Preparation of Source Database Export - Intergraph Smart Materials - Version 10.1 - Installation & Upgrade - Hexagon

Intergraph Smart Materials Installation (10.1)

Language
English
Product
Intergraph Smart Materials
Subproduct
Classic
Search by Category
Installation & Upgrade
Smart Materials/Smart Reference Data Version
10.1

Before the source database is exported, you must modify the database as described below. The statement must only be executed as M_SYS!

  1. Launch a SQL*Plus session and connect as m_sys.

  2. set linesize 2000

  3. set heading off

  4. spool alter_table_run.sql

  5. 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 '+';

  6. spool off

  7. @alter_table_run.sql