Code:
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production

lsc@LNX920-RAC1>
lsc@LNX920-RAC1>select tablespace_name, extent_management from dba_tablespaces;


TABLESPACE_NAME                EXTENT_MAN
------------------------------ ----------
SYSTEM                         LOCAL
UNDOTBS1                       LOCAL
TEMP                           LOCAL
DRSYS                          LOCAL
EXAMPLE                        LOCAL
INDX                           LOCAL
TOOLS                          LOCAL
USERS                          LOCAL
XDB                            LOCAL