3.3 Supported Types

DDL types use create or replace syntax. A snapshot of the object is taken before applying the change so automatic rollback to the last known state is supported.

SXML types support automatic alter generation with automatic rollback support.

DDL types have their own change type.

• CONSTRAINT
• DIMENSION
• DIRECTORY
• FUNCTION
• JOB
• OBJECT_GRANT
• PACKAGE_BODY
• PACKAGE_SPEC
• PROCEDURE
• PUBLIC_SYNONYM
• REF_CONSTRAINT
• SYNONYM
• TRIGGER
• TYPE BODY
• TYPE SPEC

SXML types share the SXML change type.

• AQ_QUEUE
• AQ_QUEUE_TABLE
• AQ_TRANSFORM
• ASSOCIATION
• AUDIT
• AUDIT_OBJ
• CLUSTER
• CONTEXT
• DB_LINK
• DEFAULT_ROLE
• FGA_POLICY
• JOB
• LIBRARY
• MATERIALIZED_VIEW
• MATERIALIZED_VIEW_LOG
• OPERATOR
• PROFILE
• PROXY
• REFRESH_GROUP
• RESOURCE_COST
• RLS_CONTEXT
• RLS_GROUP
• RMGR_CONSUMER_GROUP
• RMGR_INTITIAL_CONSUMER_GROUP
• RMGR_PLAN
• RMGR_PLAN_DIRECTIVE
• ROLE
• ROLLBACK_SEGMENT
• SEQUENCE
• TABLE
• TABLESPACE
• TRIGGER XS_ACL
• TRUSTED_DB_LINK
• USER
• VIEW
• XMLSCHEMA
• XS_ACL_PARAM INDEX
• XS_DATA_SECURITY
• XS_ROLE
• XS_ROLESET
• XS_ROLE_GRANT
• XS_SECURITY_CLASS
• XS_USER