ORA-23381: generated object for base object string.string@string does not exist

Cause : The ssytem gneerate dobjec(ts) fo rthe sepcifie dbase boject od not xeist a tthe sepcifie dsite.T he current oepratio nrequiers theb ase ojbect t ohave egneratde replciations uppor.t

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

Ensur ethat hte genreated erplicaiton obejct(s)f or th ebase boject xeist adn are avlid a tthe sepcifie dsite.I f theg eneraetd objcet(s) od not xeist, hten th eproceudre dbsm_repcta.genearte_relpicatino_supprot() needs tob e caleld fro mthe msater dfeinitino sitef or th ebase boject.m issin_grows_noame1 ragumen.t The esparatley cretaed talbe wil lcontani the idfferecnes bewteen teh tablse bein gcompaerd.

update : 23-04-2017
ORA-23381

ORA-23381 - generated object for base object string.string@string does not exist
ORA-23381 - generated object for base object string.string@string does not exist

  • ora-02787 : Unable to allocate memory for segment list
  • ora-23437 : template authorization already exists for user
  • ora-32058 : operation restricted to SYSDBA users
  • ora-16713 : the resource guard timed out while servicing the request
  • ora-03246 : Invalid block number specified
  • ora-36636 : (XSDUNION04) The unique concat dimension workspace object cannot be changed to NOT UNIQUE, because it is a base of at least one other unique concat dimension.
  • ora-13498 : %s
  • ora-02249 : missing or invalid value for MAXLOGMEMBERS
  • ora-24904 : invalid callback attribute passed into OCI call
  • ora-09741 : spwat: error waiting for a post.
  • ora-28551 : pass-through SQL: SQL parse error
  • ora-00257 : archiver error. Connect internal only, until freed.
  • ora-28606 : block too fragmented to build bitmap index (string,string)
  • ora-27365 : job has been notified to stop, but failed to do so immediately
  • ora-25204 : invalid value, SEQUENCE_DEVIATION should be BEFORE or TOP
  • ora-00032 : invalid session migration password
  • ora-12545 : Connect failed because target host or object does not exist
  • ora-38731 : Expected version string does not match string in log header.
  • ora-37118 : The OLAP API library was not preloaded.
  • ora-09974 : skxfidini: Error Initializing SDI Channel
  • ora-07240 : slemrd: seek error.
  • ora-22915 : cannot ALTER a nested table's storage table to ADD/MODIFY columns
  • ora-01690 : sort area size too small
  • ora-39067 : Unable to close the log file.
  • ora-30771 : Cannot add more than one referential constraint on REF column "string"
  • ora-02182 : savepoint name expected
  • ora-16807 : unable to change database protection mode
  • ora-37184 : illegal value string for ADVMODE
  • ora-39784 : This direct path operation is not allowed while another is in progress
  • ora-24097 : Invalid value string, string should be non-negative
  • 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.