{"id":1863,"date":"2016-04-09T13:20:36","date_gmt":"2016-04-09T10:20:36","guid":{"rendered":"http:\/\/www.fatihacar.com\/blog\/?p=1863"},"modified":"2016-10-24T13:21:44","modified_gmt":"2016-10-24T10:21:44","slug":"oracle-11g-error-codes-and-solution-suggestions-from-ora-12900-to-ora-13000","status":"publish","type":"post","link":"http:\/\/www.fatihacar.com\/blog\/oracle-11g-error-codes-and-solution-suggestions-from-ora-12900-to-ora-13000\/","title":{"rendered":"Oracle 11g Error Codes and Solution Suggestions from ORA-12900 to ORA-13000"},"content":{"rendered":"

Oracle 11g Error Codes and Solution Suggestions from ORA-12900 to ORA-13000<\/strong><\/p>\n

 <\/p>\n

\n
ORA-12900: must specify a default temporary tablespace for a locally managed database<\/i><\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0a locally managed database must have a temporary tablespace other than SYSTEM tablespace<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0specify the default temporary tablespace when creating a locally managed database<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12901: default temporary tablespace must be of TEMPORARY type<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0in a locally managed database, default temporary tablespace must be TEMPORARY type<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0None<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12902: default temporary tablespace must be SYSTEM or of TEMPORARY type<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0in a dictionary managed database, default temporary tablespace must be SYSTEM or TEMPORARY type<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0None<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12910: cannot specify temporary tablespace as default tablespace<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0attempt to assign a temporary tablespace to be a user’s default tablespace<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0assign a permanent tablespace to be the default tablespace<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12911: permanent tablespace cannot be temporary tablespace<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0attempt to assign a permanent tablespace to be a user’s temporary tablespace<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0assign a temporary tablespace to be user’s temporary tablespace<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12912: Dictionary managed tablespace specified as temporary tablespace<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0attempt to assign a dictionary managed tablespace to be a user’s temporary tablespace<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Assign a locally managed temporary tablespace to be user’s temporary tablespace<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12913: Cannot create dictionary managed tablespace<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Attemp to create dictionary managed tablespace in database which has system tablespace as locally managed<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Create a locally managed tablespace.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12914: Cannot migrate tablespace to dictionary managed type<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Attemp to migrate locally managed tablespace to dictionary managed type when the database has locally managed system tablespace.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Command cannot be issued.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12915: Cannot alter dictionary managed tablespace to read write<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Attemp to alter dictionary managed tablespace to read write in database which has system tablespace as locally managed. This tablespace can only be dropped.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Command cannot be issued.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12916: cannot shrink permanent or dictionary managed tablespace<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt was made to shrink a permanent tablespace or a dictionary managed tablespace.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check the tablespace type and issue the statement only on locally managed temporary tablespaces.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12918: Invalid tablespace type for default permanent tablespace<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The tablespace is either dropped, temporary or undo<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Check the tablespace type and reissue the statement<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12919: Can not drop the default permanent tablespace<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attemp was made to drop the default permanent tablespace<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Make a different tablespace as the default permanent tablespace and reissue the drop<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12920: database is already in force logging mode<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0ALTER DATABASE FORCE LOGGING command failed because the database is already in force logging mode.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0None<\/span><\/span><\/span><\/dd>\n

<\/p>\n

<\/a><\/a>ORA-12921: database is not in force logging mode<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0ALTER DATABASE NO FORCE LOGGING command failed because the database is not in force logging mode.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0None<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12922: concurrent ALTER DATABASE [NO] FORCE LOGGING command is running<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0There is a concurrent ALTER DATABASE FORCE LOGGING or ALTER DATABASE NO FORCE LOGGING command running in the system.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Contact the database administrator who is responsible for the concurrent command.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12923: tablespace\u00a0string<\/i>\u00a0is in force logging mode<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt to alter the specified tablespace temporary failed because the tablespace is in force logging mode.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Put the tablespace out of force logging mode by ALTER TABLESPACE NO FORCE LOGGING command.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12924: tablespace\u00a0string<\/i>\u00a0is already in force logging mode<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt to alter the specified tablespace into force logging mode failed because it is already in force logging mode.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0None<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12925: tablespace\u00a0string<\/i>\u00a0is not in force logging mode<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt to alter the specified tablespace out of force logging mode failed because it is not in force logging mode.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0None<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12926: FORCE LOGGING option already specified<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0In CREATE TABLESPACE, the FORCE LOGGING option was specified more than once.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Remove all but one of the FORCE LOGGING options.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12927: RETENTION option already specified<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0In CREATE TABLESPACE, the RETENTION option was specified more than once.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Remove all but one of the RETENTION options.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12928: ENCRYPTION option already specified<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0In CREATE TABLESPACE, the ENCRYPTION option was specified more than once.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Remove all but one of the ENCRYPTION options.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12940: Not enough space in DBVerify text buffer<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0DBVerify ran out of text buffer. The error was trapped internally by the system. DBVerify would return the result in text buffer and then resume checking.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0None<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12941: DBVerify exception<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0DBVerify encountered run-time error. The error signal was trapped internally by the system.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0None<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12950: SYSTEM tablespace specified as default permanent tablespace<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0SYSTEM tablespace was specified as the default permanent during database creation.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0If default permanent tablespace is not specified,then SYSTEM will implicitly become the default permanent tablespace. Specify an alternate tablespace or omit the default tablespace clause and reissue the CREATE DATABASE statement<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12951: Attempt to change default permanent tablespace to temporary<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0It is incorrect to alter the default permanent tablespace of a database to temporary type<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0None<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12980: checkpoint option not allowed with SET UNUSED<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt was made to specify checkpoint option with SET UNUSED.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Remove checkpoint option.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12981: cannot drop column from an object type table<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt was made to drop a column from an object type table.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0This action is not allowed.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12982: cannot drop column from a nested table<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt was made to drop a column from a nested table.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0This action is not allowed.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12983: cannot drop all columns in a table<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt was made to drop all columns in a table.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Make sure at least one column remains in the table after the drop column operation.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12984: cannot drop partitioning column<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt was made to drop a column used as the partitioning key.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0This action is not allowed.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12985: tablespace ‘string<\/i>‘ is read only, cannot drop column<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt was made to drop column from a partition\/subpartition on a read only tablespace.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Set the tablespace to read write and resubmit statement.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12986: columns in partially dropped state. Submit ALTER TABLE DROP COLUMNS CONTINUE<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt was made to access a table with columns in partially dropped state (i.e., drop column operation was interrupted).<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Submit ALTER TABLE DROP COLUMNS CONTINUE to complete the drop column operation before accessing the table.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12987: cannot combine drop column with other operations<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt was made to combine drop column with other ALTER TABLE operations.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Ensure that drop column is the sole operation specified in ALTER TABLE.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12988: cannot drop column from table owned by SYS<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt was made to drop a column from a system table.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0This action is not allowed<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12989: invalid value for checkpoint interval<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An invalid checkpoint interval specified in statement. Checkpoint interval must be between 0 and (2^31-1).<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Correct checkpoint interval and resubmit statement<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12990: duplicate option specified<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Duplicate option specified in statement.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Remove the duplicate option and resubmit statement.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12991: column is referenced in a multi-column constraint<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt was made to drop a column referenced by some constraints.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Drop all constraints referencing the dropped column or specify CASCADE CONSTRAINTS in statement.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12992: cannot drop parent key column<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt was made to drop a parent key column.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Drop all constraints referencing the parent key column, or specify CASCADE CONSTRAINTS in statement.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12993: tablespace ‘string<\/i>‘ is offline, cannot drop column<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt was made to drop a column from a partition\/subpartition on an offline tablespace.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Bring the tablespace online and resubmit statement.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12994: drop column option only allowed once in statement<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt was made to repeat the drop column option in a single statement.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Separate drop column options into different statements and resubmit statements.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12995: no columns in partially dropped state<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt was made to submit DROP COLUMNS CONTINUE statement while there are no partially dropped columns.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Cannot submit this statement.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12996: cannot drop system-generated virtual column<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt was made to drop a virtual column generated by the system.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0None<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12997: cannot drop primary key column from an index-organized table<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt was made to drop a primary key column from an index- organized table.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0This action is not allowed.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-12999: cannot DROP or SET UNUSED a column that has been set unused<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt was made to DROP or SET UNUSED a column that has already been ‘set unused’.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Use the DROP UNUSED COLUMNS option to remove the column.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-13000: dimension number is out of range<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The specified dimension is either smaller than 1 or greater than the number of dimensions encoded in the HHCODE.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Make sure that the dimension number is between 1 and the maximum number of dimensions encoded in the HHCODE.<\/span><\/span><\/span><\/dd>\n
<\/dd>\n<\/dl>\n","protected":false},"excerpt":{"rendered":"

Oracle 11g Error Codes and Solution Suggestions from ORA-12900 to ORA-13000   ORA-12900: must specify a default temporary tablespace for a locally managed database Cause:\u00a0a locally managed database must have a temporary tablespace other than SYSTEM tablespace Action:\u00a0specify the default temporary tablespace when creating a locally managed database ORA-12901: default temporary tablespace must be of…<\/p>\n","protected":false},"author":37,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[53],"tags":[14,32,54],"class_list":["post-1863","post","type-post","status-publish","format-standard","hentry","category-oracle-errors-and-solutions","tag-database-administration","tag-oracle-administration","tag-oracle-error-solutions"],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p39NFI-u3","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/1863","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/users\/37"}],"replies":[{"embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/comments?post=1863"}],"version-history":[{"count":1,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/1863\/revisions"}],"predecessor-version":[{"id":1864,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/1863\/revisions\/1864"}],"wp:attachment":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/media?parent=1863"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/categories?post=1863"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/tags?post=1863"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}