Overblog Suivre ce blog
Editer la page Administration Créer mon blog
/ / /

 

Liste Erreurs Oracle Cause et Action

 

ORA-12700 ORA-12700: invalid NLS parameter value (string)
Cause  An invalid or unknown NLS configuration parameter was specified.
Action  none

 

ORA-12701 ORA-12701: CREATE DATABASE character set is not known
Cause  The character set specified when creating the database is unknown.
Action  none

 

ORA-12702 ORA-12702: invalid NLS parameter string used in SQL function
Cause  An unknown parameter name or invalid value is specified in a NLS parameter string.
Action  none

 

ORA-12703 ORA-12703: this character set conversion is not supported
Cause  The requested conversion between two character sets in the CONVERT function is not implemented
Action  none

 

ORA-12704 ORA-12704: character set mismatch
Cause  One of the following:
- The string operands(other than an nlsparams argument) to an operator or built-in function do not have the same character set.
- An nlsparams operand is not in the database character set.
- String data with character set other than the database character set is passed to a built-in function not expecting it.
- The second argument to CHR() or CSCONVERT() is not CHAR_CS or NCHAR_CS.
- A string expression in the VALUES clause of an INSERT statement, or the SET clause of an UPDATE statement, does not have the same character set as the column into which the value would be inserted.
- A value provided in a DEFAULT clause when creating a table does not have the same character set as declared for the column.
- An argument to a PL/SQL function does not conform to the character set requirements of the corresponding parameter.
Action  none

 

ORA-12705 ORA-12705: Cannot access NLS data files or invalid environment specified
Cause  Either an attempt was made to issue an ALTER SESSION command with an invalid NLS parameter or value; or the environment variable(s) NLS_LANG, ORA_NLSxx, or ORACLE_HOME was incorrectly specified, therefore the NLS data files cannot be located.
Action  Check the syntax of the ALTER SESSION command and the NLS parameter, correct the syntax and retry the statement, or specify the correct directory path/values in the environment variables.

 

ORA-12706 ORA-12706: this CREATE DATABASE character set is not allowed
Cause  It is not allowed to create a database on a native ASCII-based machine using an EBCDIC-based character set, and vice versa.
Action  none

 

ORA-12707 ORA-12707: error while getting create database NLS parameter string
Cause  Internal error
Action  none

 

ORA-12708 ORA-12708: error while loading create database NLS parameter string
Cause  Internal error
Action  none

 

ORA-12709 ORA-12709: error while loading create database character set
Cause  Internal error
Action  none

 

ORA-12710 ORA-12710: CREATE CONTROLFILE character set is not known
Cause  The character set specified when creating the control file is unknown.
Action  none

 

ORA-12711 ORA-12711: this CREATE CONTROLFILE character set is not allowed
Cause  It is not allowed to create a control file on a native ASCII-based machine using an EBCDIC-based character set, and vice versa.
Action  none

 

ORA-12712 ORA-12712: new character set must be a superset of old character set
Cause  When you ALTER DATABASE ... CHARACTER SET, the new character set must be a superset of the old character set. For example, WE8ISO8859P1 is not a superset of the WE8DEC.
Action  Specify a superset character set.

 

ORA-12713 ORA-12713: Character data loss in NCHAR/CHAR conversion
Cause  When character set conversion happens between CHAR and NCHAR either implicitly or explicitly, some characters are lost due to no mapping characters in the destination character set.
Action  Make sure all the characters can be mapped to destination character set or set NLS_NCHAR_CONV_EXCP to be FALSE.

 

ORA-12714 ORA-12714: invalid national character set specified
Cause  Only UTF8 and AL16UTF16 are allowed to be used as the national character set
Action  Ensure that the specified national character set is valid

 

ORA-12715 ORA-12715: invalid character set specified
Cause  The character set specified is not allowed for this operation or is invalid
Action  Ensure that the specified character set is valid

 

