Oracle Database Errors or Warnings from Error ORA-14658 to ORA-14703

SQLServerF1

ORA-14658: specified dependent table is not affected by this operation
Cause: A table has been specified in the DEPENDENT TABLES clause that is not a reference-partitioned table affected by the operation.
Action: Correct the statement and reenter.
ORA-14659: Partitioning method of the parent table is not supported
Cause: An attempt was made to create a reference-partitioned table with an interval partitioned parent table.
Action: Do not create a reference-partitioned table with an interval partitioned parent table.
ORA-14660: parent table of a reference-partitioned table cannot be index-organized
Cause: Attempted to create a reference-partitioned table with a index-organized parent table.
Action: Correct the statement and reenter.

ORA-14661: row movement must be enabled
Cause: Attempted to disable row movement for a reference-partitioned table, although row movement was enabled for its parent table.
Action: Disable row movement for parent table before disabling row movement for the reference-partitioned table.
ORA-14662: row movement cannot be enabled
Cause: Attempted to enable row movement for a partitioned table, although row movement was disabled for a reference-partitioned child table.
Action: Enable row movement for reference-partitioned child tables before enabling row movement for the parent table.
ORA-14663: reference partitioning parent key is not supported
Cause: Parent key of the reference-partitioned table’s partitioning constraint contained virtual columns.
Action: Correct the statement to specify a partitioning constraint with supported parent key and reenter.

ORA-14700: Object(s) owned by SYS cannot be locked by non-SYS user
Cause: Attempt to issue a LOCK TABLE statement on SYS owned object(s) by a non-SYS user, user should minimally have DML privileges
Action: Re-issue LOCK TABLE statement for non-SYS user after granting DML privileges on object, or non-SYS user should connect as SYS
ORA-14701: partition-extended name or bind variable must be used for DMLs on tables partitioned by the System method
Cause: User attempted not to use partition-extended syntax for a table partitioned by the System method
Action: Must use of partition-extended syntax in contexts mentioned above.
ORA-14702: The partition number is invalid or out-of-range
Cause: Attempted to use nonnumerical value or the number was out of range of the partitions.
Action: Use a valid partition number.
ORA-14703: The AFTER clause can be used to ADD PARTITION only to a System Partitioned table.
Cause: The table is not partitioned by the System method
Action: Skip the AFTER clause.

Above are list of Oracle Database Errors or Warnings from Error ORA-14658 to ORA-14703 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.

Thanks,
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 *