Minimal size of extent allocated in tablespace. You can change it by
alter tablespace XXXX minimum extent XXXXX;=20
> -----Urspr=FCngliche Nachricht-----
> Von: Sandeep Kurliye [SMTP:Sandeep.Kurliye_at_almarai.com]
> Gesendet am: Mittwoch, 9. August 2000 10:05
> An: Multiple recipients of list ORACLE-L
> Betreff: DBA_TABLESPACES - MIN_EXTLEN
>=20
>=20
> Hi Gurus,
>=20
> Can anyone tell me the significance of Min_Extlen field in
> DBA_TABLESPACES.
>=20
> SQL> ;
> 1 SELECT tablespace_name, initial_extent, next_extent,
> 2 max_extents, pct_increase, min_extlen
> 3* FROM dba_tablespaces
> ORACLE - SQL> /
>=20
> TABLESPACE_NAME INITIAL_EXTENT NEXT_EXTENT MAX_EXTENTS =
PCT_INCREASE
> MIN_EXTLEN =20
> ------------------------------ -------------- =
> ---------- ------------ ----------
>=20
> SYSTEM 10240 10240 =
121
> 50 0 =20
> USER_DATA 10240 10240 =
121
> 50 0 =20
> ROLLBACK_DATA 10240 10240 121
> 50 0 =20
> TEMPORARY_DATA 10240 10240 121
> 50 0 =20
> TS_DATA 10240 10240 =
121
> 50 0 =20
> TS_INDEX 10240 10240 =
121
> 50 0 =20
> TS_TMP 10240 10240 =
121
> 50 0 =20
> TS_RBS 10240 10240 =
121
> 50 0 =20
> 10 rows selected.
> --=20
> Author: Sandeep Kurliye
> INET: Sandeep.Kurliye_at_almarai.com
>=20
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing =
Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Wed Aug 09 2000 - 03:01:05 CDT
