VIEW: SYS.KU$_FILE_VIEW

Source

View Text - Preformatted

select  substrb(fn.fnnam, -(least(lengthb(fn.fnnam),923)), 923),
                replace(fn.fnnam, '''', ''''''),
                f.blocks, fh.fhfsz, f.maxextend, f.inc, f.ts#,
                sys.dbms_metadata_util.is_omf(
                  substrb(fn.fnnam, -(least(lengthb(fn.fnnam),923)), 923))
        from    sys.x$kccfn fn, sys.file$ f, x$kcvfh fh
        where   f.file# = fn.fnfno AND
                fn.fnnam IS NOT NULL AND
                fn.fnfno = fh.hxfil AND
                fn.fntyp = 4 AND                     /* For data files */
                f.spare1 is NULL
      union all
        select  substrb(fn.fnnam, -(least(lengthb(fn.fnnam),923)), 923),
                replace (fn.fnnam, '''', ''''''),
                f.blocks,
                DECODE(hc.ktfbhccval, 0, hc.ktfbhcsz, NULL),
                DECODE(hc.ktfbhccval, 0, hc.ktfbhcmaxsz, NULL),
                DECODE(hc.ktfbhccval, 0, hc.ktfbhcinc, NULL),
                ts.ts#,
                sys.dbms_metadata_util.is_omf(
                  substrb(fn.fnnam, -(least(lengthb(fn.fnnam),923)), 923))
        FROM    sys.x$kccfn fn, sys.file$ f, sys.x$ktfbhc hc, sys.ts$ ts
        WHERE   fn.fnfno = f.file# AND
                fn.fntyp = 4 AND                         /* For data files */
                fn.fnnam IS NOT NULL AND
                f.spare1 is NOT NULL AND
                fn.fnfno = hc.ktfbhcafno AND
                hc.ktfbhctsn = ts.ts#
      union all
        select                                       /*+ ordered use_nl(hc) +*/
                substrb(fn.fnnam, -(least(lengthb(fn.fnnam),923)), 923),
                replace (fn.fnnam, '''', ''''''),
                DECODE(hc.ktfthccval, 0, hc.ktfthcsz, -1),
                DECODE(hc.ktfthccval, 0, hc.ktfthcsz, -1),
                DECODE(hc.ktfthccval, 0, hc.ktfthcmaxsz, NULL),
                DECODE(hc.ktfthccval, 0, hc.ktfthcinc, NULL),
                ts.ts#,
                sys.dbms_metadata_util.is_omf(
                  substrb(fn.fnnam, -(least(lengthb(fn.fnnam),923)), 923))
        FROM    sys.x$kccfn fn, sys.x$ktfthc hc, sys.ts$ ts
        WHERE   fn.fntyp = 7 AND
                fn.fnnam IS NOT NULL AND
                fn.fnfno = hc.ktfthctfno AND
                hc.ktfthctsn(+) = ts.ts#

View Text - HTML Formatted

SELECT SUBSTRB(FN.FNNAM
, -(LEAST(LENGTHB(FN.FNNAM)
, 923))
, 923)
, REPLACE(FN.FNNAM
, ''''
, '''''')
, F.BLOCKS
, FH.FHFSZ
, F.MAXEXTEND
, F.INC
, F.TS#
, SYS.DBMS_METADATA_UTIL.IS_OMF( SUBSTRB(FN.FNNAM
, -(LEAST(LENGTHB(FN.FNNAM)
, 923))
, 923))
FROM SYS.X$KCCFN FN
, SYS.FILE$ F
, X$KCVFH FH
WHERE F.FILE# = FN.FNFNO AND FN.FNNAM IS NOT NULL AND FN.FNFNO = FH.HXFIL AND FN.FNTYP = 4
AND /* FOR DATA FILES */ F.SPARE1 IS NULL UNION ALL SELECT SUBSTRB(FN.FNNAM
, -(LEAST(LENGTHB(FN.FNNAM)
, 923))
, 923)
, REPLACE (FN.FNNAM
, ''''
, '''''')
, F.BLOCKS
, DECODE(HC.KTFBHCCVAL
, 0
, HC.KTFBHCSZ
, NULL)
, DECODE(HC.KTFBHCCVAL
, 0
, HC.KTFBHCMAXSZ
, NULL)
, DECODE(HC.KTFBHCCVAL
, 0
, HC.KTFBHCINC
, NULL)
, TS.TS#
, SYS.DBMS_METADATA_UTIL.IS_OMF( SUBSTRB(FN.FNNAM
, -(LEAST(LENGTHB(FN.FNNAM)
, 923))
, 923))
FROM SYS.X$KCCFN FN
, SYS.FILE$ F
, SYS.X$KTFBHC HC
, SYS.TS$ TS
WHERE FN.FNFNO = F.FILE# AND FN.FNTYP = 4
AND /* FOR DATA FILES */ FN.FNNAM IS NOT NULL AND F.SPARE1 IS NOT NULL AND FN.FNFNO = HC.KTFBHCAFNO AND HC.KTFBHCTSN = TS.TS# UNION ALL SELECT /*+ ORDERED USE_NL(HC) +*/ SUBSTRB(FN.FNNAM
, -(LEAST(LENGTHB(FN.FNNAM)
, 923))
, 923)
, REPLACE (FN.FNNAM
, ''''
, '''''')
, DECODE(HC.KTFTHCCVAL
, 0
, HC.KTFTHCSZ
, -1)
, DECODE(HC.KTFTHCCVAL
, 0
, HC.KTFTHCSZ
, -1)
, DECODE(HC.KTFTHCCVAL
, 0
, HC.KTFTHCMAXSZ
, NULL)
, DECODE(HC.KTFTHCCVAL
, 0
, HC.KTFTHCINC
, NULL)
, TS.TS#
, SYS.DBMS_METADATA_UTIL.IS_OMF( SUBSTRB(FN.FNNAM
, -(LEAST(LENGTHB(FN.FNNAM)
, 923))
, 923))
FROM SYS.X$KCCFN FN
, SYS.X$KTFTHC HC
, SYS.TS$ TS
WHERE FN.FNTYP = 7 AND FN.FNNAM IS NOT NULL AND FN.FNFNO = HC.KTFTHCTFNO AND HC.KTFTHCTSN(+) = TS.TS#