ORA-28653: tables must both be index-organized

Cause : Attempt to exchange a non IOT table/partition with a partition/table respectively

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

Ensure that non-partitioned and partitioned tables are both index-organized.

update : 18-08-2017
ORA-28653

ORA-28653 - tables must both be index-organized
ORA-28653 - tables must both be index-organized

  • ora-32845 : Messaging Gateway agent is already running
  • ora-38460 : filtering based on datatype "string" not supported for XML Tags
  • ora-36846 : (XSLMGEN16) AW name is greater than 30 bytes
  • ora-29815 : object being associated is not present
  • ora-23542 : dependent object "string"."string" already registered
  • ora-00478 : SMON process terminated due to error string
  • ora-16027 : parameter string is missing a destination option
  • ora-14521 : Default tablespace string block size [string] for string string does not match existing string block size [string]
  • ora-29858 : error occurred in the execution of ODCIINDEXALTER routine
  • ora-12699 : Native service internal error
  • ora-12027 : duplicate filter column
  • ora-03250 : Cannot mark this segment corrupt
  • ora-19632 : file name not found in control file
  • ora-04050 : invalid or missing procedure, function, or package name
  • ora-07702 : unrecognized device type in archive text
  • ora-24372 : invalid object for describe
  • ora-02162 : invalid value for MAXDATAFILES
  • ora-36800 : (XSTBLFUNC00) The OLAP_TABLE function can only have a single LOOP statement within the LIMITMAP
  • ora-29851 : cannot build a domain index on more than one column
  • ora-07473 : snclrd: read error when trying to read sgadef.dbf file.
  • ora-30186 : '' must be followed by four hexdecimal characters or another ''
  • ora-19701 : device name exceeds maximum length of string
  • ora-09936 : Open of ORACLE password file for write failed.
  • ora-31425 : subscription does not exist
  • ora-19657 : cannot inspect current datafile string
  • ora-02490 : missing required file size in RESIZE clause
  • ora-19754 : error reading from change tracking file
  • ora-14604 : During CREATE TABLE time it is illegal to specify SUBPARTITIONS or STORE IN once a SUBPARTITION TEMPLATE has been specified
  • ora-02362 : error closing file: string
  • ora-09740 : slsget: cannot get virtual memory region statistics.
  • 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.