ORA-12716 ORA-12716: Cannot ALTER DATABASE CHARACTER SET when CLOB data exists
Cause  CLOB data changes representation to Unicode when converting to a multibyte character set and must be migrated
Action  Remove CLOB data as listed in the alert file. CLOB data can be migrated by methods such as import/export

 

ORA-12717 ORA-12717: Cannot issue ALTER DATABASE NATIONAL CHARACTER SET when NCLOB, NCHAR or NVARCHAR2 data exists
Cause  NCLOB, NCHAR or NVARCHAR2 data changed the representation to Unicode when converting to a multibyte character set and must be migrated.
Action  Remove NCLOB, NCHAR or NVARCHAR2 data as listed in the alert file. The above type data can be migrated by methods such as import/export.

 

ORA-12718 ORA-12718: operation requires connection as SYS
Cause  This command can only be run when connecting as SYS
Action  Connect as SYS to run this command

 

ORA-12719 ORA-12719: operation requires database is in RESTRICTED mode
Cause  This command can only be run when the database is in RESTRICTED mode
Action  Ensure that the system is in RESTRICTED mode

 

ORA-12720 ORA-12720: operation requires database is in EXCLUSIVE mode
Cause  This command can only be run when the database is in EXCLUSIVE mode
Action  Ensure that the system is in EXCLUSIVE mode

 

ORA-12721 ORA-12721: operation cannot execute when other sessions are active
Cause  This command can only be run when there are no other sessions active
Action  Ensure there are no other connections to the database

 

ORA-12722 ORA-12722: regular expression internal error
Cause  A regular expression internal error occurred.
Action  This is an internal error. Contact Oracle Support Services.

 

ORA-12723 ORA-12723: regular expression too complex
Cause  The regular expression was too complex and could not be parsed.
Action  This is an internal error. Contact Oracle Support Services.

 

ORA-12724 ORA-12724: regular expression corrupt
Cause  The regular expression contained an incorrect sequence of metacharacters.
Action  Ensure the metacharacters are correctly positioned.

 

ORA-12725 ORA-12725: unmatched parentheses in regular expression
Cause  The regular expression did not have balanced parentheses.
Action  Ensure the parentheses are correctly balanced.

 

ORA-12726 ORA-12726: unmatched bracket in regular expression
Cause  The regular expression did not have balanced brackets.
Action  Ensure the brackets are correctly balanced.

 

ORA-12727 ORA-12727: invalid back reference in regular expression
Cause  A back references was found before a sub-expression.
Action  Ensure a valid sub-expression is being referenced.

 

ORA-12728 ORA-12728: invalid range in regular expression
Cause  An invalid range was found in the regular expression.
Action  Ensure a valid range is being used.

 

ORA-12729 ORA-12729: invalid character class in regular expression
Cause  An unknown character class was found in the regular expression.
Action  Ensure a valid characters class is being used.

 

ORA-12730 ORA-12730: invalid equivalence class in regular expression
Cause  An unknown equivalence class was found in the regular expression.
Action  Ensure a valid equivalence class is being used.

 

ORA-12731 ORA-12731: invalid collation class in regular expression
Cause  An unknown collation class was found in the regular expression.
Action  Ensure a valid collation class is being used.

 

ORA-12732 ORA-12732: invalid interval value in regular expression
Cause  An invalid interval value was found in the regular expression.
Action  Ensure a valid interval value is being used.

 

ORA-12733 ORA-12733: regular expression too long
Cause  The operation failed because the regular expression it used exceeds the maximum supported size.
Action  Use a shorter regular expression.

 

ORA-12734 ORA-12734: Instant Client Light: unsupported client national character set string
Cause  Only UTF8 and AL16UTF16 are allowed to be used as the national character set. Instant Client Light has only minimal character sets.
Action  Do not use Instant Client Light for this character set

 

ORA-12735 ORA-12735: Instant Client Light: unsupported client character set string
Cause  The character set specified is not allowed for this operation or is invalid. Instant Client Light has only minimal character sets.
Action  Do not use Instant Client Light for this character set

 

