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 : 24-05-2017

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

  • ora-00151 : invalid transaction ID
  • ora-12643 : Client received internal error from server
  • ora-14630 : subpartition resides in offlined tablespace
  • ora-00278 : log file 'string' no longer needed for this recovery
  • ora-19999 : skip_row procedure was called
  • ora-08467 : error converting Oracle number to string
  • ora-14045 : only one partition may be modified
  • ora-01631 : max # extents (string) reached in table string.string
  • ora-30752 : column or table string is not substitutable
  • ora-14254 : cannot specify ALLOCATE STORAGE for a (Composite) Range or List partitioned table
  • ora-12422 : max policies exceeded
  • ora-32613 : not a MODEL cell
  • ora-34871 : (PERMIT06) Session-only value 'value' of workspace object has been deleted because a PERMIT change has revealed a duplicate value.
  • ora-08457 : syntax error in SEPARATE CHARACTER option of SIGN clause
  • ora-13261 : geometry table string does not exist
  • ora-02142 : missing or invalid ALTER TABLESPACE option
  • ora-22295 : cannot bind more than 4000 bytes data to LOB and LONG columns in 1 statement
  • ora-00391 : All threads must switch to new log format at the same time
  • ora-30379 : query txt not specified
  • ora-24080 : unschedule_propagation pending for QUEUE string and DESTINATION string
  • ora-00368 : checksum error in redo log block
  • ora-12156 : TNS:tried to reset line from incorrect state
  • ora-14283 : UNIQUE constraints mismatch in ALTER TABLE EXCHANGE SUBPARTITION
  • ora-24274 : no row exists in the string table for these parameters
  • ora-36846 : (XSLMGEN16) AW name is greater than 30 bytes
  • ora-01282 : date range specified is invalid
  • ora-01111 : name for data file string is unknown - rename to correct file
  • ora-32503 : Mapping SGA from file failed
  • ora-01609 : log string is the current log for thread string - cannot drop members
  • 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.
  • 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.