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

DRG-10900: out of memory

1 Answers  


ORA-01533: cannot rename file 'string'; file does not belong to tablespace

1 Answers  


IMG-00543: invalid compressionFormat specified

1 Answers  


PLS-00619: the first operand in the NULLIF expression must not be NULL

1 Answers  


ORA-38418: ADT associated with the attribute set string does not exist

1 Answers  






NNC-00401: program interface initialization failed

1 Answers  


ORA-01661: tablespace 'string' is already temporary

1 Answers  


ORA-24075: cannot specify agent with NULL address and non-NULL protocol

1 Answers  


PCC-02410: Expecting an expression of some Collection type.

1 Answers  


ORA-16080: invalid LogMiner session string for APPLY

1 Answers  


ORA-32321: REFRESH FAST of "string"."string" unsupported after detail table TRUNCATE

1 Answers  


ORA-28664: a partitioned table may not be coalesced as a whole

1 Answers  


Categories