Saturday 19 May 2012

ORA-30152: File does not exist

ORA-30152: File does not exist

Cause: The OCIFile function requires the file to exist, but it does not.

Action: Make sure that the file exists.

ORA-30151: File already exists

ORA-30151: File already exists

Cause: Tried to open a file with OCI_FILE_EXCL flag and the file already exists.

Action: OCIFile is supposed throw this exception in this case.

ORA-30150: Invalid argument passed to OCIFile function

ORA-30150: Invalid argument passed to OCIFile function

Cause: An invalid argument is passed to the OCIFile function. The most common cause is that a NULL pointer is passed where a non-NULL pointer is expected.

Action: Make sure that the values passed as arguments are valid. Esp check for NULL pointers.

ORA-30135: OCI Thread operation fails

ORA-30135: OCI Thread operation fails

Cause: An OCI Thread function call has failed.

Action: Check the function call to make sure that the correct parameters are being passed and take the apropriate action.

ORA-30134: reserved for future use

ORA-30134: reserved for future use

Cause: None.

Action: None.

ORA-30133: reserved for future use

ORA-30133: reserved for future use

Cause: None.

Action: None.

ORA-30132: invalid key index supplied

ORA-30132: invalid key index supplied

Cause: The key index specified was not within bounds

Action: Change key index to ensure it lies within bounds

ORA-30131: number of keys being set exceeds allocation

ORA-30131: number of keys being set exceeds allocation

Cause: Number of parameter keys being set exceeds allocation

Action: Reduce the number of keys being set or increase allocation

ORA-30130: invalid parameter key type received

ORA-30130: invalid parameter key type received

Cause: A function received an invalid parameter key type

Action: Check parameter key types in function calls

ORA-30129: invalid function argument received

ORA-30129: invalid function argument received

Cause: A function received an invalid argument

Action: Check function calls, make sure correct arguments are being passed.

ORA-30122: value string for string must be between number and number

ORA-30122: value string for string must be between number and number

Cause: The value of the parameter is not within the legal range.

Action: Specify a value that is within the legal range.

ORA-30121: string is not an allowable value for string

ORA-30121: string is not an allowable value for string

Cause: The value is not a legal value for this parameter.

Action: Refer to the manual for allowable values.

ORA-30120: string is not a legal oracle number for string

ORA-30120: string is not a legal oracle number for string

Cause: The value is not a valid oracle number.

Action: Refer to the manual for allowable oracle number values.

ORA-30119: unable to obtain a valid value for string

ORA-30119: unable to obtain a valid value for string

Cause: No valid value was obtained for this parameter.

Action: Rerun the application and enter a valid value.

ORA-30118: syntax error at string at the end of input

ORA-30118: syntax error at string at the end of input

Cause: A syntax error was detected.

Action: Change the input so that the correct syntax is used.

ORA-30117: syntax error at string at the start of input

ORA-30117: syntax error at string at the start of input

Cause: A syntax error was detected.

Action: Change the input so that the correct syntax is used.

ORA-30116: syntax error at string following string

ORA-30116: syntax error at string following string

Cause: A syntax error was detected.

Action: Change the input so that the correct syntax is used.

ORA-30115: error when processing an environment variable

ORA-30115: error when processing an environment variable

Cause: A problem occurred when processing an environment variable.

Action: Examine the additional error messages and correct the problem.

ORA-30114: error when processing from command line

ORA-30114: error when processing from command line

Cause: A problem occurred when processing the command line.

Action: Examine the additional error messages and correct the problem.

ORA-30113: error when processing file string

ORA-30113: error when processing file string

Cause: A problem occurred when processing this file.

Action: Examine the additional error messages and correct the problem.

ORA-30112: multiple values not allowed for parameter string

ORA-30112: multiple values not allowed for parameter string

Cause: You attempted to specify multiple values for a parameter which can take only one value.

Action: Do not specify more than one value for this parameter.

ORA-30111: no closing quote for value string

ORA-30111: no closing quote for value string

Cause: A quoted string was begun but not finished.

Action: Put a closing quote in the proper location.

ORA-30110: syntax error at string

ORA-30110: syntax error at string

Cause: A syntax error was detected.

Action: Change the input so that the correct syntax is used.

ORA-30109: could not open parameter file string

