Modifying a schema comprises several tasks for ensuring your changes
are validated, saved, and applied to user databases.
About this task
To
modify a schema and put the modifications into effect or to create a new schema:
Procedure
- Start the Designer.
- Create a test database and associate it with the
schema that you want to customize.
- Check out the schema that you want to customize,
or create a new schema.
- Select the scripting language to use the for hook
code.
- Modify the schema, either by using the Designer to
change elements of the schema, or by applying packages.
- Validate the customized schema using the Validate
schema command in the Designer.
- Set the test database for the schema (that is, designate
that the test database that you created earlier be used to test the schema
that you checked out).
- Use the test database to test the customized schema.
- Save work in progress.
- Check in the customized schema.
- Upgrade the user database with the modified schema.