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-16039: RFS request version mismatch

1 Answers  


ORA-30440: can't fast refresh;refresh complete or set event 30441 for partial refresh

1 Answers  


SQL*Loader-00810: error creating external table: string

1 Answers  


ORA-16797: SPFILE is missing in the Data Guard broker environment

1 Answers  


NNL-00205: Reload check occurs in string

1 Answers  


ORA-12537: TNS:connection closed

2 Answers   State Bank Of India SBI,


RMAN-04012: auxiliary database Password:

1 Answers  


NNL-00851: Renames refused, name is not a leaf name: number

1 Answers  


ORA-07701: sksatln: internal exception: output buffer too small

1 Answers  


KUP-04009: invalid SLF handle

1 Answers  


ORA-30357: this PL/SQL function cannot be supported for query rewrite

1 Answers  


ORA-00050: operating system error occurred while obtaining an enqueue

1 Answers  


Categories