Oracle Database Errors or Warnings from Error ORA-29337 to ORA-29348

SQLServerF1

ORA-29337: tablespace ‘string’ has a non-standard block size (string)
Cause: The tablespace has a non-standard block size and making such a tablespace read-write is not permitted.
Action: Use some other mechanism to import the data
ORA-29338: datafile string is in an undesired state (string, string)
Cause: The referred datafile is not in a state ready for tablespace copy operation. For example, the datafile may be offline. The datafile needs to be ONLINE, and either READ ONLY or READ WRITE.
Action: Put the datafile into the desired state.
ORA-29339: tablespace block size string does not match configured block sizes
Cause: The block size of the tablespace to be plugged in or created does not match the block sizes configured in the database.
Action: Configure the appropriate cache for the block size of this tablespace using one of the various (db_2k_cache_size, db_4k_cache_size, db_8k_cache_size, db_16k_cache_size, db_32K_cache_size) parameters.

ORA-29340: export file appears to be corrupted: [string] [string] [string]
Cause: This is caused either by a corrupted export file or by an Oracle internal error.
Action: Make sure the export file used for transportable tablespace is not corrupted. If the error still occurs, call Oracle support.
ORA-29341: The transportable set is not self-contained
Cause: The set of objects in the set of tablespaces selected are not self-contained.
Action: Consider using different export options, or removing some of the pointers that caused the violation, or selecting a different set of tablespaces.
ORA-29342: user string does not exist in the database
Cause: The referred user is one of the owners of data in the pluggable set. This user does not exist in the database.
Action: Consider either creating the user in the database or map the user to a different user via FROM_USER and TO_USER import options.

ORA-29343: user string (mapped from user string) does not exist in the database
Cause: The referred user is one of the owners of data in the pluggable set. This user does not exist in the database.
Action: Consider either creating the user or map the original user to a different user.
ORA-29344: Owner validation failed – failed to match owner ‘string’
Cause: The system failed to match the referred owner. There are two cases that this may occur. (1) This user owns data in the transportable set, but this user is not specified in the TTS_OWNERS list of the import command line option, assuming that TTS_OWNERS is specified. (2) This user is specified in the TTS_OWNER list, but this user does not own any data in the transportable set.
Action: Retry import with a different OWNER list.
ORA-29345: cannot plug a tablespace into a database using an incompatible character set
Cause: Oracle does not support plugging a tablespace into a database using an incompatible character set.
Action: Use import/export or unload/load to move data instead.
ORA-29346: invalid tablespace list
Cause: the tablespace list supplied to dbms_tts.transport_set_check PL/SQL routine is in an incorrect format.
Action: Check the manual and use the correct format.
ORA-29347: Tablespace name validation failed – failed to match tablespace ‘string’
Cause: The system failed to match the referred tablespace. There are 2 cases that this may happen. (1) This tablespace is in the transportable set, but it is not specified in the TABLESPACES list of the import command line option, assuming that TABLESPACES is specified. (2) This tablespace is in the TABLESPACES list, but it is not in the transportable set.
Action: Retry the operation with the correct TABLESPACES list.
ORA-29348: You must specify the datafiles to be plugged in
Cause: The datafiles to be plugged in are not specified.
Action: Specify the datafiles via the import DATAFILES command line option.

Above are list of Oracle Database Errors or Warnings from Error ORA-29337 to ORA-29348 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.

Thanks,
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 *