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

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 - How to fix it : DBA Scripts :: www.high-oracle.com/scripts

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

update : 27-06-2017
ORA-14020

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

  • ora-27166 : tried to join current thread
  • ora-33313 : (DELDENT05) workspace object cannot be deleted because it is the target of an external partition of a partitioned variable.
  • ora-31109 : Action failed as parent resource string is locked
  • ora-02330 : datatype specification not allowed
  • ora-32604 : invalid REBUILD option
  • ora-26050 : Direct path load of domain index is not supported for this column type.
  • ora-14507 : partition corrupt. all rows do not fall within partition bounds
  • ora-24397 : error occured while trying to free connections
  • ora-23498 : repgroups specified must have the same masters
  • ora-37032 : (XSMLTMAINT03) You cannot MAINTAIN partition template workspace object in MULTI mode.
  • ora-28051 : the account is locked
  • ora-32164 : Method called on Invalid Connection type
  • ora-19371 : invalid update option
  • ora-01927 : cannot REVOKE privileges you did not grant
  • ora-12162 : TNS:net service name is incorrectly specified
  • ora-19598 : can not backup SPFILE because the instance was not started with SPFILE
  • ora-02845 : Invalid value for the timing wanted flag
  • ora-12589 : TNS:connection not bequeathable
  • ora-15048 : ASM internal files cannot be deleted
  • ora-16783 : instance string not open for read and write access
  • ora-27376 : event condition cannot be NULL
  • ora-19723 : Cannot recreate plugged in read-only datafile string
  • ora-26017 : global indexes not allowed for direct path load of table partition string
  • ora-01111 : name for data file string is unknown - rename to correct file
  • ora-29323 : ALTER DATABASE SET COMPATIBILITY command not supported by string
  • ora-36405 : (XSSPROP05) Property ignored for object workspace object:
  • ora-13426 : invalid window parameter for subset operation
  • ora-32141 : get method does not match the type of the parameter
  • ora-02306 : cannot create a type that already has valid dependent(s)
  • ora-25953 : join index cannot be a functional index
  • Oracle Database Error Messages



    Oracle Database High Availability Any organization evaluating a database solution for enterprise data must also evaluate the High Availability (HA) capabilities of the database. Data is one of the most critical business assets of an organization. If this data is not available and/or not protected, companies may stand to lose millions of dollars in business downtime as well as negative publicity. Building a highly available data infrastructure is critical to the success of all organizations in today's fast moving economy.

    Well, the reason for above error is that i have taken the above script from a 11g database and running it on 10g database. 11g has bring some changes in password management. Below code is executed on 11g and user created successfully, which is expected result.