ORA-30109: could not open parameter file string

Cause: The parameter file does not exist.

Action: Create an appropriate parameter file.

ORA-30108: invalid positional parameter value string

ORA-30108: invalid positional parameter value string

Cause: An invalid positional parameter value has been entered.

Action: Remove the invalid positional parameter.

ORA-30107: parameter name abbreviation string is not unique

ORA-30107: parameter name abbreviation string is not unique

Cause: The abbreviation given was not unique.

Action: Use a longer abbreviation to make the parameter name unique.

ORA-30106: reserved for future use

ORA-30106: reserved for future use

Cause: None.

Action: None.

ORA-30105: string is not a legal boolean for string

ORA-30105: string is not a legal boolean for string

Cause: The value is not a valid boolean.

Action: Refer to the manual for allowable boolean values.

ORA-30104: string is not a legal integer for string

ORA-30104: string is not a legal integer for string

Cause: The value is not a valid integer.

Action: Specify only valid integers for this parameter.

ORA-30103: string contains an illegal integer radix for string

ORA-30103: string contains an illegal integer radix for string

Cause: An illegal integer radix specification was found.

Action: Only d , h , D , and H may be used as radix specifications.

ORA-30102: string is not in the legal range for string

ORA-30102: string is not in the legal range for string

Cause: The value of the parameter is not within the legal range.

Action: Refer to the manual for the allowable values for this parameter.

ORA-30101: unknown parameter name string

ORA-30101: unknown parameter name string

Cause: You have misspelled the parameter name.

Action: Spell the parameter name correctly.

