Drop Partition

Delete from the system a partition definition between two databases. Database designer privilege for each database is required.

Syntax

If the create partition statement used was of the format:

create partition SOURCE to TARGET;

Then the only permutations of the drop partition statement that will have effect are:

drop partition SOURCE to TARGET;
drop partition TARGET from SOURCE;

Examples

create or replace replicated partition sampeast.east area '@IDESCENDANTS("Eastern Region"), @IDESCENDANTS(Qtr1)' to samppart.company at localhost;

drop replicated partition Samppart.Company from Sampeast.East;

Descriptions

You can delete partition definitions in the following ways using drop partition.

Key Phrase Explanation
drop...partition...from Remove a transparent, replicated, or linked partition definition between the current target database and a source database.
drop...partition...to Remove a transparent, replicated, or linked partition definition between the current source database and a target database.
at <host-name> Optionally specify the host computer name, if removing a partition definition associated with a remote server. The host name can be an IP address; for example, '127.0.0.1'.
force Specify that the source half of a partition definition should be dropped regardless of whether the target half is missing or invalid. For more information, see Forcing Deletion of Partitions.

©2004 Hyperion Solutions Corporation. All Rights Reserved.
http://www.hyperion.com