Oracle Database Errors or Warnings from Error ORA-25158 to ORA-25184


ORA-25158: Cannot specify RELY for foreign key if the associated primary key is NORELY
Cause: RELY is specified for the foreign key contraint, when the associated primary key constraint is NORELY.
Action: Change the option of the primary key also to RELY.
ORA-25175: no PRIMARY KEY constraint found
Cause: A PRIMARY KEY constraint must be defined for a table with this organization
Action: Define a PRIMARY KEY
ORA-25176: storage specification not permitted for primary key
Cause: Storage parameters cannot be defined for a PRIMARY KEY constraint for a table with this organization
Action: Remove storage specification for primary key

ORA-25177: UNRECOVERABLE option not permitted
Cause: The UNRECOVERABLE option may not be specified for a primary key for a table with this organization
Action: Remove UNRECOVERABLE option for primary key
ORA-25178: duplicate PCTTHRESHOLD storage option specification
Cause: The storage option PCTTHRESHOLD is specified more than once.
Action: Specify storage options at most once.
ORA-25179: invalid PCTTHRESHOLD storage option value
Cause: The specified value must be a positive integer.
Action: Specify an appropriate value.

ORA-25180: PCTTHRESHOLD only valid for certain table organizations
Cause: PCTTHRESHOLD can only be specified for tables with certain organizations.
Action: Remove the PCTTHRESHOLD option.
ORA-25181: missing ON keyword for NESTED INDEX
Cause: ON keyword required to specify nested index column nest
Action: Add ON keyword
ORA-25182: feature not currently available for index-organized tables
Cause: An attempt was made to use one or more of the following feature(s) not currently supported for index-organized tables: CREATE TABLE with LOB/BFILE/VARRAY columns, partitioning/PARALLEL/CREATE TABLE AS SELECT options, ALTER TABLE with ADD/MODIFY column options, CREATE INDEX
Action: Do not use the disallowed feature(s) in this release.
ORA-25183: index-organized table top index segment is in a different tablespace
Cause: An attempt was made to drop a tablespace which contains an index only table’s overflow segment but not the top index segment”
Action: find index-organized tables which span the tablespace being dropped and some other tablespace(s). Drop these tables.
ORA-25184: column name expected
Cause: A column name is not present where required by the CREATE TABLE for specifying last column to be included in the index segment of the index-organized table
Action: Specify a column name where required by the syntax.

Above are list of Oracle Database Errors or Warnings from Error ORA-25158 to ORA-25184 received while performing certain operation against Oracle Database or related products.

What are Oracle Database Error Messages?

Oracle Error Messages may be returned while using products which are part of Oracle Database. Each Oracle Database Error or Warning Message mentioned above contains the Warning or Error Message Statement, a short explanation of the probable causes of the Error message, and a recommended action.

Hope this was helpful.

SQLServerF1 Team
Information about Oracle Database Error Messages or Warning Messages on Windows and Linux Operating Systems.


Leave a Reply

Your email address will not be published. Required fields are marked *