03290-03295: TRUNCATE Command Messages

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

ORA-03290: invalid truncate command - missing CLUSTER or TABLE keyword

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.

---