Neoview SQL Reference Manual (R2.5)

3 SQL Utilities
A utility is a tool that runs within Neoview SQL and performs such tasks as maintenance, loading
indexes, purging data from tables, indexes, materialized views and reorganizing and reloading
data in a table or index.
This section describes the Neoview SQL utilities:
Performs one or more maintenance tasks, such as REORG,
UPDATE STATISTICS, and REFRESH, on a specified
database object.
“MAINTAIN Command” (page 212)
Loads indexes.“POPULATE INDEX Utility” (page 220)
Purges data from tables and indexes.“PURGEDATA Utility” (page 222)
Allows an installation to replicate a table or an entire
schema from one Neoview system to another.
“REPLICATE Command” (page 224)
Privileges Required to Execute Utilities
Privileges RequiredUtility
MAINTAIN
To refresh, you must be the schema owner, object owner, or have the
SELECT, INSERT, and DELETE privileges on the materialized view.
REFRESH
To reorganize, you must be the object owner or have all table privileges
(SELECT/INSERT/DELETE/UPDATE).
REORG
To update statistics, you must be the object owner, the schema owner,
or have SELECT privilege on the table.
UPDATE STATISTICS
You must be the object owner, schema owner, have the ALTER
privilege, or have the SELECT, DELETE, and INSERT privileges on
the table or materialized view.
POPULATE INDEX
You must be the object owner, the schema owner, and have the SELECT
and DELETE privileges.
PURGEDATA
You must be the table owner or schema owner.REPLICATE
Privileges Required to Execute Utilities 211