ORA-12736 ORA-12736: Instant Client Light: unsupported server national character set string
Cause  Only UTF8 and AL16UTF16 are allowed to be used as the national character set. Instant Client Light has only minimal character sets.
Action  Do not use Instant Client Light for this character set

 

ORA-12737 ORA-12737: Instant Client Light: unsupported server character set string
Cause  The character set specified is not allowed for this operation or is invalid. Instant Client Light has only minimal character sets.
Action  Do not use Instant Client Light for this character set

 

ORA-12800 ORA-12800: system appears too busy for parallel query execution
Cause  load on system is too high to perform parallel queries.
Action  re-execute serially or wait until system load is reduced.

 

ORA-12801 ORA-12801: error signaled in parallel query server string
Cause  A parallel query server reached an exception condition.
Action  Check the following error message for the cause, and consult your error manual for the appropriate action.

 

ORA-12802 ORA-12802: parallel query server lost contact with coordinator
Cause  A parallel query server lost contact with the foreground (coordinator) process/thread.
Action  Check your system for anomalies and reissue the statement. If this error persists, contact Oracle Support Services.

 

ORA-12803 ORA-12803: parallel query server lost contact with another server
Cause  A parallel query server lost contact with another server.
Action  Check your system for anomalies and reissue the statement. If this error persists, contact Oracle Support Services.

 

ORA-12804 ORA-12804: parallel query server appears to have died
Cause  Cannot find process information for a parallel query server thread.
Action  Check your system for anomalies and reissue the statement. If this error persists, contact Oracle Support Services.

 

ORA-12805 ORA-12805: parallel query server died unexpectedly
Cause  A parallel query server died unexpectedly, PMON cleaning up the process.
Action  Check your system for anomalies and reissue the statement. If this error persists, contact Oracle Support Services. See trace file for more details.

 

ORA-12806 ORA-12806: could not get background process to hold enqueue
Cause  Internal error.
Action  This error should not normally occur. If it persists, contact Oracle Support Services.

 

ORA-12807 ORA-12807: process queue could not receive parallel query message
Cause  Internal error.
Action  This error should not normally occur. If it persists, contact Oracle Support Services.

 

ORA-12808 ORA-12808: cannot set string_INSTANCES greater than number of instances string
Cause  An attempt was made to set SCAN_INSTANCES or CACHE_INSTANCES using the ALTER SYSTEM command to a value larger than the number of available instances.
Action  See the accompanying message for the current allowable maximum value, or set SCAN_INSTANCES / CACHE_INSTANCES to ALL.

 

ORA-12809 ORA-12809: cannot set string_INSTANCES when mounted in exclusive mode
Cause  An attempt was made to set SCAN_INSTANCES or CACHE_INSTANCES using the ALTER SYSTEM command while the database was mounted in exclusive mode.
Action  SCAN_INSTANCES / CACHE_INSTANCES may not be set unless running Oracle Real Application Clusters mounted in CLUSTER_DATABASE mode.

 

ORA-12810 ORA-12810: PARALLEL_MAX_SERVERS must be less than or equal to string
Cause  An attempt was made to set the PARALLEL_MAX_SERVERS parameter to a value higher than the maximum allowed by the system.
Action  Set PARALLEL_MAX_SERVERS to a value less than or equal to the maximum specified in the accompanying message and retry.

 

ORA-12811 ORA-12811: PARALLEL_MIN_SERVERS must be less than or equal to PARALLEL_MAX_SERVERS, string
Cause  An attempt was made to set the PARALLEL_MIN_SERVERS parameter to a value higher than PARALLEL_MAX_SERVERS.
Action  Set PARALLEL_MIN_SERVERS to a value less than or equal to PARALLEL_MAX_SERVERS (indicated in the accompanying message) and retry.

 

