Step 3. Creating a new schema in Oracle 9i - HxGN EAM - Version 11.7.1 - Installation & Upgrade - Hexagon

HxGN EAM Oracle Database Installation Guide

Language
English
Product
HxGN EAM
Search by Category
Installation & Upgrade
HxGN EAM Version
11.7.1
  1. Execute the following query from SYS.

    select name, value from v$parameter where name='nls_length_semantics';

    The query should return CHAR. If the query does not return CHAR, then execute one of the following queries from SYS.

    alter system set NLS_LENGTH_SEMANTICS=CHAR scope=BOTH

    or

    alter system set NLS_LENGTH_SEMANTICS=CHAR scope=SPFILE

  2. Reboot the Oracle database server.

    Verify that the Oracle home for the database must have the NLS LANG=AMERICAN_AMERICA.AL32UTF8 setting.

  3. Create the new schema in Oracle 9i.

  4. Start SQL*Plus for the Oracle 9i schema and run the 00CU76I.SQL script.

  5. Run the TAB7511.SQL script in the Oracle 9i schema to create empty tables without constraints.

    TAB7511.SQL creates the same table definitions as the Oracle 8i schema from which the export schema was created. However, TAB7511.SQL creates the all the tables from Oracle 8i with the necessary multibyte width for the Oracle 9i multibyte database TAB7511.SQL also table creates the R5DOCBODY table in the default tablespace of the new Oracle 9i schema.

If the Oracle 8i export schema has any extra tables or columns, you must also create any extra tables or columns before importing the Oracle 8i database in the Oracle 9i multibyte database.