ORA-14010: this physical attribute may not be specified for
an index partition



ORA-14010: this physical attribute may not be specified for an index partition..

Answer / guest

Cause: unexpected option was encountered while parsing
physical attributes of an index partition; valid options for
Range or Composite Range partitions are INITRANS, MAXTRANS,
TABLESPACE, STORAGE, PCTFREE; only TABLESPACE may be
specified for Hash partitions

Action: remove invalid option(s) from the list of physical
attributes of an index partition

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-01264: Unable to create string file name

1 Answers  


ORA-25005: cannot CREATE INSTEAD OF trigger on a read-only view

1 Answers  


NNL-00413: Total response time: string

1 Answers  


LSX-00176: circular reference detected in schema component named "~S"

1 Answers  


ORA-07610: $GETJPIW failed in retrieving the user's MAC priviledges

1 Answers  






ORA-00965: column aliases not allowed for '*'

1 Answers  


ORA-36984: (XSRELGID04) A value cannot be inserted into dimension workspace object.

1 Answers  


PLS-00510: Float cannot have scale

1 Answers  


ORA-22600: encountered 8.0.2 (Beta) VARRAY data that cannot be processed

1 Answers  


QSM-02092: mv references a sequence number

1 Answers  


ORA-14285: cannot COALESCE the only partition of this hash partitioned table or index

1 Answers  


ORA-13769: Snapshots string and string do not exist.

1 Answers  


Categories