9.7.2 CREATE

Purpose

The CREATE command creates a new object and assigns initial attributes to the object.

Syntax

CREATE object_type [name] [attributename=attribute_value [, attributename=attribute_value]...]

Usage Notes

• object_type can be as follows:

  • DBSERVER

  • DIAGPACK

  • ROLE

  • THRESHOLD

  • USER

• name is the name of the new object.

• attribute_value is the name of a modifiable attribute for the object_type.

• attribute_value is the initial setting for the attribute.

• When multiple objects are valid as the target of a CREATE command, there is the possibility of partial success. If an error occurs, then the command is interrupted, and the remaining objects are not created.

• CREATE DBSERVER
  
• CREATE DIAGPACK
  
• CREATE ROLE
  
• CREATE THRESHOLD
  
• CREATE USER