Oracle Database Error Codes

Tuesday, August 09, 2022

ORA-00066 LOG_FILES is string but needs

Posted on Tuesday, August 09, 2022 by admin with No comments

Oracle Database Error Code Messages ORA-00066 Description Help About;LOG_FILES is string but needs to be string to be compatible. Error Cause;The maximum number of log files supported by this instance is not the same as for the other instances....

ORA-28654 table and partition not

Posted on Tuesday, August 09, 2022 by admin with No comments

Oracle Database Error Code Messages ORA-28654 Description Help About;Table and partition not overflow compatible. Error Cause; If one of the tables (partitioned/non-partitioned) has overflow data segment and the other one does...

ORA-00065 initialization of FIXED_DATE

Posted on Tuesday, August 09, 2022 by admin with No comments

ORA-00065 initialization of FIXED_DATE Oracle Database Error Code Messages ORA-00065 Description Help About;Initialization of FIXED_DATE failed. Error Cause for Problem;The FIXED_DATE string was not in date format yyyy-mm-dd:hh24:mi:ss. ...

ORA-28655 Alter table add overflow

Posted on Monday, August 08, 2022 by admin with No comments

Oracle Database Error Code Messages ORA-28655 Description Help About;Alter table add overflow syntax error. Error Cause;Syntax error. How to Solve ORA-28655 Alter table add overflow syntax error? Action...

ORA-00064 object is too large to

Posted on Monday, August 08, 2022 by admin with No comments

Oracle Database Error Code Messages ORA-00064 Description Help About;Object is too large to allocate on this O/S (string,string). Error Cause;An initialization parameter was set to a value that required allocating more contiguous space than...

ORA-28656 incomplete attribute

Posted on Monday, August 08, 2022 by admin with No comments

Oracle Database Error Code Messages ORA-28656 Description Help About;Incomplete attribute specification. Error Cause;The attribute specification is not done for all partitions. How to Solve ORA-28656? Action for...

ORA-00063 maximum number of LOG_FILES

Posted on Monday, August 08, 2022 by admin with No comments

Oracle Database Error Code Messages ORA-00063 Description Help About;Maximum number of LOG_FILES exceeded. Error Cause;The value of the LOG_FILES initialization parameter was exceeded. How to Solve ORA-00063 maximum number...

ORA-28658 This operation is supported

Posted on Sunday, August 07, 2022 by admin with No comments

Oracle Database Error Code Messages ORA-28658 Description Help About;This operation is supported only for Index-Organized tables. Error Cause;Attempt to perform some IOT specific operation on a non-IOT. This is not supported. ...

ORA-00062 DML full-table lock cannot be

Posted on Sunday, August 07, 2022 by admin with No comments

Oracle Database Error Code Messages ORA-00062 Description About Help;DML full-table lock cannot be acquired; DML_LOCKS is 0 Error Cause;The instance was started with the value of DML_LOCKS set to zero, and the statement being executed needs...

ORA-28659 COMPRESS must be specified at

Posted on Sunday, August 07, 2022 by admin with No comments

Oracle Database Error Code Messages ORA-28659 Description About Help;COMPRESS must be specified at object level first. Error Cause;An attempt was made to specify COMPRESS at the partition level without first specifying it at the table level. ...

ORA-00061 another instance has

Posted on Sunday, August 07, 2022 by admin with 1 comment

Oracle Database Error Code Messages ORA-00061 Description About Help;Another instance has a different DML_LOCKS setting. Error Cause;The shared instance being started is using DML locks, and the running instances are not, or vice-versa. ...

ORA-28660-Partitioned Index-Organized

Posted on Sunday, August 07, 2022 by admin with No comments

Oracle Database Error Code Messages ORA-28660 Description Help About;Partitioned Index-Organized table may not be MOVEd as a whole. Error Cause;An attempt was made to MOVE a partitioned index-organized table as a whole. This is not supported. ...

ORA-00060 deadlock detected while

Posted on Saturday, August 06, 2022 by admin with No comments

Oracle Database Error Code Messages ORA-00060 Description Help About;Deadlock detected while waiting for resource. Error Cause;Your session and another session are waiting for a resource locked by the other. This condition is known as a...

ORA-28661-Object already has COMPRESS

Posted on Saturday, August 06, 2022 by admin with No comments

Oracle Database Error Code Messages ORA-28661 Description;Object already has COMPRESS clause specified. Error Cause;An attempt was made to specify COMPRESS for an index-organized table/index which already has a compression clause. This attribute...

ORA-00059 maximum number of DB_FILES

Posted on Saturday, August 06, 2022 by admin with No comments

Oracle Database Error Code Messages ORA-00059 Description;Maximum number of DB_FILES exceeded. Error Cause;The value of the DB_FILES initialization parameter was exceeded. How to Solve ORA-00059 Maximum number of DB_FILES...

ORA-28662 IOT index and overflow

Posted on Friday, August 05, 2022 by admin with No comments

Oracle Database Error Code Messages ORA-28662 Description;IOT index and overflow segments must share the same LOGGING attribute. Error Casuse;An attempt was made to specify LOGGING for one segment and NOLOGGING for the other segment. ...

ORA-00058 DB_BLOCK_SIZE must be string to

Posted on Thursday, August 04, 2022 by admin with 1 comment

Oracle Database Error Code Messages ORA-00058 Description;DB_BLOCK_SIZE must be string to mount this database (not string). Error Cause;The value of the DB_BLOCK_SIZE initialization parameter used to start this database does not match the...

ORA-28663 Logging/Nologging attribute

Posted on Thursday, August 04, 2022 by admin with 1 comment

Oracle Database Error Code Messages ORA-28663 Description;Logging/Nologging attribute can not be specified in the statement ALTER TABLE ADD OVERFLOW. Error Cause;An attempt was made to specify LOGGING for an ALTER TABLE ADD OVERFLOW statement.How...

ORA-00057 maximum number of temporary

Posted on Wednesday, August 03, 2022 by admin with No comments

Oracle Database Error Code Messages ORA-00057 Description;Maximum number of temporary table locks exceeded. Error Cause;The number of temporary tables equals or exceeds the number of temporary table locks. Temporary tables are often created...

ORA-28664 a partitioned table may not be

Posted on Wednesday, August 03, 2022 by admin with No comments

Oracle Database Error Code Messages ORA-28664 Description; A partitioned table may not be coalesced as a whole. Error Cause;User attempted to coalesce a partitioned IOT using ALTER TABLE COALESCE statement, which is illegal. ...

ORA-00056 DDL lock on object

Posted on Wednesday, August 03, 2022 by admin with No comments

Oracle Database Error Code Messages ORA-00056 Descriptions;DDL lock on object 'string.string' is already held in an incompatible mode Error Cause;The attempted lock is incompatible with the DDL lock already held on the object. This happens...

ORA-28665 table and partition must have

Posted on Wednesday, August 03, 2022 by admin with No comments

Oracle Database Error Code Messages ORA-28665 Descriptions;Table and partition must have same compression attribute. Error Cause;User attempted to EXCHANGE a compression enabled partition with a compression disabled table or vice versa OR...