ORA-12812 ORA-12812: only one PARALLEL or NOPARALLEL clause may be specified
Cause  PARALLEL was specified more than once, NOPARALLEL was specified more than once, or both PARALLEL and NOPARALLEL were specified in a CREATE TABLE, CLUSTER, or INDEX or in an ALTER TABLE or CLUSTER statement, or in a RECOVER command.
Action  Remove all but one of the PARALLEL or NOPARALLEL clauses and reissue the statement.

 

ORA-12813 ORA-12813: value for PARALLEL or DEGREE must be greater than 0
Cause  PARALLEL 0 or DEGREE 0 was specified in a CREATE TABLE, CLUSTER, or INDEX or in an ALTER TABLE or CLUSTER statement.
Action  Specify a degree of parallelism greater than 0 or specify default parallelism using PARALLEL with no degree or using DEGREE DEFAULT within a PARALLEL clause.

 

ORA-12814 ORA-12814: only one CACHE or NOCACHE clause may be specified
Cause  CACHE was specified more than once, NOCACHE was specified more than once, or both CACHE and NOCACHE were specified in a CREATE TABLE or CLUSTER, or in an ALTER TABLE or CLUSTER statement.
Action  Remove all but one of the CACHE or NOCACHE clauses and reissue the statement.

 

ORA-12815 ORA-12815: value for INSTANCES must be greater than 0
Cause  PARALLEL parameter specifying number of instances must be a positive integer or DEFAULT
Action  specify a positive integer or DEFAULT for INSTANCES if parallelism across instances is desired.

 

ORA-12817 ORA-12817: parallel query option must be enabled
Cause  A parallel query option feature has been invoked but this option has not been enabled.
Action  Enable the parallel query option.

 

ORA-12818 ORA-12818: invalid option in PARALLEL clause
Cause  an unrecognized option was used within a PARALLEL clause.
Action  specify any combination of DEGREE { | DEFAULT } and INSTANCES { | DEFAULT } within the PARALLEL clause.

 

ORA-12819 ORA-12819: missing options in PARALLEL clause
Cause  PARALLEL clause cannot be empty.
Action  specify any combination of DEGREE { | DEFAULT } and INSTANCES { | DEFAULT } within the PARALLEL clause.

 

ORA-12820 ORA-12820: invalid value for DEGREE
Cause  invalid value for DEGREE was specified within a PARALLEL clause.
Action  specify a positive integer or DEFAULT for the DEGREE option within a PARALLEL clause.

 

ORA-12821 ORA-12821: invalid value for INSTANCES
Cause  invalid value for INSTANCES was specified within a PARALLEL clause.
Action  specify a positive integer or DEFAULT for the INSTANCES option within a PARALLEL clause.

 

ORA-12822 ORA-12822: duplicate option in PARALLEL clause
Cause  DEGREE or INSTANCES was specified more than once within a PARALLEL clause.
Action  specify each desired PARALLEL clause option only once.

 

ORA-12823 ORA-12823: default degree of parallelism may not be specified here
Cause  the PARALLEL keyword was used alone or DEGREE DEFAULT was specified in the PARALLEL clause of an ALTER DATABASE RECOVER command.
Action  respecify with an explicit degree of parallelism.

 

ORA-12824 ORA-12824: INSTANCES DEFAULT may not be specified here
Cause  INSTANCES DEFAULT was specified in the PARALLEL clause of an ALTER DATABASE RECOVER command
Action  respecify with an explicit value for INSTANCES or omit the INSTANCES option if single instance recovery is desired.

 

ORA-12825 ORA-12825: explicit degree of parallelism must be specified here
Cause  the DEGREE option was omitted from an ALTER DATABASE RECOVER command.
Action  respecify with an explicit degree of parallelism.

 

ORA-12826 ORA-12826: hung parallel query server was killed
Cause  parallel query server was hung and subsequently killed.
Action  re-execute query and report suspicious events in trace file to Oracle Support Services if error persists.

 

ORA-12827 ORA-12827: insufficient parallel query slaves available
Cause  PARALLEL_MIN_PERCENT parameter was specified and fewer than minimum slaves were acquired
Action  either re-execute query with lower PARALLEL_MIN_PERCENT or wait until some running queries are completed, thus freeing up slaves

 

