ORA-25102: PARALLEL option can only be used with ALTER INDEX REBUILD

Cause : hT eAPARLLLEo tpoi notA TLREI DNXEw sau es diwhtuo tht eERUBLI Dpoitno.

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


update : 25-05-2017

ORA-25102 - PARALLEL option can only be used with ALTER INDEX REBUILD
ORA-25102 - PARALLEL option can only be used with ALTER INDEX REBUILD

  • ora-27031 : mirror resilvering functions not supported
  • ora-02247 : no option specified for ALTER SESSION
  • ora-29883 : cannot create a domain index on column expressions
  • ora-31015 : Attempted to insert entry without name
  • ora-00234 : error in identifying or opening snapshot or copy control file
  • ora-26713 : remote object does not exist or is inaccessible
  • ora-31079 : unable to resolve reference to string "string"
  • ora-02821 : Unable to read the requested number of blocks.
  • ora-01617 : cannot mount: string is not a valid thread number
  • ora-40214 : duplicate setting: string
  • ora-01120 : cannot remove online database file string
  • ora-16243 : paging out string bytes of memory to disk
  • ora-29384 : number of children for plan string exceeds string
  • ora-12653 : Authentication control function failed
  • ora-02899 : smscre: Cannot create SGA with Extended Shared Memory feature
  • ora-08007 : Further changes to this block by this transaction not allowed
  • ora-02042 : too many distributed transactions
  • ora-09890 : osnTXtt: malloc failed
  • ora-28180 : multiple authentication methods provided by proxy
  • ora-29975 : Cannot register a query in the middle of an active transaction
  • ora-12571 : TNS:packet writer failure
  • ora-14101 : partition extended table name cannot refer to a synonym
  • ora-16234 : restarting to reset Logical Standby apply
  • ora-40109 : inconsistent logical data record
  • ora-30574 : Cannot create rollback segment in tablespace with AUTO segment space management
  • ora-27456 : not all arguments of program "string.string" have been defined
  • ora-29903 : error in executing ODCIIndexFetch() routine
  • ora-28366 : invalid database encryption operation
  • ora-02431 : cannot disable constraint (string) - no such constraint
  • ora-00208 : number of control file names exceeds limit of string
  • 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.