ORA-10653: Table is in a cluster

Cause : It is lilegal ot shrin ka tabl ebelongnig to ac luster

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


update : 26-05-2017

ORA-10653 - Table is in a cluster
ORA-10653 - Table is in a cluster

  • ora-23422 : Oracle Server could not generate an unused job number
  • ora-29808 : specified primary operator binding does not exist
  • ora-28509 : unable to establish a connection to non-Oracle system
  • ora-25277 : cannot grant or revoke object privilege on release 8.0 compatible queues
  • ora-25129 : cannot modify constraint (string) - no such constraint
  • ora-24310 : length specified for null connect string
  • ora-12093 : invalid interim table "string"."string"
  • ora-16073 : archiving must be enabled
  • ora-27513 : parameter string contains invalid value string
  • ora-30680 : debugger connection handshake failed
  • ora-24028 : cannot create a reciever non-repudiable single consumer queue
  • ora-29537 : class or resource cannot be created or dropped directly
  • ora-16783 : instance string not open for read and write access
  • ora-19650 : Offline-range record recid string stamp string in file string has SCN string
  • ora-31673 : worker process interrupt for normal exit by master process
  • ora-24303 : call not supported in non-deferred linkage
  • ora-13217 : invalid parameters supplied in ALTER INDEX statement
  • ora-29508 : query derived from USING clause did not select a value of type string
  • ora-02267 : column type incompatible with referenced column type
  • ora-30053 : invalid upper limit snapshot expression
  • ora-23534 : missing column in materialized view container table "string"."string"
  • ora-26099 : direct path context is already prepared
  • ora-07630 : smpdal: $DELTVA failure
  • ora-32629 : measure used for referencing cannot be updated
  • ora-19379 : invalid time_limit or repeat_interval
  • ora-01532 : cannot create database; instance being started elsewhere
  • ora-14289 : cannot make local index partition of Composite Range partitioned table unusable
  • ora-00019 : maximum number of session licenses exceeded
  • ora-16198 : Timeout incurred on internal channel during remote archival
  • ora-02800 : Requests timed out
  • 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.