Corporation Network Router User Manual

Introduction to the User Migration Utility
Using the User Migration Utility G-5
Table G–1 ORCL_GLOBAL_USR_MIGRATION_DATA Table Schema
Column Name DataType Null Description
USERNAME (Primary Key) VARCHAR2(30) NOT NULL Database user name.
OLD_SCHEMA_TYPE VARCHAR2(10) - Old schema type in the database before
migration.
PASSWORD_VERIFIER VARCHAR2(30) - Not used
USERDN VARCHAR2(4000) - Distinguished Name (DN) of the user in
the directory (new or existing).
USERDN_EXIST_FLAG CHAR(1) - Flag indicating whether the DN already
exists in the directory.
SHARED_SCHEMA VARCHAR2(30) - Shared schema name, if users are to be
mapped to a shared schema during phase
two.
MAPPING_TYPE VARCHAR2(10) - Mapping type (database or domain).
MAPPING_LEVEL VARCHAR2(10) - Mapping level (entry or subtree).
CASCADE_FLAG CHAR(1) - Cascade flag used when dropping a user
(for shared schema mapping only).
DBPASSWORD_EXIST_FLAG CHAR(1) - Flag indicating whether the database
password verifier already exists in the
directory for this user.
DBPASSWORD VARCHAR2(30) - Randomly generated database password
verifiers that are to be stored in the
directory.
DIRPASSWORD VARCHAR2(30) - Randomly generated directory password
for new entries.
PHASE_COMPLETED VARCHAR2(10) - Information about the phase that has
completed successfully.
NEEDS_ATTENTION_FLAG CHAR(1) - Flag indicating whether the row contains
abnormalities that require administrator
attention.
ATTENTION_DESCRIPTION VARCHAR2(100) - Textual hint for the administrator if the
attention flag is set.