Datafiles that have been Allocated.

SET SERVEROUTPUT ON
SET ECHO OFF
SET FEEDBACK OFF
SET PAGES 80
SET LINES 132

REM
REM
REM || Title : show_data_files.sql
REM ||
REM || Purpose : Script All Displays all data files that have been allocated
REM ||
REM || Release No : 1
REM ||
REM || Variables : None
REM ||
REM || Schema : system
REM ||
REM


COL tablespace_name FORMAT A15 HEADING 'Tablespace|Name' JUSTIFY L
COL file_name FORMAT A50 HEADING 'Filename' JUSTIFY L
COL mbytes FORMAT 999,999 HEADING 'Size Mb' JUSTIFY L
COL file_id FORMAT 999,999 HEADING 'File id' JUSTIFY L

SELECT tablespace_name,
file_name,
file_id,
(bytes/1024/1024) mbytes,
status,
autoextensible
FROM dba_data_files
ORDER BY 1,3

SPOOL show_data_files.lis
/
SPOOL OFF


SET FEEDBACK ON
SET PAGES 60
CLEAR BREAKS
CLEAR COL
This script is provided for educational purposes only. The script has been tested and appears to work as intended. However, you should always test any script before relying on it. No responsibility will be accepted for Lost or damage that may occur from it's use.