Enables you to drop
a data service. Following is the syntax:
DROP [DATA] SERVICE data-service [drop-disposition]
data-service
Specifies the data
service name.
drop-disposition
Specifies the drop
disposition as one of the following values:
{RESTRICT | CASCADE} [FORCE]
| RESTRICT |
Specifies that the drop target is empty. This is
the default value.
|
| CASCADE |
Specifies that contained objects are dropped. |
| FORCE |
Specifies the optional FORCE keyword that will suppress
error messages when the data service does not exist. This additional
option does not affect the performance of the RESTRICT or CASCADE
options.
|
drop DATA SERVICE ORACLE3
drop service "MYSQL_SERVICE" cascade force
drop data service ORACLE1 cascade