Monday, June 20, 2005

 

df_space.sql (need update)


select substr(file_name, 1, 40) file_name
, substr(tablespace_name, 1, 20) tablespace
, bytes / 1024 / 1024 Meg
, blocks
, autoextensible
, maxbytes
, increment_by
from dba_data_files
/

This page is powered by Blogger. Isn't yours?