81 DBMS_INMEMORY

The DBMS_INMEMORY package provides an interface for in-memory column store functionality.

This chapter contains the following topics:

Summary of DBMS_INMEMORY Subprograms

Table 81-1 DBMS_INMEMORY Package Subprograms

Subprogram Description

POPULATE Procedure on

Forces population of a given table

REPOPULATE Procedure on

Forces repopulation of a given table

POPULATE Procedure

This procedure forces population of a given table.

Syntax

DBMS_INMEMORY.POPULATE (
   schema_name      IN    VARCHAR2,
   table_name       IN    VARCHAR2,
   subobject_name   IN    VARCHAR2 DEFAULT NULL);

Parameters

Table 81-2 POPULATE Procedure Parameters

Parameter Description

schema_name

Name of schema

table_name

Name of table

subobject_name

Partition or subpartition may be specified

REPOPULATE Procedure

This procedure forces repopulation of a given table.

Syntax

DBMS_INMEMORY.REPOPULATE (
   schema_name      IN    VARCHAR2,
   table_name       IN    VARCHAR2,
   subobject_name   IN    VARCHAR2 DEFAULT NULL,
   force            IN    BOOLEAN DEFAULT FALSE);

Parameters

Table 81-3 REPOPULATE Procedure Parameters

Parameter Description

schema_name

Name of schema

table_name

Name of table

subobject_name

Partition or subpartition may be specified

force

If TRUE, then repopulates the entire table.