Recreating and Resizing Indexes in a Specified Base Database

The recreateIndexes.sql script enables you to recreate and resize the indexes in a specified base database. By default all the indexes in a base database are recreated, but optional parameters allow you to recreate all the indexes on a specified table or just a single specified index. By default the recreated indexes are placed in the PCMS_IDX tablespace, but this can be overridden by an optional parameter.

The recreateIndexes.sql script is run under the dmdba utility, and is invoked by the command:

recreateIndexes <basedb> [<tablespaceName>]

or

recreateIndexes <basedb> [<tablespaceName>] [/t[able]=<tableName>]

or

recreateIndexes <basedb> [<tablespaceName>] [/i[ndex]=<indexName>]

where <basedb> is the schema whose index(es) are to be recreated and <tablespaceName> is the tablespace in which the indexes will be created.

The recreateIndexes.sql script will rebuild and resize:

- all the indexes in the specified schema, or

- if the /table qualifier is given, all the indexes on the table specified by <tableName>, or

- if the /index qualifier is given, the single index <indexName>.

NOTE When the /table or /index qualifier is used, ensure that there are no spaces before or after the equals sign (=).

MIGRATE– Migrate an MBCS Encoded Database to UTF-8

NOTE Only available, and displayed, when connected to a Serena-Supplied Runtime RDBMS or an Oracle Enterprise database.

This command enables you to migrate a Serena-Supplied Runtime RDBMS or Oracle Enterprise MBCS encoded database to UTF-8. For details on migrating MBCS data to UTF-8 data, see the Administration Guide.

ITEMLIBMODE - Item Library Access Policy

Enforces an item library access policy base across a base database.

ITEMLIBMODE default|secure

where:

- default

  14.3.3 and earlier: item libraries are not required to have an associated credential set.

- secure

  14.3.3 and later: must be explicitly activated. Requires item libraries to have an associated credential set to access files.

See also information about the item library security in the Administration Guide.

This command enables you to migrate a Serena-Supplied Runtime RDBMS or Oracle Enterprise MBCS encoded database to UTF-8. For details on migrating MBCS data to UTF-8 data, see the Administration Guide.