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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment