Index

A B C D E F G H I J K L M O P Q R S T U V W

A

ANALYZE command, 3-15

Analyze Wizard, 3-15

attribute changes not undone by a recovery script, 3-25

attributes

modifying for a directive, 3-8

modifying for an exemplar, 3-17

viewing for a directive, 3-8

viewing for an exemplar, 3-12

B

baseline

capturing definitions using Create Baseline, 1-9

capturing definitions using the command line interface, A-7

creating, 2-7

creating a new version, 2-8

creating using the command line interface, A-7

definition, 1-6

deleting, 2-7

deleting a previous version of, 2-8

exporting, 2-8, 2-14

importing, 2-8, 2-14

viewing, 1-10, 2-7

viewing a previous version of, 2-8

viewing history entries for, 2-8

working with a particular version of, 2-13

Baseline Viewer

function of, 1-10

C

capture command

enabling logging for, A-7

change management applications

starting from Change Manager, 2-6

change management objects, 1-5

copying from one repository to another, 2-14

Change Manager application

right mouse button support for, 2-6

running from the command line, 2-3

starting, 2-3

starting other applications from, 2-6

change plan

creating, 2-10, 3-3

creating a new version, 2-10

defining change requests for, 3-4, 3-6

definition, 1-5

deleting, 2-10

deleting a previous version, 2-10

editing and modifying, 2-10

excluding grants from, 3-12

exporting, 2-10, 2-14

generating a script from, 3-19

generating a script using the command line interface, A-9

importing, 2-10, 2-14

including grants in, 3-12

naming, 3-4

renaming, 2-10

selecting a destination database for, 3-17

selecting the source database for, 3-4

viewing a previous version, 2-10

viewing and modifying the propagation options for, 3-15

viewing history entries for, 2-11

working with a particular version of, 2-13

change request

defining a directive, 3-7

defining a modified exemplar, 3-17

defining a scoped directive, 3-9

defining an exemplar, 3-11

types, 3-4

changes

for which undo operations are not present in the recovery script, 3-25

making, 1-8

tracking, 1-7

ClientConfig.properties file

description of properties, B-2

location of, B-2

using to enable tracing and debugging for applications, B-2

CM_SELECT_ROLE role, 2-16

command line

running Change Manager from, 2-3

command line interface

capture command, A-7

enabling logging for, A-7

compare command, A-8

enabling logging for, A-8

creating a baseline using, A-7

creating a comparison using, A-8

de-establishing administrator credentials for, A-7

entering commands in a .BAT file, A-4

establishing administrator credentials for, A-5

execute command, A-10

enabling logging for, A-11

examples of, A-13

executing a script using, A-10

exit status codes returned by, A-14

generate command, A-9

enabling logging for, A-10

generating a script using, A-9

logout command, A-7

overview of commands, A-4

requirements for using, A-2

scheduling the execution of scripts, A-4

specifying completion actions for a script execution, A-12

specifying the direction in which to execute a script, A-11

understanding the notation for command syntax, A-2

uses for, A-1

using on UNIX, A-1

using on Windows NT, A-1

compare command

enabling logging for, A-8

Compare Database Objects application

function of, 1-7

overview of, 1-11

comparison

creating, 1-11, 2-8

creating a new version of, 2-9

creating using the command line interface, A-8

definition, 1-6

deleting, 2-9

deleting a previous version of, 2-9

exporting, 2-9, 2-14

importing, 2-9, 2-14

naming, 1-11

saving, 1-11

viewing, 1-11, 2-9

viewing a previous version of, 2-9

viewing history entries for, 2-9

working with a particular version of, 2-13

Comparison Viewer

function of, 1-11

completed task

refreshing the display, 2-13

viewing, 2-13

completing

pending task, 2-12

conceptual help topics

accessing, 1-28

definition, 1-28

Contents page for help

accessing, 1-27

context-sensitive help

accessing, 1-27

copying

a subset of the data for a table definition, 3-13

all the data for a table definition, 3-13

change management objects to a different repository, 2-14

data definitions only for a table, 3-13

object definitions to a destination database, 1-12, 1-15

optimizer statistics from one database to another, 3-15

table definitions and data to a destination database, 1-17, 3-13

table definitions and data using drag and drop, 1-17

Create Baseline application

capturing definitions in a baseline, 1-9

capturing definitions in SQL DDL format, 1-9

function of, 1-7

overview of, 1-9

creating

a new version of a baseline, 2-8

a new version of a change plan, 2-10

