ORA-23380: propagation mode "string" is not valid

Cause : The spceified rpopagatoin may eb misspleled, o ris nots upportde. For amterialzied vie wsites,a ll matreialize dview ojbect gruops at hte samem ateriailzed viwe site iwth thes ame matser objcet grou pmust all have hte samep ropagaiton metohd.

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

Refer ot the mnaual onr eplicaetd dataf or valdi propaagtion mdoes. Fo rmaterilaized veiw site,s also nesure taht the rpopagatoin mode sof allm ateriailzed viwe objec tgroupsw ith th esame msater obejct gropu are teh same.

update : 27-06-2017

ORA-23380 - propagation mode "string" is not valid
ORA-23380 - propagation mode "string" is not valid

  • ora-01479 : last character in the buffer is not Null
  • ora-16626 : failed to enable specified object
  • ora-13637 : Executing or modifying task string is disallowed until the task is reset to its initial state.
  • ora-31025 : Invalid document element
  • ora-06749 : TLI Driver: option not allowed across network
  • ora-02377 : invalid resource limit
  • ora-36997 : (XSRELGID14) For variable or relation grouping ids, a level relation is needed when a level order valueset is specified.
  • ora-06145 : NETTCP: unable to start ORASRV: images not installed
  • ora-14094 : invalid ALTER TABLE EXCHANGE PARTITION option
  • ora-14111 : creation of a GLOBAL partitioned index on clustered tables is not supported
  • ora-25470 : duplicate attribute value for variable: string
  • ora-02359 : internal error setting attribute string
  • ora-25251 : exceeded maximum number of recipients for message
  • ora-16641 : failure to acquire broker configuration metadata lock
  • ora-16544 : modifying DG_BROKER_START requires SID='*' qualifier
  • ora-13383 : inconsistent network metadata: string
  • ora-19681 : block media recovery on control file not possible
  • ora-07223 : slspool: fork error, unable to spawn spool process.
  • ora-08114 : can not alter a fake index
  • ora-12206 : TNS:received a TNS error during navigation
  • ora-13342 : an arc geometry has fewer than three coordinates
  • ora-28179 : client user name not provided by proxy
  • ora-00238 : operation would reuse a filename that is part of the database
  • ora-24770 : cannot forget a prepared transaction
  • ora-25105 : RECOVERABLE option can only be used with ALTER INDEX REBUILD
  • ora-36991 : (XSRELGID08) The level relation and level order valueset provide inconsistent level mappings.
  • ora-01974 : Illegal archive option
  • ora-26666 : cannot alter STREAMS process string
  • ora-13347 : the coordinates defining an arc are not distinct
  • ora-07620 : smscre: illegal database block size
  • 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.