Specifications

9032277-04 Software Superseded by CS3/MMS3

5-53

Patches Issued Since the CS2/MMS2 Release

for table STAT_ROUT Oracle sends out a message that the index does

not exist, and an "insufﬁcient privileges" message when it tries to

create the index. These messages obviously occur because the actual

table that is being loaded is STAT_ROUT_new.

Also, when SPECTRUM models are exported daily the SDEOraImport

script automatically assumes that an overwrite is in order. The actual

table name is SPECTRUM.MODELS. The MODELS table is needed

by both historical and current reports. So, a private synonym was

created in the SPECTR schema called MODELS, which points to the

SPECTRUM.MODELS table. However, since the SDEOraImport

script attempts to drop the table (overwrite) and recreate it as user

SPECTR, it gets the "insufﬁcient privileges" error message. In the

past this problem was avoided because the table was dropped as user

SPECTRUM and a user has the ability to drop and create tables

within its schema, but not across schemas.

The resolution was that the generation of the list of tables was

changed to include tables, views and synonyms. The structure of each

line in the list is now t=b, where t is a table name (b = t), a view name

(b = base table of view), or a synonym deﬁned for the current user (b =

actual table name in form schema.name).

The function exists() now performs a match on t (in lines of the form

t=b), and sets the value of the variable base_table equal to b. All table/

index creations and drops now use base_table rather than the table

name obtained from the sprm ﬁle.

For all tables except those of type "Statistic", the drop/re-create

process for existing tables has been replaced by a SQL truncate

command. This is more efﬁcient than the drop/create process, and

allows resetting of a table across schemas, if DELETE permissions are

properly granted. Statistic tables are still dropped and created, since

their structures can change from export to export.

SPECTRUM_5.0rev1.P88

Never released to customers. Never existed.

SPECTRUM_5.0rev1.P89

Included in SPECTRUM_5.0rev1.P101