Oracle tablespace error codes/messages

The Oracle tablespace is a logical storage unit of the Oracle database ,  a tablespace inlcuding one or more datafiles.

The are three types of tablespace: normal tablespace,  undo tablespace, redo tablespace.

When add tablespace,drop tablespace,tablespace is full, you may issue errors about tablespace.

Help following tablespace erros help you solve problems.

 

ORA-00959 tablespace ‘string’ does not exist

ORA-01129 user’s default or temporary tablespace does not exist

ORA-01147 SYSTEM tablespace file string is offline

ORA-01173 data dictionary indicates missing data file from system tablespace

ORA-01243 system tablespace file suffered media failure

ORA-01246 recovering files through TSPITR of tablespace string

ORA-01247 database recovery through TSPITR of tablespace string

ORA-01268 invalid TEMPFILE clause for alter of permanent TABLESPACE

ORA-01350 must specify a tablespace name

ORA-01351 tablespace given for Logminer dictionary does not exist

ORA-01352 tablespace given for Logminer spill does not exist

ORA-01533 cannot rename file ‘string’; file does not belong to tablespace

ORA-01536 space quota exceeded for tablespace ‘string’

ORA-01539 tablespace ‘string’ is not online

ORA-01540 tablespace ‘string’ is not offline

ORA-01541 system tablespace cannot be brought offline; shut down if necessary

ORA-01542 tablespace ‘string’ is offline, cannot allocate space in it

ORA-01543 tablespace ‘string’ already exists

ORA-01546 tablespace contains active rollback segment ‘string’

ORA-01548 active rollback segment ‘string’ found, terminate dropping tablespace

ORA-01549 tablespace not empty, use INCLUDING CONTENTS option

ORA-01550 cannot drop system tablespace

ORA-01552 cannot use system rollback segment for non-system tablespace ‘string’

ORA-01561 failed to remove all objects in the tablespace specified

ORA-01629 max # extents (string) reached saving undo for tablespace string

ORA-01630 max # extents (string) reached in temp segment in tablespace string

ORA-01640 cannot make tablespace read only with active transactions

ORA-01641 tablespace ‘string’ is not online – cannot add data file

ORA-01642 begin backup not needed for read only tablespace ‘string’

ORA-01643 system tablespace can not be made read only

ORA-01644 tablespace ‘string’ is already read only

ORA-01646 tablespace ‘string’ is not read only – cannot make read write

ORA-01647 tablespace ‘string’ is read only, cannot allocate space in it

ORA-01650 unable to extend rollback segment string by string in tablespace string

ORA-01651 unable to extend save undo segment by string for tablespace string

ORA-01652 unable to extend temp segment by string in tablespace string

ORA-01653 unable to extend table string.string by string in tablespace string

ORA-01654 unable to extend index string.string by string in tablespace string

ORA-01655 unable to extend cluster string.string by string in tablespace string

ORA-01658 unable to create INITIAL extent for segment in tablespace string

ORA-01659 unable to allocate MINEXTENTS beyond string in tablespace string

ORA-01660 tablespace ‘string’ is already permanent

ORA-01661 tablespace ‘string’ is already temporary

ORA-01662 tablespace ‘string’ is non-empty and cannot be made temporary

ORA-01663 the contents of tablespace ‘string’ is constantly changing

ORA-01667 cannot add any more tablespaces: limit of string exceeded

ORA-01680 unable to extend LOB segment by string in tablespace string

ORA-01681 max # extents (string) reached in LOB segment in tablespace string

ORA-01682 read-only DB cannot allocate temporary space in tablespace string

ORA-01683 unable to extend index string.string partition string by string in tablespace string

ORA-01686 max # files (string) reached for the tablespace string

ORA-01687 specified logging attribute for tablespace ‘string’ is same as the existing

ORA-01688 unable to extend table string.string partition string by string in tablespace string

ORA-01691 unable to extend lob segment string.string by string in tablespace string

ORA-01692 unable to extend lob segment string.string partition string by string in tablespace string

ORA-01699 tablespace ‘string’ is being imported for point in time recovery

ORA-01907 TABLESPACE keyword expected

ORA-01946 DEFAULT TABLESPACE already specified

ORA-01947 TEMPORARY TABLESPACE already specified

ORA-01950 no privileges on tablespace ‘string’

ORA-02140 invalid tablespace name

ORA-02142 missing or invalid ALTER TABLESPACE option

ORA-02155 invalid DEFAULT tablespace identifier

ORA-02156 invalid TEMPORARY tablespace identifier

ORA-02173 invalid option for DROP TABLESPACE

ORA-02180 invalid option for CREATE TABLESPACE

ORA-02186 tablespace resource privilege may not appear with other privileges

ORA-02189 ON tablespace required

