Oracle Database Administration
Learn Oracle Database Administration Online
16 June 2010
determine the datafile names for a tablespace
select FILE_NAME,
(BYTES/1024)/1024 as "SIZE (MB)",
(MAXBYTES/1024)/1024 as "MAXSIZE (MB)"
from dba_data_files
where tablespace_name='&1';
No comments:
Post a Comment
‹
›
Home
View web version
No comments:
Post a Comment