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

NNC-00424: invalid address "string"

1 Answers  


EXP-00077: multiple output files specified for unbounded export file

1 Answers  


ORA-32302: object materialized views must be object ID based

1 Answers  


ORA-33448: (ESDREAD04) Discarding compiled code for workspace object because number now has string data, whereas it had string data when the code was compiled.

1 Answers  


ORA-39094: Parallel execution not supported in this database edition.

1 Answers  






ORA-12527: TNS:listener: all instances are in restricted mode or blocking new connections

1 Answers  


LRM-00104: 'string' is not a legal integer for 'string'

1 Answers  


PCC-00145: This statement can only be used with THREADS=YES

1 Answers  


PLS-00561: character set mismatch on value for parameter 'string'

1 Answers  


NID-00104: Need to specify TARGET connection parameter in command line

1 Answers  


O2I-00120: Error reported by subsystem:

1 Answers  


ORA-29822: selectivity cannot be specified for the type of object

1 Answers  


Categories