Open SQL Plus and execute the following scripts to verify the installation:
Script |
Function |
---|---|
71testdb.sql |
Shows objects that are missing compared to a default and complete installation. The information reported by this script is also contained in the end of the 80ed117i.sql file, which runs the following queries: PROMPT Base HxGN EAM columns missing in the current HxGN EAM build: PROMPT Base HxGN EAM Database objects missing in the current HxGN EAM build: PROMPT Base HxGN EAM Database constraints missing in the current HxGN EAM build: After running this script, compare the information generated with the information contained in the following tables to verify the installation: R5USERTABCOLUMNS and R5USEROBJECTS. |
All database objects should be valid. Run the 7icomp.sql script to compile and list remaining invalid objects.