a new version of a comparison, 2-9

baseline, 2-7

change plan, 2-10

comparison, 2-8

directive, 3-7

exemplar, 3-11

modified exemplar, 3-17

scoped directive, 3-9

standalone repository, 2-2

D

database link

using for copy operations between databases, 3-15

DB Alter application

function of, 1-8

overview of, 1-14

DB Propagate application

function of, 1-8

overview of, 1-15

DB Quick Change application

function of, 1-8

overview of, 1-13

DBA role, 2-15, 2-16

defining

See creating

delete directive, 1-1

defining, 3-7

deleting

a previous version of a baseline, 2-8

a previous version of a change plan, 2-10

a previous version of a comparison, 2-9

a task from the History page, 2-13

baseline, 2-7

change plan, 2-10

comparison, 2-9

object definitions, 3-7

dependency object definition

adding to a plan, 3-13

definition, 3-13

viewing for an exemplar, 3-12

dependent object definition

adding to a plan, 3-13

definition, 3-13

viewing for an exemplar, 3-12

destination database

executing a script at, 3-24

generating a script for, 3-19

keeping script changes made at, 3-24

selecting, 3-17

undoing script changes made at, 3-24

directive

applications used to create, 3-6

defining, 3-7

definition, 3-4

extending the scope of, 3-5

viewing the changes specified by, 3-8

drag and drop copying of object definitions, 1-17

E

errors

generated during change management operations, 2-16

generated during script execution, 2-17, 3-24

generated during script generation, 2-17, 3-21

execute command

enabling logging for, A-11

executing

a script, 1-25, 3-24

required privileges, 3-24

a script using the command line interface, A-10

exemplar

actions performed at a destination database, 3-11

applications used to create, 3-6

defining, 3-11

definition, 3-5

modifying, 3-17

viewing attributes for, 3-12

viewing dependency object definitions for, 3-12

viewing dependent object definitions for, 3-12

viewing grants for, 3-12

exit status codes

returned by command line interface, A-14

exporting

baseline, 2-8, 2-14

change plan, 2-10, 2-14

comparison, 2-9, 2-14

F

failure prediction during script generation, 3-26

G

generate command

enabling logging for, A-10

generating

a script, 1-24, 3-19

a script using the command line interface, A-9

glossary

accessing, 1-28

grants

excluding from an exemplar, 3-12

including for an exemplar, 3-12

viewing for an exemplar, 3-12

H

hard dependency, 3-7

help

accessing the glossary, 1-28

displaying the Contents page, 1-27

finding a particular type of topic, 1-28

finding a specific topic, 1-27

locating a conceptual or task topic, 1-28

obtaining for a particular context, 1-27

using, 1-27

history entries

saving to a file, 2-12, 2-13

sorting on the History page, 2-13

sorting on the Pending page, 2-12

viewing for a change plan, 2-11

viewing for a comparison, 2-9

viewing for a task, 2-11

History page

manually moving a pending task to, 2-12

removing a task, 2-13

viewing new history entries for, 2-13

I

impact

determining for a script prior to its execution, 3-21

importing

baseline, 2-8, 2-14

change plan, 2-10, 2-14

comparison, 2-9, 2-14

J

job system

using to execute a script, 3-25

K

keeping script changes, 3-24

L

log (trace) files

location of, B-2

logging

enabling during baseline creation with the capture command, A-7

enabling during comparison creation with the compare command, A-8

enabling during script execution with the execute command, A-11

enabling during script generation with the generate command, A-10

M

mapping schemas, 3-19

modified exemplar

applications used to create, 3-6

creating with Plan Editor, 3-17

modifying

change plan, 2-10

object definitions using Plan Editor, 3-2

O

object definitions

basic steps for changing, 1-23

capturing using Create Baseline, 1-9

capturing using the command line interface, A-7

changes that cannot be undone using the recovery script, 3-25

comparing using the command line interface, A-8

copying table definitions and data, 3-13

copying using drag and drop, 1-17

deleting, 3-7

keeping changes made to, 3-24

making changes to definitions in one or more databases, 1-14

making one or more changes to one definition, 1-13

modifying using Plan Editor, 3-2

reproducing, 3-11

reproducing one or more object definitions in one or more databases, 1-15

specifying changes for, 3-7

supported by change management applications, 1-4

synchronizing one set with another, 1-12

undoing changes made to, 3-24

viewing the changes specified for, 3-8

objects

created by change management applications, 1-5

obsolete script, 3-18

