hi,
What are extents and segments?
An extent is a connected area of a data file that is exclusively assigned to a segment.
A segment consists of one or more extents and contains the physical data.
Segments can have different types that more or less correlate with certain object types. The most important types are CLUSTER, INDEX, INDEX PARTITION, LOBINDEX, LOBSEGMENT, ROLLBACK, TABLE, TABLE PARTITION and TYPE2 UNDO.
If there is no more free space available for a new extent to be allocated, and if the automatic data file enhancement is not activated by AUTOALLOCATE, the current transaction terminates and the system issues an error message. If this is an SAP update transaction, the SAP system update is deactivated
Regards,
Suraj
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.