Oracle Database Errors or Warnings from Error ORA-14044 to ORA-14053

SQLServerF1

ORA-14044: only one partition may be moved
Cause: ALTER TABLE MOVE PARTITION contained descriptions of more than one partition to be moved
Action: Ensure that the statement describes exactly one partition to be moved and that it does not contain any commas
ORA-14045: only one partition may be modified
Cause: ALTER TABLE|INDEX MODIFY PARTITION contained descriptions of more than one partition to be modified
Action: Ensure that the statement describes exactly one partition to be modified and that it does not contain any commas
ORA-14046: a partition may be split into exactly two new partitions
Cause: ALTER TABLE|INDEX SPLIT PARTITION did not contain descriptions of exactly two new partitions into which an existing table or index partition was to be split
Action: Ensure that the statement describes exactly two partition into which an existing partition is to be split

ORA-14047: ALTER TABLE|INDEX RENAME may not be combined with other operations
Cause: ALTER TABLE or ALTER INDEX statement attempted to combine a RENAME operation with some other operation which is illegal
Action: Ensure that RENAME operation is the sole operation specified in ALTER TABLE or ALTER INDEX statement;
ORA-14048: a partition maintenance operation may not be combined with other operations
Cause: ALTER TABLE or ALTER INDEX statement attempted to combine a partition maintenance operation (e.g. MOVE PARTITION) with some other operation (e.g. ADD PARTITION or PCTFREE which is illegal
Action: Ensure that a partition maintenance operation is the sole operation specified in ALTER TABLE or ALTER INDEX statement; operations other than those dealing with partitions, default attributes of partitioned tables/indices or specifying that a table be renamed (ALTER TABLE RENAME) may be combined at will
ORA-14049: invalid ALTER TABLE MODIFY PARTITION option
Cause: An option other than PCTFREE, PCTUSED, INITRANS, MAXTRANS, STORAGE, BACKUP, ALLOCATE EXTENT, or DEALLOCATE UNUSED was specified in an ALTER TABLE MODIFY PARTITION statement for a Range or Composite Range partition.
Action: Specify only legal options.

ORA-14050: invalid ALTER INDEX MODIFY PARTITION option
Cause: An option other than INITRANS, MAXTRANS, STORAGE, or DEALLOCATE UNUSED was specified in an ALTER INDEX MODIFY PARTITION statement.
Action: Specify only legal options.
ORA-14051: invalid ALTER MATERIALIZED VIEW option
Cause: An option other than PCTFREE, PCTUSED, INITRANS, MAXTRANS, STORAGE, or BACKUP was specified in an ALTER MATERIALIZED VIEW statement.
Action: Specify only legal options.
ORA-14052: partition-extended table name syntax is disallowed in this context
Cause: User attempted to use partition-extended table name syntax in illegal context (i.e. not in FROM-clause or INSERT, DELETE, or UPDATE statement)
Action: Avoid use of partition-extended table name in contexts other those mentioned above.
ORA-14053: illegal attempt to modify string in string statement
Cause: Certain attributes of objects (e.g. tables) may be specified at creation time, but may not be modified using ALTER statement. Unfortunately, user specified one of such attributes.
Action: Ensure that ALTER statement specifies new values only for attributes which may be changed once an object has been created

Above are list of Oracle Database Errors or Warnings from Error ORA-14044 to ORA-14053 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 *