Page History
...
| Anchor | ||||
|---|---|---|---|---|
|
Decorator Options affect particular database objects.
These options include:
- Preserve Target File Group (on extended alter) (SQL Server only) When an extended alter is generated for an object, the target objects file group remains the same as the original object if this option is enabled.
If this option is disabled, the targets objects file group are set to the one used by the source object. - Preserve Target Storage (Oracle only) The functionality is similar to Preserve Target File Group but this option applies to the storage properties of Oracle objects.
- Preserve Target Tablespace (Oracle only) The functionality is similar to Preserve Target File Group but this option applies to the tablespace properties of Oracle objects.
- Preserve Target Segment (Sybase only) Preserves the Segment property for tables, indexes, and partition definitions.
- Recompile This option triggers a recompilation for dependent procedures, when the target object needs to be dropped and recreated (extended altered).
- Comment Out Extended Alters for Tablespaces An extended alter is essentially a drop and then a recreate. For tablespaces, an extended alter is a dangerous operation that may cause data loss.
This option is by default enabled and generates commented out DDL for tablespace extended alter.
| Anchor | ||||
|---|---|---|---|---|
|
...