Document-ID: 28449.1
Subject: (V45) INSTALLING BASE TABLES FOR DEVELOPER/2000
Author: BPATEL
Last Modified Date: 26 May 1995
How to Install Base Tables for Developer 2000 Tools
This document explains how to install base tables for Developer 2000 Tools
(i.e. Oracle Forms V4.5, Oracle Reports V2.5 and Oracle Graphics V2.5).
Developer 2000 Tools allow saving modules to file system or database.
To be able to save modules to the database, all bases tables must exist.
If any of the base tables are missing or corrupt, usually
ORA-942 : "Table or view does not exist" or other errors will occur.
Types of Base Tables
====================
There are a number of tables, views and synonyms which are shared by Oracle
Forms, Oracle Reports and Oracle Graphics. They have prefixes TOOLS, ROS,
VG, GC or DE. Base tables for Oracle Forms 4.5, Reports 2.5, and Graphics 2.5
have prefixes FRM45, SRW2, and GO respectively.
Check Common Base Tables, Views and Synonyms
============================================
Before you install the base tables, you need to find out if they exist already
and thus skip the installation of existing objects. This process can be started
from checking objects shared by all CDE products. Put the following code into
a SQL*Plus script called checkobjects.sql.
set space 0
set escape off
set pagesize 100
column object_name format a30
column owner format a30
column object_type format a20
select object_name, owner, object_type from sys.dba_objects
where object_name like 'TOOL\_%' escape '\' or
object_name like 'ROS%' or
object_name like 'VG\_%' escape '\' or
object_name like 'GC\_%' escape '\' or
object_name like 'DE\_%' escape '\'
order by object_name, object_type;
Now log into SQL*Plus as SYSTEM (default password is MANAGER) and type:
SQL>start checkobjects.sql
You should see the following list of objects returned :
OBJECT_NAME OWNER OBJECT_TYPE
-------------------------------------------------------------------------
DE_ATTACHED_LIBS PUBLIC SYNONYM
DE_ATTACHED_LIBS SYSTEM VIEW
DE_ATTACHED_LIBS_IDX SYSTEM INDEX
DE__ATTACHED__LIBS SYSTEM TABLE
GC_CHARTING PUBLIC SYNONYM
GC_CHARTING SYSTEM VIEW
GC_FIELD PUBLIC SYNONYM
GC_FIELD SYSTEM VIEW
GC_REFERENCE PUBLIC SYNONYM
GC_REFERENCE SYSTEM VIEW
GC__CHARTING SYSTEM TABLE
GC__FIELD SYSTEM TABLE
GC__REFERENCE SYSTEM TABLE
ROSATTRIBS PUBLIC SYNONYM
ROSATTRIBS SYSTEM VIEW
ROSLFDESC PUBLIC SYNONYM
ROSLFDESC SYSTEM TABLE
ROSLFDESC_ID SYSTEM SEQUENCE
ROSLFDESC_ID PUBLIC SYNONYM
ROSOBJMAP PUBLIC SYNONYM
ROSOBJMAP SYSTEM TABLE
ROSSEQUENCES PUBLIC SYNONYM
ROSSEQUENCES SYSTEM TABLE
ROSSTRINGS PUBLIC SYNONYM
ROSSTRINGS SYSTEM TABLE
ROSSTRUCTS PUBLIC SYNONYM
ROSSTRUCTS SYSTEM VIEW
ROSTFDESC PUBLIC SYNONYM
ROSTFDESC SYSTEM TABLE
ROSTFDESC_ID SYSTEM SEQUENCE
ROSTFDESC_ID PUBLIC SYNONYM
TOOL_ACCESS PUBLIC SYNONYM
TOOL_ACCESS SYSTEM VIEW
TOOL_ACCESSIBLE PUBLIC SYNONYM
TOOL_ACCESSIBLE SYSTEM VIEW
TOOL_ACCESSIBLE_IDX SYSTEM INDEX
TOOL_ACCESS_IDX SYSTEM INDEX
TOOL_COMMENT PUBLIC SYNONYM
TOOL_COMMENT SYSTEM VIEW
TOOL_COMMENT_IDX SYSTEM INDEX
TOOL_DEPEND PUBLIC SYNONYM
TOOL_DEPEND SYSTEM VIEW
TOOL_DEPENDENT PUBLIC SYNONYM
TOOL_DEPENDENT SYSTEM VIEW
TOOL_LIBRARY PUBLIC SYNONYM
TOOL_LIBRARY SYSTEM VIEW
TOOL_LIBRARY_IDX SYSTEM INDEX
TOOL_LRAW PUBLIC SYNONYM
TOOL_LRAW SYSTEM VIEW
TOOL_LRAW_ID SYSTEM SEQUENCE
TOOL_LRAW_ID PUBLIC SYNONYM
TOOL_LRAW_IDX1 SYSTEM INDEX
TOOL_LRAW_IDX2 SYSTEM INDEX
TOOL_LTEXT PUBLIC SYNONYM
TOOL_LTEXT SYSTEM VIEW
TOOL_LTEXT_ID SYSTEM SEQUENCE
TOOL_LTEXT_ID PUBLIC SYNONYM
TOOL_LTEXT_IDX1 SYSTEM INDEX
TOOL_LTEXT_IDX2 SYSTEM INDEX
TOOL_MODID SYSTEM SEQUENCE
TOOL_MODID PUBLIC SYNONYM
TOOL_MODTYPE_IDX SYSTEM INDEX
TOOL_MODULE PUBLIC SYNONYM
TOOL_MODULE SYSTEM VIEW
TOOL_MODULE_IDX SYSTEM INDEX
TOOL_PLSQL PUBLIC SYNONYM
TOOL_PLSQL SYSTEM VIEW
TOOL_PLSQL_IDX SYSTEM INDEX
TOOL__ACCESS SYSTEM TABLE
TOOL__COMMENT SYSTEM TABLE
TOOL__DEPEND SYSTEM TABLE
TOOL__LIBRARY SYSTEM TABLE
TOOL__LRAW SYSTEM TABLE
TOOL__LTEXT SYSTEM TABLE
TOOL__MODULE SYSTEM TABLE
TOOL__PLSQL SYSTEM TABLE
VG_COLOR PUBLIC SYNONYM
VG_COLOR SYSTEM VIEW
VG_DRAWING PUBLIC SYNONYM
VG_DRAWING SYSTEM VIEW
VG_FONT PUBLIC SYNONYM
VG_FONT SYSTEM VIEW
VG_IMAGE PUBLIC SYNONYM
VG_IMAGE SYSTEM VIEW
VG__COLOR SYSTEM TABLE
VG__DRAWING SYSTEM TABLE
VG__FONT SYSTEM TABLE
VG__IMAGE SYSTEM TABLE
88 rows selected.
Make sure all the objects listed above exist. The owner and type of the
objects also have to be the same as above. If there is any discrepancy,
you need to re-install those objects. Use SQL*Plus command DESCRIBE to
check the structure of some of the tables. All the string data type must
be VARCHAR2, otherwise re-installation of base objects is also needed.
Install / Re-install Common Base Tables
=======================================
BEFORE YOU RUN ANY SCRIPTS, MAKE SURE YOU HAVE A BACKUP OF THE DATABASE AND
SOURCE FILES FOR ALL APPLICATIONS (FMB AND MMB FILES FOR ORACLE FORMS; PLL
FILES FOR PL/SQL LIBRARY; RDF AND SQL FILES FOR ORACLE REPORTS; OGD FILES FOR
ORACLE GRAPHICS). Since the common base tables are shared by different CDE
Tools, dropping them may cause loss of data from other tools.
The following scripts need to be run in order to build the base tables. Log
into SQL*Plus as SYSTEM to execute them and make sure the order in which they
are specified is followed. Note that when you run the "grant" scripts (the
xxxgrnt.sql files), you will be prompted for a username. Specify a username
if you want to grant access to one user at a time, or you can specify PUBLIC
and every user will have access to the base tables.
On Microsoft Windows
====================
The installation process creates a number of program groups which appear
on your desktop. The install and upgrade scripts can be run by double
clicking the icons in the Developer 2000 Administration program group. The actu
al
scripts to install the common base tables for the Developer 2000 tools are in
C:\ORAWIN\Developer 2000\SQL. The product specific script are located in
C:\ORAWIN\PRODUCT\SQL, where PRODUCT refers to product name eg. for forms45
the scripts are in C:\ORAWIN\FORMS45\SQL directory.
The followings are scripts needed to be run to rebuild the base tables.
1. TOOLDROP.SQL TOOLBILD.SQL TOOLGRNT.SQL
2. ROSDROP.SQL ROSBILD.SQL ROSGRNT.SQL
3. VGDROP.SQL VGBILD.SQL VGGRNT.SQL
4. DEDROP.SQL DEBILD.SQL DEGRNT.SQL
Additionaly, you need (only for Oracle Graphics 2.5)
5. GCDROP.SQL GCBILD.SQL GCGRNT.SQL
Check Product Specific Base Tables
==================================
You are not required to install product-specific base tables for all CDE
Tools. Any one of them can be installed independently. Log into SQL*Plus as
SYSTEM and use the following SELECT statements to check the existence of the
base tables first.
Oracle Forms
------------
select object_name, owner, object_type from sys.dba_objects
where object_name like 'FRM45%'
order by object_name;
you should get the following list:
FRM45_BINDVAR PUBLIC SYNONYM
FRM45_BUFFER PUBLIC SYNONYM
FRM45_ENABLED_ROLES PUBLIC SYNONYM
FRM45_GRP PUBLIC SYNONYM
FRM45_OBJECT PUBLIC SYNONYM
FRM45__BINDVAR SYSTEM TABLE
FRM45__BUFFER SYSTEM TABLE
FRM45__GRP SYSTEM TABLE
FRM45__OBJECT SYSTEM TABLE
FRM45_ENABLED_ROLES SYSTEM VIEW
10 rows selected.
Important: Please note that unlike Oracle Forms 4.0 which utilizes 62 base
table objects, Oracle Forms 4.5 utilizes only the above 10 base
table objects. As a result, each of the above base table objects
tend to be very large in size.
Oracle Reports
--------------
select object_name, owner, object_type from sys.dba_objects
where object_name like 'SRW2%'
order by object_type;
you should get the following list:
SRW2_ANCHOR_IDX SYSTEM INDEX
SRW2_BODY_LOCATION_IDX SYSTEM INDEX
SRW2_BOILERPLATE_IDX SYSTEM INDEX
SRW2_COLUMN_IDX SYSTEM INDEX
SRW2_ELEMENT_IDX SYSTEM INDEX
SRW2_FRAME_IDX SYSTEM INDEX
SRW2_LAYOUT_GROUP_IDX SYSTEM INDEX
SRW2_LINK_IDX SYSTEM INDEX
SRW2_MATRIX_IDX SYSTEM INDEX
SRW2_LISTS_IDX SYSTEM INDEX
SRW2_TEXT_SEGMENT_IDX SYSTEM INDEX
SRW2_QUERY_IDX SYSTEM INDEX
SRW2_PARAM_FORM_IDX SYSTEM INDEX
SRW2_OG_DOCUMENT_IDX SYSTEM INDEX
SRW2_OGD_COLUMN_MAP_IDX SYSTEM INDEX
SRW2_LAYOUT_IDX SYSTEM INDEX
SRW2_GROUP_IDX SYSTEM INDEX
SRW2_DISPLAY_TAG_IDX SYSTEM INDEX
SRW2_DATA_MODEL_IDX SYSTEM INDEX
SRW2_BUTTON_IDX SYSTEM INDEX
SRW2_FIELD_IDX SYSTEM INDEX
SRW2_ANCHOR PUBLIC SYNONYM
SRW2_BODY_LOCATION PUBLIC SYNONYM
SRW2_BOILERPLATE PUBLIC SYNONYM
SRW2_BUTTON PUBLIC SYNONYM
SRW2_COLUMN PUBLIC SYNONYM
SRW2_DATA_MODEL PUBLIC SYNONYM
SRW2_DISPLAY_TAG PUBLIC SYNONYM
SRW2_ELEMENT PUBLIC SYNONYM
SRW2_FIELD PUBLIC SYNONYM
SRW2_FRAME PUBLIC SYNONYM
SRW2_GROUP PUBLIC SYNONYM
SRW2_LAYOUT PUBLIC SYNONYM
SRW2_LAYOUT_GROUP PUBLIC SYNONYM
SRW2_LINK PUBLIC SYNONYM
SRW2_LISTS PUBLIC SYNONYM
SRW2_MATRIX PUBLIC SYNONYM
SRW2_MODULE PUBLIC SYNONYM
SRW2_OGD_COLUMN_MAP PUBLIC SYNONYM
SRW2_OG_DOCUMENT PUBLIC SYNONYM
SRW2_PARAM_FORM PUBLIC SYNONYM
SRW2_QUERY PUBLIC SYNONYM
SRW2_TEXT_SEGMENT PUBLIC SYNONYM
SRW2__ANCHOR SYSTEM TABLE
SRW2__DISPLAY_TAG SYSTEM TABLE
SRW2__DATA_MODEL SYSTEM TABLE
SRW2__TEXT_SEGMENT SYSTEM TABLE
SRW2__QUERY SYSTEM TABLE
SRW2__PARAM_FORM SYSTEM TABLE
SRW2__OG_DOCUMENT SYSTEM TABLE
SRW2__OGD_COLUMN_MAP SYSTEM TABLE
SRW2__MATRIX SYSTEM TABLE
SRW2__LISTS SYSTEM TABLE
SRW2__LINK SYSTEM TABLE
SRW2__LAYOUT_GROUP SYSTEM TABLE
SRW2__LAYOUT SYSTEM TABLE
SRW2__GROUP SYSTEM TABLE
SRW2__FRAME SYSTEM TABLE
SRW2__FIELD SYSTEM TABLE
SRW2__ELEMENT SYSTEM TABLE
SRW2__BODY_LOCATION SYSTEM TABLE
SRW2__BOILERPLATE SYSTEM TABLE
SRW2__BUTTON SYSTEM TABLE
SRW2__COLUMN SYSTEM TABLE
SRW2_ANCHOR SYSTEM VIEW
SRW2_FIELD SYSTEM VIEW
SRW2_ELEMENT SYSTEM VIEW
SRW2_OGD_COLUMN_MAP SYSTEM VIEW
SRW2_MODULE SYSTEM VIEW
SRW2_MATRIX SYSTEM VIEW
SRW2_LISTS SYSTEM VIEW
SRW2_LINK SYSTEM VIEW
SRW2_LAYOUT_GROUP SYSTEM VIEW
SRW2_LAYOUT SYSTEM VIEW
SRW2_GROUP SYSTEM VIEW
SRW2_TEXT_SEGMENT SYSTEM VIEW
SRW2_QUERY SYSTEM VIEW
SRW2_PARAM_FORM SYSTEM VIEW
SRW2_OG_DOCUMENT SYSTEM VIEW
SRW2_FRAME SYSTEM VIEW
SRW2_BOILERPLATE SYSTEM VIEW
SRW2_COLUMN SYSTEM VIEW
SRW2_DATA_MODEL SYSTEM VIEW
SRW2_DISPLAY_TAG SYSTEM VIEW
SRW2_BUTTON SYSTEM VIEW
SRW2_BODY_LOCATION SYSTEM VIEW
86 rows selected.
Important: Please note that base table objects for Oracle Reports 2.5 and
Oracle Reports 2.0 are one and the same.
Oracle Graphics
---------------
select object_name, owner, object_type from sys.dba_objects
where object_name like 'GO\_%' escape '\'
order by object_type;
you should get the following list:
GO_COLUMN PUBLIC SYNONYM
GO_DOCUMENT PUBLIC SYNONYM
GO_PARAMETER PUBLIC SYNONYM
GO_QUERY PUBLIC SYNONYM
GO_SOUND PUBLIC SYNONYM
GO_TIMER PUBLIC SYNONYM
GO_VISLAYER PUBLIC SYNONYM
GO__COLUMN SYSTEM TABLE
GO__PARAMETER SYSTEM TABLE
GO__SOUND SYSTEM TABLE
GO__TIMER SYSTEM TABLE
GO__VISLAYER SYSTEM TABLE
GO__QUERY SYSTEM TABLE
GO__DOCUMENT SYSTEM TABLE
GO_COLUMN SYSTEM VIEW
GO_DOCUMENT SYSTEM VIEW
GO_PARAMETER SYSTEM VIEW
GO_QUERY SYSTEM VIEW
GO_SOUND SYSTEM VIEW
GO_TIMER SYSTEM VIEW
GO_VISLAYER SYSTEM VIEW
21 rows selected.
Important: Please note that the base table objects for Oracle Graphics 2.5
and Oracle Graphics 2.0 are one and the same.
Re-install Product Specific Base Tables
=======================================
BEFORE YOU RUN ANY SCRIPTS, MAKE SURE YOU HAVE A BACKUP OF THE DATABASE AND
SOURCE FILES FOR ALL APPLICATIONS (FMB AND MMB FILES FOR ORACLE FORMS; PLL
FILES FOR PL/SQL LIBRARY; RDF AND SQL FILES FOR ORACLE REPORTS; OGD FILES FOR
ORACLE GRAPHICS).
If any object of a CDE Tools application is missing or the string data type
of any table is CHAR instead of VARCHAR2, you need to re-install the base
objects. Again, log into SQL*Plus as SYSTEM and execute the scripts. You
can grant access to individual user or PUBLIC when you run the "grant" scripts.
Oracle Forms 4.5:
-----------------
On Windows: In C:\ORAWIN\FORMS45\SQL\
FRM45DRP.SQL FRM45BLD.SQL FRM45GRT.SQL
Oracle Reports 2.5:
-------------------
On Windows: In C:\ORAWIN\REPORT25\SQL\
SRW2DROP.SQL SRW2BILD.SQL SRW2GRNT.SQL
Oracle Graphics 2.5:
--------------------
On Windows: In C:\ORAWIN\GRAPH25\SQL
GODROP.SQL GOBILD.SQL GOGRNT.SQL
Upgrading from Earlier Versions:
================================
If you are upgrading from an earlier version of Developer 2000 products, you
should run one or more upgrade scripts instead of creating the tables from
scratch. Doing so will update the information in your tables (preserve your
existing information) rather than rebuild the tables.
Note: During installation, program items are created in the Developer 2000
Administration program group for the SQL scripts needed to upgrade the
Developer 2000 tables and the individual product tables. Double-click on
the program items to upgrade the tables.
Oracle Forms:
-------------
From previous versions of 4.0 to 4.5:
Run C:\ORAWIN\FORMS45\DEBILD.SQL
DEGRNT.SQL username
FRM45BLD.SQL
FRM45GRT.SQL username
From previous versions of 4.5:
Run C:\ORAWIN\Developer 2000\SQL\DEALTR.SQL
FRM45UP1.SQL
Oracle Reports:
---------------
Using the following table, run the upgrade SQL scripts that correspond to the
version of Oracle Reports you want to upgrade. The SQL scripts listed are
located in:
C:\ORAWIN\REPORT25\SQL
Version to Version Script
---------------------------------------------------------------
2.0.13.0 to 2.0.14.0 SRW20140.SQL
2.0.14.0 to 2.5 SRW2500.SQL
2.5 to 2.5.3.1.16 SRW2530.SQL
Oracle Graphics:
----------------
To upgrade Oracle Graphics tables, you must run the following scripts:
C:\ORAWIN\Developer 2000\GC25UP.SQL
C:\ORAWIN\GRAPH25\SQL\GO25UP.SQL