ORA-02195 Attempt to create string object in a string tablespace

ORA-02215 duplicate tablespace name clause

ORA-02216 tablespace name expected

ORA-02495 cannot resize file string, tablespace string is read only

ORA-03212 Temporary Segment cannot be created in locally-managed tablespace

ORA-03216 Tablespace/Segment Verification cannot proceed

ORA-03217 invalid option for alter of TEMPORARY TABLESPACE

ORA-03218 invalid option for CREATE/ALTER TABLESPACE

ORA-03219 Tablespace ‘string’ is dictionary managed, offline, or temporary.

ORA-03221 temporary tablespaces and temporary segments must have standard block size
ORA-03233 unable to extend table string.string subpartition string by string in tablespace string

ORA-03234 unable to extend index string.string subpartition string by string in tablespace string

ORA-03237 Initial Extent of specified size cannot be allocated in tablespace (string)

ORA-03238 unable to extend LOB segment string.string subpartition string by string in tablespace string

ORA-03240 User’s temporary tablespace same as tablespace being migrated

ORA-03242 Tablespace migration retried 500 times

ORA-03245 Tablespace has to be dictionary managed, online and permanent to be able to migrate

ORA-03249 Uniform size for auto segment space managed tablespace should have atleast string blocks.

ORA-03251 Cannot issue this command on SYSTEM tablespace

ORA-03284 datafile string is not a member of tablespace string

ORA-10564 tablespace string

ORA-10615 Invalid tablespace type for temporary tablespace

ORA-10616 Operation not allowed on this tablespace

ORA-10617 Cannot create rollback segment in dictionary managed tablespace

ORA-10640 Operation not permitted during SYSTEM tablespace migration

ORA-10642 Found rollback segments in dictionary managed tablespaces

ORA-10644 SYSTEM tablespace cannot be default temporary tablespace

ORA-10646 Too many recursive extensions during SYSTEM tablespace migration

ORA-10647 Tablespace other than SYSTEM,string, string not found in read only mode

ORA-12900 must specify a default temporary tablespace for a locally managed database

ORA-12901 Default temporary tablespace must be of TEMPORARY type

ORA-12902 default temporary tablespace must be SYSTEM or of TEMPORARY type

ORA-12903 default temporary tablespace must be an ONLINE tablespace

ORA-12904 default temporary tablespace cannot be altered to PERMANENT type

ORA-12905 default temporary tablespace cannot be brought OFFLINE

ORA-12906 cannot drop default temporary tablespace

ORA-12907 tablespace string is already the default temporary tablespace

ORA-12908 cannot specify SYSTEM as default temporary tablespace when creating database

ORA-12910 cannot specify temporary tablespace as default tablespace

ORA-12911 permanent tablespace cannot be temporary tablespace

ORA-12912 Dictionary managed tablespace specified as temporary tablespace

ORA-12913 Cannot create dictionary managed tablespace

ORA-12914 Cannot migrate tablespace to dictionary managed type

ORA-12915 Cannot alter dictionary managed tablespace to read write

ORA-12923 tablespace string is in force logging mode

ORA-12924 tablespace string is already in force logging mode

ORA-12925 tablespace string is not in force logging mode

ORA-12985 tablespace ‘string’ is read only, cannot drop column

ORA-12993 tablespace ‘string’ is offline, cannot drop column

ORA-13114 tablespace string not found

ORA-13115 tablespace string is already allocated

ORA-13116 tablespace string is not allocated to table string

ORA-13119 source and target tablespaces are identical

ORA-13137 failed to generate tablespace sequence number

ORA-14062 one or more of table’s partitions reside in a read-only tablespace

ORA-14067 duplicate TABLESPACE_NUMBER specification

ORA-14068 TABLESPACE and TABLESPACE_NUMBER may not be both specified

ORA-14069 invalid TABLESPACE_NUMBER value

ORA-14084 you may specify TABLESPACE DEFAULT only for a LOCAL index

ORA-14117 partition resides in offlined tablespace

ORA-14177 STORE-IN (Tablespace list) can only be specified for a LOCAL index on a table which is hash or composite partitioned

ORA-14183 TABLESPACE DEFAULT can be specified only for Composite LOCAL index

ORA-14268 subpartition ‘string’ of the partition resides in offlined tablespace

ORA-14284 one or more of table’s subpartitions reside in a read-only tablespace

ORA-14404 partitioned table contains partitions in a different tablespace

ORA-14405 partitioned index contains partitions in a different tablespace

ORA-14407 partitioned table contains subpartitions in a different tablespace

ORA-14408 partitioned index contains subpartitions in a different tablespace

ORA-14519 Conflicting tablespace blocksizes for string string: Tablespace string block size string [string] conflicts with previously specified/implied tablespace string block size string [string]

