ttOptStatsExport

This procedure returns the set of statements required to restore the table statistics to the current state. If no table is specified, it returns the set of statements required to restore the table statistics for all user tables that the calling user has permission to access.

Required Privilege

This procedure requires ADMIN privilege.

Related Views

This procedure has this related view.

SYS.V$OPT_STATS

Syntax

ttOptStatsExport('tblName')

Parameters

ttOptStatsExport has the parameter:

Parameter Type Description

Parameter	Type	Description
`tblName`	`TT_CHAR (61)`	Name of the table whose statistics are to be returned. If `NULL` is passed, then values for all tables are returned. Using a synonym to specify a table name is not supported.

tblName

TT_CHAR (61)

Name of the table whose statistics are to be returned. If NULL is passed, then values for all tables are returned.

Using a synonym to specify a table name is not supported.

Result Set

ttOptStatsExport returns the result set:

Column	Type	Description
`stmt`	`TT_VARCHAR (8300) NOT NULL`	The set of statements required to restore the table(s) statistics to the current state.

Examples

CALL ttOptStatsExport('MyTable');