现在的位置: 首页 > 综合 > 正文

oracle errorORA-01409 —ORA-01500

2013年08月26日 ⁄ 综合 ⁄ 共 6990字 ⁄ 字号 小 中 大 ⁄ 评论关闭
ORA-01409: NOSORT option may not be used; rows are not in ascending order
Cause:
Creation of index with
NOSORT option when rows were not ascending. For non-unique indexes the
rowid is considered part of the index key. Therefore, if you create an
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 the
dba of the first block in the second extent is less than the dba of the
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 64K and couldn't store the length of the column in the
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 many 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 to
modify the datatype of column which has referential constraints; or has
check constraints which only allows changing the datatype from CHAR to
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 performing an array bind with a bind variable whose maximum size is greater than 2000 bytes.
Action:
Such bind variables cannot participate 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 to
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 of
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 the
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 performed

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 performed

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
返回
【上篇】
【下篇】

作者:

抱歉!评论已关闭.

返回首页

Copyright © 2013-2018 学步园  保留所有权利.
软文销售 QQ客服：2265327166 点击这里给我发消息（其他合作也可洽谈）
必威体育
必威电竞