DBA Data[Home] [Help]

VIEW: SYS.DBA_EXP_FILES

Source

View Text - Preformatted

select o.expid, decode(o.exptype, 'X', 'COMPLETE', 'C', 'CUMULATIVE',
                                  'I', 'INCREMENTAL', 'UNDEFINED'),
       o.expfile, o.expuser, o.expdate
from sys.incfil o
View Text - HTML Formatted

SELECT O.EXPID
, DECODE(O.EXPTYPE
, 'X'
, 'COMPLETE'
, 'C'
, 'CUMULATIVE'
, 'I'
, 'INCREMENTAL'
, 'UNDEFINED')
, O.EXPFILE
, O.EXPUSER
, O.EXPDATE FROM SYS.INCFIL O