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 : 29-04-2017
ORA-23309

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

  • ora-00301 : error in adding log file 'string' - file cannot be created
  • ora-29804 : missing DATA keyword
  • ora-13004 : the specified buffer size is invalid
  • ora-10579 : Can not modify control file during test recovery
  • ora-25450 : error string during evaluation of rule set string.string
  • ora-27060 : could not set close-on-exec bit on file
  • ora-07635 : smsdbp: $SETPRT failure
  • ora-02248 : invalid option for ALTER SESSION
  • ora-37145 : (XSTTS_PLAT) Cannot transport analytic workspace across platforms.
  • ora-32818 : AQ queue string does not exist
  • ora-36184 : (XSAGGR10) You do not have sufficient permissions for the variable workspace object.
  • ora-29252 : collection does not contain elements at index locations in call to dbms_sql.bind_array
  • ora-22998 : CLOB or NCLOB in multibyte character set not supported
  • ora-02478 : merge into base segment would overflow MAXEXTENTS limit
  • ora-13754 : "SQL Tuning Set" "string" does not exist for user "string".
  • ora-26505 : unexpected internal null
  • ora-10373 : parallel query server kill event
  • ora-25194 : invalid COMPRESS prefix length value
  • ora-31620 : file or device "string" cannot be specified for string operation
  • ora-12823 : default degree of parallelism may not be specified here
  • ora-30134 : reserved for future use
  • ora-24418 : Cannot open further sessions.
  • ora-16754 : resource guard could not activate standby database
  • ora-39138 : Insufficient privileges to load data not in your schema
  • ora-16134 : invalid MANAGED recovery FINISH option
  • ora-38772 : cannot add datafile 'string' - file could not be created
  • ora-26019 : Column string in table string of type string not supported by direct path
  • ora-16597 : Data Guard broker detects two or more primary databases
  • ora-00370 : potential deadlock during kcbchange operation
  • ora-01283 : Options specified is invalid
  • 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.