ORA-10633: No space found in the segment

Cause : Raised while trying to find space during segment shrink

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

This error should be trapped internally and treated. The user should not be able to see the error.

update : 26-04-2017
ORA-10633

ORA-10633 - No space found in the segment
ORA-10633 - No space found in the segment

  • ora-00956 : missing or invalid auditing option
  • ora-33084 : (XSAGDNGL42) In AGGMAP workspace object, you cannot qualify the dimensioned valueset workspace object.
  • ora-01120 : cannot remove online database file string
  • ora-31225 : DBMS_LDAP: invalid BER_ELEMENT
  • ora-16128 : User initiated stop apply successfully completed
  • ora-28365 : wallet is not open
  • ora-30367 : a JOIN KEY clause is required
  • ora-12556 : TNS:no caller
  • ora-06763 : TLI Driver: error sending disconnect
  • ora-00953 : missing or invalid index name
  • ora-07404 : sfareq: Timeout occurred waiting for request to complete.
  • ora-14611 : Duplicate subpartition name string in template
  • ora-32151 : Environment not specified
  • ora-32403 : cannot use new values from mv log on "string"."string"
  • ora-39003 : unable to get count of total workers alive
  • ora-31476 : a change table data column is missing from the source table
  • ora-10635 : Invalid segment or tablespace type
  • ora-28173 : certificate not provided by proxy
  • ora-19675 : file string was modified during proxy copy
  • ora-31502 : invalid number supplied for supplemental_processes
  • ora-10641 : Cannot find a rollback segment to bind to
  • ora-23423 : job number string is not positive
  • ora-07477 : scgcmn: lock manager not initialized.
  • ora-26080 : file "string" is not part of table string.string partition string
  • ora-16643 : unable to determine location of broker configuration files
  • ora-29868 : cannot issue DDL on a domain index marked as LOADING
  • ora-08429 : raw data has invalid digit in display type data
  • ora-16754 : resource guard could not activate standby database
  • ora-01208 : data file is an old version - not accessing current version
  • ora-00981 : cannot mix table and system auditing options
  • 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.