PACKAGE: SYS.DBMS_INMEMORY

Source

1 package dbms_inmemory as
2 --create or replace package dbms_inmemory authid current_user as
3 
4   ----------------------------
5   --  PROCEDURES AND FUNCTIONS
6   --
7 
8   -------------------------------------------------------------------------
9   -- PROCEDURE repopulate
10   -------------------------------------------------------------------------
11   -- Description :
12   --   Repopulate the in-memory representation of the specified
13   --   table/partition if an in-memory representation exists.
14   --
15   -- Input parameters:
16   --   schema_Name    - User owning the object
17   --   table_name     - Name of the table whose in-memory representation
18   --                    is to be repopulated.
19   --   partition_name - If partition name is not null,
20   --                    then repopulate the specified partition
21   --   force          - Repopulate required with force(TRUE/FALSE).
22 
23   procedure repopulate(
24         schema_name      in varchar2,
25         table_name       in varchar2,
26         partition_name   in varchar2 DEFAULT NULL,
27         force            in boolean  DEFAULT FALSE);
28 
29   -------------------------------------------------------------------------
30   -- PROCEDURE populate
31   -------------------------------------------------------------------------
32   -- Description :
33   --   Populate the in-memory representation of the specified
34   --   table/partition if an in-memory representation exists.
35   --
36   -- Input parameters:
37   --   schema_Name    - User owning the object
38   --   table_name     - Name of the table whose in-memory representation
39   --                    is to be populated.
40   --   partition_name - If partition name is not null,
41   --                    then repopulate the specified partition
42 
43   procedure populate(
44         schema_name      in varchar2,
45         table_name       in varchar2,
46         partition_name   in varchar2 DEFAULT NULL);
47 
48   -------------------------------------------------------------------------
49   -- PROCEDURE enablefaststart
50   -------------------------------------------------------------------------
51   -- Description :
52   --   Enables the faststart mechanism for the specified tablespace.
53   --
54   -- Input parameters:
55   --   tbs_name       - tablespace name
56 
57   procedure enablefaststart(tbs_name in varchar2);
58 
59   -------------------------------------------------------------------------
60   -- PROCEDURE disablefaststart
61   -------------------------------------------------------------------------
62   -- Description :
63   --   Disables the faststart mechanism
64   --
65   -- Input parameters:
66   --   none
67 
68   procedure disablefaststart;
69 
70 end;