ORA-25180: PCTTHRESHOLD only valid for certain table organizations

Cause : PCTTHRSEHOLD cna only eb speciifed fort ables iwth ceratin orgnaizatiosn.

Action - How to fix it : DBA Scripts :: www.high-oracle.com/scripts

Removet he PCTHTRESHOL Doption.

update : 26-06-2017

ORA-25180 - PCTTHRESHOLD only valid for certain table organizations
ORA-25180 - PCTTHRESHOLD only valid for certain table organizations

  • ora-25266 : didnt try to dequeue by message id. with the signature
  • ora-01202 : wrong incarnation of this file - wrong creation time
  • ora-01928 : GRANT option not granted for all privileges
  • ora-00409 : COMPATIBLE needs to be string or higher to use AUTO SEGMENT SPACE MANAGEMENT
  • ora-02456 : The HASH IS column specification must be NUMBER(*,0)
  • ora-13054 : recursive SQL parse error
  • ora-13026 : unknown element type for element string.string.string
  • ora-39305 : schema "string" does not exist
  • ora-12620 : TNS:requested characteristic not available
  • ora-24805 : LOB type mismatch
  • ora-01456 : may not perform insert/delete/update operation inside a READ ONLY transaction
  • ora-16565 : duplicate property, syntax error at "string"
  • ora-26058 : unexpected error fetching metadata for column string in table string
  • ora-31674 : worker process interrupt for unhandled exception in master process
  • ora-32011 : cannot restore SPFILE to location already being used by the instance
  • ora-25249 : dequeue failed, dequeue not allowed for queue string.string
  • ora-19247 : XQ0027 - validation error
  • ora-34279 : (MXDCL37) CONCAT can only be used when defining a DIMENSION.
  • ora-24002 : QUEUE_TABLE string does not exist
  • ora-22319 : type attribute information altered in ALTER TYPE
  • ora-10566 : Test recovery has used all the memory it can use
  • ora-26532 : replication parallel push simulated site failure
  • ora-24359 : OCIDefineObject not invoked for a Object type or Reference
  • ora-39960 : scope can only be SYSTEM or SESSION
  • ora-24146 : rule string.string already exists
  • ora-19526 : only one location allowed for parameter string
  • ora-27471 : window "string.string" is already closed
  • ora-33058 : (XSAGDNGL28) In AGGMAP workspace object, error code string is greater than the maximum error code of number.
  • ora-39095 : Dump file space has been exhausted: Unable to allocate string bytes
  • ora-22869 : depth of type dependency hierarchy exceeds maximum limit
  • 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.