Oracle Database Errors or Warnings from Error ORA-03291 to ORA-04000



ORA-03291: Invalid truncate option – missing STORAGE keyword
Cause: Expected STORAGE keyword
Action: Either specify DROPP STORAGE or REUSE STORAGE
ORA-03292: Table to be truncated is part of a cluster
Cause: The table being truncated is a member of a cluster.
ORA-03293: Cluster to be truncated is a HASH CLUSTER

Cause: Only INDEX CLUSTERS can be truncated.
Action: Drop and recreate the HASH CLUSTER instead of using truncate.
ORA-03296: cannot resize datafile – file string not found
Cause: The specified datafile is not available for resizing.
Action: Ensure that the datafile name is valid, and if so, ensure the file is accessible.
ORA-03297: file contains used data beyond requested RESIZE value
Cause: Some portion of the file in the region to be trimmed is currently in use by a database object
Action: Drop or move segments containing extents in this region prior to resizing the file, or choose a resize value such that only free space is in the trimmed.

ORA-03298: cannot shrink datafile – file string is under hot backup
Cause: Attempt to shrink a datafile while it is under hot backup. This is not allowed.
Action: Retry shrinking the file after the hot backup completes.
ORA-03299: cannot create dictionary table string
Cause: A dictionary table is created upon the first execution of the command ‘alterr database datafile autoextend on’ for a database. This operation did not succeed. The most probable cause for this is insufficient space in the system tablespace.
Action: See action for next error message in error stack.
ORA-04000: the sum of PCTUSED and PCTFREE cannot exceed 100
Cause: the sum of PCTUSED and PCTFREE for a cluster or table exceeds 100
Action: create the table/cluster specifying values whose sum is <= 100

Above are list of Oracle Database Errors or Warnings from Error ORA-03291 to ORA-04000 received while performing certain operation against Oracle Database or related products.

What are Oracle Database Error Messages?

Oracle Error Messages may be returned while using products which are part of Oracle Database.  Each Oracle Database Error or Warning Message mentioned above contains the Warning or Error Message Statement, a short explanation of the probable causes of the Error message, and a recommended action.

Hope this was helpful.

SQLServerF1 Team
Information about Oracle Database Error Messages or Warning Messages on Windows and Linux Operating Systems.


Leave a Reply

Your email address will not be published. Required fields are marked *