The IMPORT_TABLE_STATS procedure is used to import table-level statistics.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition does not support this feature.
Syntax
DBMS_STATS.IMPORT_TABLE_STATS (
ownname VARCHAR2,
tabname VARCHAR2,
partname VARCHAR2 DEFAULT NULL,
stattab VARCHAR2,
cascade BOOLEAN DEFAULT TRUE,
statown VARCHAR2 DEFAULT NULL,
no_invalidate BOOLEAN DEFAULT FALSE,
force BOOLEAN DEFAULT FALSE
);
Parameters
| Parameter | Description |
|---|---|
| ownname | The username. If the username is set to NULL, the current logged-in username is used by default. |
| tabname | The table name. |
| partname | The name of the table partition. If the table is partitioned and partname is NULL, global and partition column statistics are imported. |
| stattab | The name of the user statistics table to be imported. |
| cascade | If TRUE, column and index statistics for this table are also imported. |
| statown | The username of the user statistics table to be imported. |
| no_invalidate | Specifies whether to clear the Plan Cache when collecting statistics. If set to TRUE, the Plan Cache is not cleared when collecting statistics. |
| force | Specifies whether to forcibly import statistics and ignore lock status. Default value is FALSE. If set to TRUE, statistics are imported even if they are locked. |
Exceptions
| Error code | Description |
|---|---|
| OBE-20000 | The object does not exist or the user does not have sufficient privileges. |
| OBE-20001 | The values in the user statistics table are invalid or inconsistent. |
Considerations
You must be the owner of the table to call this procedure. For objects owned by
SYS, you must be the owner or have theSYSDBAprivilege to call this procedure.Statistics cannot be exported or imported between databases with different character sets.
Examples
Import statistics from the tbl1 table of user testUser01 into the test_stat table of user testUser02.
obclient> CALL DBMS_STATS.CREATE_STAT_TABLE('testUser02', 'test_stat');
Query OK, 0 rows affected
obclient> CALL DBMS_STATS.IMPORT_TABLE_STATS('testUser01', 'tbl1', stattab=>'test_stat', statown=>'testUser02');
Query OK, 0 rows affected