ORA-30100: internal error (number(

ORA-30100: internal error (number(

Cause: An internal error has occurred.

Action: Contact Oracle Worldwide Support and report the error.

ORA-30089: missing or invalid lamp;lt;lamp;nbsp;datetime fieldlamp;gt;

ORA-30089: missing or invalid lamp;lt;lamp;nbsp;datetime fieldlamp;gt;

Cause: A lamp;lt;lamp;nbsp;datetime fieldlamp;gt; (YEAR, MONTH, DAY, HOUR, MINUTE, SECOND) is expected but not found, or a lamp;lt;lamp;nbsp;datetime fieldlamp;gt; specified the lamp;lt;lamp;nbsp;end fieldlamp;gt; in an lamp;lt;lamp;nbsp;interval qualifierlamp;gt; is more significant than its lamp;lt;lamp;nbsp;start fieldlamp;gt;.

Action: none

ORA-30088: datetime or interval precision is out of range

ORA-30088: datetime or interval precision is out of range

Cause: The specified datetime or interval precision was not between 0 and 9.

Action: Use a value between 0 and 9 for datetime or interval precision.

ORA-30087: Adding two datetime values is not allowed

ORA-30087: Adding two datetime values is not allowed

Cause: An attempt was made to add two datetime values.

Action: This addition is not allowed.

ORA-30086: interval year-month result not allowed for datetime subtraction

ORA-30086: interval year-month result not allowed for datetime subtraction

Cause: An attempt was made to specify interval year to month as the result of datetime subtraction.

Action: This is not allowed currently due to unclear specification in SQL Standards for this interval type. Change the interval type to interval day to second and resubmit statement.

ORA-30085: syntax error was found in overlaps predicate

ORA-30085: syntax error was found in overlaps predicate

Cause: A syntax error was found during parsing an overlaps predicate.

Action: Correct the syntax.

ORA-30084: invalid data type for datetime primary with time zone modifier

ORA-30084: invalid data type for datetime primary with time zone modifier

Cause: When a time zone modifier is specified, the data type of datetime primary must be one of the following: TIME, TIME WITH TIME ZONE, TIMESTAMP, TIMESTAMP WITH TIME ZONE.

Action: none

ORA-30083: syntax error was found in interval value expression

ORA-30083: syntax error was found in interval value expression

Cause: A syntax error was found during parsing an interval value value expression.

Action: Correct the syntax.

ORA-30082: datetime or interval column to be modified must be empty to decrease fractional second or leading field precision

ORA-30082: datetime or interval column to be modified must be empty to decrease fractional second or leading field precision

Cause: datetime or interval column with existing data is being modified to decrease fractional second or leading field precisions.

Action: Such columns are only allowed to increase the precisions.

ORA-30081: invalid data type for datetime or interval arithmetic

ORA-30081: invalid data type for datetime or interval arithmetic

Cause: The data types of the operands are not valid for datetime or interval arithmetic.

Action: none

ORA-30079: cannot alter database timezone when database has TIMESTAMP WITH LOCAL TIME ZONE columns

ORA-30079: cannot alter database timezone when database has TIMESTAMP WITH LOCAL TIME ZONE columns

Cause: An attempt was made to alter database timezone with TIMESTAMP WITH LOCAL TIME ZONE column in the database.

Action: Either do not alter database timezone or first drop all the TIMESTAMP WITH LOCAL TIME ZONE columns.

ORA-30078: partition bound must be TIME or TIMESTAMP WITH TIME ZONE literals

ORA-30078: partition bound must be TIME or TIMESTAMP WITH TIME ZONE literals

Cause: An attempt was made to use a time or timestamp expression whose format does not explicitly have time zone on a TIME or TIMESTAMP or TIME or TIMESTAMP WITH TIME ZONE column.

Action: Explicitly use TIME or TIMESTAMP WITH TIME ZONE literal.

ORA-30077: illegal casting between specified datetime types

ORA-30077: illegal casting between specified datetime types

Cause: Cannot cast between the specified datetime types.

Action: none

ORA-30076: invalid extract field for extract source

ORA-30076: invalid extract field for extract source

Cause: The extract source does not contain the specified extract field.

Action: none

ORA-30075: TIME or TIMESTAMP WITH TIME ZONE literal must be specified in CHECK constraint

ORA-30075: TIME or TIMESTAMP WITH TIME ZONE literal must be specified in CHECK constraint

Cause: User is trying to create a constraint on a time or timestamp with or without time zone column without explicitly specifying the time zone.

Action: Use time or timestamp with time zone literals only.

ORA-30074: GLOBAL partitioned index on TIME or TIMESTAMP WITH TIME ZONE not allowed

ORA-30074: GLOBAL partitioned index on TIME or TIMESTAMP WITH TIME ZONE not allowed

Cause: try to GLOBAL partitioned index on TIME or TIMESTAMP WITH TIME ZONE.

Action: Do not GLOBAL partitioned index on TIME or TIMESTAMP WITH TIME ZONE.

ORA-30073: invalid adjustment value

ORA-30073: invalid adjustment value

Cause: The value is none of the followings: ADJUST , NO_ADJUST , ANSI_ DATE , ADJUST_WITH_ANSI_DATE . NO_ADJUST is the default value.

Action: set it to one of the three values

ORA-30072: invalid time zone value

ORA-30072: invalid time zone value

Cause: The value specified for the time zone string, which appears in ALTER SESSION statement, environment variable ORA_SDTZ, or a datetime factor, is not valid.

Action: none

ORA-30071: conversion between datetime or interval and string fail

ORA-30071: conversion between datetime or interval and string fail

Cause: An error occurs during a conversion between datetime or interval and string data type due to one of the following reasons:

Action: none

ORA-30069: Auto Undo-Management Error simulation - test site = string

ORA-30069: Auto Undo-Management Error simulation - test site = string

Cause: test events for internal use only.

Action: none.

ORA-30068: Internal Event to turn on nested

ORA-30068: Internal Event to turn on nested

Cause: none

Action: none.

ORA-30067: Internal Event to turn on nested debugging info

ORA-30067: Internal Event to turn on nested debugging info

Cause: none

Action: none.

ORA-30066: test support - drop rollback segment wait

ORA-30066: test support - drop rollback segment wait

Cause: internal use only

Action: none.

ORA-30065: test support for row dependencies

ORA-30065: test support for row dependencies

Cause: internal use only

Action: none.

ORA-30064: Test support for two phase read only optimization

ORA-30064: Test support for two phase read only optimization

Cause: internal use only

Action: none.

ORA-30063: Internal Event to Test NTP

ORA-30063: Internal Event to Test NTP

Cause: none

Action: none

ORA-30062: Test support for ktulat latch recovery

ORA-30062: Test support for ktulat latch recovery

Cause: internal use only

Action: none.

ORA-30061: Internal Event for Savepoint Tracing

ORA-30061: Internal Event for Savepoint Tracing

Cause: internal use only

Action: none