SQL for determine free space in tablespaces / files
From: Johan Nilsson <jni_at_esrange.ssc.se.--->
Date: 1998/04/01
Message-ID: <35221540.0_at_d2o19.telia.com>#1/1
If replying by e-mail, please remove the spam protection '.---' from the end of my return address. Received on Wed Apr 01 1998 - 00:00:00 CEST
Date: 1998/04/01
Message-ID: <35221540.0_at_d2o19.telia.com>#1/1
Hi,
I'd be grateful if anyone could help me out on how to query the database for information like :
- Tablespaces in database
- Datafiles in tablespaces
- Tables in tablespaces
- Max size of tablespace / current usage total / usage per table
- Max size of datafiles / current usage
Platform is Oracle Workgroup Server 7.3 on Win NT 4.0. SQL samples are appreciated, or any hints on where to find them.
T.I.A. // Johan
If replying by e-mail, please remove the spam protection '.---' from the end of my return address. Received on Wed Apr 01 1998 - 00:00:00 CEST