UNLOCK_CATALOG_PARTITION_STAT is used to unlock partition statistics in the catalog.
Note
This subprogram is available starting with V5.0.1.
Syntax
DBMS_STATS.UNLOCK_CATALOG_PARTITION_STAT (
catname VARCHAR(65535),
dbname VARCHAR(65535),
tabname VARCHAR(65535),
partname VARCHAR(65535)
);
Parameters
Parameter |
Explanation |
|---|---|
| catname | Specifies the catalog name. |
| dbname | Specify the database name. |
| tabname | Specifies the table name. |
| partname | Specifies the partition name.NULLRepresents the entire table. |
Examples
Unlock the statistics for partition l_shipdate=1998-01-01 of table lineitem under Catalog name hive_catalog and Database name test_oss.
obclient> CALL DBMS_STATS.UNLOCK_CATALOG_PARTITION_STAT (
'hive_catalog',
'test_oss',
'lineitem',
'l_shipdate=1998-01-01'
);