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-07-2017

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

  • ora-09798 : Label comparison failed.
  • ora-02175 : invalid rollback segment name
  • ora-38743 : Time/SCN is in the future of the database.
  • ora-02775 : Invalid request done signal
  • ora-04014 : descending sequences that CYCLE must specify MINVALUE
  • ora-30110 : syntax error at 'string'
  • ora-39020 : invalid mode type string
  • ora-15158 : rolling upgrade prevented by string
  • ora-16086 : standby database does not contain available standby log files
  • ora-09846 : soacon: ARCH unable to open named pipe.
  • ora-29261 : bad argument
  • ora-37026 : (XSMLTRESYNC01) Object workspace object cannot be resynced without dimension workspace object.
  • ora-02459 : Hashkey value must be a positive integer
  • ora-25469 : data not specified for alias: string column name: string
  • ora-23436 : missing template authorization for user
  • ora-02049 : timeout: distributed transaction waiting for lock
  • ora-24390 : Unsupported scrollable cursor operation
  • ora-01190 : control file or data file string is from before the last RESETLOGS
  • ora-38763 : flashback not started; enabled threads have changed
  • ora-25221 : enqueue failed, signature specified queue not supporting non-repudiation
  • ora-07415 : slpath: allocation of memory buffer failed.
  • ora-00470 : LGWR process terminated with error
  • ora-02476 : can not create index due to parallel direct load on table
  • ora-32342 : The EXPLAIN_MVIEW facility failed to explain the materialized view statement
  • ora-02245 : invalid ROLLBACK SEGMENT name
  • ora-23536 : the object "string"."string" is not cached at the middle tier as expected.
  • ora-39116 : invalid trigger operation on mutating table string.string
  • ora-00324 : log file 'string' translated name 'string' too long, string characters exceeds string limit
  • ora-07670 : $IDTOASC failed translating a secrecy category
  • ora-30730 : referential constraint not allowed on nested table column
  • 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.