Database Files that constitute a Database Instance

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

REM
REM
REM || Title : show_instance_files.sql
REM ||
REM || Purpose : Script that displays files that constitute a database.
REM ||
REM || Release No : 1
REM ||
REM || Variables : None
REM ||
REM || Schema : system
REM ||
REM ||
REM


SELECT SUBSTR (name, 1, 55)
FROM v$datafile
UNION
SELECT SUBSTR (member, 1, 55)
FROM v$logfile
UNION
SELECT SUBSTR (name, 1, 55)
FROM v$controlfile

 

SPOOL show_instance_files.lst
/
SPOOL OFF

SET SERVEROUTPUT ON
SET ECHO OFF
SET FEEDBACK OFF
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.