ORA-12828 ORA-12828: Can"t start parallel transaction at a remote site
Cause  PDML transaction cannot be started because we are not in the coordinator site of the distributed transaction.
Action  Do not use PDML at remote sites.

 

ORA-12829 ORA-12829: Deadlock - itls occupied by siblings at block string of file string
Cause  parallel statement failed because all itls in the current block are occupied by siblings of the same transaction.
Action  increase MAXTRANS of the block or reduce the degree of parallelism for the statement. Reexecute the statement. Report suspicious events in trace file to Oracle Support Services if error persists.

 

ORA-12830 ORA-12830: Must COMMIT or ROLLBACK after executing parallel INSERT/UPDATE/DELETE
Cause  After executing a parallel INSERT/UPDATE/DELETE statement, a command other than COMMIT or ROLLBACK was issued.
Action  Execute COMMIT or ROLLBACK before issuing another SQL command.

 

ORA-12831 ORA-12831: Must COMMIT or ROLLBACK after executing INSERT with APPEND hint
Cause  After executing an INSERT statement with an APPEND hint, a command other than COMMIT or ROLLBACK was issued.
Action  Execute COMMIT or ROLLBACK before issuing another SQL command.

 

ORA-12832 ORA-12832: Could not allocate slaves on all specified instances
Cause  After executing a query on a global v$ fixed view, one or more instances failed to allocate a slave to process query
Action  To allow results to be returned by sucessfully allocated slaves, execute ALTER SESSION SET ALLOW_PARTIAL_SN_RESULTS=TRUE statement, or check parameters of instances

 

ORA-12833 ORA-12833: Coordinator"s instance not a member of parallel_instance_group
Cause  The coordinator"s instance must be a member of the parallel_instance_group in which this operation will be run.
Action  Either add the coordinator"s instance to the current parallel_instance_group or change parallel_instance_group.

 

ORA-12834 ORA-12834: Instance group name, "string", too long, must be less than string characters
Cause  The instance group name is too long.
Action  Either shorten the name or get rid of the instance group.

 

ORA-12835 ORA-12835: No instances are active in the GLOBAL_VIEW_ADMIN_GROUP
Cause  There must be at least one instance in the GLOBAL_VIEW_ADMIN_GROUP in order to execute a query on global views
Action  Change the value of GLOBAL_VIEW_ADMIN_GROUP

 

ORA-12838 ORA-12838: cannot read/modify an object after modifying it in parallel
Cause  Within the same transaction, an attempt was made to add read or modification statements on a table after it had been modified in parallel or with direct load. This is not permitted.
Action  Rewrite the transaction, or break it up into two transactions: one containing the initial modification and the second containing the parallel modification operation.

 

ORA-12839 ORA-12839: cannot modify an object in parallel after modifying it
Cause  Within the same transaction, an attempt was made to perform parallel modification operations on a table after it had been modified. This is not permitted.
Action  Rewrite the transaction or break it up into two transactions: one containing the parallel modification and the second containing the initial modification operation.

 

ORA-12840 ORA-12840: cannot access a remote table after parallel/insert direct load txn
Cause  Within a transaction, an attempt was made to perform distributed access after a PDML or insert direct statement had been issued.
Action  Commit/rollback the PDML transaction first, and then perform the distributed access, or perform the distributed access before the first PDML statement in the transaction.

 

ORA-12841 ORA-12841: Cannot alter the session parallel DML state within a transaction
Cause  Transaction in progress
Action  Commit or rollback transaction and then re-execute

 

ORA-12842 ORA-12842: Cursor invalidated during parallel execution
Cause  The cursor was invalidated during the parse phase of deferred parallel processing, e.g. when set operands are parallelized.
Action  Depends on why the cursor was invalidated. Possible causes include DDL on a schema object and shared pool being flushed.

 

