Oracle 11g Error Codes and Solution Suggestions from ORA-03200 to ORA-03300

Posted on by Fatih Acar

Oracle 11g Error Codes and Solution Suggestions from ORA-03200 to ORA-03300

ORA-03200: the segment type specification is invalid
Cause: segment type is not TABLE, INDEX, or CLUSTER
Action: use a correct segment type
ORA-03201: the group number specification is invalid
Cause: the freelist group number was either negative or larger than the the number of freelist groups in the segment
Action: use a correct group number
ORA-03202: the scan limit specification is invalid
Cause: the scan limit did not have a positive integer value the number of freelist groups in the segment
Action: use a correct scan limit
ORA-03203: concurrent update activity makes space analysis impossible
Cause: high volume of user updates interfere with the space analysis
Action: retry the command or lock the underlying objects
ORA-03204: the segment type specification should indicate partitioning
Cause: partition name is specified for the space analysis, but the object type does not indicate parttitioning
Action: specify PARTITION in the segment type, if the object is partitioned, otherwise, omit the partition name
ORA-03205: partition name is required when partitioned type is specified
Cause: partition name is not specified for the space analysis, but the object type indicates parttitioning
Action: specify partition name, if the object is partitioned, otherwise, specify a non-partitioned type
ORA-03206: maximum file size of (string) blocks in AUTOEXTEND clause is out of range
Cause: The maximum file size for an autoextendable file has exceeded the maximum number of blocks allowed.
Action: Reduce the size and retry.
ORA-03207: subpartitioned type must be specified for composite object
Cause: partition type is specified for the space analysis, but the object type indicates composite partitioning
Action: specify subpartition name and subpartition type