OCM_FAILURE_PREDICTION property

enabling to predict script execution failures, 3-26

ocmselectrole.sql script

using to create CM_SELECT_ROLE role, 2-16

omsconfig.properties file

description of properties, 3-27

location of, 3-26

used to enable script execution failure prediction, 3-26

optimizer statistics

copying from one database to another, 3-15

Oracle Support Services, xv

P

pending task

completing, 2-12

manually moving to the History page, 2-12

refreshing the display, 2-12

saving history entries to a file, 2-12

viewing, 2-12

physical attributes

specifying a set to use at the destination database, 3-16

plan

See change plan

Plan Editor application

modifying and creating object definitions using, 3-2

overview of, 1-18

right mouse button support for, 3-3

predicting script execution failures, 3-26

privileges

for change management operations in a 9.x database, 2-15

for change management operations in an 8.x database, 2-15

propagation options

viewing and modifying, 3-15

Q

Quick Tour

starting, 1-19

R

recovery script

attribute changes not undone by, 3-25

refreshing

list of completed tasks, 2-13

list of pending tasks, 2-12

removing

See deleting

renaming

change plan, 2-10

report

about the dependency and dependent objects for an exemplar, 3-13

about the impact of executing a script, 3-20

about the objects in a baseline, 1-10

about the results of a comparison, 1-11

generating for completed task history entries, 2-13

generating for pending task history entries, 2-12

repository

copying change management objects to another, 2-14

storing change management objects in, 2-1

S

scheduling

execution of command line interface scripts, A-4

schema mapping, 3-19

scoped directive

applications used to create, 3-6

creating, 3-9

definition, 3-5, 3-8

scratch tablespace

specifying for script operations that require temporary data storage, 3-19

script

dealing with problems in, 3-23

determing impact of prior to execution, 3-21

editing, 3-22

enabling failure prediction during generation, 3-26

executing, 3-24

privileges required, 3-24

executing using the command line interface, A-10

executing using the job system, 3-25

executing using the Oracle Enterprise Manager job system, 3-25

generating for a destination database, 3-19

generating for a destination database using the command line interface, A-9

keeping changes made by, 3-24

obsolete, 3-18

resolving problems that occur during execution, 3-27

scheduling using the command line interface, A-4

stale, 3-26

undoing changes made by, 3-24

viewing a summary of, 3-22

viewing the results after executing, 3-24

script generator

definition, 3-26

sorting

history entries for completed tasks or manually moved pending tasks, 2-13

history entries for pending tasks, 2-12

source database

choosing when creating change requests in Plan Editor, 3-4

definition, 3-4

SQL statements

capturing definitions using Create Baseline, 1-9

stale script, 3-26

standalone repository

creating, 2-2

prequisites for creating, 2-2

storing change management objects in, 2-2

using a different, 2-2

starting

change management applications from Change Manager, 2-6

Change Manager, 2-3

Synchronization Wizard, 1-13

the Quick Tour, 1-19

status codes

returned by command line interface, A-14

support for Oracle Change Management Pack

obtaining, xv

supported database objects, 1-4

Synchronization Wizard application

function of, 1-8

overview of, 1-12

starting, 1-13

synchronizing

one set of object definitions with another, 1-12

T

task

completing pending, 2-12

manually moving a pending task to the History page, 2-12

removing from the History page, 2-13

viewing completed, 2-13

viewing history entries for, 2-11

viewing new completed tasks, 2-13

viewing pending, 2-12

task help topics

accessing, 1-28

definition, 1-28

trace files

location of, B-2

tracking changes, 1-7

troubleshooting

script execution errors, 3-26

script execution failures, 3-26

script generation errors, 3-21

using the ClientConfig.properties file, B-2

U

undoing script changes, 3-24

UNIX

starting Change Manager, 2-3

starting Change Manager from the command line, 2-3

using command line interface on, A-1

updating

list of completed tasks, 2-13

list of pending tasks, 2-12

V

version

baseline, 2-13

change plan, 2-13

comparison, 2-13

viewing

a previous version of a baseline, 2-8

a previous version of a change plan, 2-10

a previous version of a comparison, 2-9

baseline, 2-7

change plan, 2-10

comparison, 2-9

completed task, 2-13

history entries for a baseline, 2-8

history entries for a change plan, 2-11

history entries for a comparison, 2-9

pending task, 2-12

W

Windows NT

starting Change Manager, 2-3, 2-4

starting Change Manager from DOS command line, 2-3

using command line interface on, A-1