ORA-24030: Only one of rule or rule-set must be specified

Cause : Specified both a rule and rule-set for the operation.

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

Specify only one of rule or rule-set.

update : 26-04-2017
ORA-24030

ORA-24030 - Only one of rule or rule-set must be specified
ORA-24030 - Only one of rule or rule-set must be specified

  • ora-16146 : standby destination control file enqueue unavailable
  • ora-22812 : cannot reference nested table column's storage table
  • ora-01425 : escape character must be character string of length 1
  • ora-16259 : Switchover to logical standby requires a log archive destination
  • ora-00162 : external dbid length string is greater than maximum (string)
  • ora-06708 : TLI Driver: message receive failure
  • ora-06018 : NETASY: message send failure
  • ora-09814 : Unable to expand file name
  • ora-24370 : illegal piecewise operation attempted
  • ora-27378 : cannot stop jobs of type EXECUTABLE on this platform
  • ora-14279 : index mismatch for tables in ALTER TABLE EXCHANGE SUBPARTITION
  • ora-16520 : unable to allocate resource id
  • ora-19107 : invalid XQueryX - unsupported construct - string
  • ora-03007 : obsolete feature
  • ora-24334 : no descriptor for this position
  • ora-27059 : could not reduce file size
  • ora-24780 : cannot recover a transaction while in an existing transaction
  • ora-13362 : disjoint sub-element in a compound polygon
  • ora-09760 : osnpui: cannot send break message
  • ora-09932 : Close of ORACLE password file failed.
  • ora-02285 : duplicate START WITH specifications
  • ora-12477 : greatest lower bound resulted in an invalid OS label
  • ora-23357 : the propagator does not exist
  • ora-36314 : (PHYS01) workspace object must be a dimension, relation or variable.
  • ora-01149 : cannot shutdown - file string has online backup set
  • ora-30088 : datetime/interval precision is out of range
  • ora-19927 : CONVERT DATABASE operation cannot proceed
  • ora-12815 : value for INSTANCES must be greater than 0
  • ora-25403 : could not reconnect
  • ora-02779 : Stat failed on core dump directory
  • 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.