Oracle® Database SQL Language Reference 11g Release 2 (11.2) Part Number E17118-04 |
|
|
PDF · Mobi · ePub |
Use the DROP
EDITION
statement to drop an edition, along with all actual editionable objects it contains. An actual editionable object is an editionable object that has been created or modified in an edition.
See Also:
CREATE EDITION for a listing of editionable object typesYou must have the DROP
ANY
EDITION
system privilege, granted either directly or through a role. In addition, you must have appropriate privileges to drop any actual editionable objects in the edition.
When successful, this statement drops the specified edition, including versions of any objects associated with that edition. Versions of the same objects in other editions are not dropped. Objects that are not editionable, or that are editionable but have not been actualized in the current edition, are not dropped.
You must specify CASCADE
if the specified edition contains any actual editionable objects.
This statement is subject to the following conditions and restrictions:
The specified edition cannot have both a parent edition and a child edition.
The specified edition cannot contain any actual editionable objects that are inherited by a child edition, even if you specify CASCADE
.
DROP
EDITION
will fail if you attempt to drop the default edition.
For examples that use this statement, refer to CREATE EDITION.