SELECT
lf.parentobj#,
lf.ts#,
lf.fragobj#,
row_number() OVER
(partition by lf.parentobj# order by lf.frag#) - 1,
lf.tabfragobj#
FROM sys.lobfrag$ lf
SELECT
LF.PARENTOBJ#
,
LF.TS#
,
LF.FRAGOBJ#
,
ROW_NUMBER() OVER
(PARTITION BY LF.PARENTOBJ# ORDER BY LF.FRAG#) - 1
,
LF.TABFRAGOBJ#
FROM SYS.LOBFRAG$ LF
|
|
|