eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

VIEW: SYS.USER_DBFS_HS_FILES

Source

View Text - Preformatted


SELECT APT.path, SF.SequenceNumber, SF.StartOffset, SF.EndOffset, SF.TarballId, BF.BackupFileName, BF.TarStartOffset, BF.TarEndOffset FROM DBFS_HS$_SFLocatorTable SF, DBFS_HS$_ContentFnMapTbl MP, DBFS_HS$_StoreId2PolicyCtx PC, DBFS_HS$_BackupFileTable BF, TABLE(dbms_dbfs_hs.listcontentfilename) APT WHERE MP.ArchiveRefId = SF.ArchiveRefId AND PC.StoreId = BF.StoreId AND BF.TarballId = SF.TarballId AND APT.contentfilename = MP.ContentFilename

View Text - HTML Formatted

SELECT APT.PATH
, SF.SEQUENCENUMBER
, SF.STARTOFFSET
, SF.ENDOFFSET
, SF.TARBALLID
, BF.BACKUPFILENAME
, BF.TARSTARTOFFSET
, BF.TARENDOFFSET
FROM DBFS_HS$_SFLOCATORTABLE SF
, DBFS_HS$_CONTENTFNMAPTBL MP
, DBFS_HS$_STOREID2POLICYCTX PC
, DBFS_HS$_BACKUPFILETABLE BF
, TABLE(DBMS_DBFS_HS.LISTCONTENTFILENAME) APT
WHERE MP.ARCHIVEREFID = SF.ARCHIVEREFID
AND PC.STOREID = BF.STOREID
AND BF.TARBALLID = SF.TARBALLID
AND APT.CONTENTFILENAME = MP.CONTENTFILENAME