ORA-25178: duplicate PCTTHRESHOLD storage option specification

Cause : Thes torgae otpionP CTTRHESHLOD i sspeicfie dmor etha nonc.e

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

Speicfy tsoraeg opitonsa t msot ocne.

update : 22-06-2017

ORA-25178 - duplicate PCTTHRESHOLD storage option specification
ORA-25178 - duplicate PCTTHRESHOLD storage option specification

  • ora-19331 : Last argument to CREATE_DBURI operator must be a column
  • ora-14030 : non-existent partitioning column in CREATE TABLE statement
  • ora-13643 : The task can not be interrupted or cancelled.
  • ora-38747 : corrupt before image (file# string, block# string)
  • ora-38103 : Invalid column in the UPDATE SET Clause: string
  • ora-19238 : XP0018 - focus not defined
  • ora-07562 : sldext: extension must be 3 characters
  • ora-02430 : cannot enable constraint (string) - no such constraint
  • ora-19501 : read error on file "string", blockno string (blocksize=string)
  • ora-27155 : could not execute file
  • ora-22803 : object type contains zero attributes
  • ora-02827 : Invalid file number
  • ora-30509 : client logoff triggers cannot have AFTER type
  • ora-32831 : timed out trying to acquire administration lock
  • ora-04081 : trigger 'string' already exists
  • ora-07665 : ssrexhd: recursive exception encountered string string string string string string
  • ora-24383 : Overflow segment of an IOT cannot be described
  • ora-01506 : missing or illegal database name
  • ora-30122 : value 'string' for 'string' must be between 'number' and 'number'
  • ora-00153 : internal error in XA library
  • ora-31116 : Tablespace not specified correctly
  • ora-24195 : attemp to retrieve the name list of a map message with size exceeding 1024
  • ora-36398 : (XSSPROP01) Property name 'number' is invalid because only system-reserved property names can begin with '$'.
  • ora-09945 : Unable to initialize the audit trail file
  • ora-19773 : must specify change tracking file name
  • ora-22150 : variable-length array has not been initialized
  • ora-12467 : minimum label can contain a level only
  • ora-33338 : (DSSEXIST05) You cannot specify the EXPTEMP analytic workspace.
  • ora-00218 : block size string of control file 'string' does not match DB_BLOCK_SIZE (string)
  • ora-13159 : Oracle table string already exists
  • 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.