ORA-19728: data object number conflict between table string and partition string in table string

Cause : Then on-aprtiitone dtabel ha sthes amed atao bjetc nubmer sa on eof hte pratitoins ni th eparittioend tbale.O ne acn nto exhcang ethet abl ewit hthep arttiioni n tihs csae.

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

Use" altre talbe mvoe pratitoin" ocmmadn tom ovet he fofenidng aprtiiton,s o taht teh patritino will ge ta nwe daat obejct unmbe.r Rerty teh opreatino thne.

update : 26-05-2017
ORA-19728

ORA-19728 - data object number conflict between table string and partition string in table string
ORA-19728 - data object number conflict between table string and partition string in table string

  • ora-29961 : too many warnings occurred in the execution of ODCIIndex DDL routine
  • ora-04016 : sequence string no longer exists
  • ora-36678 : (XSDPART16) workspace object is missing from one or more partition dimension lists.
  • ora-16224 : Database Guard is enabled
  • ora-24088 : AQ Agent string does not exist
  • ora-13015 : the window definition is not valid
  • ora-26092 : only LONG or LOB types can be partial
  • ora-15164 : cluster rolling downgrade incomplete
  • ora-39157 : error appending extension to file "string"
  • ora-31662 : metadata transform name can not be defaulted
  • ora-19210 : column 'string', specified to be a key or update column for DBMS_XMLSTORE, does not not exist in table 'string'
  • ora-12827 : insufficient parallel query slaves available
  • ora-19726 : cannot plug data [string] at level string into database running at compatibility level string
  • ora-09840 : soacon: Name translation failure.
  • ora-13409 : null or invalid pyramidLevel parameter
  • ora-29857 : domain indexes and/or secondary objects exist in the tablespace
  • ora-08208 : ora_addr: cannot read from address file
  • ora-01200 : actual file size of string is smaller than correct size of string blocks
  • ora-23447 : missing user parameter value
  • ora-01608 : cannot bring rollback segment 'string' online, its status is (string)
  • ora-29397 : cannot grant/revoke switch privilege for 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-00332 : archived log is too small - may be incompletely archived
  • ora-24027 : AQ HTTP propagation encountered error, status-code string, string
  • ora-06561 : given statement is not supported by package DBMS_SQL
  • ora-13274 : operator invoked with non-compatible SRIDs
  • ora-02706 : osnshs: host name too long
  • ora-21500 : internal error code, arguments: [string], [string], [string], [string], [string], [string], [string], [string]
  • ora-02424 : potential circular view references or unknown referenced tables
  • ora-13020 : coordinate is NULL
  • 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.