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