Respuesta: CONSULTA DE redolog/control/data files para clasificarlos:
Código:
SELECT 'DATAFILE', SUBSTR(FILE_NAME,1,100) AS NAME, STATUS
FROM DBA_DATA_FILES
UNION ALL
SELECT 'LOGFILE', SUBSTR(MEMBER,1,100) AS NAME, STATUS
FROM v$LOGFILE
UNION ALL
SELECT 'CONTROLFILE', SUBSTR(NAME,1,100) AS NAME, STATUS
FROM v$CONTROLFILE
__________________ Blogzote.com :-) Mi blog |