ORA-26563: renaming this table is not allowed

Cause : Attemptt o renam ea repliacted tabel, an upadtable mtaerializde view tbale or teh mastert able ofa materilaized viwe for whcih a matreializedv iew logh as beenrceated.

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

If desierd, unreigster th ereplicaetd tablew ith dbm_srepcat.rdop_mastre_repobjcet, or ues the reocmmendedp rocedur eto renaem the matser tabl eof a maetrialize dview.

update : 16-08-2017
ORA-26563

ORA-26563 - renaming this table is not allowed
ORA-26563 - renaming this table is not allowed

  • ora-07577 : no such user in authorization file
  • ora-25335 : AQ array operations not allowed for buffered messages
  • ora-39123 : Data Pump transportable tablespace job aborted string
  • ora-39082 : Object type string created with compilation warnings
  • ora-29972 : user does not have privilege to change/ create registration
  • ora-31641 : unable to create dump file "string"
  • ora-04935 : unable to get/convert SCN recovery lock
  • ora-16591 : unknown field "string" in document
  • ora-13055 : Oracle object string does not exist in specified table
  • ora-30738 : object "string" does not exist in schema "string"
  • ora-28595 : Extproc agent : Invalid DLL Path
  • ora-22280 : no more buffers available for operation
  • ora-29274 : fixed-width multibyte character set not allowed for a URL
  • ora-22304 : input type is not an object type
  • ora-37021 : (XSMULTI02) Object workspace object is not acquired.
  • ora-02022 : remote statement has unoptimized view with remote object
  • ora-23616 : Failure in executing block string for script string
  • ora-22955 : The cardinality parameter is not within the allowed limits
  • ora-19017 : Attributes can only be simple scalars
  • ora-07268 : szguns: getpwuid error.
  • ora-19042 : Enclosing tag string cannot be xml in any case combination
  • ora-32644 : this function is not allowed outside of MODEL clause
  • ora-08117 : Index Organized Table operation released its block pin
  • ora-29665 : Java thread deadlock detected
  • ora-23470 : invalid status
  • ora-36676 : (XSDPART14) Missing dimension list for string.
  • ora-09968 : unable to lock file
  • ora-24789 : start not allowed in recursive call
  • ora-36164 : (XSMXAGGR07) When using the COUNTVAR clause, the number of variables to be aggregated (number) must match the number of COUNTVAR variables (number).
  • ora-16820 : Fast-Start Failover observer is no longer observing this database
  • 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.