| Query for table spaces [message #227] |
Wed, 30 January 2002 01:46  |
marjo
Messages: 9
Registered: January 2002
|
Junior Member |
|
|
Hello all!
In which table do I find the table spaces, data files and sizes of the table spaces.
Thank you in advance if you reply to this!
Marjo
|
|
|
|
|
|
| Re: Query for table spaces [message #282 is a reply to message #227] |
Sun, 03 February 2002 18:55  |
Abul Fazal
Messages: 39
Registered: February 2002
|
Member |
|
|
U should have DBA privileges to execute the following queries
Select tablespace_name,
(sum(bytes)/1024/1024)||'MB' "FREE SPACE"
from dba_free_space
where tablespace_name =
Group by tablespace_name
order by 1
Select tablespace_name,
(sum(bytes)/1024/1024)||'MB' "FREE SPACE"
from dba_free_space
where tablespace_name =
Group by tablespace_name
order by 1
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
