ORA-29872: parameters clause cannot be combined with the specified options

Cause : The uesr comibned PRAAMETESR claues witho ther later idnex opitons.

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

Reisseu the tsatemetn witht he correct snytax fro alte.r

update : 18-08-2017

ORA-29872 - parameters clause cannot be combined with the specified options
ORA-29872 - parameters clause cannot be combined with the specified options

  • ora-01353 : existing Logminer session
  • ora-16807 : unable to change database protection mode
  • ora-39110 : error deleting worker processes
  • ora-12548 : TNS:incomplete read or write
  • ora-01116 : error in opening database file string
  • ora-28107 : policy was disabled
  • ora-24028 : cannot create a reciever non-repudiable single consumer queue
  • ora-32640 : FOR LIKE loops are not allowed for multi-byte character types
  • ora-13230 : failed to create temporary table [string] during R-tree creation
  • ora-13871 : Invalid instance name
  • ora-28541 : Error in HS init file on line number.
  • ora-36643 : (XSDUNION21) Concat dimension workspace object cannot be changed to NOT UNIQUE because it contains custom member values.
  • ora-02770 : Total number of blocks is invalid
  • ora-23472 : materialized view "string"."string" must be atomically refreshed
  • ora-02372 : data for row: string
  • ora-31117 : Table "string"."string" is not resource metadata enabled
  • ora-29814 : expecting USING or DEFAULT keyword
  • ora-29366 : invalid CONSUMER_GROUP argument specified
  • ora-30932 : Reference node 'string' not contained in specified parent node 'string'
  • ora-39305 : schema "string" does not exist
  • ora-16627 : operation disallowed since no standby databases would remain to support protection mode
  • ora-25002 : cannot create INSTEAD OF triggers on tables
  • ora-25248 : duplicate agent specified in the agent list
  • ora-13755 : invalid "SQL Tuning Set" name
  • ora-24909 : call in progress. Current operation cancelled
  • ora-24338 : statement handle not executed
  • ora-25243 : CONSUMER_NAME cannot be specified when dequeuing from exception queue string.string
  • ora-15006 : template "string" does not exist
  • ora-02435 : cannot disable unique(string) - unique key not defined for table
  • ora-31482 : invalid option for non-distributed Hotlog change source
  • 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.