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 : 28-04-2017

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

  • ora-07607 : szaud: $SNDOPR failure
  • ora-40209 : setting % is invalid for % function
  • ora-00067 : invalid value string for parameter string; must be at least string
  • ora-13338 : failure in reversing LRS polygon/collection geometry
  • ora-00282 : UPI string call not supported, use ALTER DATABASE RECOVER
  • ora-07490 : scgrcl: cannot convert lock.
  • ora-25406 : could not generate a connect address
  • ora-06778 : TLI Driver: error sending ccode
  • ora-31229 : DBMS_LDAP: invalid input parameter
  • ora-22861 : invalid user-defined type
  • ora-34514 : (MXOPERR) You cannot string string data in the expression that begins with 'string'.
  • ora-13384 : error in network schema: string
  • ora-29760 : instance_number parameter not specified
  • ora-38312 : original name is used by an existing object
  • ora-36872 : (XSTFDSC02) Column type specifier cannot be used when the table function data type is specified.
  • ora-12810 : PARALLEL_MAX_SERVERS must be less than or equal to string
  • ora-06137 : NETTCP: error during connection handshake
  • ora-24181 : The type string does not exist
  • ora-09283 : sllfsk: error skipping records
  • ora-06970 : X.25 Driver: remote host is unknown
  • ora-13707 : Either the start snapshot string or the end snapshot string is incomplete or missing key statistics.
  • ora-30974 : invalid Path Id Index option for XML Index
  • ora-24199 : message store is overflow
  • ora-04099 : trigger 'string' is valid but not stored in compiled form
  • ora-07880 : sdopnf: internal error
  • ora-34897 : (PPMONTHS01) Blank lines are not allowed in the MONTHNAMES option.
  • ora-02144 : no option specified for ALTER CLUSTER
  • ora-19245 : XQ0025 - duplicate attribute name string
  • ora-01298 : conflicting dictionary option
  • ora-19908 : datafile string has invalid checkpoint
  • 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.