Oracle8 Error Messages Release 8.0.4 A58312-01 |
Library | Product | Contents | Index

## 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.

Prev | Top | Next
| Copyright © 1997 Oracle Corporation. All Rights Reserved. |
Library | Product | Contents | Index