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-28519: no heterogeneous data dictionary translations available

1 Answers  


ORA-12606: TNS: Application timeout occurred

1 Answers  


ORA-33012: (XSAGDNGL05) AGGMAP workspace object contains invalid syntax.

1 Answers  


TNS-00021: INTCTL: missing INTERCHANGE_DATA in INTCHG.ORA

1 Answers  


ORA-13833: SQL profile named string doesn't exist

1 Answers  






PLS-00670: sort columns must be simple column names

1 Answers  


DRG-11866: Please Try `ftp://' Instead Of `file://'

1 Answers  


TNS-00128: Missing COMMUNITY in TNSNET.ORA

1 Answers  


ORA-01333: failed to establish Logminer Dictionary

1 Answers  


NNL-00806: Queries received, type RELATED-INFO: number

1 Answers  


ORA-01493: invalid SAMPLE size specified

1 Answers  


ORA-14011: names assigned to resulting partitions must be distinct

1 Answers  


Categories