Oracle errorORA-01409-ORA-01500

Source: Internet
Author: User
Tags table definition
ORA-01409: nosort option may not be used; rows are not in ascending order
Cause:
Creation of index
Nosort option when rows were not ascending. For non-unique indexes
Rowid is considered part of the index key. Therefore, if you create
Index nosort and two of the rows in the table have the same key and are
Stored in ascending order, but get split accross two extents where
DBA of the first block in the second extent is less than the DBA of
Last block in the first extent, then the create index nosort may fail.
Action:
Create the index without the nosort option, or ensure table is stored in one extent.

ORA-01411: cannot store the length of column in the indicator

Cause:
Tried to fetch a column
Of size more than 64 K and couldn't store the length of the column in
Given indicator of size 2 bytes.
Action:
Use the new bind type with call backs to fetch the long column.

ORA-01412: zero length not allowed for this datatype

Cause:
The length for Type 97 is 0
Action:
Specify the correct length.

ORA-01413: Illegal value in packed decimal number Buffer

Cause:
The user buffer bound by the user as packed decimal number contained an illegal value.
Action:
Use a legal value.

ORA-01414: Invalid array length when trying to bind Array

Cause:
An attempt was made to bind an array without either a current array length pointer or a zero maximum array length.
Action:
Sepcify a valid length.

ORA-01415: Too functions distinct Aggregate functions

Cause:
The query contains more distinct aggregates than can be processed. The current limit is 255.
Action:
Reduce the number of distinct Aggregate functions in the query.

ORA-01417: A table may be outer joined to at most one other table

Cause:
A. B (+) = B. B and A. C (+) = C. C is not allowed
Action:
Check that this is really what you want, then join B and C first in a view.

ORA-01422: exact fetch returns more than requested number of rows

Cause:
The number specified in exact fetch is less than the rows returned.
Action:
Rewrite the query or change number of rows requested

ORA-01424: Missing or illegal character following the Escape Character

Cause:
The character following the Escape Character in like pattern is missing or not one of the escape character, '%', or '_'.
Action:
Remove the escape character or specify the missing character.

ORA-01425: escape character must be character string of length 1

Cause:
Given escape character for LIKE is not a character string of length 1.
Action:
Change it to a character string of length 1.

ORA-01426: Numeric Overflow

Cause:
Evaluation of an value expression causes an overflow/underflow.
Action:
Reduce the operands.

ORA-01429: Index-organized table: No data segment to store overflow row-pieces

Cause:
No overflow segment defined.
Action:
Add overflow segment.

ORA-01451: column to be modified to null cannot be modified to null

Cause:
The column may already allow NULL values, the not null constraint is part of a primary key or check constraint.
Action:
If a primary key or check constraint is enforcing the not null constraint, then drop that constraint.

ORA-01453: Set transaction must be first statement of transaction

Cause:
Self-evident
Action:
Commit (or rollback) transaction, and re-execute

ORA-01456: may not perform insert/delete/update operation inside a read only transaction

Cause:
A non-DDL insert/delete/update or select for update operation was attempted
Action:
Commit (or rollback) transaction, and re-execute

ORA-01463: cannot modify column datatype with current constraint (s)

Cause:
An attempt was made
Modify the datatype of column which has referential constraints; or has
Check constraints which only allows changing the datatype from Char
Varchar or vise versa.
Action:
Remove the constraint (s) or do not perform the offending operation.

ORA-01466: unable to read data-table definition has changed

Cause:
Query parsed after TBL (or index) change, and executed w/old snapshot
Action:
Commit (or rollback) transaction, and re-Execute

ORA-01469: Prior can only be followed by a column name

Cause:
Attempting to specify "prior <something>" where <something> is not a column name.
Action:
Only a column name can follow prior. replace with a column name.

ORA-01470: In-list iteration does not support mixed Operators

Cause:
Constants of different types are specified in an in-list.
Action:
Use constants of same type for In-lists.

ORA-01478: array BIND may not include any long columns

Cause:
User is refreshing Ming an array bind with a bind variable whose maximum size is greater than 2000 bytes.
Action:
Such bind variables cannot participant in array binds. Use an ordinary bind operation instead.

ORA-01479: Last character in the buffer is not null

Cause:
A Bind Variable of Type 97 does not contain null at the last position
Action:
Make the last character null

ORA-01480: trailing null missing from STR bind Value

Cause:
A Bind Variable of type 5 (null-terminated string) does not contain the terminating null in its buffer.
Action:
Terminate the string with a NULL Character

ORA-01481: Invalid Number Format Model

Cause:
The user is attempting
Either convert a number to a string via to_char or a string to a number
Via to_number and has supplied an invalid number format Model
Parameter.
Action:
Consult your manual.

ORA-01482: Unsupported Character Set

Cause:
The character set used to perform the operation, such as the convert function, is not a supported character set.
Action:
Use one of the supported character sets.

ORA-01483: Invalid Length for date or number Bind Variable

Cause:
A Bind Variable of type date or number is too long.
Action:
Consult your manual for the maximum allowable length.

ORA-01484: Arrays can only be bound to PL/SQL statements

Cause:
You tried to bind an array to a non-PL/SQL statement.
Action:
None

ORA-01485: Compile bind length different from execute bind Length

Cause:
You bound a buffer
Type dtyvcs (varchar with the two byte length in front) and at Execute
Time the length in the first two bytes is more than the maximum Buffer
Length (given in the bind Call). The number of elements in the array and
The current number of elements in the array cannot be more than
Maximum size of the array.
Action:
None

ORA-01486: size of array element is too large

Cause:
You tried to bind a data
Value which was either too large for the datatype (for example, number)
Or was greater than 4000 bytes (for example, varchar or long ).
Action:
None

ORA-01487: packed decimal number too large for supplied Buffer

Cause:
An impossible request for decimal to Oracle number conversion was made
Action:
This conversion cannot be saved med

ORA-01488: Invalid nibble or byte in the input data

Cause:
An impossible request for decimal to oracle number conversion was made
Action:
This conversion cannot be saved med

ORA-01489: Result of String concatenation is too long

Cause:
String concatenation result is more than the maximum size.
Action:
Make sure that the result is less than the maximum size.

ORA-01490: Invalid analyze command

Cause:
Incorrect syntax specified
Action:
Retry the command

ORA-01491: cascade option not valid

Cause:
The CASCADE option is only valid for tables or clusters.
Action:
Do not specify CASCADE

ORA-01492: List Option not valid

Cause:
The LIST option is only valid for tables or clusters.
Action:
Do not specify LIST

ORA-01493: Invalid sample size specified

Cause:
The specified SAMPLE size is out of range
Action:
Specify a value within the proper range.

ORA-01494: Invalid size specified

Cause:
The specified histogram SIZE value was out of range.
Action:
Specify a value within the proper range.

ORA-01495: specified chain row table not found

Cause:
The specified table either does not exist or user does not have the proper privleges.
Action:
Specify the correct table to use.

ORA-01496: specified chain row table form incorrect

Cause:
The specified table does not have the proper field definitions.
Action:
Specify the correct table to use.

ORA-01497: Illegal option for analyze Cluster

Cause:
The for columns <column-List> clause may not be used with analyze cluster.
Action:
Retry with a legal syntax.
ORA-01500: Failure in getting date/time
Cause:
During create database or alter tablespace, there was a failure in getting the date and time.
Action:
Contact your customer support representative. Link: http://www.docfans.net /? P = 459
Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.