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 : 30-05-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-36184 : (XSAGGR10) You do not have sufficient permissions for the variable workspace object.
  • ora-30012 : undo tablespace 'string' does not exist or of wrong type
  • ora-37036 : (XSMLTDCL02) You cannot DELETE objects in analytic workspace string because it is attached in MULTI mode.
  • ora-19726 : cannot plug data [string] at level string into database running at compatibility level string
  • ora-30659 : too many locations specified for external table
  • ora-16175 : cannot shut down database when media recovery is active
  • ora-30032 : the suspended (resumable) statement has timed out
  • ora-16232 : adding Logical Standby skip entry for table string.string
  • ora-24430 : Null values for sqltext and key were specified.
  • ora-28232 : invalid input length for obfuscation toolkit
  • ora-29877 : failed in the execution of the ODCIINDEXUPDATE routine
  • ora-19563 : %s header validation failed for file string
  • ora-12674 : Shared server: proxy context not saved
  • ora-16068 : redo log file activation identifier mismatch
  • ora-14016 : underlying table of a LOCAL partitioned index must be partitioned
  • ora-36188 : (XSAGGR16) AGGREGATE read a value less than 1 out of COUNTVAR variable workspace object. Either the values of the COUNTVAR variable are stored improperly, or there is problem in AGGREGATE. If no one has modified the values in this COUNTVAR, contact Oracle customer support.
  • ora-01208 : data file is an old version - not accessing current version
  • ora-12161 : TNS:internal error: partial data received
  • ora-19263 : XQ0043 - duplicate namespace prefix string
  • ora-16954 : SQL parse error.
  • ora-40203 : model string does not exist
  • ora-29959 : error in the execution of the string routine for one or more of the index partitions
  • ora-01883 : overlap was disabled during a region transition
  • ora-09974 : skxfidini: Error Initializing SDI Channel
  • ora-00402 : database changes by release string cannot be used by release string
  • ora-00371 : not enough shared pool memory, should be atleast string bytes
  • ora-08440 : raw buffer is too short to hold converted data
  • ora-07613 : $GETJPIW failed in retrieving the user's process label
  • ora-06313 : IPA: Shared memory failed to initialise
  • ora-12706 : this CREATE DATABASE character set is not allowed
  • 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.