ORA-14171: cannot specify <subpartition-description> clause
in CREATE|ALTER TABLE



ORA-14171: cannot specify <subpartition-description> clause in CREATE|ALTER TABLE..

Answer / guest

Cause: User requested to generate default subpartition
description(s) (possibly via SUBPARTITIONS) while at the
same time specified <subpartition-description> clause which
is illegal

Action: Remove one of offending clauses.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

NID-00141: No database name specified, previous attempt used string

1 Answers  


ORA-02366: The following index(es) on table string were processed:

1 Answers  


ORA-08414: error encountered in string

1 Answers  


ORA-13019: coordinates out of bounds

1 Answers  


ORA-31528: could not find change set string for CDC subscription string

1 Answers  






PLS-00228: Illegal declaration of variable of type LONG

1 Answers  


ORA-01494: invalid SIZE specified

1 Answers  


ORA-30336: no child for specified JOIN KEY

1 Answers  


TNS-00102: Keyword-Value binding operation error

1 Answers  


LSX-00169: circular group reference is disallowed outside <redefine>

1 Answers  


PLS-01471: The keyword DISTINCT must be present in a COUNT(DISTINCT sim_expr)

1 Answers  


ORA-14326: Primary index on an IOT, DOMAIN and LOB indexes may not be specified in the UPDATE INDEXES clause

1 Answers  


Categories