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 : 21-08-2017

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-27478 : job "string.string" is running
  • ora-31407 : end_date must be greater than the begin_date
  • ora-38492 : invalid ALTER INDEX parameters clause "string"
  • ora-29741 : IMR active for some, but not all members of cluster
  • ora-27001 : unsupported device type
  • ora-24795 : Illegal string attempt made
  • ora-07565 : sldext: $SEARCH failure
  • ora-28362 : master key not found
  • ora-16120 : dependencies being computed for transaction at SCN string
  • ora-16024 : parameter string cannot be parsed
  • ora-25287 : Invalid value string, string should be non-negative
  • ora-13338 : failure in reversing LRS polygon/collection geometry
  • ora-07683 : sou2os: $SETPRV reset error
  • ora-15110 : no diskgroups mounted
  • ora-09745 : smscre: vm_allocate error, unable to create shared memory.
  • ora-14190 : only one ENABLE/DISABLE ROW MOVEMENT clause can be specified
  • ora-06022 : NETASY: channel open failure
  • ora-38456 : The attribute set "string" is in an inconsistent state.
  • ora-22997 : VARRAY | OPAQUE stored as LOB is not specified at the table level
  • ora-06318 : IPA: Local maximum number of connections exceeded
  • ora-32026 : %s.string has fewer columns compared to string table.
  • ora-31621 : error creating master process
  • ora-02721 : osnseminit: cannot create semaphore set
  • ora-14007 : missing LESS keyword
  • ora-32055 : invalid file type
  • ora-07244 : ssfccf: create file failed, file size limit reached.
  • ora-00064 : object is too large to allocate on this O/S (string,string)
  • ora-01334 : invalid or missing logminer dictionary processes context
  • ora-28108 : circular security policies detected
  • ora-39780 : Direct path context operations are not allowed after the context is aborted or finished
  • 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.