03290-03295: TRUNCATE Command

This section lists messages generated when the TRUNCATE command is used.

Cause:	An invalid object specification was given for the TRUNCATE command.

Action:	Check the syntax of the command and retry the operation specifying either TRUNCATE CLUSTER or TRUNCATE TABLE.

ORA-03291 invalid truncate option - missing STORAGE keyword

Cause:	The STORAGE keyword was not specified with the DROP or REUSE options of the TRUNCATE command.

Action:	Check the syntax of the command and retry the operation.

ORA-03292 table to be truncated is a member of a cluster

Cause:	An attempt was made to truncate a table that is a member of a cluster.

Action:	Either truncate the entire cluster or drop and re-create the individual table.

ORA-03293 cluster to be truncated is a HASH CLUSTER

Cause:	An attempt was made to truncate a hash cluster. This is not permitted; only index clusters can be truncated.

Action:	Drop and re-create the cluster instead of using the TRUNCATE command.