{"id":1921,"date":"2016-04-24T10:10:51","date_gmt":"2016-04-24T07:10:51","guid":{"rendered":"http:\/\/www.fatihacar.com\/blog\/?p=1921"},"modified":"2016-10-26T10:12:12","modified_gmt":"2016-10-26T07:12:12","slug":"oracle-11g-error-codes-and-solution-suggestions-from-ora-14700-to-ora-15000","status":"publish","type":"post","link":"http:\/\/www.fatihacar.com\/blog\/oracle-11g-error-codes-and-solution-suggestions-from-ora-14700-to-ora-15000\/","title":{"rendered":"Oracle 11g Error Codes and Solution Suggestions from ORA-14700 to ORA-15000"},"content":{"rendered":"

Oracle 11g Error Codes and Solution Suggestions from ORA-14700 to ORA-15000<\/strong><\/p>\n

\n
ORA-14700: Object(s) owned by SYS cannot be locked by non-SYS user<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Attempt to issue a LOCK TABLE statement on SYS owned object(s) by a non-SYS user, user should minimally have DML privileges<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Re-issue LOCK TABLE statement for non-SYS user after granting DML privileges on object, or non-SYS user should connect as SYS<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14701: partition-extended name or bind variable must be used for DMLs on tables partitioned by the System method<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0User attempted not to use partition-extended syntax for a table partitioned by the System method<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Must use of partition-extended syntax in contexts mentioned above.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14702: The partition number is invalid or out-of-range<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Attempted to use nonnumerical value or the number was out of range of the partitions.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Use a valid partition number.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14703: The AFTER clause can be used to ADD PARTITION only to a System Partitioned table.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The table is not partitioned by the System method<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Skip the AFTER clause.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14704: Create table as select disallowed for SYSTEM patitioned tables<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0User attempted to create a SYSTEM partitioned table by doing a create table as select.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Do a create table followed by an insert as select into each partition.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14750: Range partitioned table with INTERVAL clause has more than one column<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0You attempted to create an interval partitioned table with more than one partitioning column.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Use a single partitioning column.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14751: Invalid data type for partitioning column of an interval partitioned table<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0You attempted to use interval partitioning on a table partitioned on a column of data type other than number or date\/time.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Use only number or date\/time columns as partitioning columns for interval partitioned tables.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14752: Interval expression is not a constant of the correct type<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0You attempted to use either a nonconstant interval or an interval whose data type does not correspond to the partitioning column<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Use only constant expressions for the interval. If the data type of partitioning column is numeric, the interval must be a numeric constant. If the data type is of type date\/time, the interval must be a constant of interval type<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14753: Interval cannot be zero<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The interval mapped to zero.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0You must use a nonzero interval.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14754: Interval string is too long<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The interval string was too long<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Specify interval using a shorter string<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14755: Invalid partition specification for FOR VALUES clause.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The [SUB]PARTITION FOR VALUES (…) clause can only take constants. In addition it takes as many arguments as there are partitioning columns and the values must be coercible to the partitioning columns.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Specify a valid FOR VALUES clause.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14756: Table is not partitioned by Interval method.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The table was not partitioned by Interval method.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0ALTER TABLE SET STORE IN is only valid for Interval partitioned tables. Ensure that the table by Interval.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14757: Table is already a range partitioned table<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0SET INTERVAL () is used to convert an interval partitioned table to a range partitioned table. It is not legal on a range partitioned table<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Use SET INTERVAL () only on an interval partitioned table.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14758: Last partition in the range section cannot be dropped<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt was made to drop the last range partition of an interval partitioned table.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Do not attempt to drop this partition.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14759: SET INTERVAL is not legal on this table.<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0SET INTERVAL clause was specified. ALTER TABLE SET INTERVAL is only legal on a range partitioned table with a single partitioning column. Additionally, this table cannot have a maxvalue partition and cannot be the parent table for any reference partitioned tables.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Use SET INTERVAL only on a valid table.<\/span><\/span><\/span><\/dd>\n

<\/p>\n

<\/a><\/a>ORA-14760: ADD PARTITION is not permitted on Interval partitioned objects<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0ALTER TABLE ADD PARTITION was attempted on an Interval partitioned object.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Do not perform the operation on an Interval partitioned object. Insert a row to create the new partition.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14761: MAXVALUE partition cannot be specified for Interval partitioned objects<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt was made to create a partition with a MAXVALUE highbound on an Interval partitioned object.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Do not create a partition with a MAXVALUE highbound.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14762: Domain index creation on interval partitioned tables is not permitted<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt was made to create a domain index on an interval partitioned table.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Do not create a domain index on an interval partitioned table.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14763: Unable to resolve FOR VALUES clause to a partition number<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0Could not determine the partition corresponding to the FOR VALUES clause.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Remove bind variables and dependencies on session parameters from the values specified in the FOR VALUES clause.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14764: FOR VALUES clause cannot be specified for only one partition<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt was made to specify the FOR VALUES clause for only one of the two partitions being merged.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Specify a FOR VALUES clause for each of the two partitions being merged or do not specify the FOR VALUES clause for either.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14765: Cannot create a partition while doing a create index<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt was made to create a partition concurrently with index creation.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Retry the statement after the index build is finished.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14766: Unable to obtain a stable metadata snapshot<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0This operation was not able to obtain a stable snapshot of the interval partitioning metadata.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Retry the statement.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14767: Cannot specify this interval with existing high bounds<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The interval specified conflicts with the existing high bound for the last partition. The combination might lead to invalid dates for high bounds in the future.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0If this is a CREATE TABLE, try specifying a different high bound value for the last partition, or a different interval. If this is an ALTER TABLE SET INTERVAL, please choose either a different interval, or, modify the table to change the high bound for the last partition.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14801: Hash composite partitioning is not supported<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An attempt was made to partition a table using a Hash composite method.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Do not partition the table by a Hash composite method.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14802: Specified operation is not permitted on Hash composite partitioned objects<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0An unsupported operation was attempted on a Hash composite partitioned object.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Do not perform the operation on a Hash composite partitioned object.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-14803: partition bound may not be specified for hash subpartitioned tables<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0A VALUES LESS THAN or VALUES clause was specified with a subpartition description.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Remove the VALUES LESS THAN or VALUES clause from the subpartition description.<\/span><\/span><\/span><\/dd>\n
<\/a><\/a>ORA-15000: command disallowed by current instance type<\/span><\/b><\/span><\/span><\/dt>\n
Cause:<\/b>\u00a0The user has issued a command to a conventional RDBMS instance that is only appropriate for an ASM instance. Alternatively, the user has issued a command to an ASM instance that is only appropriate for an RDBMS instance.<\/span><\/span><\/span><\/dd>\n
Action:<\/b>\u00a0Connect to the correct instance type and re-issue the command.<\/span><\/span><\/span><\/dd>\n
<\/dd>\n<\/dl>\n","protected":false},"excerpt":{"rendered":"

Oracle 11g Error Codes and Solution Suggestions from ORA-14700 to ORA-15000 ORA-14700: Object(s) owned by SYS cannot be locked by non-SYS user Cause:\u00a0Attempt to issue a LOCK TABLE statement on SYS owned object(s) by a non-SYS user, user should minimally have DML privileges Action:\u00a0Re-issue LOCK TABLE statement for non-SYS user after granting DML privileges on…<\/p>\n","protected":false},"author":37,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[53],"tags":[14,32,54],"class_list":["post-1921","post","type-post","status-publish","format-standard","hentry","category-oracle-errors-and-solutions","tag-database-administration","tag-oracle-administration","tag-oracle-error-solutions"],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p39NFI-uZ","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/1921","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/users\/37"}],"replies":[{"embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/comments?post=1921"}],"version-history":[{"count":1,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/1921\/revisions"}],"predecessor-version":[{"id":1922,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/1921\/revisions\/1922"}],"wp:attachment":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/media?parent=1921"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/categories?post=1921"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/tags?post=1921"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}