DROP INMEMORY JOIN GROUP

Purpose

Use the DROP INMEMORY JOIN GROUP statement to remove a join group from the database.

See Also:

• CREATE INMEMORY JOIN GROUP and ALTER INMEMORY JOIN GROUP

• Oracle Database In-Memory Guide for more information on join groups

Prerequisites

If the join group is in another user’s schema, then you must have the DROP ANY TABLE system privilege.

Syntax

drop_inmemory_join_group::=

Description of the illustration drop_inmemory_join_group.gif

Semantics

IF EXISTS

Specify IF EXISTS to drop an existing object.

Specifying IF NOT EXISTS with DROP results in ORA-11544: Incorrect IF EXISTS clause for ALTER/DROP statement.

schema

Specify the schema containing the join group. If you omit schema, then the database assumes the join group is in your own schema.

join_group

Specify the name of the join group to be dropped.

You can view existing join groups by querying the DBA_JOINGROUPS or USER_JOINGROUPS data dictionary view. Refer to Oracle Database Reference for more information on these views.

Examples

The following statement drops the join group prod_id1:

DROP INMEMORY JOIN GROUP prod_id1;