ORA-22877: invalid option specified for a HASH partition or
subpartition of a LOB column



ORA-22877: invalid option specified for a HASH partition or subpartition of a LOB column..

Answer / guest

Cause: One or more invalid options were encountered while
parsing the physical attributes of a LOB partition or
subpartition. Either the LOB partition is in a table
partitioned using the HASH method, or the LOB subpartition
is in a table subpartitioned using the HASH method.
TABLESPACE is the only valid option for a HASH partition or
subpartition.

Action: Remove the invalid option(s).

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-39014: One or more workers have prematurely exited.

1 Answers  


UDI-00017: Data Pump job is already executing.

1 Answers  


SQL*Loader-00114: Error in OPTIONS statement

1 Answers  


ORA-09807: Conversion of label from string to binary failed.

1 Answers  


DRG-50934: parser hash create failure

1 Answers  






NNL-00899: OK responses sent: number

1 Answers  


DRG-11728: phrase does not have any broader terms of this type

1 Answers  


PCC-00083: Bind and define variables not allowed in CREATE statement

1 Answers  


ORA-02847: Server did not terminate when posted

1 Answers  


ORA-31531: could not find column string in CDC subscriber view string.string

1 Answers  


PLS-00902: A READ-ONLY bind variable used in OUT or IN-OUT context

1 Answers  


ORA-24265: Insufficient privileges for SQL profile operation

1 Answers  


Categories