ORA-14020: this physical attribute may not be specified for
a table partition



ORA-14020: this physical attribute may not be specified for a table partition..

Answer / guest

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

Action: remove invalid option(s) from the list of physical
attributes of a table partition

Please add more information about this Error

Is This Answer Correct ?    1 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-12950: SYSTEM tablespace specified as default permanent tablespace

1 Answers  


QSM-01104: query is using flashback

1 Answers  


NMP-00002: no such SNMP variable name

1 Answers  


TNS-02504: Parameter count retrieval failed

1 Answers  


NID-00105: Need to specify "LOGFILE=<logfile>" when using APPEND=YES option

1 Answers  






TNS-00023: INTCTL: missing ADDRESS(es) in config files

1 Answers  


ORA-13343: a polygon geometry has fewer than four coordinates

1 Answers  


NNL-00305: Server dumping statistics to the log file

1 Answers  


ORA-02007: can't use ALLOCATE or DEALLOCATE options with REBUILD

1 Answers  


SQL*Loader-00525: OCI return status: success

1 Answers  


ORA-01942: IDENTIFIED BY and EXTERNALLY cannot both be specified

1 Answers  


PLS-00367: a RAISE statement with no exception name must be inside an exception handler

1 Answers  


Categories