ORA-14520 Tablespace string block size [string] does not match existing object block size [string]

ORA-14521 Default tablespace string block size [string] for string string does not match existing string block size [string]

ORA-14522 Partition-level default tablespace string block size [string] for string string does not match existing string block size [string]

ORA-14606 Tablespace was specified for previous subpartitions in template but is not specified for string

ORA-14607 Tablespace was not specified for previous subpartitions in template but is specified for string

ORA-14608 Tablespace was specified for the previous lob segments of column string in template but is not specified for string

ORA-14609 Tablespace was not specified for the previous lob segments of column string in template but is specified for string

ORA-14630 subpartition resides in offlined tablespace

ORA-19721 Cannot find datafile with absolute file number string in tablespace string

ORA-19732 incorrect number of datafiles for tablespace string

ORA-19736 can not plug a tablespace into a database using a different national character set

ORA-22868 table with LOBs contains segments in different tablespaces

ORA-22931 MOVE of nested table to a different tablespace not supported

ORA-22995 TABLESPACE DEFAULT option is invalid in this context

ORA-23515 materialized views and/or their indices exist in the tablespace

ORA-25100 TABLESPACE option can only be used with ALTER INDEX REBUILD

ORA-25107 duplicate TABLESPACE option specification

ORA-25139 invalid option for CREATE TEMPORARY TABLESPACE

ORA-25144 invalid option for CREATE TABLESPACE with TEMPORARY contents

ORA-25151 Rollback Segment cannot be created in this tablespace

ORA-25153 Temporary Tablespace is Empty

ORA-25183 index-organized table top index segment is in a different tablespace

ORA-26101 tablespace # in file header is string rather than string for file string

ORA-29300 ORACLE error, tablespace point-in-time recovery

ORA-29304 tablespace ‘string’ does not exist

ORA-29305 cannot point-in-time recover tablespace ‘string’

ORA-29313 tablespace ‘string’ cannot be imported twice

ORA-29314 tablespace ‘string’ is not OFFLINE FOR RECOVER nor READ ONLY

ORA-29315 tablespace ‘string’ has been recreated

ORA-29328 too many datafiles in this tablespace ‘string’

ORA-29335 tablespace ‘string’ is not read only

ORA-29337 tablespace ‘string’ has a non-standard block size (string)

ORA-29339 tablespace block size string does not match configured block sizes

ORA-29345 can not plug a tablespace into a database using a different character set

ORA-29346 invalid tablespace list

ORA-29347 Tablespace name validation failed – failed to match tablespace ‘string’

ORA-29349 tablespace ‘string’ already exists

Solution: Do not include this tablespace in the transportable set.

Solution: Reduce the list of tablespaces to transport.

Solution: Drop the offending tablespace if possible. Otherwise use a different method (for example, import/export) to move data.

Solution: Do not include this tablespace in the transportable set.

ORA-29351 can not transport system or temporary tablespace ‘string’

Solution: Drop the offending tablespace if possible. Otherwise use a different method (for example, import/export) to move data.

ORA-29351 can not transport system or temporary tablespace ‘string’

ORA-29857 domain indexes and/or secondary objects exist in the tablespace

ORA-30012 undo tablespace ‘string’ does not exist or of wrong type

ORA-30013 undo tablespace ‘string’ is currently in use

ORA-30015 previously offlined undo tablespace ‘string’ is still pending

ORA-30016 undo tablespace ‘string’ is already in use by this instance

ORA-30021 Operation not allowed on undo tablespace

ORA-30022 Cannot create segments in undo tablespace

ORA-30023 Duplicate undo tablespace specification

ORA-30024 Invalid specification for CREATE UNDO TABLESPACE

ORA-30025 DROP segment ‘string’ (in undo tablespace) not allowed

ORA-30026 Undo tablespace ‘string’ has unexpired undo with string(sec) left, Undo_Retention=string(sec)

ORA-30029 no active undo tablespace assigned to instance

ORA-30033 Undo tablespace cannot be specified as default user tablespace

ORA-30034 Undo tablespace cannot be specified as temporary tablespace

ORA-30035 Undo tablespace cannot be specified as default temporary tablespace

ORA-30036 unable to extend segment by string in undo tablespace ‘string’

ORA-30039 Cannot drop the undo tablespace

ORA-30040 Undo tablespace is offline

ORA-30041 Cannot grant quota on the tablespace

ORA-30042 Cannot offline the undo tablespace

ORA-30045 No undo tablespace name specified

ORA-30514 system trigger cannot modify tablespace being made read only

ORA-30573 AUTO segment space management not valid for this type of tablespace

ORA-30574 Cannot create rollback segment in tablespace with AUTO segment space management

ORA-30928 Connect by filtering phase runs out of temp tablespace