ORA-12843 ORA-12843: pdml lock not held properly on the table
Cause  The coodinator crashed or released the lock on the partition which the slave is trying to aquire currently.
Action  Check if the coordinator or some of the other slaves died. Also check that the lock has not been corrupted. Issue the pdml again.

 

ORA-12844 ORA-12844: cluster reconfiguration in progress
Cause  Internal error
Action  THIS IS NOT A USER ERROR NUMBER/MESSAGE. THIS DOES NOT NEED TO BE TRANSLATED OR DOCUMENTED. IT IS USED ONLY FOR INTERNAL ERROR.

 

ORA-12845 ORA-12845: failed to receive interinstance parallel execution message
Cause  OS or interconnect problem receiving interinstance message
Action  Check OS specific diagnostics

 

ORA-12850 ORA-12850: Could not allocate slaves on all specified instances: string needed, string allocated
Cause  When executing a query on a gv$ fixed view, one or more instances failed to allocate a slave to process query.
Action  Check trace output for instances on which slaves failed to start. GV$ query can only proceed if slaves can be allocated on all instances.

 

ORA-12851 ORA-12851: PARALLEL_MAX_SERVERS must be greater than or equal to PARALLEL_MIN_SERVERS, string
Cause  An attempt was made to set the PARALLEL_MAX_SERVERS parameter to a value less than PARALLEL_MIN_SERVERS.
Action  Set PARALLEL_MAX_SERVERS to a value greater than or equal to PARALLEL_MIN_SERVERS value specified in the accompanying message and retry.

 

ORA-12852 ORA-12852: PARALLEL_MIN_SERVERS must be less than PROCESSES, string
Cause  An attempt was made to set the PARALLEL_MIN_SERVERS parameter to a value higher than PROCESSES.
Action  Set PARALLEL_MIN_SERVERS to a value less than PROCESSES value specified in the accompanying message and retry.

 

ORA-12853 ORA-12853: insufficient memory for PX buffers: current stringK, max needed stringK
Cause  Insufficient SGA memory for PX buffers
Action  Reconfigure sga to include at least (max - current) bytes of additional memory

 

ORA-12854 ORA-12854: Parallel query is not supported on temporary LOBs
Cause  The parallel query statement produced a temporary LOB.
Action  Turn off parallelism for the query or underlying table

 

ORA-12855 ORA-12855: cannot run parallel or insert direct load in a loopback
Cause  A loopback was created in the transaction before this operation.
Action  Do not use loopback when using pdml or insert direct load.

 

ORA-12856 ORA-12856: cannot run parallel query on a loopback connection
Cause  A table or index in a parallel query is referenced via a loopback connection.
Action  Do not use loopback connection when running a query in parallel.

 

ORA-12872 ORA-12872: First slave parse gave different plan
Cause  First hard parse on slave given QC-supplied environment and parameters gave different plan from QC. Try again with outline.
Action  No external action. Internally used for outline-based reparse.

 

ORA-12899 ORA-12899: value too large for column string (actual: string, maximum: string)
Cause  An attempt was made to insert or update a column with a value which is too wide for the width of the destination column. The name of the column is given, along with the actual width of the value, and the maximum allowed width of the column. Note that widths are reported in characters if character length semantics are in effect for the column, otherwise widths are reported in bytes.
Action  Examine the SQL statement for correctness. Check source and destination column data types. Either make the destination column wider, or use a subset of the source column (i.e. use substring).

 

ORA-12900 ORA-12900: must specify a default temporary tablespace for a locally managed database
Cause  a locally managed database must have a temporary tablespace other than SYSTEM tablespace
Action  specify the default temporary tablespace when creating a locally managed database

 

ORA-12901 ORA-12901: default temporary tablespace must be of TEMPORARY type
Cause  in a locally managed database, default temporary tablespace must be TEMPORARY type
Action  none

 

ORA-12902 ORA-12902: default temporary tablespace must be SYSTEM or of TEMPORARY type
Cause  in a dictionary managed database, default temporary tablespace must be SYSTEM or TEMPORARY type
Action  none

 

