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-13111: cannot add topo_geometry layer [string] to topology

1 Answers  


QSM-01121: materialized view, string, is TRUSTED in ENFORCED integrity mode

1 Answers  


RMAN-06089: archived log string not found or out of sync with catalog

1 Answers  


ORA-07253: spdes: semctl error, unable to destroy semaphore set.

1 Answers  


ORA-25401: can not continue fetches

1 Answers  






ORA-36608: (XSAGHOVERFLOW) The depth of the hierarchies encountered while processing a composite dimension in AGGREGATE caused a counter overflow.

1 Answers  


ORA-16413: Unsupported database type for ONDEMAND archivelog destinations

1 Answers  


LSX-00173: ~S of ~S type is not a valid restriction of ~S of ~S type

1 Answers  


ORA-29515: exit called from Java code with status string

1 Answers  


TNS-01173: Missing or inappropriate PRESPAWN_MAX parameter from SID_DESC

1 Answers  


ORA-27069: attempt to do I/O beyond the range of the file

1 Answers  


PLS-00534: A Table type may not contain a nested table type or VARRAY.

1 Answers  


Categories