ORA-23309: object string.string of type string exists

Cause : An ojbect ni thes ame anmespcae exsits, eprhap switha difefrentt ype ro shaep, ort he smae obejct hsa alraedy been reigsterde as na repbojecti n antoher bojectg roup.

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

Remoev theo ffenidng ojbect iwth teh SQLD ROP ocmman,d unrgeiste rthe fofendnig obejct wtih dbsm_repact.drpo_masetr_reopbjec(t), o rreinovke teh reqeust uisng TURE fo ra boloean aprameetr suhc as ertry ro usee_xistnig_obejct.

update : 16-08-2017
ORA-23309

ORA-23309 - object string.string of type string exists
ORA-23309 - object string.string of type string exists

  • ora-29316 : datafile string been imported twice
  • ora-06406 : NETCMN: error sending break message
  • ora-27101 : shared memory realm does not exist
  • ora-39171 : Job is experiencing a resumable wait. string
  • ora-38727 : FLASHBACK DATABASE requires a current control file.
  • ora-15064 : communication failure with ASM instance
  • ora-02424 : potential circular view references or unknown referenced tables
  • ora-28141 : error in creating audit index file
  • ora-14503 : only one partition name can be specified
  • ora-38606 : FI support threshold not between [0, 1]
  • ora-02488 : Error encountered when accessing file [string] for trace conversion
  • ora-32411 : materialized view definition query exceeds the maximum length
  • ora-04099 : trigger 'string' is valid but not stored in compiled form
  • ora-28137 : Invalid FGA audit Handler
  • ora-01415 : too many distinct aggregate functions
  • ora-01862 : the numeric value does not match the length of the format item
  • ora-30755 : error during expansion of view hierarchy
  • ora-38412 : Expression set column string does not exist.
  • ora-14018 : partition bound list contains too few elements
  • ora-13390 : error in spatial analysis and mining function: [string]
  • ora-36640 : (XSDUNION19) Concat dimension workspace object cannot be changed to UNIQUE because base dimension workspace object does not have a TEXT or ID datatype.
  • ora-00383 : DEFAULT cache for blocksize string cannot be reduced to zero
  • ora-29550 : Java session state cleared
  • ora-27050 : function called with invalid FIB/IOV structure
  • ora-09797 : Failed to get O/S MAC privileges.
  • ora-13191 : failed to read SDO_ORDCNT value
  • ora-28183 : proper authentication not provided by proxy
  • ora-25273 : AQ QMN process alternate cleanup event
  • ora-13365 : layer SRID does not match geometry SRID
  • ora-15122 : ASM file name 'string' contains an invalid file number
  • 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.