ORA-12910 ORA-12910: cannot specify temporary tablespace as default tablespace
Cause  attempt to assign a temporary tablespace to be a user"s default tablespace
Action  assign a permanent tablespace to be the default tablespace

 

ORA-12911 ORA-12911: permanent tablespace cannot be temporary tablespace
Cause  attempt to assign a permanent tablespace to be a user"s temporary tablespace
Action  assign a temporary tablespace to be user"s temporary tablespace

 

ORA-12912 ORA-12912: Dictionary managed tablespace specified as temporary tablespace
Cause  attempt to assign a dictionary managed tablespace to be a user"s temporary tablespace
Action  Assign a locally managed temporary tablespace to be user"s temporary tablespace

 

ORA-12913 ORA-12913: Cannot c
reate dictionary managed tablespace
Cause  Attemp to create dictionary managed tablespace in database which has system tablespace as locally managed
Action  Create a locally managed tablespace.

 

ORA-12914 ORA-12914: Cannot migrate tablespace to dictionary managed type
Cause  Attemp to migrate locally managed tablespace to dictionary managed type when the database has locally managed system tablespace.
Action  Command cannot be issued.

 

ORA-12915 ORA-12915: Cannot alter dictionary managed tablespace to read write
Cause  Attemp to alter dictionary managed tablespace to read write in database which has system tablespace as locally managed. This tablespace can only be dropped.
Action  Command cannot be issued.

 

ORA-12916 ORA-12916: Cannot use default permanent tablespace with this release
Cause  To use default permanent tablespace the release should be 10.0 or higher
Action  Check the compatibility setting and reissue the statement

 

ORA-12918 ORA-12918: Invalid tablespace type for default permanent tablespace
Cause  The tablespace is either dropped, temporary or undo
Action  Check the tablespace type and reissue the statement

 

ORA-12919 ORA-12919: Can not drop the default permanent tablespace
Cause  An attemp was made to drop the default permanent tablespace
Action  Make a different tablespace as the default permanent tablespace and reissue the drop

 

ORA-12920 ORA-12920: database is already in force logging mode
Cause  ALTER DATABASE FORCE LOGGING command failed because the database is already in force logging mode.
Action  none

 

ORA-12921 ORA-12921: database is not in force logging mode
Cause  ALTER DATABASE NO FORCE LOGGING command failed because the database is not in force logging mode.
Action  none

 

ORA-12922 ORA-12922: concurrent ALTER DATABASE [NO] FORCE LOGGING command is running
Cause  There is a concurrent ALTER DATABASE FORCE LOGGING or ALTER DATABASE NO FORCE LOGGING command running in the system.
Action  Contact the database administrator who is responsible for the concurrent command.

 

ORA-12923 ORA-12923: tablespace string is in force logging mode
Cause  An attempt to alter the specified tablespace temporary failed because the tablespace is in force logging mode.
Action  Put the tablespace out of force logging mode by ALTER TABLESPACE NO FORCE LOGGING command.

 

ORA-12924 ORA-12924: tablespace string is already in force logging mode
Cause  An attempt to alter the specified tablespace into force logging mode failed because it is already in force logging mode.
Action  none

 

ORA-12925 ORA-12925: tablespace string is not in force logging mode
Cause  An attempt to alter the specified tablespace out of force logging mode failed because it is not in force logging mode.
Action  none

 

ORA-12926 ORA-12926: FORCE LOGGING option already specified
Cause  In CREATE TABLESPACE, the FORCE LOGGING option was specified more than once.
Action  Remove all but one of the FORCE LOGGING options.

 

ORA-12927 ORA-12927: RETENTION option already specified
Cause  In CREATE TABLESPACE, the RETENTION option was specified more than once.
Action  Remove all but one of the RETENTION options.

 

