FETCH ALL DATAFILES WITH TABLESPACE NAME:
-----------------------------------------
col tablespace_name format a16;
col file_name format a36;
SELECT TABLESPACE_NAME, FILE_NAME, BYTES FROM DBA_DATA_FILES;
FETCH DATAFILES AVAILABLE IN TABLESPACE:
----------------------------------------
select file_name from dba_data_files where tablespace_name='PSIMAGE';
FILE_NAME
--------------------------------------------------------------------------------
+ORA_DB/hrprd/datafile/psimage.221.81503
+ORA_DB/hrprd/datafile/psimage.450.97645
+ORA_DB/hrprd/datafile/psimage.589.94091
FETCH DATAFILE SPACE, MAXIMUM SPACE, AUTOEXTEND OF DATAFILE:
-----------------------------------------------------------
set linesize 124
col file_name format a60
col AUTOEXTENSIBLE format a18
SELECT FILE_NAME, BYTES/(1024*1024), MAXBYTES/(1024*1024), AUTOEXTENSIBLE from DBA_DATA_FILES
WHERE TABLESPACE_NAME='PSIMAGE';
FILE_NAME BYTES/(1024*1024) MAXBYTES/(1024*1024) AUTOEXTENSIBLE
--------------------------------- ----------------- -------------------- ------------------
/u01/oradata/hrdemo/psimage.dbf 1813 32767.9844 YES
No comments:
Post a Comment