DROP OPENFLOW CONNECTOR¶

See also:

CREATE OPENFLOW CONNECTOR, ALTER OPENFLOW CONNECTOR, SHOW OPENFLOW CONNECTOR DEFINITIONS, SHOW OPENFLOW CONNECTORS, DESCRIBE OPENFLOW CONNECTOR, SHOW VERSIONS IN OPENFLOW CONNECTOR

Syntax¶

DROP OPENFLOW CONNECTOR [ IF EXISTS ] <name>

Parameters¶

IF EXISTS

Drops the connector only if it exists. If the connector does not exist, the statement does nothing and returns a success message.

Requires OWNERSHIP. The connector must be terminated first (ALTER ... TERMINATE). Stop the connector before terminating. TERMINATE drains in-flight data.

Typical deletion sequence:

ALTER OPENFLOW CONNECTOR my_db.my_schema.my_connector STOP;
SELECT SYSTEM$WAIT_FOR_STABLE_OPENFLOW_CONNECTORS(600, 'my_db.my_schema.my_connector');

ALTER OPENFLOW CONNECTOR my_db.my_schema.my_connector TERMINATE;
SELECT SYSTEM$WAIT_FOR_STABLE_OPENFLOW_CONNECTORS(600, 'my_db.my_schema.my_connector');

DROP OPENFLOW CONNECTOR my_db.my_schema.my_connector;