ORA-12950 ORA-12950: SYSTEM tablespace specified as default permanent tablespace
Cause  SYSTEM tablespace was specified as the default permanent during database creation.
Action  If 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

 

ORA-12951 ORA-12951: Attempt to change default permanent tablespace to temporary
Cause  It is incorrect to alter the default permanent tablespace of a database to temporary type
Action  none

 

ORA-12980 ORA-12980: checkpoint option not allowed with SET UNUSED
Cause  An attempt was made to specify checkpoint option with SET UNUSED.
Action  Remove checkpoint option.

 

ORA-12981 ORA-12981: cannot drop column from an object type table
Cause  An attempt was made to drop a column from an object type table.
Action  This action is not allowed.

 

ORA-12982 ORA-12982: cannot drop column from a nested table
Cause  An attempt was made to drop a column from a nested table.
Action  This action is not allowed.

 

ORA-12983 ORA-12983: cannot drop all columns in a table
Cause  An attempt was made to drop all columns in a table.
Action  Make sure at least one column remains in the table after the drop column operation.

 

ORA-12984 ORA-12984: cannot drop partitioning column
Cause  An attempt was made to drop a column used as the partitioning key.
Action  This action is not allowed.

 

ORA-12985 ORA-12985: tablespace "string" is read only, cannot drop column
Cause  An attempt was made to drop column from a partition/subpartition on a read only tablespace.
Action  Set the tablespace to read write and resubmit statement.

 

ORA-12986 ORA-12986: columns in partially dropped state. Submit ALTER TABLE DROP COLUMNS CONTINUE
Cause  An attempt was made to access a table with columns in partially dropped state (i.e., drop column operation was interrupted).
Action  Submit ALTER TABLE DROP COLUMNS CONTINUE to complete the drop column operation before accessing the table.

 

ORA-12987 ORA-12987: cannot combine drop column with other operations
Cause  An attempt was made to combine drop column with other ALTER TABLE operations.
Action  Ensure that drop column is the sole operation specified in ALTER TABLE.

 

ORA-12988 ORA-12988: cannot drop column from table owned by SYS
Cause  An attempt was made to drop a column from a system table.
Action  This action is not allowed

 

ORA-12989 ORA-12989: invalid value for checkpoint interval
Cause  An invalid checkpoint interval specified in statement. Checkpoint interval must be between 0 and (2^31-1).
Action  Correct checkpoint interval and resubmit statement

 

ORA-12990 ORA-12990: duplicate option specified
Cause  Duplicate option specified in statement.
Action  Remove the duplicate option and resubmit statement.

 

ORA-12991 ORA-12991: column is referenced in a multi-column constraint
Cause  An attempt was made to drop a column referenced by some constraints.
Action  Drop all constraints referencing the dropped column or specify CASCADE CONSTRAINTS in statement.

 

ORA-12992 ORA-12992: cannot drop parent key column
Cause  An attempt was made to drop a parent key column.
Action  Drop all constraints referencing the parent key column, or specify CASCADE CONSTRAINTS in statement.

 

ORA-12993 ORA-12993: tablespace "string" is offline, cannot drop column
Cause  An attempt was made to drop a column from a partition/subpartition on an offline tablespace.
Action  Bring the tablespace online and resubmit statement.

 

ORA-12994 ORA-12994: drop column option only allowed once in statement
Cause  An attempt was made to repeat the drop column option in a single statement.
Action  Separate drop column options into different statements and resubmit statements.

 

ORA-12995 ORA-12995: no columns in partially dropped state
Cause  An attempt was made to submit DROP COLUMNS CONTINUE statement while there are no partially dropped columns.
Action  Cannot submit this statement.

 

ORA-12996 ORA-12996: cannot drop system-generated virtual column
Cause  An attempt was made to drop a virtual column generated by the system.
Action  none

 

ORA-12997 ORA-12997: cannot drop primary key column from an index-organized table
Cause  An attempt was made to drop a primary key column from an index- organized table.
Action  This action is not allowed.

 

Partager cette page

Repost 0
Published by