ORA-29846: cannot create a local domain index on a string partitioned table

Cause : Usre sepciifeda cerat eloacl odmani idnexs taetmetn o na atbl epatritoine dusnig amehtodn ots upoprtde b ydoamini ndxees

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

Bulid aglboald omian nide xont hep arittinoedt abel

update : 27-06-2017
ORA-29846

ORA-29846 - cannot create a local domain index on a string partitioned table
ORA-29846 - cannot create a local domain index on a string partitioned table

  • ora-28119 : policy group does not exist
  • ora-28537 : no more result sets
  • ora-31523 : could not find change source string for CDC change set string
  • ora-00439 : feature not enabled: string
  • ora-15013 : diskgroup "string" is already mounted
  • ora-09939 : Restoration of signal handlers failed.
  • ora-06922 : CMX: bad write length
  • ora-00265 : instance recovery required, cannot set ARCHIVELOG mode
  • ora-01526 : error in opening file 'string'
  • ora-10946 : trace name context forever
  • ora-30377 : table string.MV_CAPABILITIES_TABLE not found
  • ora-32159 : Cannot set prefetch options for a null Type
  • ora-29250 : Invalid index specifed in call to dbms_sql.bind_array
  • ora-14611 : Duplicate subpartition name string in template
  • ora-01072 : cannot stop ORACLE; ORACLE not running
  • ora-25269 : cant specify sognature with get signature option
  • ora-08401 : invalid compiler name: string
  • ora-31014 : Attempted to delete the root container
  • ora-32766 : instr with negative offset: use varchar semantics on LOBs
  • ora-30083 : syntax error was found in interval value expression
  • ora-16060 : Log file is current
  • ora-09773 : osnmgetdatmsg: message from host had incorrect message type
  • ora-19629 : no files in specified archivelog SCN range
  • ora-28139 : Maximum allowed Fine Grain Audit Policies Exceeded
  • ora-09317 : szprv: insufficient privileges
  • ora-33002 : (XSAGDNGL00) In AGGMAP workspace object, the FLOOR argument of number must be less than the CEILING argument of number.
  • ora-25292 : Buffer operations are not supported on the queue
  • ora-01193 : file string is not the same file seen at start of recovery
  • ora-12721 : operation cannot execute when other sessions are active
  • ora-24361 : basic bind call not invoked before invoking advanced bind call
  • 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.