ORA-03208: partitioned type must be specified for a non-composite object
Cause: subpartition type is specified for the space analysis, but the object type indicates non-composite partitioning
Action: specify partition name and partition type
ORA-03209: DBMS_ADMIN_PACKAGE invalid file/block specification
Cause: The value of file number or block number is outside of limits or inconsistent
Action: Fix the file number/block number value
ORA-03210: DBMS_ADMIN_PACKAGE invalid option specification
Cause: The value of one of the option parameters is incorrect
Action: Fix the option value
ORA-03211: The segment does not exist or is not in a valid state
Cause: The segment specified in the DBMS_SPACE_ADMIN or DBMS_SPACE operation does not exist or is not in a state appropriate for this operation
Action: Fix the segment specification, or put the segment in the appropriate state.
ORA-03212: Temporary Segment cannot be created in locally-managed tablespace
Cause: Attempt to create a temporary segment for sort/hash/lobs in in permanent tablespace of kind locally-managed
Action: Alter temporary tablespace of user to a temporary tablespace or a dictionary-managed permanent tablespace
ORA-03213: Invalid Lob Segment Name for DBMS_SPACE package
Cause: The Lob Segment specified in the DBMS_SPACE operation does not exist.
Action: Fix the Segment Specification
ORA-03214: File Size specified is smaller than minimum required
Cause: File Size specified for add/resize datafile/tempfile does not allow for the minimum required of one allocation unit.
Action: Increase the specification for file size
ORA-03215: File Size specified for resize is too small
Cause: File Size specified for resize datafile/tempfile causes bitmap control structures to overlap
Action: Increase the specification for file size
ORA-03216: Tablespace/Segment Verification cannot proceed
Cause: Corruptions detected during verification whch cannot be dealt with
Action: Do manual verification
ORA-03217: invalid option for alter of TEMPORARY TABLESPACE
Cause: invalid option for alter of temporary tablespace was specified
Action: Specify one of the valid options: ADD TEMPFILE, TEMPFILE ONLINE, TEMPFILE OFFLINE
ORA-03218: invalid option for CREATE/ALTER TABLESPACE
Cause: invalid option for create/alter tablespace of type locally-managed
Action: Specify one of the valid options.
ORA-03219: Tablespace ‘string‘ is dictionary-managed, offline or temporary
Cause: Operation which is only applicable to permanent, online, locally-managed tablespaces is specified for a tablespace which is either dictionary-managed, offline or temporary
Action: Reissue operation for a different tablespace, mount the tablespace or do not issue it at all, since it does not apply for the given tablespace
ORA-03220: DBMS_ADMIN_PACKAGE required parameter is NULL or missing
Cause: Some of the procedures was called with missing or NULL parameters
Action: Specify the missing parameter
ORA-03221: Temporary tablespaces and temporary segments must have standard block size
Cause: An attempt was made to do one of the following : (1) create a temporary tablespace with a non-standard block size or, (2) alter an existing permanent tablespace of non-standard block size to a temporary tablespace or, (3) issue a DDL statement that would result in the creation of a temporary segment in a tablespace of non-standard block size.
Action: (1) If creating a temporary tablespace, do not specify a block size different from the standard block size. (2) If altering an existing permanent tablespace to a temporary tablespace, ensure that it is of standard block size. (3) Ensure that the user’s temporary tablespace is a tablespace having the standard block size.
ORA-03222: average row size and row count must be greater than zero
Cause: Either a bad value passed to dbms_space.create_table_cost() or explain plan did not pass through size information.
Action: Check the row size parameter in dbms_space.create_table_cost(). For explain plan, make sure statistics have been computed for all source tables in the CREATE TABLE AS SELECT statement.
ORA-03230: segment only contains string blocks of unused space above high water mark
Cause: Attempt to preserve too many blocks.
Action: reduce the KEEP amount.
ORA-03231: the INITIAL extent may not be deallocated
Cause: Attempt to deallocate space from the segment which was truncated prior to the 7.3 release.
Action: increase the KEEP amount, or truncate the segment, and reissue the command.
ORA-03233: unable to extend table string.string subpartition string by string in tablespace string
Cause: Failed to allocate an extent for table subpartition segment in tablespace.
Action: Use ALTER TABLESPACE ADD DATAFILE statement to add one or more files to the tablespace indicated.
ORA-03234: unable to extend index string.string subpartition string by string in tablespace string
Cause: Failed to allocate an extent for index subpartition segment in tablespace.
Action: Use ALTER TABLESPACE ADD DATAFILE statement to add one or more files to the tablespace indicated.
ORA-03235: max # extents (string) reached in table string.string subpartition string
Cause: A table subpartition tried to extend past maxextents
Action: If maxextents is less than the system maximum, raise it. Otherwise, you must recreate with larger initial, next or pctincrease params
ORA-03236: max # extents (string) reached in index string.string subpartition string
Cause: An index subpartition tried to extend past maxextents
Action: If maxextents is less than the system max, raise it. Otherwise, you must recreate with larger initial, next or pctincrease params.
ORA-03237: Initial Extent of specified size cannot be allocated in tablespace (string)
Cause: Too large a size for an initial extent due to freelist group specification
Action: Reduce number of freelist groups specified for segment
ORA-03238: unable to extend LOB segment string.string subpartition string by string in tablespace string
Cause: An attempt was made to allocate an extent for LOB subpartition segment in tablespace, but the extent could not be allocated because there is not enough space in the tablespace indicated.
Action: Use the ALTER TABLESPACE ADD DATAFILE statement to add one or more files to the tablespace indicated.
ORA-03239: maxextents (string) reached in LOB segment string.string subpartition string
Cause: A LOB subpartition segment tried to extend past maxextents.
Action: If maxextents is less than the system maximum, raise it. Otherwise, recreate the subpartition with larger INITIAL, NEXT, or PCTINCREASE parameters.
ORA-03240: User’s temporary tablespace same as tablespace being migrated
Cause: Users default temporary tablespace must be different from the tablespace being migrated.
Action: alter users default temporary tablespace to be different.
ORA-03241: Invalid unit size
Cause: User specified an invalid unit size for the tablespace
Action: Specify the correct unit size. To estimate unit size please refer to Oracle Server Administrator’s Guide.
ORA-03242: Tablespace migration retried 500 times
Cause: For migration to complete, temporary segments should not be present in the tablespace at the time of migration.
Action: Avoid migrating the tablespace when there is heavy temporary segment creation going on as with object drops.
ORA-03243: destination dba overlaps with existing control information
Cause: Cannot overlap control information during relocation
Action: Please chose another destination address
ORA-03244: No free space found to place the control information
Cause: During migration of tablespace found no place to put the control information. If during bitmaps relocation, found no space at the specified destination.
Action: If during migration, add more space to the tablespace and retry migration. If during bitmaps relocation, specify a destination address where there is enough free space.
ORA-03245: Tablespace has to be dictionary managed, online and permanent to be able to migrate
Cause: Tablespace was not dictionary managed or online or permanent.
Action: Make sure the tablespace is online, permanent and dictionary managed
ORA-03246: Invalid block number specified
Cause: Control information cannot be placed at the specified dba either because the block number specified is beyond the file end or the file is not large enough to accomodate the control information at that location
Action: specify a correct block number
ORA-03247: Invalid block number specified
Cause: Relocation of bitmaps to the said destination will make the tablespace self descriptive
Action: Choose another destination dba.
ORA-03248: Too much of segment creation activity during migration
Cause: Temporary segments were attempted to be created during migration
Action: The error is signalled after retrying migration for 500 times. Run migration when there is less of segment creation activity is going on.
ORA-03249: Uniform size for auto segment space managed tablespace should have atleast string blocks
Cause: For the given blocksize, uniform size specified is insufficient
Action: Specify larger extent size and retry
ORA-03250: Cannot mark this segment corrupt
Cause: This segment cannot be marked corrupt because it contains data dictionary objects
Action: Check the segment information and reissue the command.
ORA-03251: Cannot issue this command on SYSTEM tablespace
Cause: It is not permitted to migrate SYSTEM tablespace from locally managed format to dictionary managed format or relocate bitmaps.
Action: Check the tablespace name and procedure name
ORA-03252: initial extent size not enough for LOB segment
Cause: Fatblock size of LOB segment is too big to fit into the initial extent.
Action: Specify a smaller fatblock size or create the LOB segment in other tablespaces with bigger initial extent size.
ORA-03254: unable to execute the sql in read only database
Cause: Unable to create a consistent snapshot of the object in a read only database. Transaction recovery must be performed before opening the database read only.
Action: Open the database read write, allow dead transaction recovery to complete and then open the database read only.
ORA-03261: the tablespace string has only one file
Cause: Dropping file from ts which has a single file extent.
Action: Cannot make a tablespace fileless
ORA-03262: the file is non-empty
Cause: Trying to drop a non-empty datafile
Action: Cannot drop a non empty datafile
ORA-03263: cannot drop the first file of tablespace string
Cause: Trying to drop the first datafile with which ts is created
Action: Cannot drop the first datafile with which ts is created
ORA-03264: cannot drop offline datafile of locally managed tablespace
Cause: Trying to drop offline datafile in lmts
Action: Try to drop file afetr making it online
ORA-03274: both ALLOCATE EXTENT and DEALLOCATE UNUSED options are specified
Cause: The DEALLOCATE option and the ALLOCATE option are specified in the same command.
Action: Choose one of the options or issue two separate commands.
ORA-03275: duplicate DEALLOCATE option specification
Cause: The DEALLOCATE UNUSED option to ALTER TABLE or ALTER INDEX is specified more than once.
Action: Specify the option at most once.
ORA-03276: duplicate ALLOCATE EXTENT option specification
Cause: The ALLOCATE EXTENT option to ALTER TABLE or ALTER INDEX is specified more than once.
Action: Specify the option at most once.
ORA-03277: invalid SIZE specified
Cause: The specified value must be an integer.
Action: Choose an appropriate integer value.
ORA-03278: duplicate ALLOCATE EXTENT option specification
Cause: An option (DATAFILE, SIZE or INSTANCE) was specified more than once.
Action: Specify each option at most once.
ORA-03279: invalid INSTANCE specified
Cause: The specified value is not recognized as a valid instance name.
Action: Use a valid name.
ORA-03280: invalid DATAFILE filename specified
Cause: A character string literal is expected, but not found.
Action: Specify filenames using character string literals.
ORA-03281: invalid ALLOCATE EXTENT option
Cause: An option other than DATAFILE, SIZE or INSTANCE was specified.
Action: Remove invalid option and retry the command.
ORA-03282: missing ALLOCATE EXTENT option
Cause: No ALLOCATE EXTENT options were specified.
Action: Specified one or more of the following options: DATAFILE, SIZE or INSTANCE.
ORA-03283: specified datafile string does not exist
Cause: The datafile does not exist
Action: Retry the option with the correct datafile
ORA-03284: datafile or tempfile string is not a member of tablespace string
Cause: The specified datafile or tempfile did not belong to the tablespace that the object resides in.
Action: Retry the option with the correct datafile or tempfile.
ORA-03286: ALLOCATE EXTENT not valid for HASH CLUSTERS
Cause: The cluster is a hash cluster, and can not use the allcoate extent option.
Action: None
ORA-03287: invalid FREELIST GROUP specified
Cause: The specified FREELIST GROUP number is invalid
Action: Choose a number between 1 and # freelist groups for this object
ORA-03288: both FREELIST GROUP and INSTANCE parameters may not be specified
Cause: Both FREELIST GROUP and INSTANCE were specified in clause
Action: Remove one of the two parameters
ORA-03289: partition name and segment type do not match
Cause: Partition name and segment type specified for space analysis do not match
Action: Specify type PARTITION if the object is partitioned, specify SUBPARTITION if the object is composite
ORA-03290: Invalid truncate command – missing CLUSTER or TABLE keyword
Cause: Invalid object specification given.
Action: Either specify TRUNCATE CLUSTER or TRUNCATE TABLE
ORA-03291: Invalid truncate option – missing STORAGE keyword
Cause: Expected STORAGE keyword
Action: Either specify DROP 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.
Action: Either use TRUNCATE CLUSTER or DROP TABLE
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 ‘alter 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.

Leave a Reply

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

Time limit is exhausted. Please reload CAPTCHA.