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 : 26-04-2017
ORA-25178

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

  • ora-23375 : feature is incompatible with database version at string
  • ora-02845 : Invalid value for the timing wanted flag
  • ora-12318 : database (link name string) is already mounted
  • ora-00253 : character limit string exceeded by archive destination string string
  • ora-32334 : cannot create prebuilt materialized view on a table already referenced by a MV
  • ora-02459 : Hashkey value must be a positive integer
  • ora-00608 : testing error [string] [string] [string] [string] [string]
  • ora-27155 : could not execute file
  • ora-01942 : IDENTIFIED BY and EXTERNALLY cannot both be specified
  • ora-13766 : A ranking measure is required.
  • ora-02760 : Client close of file failed.
  • ora-24280 : invalid input value for parameter string
  • ora-24911 : Cannot start listener thread at specified port
  • ora-36160 : (XSMXAGGR04) You cannot use string on scalar VARIABLE workspace object.
  • ora-31023 : Index size error
  • ora-09703 : sem_release: cannot release latch semaphore
  • ora-01548 : active rollback segment 'string' found, terminate dropping tablespace
  • ora-16614 : object has an ancestor that is disabled
  • ora-02396 : exceeded maximum idle time, please connect again
  • ora-13155 : invalid number of dimensions specified
  • ora-31083 : error while creating SQL type "string"."string"
  • ora-01300 : writable database required for specified LogMiner options
  • ora-33429 : (EIFMAKEF17) CAUTION: NTEXT expression will be exported with type TEXT.
  • ora-30039 : Cannot drop the undo tablespace
  • ora-27479 : Cannot string "string.string" because other objects depend on it
  • ora-00438 : %s Option not installed
  • ora-22993 : specified input amount is greater than actual source amount
  • ora-09880 : sstasfre/sstasdel: shmdt error, unable to detach tas write page
  • ora-08460 : invalid environment clause in environment parameter
  • ora-37132 : (XSCCOMP07) Incremental aggregation over the dense DIMENSION workspace object is not supported when aggregating a VARIABLE dimensioned by a COMPRESSED COMPOSITE.
  • 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.