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 : 18-08-2017

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

  • ora-01931 : cannot grant string to a role
  • ora-28271 : No permission to read user entry in LDAP directory service.
  • ora-06003 : NETASY: port write failure
  • ora-09714 : Two Task interface: cannot obtain puname
  • ora-02077 : selects of long columns must be from co-located tables
  • ora-16204 : DDL successfully applied
  • ora-29517 : recursive resolution failed for a referenced class
  • ora-28140 : Invalid column specified
  • ora-32737 : Hang analysis aborted due to failed memory allocation
  • ora-30506 : system triggers cannot be based on tables or views
  • ora-02042 : too many distributed transactions
  • ora-34141 : (MXCGPUT00) You cannot use the ASSIGN keyword with DIMENSION workspace object.
  • ora-28023 : must revoke grants of this role to other user(s) first
  • ora-39051 : parameter string specified multiple times
  • ora-16242 : Processing logfile (thread# string, sequence# string)
  • ora-22282 : non-contiguous append to a buffering enabled LOB not allowed
  • ora-21614 : constraint violation for attribute number [string]
  • ora-30013 : undo tablespace 'string' is currently in use
  • ora-32159 : Cannot set prefetch options for a null Type
  • ora-16706 : no resource guard is available
  • ora-15008 : cannot drop system template
  • ora-13437 : GeoRaster metadata blocking error
  • ora-25281 : complete reciever information not provided to non-repudiate reciever
  • ora-23323 : parameter length exceeds deferred RPC limits
  • ora-22632 : AnyDataSet parameter is not valid for the current operation
  • ora-06265 : NETNTT: break protocol error
  • ora-16053 : DB_UNIQUE_NAME string is not in the Data Guard Configuration
  • ora-30382 : DROP MATERIALIZED VIEW string.string operation is not complete
  • ora-02805 : Unable to set handler for SIGTPA
  • ora-38412 : Expression set column string does not exist.
  • 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.