Parameters specific to database bugs and behavior changes - 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

A change in the behavior of the RDBMS requires the following parameter to be set. This is documented in Oracle Metalink note 271939.1.

Alter system set "_allow_level_without_connect_by" = TRUE scope=spfile;

If you are using an INIT.ORA file, add the parameter to your init.ora file. In both scenarios, you must restart the database for the new parameter to be take effect.

If you will be using the original exp and imp utilities, set the following parameter to assure that tables with 0 rows are included in exports. The change in behavior is documented in Oracle Metalink document id 887962.1.

Alter system set deferred_segment_creation=false scope=spfile;

After the database and operating system parameters have been set, restart the database.