Re: Newbie question, on reindexing tables

Here are the queries, thanks!!!
Eduard
info_at_edrox.demon.nl

=========QUERY 1

SQL> select * from dba_free_space;

TABLESPACE_NAME                  FILE_ID  BLOCK_ID     BYTES    BLOCKS

------------------------------ --------- --------- --------- --------- -----
-------
SYSTEM                                 1     29850    184320        90
1
SYSTEM                                 1     30185   1097728       536
1
USER_DATA                              2       757   1597440       780
2
ROLLBACK_DATA                          3       927    256000       125
3
ROLLBACK_DATA                          3       477    256000       125
3
ROLLBACK_DATA                          3      2777  10043392      4904
3
ROLLBACK_DATA                          3       177    256000       125
3
TEMPORARY_DATA                         4         2   2095104      1023
4
NSTVO                                  5      1102  50173952     24499
5
NSTLOC                                 6      1105  50167808     24496
6
NSTCATIDX                              7       387  51638272     25214
7
NSINDX                                 8      8437  35151872     17164
8
NSINDX                                 8       177    143360        70
8
ODOCTEMP                               9         2  10483712      5119
9
NSTWFPROCINST                         10      1592  49170432     24009
10
NSTWFPROCESS                          11      1737  48873472     23864

16 rows selected.

SQL>
=========QUERY 2
SQL> select tablespace_name, max_extents   2 from dba_tablespaces
  3 where tablespace_name like 'NST%';

TABLESPACE_NAME                MAX_EXTENTS
------------------------------ -----------
NSTCATIDX                        2.147E+09
NSTLOC                           2.147E+09
NSTVO                            2.147E+09
NSTWFPROCESS                     2.147E+09
NSTWFPROCINST                    2.147E+09

SQL> Received on Thu Dec 06 2001 - 17:43:50 CST