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 : 29-04-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-30332 : container table already in use by other summary
  • ora-06932 : CMX: error in local name
  • ora-12333 : database (link name string) is not mounted
  • ora-23351 : parameter datatype string for procedure string not supported
  • ora-07432 : unable to perform nested sleep
  • ora-38305 : object not in RECYCLE BIN
  • ora-13181 : unable to determine length of column string_SDOINDEX.SDO_CODE
  • ora-19704 : file name exceeds maximum length of string
  • ora-10583 : Can not recovery file string renamed as missing during test recovery
  • ora-24029 : operation not allowed on a single-consumer queue
  • ora-06107 : NETTCP: ORACLE network server not found
  • ora-00394 : online log reused while attempting to archive it
  • ora-10642 : Found rollback segments in dictionary managed tablespaces
  • ora-12044 : invalid CREATE MATERIALIZED VIEW LOG option
  • ora-39085 : cannot update job string for user string
  • ora-15041 : diskgroup space exhausted
  • ora-27369 : job of type EXECUTABLE failed with exit code: string
  • ora-30360 : REF not supported with query rewrite
  • ora-01283 : Options specified is invalid
  • ora-15027 : active use of diskgroup "string" precludes its dismount
  • ora-38702 : Cannot update flashback database log file header.
  • ora-04006 : START WITH cannot be less than MINVALUE
  • ora-36278 : (XSCGMDLAGG07) workspace object does not exist or is not valueset.
  • ora-00340 : IO error processing online log string of thread string
  • ora-31203 : DBMS_LDAP: PL/SQL - Init Failed.
  • ora-29702 : error occurred in Cluster Group Service operation
  • ora-13776 : User "string" has not been granted the "SELECT" privilege on the "SQL tuning set" DBA views.
  • ora-32016 : parameter "string" cannot be updated in SPFILE
  • ora-23384 : replication parallel push string argument out of range
  • ora-06400 : NETCMN: No default host string specified
  • 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.