/ Liren Large Software Subsidy 5 / 05.iso / a / a522 / 21.ddi / DBS1.OR3

< prev

next >

MacOS 8.1

Win98

DOS

view JSON data

view as text

+--------+-------------------------+-------------------------+--------+--------+
|00000000| 73 79 73 2e 73 79 6e 24 | 20 74 2c 20 73 79 73 2e |sys.syn$| t, sys.|
|00000010| 75 73 65 72 24 20 75 0a | 77 68 65 72 65 20 73 2e |user$ u.|where s.|
|00000020| 6f 62 6a 23 20 3d 20 74 | 2e 6f 62 6a 23 0a 61 6e |obj# = t|.obj#.an|
|00000030| 64 20 73 2e 74 79 70 65 | 20 3d 20 35 0a 61 6e 64 |d s.type| = 5.and|
|00000040| 20 6f 74 2e 6e 61 6d 65 | 20 3d 20 74 2e 6e 61 6d | ot.name| = t.nam|
|00000050| 65 0a 61 6e 64 20 74 2e | 6f 77 6e 65 72 20 3d 20 |e.and t.|owner = |
|00000060| 75 2e 6e 61 6d 65 0a 61 | 6e 64 20 6f 74 2e 6f 77 |u.name.a|nd ot.ow|
|00000070| 6e 65 72 23 20 3d 20 75 | 2e 75 73 65 72 23 0a 61 |ner# = u|.user#.a|
|00000080| 6e 64 20 73 2e 6f 77 6e | 65 72 23 20 69 6e 20 28 |nd s.own|er# in (|
|00000090| 31 2c 75 69 64 29 0a 61 | 6e 64 20 74 2e 6e 6f 64 |1,uid).a|nd t.nod|
|000000a0| 65 20 69 73 20 6e 75 6c | 6c 0a 75 6e 69 6f 6e 0a |e is nul|l.union.|
|000000b0| 73 65 6c 65 63 74 20 73 | 2e 6e 61 6d 65 2c 20 64 |select s|.name, d|
|000000c0| 65 63 6f 64 65 28 73 2e | 6f 77 6e 65 72 23 2c 20 |ecode(s.|owner#, |
|000000d0| 31 2c 20 27 50 55 42 4c | 49 43 27 2c 20 27 50 52 |1, 'PUBL|IC', 'PR|
|000000e0| 49 56 41 54 45 27 29 2c | 0a 74 2e 6f 77 6e 65 72 |IVATE'),|.t.owner|
|000000f0| 2c 20 74 2e 6e 61 6d 65 | 2c 20 74 2e 6e 6f 64 65 |, t.name|, t.node|
|00000100| 2c 20 27 52 45 4d 4f 54 | 45 27 0a 66 72 6f 6d 20 |, 'REMOT|E'.from |
|00000110| 20 73 79 73 2e 6f 62 6a | 24 20 73 2c 20 73 79 73 | sys.obj|$ s, sys|
|00000120| 2e 73 79 6e 24 20 74 0a | 77 68 65 72 65 20 73 2e |.syn$ t.|where s.|
|00000130| 6f 62 6a 23 20 3d 20 74 | 2e 6f 62 6a 23 0a 61 6e |obj# = t|.obj#.an|
|00000140| 64 20 73 2e 74 79 70 65 | 20 3d 20 35 0a 61 6e 64 |d s.type| = 5.and|
|00000150| 20 73 2e 6f 77 6e 65 72 | 23 20 69 6e 20 28 31 2c | s.owner|# in (1,|
|00000160| 20 75 69 64 29 0a 61 6e | 64 20 74 2e 6e 6f 64 65 | uid).an|d t.node|
|00000170| 20 69 73 20 6e 6f 74 20 | 6e 75 6c 6c 0a 3c 01 05 | is not |null.<..|
|00000180| 03 c2 04 12 18 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |.....---|--------|
|00000190| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 02 c1 06 |--------|-----...|
|000001a0| 02 c1 59 58 73 65 6c 65 | 63 74 20 73 6e 61 6d 65 |..YXsele|ct sname|
|000001b0| 2c 20 63 72 65 61 74 6f | 72 2c 20 74 6e 61 6d 65 |, creato|r, tname|
|000001c0| 2c 20 64 61 74 61 62 61 | 73 65 2c 20 74 61 62 74 |, databa|se, tabt|
|000001d0| 79 70 65 0a 66 72 6f 6d | 20 20 73 79 6e 6f 6e 79 |ype.from|  synony|
|000001e0| 6d 73 0a 77 68 65 72 65 | 20 73 79 6e 74 79 70 65 |ms.where| syntype|
|000001f0| 20 3d 20 27 50 55 42 4c | 49 43 27 0a 12 00 8e 0c | = 'PUBL|IC'.....|
|00000200| 06 01 00 00 de 04 00 01 | 8e 0c 00 00 0a 00 00 00 |........|........|
|00000210| 00 00 00 00 01 00 94 02 | 00 01 52 08 00 00 00 00 |........|..R.....|
|00000220| 01 00 00 00 00 00 00 00 | 00 00 0c 00 4b 00 00 00 |........|....K...|
|00000230| 45 00 00 01 07 00 05 02 | 00 80 00 00 52 08 00 00 |E.......|....R...|
|00000240| 00 01 03 00 ff ff 18 00 | 16 01 fe 00 fe 00 00 00 |........|........|
|00000250| 03 00 53 02 b7 01 16 01 | 00 00 00 00 00 00 00 00 |..S.....|........|
|00000260| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000270| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000280| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000290| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000002a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000002b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000002c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000002d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000002e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000002f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000300| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000310| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000320| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000330| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000340| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000350| 00 00 00 00 00 00 2c 00 | 05 03 c2 04 17 18 2d 2d |......,.|......--|
|00000360| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|00000370| 2d 2d 2d 2d 2d 2d 02 c1 | 06 03 c2 02 16 79 73 65 |------..|.....yse|
|00000380| 6c 65 63 74 20 74 6e 61 | 6d 65 2c 20 6d 61 78 28 |lect tna|me, max(|
|00000390| 64 5f 62 6c 6b 73 29 2c | 20 6d 61 78 28 64 5f 65 |d_blks),| max(d_e|
|000003a0| 78 74 73 29 2c 20 73 75 | 6d 28 69 5f 62 6c 6b 73 |xts), su|m(i_blks|
|000003b0| 29 2c 20 73 75 6d 28 69 | 5f 65 78 74 73 29 0a 66 |), sum(i|_exts).f|
|000003c0| 72 6f 6d 20 73 79 73 74 | 61 62 61 6c 6c 6f 63 5f |rom syst|aballoc_|
|000003d0| 0a 77 68 65 72 65 20 20 | 63 72 65 61 74 6f 72 69 |.where  |creatori|
|000003e0| 64 20 3d 20 75 69 64 0a | 67 72 6f 75 70 20 62 79 |d = uid.|group by|
|000003f0| 20 74 6e 61 6d 65 0a 2c | 00 05 03 c2 04 16 18 2d | tname.,|.......-|
|00000400| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|00000410| 2d 2d 2d 2d 2d 2d 2d 02 | c1 07 03 c2 02 11 74 73 |-------.|......ts|
|00000420| 65 6c 65 63 74 20 63 72 | 65 61 74 6f 72 2c 20 74 |elect cr|eator, t|
|00000430| 6e 61 6d 65 2c 20 6d 61 | 78 28 64 5f 62 6c 6b 73 |name, ma|x(d_blks|
|00000440| 29 2c 20 6d 61 78 28 64 | 5f 65 78 74 73 29 2c 20 |), max(d|_exts), |
|00000450| 73 75 6d 28 69 5f 62 6c | 6b 73 29 2c 20 73 75 6d |sum(i_bl|ks), sum|
|00000460| 28 69 5f 65 78 74 73 29 | 0a 66 72 6f 6d 20 73 79 |(i_exts)|.from sy|
|00000470| 73 74 61 62 61 6c 6c 6f | 63 5f 0a 67 72 6f 75 70 |staballo|c_.group|
|00000480| 20 62 79 20 63 72 65 61 | 74 6f 72 2c 20 74 6e 61 | by crea|tor, tna|
|00000490| 6d 65 0a 2c 00 05 03 c2 | 04 15 18 2d 2d 2d 2d 2d |me.,....|...-----|
|000004a0| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|000004b0| 2d 2d 2d 02 c1 08 03 c2 | 04 14 fe 3f 01 73 65 6c |---.....|...?.sel|
|000004c0| 65 63 74 0a 75 2e 6e 61 | 6d 65 2c 20 6f 2e 6f 77 |ect.u.na|me, o.ow|
|000004d0| 6e 65 72 23 2c 20 6f 2e | 6e 61 6d 65 2c 20 64 2e |ner#, o.|name, d.|
|000004e0| 62 6c 6f 63 6b 73 2c 20 | 64 2e 65 78 74 65 6e 74 |blocks, |d.extent|
|000004f0| 73 2c 20 69 2e 62 6c 6f | 63 6b 73 2c 20 69 2e 65 |s, i.blo|cks, i.e|
|00000500| 78 74 65 6e 74 73 0a 66 | 72 6f 6d 20 73 79 73 2e |xtents.f|rom sys.|
|00000510| 75 73 65 72 24 20 75 2c | 20 73 79 73 2e 6f 62 6a |user$ u,| sys.obj|
|00000520| 24 20 6f 2c 20 73 79 73 | 2e 74 61 62 24 20 74 2c |$ o, sys|.tab$ t,|
|00000530| 20 73 79 73 2e 69 6e 64 | 24 20 78 2c 20 73 79 73 | sys.ind|$ x, sys|
|00000540| 2e 73 65 67 24 20 64 2c | 20 73 79 73 2e 73 65 67 |.seg$ d,| sys.seg|
|00000550| 24 20 69 0a 77 68 65 72 | 65 20 74 2e 6f 62 6a 23 |$ i.wher|e t.obj#|
|00000560| 20 3d 20 6f 2e 6f 62 6a | 23 0a 61 6e 64 20 6f 2e | = o.obj|#.and o.|
|00000570| 6f 77 6e 65 72 23 20 3d | 20 75 2e 75 73 65 72 23 |owner# =| u.user#|
|00000580| 0a 61 6e 64 20 74 2e 66 | 69 6c 65 23 20 3d 20 64 |.and t.f|ile# = d|
|00000590| 2e 66 69 6c 65 23 0a 61 | 6e 64 20 74 2e 62 6c 6f |.file#.a|nd t.blo|
|000005a0| 63 6b 23 20 3d 20 64 2e | 62 6c 6f 63 6b 23 0a 61 |ck# = d.|block#.a|
|000005b0| 6e 64 20 78 2e 62 6f 23 | 20 28 2b 29 20 3d 20 74 |nd x.bo#| (+) = t|
|000005c0| 2e 6f 62 6a 23 0a 61 6e | 64 20 78 2e 66 69 6c 65 |.obj#.an|d x.file|
|000005d0| 23 20 3d 20 69 2e 66 69 | 6c 65 23 20 28 2b 29 0a |# = i.fi|le# (+).|
|000005e0| 61 6e 64 20 78 2e 62 6c | 6f 63 6b 23 20 3d 20 69 |and x.bl|ock# = i|
|000005f0| 2e 62 6c 6f 63 6b 23 20 | 28 2b 29 0a 0a 00 8e 0c |.block# |(+).....|
|00000600| 06 01 00 00 df 04 00 01 | 8e 0c 00 00 0b 00 00 00 |........|........|
|00000610| 00 00 00 00 01 00 94 02 | 00 01 63 08 00 00 00 00 |........|..c.....|
|00000620| 01 00 00 00 00 00 00 00 | 00 00 04 00 4c 00 00 00 |........|....L...|
|00000630| 56 00 00 01 07 00 02 02 | 00 80 00 00 63 08 00 00 |V.......|....c...|
|00000640| 00 01 04 00 ff ff 1a 00 | 99 00 7f 00 7f 00 00 00 |........|........|
|00000650| 04 00 a6 02 aa 01 1d 01 | 99 00 00 00 00 00 00 00 |........|........|
|00000660| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000670| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000680| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000690| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000006a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000006b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000006c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000006d0| 00 00 00 00 00 00 00 00 | 00 2c 00 05 03 c2 04 1b |........|.,......|
|000006e0| 18 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |.-------|--------|
|000006f0| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 02 c1 05 02 c1 5e 5d |--------|-.....^]|
|00000700| 73 65 6c 65 63 74 20 74 | 73 2e 6e 61 6d 65 2c 20 |select t|s.name, |
|00000710| 66 2e 66 69 6c 65 23 2c | 20 66 2e 62 6c 6f 63 6b |f.file#,| f.block|
|00000720| 23 2c 20 66 2e 6c 65 6e | 67 74 68 0a 66 72 6f 6d |#, f.len|gth.from|
|00000730| 20 73 79 73 2e 74 73 24 | 20 74 73 2c 20 73 79 73 | sys.ts$| ts, sys|
|00000740| 2e 66 65 74 24 20 66 0a | 77 68 65 72 65 20 66 2e |.fet$ f.|where f.|
|00000750| 74 73 23 20 3d 20 74 73 | 2e 74 73 23 0a 2c 00 05 |ts# = ts|.ts#.,..|
|00000760| 03 c2 04 1a 18 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |.....---|--------|
|00000770| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 02 c1 06 |--------|-----...|
|00000780| 03 c2 02 02 65 73 65 6c | 65 63 74 20 63 72 65 61 |....esel|ect crea|
|00000790| 74 6f 72 2c 20 6e 61 6d | 65 2c 20 74 79 70 65 2c |tor, nam|e, type,|
|000007a0| 20 73 75 6d 28 73 74 6f | 72 61 67 65 29 2c 20 73 | sum(sto|rage), s|
|000007b0| 75 6d 28 65 78 74 65 6e | 74 73 29 0a 66 72 6f 6d |um(exten|ts).from|
|000007c0| 20 73 79 73 73 74 6f 72 | 61 67 65 5f 0a 67 72 6f | sysstor|age_.gro|
|000007d0| 75 70 20 62 79 20 63 72 | 65 61 74 6f 72 2c 20 6e |up by cr|eator, n|
|000007e0| 61 6d 65 2c 20 74 79 70 | 65 0a 2c 00 05 03 c2 04 |ame, typ|e.,.....|
|000007f0| 19 18 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |..------|--------|
|00000800| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 02 c1 07 03 c2 03 |--------|--......|
|00000810| 0d d4 73 65 6c 65 63 74 | 20 75 2e 6e 61 6d 65 2c |..select| u.name,|
|00000820| 20 6f 2e 6f 77 6e 65 72 | 23 2c 20 6f 2e 6e 61 6d | o.owner|#, o.nam|
|00000830| 65 2c 20 73 6f 2e 74 79 | 70 65 2c 20 73 2e 62 6c |e, so.ty|pe, s.bl|
|00000840| 6f 63 6b 73 2c 20 73 2e | 65 78 74 65 6e 74 73 0a |ocks, s.|extents.|
|00000850| 66 72 6f 6d 20 20 73 79 | 73 2e 75 73 65 72 24 20 |from  sy|s.user$ |
|00000860| 75 2c 20 73 79 73 2e 73 | 65 67 24 20 73 2c 20 73 |u, sys.s|eg$ s, s|
|00000870| 79 73 2e 6f 62 6a 24 20 | 6f 2c 20 73 79 73 73 65 |ys.obj$ |o, sysse|
|00000880| 67 6f 62 6a 20 73 6f 0a | 77 68 65 72 65 20 75 2e |gobj so.|where u.|
|00000890| 75 73 65 72 23 20 3d 20 | 6f 2e 6f 77 6e 65 72 23 |user# = |o.owner#|
|000008a0| 0a 61 6e 64 20 6f 2e 6f | 62 6a 23 20 3d 20 73 6f |.and o.o|bj# = so|
|000008b0| 2e 6f 62 6a 23 0a 61 6e | 64 20 73 2e 66 69 6c 65 |.obj#.an|d s.file|
|000008c0| 23 20 3d 20 73 6f 2e 66 | 69 6c 65 23 0a 61 6e 64 |# = so.f|ile#.and|
|000008d0| 20 73 2e 62 6c 6f 63 6b | 23 20 3d 20 73 6f 2e 62 | s.block|# = so.b|
|000008e0| 6c 6f 63 6b 23 0a 2c 00 | 05 03 c2 04 18 18 2d 2d |lock#.,.|......--|
|000008f0| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|00000900| 2d 2d 2d 2d 2d 2d 02 c1 | 07 03 c2 03 27 ee 73 65 |------..|....'.se|
|00000910| 6c 65 63 74 20 6f 62 6a | 23 2c 20 66 69 6c 65 23 |lect obj|#, file#|
|00000920| 2c 20 62 6c 6f 63 6b 23 | 2c 20 27 54 41 42 4c 45 |, block#|, 'TABLE|
|00000930| 27 2c 20 70 63 74 66 72 | 65 65 24 2c 20 70 63 74 |', pctfr|ee$, pct|
|00000940| 75 73 65 64 24 20 66 72 | 6f 6d 20 73 79 73 2e 74 |used$ fr|om sys.t|
|00000950| 61 62 24 0a 75 6e 69 6f | 6e 0a 73 65 6c 65 63 74 |ab$.unio|n.select|
|00000960| 20 6f 62 6a 23 2c 20 66 | 69 6c 65 23 2c 20 62 6c | obj#, f|ile#, bl|
|00000970| 6f 63 6b 23 2c 20 27 43 | 4c 55 53 54 45 52 27 2c |ock#, 'C|LUSTER',|
|00000980| 20 70 63 74 66 72 65 65 | 24 2c 20 70 63 74 75 73 | pctfree|$, pctus|
|00000990| 65 64 24 20 66 72 6f 6d | 20 73 79 73 2e 63 6c 75 |ed$ from| sys.clu|
|000009a0| 24 0a 75 6e 69 6f 6e 0a | 73 65 6c 65 63 74 20 6f |$.union.|select o|
|000009b0| 62 6a 23 2c 20 66 69 6c | 65 23 2c 20 62 6c 6f 63 |bj#, fil|e#, bloc|
|000009c0| 6b 23 2c 20 27 49 4e 44 | 45 58 27 2c 20 74 6f 5f |k#, 'IND|EX', to_|
|000009d0| 6e 75 6d 62 65 72 28 6e | 75 6c 6c 29 2c 20 74 6f |number(n|ull), to|
|000009e0| 5f 6e 75 6d 62 65 72 28 | 6e 75 6c 6c 29 0a 66 72 |_number(|null).fr|
|000009f0| 6f 6d 20 73 79 73 2e 69 | 6e 64 24 0a 0b 00 8e 0c |om sys.i|nd$.....|
|00000a00| 06 01 00 00 e0 04 00 01 | 8e 0c 00 00 0d 00 00 00 |........|........|
|00000a10| 00 00 00 00 01 00 94 02 | 00 01 71 08 00 00 00 00 |........|..q.....|
|00000a20| 01 00 00 00 00 00 00 00 | 00 00 1c 00 63 00 00 00 |........|....c...|
|00000a30| 19 00 00 01 0b 00 08 02 | 01 00 79 00 00 00 00 00 |........|..y.....|
|00000a40| 00 01 04 00 ff ff 1a 00 | ec 00 d2 00 4d 01 00 00 |........|....M...|
|00000a50| 04 00 2a 03 d5 01 67 01 | ec 00 00 00 00 00 00 00 |..*...g.|........|
|00000a60| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000a70| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000a80| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000a90| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000aa0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000ab0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000ac0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000ad0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000ae0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000af0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000b00| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000b10| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000b20| 00 00 00 00 00 00 00 00 | 00 00 00 00 3c 01 05 03 |........|....<...|
|00000b30| c2 04 1f 18 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |....----|--------|
|00000b40| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 02 c1 06 02 |--------|----....|
|00000b50| c1 55 54 73 65 6c 65 63 | 74 20 6e 61 6d 65 2c 20 |.UTselec|t name, |
|00000b60| 74 79 70 65 2c 20 73 74 | 6f 72 61 67 65 2c 20 73 |type, st|orage, s|
|00000b70| 74 61 72 74 69 6e 67 2c | 20 65 6e 64 69 6e 67 0a |tarting,| ending.|
|00000b80| 66 72 6f 6d 20 73 79 73 | 65 78 74 65 6e 74 73 5f |from sys|extents_|
|00000b90| 0a 77 68 65 72 65 20 63 | 72 65 61 74 6f 72 69 64 |.where c|reatorid|
|00000ba0| 20 3d 20 75 69 64 0a 2c | 00 05 03 c2 04 1e 18 2d | = uid.,|.......-|
|00000bb0| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|00000bc0| 2d 2d 2d 2d 2d 2d 2d 02 | c1 07 02 c1 48 47 73 65 |-------.|....HGse|
|00000bd0| 6c 65 63 74 20 63 72 65 | 61 74 6f 72 2c 20 6e 61 |lect cre|ator, na|
|00000be0| 6d 65 2c 20 74 79 70 65 | 2c 20 73 74 6f 72 61 67 |me, type|, storag|
|00000bf0| 65 2c 20 73 74 61 72 74 | 69 6e 67 2c 20 65 6e 64 |e, start|ing, end|
|00000c00| 69 6e 67 0a 66 72 6f 6d | 20 73 79 73 65 78 74 65 |ing.from| sysexte|
|00000c10| 6e 74 73 5f 0a 2c 00 05 | 03 c2 04 1d 18 2d 2d 2d |nts_.,..|.....---|
|00000c20| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|00000c30| 2d 2d 2d 2d 2d 02 c1 08 | 02 c2 04 fe 2c 01 73 65 |-----...|....,.se|
|00000c40| 6c 65 63 74 20 75 2e 6e | 61 6d 65 2c 20 6f 2e 6f |lect u.n|ame, o.o|
|00000c50| 77 6e 65 72 23 2c 20 6f | 2e 6e 61 6d 65 2c 20 73 |wner#, o|.name, s|
|00000c60| 6f 2e 74 79 70 65 2c 20 | 65 2e 6c 65 6e 67 74 68 |o.type, |e.length|
|00000c70| 2c 20 65 2e 62 6c 6f 63 | 6b 23 2c 0a 65 2e 62 6c |, e.bloc|k#,.e.bl|
|00000c80| 6f 63 6b 23 2b 65 2e 6c | 65 6e 67 74 68 2d 31 0a |ock#+e.l|ength-1.|
|00000c90| 66 72 6f 6d 20 73 79 73 | 2e 75 65 74 24 20 65 2c |from sys|.uet$ e,|
|00000ca0| 20 73 79 73 2e 73 65 67 | 24 20 73 2c 20 73 79 73 | sys.seg|$ s, sys|
|00000cb0| 2e 75 73 65 72 24 20 75 | 2c 20 73 79 73 2e 6f 62 |.user$ u|, sys.ob|
|00000cc0| 6a 24 20 6f 2c 20 73 79 | 73 73 65 67 6f 62 6a 20 |j$ o, sy|ssegobj |
|00000cd0| 73 6f 0a 77 68 65 72 65 | 20 65 2e 73 65 67 66 69 |so.where| e.segfi|
|00000ce0| 6c 65 23 20 3d 20 73 2e | 66 69 6c 65 23 0a 61 6e |le# = s.|file#.an|
|00000cf0| 64 20 65 2e 73 65 67 62 | 6c 6f 63 6b 23 20 3d 20 |d e.segb|lock# = |
|00000d00| 73 2e 62 6c 6f 63 6b 23 | 0a 61 6e 64 20 73 2e 75 |s.block#|.and s.u|
|00000d10| 73 65 72 23 20 3d 20 75 | 2e 75 73 65 72 23 0a 61 |ser# = u|.user#.a|
|00000d20| 6e 64 20 65 2e 73 65 67 | 66 69 6c 65 23 20 3d 20 |nd e.seg|file# = |
|00000d30| 73 6f 2e 66 69 6c 65 23 | 0a 61 6e 64 20 65 2e 73 |so.file#|.and e.s|
|00000d40| 65 67 62 6c 6f 63 6b 23 | 20 3d 20 73 6f 2e 62 6c |egblock#| = so.bl|
|00000d50| 6f 63 6b 23 0a 61 6e 64 | 20 73 6f 2e 6f 62 6a 23 |ock#.and| so.obj#|
|00000d60| 20 3d 20 6f 2e 6f 62 6a | 23 0a 2c 00 05 03 c2 04 | = o.obj|#.,.....|
|00000d70| 1c 18 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |..------|--------|
|00000d80| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 02 c1 05 03 c2 02 |--------|--......|
|00000d90| 07 6a 73 65 6c 65 63 74 | 20 6e 61 6d 65 2c 20 74 |.jselect| name, t|
|00000da0| 79 70 65 2c 20 73 75 6d | 28 73 74 6f 72 61 67 65 |ype, sum|(storage|
|00000db0| 29 2c 20 73 75 6d 28 65 | 78 74 65 6e 74 73 29 0a |), sum(e|xtents).|
|00000dc0| 66 72 6f 6d 20 20 73 79 | 73 73 74 6f 72 61 67 65 |from  sy|sstorage|
|00000dd0| 5f 0a 77 68 65 72 65 20 | 63 72 65 61 74 6f 72 69 |_.where |creatori|
|00000de0| 64 20 3d 20 75 69 64 0a | 67 72 6f 75 70 20 62 79 |d = uid.|group by|
|00000df0| 20 6e 61 6d 65 2c 20 74 | 79 70 65 0a 0d 00 8e 0c | name, t|ype.....|
|00000e00| 06 01 00 00 e1 04 00 01 | 8e 0c 00 00 08 00 00 00 |........|........|
|00000e10| 00 00 00 00 01 00 94 02 | 00 01 7b 08 00 00 00 00 |........|..{.....|
|00000e20| 01 00 00 00 00 00 00 00 | 00 00 15 00 4c 00 00 00 |........|....L...|
|00000e30| 41 02 00 01 07 00 02 02 | 00 80 00 00 7b 08 00 00 |A.......|....{...|
|00000e40| 00 01 02 00 ff ff 16 00 | 99 00 83 00 83 00 00 00 |........|........|
|00000e50| 02 00 35 01 99 00 00 00 | 00 00 00 00 00 00 00 00 |..5.....|........|
|00000e60| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000e70| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000e80| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000e90| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000ea0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000eb0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000ec0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00000ed0| 00 00 00 00 00 00 00 00 | 00 2c 00 05 03 c2 04 21 |........|.,.....!|
|00000ee0| 18 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |.-------|--------|
|00000ef0| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 02 c1 0c 03 c2 02 11 |--------|-.......|
|00000f00| 74 73 65 6c 65 63 74 20 | 63 6e 61 6d 65 2c 20 74 |tselect |cname, t|
|00000f10| 6e 61 6d 65 2c 20 63 72 | 65 61 74 6f 72 2c 20 63 |name, cr|eator, c|
|00000f20| 6f 6c 6e 6f 2c 20 63 6f | 6c 74 79 70 65 2c 20 77 |olno, co|ltype, w|
|00000f30| 69 64 74 68 2c 20 73 63 | 61 6c 65 2c 20 70 72 65 |idth, sc|ale, pre|
|00000f40| 63 69 73 69 6f 6e 2c 0a | 6e 75 6c 6c 73 2c 20 64 |cision,.|nulls, d|
|00000f50| 65 66 61 75 6c 74 76 61 | 6c 2c 20 72 65 6d 61 72 |efaultva|l, remar|
|00000f60| 6b 73 0a 66 72 6f 6d 20 | 20 73 79 73 63 6f 6c 75 |ks.from | syscolu|
|00000f70| 6d 6e 73 5f 0a 2c 00 05 | 03 c2 04 20 18 2d 2d 2d |mns_.,..|... .---|
|00000f80| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|00000f90| 2d 2d 2d 2d 2d 02 c1 0d | 03 c2 07 06 fe 5d 02 73 |-----...|.....].s|
|00000fa0| 65 6c 65 63 74 20 20 63 | 2e 6e 61 6d 65 2c 20 74 |elect  c|.name, t|
|00000fb0| 2e 6e 61 6d 65 2c 20 75 | 2e 6e 61 6d 65 2c 20 74 |.name, u|.name, t|
|00000fc0| 2e 6f 77 6e 65 72 23 2c | 20 63 2e 63 6f 6c 23 2c |.owner#,| c.col#,|
|00000fd0| 0a 64 65 63 6f 64 65 28 | 63 2e 74 79 70 65 23 2c |.decode(|c.type#,|
|00000fe0| 20 31 2c 20 27 43 48 41 | 52 27 2c 20 32 2c 20 27 | 1, 'CHA|R', 2, '|
|00000ff0| 4e 55 4d 42 45 52 27 2c | 20 38 2c 20 27 4c 4f 4e |NUMBER',| 8, 'LON|
|00001000| 47 27 2c 20 39 2c 20 27 | 56 41 52 43 48 41 52 27 |G', 9, '|VARCHAR'|
|00001010| 2c 0a 31 32 2c 20 27 44 | 41 54 45 27 2c 20 32 33 |,.12, 'D|ATE', 23|
|00001020| 2c 20 27 52 41 57 27 2c | 20 32 34 2c 20 27 4c 4f |, 'RAW',| 24, 'LO|
|00001030| 4e 47 20 52 41 57 27 2c | 0a 36 39 2c 20 27 52 4f |NG RAW',|.69, 'RO|
|00001040| 57 49 44 27 2c 20 27 55 | 4e 44 45 46 49 4e 45 44 |WID', 'U|NDEFINED|
|00001050| 27 29 2c 0a 64 65 63 6f | 64 65 28 63 2e 74 79 70 |'),.deco|de(c.typ|
|00001060| 65 23 2c 20 32 2c 20 63 | 2e 70 72 65 63 69 73 69 |e#, 2, c|.precisi|
|00001070| 6f 6e 2c 20 63 2e 6c 65 | 6e 67 74 68 29 2c 0a 63 |on, c.le|ngth),.c|
|00001080| 2e 73 63 61 6c 65 2c 20 | 63 2e 70 72 65 63 69 73 |.scale, |c.precis|
|00001090| 69 6f 6e 2c 0a 64 65 63 | 6f 64 65 28 63 2e 6e 75 |ion,.dec|ode(c.nu|
|000010a0| 6c 6c 24 2c 20 30 2c 20 | 27 4e 55 4c 4c 27 2c 20 |ll$, 0, |'NULL', |
|000010b0| 27 4e 4f 54 20 4e 55 4c | 4c 27 29 2c 20 63 2e 64 |'NOT NUL|L'), c.d|
|000010c0| 65 66 61 75 6c 74 24 2c | 20 63 6f 2e 63 6f 6d 6d |efault$,| co.comm|
|000010d0| 65 6e 74 24 0a 66 72 6f | 6d 09 73 79 73 2e 75 73 |ent$.fro|m.sys.us|
|000010e0| 65 72 24 20 75 2c 20 73 | 79 73 2e 63 6f 6c 24 20 |er$ u, s|ys.col$ |
|000010f0| 63 2c 20 73 79 73 2e 6f | 62 6a 24 20 74 2c 20 73 |c, sys.o|bj$ t, s|
|00001100| 79 73 2e 63 6f 6d 24 20 | 63 6f 0a 77 68 65 72 65 |ys.com$ |co.where|
|00001110| 20 74 2e 74 79 70 65 20 | 69 6e 20 28 32 2c 20 34 | t.type |in (2, 4|
|00001120| 29 0a 61 6e 64 20 74 2e | 6f 62 6a 23 20 3d 20 63 |).and t.|obj# = c|
|00001130| 2e 6f 62 6a 23 0a 61 6e | 64 20 63 2e 6f 62 6a 23 |.obj#.an|d c.obj#|
|00001140| 20 3d 20 63 6f 2e 6f 62 | 6a 23 20 28 2b 29 0a 61 | = co.ob|j# (+).a|
|00001150| 6e 64 20 63 2e 63 6f 6c | 23 20 3d 20 63 6f 2e 63 |nd c.col|# = co.c|
|00001160| 6f 6c 23 20 28 2b 29 0a | 61 6e 64 09 75 2e 75 73 |ol# (+).|and.u.us|
|00001170| 65 72 23 20 3d 20 74 2e | 6f 77 6e 65 72 23 0a 61 |er# = t.|owner#.a|
|00001180| 6e 64 20 28 20 74 2e 6f | 77 6e 65 72 23 20 3d 20 |nd ( t.o|wner# = |
|00001190| 75 69 64 0a 6f 72 20 65 | 78 69 73 74 73 0a 28 20 |uid.or e|xists.( |
|000011a0| 73 65 6c 65 63 74 20 6e | 75 6c 6c 0a 66 72 6f 6d |select n|ull.from|
|000011b0| 20 20 73 79 73 2e 74 61 | 62 61 75 74 68 24 20 74 |  sys.ta|bauth$ t|
|000011c0| 61 75 0a 77 68 65 72 65 | 20 74 2e 6f 62 6a 23 20 |au.where| t.obj# |
|000011d0| 3d 20 74 61 75 2e 6f 62 | 6a 23 0a 61 6e 64 20 74 |= tau.ob|j#.and t|
|000011e0| 61 75 2e 67 72 61 6e 74 | 65 65 23 20 69 6e 20 28 |au.grant|ee# in (|
|000011f0| 75 69 64 2c 20 31 29 0a | 29 0a 29 0a 08 00 8e 0c |uid, 1).|).).....|
|00001200| 06 01 00 00 e2 04 00 01 | 8e 0c 00 00 0d 00 00 00 |........|........|
|00001210| 00 00 00 00 01 00 94 02 | 00 01 91 08 00 00 00 00 |........|........|
|00001220| 01 00 00 00 00 00 00 00 | 00 00 18 00 63 00 00 00 |........|....c...|
|00001230| 10 00 00 01 0b 00 07 02 | 01 00 b7 00 00 00 00 00 |........|........|
|00001240| 00 01 04 00 ff ff 1a 00 | f3 00 d9 00 92 01 00 00 |........|........|
|00001250| 04 00 03 03 c2 01 69 01 | f3 00 00 00 00 00 00 00 |......i.|........|
|00001260| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001270| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001280| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001290| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000012a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000012b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000012c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000012d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000012e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000012f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001300| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001310| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001320| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001330| 00 00 00 2c 00 05 03 c2 | 04 25 18 2d 2d 2d 2d 2d |...,....|.%.-----|
|00001340| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|00001350| 2d 2d 2d 02 c1 04 02 c1 | 50 4f 73 65 6c 65 63 74 |---.....|POselect|
|00001360| 20 74 6e 61 6d 65 2c 20 | 63 72 65 61 74 6f 72 2c | tname, |creator,|
|00001370| 20 74 61 62 6c 65 74 79 | 70 65 0a 66 72 6f 6d 09 | tablety|pe.from.|
|00001380| 73 79 73 63 61 74 61 6c | 6f 67 5f 0a 77 68 65 72 |syscatal|og_.wher|
|00001390| 65 20 63 72 65 61 74 6f | 72 69 64 20 6e 6f 74 20 |e creato|rid not |
|000013a0| 69 6e 20 28 30 2c 32 29 | 0a 2c 00 05 03 c2 04 24 |in (0,2)|.,.....$|
|000013b0| 18 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |.-------|--------|
|000013c0| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 02 c1 04 02 c1 33 32 |--------|-.....32|
|000013d0| 73 65 6c 65 63 74 20 74 | 6e 61 6d 65 2c 20 63 72 |select t|name, cr|
|000013e0| 65 61 74 6f 72 2c 20 74 | 61 62 6c 65 74 79 70 65 |eator, t|abletype|
|000013f0| 0a 66 72 6f 6d 20 73 79 | 73 63 61 74 61 6c 6f 67 |.from sy|scatalog|
|00001400| 5f 0a 2c 00 05 03 c2 04 | 23 18 2d 2d 2d 2d 2d 2d |_.,.....|#.------|
|00001410| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|00001420| 2d 2d 02 c1 05 03 c2 03 | 50 fe 17 01 73 65 6c 65 |--......|P...sele|
|00001430| 63 74 20 6f 2e 6e 61 6d | 65 2c 20 75 2e 6e 61 6d |ct o.nam|e, u.nam|
|00001440| 65 2c 20 6f 2e 6f 77 6e | 65 72 23 2c 0a 64 65 63 |e, o.own|er#,.dec|
|00001450| 6f 64 65 28 6f 2e 74 79 | 70 65 2c 20 32 2c 20 27 |ode(o.ty|pe, 2, '|
|00001460| 54 41 42 4c 45 27 2c 20 | 34 2c 20 27 56 49 45 57 |TABLE', |4, 'VIEW|
|00001470| 27 2c 20 36 2c 20 27 53 | 45 51 55 45 4e 43 45 27 |', 6, 'S|EQUENCE'|
|00001480| 2c 27 3f 27 29 0a 66 72 | 6f 6d 09 73 79 73 2e 75 |,'?').fr|om.sys.u|
|00001490| 73 65 72 24 20 75 2c 20 | 73 79 73 2e 6f 62 6a 24 |ser$ u, |sys.obj$|
|000014a0| 20 6f 0a 77 68 65 72 65 | 20 75 2e 75 73 65 72 23 | o.where| u.user#|
|000014b0| 20 3d 20 6f 2e 6f 77 6e | 65 72 23 0a 61 6e 64 09 | = o.own|er#.and.|
|000014c0| 6f 2e 74 79 70 65 20 69 | 6e 20 28 32 2c 20 34 2c |o.type i|n (2, 4,|
|000014d0| 20 36 29 0a 61 6e 64 20 | 28 20 6f 2e 6f 77 6e 65 | 6).and |( o.owne|
|000014e0| 72 23 20 3d 20 75 69 64 | 0a 6f 72 20 6f 2e 6f 62 |r# = uid|.or o.ob|
|000014f0| 6a 23 20 69 6e 0a 28 73 | 65 6c 65 63 74 20 74 61 |j# in.(s|elect ta|
|00001500| 75 2e 6f 62 6a 23 0a 66 | 72 6f 6d 20 20 20 73 79 |u.obj#.f|rom   sy|
|00001510| 73 2e 74 61 62 61 75 74 | 68 24 20 74 61 75 0a 77 |s.tabaut|h$ tau.w|
|00001520| 68 65 72 65 20 20 74 61 | 75 2e 67 72 61 6e 74 65 |here  ta|u.grante|
|00001530| 65 23 20 69 6e 20 28 75 | 69 64 2c 20 31 29 0a 29 |e# in (u|id, 1).)|
|00001540| 0a 29 0a 3c 01 05 03 c2 | 04 22 18 2d 2d 2d 2d 2d |.).<....|.".-----|
|00001550| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|00001560| 2d 2d 2d 02 c1 0c 03 c2 | 02 2e 91 73 65 6c 65 63 |---.....|...selec|
|00001570| 74 20 63 6e 61 6d 65 2c | 20 74 6e 61 6d 65 2c 20 |t cname,| tname, |
|00001580| 63 72 65 61 74 6f 72 2c | 20 63 6f 6c 6e 6f 2c 20 |creator,| colno, |
|00001590| 63 6f 6c 74 79 70 65 2c | 20 77 69 64 74 68 2c 20 |coltype,| width, |
|000015a0| 73 63 61 6c 65 2c 20 70 | 72 65 63 69 73 69 6f 6e |scale, p|recision|
|000015b0| 2c 0a 6e 75 6c 6c 73 2c | 20 64 65 66 61 75 6c 74 |,.nulls,| default|
|000015c0| 76 61 6c 2c 20 72 65 6d | 61 72 6b 73 0a 66 72 6f |val, rem|arks.fro|
|000015d0| 6d 20 20 73 79 73 63 6f | 6c 75 6d 6e 73 5f 0a 77 |m  sysco|lumns_.w|
|000015e0| 68 65 72 65 20 63 72 65 | 61 74 6f 72 69 64 20 6e |here cre|atorid n|
|000015f0| 6f 74 20 69 6e 20 28 30 | 2c 31 29 0a 0d 00 8e 0c |ot in (0|,1).....|
|00001600| 06 01 00 00 e3 04 00 01 | 8e 0c 00 00 0b 00 00 00 |........|........|
|00001610| 00 00 00 00 01 00 94 02 | 00 01 a3 08 00 00 00 00 |........|........|
|00001620| 01 00 00 00 00 00 00 00 | 00 00 16 00 65 00 00 00 |........|....e...|
|00001630| 3f 00 00 01 0b 00 02 02 | 01 00 b7 00 00 00 00 00 |?.......|........|
|00001640| 00 01 03 00 ff ff 18 00 | d4 00 bc 00 75 01 00 00 |........|....u...|
|00001650| 03 00 2d 03 74 02 d4 00 | 00 00 00 00 00 00 00 00 |..-.t...|........|
|00001660| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001670| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001680| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001690| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000016a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000016b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000016c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000016d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000016e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000016f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001700| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001710| 00 00 00 00 2c 00 05 03 | c2 04 29 18 2d 2d 2d 2d |....,...|..).----|
|00001720| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|00001730| 2d 2d 2d 2d 02 c1 05 03 | c2 04 4b fe 76 01 73 65 |----....|..K.v.se|
|00001740| 6c 65 63 74 20 63 75 2e | 6e 61 6d 65 2c 20 63 2e |lect cu.|name, c.|
|00001750| 6e 61 6d 65 2c 20 74 75 | 2e 6e 61 6d 65 2c 20 74 |name, tu|.name, t|
|00001760| 2e 6e 61 6d 65 0a 66 72 | 6f 6d 20 73 79 73 2e 75 |.name.fr|om sys.u|
|00001770| 73 65 72 24 20 74 75 2c | 20 73 79 73 2e 75 73 65 |ser$ tu,| sys.use|
|00001780| 72 24 20 63 75 2c 20 73 | 79 73 2e 6f 62 6a 24 20 |r$ cu, s|ys.obj$ |
|00001790| 74 2c 20 73 79 73 2e 6f | 62 6a 24 20 63 2c 20 73 |t, sys.o|bj$ c, s|
|000017a0| 79 73 2e 74 61 62 24 20 | 74 61 62 0a 77 68 65 72 |ys.tab$ |tab.wher|
|000017b0| 65 20 63 2e 74 79 70 65 | 20 3d 20 33 0a 61 6e 64 |e c.type| = 3.and|
|000017c0| 20 74 2e 74 79 70 65 20 | 3d 20 32 0a 61 6e 64 20 | t.type |= 2.and |
|000017d0| 74 2e 6f 62 6a 23 20 3d | 20 74 61 62 2e 6f 62 6a |t.obj# =| tab.obj|
|000017e0| 23 0a 61 6e 64 20 74 61 | 62 2e 63 6c 75 23 20 3d |#.and ta|b.clu# =|
|000017f0| 20 63 2e 6f 62 6a 23 0a | 61 6e 64 20 63 2e 6f 77 | c.obj#.|and c.ow|
|00001800| 6e 65 72 23 20 3d 20 63 | 75 2e 75 73 65 72 23 0a |ner# = c|u.user#.|
|00001810| 61 6e 64 20 74 2e 6f 77 | 6e 65 72 23 20 3d 20 74 |and t.ow|ner# = t|
|00001820| 75 2e 75 73 65 72 23 0a | 61 6e 64 20 28 74 2e 6f |u.user#.|and (t.o|
|00001830| 77 6e 65 72 23 20 3d 20 | 75 69 64 0a 6f 72 20 63 |wner# = |uid.or c|
|00001840| 2e 6f 77 6e 65 72 23 20 | 3d 20 75 69 64 0a 6f 72 |.owner# |= uid.or|
|00001850| 20 65 78 69 73 74 73 0a | 28 73 65 6c 65 63 74 20 | exists.|(select |
|00001860| 6e 75 6c 6c 0a 66 72 6f | 6d 20 73 79 73 2e 74 61 |null.fro|m sys.ta|
|00001870| 62 61 75 74 68 24 20 74 | 61 75 0a 77 68 65 72 65 |bauth$ t|au.where|
|00001880| 20 74 2e 6f 62 6a 23 20 | 3d 20 74 61 75 2e 6f 62 | t.obj# |= tau.ob|
|00001890| 6a 23 0a 61 6e 64 20 74 | 61 75 2e 67 72 61 6e 74 |j#.and t|au.grant|
|000018a0| 65 65 23 20 69 6e 20 28 | 75 69 64 2c 20 31 29 0a |ee# in (|uid, 1).|
|000018b0| 29 0a 29 0a 3c 01 05 03 | c2 04 28 18 2d 2d 2d 2d |).).<...|..(.----|
|000018c0| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|000018d0| 2d 2d 2d 2d 02 c1 0a 03 | c2 02 2e 91 73 65 6c 65 |----....|....sele|
|000018e0| 63 74 20 69 6e 61 6d 65 | 2c 20 69 63 72 65 61 74 |ct iname|, icreat|
|000018f0| 6f 72 2c 20 74 6e 61 6d | 65 2c 20 74 74 79 70 65 |or, tnam|e, ttype|
|00001900| 2c 20 63 72 65 61 74 6f | 72 2c 20 63 6f 6c 6e 61 |, creato|r, colna|
|00001910| 6d 65 73 2c 0a 69 6e 64 | 65 78 74 79 70 65 2c 20 |mes,.ind|extype, |
|00001920| 63 6f 6d 70 72 65 73 73 | 69 6f 6e 2c 20 73 65 71 |compress|ion, seq|
|00001930| 0a 66 72 6f 6d 20 20 73 | 79 73 69 6e 64 65 78 65 |.from  s|ysindexe|
|00001940| 73 5f 0a 77 68 65 72 65 | 09 69 63 72 65 61 74 6f |s_.where|.icreato|
|00001950| 72 69 64 20 3d 20 75 69 | 64 0a 6f 72 20 63 72 65 |rid = ui|d.or cre|
|00001960| 61 74 6f 72 69 64 20 3d | 20 75 69 64 0a 2c 00 05 |atorid =| uid.,..|
|00001970| 03 c2 04 27 18 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |...'.---|--------|
|00001980| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 02 c1 0a |--------|-----...|
|00001990| 03 c2 02 04 67 73 65 6c | 65 63 74 20 69 6e 61 6d |....gsel|ect inam|
|000019a0| 65 2c 20 69 63 72 65 61 | 74 6f 72 2c 20 74 6e 61 |e, icrea|tor, tna|
|000019b0| 6d 65 2c 20 74 74 79 70 | 65 2c 20 63 72 65 61 74 |me, ttyp|e, creat|
|000019c0| 6f 72 2c 20 63 6f 6c 6e | 61 6d 65 73 2c 0a 69 6e |or, coln|ames,.in|
|000019d0| 64 65 78 74 79 70 65 2c | 20 63 6f 6d 70 72 65 73 |dextype,| compres|
|000019e0| 73 69 6f 6e 2c 20 73 65 | 71 0a 66 72 6f 6d 20 20 |sion, se|q.from  |
|000019f0| 73 79 73 69 6e 64 65 78 | 65 73 5f 0a 0b 00 8e 0c |sysindex|es_.....|
|00001a00| 06 01 00 00 e4 04 00 01 | 8e 0c 00 00 0b 00 00 00 |........|........|
|00001a10| 00 00 00 00 01 00 94 02 | 00 01 b0 08 00 00 00 00 |........|........|
|00001a20| 01 00 00 00 00 00 00 00 | 00 00 03 00 65 00 00 00 |........|....e...|
|00001a30| 2a 00 00 01 0b 00 05 02 | 01 00 82 00 00 00 00 00 |*.......|........|
|00001a40| 00 01 03 00 ff ff 18 00 | b8 00 a0 00 24 01 00 00 |........|....$...|
|00001a50| 03 00 a3 01 1f 01 b8 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001a60| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001a70| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001a80| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001a90| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001aa0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001ab0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001ac0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001ad0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001ae0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001af0| 00 00 00 00 00 00 00 00 | 2c 00 05 03 c2 04 2c 18 |........|,.....,.|
|00001b00| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|00001b10| 2d 2d 2d 2d 2d 2d 2d 2d | 02 c1 03 02 c1 41 40 73 |--------|.....A@s|
|00001b20| 65 6c 65 63 74 20 74 6e | 61 6d 65 2c 20 63 72 65 |elect tn|ame, cre|
|00001b30| 61 74 6f 72 0a 66 72 6f | 6d 20 20 73 79 73 63 61 |ator.fro|m  sysca|
|00001b40| 74 61 6c 6f 67 0a 77 68 | 65 72 65 20 74 61 62 6c |talog.wh|ere tabl|
|00001b50| 65 74 79 70 65 20 3d 20 | 27 56 49 45 57 27 0a 3c |etype = |'VIEW'.<|
|00001b60| 01 05 03 c2 04 2b 18 2d | 2d 2d 2d 2d 2d 2d 2d 2d |.....+.-|--------|
|00001b70| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 02 |--------|-------.|
|00001b80| c1 03 02 c1 5e 5d 73 65 | 6c 65 63 74 20 6f 2e 6e |....^]se|lect o.n|
|00001b90| 61 6d 65 2c 20 76 2e 74 | 65 78 74 0a 66 72 6f 6d |ame, v.t|ext.from|
|00001ba0| 20 20 73 79 73 2e 76 69 | 65 77 24 20 76 2c 20 73 |  sys.vi|ew$ v, s|
|00001bb0| 79 73 2e 6f 62 6a 24 20 | 6f 0a 77 68 65 72 65 20 |ys.obj$ |o.where |
|00001bc0| 76 2e 6f 62 6a 23 20 3d | 20 6f 2e 6f 62 6a 23 0a |v.obj# =| o.obj#.|
|00001bd0| 61 6e 64 20 6f 2e 6f 77 | 6e 65 72 23 20 3d 20 75 |and o.ow|ner# = u|
|00001be0| 69 64 0a 2c 00 05 03 c2 | 04 2a 18 2d 2d 2d 2d 2d |id.,....|.*.-----|
|00001bf0| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|00001c00| 2d 2d 2d 02 c1 07 03 c2 | 05 60 fe ef 01 73 65 6c |---.....|.`...sel|
|00001c10| 65 63 74 20 63 75 2e 6e | 61 6d 65 2c 20 63 2e 6e |ect cu.n|ame, c.n|
|00001c20| 61 6d 65 2c 20 63 63 2e | 6e 61 6d 65 2c 20 74 75 |ame, cc.|name, tu|
|00001c30| 2e 6e 61 6d 65 2c 20 74 | 2e 6e 61 6d 65 2c 20 74 |.name, t|.name, t|
|00001c40| 63 2e 6e 61 6d 65 0a 66 | 72 6f 6d 20 20 20 73 79 |c.name.f|rom   sy|
|00001c50| 73 2e 63 6f 6c 24 20 74 | 63 2c 20 73 79 73 2e 63 |s.col$ t|c, sys.c|
|00001c60| 6f 6c 24 20 63 63 2c 20 | 73 79 73 2e 75 73 65 72 |ol$ cc, |sys.user|
|00001c70| 24 20 74 75 2c 20 73 79 | 73 2e 75 73 65 72 24 20 |$ tu, sy|s.user$ |
|00001c80| 63 75 2c 0a 73 79 73 2e | 6f 62 6a 24 20 74 2c 20 |cu,.sys.|obj$ t, |
|00001c90| 20 73 79 73 2e 6f 62 6a | 24 20 63 2c 20 73 79 73 | sys.obj|$ c, sys|
|00001ca0| 2e 74 61 62 24 20 74 61 | 62 0a 77 68 65 72 65 20 |.tab$ ta|b.where |
|00001cb0| 63 2e 74 79 70 65 20 3d | 20 33 20 61 6e 64 20 74 |c.type =| 3 and t|
|00001cc0| 2e 74 79 70 65 20 3d 20 | 32 0a 61 6e 64 09 74 2e |.type = |2.and.t.|
|00001cd0| 6f 62 6a 23 20 3d 20 74 | 61 62 2e 6f 62 6a 23 20 |obj# = t|ab.obj# |
|00001ce0| 20 61 6e 64 20 74 61 62 | 2e 63 6c 75 23 20 3d 20 | and tab|.clu# = |
|00001cf0| 63 2e 6f 62 6a 23 0a 61 | 6e 64 09 63 2e 6f 62 6a |c.obj#.a|nd.c.obj|
|00001d00| 23 20 3d 20 63 63 2e 6f | 62 6a 23 20 20 20 61 6e |# = cc.o|bj#   an|
|00001d10| 64 20 74 2e 6f 62 6a 23 | 20 3d 20 74 63 2e 6f 62 |d t.obj#| = tc.ob|
|00001d20| 6a 23 0a 61 6e 64 09 63 | 63 2e 73 65 67 63 6f 6c |j#.and.c|c.segcol|
|00001d30| 23 20 3d 20 74 63 2e 73 | 65 67 63 6f 6c 23 0a 61 |# = tc.s|egcol#.a|
|00001d40| 6e 64 20 63 2e 6f 77 6e | 65 72 23 20 3d 20 63 75 |nd c.own|er# = cu|
|00001d50| 2e 75 73 65 72 23 20 61 | 6e 64 20 74 2e 6f 77 6e |.user# a|nd t.own|
|00001d60| 65 72 23 20 3d 20 74 75 | 2e 75 73 65 72 23 0a 61 |er# = tu|.user#.a|
|00001d70| 6e 64 20 28 74 2e 6f 77 | 6e 65 72 23 20 3d 20 75 |nd (t.ow|ner# = u|
|00001d80| 69 64 20 6f 72 20 63 2e | 6f 77 6e 65 72 23 20 3d |id or c.|owner# =|
|00001d90| 20 75 69 64 0a 6f 72 20 | 20 65 78 69 73 74 73 0a | uid.or | exists.|
|00001da0| 28 73 65 6c 65 63 74 20 | 6e 75 6c 6c 0a 66 72 6f |(select |null.fro|
|00001db0| 6d 20 73 79 73 2e 74 61 | 62 61 75 74 68 24 20 74 |m sys.ta|bauth$ t|
|00001dc0| 61 75 0a 77 68 65 72 65 | 20 74 2e 6f 62 6a 23 20 |au.where| t.obj# |
|00001dd0| 3d 20 74 61 75 2e 6f 62 | 6a 23 0a 61 6e 64 20 74 |= tau.ob|j#.and t|
|00001de0| 61 75 2e 67 72 61 6e 74 | 65 65 23 20 69 6e 20 28 |au.grant|ee# in (|
|00001df0| 75 69 64 2c 20 31 29 0a | 29 0a 29 0a 0b 00 8e 0c |uid, 1).|).).....|
|00001e00| 06 01 00 00 e5 04 00 01 | 8e 0c 00 00 06 00 00 00 |........|........|
|00001e10| 00 00 00 00 01 00 94 02 | 00 01 b4 08 00 00 00 00 |........|........|
|00001e20| 01 00 00 00 00 00 00 00 | 00 00 03 00 4f 00 00 00 |........|....O...|
|00001e30| 78 02 00 01 07 00 0a 02 | 00 80 00 00 b4 08 00 00 |x.......|........|
|00001e40| 00 01 01 00 ff ff 14 00 | ae 00 9a 00 9a 00 00 00 |........|........|
|00001e50| 01 00 ae 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001e60| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001e70| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001e80| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001e90| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001ea0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001eb0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001ec0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001ed0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00001ee0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 2c 00 |........|......,.|
|00001ef0| 05 03 c2 04 2d 18 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |....-.--|--------|
|00001f00| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 02 c1 |--------|------..|
|00001f10| 0d 03 c2 08 29 fe e4 02 | 73 65 6c 65 63 74 20 75 |....)...|select u|
|00001f20| 72 2e 6e 61 6d 65 2c 20 | 75 65 2e 6e 61 6d 65 2c |r.name, |ue.name,|
|00001f30| 20 75 2e 6e 61 6d 65 2c | 20 6f 2e 6e 61 6d 65 2c | u.name,| o.name,|
|00001f40| 20 74 61 75 2e 74 69 6d | 65 2c 0a 64 65 63 6f 64 | tau.tim|e,.decod|
|00001f50| 65 28 74 61 75 2e 61 6c | 74 65 72 24 2c 20 20 30 |e(tau.al|ter$,  0|
|00001f60| 2c 20 27 20 27 2c 20 32 | 2c 20 27 59 27 2c 20 27 |, ' ', 2|, 'Y', '|
|00001f70| 47 27 29 2c 0a 64 65 63 | 6f 64 65 28 74 61 75 2e |G'),.dec|ode(tau.|
|00001f80| 64 65 6c 65 74 65 24 2c | 20 30 2c 20 27 20 27 2c |delete$,| 0, ' ',|
|00001f90| 20 32 2c 20 27 59 27 2c | 20 27 47 27 29 2c 0a 64 | 2, 'Y',| 'G'),.d|
|00001fa0| 65 63 6f 64 65 28 74 61 | 75 2e 69 6e 64 65 78 24 |ecode(ta|u.index$|
|00001fb0| 2c 20 20 30 2c 20 27 20 | 27 2c 20 32 2c 20 27 59 |,  0, ' |', 2, 'Y|
|00001fc0| 27 2c 20 27 47 27 29 2c | 0a 64 65 63 6f 64 65 28 |', 'G'),|.decode(|
|00001fd0| 74 61 75 2e 69 6e 73 65 | 72 74 24 2c 20 30 2c 20 |tau.inse|rt$, 0, |
|00001fe0| 27 20 27 2c 20 32 2c 20 | 27 59 27 2c 20 27 47 27 |' ', 2, |'Y', 'G'|
|00001ff0| 29 2c 0a 64 65 63 6f 64 | 65 28 74 61 75 2e 73 65 |),.decod|e(tau.se|
|00002000| 6c 65 63 74 24 2c 20 30 | 2c 20 27 20 27 2c 20 32 |lect$, 0|, ' ', 2|
|00002010| 2c 20 27 59 27 2c 20 27 | 47 27 29 2c 0a 64 65 63 |, 'Y', '|G'),.dec|
|00002020| 6f 64 65 28 74 61 75 2e | 75 70 64 61 74 65 24 2c |ode(tau.|update$,|
|00002030| 20 30 2c 20 27 20 27 2c | 20 31 2c 20 27 52 27 2c | 0, ' ',| 1, 'R',|
|00002040| 20 20 32 2c 20 27 59 27 | 2c 20 27 47 27 29 2c 0a |  2, 'Y'|, 'G'),.|
|00002050| 64 65 63 6f 64 65 28 74 | 61 75 2e 72 65 66 65 72 |decode(t|au.refer|
|00002060| 65 6e 63 65 73 24 2c 20 | 30 2c 20 27 20 27 2c 20 |ences$, |0, ' ', |
|00002070| 31 2c 20 27 52 27 2c 20 | 20 32 2c 20 27 59 27 2c |1, 'R', | 2, 'Y',|
|00002080| 20 27 47 27 29 0a 66 72 | 6f 6d 20 73 79 73 2e 74 | 'G').fr|om sys.t|
|00002090| 61 62 61 75 74 68 24 20 | 74 61 75 2c 20 73 79 73 |abauth$ |tau, sys|
|000020a0| 2e 6f 62 6a 24 20 6f 2c | 20 73 79 73 2e 75 73 65 |.obj$ o,| sys.use|
|000020b0| 72 24 20 75 2c 20 73 79 | 73 2e 75 73 65 72 24 20 |r$ u, sy|s.user$ |
|000020c0| 75 72 2c 20 73 79 73 2e | 75 73 65 72 24 20 75 65 |ur, sys.|user$ ue|
|000020d0| 0a 77 68 65 72 65 20 74 | 61 75 2e 6f 62 6a 23 20 |.where t|au.obj# |
|000020e0| 3d 20 6f 2e 6f 62 6a 23 | 0a 61 6e 64 20 6f 2e 6f |= o.obj#|.and o.o|
|000020f0| 77 6e 65 72 23 20 3d 20 | 75 2e 75 73 65 72 23 0a |wner# = |u.user#.|
|00002100| 61 6e 64 20 74 61 75 2e | 67 72 61 6e 74 6f 72 23 |and tau.|grantor#|
|00002110| 20 3d 20 75 72 2e 75 73 | 65 72 23 0a 61 6e 64 20 | = ur.us|er#.and |
|00002120| 74 61 75 2e 67 72 61 6e | 74 65 65 23 20 3d 20 75 |tau.gran|tee# = u|
|00002130| 65 2e 75 73 65 72 23 0a | 61 6e 64 20 28 74 61 75 |e.user#.|and (tau|
|00002140| 2e 67 72 61 6e 74 6f 72 | 23 20 3d 20 75 69 64 20 |.grantor|# = uid |
|00002150| 6f 72 20 74 61 75 2e 67 | 72 61 6e 74 65 65 23 20 |or tau.g|rantee# |
|00002160| 69 6e 20 28 75 69 64 2c | 20 31 29 29 0a 75 6e 69 |in (uid,| 1)).uni|
|00002170| 6f 6e 0a 73 65 6c 65 63 | 74 20 75 2e 6e 61 6d 65 |on.selec|t u.name|
|00002180| 2c 20 75 2e 6e 61 6d 65 | 20 2c 20 75 2e 6e 61 6d |, u.name| , u.nam|
|00002190| 65 2c 20 6f 2e 6e 61 6d | 65 2c 20 6f 2e 63 74 69 |e, o.nam|e, o.cti|
|000021a0| 6d 65 2c 0a 27 47 27 2c | 27 47 27 2c 27 47 27 2c |me,.'G',|'G','G',|
|000021b0| 27 47 27 2c 27 47 27 2c | 27 47 27 2c 27 47 27 0a |'G','G',|'G','G'.|
|000021c0| 66 72 6f 6d 20 75 73 65 | 72 24 20 75 2c 20 6f 62 |from use|r$ u, ob|
|000021d0| 6a 24 20 6f 0a 77 68 65 | 72 65 20 75 2e 75 73 65 |j$ o.whe|re u.use|
|000021e0| 72 23 20 3d 20 75 69 64 | 20 61 6e 64 20 6f 2e 6f |r# = uid| and o.o|
|000021f0| 77 6e 65 72 23 20 3d 20 | 75 69 64 0a 06 00 8e 0c |wner# = |uid.....|
|00002200| 06 01 00 00 e6 04 00 01 | 8e 0c 00 00 0a 00 00 00 |........|........|
|00002210| 00 00 00 00 01 00 94 02 | 00 01 c2 08 00 00 00 00 |........|........|
|00002220| 01 00 00 00 00 00 00 00 | 00 00 09 00 4f 00 00 00 |........|....O...|
|00002230| 83 02 00 01 07 00 05 02 | 00 80 00 00 c2 08 00 00 |........|........|
|00002240| 00 01 03 00 ff ff 18 00 | 7d 00 65 00 65 00 00 00 |........|}.e.e...|
|00002250| 03 00 3a 02 15 01 7d 00 | 00 00 00 00 00 00 00 00 |..:...}.|........|
|00002260| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002270| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002280| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002290| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000022a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000022b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 2c 00 05 |........|.....,..|
|000022c0| 03 c2 04 30 18 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |...0.---|--------|
|000022d0| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 02 c1 09 |--------|-----...|
|000022e0| 03 c2 02 0d 70 73 65 6c | 65 63 74 20 75 73 65 72 |....psel|ect user|
|000022f0| 69 64 2c 20 75 73 65 72 | 6e 61 6d 65 2c 20 74 69 |id, user|name, ti|
|00002300| 6d 65 73 74 61 6d 70 2c | 20 63 6f 6e 6e 65 63 74 |mestamp,| connect|
|00002310| 61 75 74 68 2c 20 64 62 | 61 61 75 74 68 2c 0a 72 |auth, db|aauth,.r|
|00002320| 65 73 6f 75 72 63 65 61 | 75 74 68 2c 20 74 61 62 |esourcea|uth, tab|
|00002330| 6c 65 73 70 61 63 65 2c | 20 74 65 6d 70 73 70 61 |lespace,| tempspa|
|00002340| 63 65 0a 66 72 6f 6d 20 | 20 73 79 73 75 73 65 72 |ce.from | sysuser|
|00002350| 61 75 74 68 0a 2c 00 05 | 03 c2 04 2f 18 2d 2d 2d |auth.,..|.../.---|
|00002360| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|00002370| 2d 2d 2d 2d 2d 02 c1 0a | 03 c2 03 34 fe fb 00 73 |-----...|...4...s|
|00002380| 65 6c 65 63 74 20 75 2e | 75 73 65 72 23 2c 20 75 |elect u.|user#, u|
|00002390| 2e 6e 61 6d 65 2c 20 75 | 2e 70 61 73 73 77 6f 72 |.name, u|.passwor|
|000023a0| 64 2c 20 75 2e 63 74 69 | 6d 65 2c 20 64 65 63 6f |d, u.cti|me, deco|
|000023b0| 64 65 28 75 2e 63 6f 6e | 6e 65 63 74 24 2c 20 31 |de(u.con|nect$, 1|
|000023c0| 2c 20 27 59 27 2c 20 27 | 20 27 29 2c 0a 64 65 63 |, 'Y', '| '),.dec|
|000023d0| 6f 64 65 28 75 2e 64 62 | 61 24 2c 20 31 2c 20 27 |ode(u.db|a$, 1, '|
|000023e0| 59 27 2c 20 27 20 27 29 | 2c 20 64 65 63 6f 64 65 |Y', ' ')|, decode|
|000023f0| 28 75 2e 72 65 73 6f 75 | 72 63 65 24 2c 20 31 2c |(u.resou|rce$, 1,|
|00002400| 20 27 59 27 2c 20 27 20 | 27 29 2c 0a 74 73 2e 6e | 'Y', ' |'),.ts.n|
|00002410| 61 6d 65 2c 20 74 6d 70 | 2e 6e 61 6d 65 0a 66 72 |ame, tmp|.name.fr|
|00002420| 6f 6d 20 20 73 79 73 2e | 75 73 65 72 24 20 75 2c |om  sys.|user$ u,|
|00002430| 20 73 79 73 2e 74 73 24 | 20 74 73 2c 20 73 79 73 | sys.ts$| ts, sys|
|00002440| 2e 74 73 24 20 74 6d 70 | 0a 77 68 65 72 65 20 75 |.ts$ tmp|.where u|
|00002450| 2e 64 61 74 61 74 73 23 | 20 3d 20 74 73 2e 74 73 |.datats#| = ts.ts|
|00002460| 23 0a 61 6e 64 20 75 2e | 74 65 6d 70 74 73 23 20 |#.and u.|tempts# |
|00002470| 3d 20 74 6d 70 2e 74 73 | 23 0a 2c 00 05 03 c2 04 |= tmp.ts|#.,.....|
|00002480| 2e 18 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |..------|--------|
|00002490| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 02 c1 09 03 c2 04 |--------|--......|
|000024a0| 2d fe 58 01 73 65 6c 65 | 63 74 20 75 72 2e 6e 61 |-.X.sele|ct ur.na|
|000024b0| 6d 65 2c 20 75 65 2e 6e | 61 6d 65 2c 20 75 2e 6e |me, ue.n|ame, u.n|
|000024c0| 61 6d 65 2c 20 6f 2e 6e | 61 6d 65 2c 20 63 2e 74 |ame, o.n|ame, c.t|
|000024d0| 69 6d 65 2c 20 63 2e 6e | 61 6d 65 2c 0a 64 65 63 |ime, c.n|ame,.dec|
|000024e0| 6f 64 65 28 63 2e 75 70 | 64 61 74 65 24 2c 20 32 |ode(c.up|date$, 2|
|000024f0| 2c 20 27 59 27 2c 20 27 | 47 27 29 2c 20 64 65 63 |, 'Y', '|G'), dec|
|00002500| 6f 64 65 28 63 2e 72 65 | 66 65 72 65 6e 63 65 73 |ode(c.re|ferences|
|00002510| 24 2c 20 32 2c 20 27 59 | 27 2c 20 27 47 27 29 0a |$, 2, 'Y|', 'G').|
|00002520| 66 72 6f 6d 20 20 73 79 | 73 2e 63 6f 6c 61 75 74 |from  sy|s.colaut|
|00002530| 68 24 20 63 2c 20 73 79 | 73 2e 6f 62 6a 24 20 6f |h$ c, sy|s.obj$ o|
|00002540| 2c 20 73 79 73 2e 75 73 | 65 72 24 20 75 2c 20 73 |, sys.us|er$ u, s|
|00002550| 79 73 2e 75 73 65 72 24 | 20 75 72 2c 20 73 79 73 |ys.user$| ur, sys|
|00002560| 2e 75 73 65 72 24 20 75 | 65 0a 77 68 65 72 65 20 |.user$ u|e.where |
|00002570| 63 2e 6f 62 6a 23 20 3d | 20 6f 2e 6f 62 6a 23 0a |c.obj# =| o.obj#.|
|00002580| 61 6e 64 20 6f 2e 6f 77 | 6e 65 72 23 20 3d 20 75 |and o.ow|ner# = u|
|00002590| 2e 75 73 65 72 23 0a 61 | 6e 64 20 63 2e 67 72 61 |.user#.a|nd c.gra|
|000025a0| 6e 74 6f 72 23 20 3d 20 | 75 72 2e 75 73 65 72 23 |ntor# = |ur.user#|
|000025b0| 0a 61 6e 64 20 63 2e 67 | 72 61 6e 74 65 65 23 20 |.and c.g|rantee# |
|000025c0| 3d 20 75 65 2e 75 73 65 | 72 23 0a 61 6e 64 20 28 |= ue.use|r#.and (|
|000025d0| 63 2e 67 72 61 6e 74 6f | 72 23 20 3d 20 75 69 64 |c.granto|r# = uid|
|000025e0| 20 6f 72 20 63 2e 67 72 | 61 6e 74 65 65 23 20 69 | or c.gr|antee# i|
|000025f0| 6e 20 28 75 69 64 2c 20 | 31 29 29 0a 0a 00 8e 0c |n (uid, |1)).....|
|00002600| 06 01 00 00 e7 04 00 01 | 8e 0c 00 00 08 00 00 00 |........|........|
|00002610| 00 00 00 00 01 00 94 02 | 00 01 d8 08 00 00 00 00 |........|........|
|00002620| 01 00 00 00 00 00 00 00 | 00 00 1a 00 4f 00 00 00 |........|....O...|
|00002630| 15 00 00 01 08 00 09 02 | 00 80 00 00 d8 08 00 00 |........|........|
|00002640| 00 01 02 00 ff ff 16 00 | 52 02 3c 02 3c 02 00 00 |........|R.<.<...|
|00002650| 02 00 3c 03 52 02 00 00 | 00 00 00 00 00 00 00 00 |..<.R...|........|
|00002660| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002670| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002680| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002690| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000026a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000026b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000026c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000026d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000026e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000026f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002700| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002710| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002720| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002730| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002740| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002750| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002760| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002770| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002780| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002790| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000027a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000027b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000027c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000027d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000027e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000027f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002800| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002810| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002820| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002830| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002840| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002850| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002860| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002870| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002880| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002890| 00 00 2c 00 05 03 c2 04 | 34 18 2d 2d 2d 2d 2d 2d |..,.....|4.------|
|000028a0| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|000028b0| 2d 2d 02 c1 04 03 c2 02 | 5f c2 73 65 6c 65 63 74 |--......|_.select|
|000028c0| 20 6f 2e 6e 61 6d 65 2c | 0a 64 65 63 6f 64 65 28 | o.name,|.decode(|
|000028d0| 6f 2e 74 79 70 65 2c 20 | 32 2c 20 27 54 41 42 4c |o.type, |2, 'TABL|
|000028e0| 45 27 2c 20 33 2c 20 27 | 43 4c 55 53 54 45 52 27 |E', 3, '|CLUSTER'|
|000028f0| 2c 0a 34 2c 20 27 56 49 | 45 57 27 2c 20 35 2c 20 |,.4, 'VI|EW', 5, |
|00002900| 27 53 59 4e 4f 4e 59 4d | 27 29 2c 20 74 2e 74 61 |'SYNONYM|'), t.ta|
|00002910| 62 23 0a 66 72 6f 6d 20 | 20 73 79 73 2e 74 61 62 |b#.from | sys.tab|
|00002920| 24 20 74 2c 20 73 79 73 | 2e 6f 62 6a 24 20 6f 0a |$ t, sys|.obj$ o.|
|00002930| 77 68 65 72 65 20 6f 2e | 6f 77 6e 65 72 23 20 3d |where o.|owner# =|
|00002940| 20 75 69 64 20 61 6e 64 | 20 6f 2e 74 79 70 65 20 | uid and| o.type |
|00002950| 3e 3d 20 32 20 61 6e 64 | 20 6f 2e 74 79 70 65 20 |>= 2 and| o.type |
|00002960| 3c 3d 35 0a 61 6e 64 20 | 6f 2e 6f 62 6a 23 20 3d |<=5.and |o.obj# =|
|00002970| 20 74 2e 6f 62 6a 23 20 | 28 2b 29 0a 2c 00 05 03 | t.obj# |(+).,...|
|00002980| c2 04 33 18 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |..3.----|--------|
|00002990| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 02 c1 06 02 |--------|----....|
|000029a0| c1 5a 59 73 65 6c 65 63 | 74 20 73 6e 61 6d 65 2c |.ZYselec|t sname,|
|000029b0| 20 63 72 65 61 74 6f 72 | 2c 20 74 6e 61 6d 65 2c | creator|, tname,|
|000029c0| 20 64 61 74 61 62 61 73 | 65 2c 20 74 61 62 74 79 | databas|e, tabty|
|000029d0| 70 65 0a 66 72 6f 6d 20 | 20 73 79 6e 6f 6e 79 6d |pe.from | synonym|
|000029e0| 73 0a 77 68 65 72 65 20 | 73 79 6e 74 79 70 65 20 |s.where |syntype |
|000029f0| 3d 20 27 50 52 49 56 41 | 54 45 27 0a 08 00 8e 0c |= 'PRIVA|TE'.....|
|00002a00| 06 01 00 00 e8 04 00 01 | 8e 0c 00 00 06 00 00 00 |........|........|
|00002a10| 00 00 00 00 01 00 94 02 | 00 01 ef 08 00 00 00 00 |........|........|
|00002a20| 01 00 00 00 00 00 00 00 | 00 00 1b 00 50 00 00 00 |........|....P...|
|00002a30| 2d 00 00 01 08 00 08 02 | 00 80 00 00 ef 08 00 00 |-.......|........|
|00002a40| 00 01 01 00 ff ff 14 00 | f6 00 e2 00 e2 00 00 00 |........|........|
|00002a50| 01 00 f6 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002a60| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002a70| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002a80| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002a90| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002aa0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002ab0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002ac0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002ad0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002ae0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002af0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002b00| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002b10| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002b20| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002b30| 00 00 00 00 00 00 2c 00 | 05 03 c2 04 38 18 2d 2d |......,.|....8.--|
|00002b40| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|00002b50| 2d 2d 2d 2d 2d 2d 02 c1 | 0c 03 c2 07 45 fe 9c 02 |------..|....E...|
|00002b60| 73 65 6c 65 63 74 0a 73 | 75 62 73 74 72 28 61 75 |select.s|ubstr(au|
|00002b70| 64 69 74 24 2c 31 2c 31 | 29 20 7c 7c 20 27 2f 27 |dit$,1,1|) || '/'|
|00002b80| 20 7c 7c 20 73 75 62 73 | 74 72 28 61 75 64 69 74 | || subs|tr(audit|
|00002b90| 24 2c 32 2c 31 29 2c 0a | 73 75 62 73 74 72 28 61 |$,2,1),.|substr(a|
|00002ba0| 75 64 69 74 24 2c 33 2c | 31 29 20 7c 7c 20 27 2f |udit$,3,|1) || '/|
|00002bb0| 27 20 7c 7c 20 73 75 62 | 73 74 72 28 61 75 64 69 |' || sub|str(audi|
|00002bc0| 74 24 2c 34 2c 31 29 2c | 0a 73 75 62 73 74 72 28 |t$,4,1),|.substr(|
|00002bd0| 61 75 64 69 74 24 2c 35 | 2c 31 29 20 7c 7c 20 27 |audit$,5|,1) || '|
|00002be0| 2f 27 20 7c 7c 20 73 75 | 62 73 74 72 28 61 75 64 |/' || su|bstr(aud|
|00002bf0| 69 74 24 2c 36 2c 31 29 | 2c 0a 73 75 62 73 74 72 |it$,6,1)|,.substr|
|00002c00| 28 61 75 64 69 74 24 2c | 37 2c 31 29 20 7c 7c 20 |(audit$,|7,1) || |
|00002c10| 27 2f 27 20 7c 7c 20 73 | 75 62 73 74 72 28 61 75 |'/' || s|ubstr(au|
|00002c20| 64 69 74 24 2c 37 2c 31 | 29 2c 0a 73 75 62 73 74 |dit$,7,1|),.subst|
|00002c30| 72 28 61 75 64 69 74 24 | 2c 39 2c 31 29 20 7c 7c |r(audit$|,9,1) |||
|00002c40| 20 27 2f 27 20 7c 7c 20 | 73 75 62 73 74 72 28 61 | '/' || |substr(a|
|00002c50| 75 64 69 74 24 2c 31 30 | 2c 31 29 2c 0a 73 75 62 |udit$,10|,1),.sub|
|00002c60| 73 74 72 28 61 75 64 69 | 74 24 2c 31 31 2c 31 29 |str(audi|t$,11,1)|
|00002c70| 20 7c 7c 20 27 2f 27 20 | 7c 7c 20 73 75 62 73 74 | || '/' ||| subst|
|00002c80| 72 28 61 75 64 69 74 24 | 2c 31 32 2c 31 29 2c 0a |r(audit$|,12,1),.|
|00002c90| 73 75 62 73 74 72 28 61 | 75 64 69 74 24 2c 31 33 |substr(a|udit$,13|
|00002ca0| 2c 31 29 20 7c 7c 20 27 | 2f 27 20 7c 7c 20 73 75 |,1) || '|/' || su|
|00002cb0| 62 73 74 72 28 61 75 64 | 69 74 24 2c 31 34 2c 31 |bstr(aud|it$,14,1|
|00002cc0| 29 2c 0a 73 75 62 73 74 | 72 28 61 75 64 69 74 24 |),.subst|r(audit$|
|00002cd0| 2c 31 35 2c 31 29 20 7c | 7c 20 27 2f 27 20 7c 7c |,15,1) ||| '/' |||
|00002ce0| 20 73 75 62 73 74 72 28 | 61 75 64 69 74 24 2c 31 | substr(|audit$,1|
|00002cf0| 36 2c 31 29 2c 0a 73 75 | 62 73 74 72 28 61 75 64 |6,1),.su|bstr(aud|
|00002d00| 69 74 24 2c 31 37 2c 31 | 29 20 7c 7c 20 27 2f 27 |it$,17,1|) || '/'|
|00002d10| 20 7c 7c 20 73 75 62 73 | 74 72 28 61 75 64 69 74 | || subs|tr(audit|
|00002d20| 24 2c 31 38 2c 31 29 2c | 0a 73 75 62 73 74 72 28 |$,18,1),|.substr(|
|00002d30| 61 75 64 69 74 24 2c 31 | 39 2c 31 29 20 7c 7c 20 |audit$,1|9,1) || |
|00002d40| 27 2f 27 20 7c 7c 20 73 | 75 62 73 74 72 28 61 75 |'/' || s|ubstr(au|
|00002d50| 64 69 74 24 2c 32 30 2c | 31 29 2c 0a 73 75 62 73 |dit$,20,|1),.subs|
|00002d60| 74 72 28 61 75 64 69 74 | 24 2c 32 31 2c 31 29 20 |tr(audit|$,21,1) |
|00002d70| 7c 7c 20 27 2f 27 20 7c | 7c 20 73 75 62 73 74 72 ||| '/' ||| substr|
|00002d80| 28 61 75 64 69 74 24 2c | 32 32 2c 31 29 0a 66 72 |(audit$,|22,1).fr|
|00002d90| 6f 6d 20 20 73 79 73 2e | 6f 62 6a 24 20 6f 2c 20 |om  sys.|obj$ o, |
|00002da0| 73 79 73 2e 74 61 62 24 | 20 74 0a 77 68 65 72 65 |sys.tab$| t.where|
|00002db0| 20 6f 2e 6f 77 6e 65 72 | 23 20 3d 20 30 0a 61 6e | o.owner|# = 0.an|
|00002dc0| 64 20 6f 2e 6e 61 6d 65 | 20 3d 20 27 5f 64 65 66 |d o.name| = '_def|
|00002dd0| 61 75 6c 74 5f 61 75 64 | 69 74 69 6e 67 5f 6f 70 |ault_aud|iting_op|
|00002de0| 74 69 6f 6e 73 5f 27 0a | 61 6e 64 20 74 2e 6f 62 |tions_'.|and t.ob|
|00002df0| 6a 23 20 3d 20 6f 2e 6f | 62 6a 23 0a 06 00 8e 0c |j# = o.o|bj#.....|
|00002e00| 06 01 00 00 e9 04 00 01 | 8e 0c 00 00 07 00 00 00 |........|........|
|00002e10| 00 00 00 00 01 00 94 02 | 00 01 f5 08 00 00 00 00 |........|........|
|00002e20| 01 00 00 00 00 00 00 00 | 00 00 04 00 51 00 00 00 |........|....Q...|
|00002e30| 37 00 00 01 08 00 02 02 | 00 80 00 00 f5 08 00 00 |7.......|........|
|00002e40| 00 01 01 00 ff ff 14 00 | 46 00 32 00 32 00 00 00 |........|F.2.2...|
|00002e50| 01 00 46 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |..F.....|........|
|00002e60| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002e70| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00002e80| 00 00 00 00 00 00 01 00 | 01 01 00 04 ea 00 00 fe |........|........|
|00002e90| 6a 03 73 65 6c 65 63 74 | 20 75 2e 6e 61 6d 65 2c |j.select| u.name,|
|00002ea0| 20 6f 2e 6e 61 6d 65 2c | 20 27 54 41 42 4c 45 27 | o.name,| 'TABLE'|
|00002eb0| 2c 0a 73 75 62 73 74 72 | 28 74 2e 61 75 64 69 74 |,.substr|(t.audit|
|00002ec0| 24 2c 31 2c 31 29 20 7c | 7c 20 27 2f 27 20 7c 7c |$,1,1) ||| '/' |||
|00002ed0| 20 73 75 62 73 74 72 28 | 74 2e 61 75 64 69 74 24 | substr(|t.audit$|
|00002ee0| 2c 32 2c 31 29 2c 0a 73 | 75 62 73 74 72 28 74 2e |,2,1),.s|ubstr(t.|
|00002ef0| 61 75 64 69 74 24 2c 33 | 2c 31 29 20 7c 7c 20 27 |audit$,3|,1) || '|
|00002f00| 2f 27 20 7c 7c 20 73 75 | 62 73 74 72 28 74 2e 61 |/' || su|bstr(t.a|
|00002f10| 75 64 69 74 24 2c 34 2c | 31 29 2c 0a 73 75 62 73 |udit$,4,|1),.subs|
|00002f20| 74 72 28 74 2e 61 75 64 | 69 74 24 2c 35 2c 31 29 |tr(t.aud|it$,5,1)|
|00002f30| 20 7c 7c 20 27 2f 27 20 | 7c 7c 20 73 75 62 73 74 | || '/' ||| subst|
|00002f40| 72 28 74 2e 61 75 64 69 | 74 24 2c 36 2c 31 29 2c |r(t.audi|t$,6,1),|
|00002f50| 0a 73 75 62 73 74 72 28 | 74 2e 61 75 64 69 74 24 |.substr(|t.audit$|
|00002f60| 2c 37 2c 31 29 20 7c 7c | 20 27 2f 27 20 7c 7c 20 |,7,1) ||| '/' || |
|00002f70| 73 75 62 73 74 72 28 74 | 2e 61 75 64 69 74 24 2c |substr(t|.audit$,|
|00002f80| 38 2c 31 29 2c 0a 73 75 | 62 73 74 72 28 74 2e 61 |8,1),.su|bstr(t.a|
|00002f90| 75 64 69 74 24 2c 39 2c | 31 29 20 7c 7c 20 27 2f |udit$,9,|1) || '/|
|00002fa0| 27 20 7c 7c 20 73 75 62 | 73 74 72 28 74 2e 61 75 |' || sub|str(t.au|
|00002fb0| 64 69 74 24 2c 31 30 2c | 31 29 2c 0a 73 75 62 73 |dit$,10,|1),.subs|
|00002fc0| 74 72 28 74 2e 61 75 64 | 69 74 24 2c 31 31 2c 31 |tr(t.aud|it$,11,1|
|00002fd0| 29 20 7c 7c 20 27 2f 27 | 20 7c 7c 20 73 75 62 73 |) || '/'| || subs|
|00002fe0| 74 72 28 74 2e 61 75 64 | 69 74 24 2c 31 32 2c 31 |tr(t.aud|it$,12,1|
|00002ff0| 29 2c 0a 73 75 62 73 74 | 72 28 74 2e 61 75 64 69 |),.subst|r(t.audi|
|00003000| 74 24 2c 31 33 2c 31 29 | 20 7c 7c 20 27 2f 27 20 |t$,13,1)| || '/' |
|00003010| 7c 7c 20 73 75 62 73 74 | 72 28 74 2e 61 75 64 69 ||| subst|r(t.audi|
|00003020| 74 24 2c 31 34 2c 31 29 | 2c 0a 73 75 62 73 74 72 |t$,14,1)|,.substr|
|00003030| 28 74 2e 61 75 64 69 74 | 24 2c 31 35 2c 31 29 20 |(t.audit|$,15,1) |
|00003040| 7c 7c 20 27 2f 27 20 7c | 7c 20 73 75 62 73 74 72 ||| '/' ||| substr|
|00003050| 28 74 2e 61 75 64 69 74 | 24 2c 31 36 2c 31 29 2c |(t.audit|$,16,1),|
|00003060| 0a 73 75 62 73 74 72 28 | 74 2e 61 75 64 69 74 24 |.substr(|t.audit$|
|00003070| 2c 31 37 2c 31 29 20 7c | 7c 20 27 2f 27 20 7c 7c |,17,1) ||| '/' |||
|00003080| 20 73 75 62 73 74 72 28 | 74 2e 61 75 64 69 74 24 | substr(|t.audit$|
|00003090| 2c 31 38 2c 31 29 2c 0a | 73 75 62 73 74 72 28 74 |,18,1),.|substr(t|
|000030a0| 2e 61 75 64 69 74 24 2c | 31 39 2c 31 29 20 7c 7c |.audit$,|19,1) |||
|000030b0| 20 27 2f 27 20 7c 7c 20 | 73 75 62 73 74 72 28 74 | '/' || |substr(t|
|000030c0| 2e 61 75 64 69 74 24 2c | 32 30 2c 31 29 2c 0a 73 |.audit$,|20,1),.s|
|000030d0| 75 62 73 74 72 28 74 2e | 61 75 64 69 74 24 2c 32 |ubstr(t.|audit$,2|
|000030e0| 31 2c 31 29 20 7c 7c 20 | 27 2f 27 20 7c 7c 20 73 |1,1) || |'/' || s|
|000030f0| 75 62 73 74 72 28 74 2e | 61 75 64 69 74 24 2c 32 |ubstr(t.|audit$,2|
|00003100| 32 2c 31 29 0a 66 72 6f | 6d 20 73 79 73 2e 6f 62 |2,1).fro|m sys.ob|
|00003110| 6a 24 20 6f 2c 20 73 79 | 73 2e 75 73 65 72 24 20 |j$ o, sy|s.user$ |
|00003120| 75 2c 20 73 79 73 2e 74 | 61 62 24 20 74 0a 77 68 |u, sys.t|ab$ t.wh|
|00003130| 65 72 65 20 6f 2e 74 79 | 70 65 20 3d 20 32 20 61 |ere o.ty|pe = 2 a|
|00003140| 6e 64 20 6f 2e 6e 61 6d | 65 20 21 3d 20 27 5f 64 |nd o.nam|e != '_d|
|00003150| 65 66 61 75 6c 74 5f 61 | 75 64 69 74 69 6e 67 5f |efault_a|uditing_|
|00003160| 6f 70 74 69 6f 6e 73 5f | 27 0a 61 6e 64 20 6f 2e |options_|'.and o.|
|00003170| 6e 61 6d 65 20 21 3d 20 | 27 5f 73 79 73 74 65 6d |name != |'_system|
|00003180| 5f 61 75 64 69 74 69 6e | 67 5f 6f 70 74 69 6f 6e |_auditin|g_option|
|00003190| 73 5f 27 20 61 6e 64 20 | 6f 2e 6f 77 6e 65 72 23 |s_' and |o.owner#|
|000031a0| 20 3d 20 75 2e 75 73 65 | 72 23 0a 61 6e 64 20 6f | = u.use|r#.and o|
|000031b0| 2e 6f 62 6a 23 20 3d 20 | 74 2e 6f 62 6a 23 20 61 |.obj# = |t.obj# a|
|000031c0| 6e 64 20 28 6f 2e 6f 77 | 6e 65 72 23 20 3d 20 75 |nd (o.ow|ner# = u|
|000031d0| 69 64 20 6f 72 20 65 78 | 69 73 74 73 20 20 28 73 |id or ex|ists  (s|
|000031e0| 65 6c 65 63 74 20 6e 75 | 6c 6c 20 66 72 6f 6d 20 |elect nu|ll from |
|000031f0| 73 79 73 2e 75 73 65 72 | 24 20 77 68 07 00 8e 0c |sys.user|$ wh....|
|00003200| 06 01 00 00 ea 04 00 01 | 8e 0c 00 00 07 00 00 00 |........|........|
|00003210| 00 00 00 00 01 00 94 02 | 00 01 f5 08 00 00 00 00 |........|........|
|00003220| 01 00 00 00 00 00 00 00 | 00 00 04 00 51 00 00 00 |........|....Q...|
|00003230| 37 00 00 01 08 00 03 02 | 00 80 00 00 f5 08 00 00 |7.......|........|
|00003240| 00 01 01 00 ff ff 14 00 | 46 00 32 00 32 00 00 00 |........|F.2.2...|
|00003250| 01 00 46 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |..F.....|........|
|00003260| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003270| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003280| 00 00 00 00 00 00 03 00 | 01 01 00 04 eb 00 00 fe |........|........|
|00003290| 6a 03 65 72 65 20 75 73 | 65 72 23 20 3d 20 75 69 |j.ere us|er# = ui|
|000032a0| 64 20 61 6e 64 20 64 62 | 61 24 20 3d 20 31 29 29 |d and db|a$ = 1))|
|000032b0| 0a 75 6e 69 6f 6e 0a 73 | 65 6c 65 63 74 20 75 2e |.union.s|elect u.|
|000032c0| 6e 61 6d 65 2c 20 6f 2e | 6e 61 6d 65 2c 20 27 56 |name, o.|name, 'V|
|000032d0| 49 45 57 27 2c 0a 73 75 | 62 73 74 72 28 74 2e 61 |IEW',.su|bstr(t.a|
|000032e0| 75 64 69 74 24 2c 31 2c | 31 29 20 7c 7c 20 27 2f |udit$,1,|1) || '/|
|000032f0| 27 20 7c 7c 20 73 75 62 | 73 74 72 28 74 2e 61 75 |' || sub|str(t.au|
|00003300| 64 69 74 24 2c 32 2c 31 | 29 2c 0a 73 75 62 73 74 |dit$,2,1|),.subst|
|00003310| 72 28 74 2e 61 75 64 69 | 74 24 2c 33 2c 31 29 20 |r(t.audi|t$,3,1) |
|00003320| 7c 7c 20 27 2f 27 20 7c | 7c 20 73 75 62 73 74 72 ||| '/' ||| substr|
|00003330| 28 74 2e 61 75 64 69 74 | 24 2c 34 2c 31 29 2c 0a |(t.audit|$,4,1),.|
|00003340| 73 75 62 73 74 72 28 74 | 2e 61 75 64 69 74 24 2c |substr(t|.audit$,|
|00003350| 35 2c 31 29 20 7c 7c 20 | 27 2f 27 20 7c 7c 20 73 |5,1) || |'/' || s|
|00003360| 75 62 73 74 72 28 74 2e | 61 75 64 69 74 24 2c 36 |ubstr(t.|audit$,6|
|00003370| 2c 31 29 2c 0a 73 75 62 | 73 74 72 28 74 2e 61 75 |,1),.sub|str(t.au|
|00003380| 64 69 74 24 2c 37 2c 31 | 29 20 7c 7c 20 27 2f 27 |dit$,7,1|) || '/'|
|00003390| 20 7c 7c 20 73 75 62 73 | 74 72 28 74 2e 61 75 64 | || subs|tr(t.aud|
|000033a0| 69 74 24 2c 38 2c 31 29 | 2c 0a 73 75 62 73 74 72 |it$,8,1)|,.substr|
|000033b0| 28 74 2e 61 75 64 69 74 | 24 2c 39 2c 31 29 20 7c |(t.audit|$,9,1) ||
|000033c0| 7c 20 27 2f 27 20 7c 7c | 20 73 75 62 73 74 72 28 || '/' ||| substr(|
|000033d0| 74 2e 61 75 64 69 74 24 | 2c 31 30 2c 31 29 2c 0a |t.audit$|,10,1),.|
|000033e0| 73 75 62 73 74 72 28 74 | 2e 61 75 64 69 74 24 2c |substr(t|.audit$,|
|000033f0| 31 31 2c 31 29 20 7c 7c | 20 27 2f 27 20 7c 7c 20 |11,1) ||| '/' || |
|00003400| 73 75 62 73 74 72 28 74 | 2e 61 75 64 69 74 24 2c |substr(t|.audit$,|
|00003410| 31 32 2c 31 29 2c 0a 73 | 75 62 73 74 72 28 74 2e |12,1),.s|ubstr(t.|
|00003420| 61 75 64 69 74 24 2c 31 | 33 2c 31 29 20 7c 7c 20 |audit$,1|3,1) || |
|00003430| 27 2f 27 20 7c 7c 20 73 | 75 62 73 74 72 28 74 2e |'/' || s|ubstr(t.|
|00003440| 61 75 64 69 74 24 2c 31 | 34 2c 31 29 2c 0a 73 75 |audit$,1|4,1),.su|
|00003450| 62 73 74 72 28 74 2e 61 | 75 64 69 74 24 2c 31 35 |bstr(t.a|udit$,15|
|00003460| 2c 31 29 20 7c 7c 20 27 | 2f 27 20 7c 7c 20 73 75 |,1) || '|/' || su|
|00003470| 62 73 74 72 28 74 2e 61 | 75 64 69 74 24 2c 31 36 |bstr(t.a|udit$,16|
|00003480| 2c 31 29 2c 0a 73 75 62 | 73 74 72 28 74 2e 61 75 |,1),.sub|str(t.au|
|00003490| 64 69 74 24 2c 31 37 2c | 31 29 20 7c 7c 20 27 2f |dit$,17,|1) || '/|
|000034a0| 27 20 7c 7c 20 73 75 62 | 73 74 72 28 74 2e 61 75 |' || sub|str(t.au|
|000034b0| 64 69 74 24 2c 31 38 2c | 31 29 2c 0a 73 75 62 73 |dit$,18,|1),.subs|
|000034c0| 74 72 28 74 2e 61 75 64 | 69 74 24 2c 31 39 2c 31 |tr(t.aud|it$,19,1|
|000034d0| 29 20 7c 7c 20 27 2f 27 | 20 7c 7c 20 73 75 62 73 |) || '/'| || subs|
|000034e0| 74 72 28 74 2e 61 75 64 | 69 74 24 2c 32 30 2c 31 |tr(t.aud|it$,20,1|
|000034f0| 29 2c 0a 73 75 62 73 74 | 72 28 74 2e 61 75 64 69 |),.subst|r(t.audi|
|00003500| 74 24 2c 32 31 2c 31 29 | 20 7c 7c 20 27 2f 27 20 |t$,21,1)| || '/' |
|00003510| 7c 7c 20 73 75 62 73 74 | 72 28 74 2e 61 75 64 69 ||| subst|r(t.audi|
|00003520| 74 24 2c 32 32 2c 31 29 | 0a 66 72 6f 6d 20 73 79 |t$,22,1)|.from sy|
|00003530| 73 2e 6f 62 6a 24 20 6f | 2c 20 73 79 73 2e 75 73 |s.obj$ o|, sys.us|
|00003540| 65 72 24 20 75 2c 20 73 | 79 73 2e 76 69 65 77 24 |er$ u, s|ys.view$|
|00003550| 20 74 0a 77 68 65 72 65 | 20 6f 2e 74 79 70 65 20 | t.where| o.type |
|00003560| 3d 20 34 20 61 6e 64 20 | 6f 2e 6e 61 6d 65 20 21 |= 4 and |o.name !|
|00003570| 3d 20 27 5f 64 65 66 61 | 75 6c 74 5f 61 75 64 69 |= '_defa|ult_audi|
|00003580| 74 69 6e 67 5f 6f 70 74 | 69 6f 6e 73 5f 27 0a 61 |ting_opt|ions_'.a|
|00003590| 6e 64 20 6f 2e 6e 61 6d | 65 20 21 3d 20 27 5f 73 |nd o.nam|e != '_s|
|000035a0| 79 73 74 65 6d 5f 61 75 | 64 69 74 69 6e 67 5f 6f |ystem_au|diting_o|
|000035b0| 70 74 69 6f 6e 73 5f 27 | 0a 61 6e 64 20 6f 2e 6f |ptions_'|.and o.o|
|000035c0| 77 6e 65 72 23 20 3d 20 | 75 2e 75 73 65 72 23 20 |wner# = |u.user# |
|000035d0| 61 6e 64 20 6f 2e 6f 62 | 6a 23 20 3d 20 74 2e 6f |and o.ob|j# = t.o|
|000035e0| 62 6a 23 0a 61 6e 64 20 | 28 6f 2e 6f 77 6e 65 72 |bj#.and |(o.owner|
|000035f0| 23 20 3d 20 75 69 64 20 | 6f 72 20 65 07 00 8e 0c |# = uid |or e....|
|00003600| 06 01 00 00 eb 04 00 01 | 8e 0c 00 00 09 00 00 00 |........|........|
|00003610| 00 00 00 00 01 00 94 02 | 00 01 0f 09 00 00 00 00 |........|........|
|00003620| 01 00 00 00 00 00 00 00 | 00 00 1b 00 51 00 00 00 |........|....Q...|
|00003630| 4c 00 00 01 08 00 08 02 | 00 80 00 00 0f 09 00 00 |L.......|........|
|00003640| 00 01 03 00 ff ff 18 00 | 2e 01 16 01 16 01 00 00 |........|........|
|00003650| 03 00 74 03 47 03 2e 01 | 00 00 00 00 00 00 00 00 |..t.G...|........|
|00003660| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003670| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003680| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003690| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000036a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000036b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000036c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000036d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000036e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000036f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003700| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003710| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003720| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003730| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003740| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003750| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003760| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 2c 00 |........|......,.|
|00003770| 05 03 c2 04 3c 18 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |....<.--|--------|
|00003780| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 02 c1 |--------|------..|
|00003790| 17 03 c2 05 60 fe ef 01 | 73 65 6c 65 63 74 20 75 |....`...|select u|
|000037a0| 73 65 72 69 64 2c 20 75 | 73 65 72 68 6f 73 74 2c |serid, u|serhost,|
|000037b0| 20 74 65 72 6d 69 6e 61 | 6c 2c 20 74 69 6d 65 73 | termina|l, times|
|000037c0| 74 61 6d 70 2c 20 6f 62 | 6a 24 63 72 65 61 74 6f |tamp, ob|j$creato|
|000037d0| 72 2c 20 6f 62 6a 24 6e | 61 6d 65 2c 0a 74 2e 61 |r, obj$n|ame,.t.a|
|000037e0| 63 74 69 6f 6e 20 61 63 | 74 69 6f 6e 2c 20 61 63 |ction ac|tion, ac|
|000037f0| 74 2e 6e 61 6d 65 20 61 | 63 74 69 6f 6e 5f 6e 61 |t.name a|ction_na|
|00003800| 6d 65 2c 20 6e 65 77 24 | 6e 61 6d 65 2c 0a 61 75 |me, new$|name,.au|
|00003810| 74 68 24 70 72 69 76 69 | 6c 65 67 65 73 2c 20 61 |th$privi|leges, a|
|00003820| 75 74 68 24 67 72 61 6e | 74 65 65 2c 20 73 65 73 |uth$gran|tee, ses|
|00003830| 24 61 63 74 69 6f 6e 73 | 2c 0a 6c 6f 67 6f 66 66 |$actions|,.logoff|
|00003840| 24 74 69 6d 65 2c 20 6c | 6f 67 6f 66 66 24 6c 72 |$time, l|ogoff$lr|
|00003850| 65 61 64 2c 20 6c 6f 67 | 6f 66 66 24 70 72 65 61 |ead, log|off$prea|
|00003860| 64 2c 20 6c 6f 67 6f 66 | 66 24 6c 77 72 69 74 65 |d, logof|f$lwrite|
|00003870| 2c 20 6c 6f 67 6f 66 66 | 24 64 65 61 64 2c 0a 63 |, logoff|$dead,.c|
|00003880| 6f 6d 6d 65 6e 74 24 74 | 65 78 74 2c 20 73 65 73 |omment$t|ext, ses|
|00003890| 73 69 6f 6e 69 64 2c 20 | 65 6e 74 72 79 69 64 2c |sionid, |entryid,|
|000038a0| 20 73 74 61 74 65 6d 65 | 6e 74 2c 20 72 65 74 75 | stateme|nt, retu|
|000038b0| 72 6e 63 6f 64 65 0a 66 | 72 6f 6d 20 73 79 73 2e |rncode.f|rom sys.|
|000038c0| 61 75 64 24 20 74 2c 20 | 61 75 64 69 74 5f 61 63 |aud$ t, |audit_ac|
|000038d0| 74 69 6f 6e 73 20 61 63 | 74 0a 77 68 65 72 65 20 |tions ac|t.where |
|000038e0| 74 2e 61 63 74 69 6f 6e | 20 3d 20 61 63 74 2e 61 |t.action| = act.a|
|000038f0| 63 74 69 6f 6e 0a 61 6e | 64 20 28 74 2e 6f 62 6a |ction.an|d (t.obj|
|00003900| 24 63 72 65 61 74 6f 72 | 20 3d 20 75 73 65 72 0a |$creator| = user.|
|00003910| 6f 72 20 28 74 2e 6f 62 | 6a 24 63 72 65 61 74 6f |or (t.ob|j$creato|
|00003920| 72 20 69 73 20 6e 75 6c | 6c 20 61 6e 64 20 74 2e |r is nul|l and t.|
|00003930| 75 73 65 72 69 64 20 3d | 20 75 73 65 72 29 0a 6f |userid =| user).o|
|00003940| 72 20 65 78 69 73 74 73 | 0a 28 73 65 6c 65 63 74 |r exists|.(select|
|00003950| 20 6e 75 6c 6c 20 66 72 | 6f 6d 20 73 79 73 2e 75 | null fr|om sys.u|
|00003960| 73 65 72 24 0a 77 68 65 | 72 65 20 75 73 65 72 23 |ser$.whe|re user#|
|00003970| 20 3d 20 75 69 64 20 61 | 6e 64 20 64 62 61 24 20 | = uid a|nd dba$ |
|00003980| 3d 20 31 29 0a 29 0a 28 | 00 04 01 00 04 e9 00 00 |= 1).).(|........|
|00003990| 03 c2 04 39 18 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |...9.---|--------|
|000039a0| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 02 c1 0f |--------|-----...|
|000039b0| 03 c2 13 11 06 00 01 44 | 78 69 73 74 73 20 28 73 |.......D|xists (s|
|000039c0| 65 6c 65 63 74 20 6e 75 | 6c 6c 20 66 72 6f 6d 20 |elect nu|ll from |
|000039d0| 73 79 73 2e 75 73 65 72 | 24 20 20 77 68 65 72 65 |sys.user|$  where|
|000039e0| 20 75 73 65 72 23 20 3d | 20 75 69 64 20 61 6e 64 | user# =| uid and|
|000039f0| 20 64 62 61 24 20 3d 20 | 31 29 29 0a 09 00 8e 0c | dba$ = |1)).....|
|00003a00| 06 01 00 00 ec 04 00 01 | 8e 0c 00 00 07 00 00 00 |........|........|
|00003a10| 00 00 00 00 01 00 94 02 | 00 01 19 09 00 00 00 00 |........|........|
|00003a20| 01 00 00 00 00 00 00 00 | 00 00 13 00 52 00 00 00 |........|....R...|
|00003a30| 5d 00 00 01 08 00 09 02 | 00 80 00 00 18 09 00 00 |].......|........|
|00003a40| 00 01 02 00 ff ff 16 00 | 88 00 72 00 72 00 00 00 |........|..r.r...|
|00003a50| 02 00 f6 01 88 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003a60| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003a70| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003a80| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003a90| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003aa0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003ab0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003ac0| 00 00 00 00 00 00 00 00 | 2c 00 05 03 c2 04 3e 18 |........|,.....>.|
|00003ad0| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|00003ae0| 2d 2d 2d 2d 2d 2d 2d 2d | 02 c1 10 03 c2 04 19 fe |--------|........|
|00003af0| 44 01 73 65 6c 65 63 74 | 20 75 73 65 72 69 64 2c |D.select| userid,|
|00003b00| 20 75 73 65 72 68 6f 73 | 74 2c 20 74 65 72 6d 69 | userhos|t, termi|
|00003b10| 6e 61 6c 2c 20 74 69 6d | 65 73 74 61 6d 70 2c 0a |nal, tim|estamp,.|
|00003b20| 6f 62 6a 24 63 72 65 61 | 74 6f 72 2c 20 6f 62 6a |obj$crea|tor, obj|
|00003b30| 24 6e 61 6d 65 2c 20 74 | 2e 61 63 74 69 6f 6e 20 |$name, t|.action |
|00003b40| 61 63 74 69 6f 6e 2c 20 | 61 63 74 2e 6e 61 6d 65 |action, |act.name|
|00003b50| 20 61 63 74 69 6f 6e 5f | 6e 61 6d 65 2c 0a 61 75 | action_|name,.au|
|00003b60| 74 68 24 70 72 69 76 69 | 6c 65 67 65 73 2c 20 61 |th$privi|leges, a|
|00003b70| 75 74 68 24 67 72 61 6e | 74 65 65 2c 20 6e 65 77 |uth$gran|tee, new|
|00003b80| 24 6e 61 6d 65 2c 0a 73 | 65 73 73 69 6f 6e 69 64 |$name,.s|essionid|
|00003b90| 2c 20 65 6e 74 72 79 69 | 64 2c 20 73 74 61 74 65 |, entryi|d, state|
|00003ba0| 6d 65 6e 74 2c 20 72 65 | 74 75 72 6e 63 6f 64 65 |ment, re|turncode|
|00003bb0| 0a 66 72 6f 6d 20 73 79 | 73 2e 61 75 64 24 20 74 |.from sy|s.aud$ t|
|00003bc0| 2c 20 61 75 64 69 74 5f | 61 63 74 69 6f 6e 73 20 |, audit_|actions |
|00003bd0| 61 63 74 0a 77 68 65 72 | 65 20 74 2e 61 63 74 69 |act.wher|e t.acti|
|00003be0| 6f 6e 20 3d 20 61 63 74 | 2e 61 63 74 69 6f 6e 0a |on = act|.action.|
|00003bf0| 61 6e 64 20 72 65 74 75 | 72 6e 63 6f 64 65 20 69 |and retu|rncode i|
|00003c00| 6e 20 28 39 34 32 2c 20 | 39 34 33 2c 20 39 35 39 |n (942, |943, 959|
|00003c10| 2c 20 31 34 31 38 2c 20 | 31 34 33 32 2c 20 31 34 |, 1418, |1432, 14|
|00003c20| 33 34 2c 20 31 34 33 35 | 2c 20 32 30 31 39 2c 20 |34, 1435|, 2019, |
|00003c30| 32 32 38 39 29 0a 2c 00 | 05 03 c2 04 3d 18 2d 2d |2289).,.|....=.--|
|00003c40| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|00003c50| 2d 2d 2d 2d 2d 2d 02 c1 | 12 03 c2 05 0d fe 9c 01 |------..|........|
|00003c60| 73 65 6c 65 63 74 20 75 | 73 65 72 69 64 2c 20 75 |select u|serid, u|
|00003c70| 73 65 72 68 6f 73 74 2c | 20 74 65 72 6d 69 6e 61 |serhost,| termina|
|00003c80| 6c 2c 20 74 69 6d 65 73 | 74 61 6d 70 2c 0a 6f 62 |l, times|tamp,.ob|
|00003c90| 6a 24 63 72 65 61 74 6f | 72 2c 20 6f 62 6a 24 6e |j$creato|r, obj$n|
|00003ca0| 61 6d 65 2c 20 74 2e 61 | 63 74 69 6f 6e 20 61 63 |ame, t.a|ction ac|
|00003cb0| 74 69 6f 6e 2c 20 61 63 | 74 2e 6e 61 6d 65 20 61 |tion, ac|t.name a|
|00003cc0| 63 74 69 6f 6e 5f 6e 61 | 6d 65 2c 0a 73 75 62 73 |ction_na|me,.subs|
|00003cd0| 74 72 28 61 75 74 68 24 | 70 72 69 76 69 6c 65 67 |tr(auth$|privileg|
|00003ce0| 65 73 2c 31 2c 31 29 20 | 63 6f 6e 6e 65 63 74 24 |es,1,1) |connect$|
|00003cf0| 2c 0a 73 75 62 73 74 72 | 28 61 75 74 68 24 70 72 |,.substr|(auth$pr|
|00003d00| 69 76 69 6c 65 67 65 73 | 2c 32 2c 31 29 20 64 62 |ivileges|,2,1) db|
|00003d10| 61 24 2c 0a 73 75 62 73 | 74 72 28 61 75 74 68 24 |a$,.subs|tr(auth$|
|00003d20| 70 72 69 76 69 6c 65 67 | 65 73 2c 33 2c 31 29 20 |privileg|es,3,1) |
|00003d30| 72 65 73 6f 75 72 63 65 | 24 2c 0a 61 75 74 68 24 |resource|$,.auth$|
|00003d40| 67 72 61 6e 74 65 65 2c | 20 6e 65 77 24 6e 61 6d |grantee,| new$nam|
|00003d50| 65 2c 0a 73 65 73 73 69 | 6f 6e 69 64 2c 20 65 6e |e,.sessi|onid, en|
|00003d60| 74 72 79 69 64 2c 20 73 | 74 61 74 65 6d 65 6e 74 |tryid, s|tatement|
|00003d70| 2c 20 72 65 74 75 72 6e | 63 6f 64 65 0a 66 72 6f |, return|code.fro|
|00003d80| 6d 20 20 73 79 73 2e 61 | 75 64 24 20 74 2c 20 61 |m  sys.a|ud$ t, a|
|00003d90| 75 64 69 74 5f 61 63 74 | 69 6f 6e 73 20 61 63 74 |udit_act|ions act|
|00003da0| 0a 77 68 65 72 65 20 74 | 2e 61 63 74 69 6f 6e 20 |.where t|.action |
|00003db0| 3d 20 61 63 74 2e 61 63 | 74 69 6f 6e 0a 61 6e 64 |= act.ac|tion.and|
|00003dc0| 20 28 74 2e 61 63 74 69 | 6f 6e 20 62 65 74 77 65 | (t.acti|on betwe|
|00003dd0| 65 6e 20 32 34 20 61 6e | 64 20 32 35 0a 6f 72 20 |en 24 an|d 25.or |
|00003de0| 74 2e 61 63 74 69 6f 6e | 20 62 65 74 77 65 65 6e |t.action| between|
|00003df0| 20 36 34 20 61 6e 64 20 | 37 33 29 0a 07 00 8e 0c | 64 and |73).....|
|00003e00| 06 01 00 00 ed 04 00 01 | 8e 0c 00 00 08 00 00 00 |........|........|
|00003e10| 00 00 00 00 01 00 94 02 | 00 01 23 09 00 00 00 00 |........|..#.....|
|00003e20| 01 00 00 00 00 00 00 00 | 00 00 06 00 52 00 00 00 |........|....R...|
|00003e30| 42 02 00 01 08 00 0a 02 | 00 80 00 00 23 09 00 00 |B.......|....#...|
|00003e40| 00 01 02 00 ff ff 16 00 | c2 00 ac 00 ac 00 00 00 |........|........|
|00003e50| 02 00 39 02 c2 00 00 00 | 00 00 00 00 00 00 00 00 |..9.....|........|
|00003e60| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003e70| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003e80| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003e90| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003ea0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003eb0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003ec0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003ed0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003ee0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003ef0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00003f00| 00 00 2c 00 05 03 c2 04 | 40 18 2d 2d 2d 2d 2d 2d |..,.....|@.------|
|00003f10| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|00003f20| 2d 2d 02 c1 0d 03 c2 04 | 22 fe 4d 01 73 65 6c 65 |--......|".M.sele|
|00003f30| 63 74 20 75 73 65 72 69 | 64 2c 20 75 73 65 72 68 |ct useri|d, userh|
|00003f40| 6f 73 74 2c 20 74 65 72 | 6d 69 6e 61 6c 2c 0a 64 |ost, ter|minal,.d|
|00003f50| 65 63 6f 64 65 28 61 63 | 74 69 6f 6e 2c 20 36 30 |ecode(ac|tion, 60|
|00003f60| 2c 20 27 4c 4f 47 4f 4e | 27 2c 20 36 31 2c 20 27 |, 'LOGON|', 61, '|
|00003f70| 4c 4f 47 4f 46 46 27 2c | 20 36 32 2c 20 27 43 4c |LOGOFF',| 62, 'CL|
|00003f80| 45 41 4e 55 50 27 29 2c | 0a 74 69 6d 65 73 74 61 |EANUP'),|.timesta|
|00003f90| 6d 70 2c 20 6c 6f 67 6f | 66 66 24 74 69 6d 65 2c |mp, logo|ff$time,|
|00003fa0| 0a 6c 6f 67 6f 66 66 24 | 6c 72 65 61 64 2c 20 6c |.logoff$|lread, l|
|00003fb0| 6f 67 6f 66 66 24 70 72 | 65 61 64 2c 20 6c 6f 67 |ogoff$pr|ead, log|
|00003fc0| 6f 66 66 24 6c 77 72 69 | 74 65 2c 20 6c 6f 67 6f |off$lwri|te, logo|
|00003fd0| 66 66 24 64 65 61 64 2c | 0a 73 65 73 73 69 6f 6e |ff$dead,|.session|
|00003fe0| 69 64 2c 20 72 65 74 75 | 72 6e 63 6f 64 65 0a 66 |id, retu|rncode.f|
|00003ff0| 72 6f 6d 20 73 79 73 2e | 61 75 64 24 0a 77 68 65 |rom sys.|aud$.whe|
|00004000| 72 65 20 61 63 74 69 6f | 6e 20 62 65 74 77 65 65 |re actio|n betwee|
|00004010| 6e 20 36 30 20 61 6e 64 | 20 36 32 0a 61 6e 64 20 |n 60 and| 62.and |
|00004020| 28 75 73 65 72 69 64 20 | 3d 20 75 73 65 72 0a 6f |(userid |= user.o|
|00004030| 72 20 65 78 69 73 74 73 | 0a 28 73 65 6c 65 63 74 |r exists|.(select|
|00004040| 20 6e 75 6c 6c 0a 66 72 | 6f 6d 20 20 73 79 73 2e | null.fr|om  sys.|
|00004050| 75 73 65 72 24 0a 77 68 | 65 72 65 20 75 73 65 72 |user$.wh|ere user|
|00004060| 23 20 3d 20 75 69 64 20 | 61 6e 64 20 64 62 61 24 |# = uid |and dba$|
|00004070| 20 3d 20 31 0a 29 0a 29 | 0a 2c 00 05 03 c2 04 3f | = 1.).)|.,.....?|
|00004080| 18 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |.-------|--------|
|00004090| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 02 c1 0d 03 c2 04 2e |--------|-.......|
|000040a0| fe 59 01 73 65 6c 65 63 | 74 20 75 73 65 72 69 64 |.Y.selec|t userid|
|000040b0| 2c 20 75 73 65 72 68 6f | 73 74 2c 20 74 65 72 6d |, userho|st, term|
|000040c0| 69 6e 61 6c 2c 0a 64 65 | 63 6f 64 65 28 61 63 74 |inal,.de|code(act|
|000040d0| 69 6f 6e 2c 20 36 30 2c | 20 27 4c 4f 47 4f 4e 27 |ion, 60,| 'LOGON'|
|000040e0| 2c 20 36 31 2c 20 27 4c | 4f 47 4f 46 46 27 2c 20 |, 61, 'L|OGOFF', |
|000040f0| 36 32 2c 20 27 43 4c 45 | 41 4e 55 50 27 29 20 61 |62, 'CLE|ANUP') a|
|00004100| 63 74 69 6f 6e 5f 6e 61 | 6d 65 2c 0a 74 69 6d 65 |ction_na|me,.time|
|00004110| 73 74 61 6d 70 2c 20 6c | 6f 67 6f 66 66 24 74 69 |stamp, l|ogoff$ti|
|00004120| 6d 65 2c 0a 6c 6f 67 6f | 66 66 24 6c 72 65 61 64 |me,.logo|ff$lread|
|00004130| 2c 20 6c 6f 67 6f 66 66 | 24 70 72 65 61 64 2c 20 |, logoff|$pread, |
|00004140| 6c 6f 67 6f 66 66 24 6c | 77 72 69 74 65 2c 20 6c |logoff$l|write, l|
|00004150| 6f 67 6f 66 66 24 64 65 | 61 64 2c 0a 73 65 73 73 |ogoff$de|ad,.sess|
|00004160| 69 6f 6e 69 64 2c 20 72 | 65 74 75 72 6e 63 6f 64 |ionid, r|eturncod|
|00004170| 65 0a 66 72 6f 6d 20 73 | 79 73 2e 61 75 64 24 0a |e.from s|ys.aud$.|
|00004180| 77 68 65 72 65 20 61 63 | 74 69 6f 6e 20 62 65 74 |where ac|tion bet|
|00004190| 77 65 65 6e 20 36 30 20 | 61 6e 64 20 36 32 0a 61 |ween 60 |and 62.a|
|000041a0| 6e 64 20 28 75 73 65 72 | 69 64 20 3d 20 75 73 65 |nd (user|id = use|
|000041b0| 72 0a 6f 72 20 65 78 69 | 73 74 73 0a 28 73 65 6c |r.or exi|sts.(sel|
|000041c0| 65 63 74 20 6e 75 6c 6c | 0a 66 72 6f 6d 20 20 73 |ect null|.from  s|
|000041d0| 79 73 2e 75 73 65 72 24 | 0a 77 68 65 72 65 20 75 |ys.user$|.where u|
|000041e0| 73 65 72 23 20 3d 20 75 | 69 64 20 61 6e 64 20 64 |ser# = u|id and d|
|000041f0| 62 61 24 20 3d 20 31 0a | 29 0a 29 0a 08 00 8e 0c |ba$ = 1.|).).....|
|00004200| 06 01 00 00 ee 04 00 01 | 8e 0c 00 00 06 00 00 00 |........|........|
|00004210| 00 00 00 00 01 00 94 02 | 00 01 29 09 00 00 00 00 |........|..).....|
|00004220| 01 00 00 00 00 00 00 00 | 00 00 15 00 52 00 00 00 |........|....R...|
|00004230| 4b 02 00 01 08 00 01 02 | 00 80 00 00 29 09 00 00 |K.......|....)...|
|00004240| 00 01 01 00 ff ff 14 00 | 94 00 80 00 80 00 00 00 |........|........|
|00004250| 01 00 94 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004260| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004270| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004280| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004290| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000042a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000042b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000042c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000042d0| 00 00 00 00 2c 00 05 03 | c2 04 41 18 2d 2d 2d 2d |....,...|..A.----|
|000042e0| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|000042f0| 2d 2d 2d 2d 02 c1 1b 03 | c2 08 43 fe fe 02 73 65 |----....|..C...se|
|00004300| 6c 65 63 74 20 75 73 65 | 72 69 64 2c 20 75 73 65 |lect use|rid, use|
|00004310| 72 68 6f 73 74 2c 20 74 | 65 72 6d 69 6e 61 6c 2c |rhost, t|erminal,|
|00004320| 20 74 69 6d 65 73 74 61 | 6d 70 2c 0a 6f 62 6a 24 | timesta|mp,.obj$|
|00004330| 63 72 65 61 74 6f 72 2c | 20 6f 62 6a 24 6e 61 6d |creator,| obj$nam|
|00004340| 65 2c 20 74 2e 61 63 74 | 69 6f 6e 20 61 63 74 69 |e, t.act|ion acti|
|00004350| 6f 6e 2c 20 61 63 74 2e | 6e 61 6d 65 20 61 63 74 |on, act.|name act|
|00004360| 69 6f 6e 5f 6e 61 6d 65 | 2c 0a 6e 65 77 24 6e 61 |ion_name|,.new$na|
|00004370| 6d 65 2c 20 61 75 74 68 | 24 70 72 69 76 69 6c 65 |me, auth|$privile|
|00004380| 67 65 73 2c 20 61 75 74 | 68 24 67 72 61 6e 74 65 |ges, aut|h$grante|
|00004390| 65 2c 0a 73 75 62 73 74 | 72 28 73 65 73 24 61 63 |e,.subst|r(ses$ac|
|000043a0| 74 69 6f 6e 73 2c 31 2c | 31 29 20 61 6c 74 2c 0a |tions,1,|1) alt,.|
|000043b0| 73 75 62 73 74 72 28 73 | 65 73 24 61 63 74 69 6f |substr(s|es$actio|
|000043c0| 6e 73 2c 32 2c 31 29 20 | 61 75 64 2c 0a 73 75 62 |ns,2,1) |aud,.sub|
|000043d0| 73 74 72 28 73 65 73 24 | 61 63 74 69 6f 6e 73 2c |str(ses$|actions,|
|000043e0| 33 2c 31 29 20 63 6f 6d | 2c 0a 73 75 62 73 74 72 |3,1) com|,.substr|
|000043f0| 28 73 65 73 24 61 63 74 | 69 6f 6e 73 2c 34 2c 31 |(ses$act|ions,4,1|
|00004400| 29 20 64 65 6c 2c 0a 73 | 75 62 73 74 72 28 73 65 |) del,.s|ubstr(se|
|00004410| 73 24 61 63 74 69 6f 6e | 73 2c 35 2c 31 29 20 67 |s$action|s,5,1) g|
|00004420| 72 61 2c 0a 73 75 62 73 | 74 72 28 73 65 73 24 61 |ra,.subs|tr(ses$a|
|00004430| 63 74 69 6f 6e 73 2c 36 | 2c 31 29 20 69 6e 64 2c |ctions,6|,1) ind,|
|00004440| 0a 73 75 62 73 74 72 28 | 73 65 73 24 61 63 74 69 |.substr(|ses$acti|
|00004450| 6f 6e 73 2c 37 2c 31 29 | 20 69 6e 73 2c 0a 73 75 |ons,7,1)| ins,.su|
|00004460| 62 73 74 72 28 73 65 73 | 24 61 63 74 69 6f 6e 73 |bstr(ses|$actions|
|00004470| 2c 38 2c 31 29 20 6c 6f | 63 2c 0a 73 75 62 73 74 |,8,1) lo|c,.subst|
|00004480| 72 28 73 65 73 24 61 63 | 74 69 6f 6e 73 2c 39 2c |r(ses$ac|tions,9,|
|00004490| 31 29 20 72 65 6e 2c 0a | 73 75 62 73 74 72 28 73 |1) ren,.|substr(s|
|000044a0| 65 73 24 61 63 74 69 6f | 6e 73 2c 31 30 2c 31 29 |es$actio|ns,10,1)|
|000044b0| 20 73 65 6c 2c 0a 73 75 | 62 73 74 72 28 73 65 73 | sel,.su|bstr(ses|
|000044c0| 24 61 63 74 69 6f 6e 73 | 2c 31 31 2c 31 29 20 75 |$actions|,11,1) u|
|000044d0| 70 64 2c 0a 73 65 73 73 | 69 6f 6e 69 64 2c 20 65 |pd,.sess|ionid, e|
|000044e0| 6e 74 72 79 69 64 2c 20 | 73 74 61 74 65 6d 65 6e |ntryid, |statemen|
|000044f0| 74 2c 20 72 65 74 75 72 | 6e 63 6f 64 65 0a 66 72 |t, retur|ncode.fr|
|00004500| 6f 6d 20 73 79 73 2e 61 | 75 64 24 20 74 2c 20 61 |om sys.a|ud$ t, a|
|00004510| 75 64 69 74 5f 61 63 74 | 69 6f 6e 73 20 61 63 74 |udit_act|ions act|
|00004520| 0a 77 68 65 72 65 20 20 | 74 2e 61 63 74 69 6f 6e |.where  |t.action|
|00004530| 20 3d 20 61 63 74 2e 61 | 63 74 69 6f 6e 0a 61 6e | = act.a|ction.an|
|00004540| 64 20 74 2e 61 63 74 69 | 6f 6e 20 3c 3d 20 36 33 |d t.acti|on <= 63|
|00004550| 0a 61 6e 64 20 6e 6f 74 | 20 28 74 2e 61 63 74 69 |.and not| (t.acti|
|00004560| 6f 6e 20 69 6e 20 28 31 | 2c 34 2c 35 2c 38 2c 31 |on in (1|,4,5,8,1|
|00004570| 31 2c 31 32 2c 31 33 2c | 31 34 2c 31 39 2c 32 30 |1,12,13,|14,19,20|
|00004580| 2c 32 31 2c 32 32 2c 32 | 34 2c 32 35 2c 36 30 2c |,21,22,2|4,25,60,|
|00004590| 36 31 2c 36 32 29 29 0a | 61 6e 64 20 28 74 2e 6f |61,62)).|and (t.o|
|000045a0| 62 6a 24 63 72 65 61 74 | 6f 72 20 3d 20 75 73 65 |bj$creat|or = use|
|000045b0| 72 0a 6f 72 20 65 78 69 | 73 74 73 0a 28 73 65 6c |r.or exi|sts.(sel|
|000045c0| 65 63 74 20 6e 75 6c 6c | 0a 66 72 6f 6d 09 20 73 |ect null|.from. s|
|000045d0| 79 73 2e 75 73 65 72 24 | 0a 77 68 65 72 65 20 75 |ys.user$|.where u|
|000045e0| 73 65 72 23 20 3d 20 75 | 69 64 20 61 6e 64 20 64 |ser# = u|id and d|
|000045f0| 62 61 24 20 3d 20 31 0a | 29 0a 29 0a 06 00 8e 0c |ba$ = 1.|).).....|
|00004600| 06 01 00 00 ef 04 00 01 | 8e 0c 00 00 09 00 00 00 |........|........|
|00004610| 00 00 00 00 01 00 94 02 | 00 01 36 09 00 00 00 00 |........|..6.....|
|00004620| 01 00 00 00 00 00 00 00 | 00 00 0e 00 53 00 00 00 |........|....S...|
|00004630| 58 02 00 01 08 00 0b 02 | 00 80 00 00 35 09 00 00 |X.......|....5...|
|00004640| 00 01 03 00 ff ff 18 00 | b9 01 a1 01 a1 01 00 00 |........|........|
|00004650| 03 00 2a 03 a3 02 b9 01 | 00 00 00 00 00 00 00 00 |..*.....|........|
|00004660| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004670| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004680| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004690| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000046a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000046b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000046c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000046d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000046e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000046f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004700| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004710| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004720| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004730| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004740| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004750| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004760| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004770| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004780| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004790| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000047a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000047b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000047c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000047d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000047e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000047f0| 00 00 00 00 00 00 00 00 | 00 2c 00 05 03 c2 04 44 |........|.,.....D|
|00004800| 18 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |.-------|--------|
|00004810| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 02 c1 09 03 c2 02 5f |--------|-......_|
|00004820| c2 73 65 6c 65 63 74 20 | 74 73 2e 6e 61 6d 65 2c |.select |ts.name,|
|00004830| 20 64 65 63 6f 64 65 28 | 74 73 2e 6f 6e 6c 69 6e | decode(|ts.onlin|
|00004840| 65 24 2c 20 31 2c 20 27 | 4f 4e 4c 49 4e 45 27 2c |e$, 1, '|ONLINE',|
|00004850| 20 32 2c 20 27 4f 46 46 | 4c 49 4e 45 27 2c 20 27 | 2, 'OFF|LINE', '|
|00004860| 55 4e 44 45 46 49 4e 45 | 44 27 29 2c 0a 74 73 2e |UNDEFINE|D'),.ts.|
|00004870| 62 6c 6f 63 6b 73 69 7a | 65 2c 20 74 73 2e 64 66 |blocksiz|e, ts.df|
|00004880| 6c 6d 69 6e 65 78 74 2c | 0a 74 73 2e 64 66 6c 6d |lminext,|.ts.dflm|
|00004890| 61 78 65 78 74 2c 20 74 | 73 2e 64 66 6c 69 6e 69 |axext, t|s.dflini|
|000048a0| 74 2c 20 74 73 2e 64 66 | 6c 69 6e 63 72 2c 20 74 |t, ts.df|lincr, t|
|000048b0| 73 2e 64 66 6c 65 78 74 | 70 63 74 0a 66 72 6f 6d |s.dflext|pct.from|
|000048c0| 20 20 73 79 73 2e 74 73 | 24 20 74 73 0a 77 68 65 |  sys.ts|$ ts.whe|
|000048d0| 72 65 20 74 73 2e 6f 6e | 6c 69 6e 65 24 20 21 3d |re ts.on|line$ !=|
|000048e0| 20 33 0a 2c 00 05 03 c2 | 04 43 18 2d 2d 2d 2d 2d | 3.,....|.C.-----|
|000048f0| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|00004900| 2d 2d 2d 02 c1 05 02 c1 | 61 60 73 65 6c 65 63 74 |---.....|a`select|
|00004910| 20 75 2e 6e 61 6d 65 2c | 20 6c 2e 6e 61 6d 65 2c | u.name,| l.name,|
|00004920| 20 6c 2e 68 6f 73 74 2c | 20 6c 2e 75 73 65 72 69 | l.host,| l.useri|
|00004930| 64 0a 66 72 6f 6d 20 20 | 73 79 73 2e 75 73 65 72 |d.from  |sys.user|
|00004940| 24 20 75 2c 20 73 79 73 | 2e 6c 69 6e 6b 24 20 6c |$ u, sys|.link$ l|
|00004950| 0a 77 68 65 72 65 20 75 | 2e 75 73 65 72 23 20 3d |.where u|.user# =|
|00004960| 20 6c 2e 6f 77 6e 65 72 | 23 0a 2c 00 05 03 c2 04 | l.owner|#.,.....|
|00004970| 42 18 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |B.------|--------|
|00004980| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 02 c1 05 03 c2 02 |--------|--......|
|00004990| 07 6a 73 65 6c 65 63 74 | 20 6e 61 6d 65 2c 20 64 |.jselect| name, d|
|000049a0| 65 63 6f 64 65 28 6f 77 | 6e 65 72 23 2c 20 31 2c |ecode(ow|ner#, 1,|
|000049b0| 20 27 50 55 42 4c 49 43 | 27 2c 20 27 50 52 49 56 | 'PUBLIC|', 'PRIV|
|000049c0| 41 54 45 27 29 2c 20 68 | 6f 73 74 2c 20 75 73 65 |ATE'), h|ost, use|
|000049d0| 72 69 64 0a 66 72 6f 6d | 20 20 73 79 73 2e 6c 69 |rid.from|  sys.li|
|000049e0| 6e 6b 24 0a 77 68 65 72 | 65 20 6f 77 6e 65 72 23 |nk$.wher|e owner#|
|000049f0| 20 69 6e 20 28 31 2c 75 | 69 64 29 0a 09 00 8e 0c | in (1,u|id).....|
|00004a00| 06 01 00 00 f0 04 00 01 | 8e 0c 00 00 09 00 00 00 |........|........|
|00004a10| 00 00 00 00 01 00 94 02 | 00 01 43 09 00 00 00 00 |........|..C.....|
|00004a20| 01 00 00 00 00 00 00 00 | 00 00 17 00 53 00 00 00 |........|....S...|
|00004a30| 68 02 00 01 08 00 03 02 | 00 80 00 00 43 09 00 00 |h.......|....C...|
|00004a40| 00 01 03 00 ff ff 18 00 | 94 00 7c 00 7c 00 00 00 |........|..|.|...|
|00004a50| 03 00 11 02 54 01 94 00 | 00 00 00 00 00 00 00 00 |....T...|........|
|00004a60| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004a70| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004a80| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004a90| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004aa0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004ab0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004ac0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004ad0| 00 00 00 00 2c 00 05 03 | c2 04 47 18 2d 2d 2d 2d |....,...|..G.----|
|00004ae0| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|00004af0| 2d 2d 2d 2d 02 c1 06 03 | c2 02 35 98 73 65 6c 65 |----....|..5.sele|
|00004b00| 63 74 20 74 73 2e 6e 61 | 6d 65 2c 20 75 2e 6e 61 |ct ts.na|me, u.na|
|00004b10| 6d 65 2c 20 74 73 71 2e | 75 73 65 72 23 2c 20 74 |me, tsq.|user#, t|
|00004b20| 73 71 2e 62 6c 6f 63 6b | 73 2c 20 74 73 71 2e 6d |sq.block|s, tsq.m|
|00004b30| 61 78 62 6c 6f 63 6b 73 | 0a 66 72 6f 6d 20 20 73 |axblocks|.from  s|
|00004b40| 79 73 2e 75 73 65 72 24 | 20 75 2c 20 73 79 73 2e |ys.user$| u, sys.|
|00004b50| 74 73 71 24 20 74 73 71 | 2c 20 73 79 73 2e 74 73 |tsq$ tsq|, sys.ts|
|00004b60| 24 20 74 73 0a 77 68 65 | 72 65 20 75 2e 75 73 65 |$ ts.whe|re u.use|
|00004b70| 72 23 20 3d 20 74 73 71 | 2e 75 73 65 72 23 0a 61 |r# = tsq|.user#.a|
|00004b80| 6e 64 20 74 73 71 2e 74 | 73 23 20 3d 20 74 73 2e |nd tsq.t|s# = ts.|
|00004b90| 74 73 23 0a 2c 00 05 03 | c2 04 46 18 2d 2d 2d 2d |ts#.,...|..F.----|
|00004ba0| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|00004bb0| 2d 2d 2d 2d 02 c1 04 03 | c2 02 32 95 73 65 6c 65 |----....|..2.sele|
|00004bc0| 63 74 20 74 73 2e 6e 61 | 6d 65 2c 20 64 62 66 2e |ct ts.na|me, dbf.|
|00004bd0| 6e 61 6d 65 2c 20 66 2e | 62 6c 6f 63 6b 73 0a 66 |name, f.|blocks.f|
|00004be0| 72 6f 6d 20 20 73 79 73 | 2e 74 73 24 20 74 73 2c |rom  sys|.ts$ ts,|
|00004bf0| 20 73 79 73 2e 66 69 6c | 65 24 20 66 2c 20 73 79 | sys.fil|e$ f, sy|
|00004c00| 73 2e 76 24 64 62 66 69 | 6c 65 20 64 62 66 0a 77 |s.v$dbfi|le dbf.w|
|00004c10| 68 65 72 65 20 74 73 2e | 74 73 23 20 3d 20 66 2e |here ts.|ts# = f.|
|00004c20| 74 73 23 28 2b 29 20 61 | 6e 64 20 64 62 66 2e 66 |ts#(+) a|nd dbf.f|
|00004c30| 69 6c 65 23 20 3d 20 66 | 2e 66 69 6c 65 23 20 61 |ile# = f|.file# a|
|00004c40| 6e 64 20 66 2e 73 74 61 | 74 75 73 24 20 3d 20 32 |nd f.sta|tus$ = 2|
|00004c50| 0a 2c 00 05 03 c2 04 45 | 18 2d 2d 2d 2d 2d 2d 2d |.,.....E|.-------|
|00004c60| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|00004c70| 2d 02 c1 09 03 c2 04 56 | fe 81 01 73 65 6c 65 63 |-......V|...selec|
|00004c80| 74 20 74 73 2e 6e 61 6d | 65 2c 20 64 65 63 6f 64 |t ts.nam|e, decod|
|00004c90| 65 28 74 73 2e 6f 6e 6c | 69 6e 65 24 2c 20 31 2c |e(ts.onl|ine$, 1,|
|00004ca0| 20 27 4f 4e 4c 49 4e 45 | 27 2c 20 32 2c 20 27 4f | 'ONLINE|', 2, 'O|
|00004cb0| 46 46 4c 49 4e 45 27 2c | 20 27 55 4e 44 45 46 49 |FFLINE',| 'UNDEFI|
|00004cc0| 4e 45 44 27 29 2c 0a 74 | 73 2e 62 6c 6f 63 6b 73 |NED'),.t|s.blocks|
|00004cd0| 69 7a 65 2c 20 74 73 2e | 64 66 6c 6d 69 6e 65 78 |ize, ts.|dflminex|
|00004ce0| 74 2c 0a 74 73 2e 64 66 | 6c 6d 61 78 65 78 74 2c |t,.ts.df|lmaxext,|
|00004cf0| 20 74 73 2e 64 66 6c 69 | 6e 69 74 2c 20 74 73 2e | ts.dfli|nit, ts.|
|00004d00| 64 66 6c 69 6e 63 72 2c | 20 74 73 2e 64 66 6c 65 |dflincr,| ts.dfle|
|00004d10| 78 74 70 63 74 0a 66 72 | 6f 6d 20 20 73 79 73 2e |xtpct.fr|om  sys.|
|00004d20| 74 73 24 20 74 73 0a 77 | 68 65 72 65 20 74 73 2e |ts$ ts.w|here ts.|
|00004d30| 6f 6e 6c 69 6e 65 24 20 | 21 3d 20 33 20 61 6e 64 |online$ |!= 3 and|
|00004d40| 20 74 73 2e 74 73 23 20 | 69 6e 0a 28 73 65 6c 65 | ts.ts# |in.(sele|
|00004d50| 63 74 20 74 73 23 20 66 | 72 6f 6d 20 73 79 73 2e |ct ts# f|rom sys.|
|00004d60| 74 73 71 24 0a 77 68 65 | 72 65 20 20 75 73 65 72 |tsq$.whe|re  user|
|00004d70| 23 20 69 6e 20 28 75 69 | 64 2c 20 31 29 0a 75 6e |# in (ui|d, 1).un|
|00004d80| 69 6f 6e 0a 73 65 6c 65 | 63 74 20 74 73 23 20 66 |ion.sele|ct ts# f|
|00004d90| 72 6f 6d 20 73 79 73 2e | 74 73 24 0a 77 68 65 72 |rom sys.|ts$.wher|
|00004da0| 65 20 20 65 78 69 73 74 | 73 0a 28 73 65 6c 65 63 |e  exist|s.(selec|
|00004db0| 74 20 6e 75 6c 6c 20 66 | 72 6f 6d 20 73 79 73 2e |t null f|rom sys.|
|00004dc0| 75 73 65 72 24 0a 77 68 | 65 72 65 20 20 28 72 65 |user$.wh|ere  (re|
|00004dd0| 73 6f 75 72 63 65 24 20 | 3d 20 31 20 6f 72 20 64 |source$ |= 1 or d|
|00004de0| 62 61 24 20 3d 20 31 29 | 20 61 6e 64 20 75 73 65 |ba$ = 1)| and use|
|00004df0| 72 23 20 3d 20 75 69 64 | 29 0a 29 0a 09 00 8e 0c |r# = uid|).).....|
|00004e00| 06 01 00 00 f1 04 00 01 | 8e 0c 00 00 07 00 00 00 |........|........|
|00004e10| 00 00 00 00 01 00 94 02 | 00 01 25 0a 00 00 00 00 |........|..%.....|
|00004e20| 01 00 00 00 00 00 00 00 | 00 00 0a 00 5b 00 00 00 |........|....[...|
|00004e30| 51 00 00 01 09 00 0a 02 | 00 80 00 00 25 0a 00 00 |Q.......|....%...|
|00004e40| 00 01 02 00 ff ff 16 00 | fa 00 e4 00 e4 00 00 00 |........|........|
|00004e50| 02 00 9f 02 fa 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004e60| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004e70| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004e80| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004e90| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004ea0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004eb0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004ec0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004ed0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004ee0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004ef0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004f00| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004f10| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004f20| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00004f30| 00 00 00 00 00 00 00 00 | 00 00 2c 00 05 03 c2 05 |........|..,.....|
|00004f40| 47 18 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |G.------|--------|
|00004f50| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 02 c1 11 03 c2 04 |--------|--......|
|00004f60| 50 fe 7b 01 53 45 4c 45 | 43 54 20 6f 24 2e 6f 62 |P.{.SELE|CT o$.ob|
|00004f70| 6a 23 2c 6f 24 2e 6e 61 | 6d 65 2c 20 75 24 2e 6e |j#,o$.na|me, u$.n|
|00004f80| 61 6d 65 2c 20 6f 24 2e | 6f 77 6e 65 72 23 2c 20 |ame, o$.|owner#, |
|00004f90| 74 73 24 2e 6e 61 6d 65 | 2c 20 74 24 2e 66 69 6c |ts$.name|, t$.fil|
|00004fa0| 65 23 2c 0a 74 24 2e 62 | 6c 6f 63 6b 23 2c 20 74 |e#,.t$.b|lock#, t|
|00004fb0| 24 2e 61 75 64 69 74 24 | 2c 20 63 24 2e 63 6f 6d |$.audit$|, c$.com|
|00004fc0| 6d 65 6e 74 24 2c 20 4e | 56 4c 28 74 24 2e 63 6c |ment$, N|VL(t$.cl|
|00004fd0| 75 23 2c 20 30 29 2c 20 | 6f 24 2e 6d 74 69 6d 65 |u#, 0), |o$.mtime|
|00004fe0| 2c 0a 74 24 2e 6d 6f 64 | 69 66 69 65 64 2c 20 74 |,.t$.mod|ified, t|
|00004ff0| 24 2e 70 63 74 66 72 65 | 65 24 2c 20 74 24 2e 70 |$.pctfre|e$, t$.p|
|00005000| 63 74 75 73 65 64 24 2c | 20 74 24 2e 69 6e 69 74 |ctused$,| t$.init|
|00005010| 72 61 6e 73 2c 20 74 24 | 2e 6d 61 78 74 72 61 6e |rans, t$|.maxtran|
|00005020| 73 0a 46 52 4f 4d 20 73 | 79 73 2e 74 61 62 24 20 |s.FROM s|ys.tab$ |
|00005030| 74 24 2c 20 73 79 73 2e | 6f 62 6a 24 20 6f 24 2c |t$, sys.|obj$ o$,|
|00005040| 20 73 79 73 2e 74 73 24 | 20 74 73 24 2c 20 73 79 | sys.ts$| ts$, sy|
|00005050| 73 2e 75 73 65 72 24 20 | 75 24 2c 20 73 79 73 2e |s.user$ |u$, sys.|
|00005060| 63 6f 6d 24 20 63 24 0a | 57 48 45 52 45 20 20 74 |com$ c$.|WHERE  t|
|00005070| 24 2e 6f 62 6a 23 20 3d | 20 6f 24 2e 6f 62 6a 23 |$.obj# =| o$.obj#|
|00005080| 20 61 6e 64 20 74 24 2e | 74 73 23 20 3d 20 74 73 | and t$.|ts# = ts|
|00005090| 24 2e 74 73 23 20 61 6e | 64 0a 75 24 2e 75 73 65 |$.ts# an|d.u$.use|
|000050a0| 72 23 20 3d 20 6f 24 2e | 6f 77 6e 65 72 23 20 61 |r# = o$.|owner# a|
|000050b0| 6e 64 20 6f 24 2e 6f 62 | 6a 23 20 3d 20 63 24 2e |nd o$.ob|j# = c$.|
|000050c0| 6f 62 6a 23 28 2b 29 0a | 61 6e 64 20 63 24 2e 63 |obj#(+).|and c$.c|
|000050d0| 6f 6c 23 28 2b 29 20 69 | 73 20 6e 75 6c 6c 0a 2c |ol#(+) i|s null.,|
|000050e0| 00 05 03 c2 04 4a 18 2d | 2d 2d 2d 2d 2d 2d 2d 2d |.....J.-|--------|
|000050f0| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 02 |--------|-------.|
|00005100| c1 04 03 c2 03 2e f5 73 | 65 6c 65 63 74 20 75 2e |.......s|elect u.|
|00005110| 6e 61 6d 65 2c 20 74 73 | 2e 6e 61 6d 65 2c 0a 64 |name, ts|.name,.d|
|00005120| 65 63 6f 64 65 28 75 2e | 73 74 61 74 75 73 24 2c |ecode(u.|status$,|
|00005130| 20 32 2c 20 27 41 56 41 | 49 4c 41 42 4c 45 27 2c | 2, 'AVA|ILABLE',|
|00005140| 20 33 2c 20 27 49 4e 55 | 53 45 27 2c 0a 34 2c 20 | 3, 'INU|SE',.4, |
|00005150| 27 4f 46 46 4c 49 4e 45 | 27 2c 20 35 2c 20 27 4e |'OFFLINE|', 5, 'N|
|00005160| 45 45 44 20 52 45 43 4f | 56 45 52 59 27 2c 20 27 |EED RECO|VERY', '|
|00005170| 55 4e 44 45 46 49 4e 45 | 44 27 29 0a 66 72 6f 6d |UNDEFINE|D').from|
|00005180| 20 20 73 79 73 2e 75 6e | 64 6f 24 20 75 2c 20 73 |  sys.un|do$ u, s|
|00005190| 79 73 2e 74 73 24 20 74 | 73 2c 20 73 79 73 2e 73 |ys.ts$ t|s, sys.s|
|000051a0| 65 67 24 20 73 0a 77 68 | 65 72 65 20 75 2e 73 74 |eg$ s.wh|ere u.st|
|000051b0| 61 74 75 73 24 20 21 3d | 20 31 20 61 6e 64 20 75 |atus$ !=| 1 and u|
|000051c0| 2e 66 69 6c 65 23 20 3d | 20 73 2e 66 69 6c 65 23 |.file# =| s.file#|
|000051d0| 20 61 6e 64 20 75 2e 62 | 6c 6f 63 6b 23 20 3d 20 | and u.b|lock# = |
|000051e0| 73 2e 62 6c 6f 63 6b 23 | 0a 61 6e 64 20 73 2e 74 |s.block#|.and s.t|
|000051f0| 73 23 20 3d 20 74 73 2e | 74 73 23 0a 07 00 8e 0c |s# = ts.|ts#.....|
|00005200| 06 01 00 00 f2 04 00 01 | 8e 0c 00 00 08 00 00 00 |........|........|
|00005210| 00 00 00 00 01 00 94 02 | 00 01 31 0a 00 00 00 00 |........|..1.....|
|00005220| 01 00 00 00 00 00 00 00 | 00 00 18 00 5b 00 00 00 |........|....[...|
|00005230| 64 00 00 01 09 00 05 02 | 00 80 00 00 31 0a 00 00 |d.......|....1...|
|00005240| 00 01 03 00 ff ff 18 00 | 5b 01 43 01 43 01 00 00 |........|[.C.C...|
|00005250| 03 00 d3 02 ab 01 5b 01 | 00 00 00 00 00 00 00 00 |......[.|........|
|00005260| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005270| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005280| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005290| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000052a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000052b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000052c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000052d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000052e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000052f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005300| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005310| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005320| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005330| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005340| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005350| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005360| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005370| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005380| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005390| 00 00 00 00 00 00 00 00 | 00 00 00 2c 00 05 03 c2 |........|...,....|
|000053a0| 05 4a 18 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |.J.-----|--------|
|000053b0| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 02 c1 11 02 c1 |--------|---.....|
|000053c0| 2a 29 53 45 4c 45 43 54 | 20 2a 20 46 52 4f 4d 20 |*)SELECT| * FROM |
|000053d0| 65 78 75 74 61 62 20 57 | 48 45 52 45 20 6f 77 6e |exutab W|HERE own|
|000053e0| 65 72 69 64 20 3d 20 75 | 69 64 0a 2c 00 05 03 c2 |erid = u|id.,....|
|000053f0| 05 49 18 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |.I.-----|--------|
|00005400| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 02 c1 11 03 c2 |--------|---.....|
|00005410| 03 37 fe fe 00 53 45 4c | 45 43 54 20 74 2e 2a 20 |.7...SEL|ECT t.* |
|00005420| 46 52 4f 4d 20 65 78 75 | 74 61 62 20 74 2c 69 6e |FROM exu|tab t,in|
|00005430| 63 65 78 70 20 69 2c 20 | 69 6e 63 76 69 64 20 76 |cexp i, |incvid v|
|00005440| 0a 57 48 45 52 45 20 20 | 74 2e 6e 61 6d 65 20 20 |.WHERE  |t.name  |
|00005450| 3d 20 69 2e 6e 61 6d 65 | 28 2b 29 20 41 4e 44 20 |= i.name|(+) AND |
|00005460| 74 2e 6f 77 6e 65 72 69 | 64 20 3d 20 69 2e 6f 77 |t.owneri|d = i.ow|
|00005470| 6e 65 72 23 28 2b 29 20 | 41 4e 44 0a 4e 56 4c 28 |ner#(+) |AND.NVL(|
|00005480| 69 2e 74 79 70 65 2c 32 | 29 20 3d 20 32 20 41 4e |i.type,2|) = 2 AN|
|00005490| 44 0a 28 74 2e 6d 6f 64 | 69 66 69 65 64 20 3d 20 |D.(t.mod|ified = |
|000054a0| 31 20 4f 52 20 69 2e 69 | 74 69 6d 65 20 3e 20 4e |1 OR i.i|time > N|
|000054b0| 56 4c 28 69 2e 63 74 69 | 6d 65 2c 0a 54 4f 5f 44 |VL(i.cti|me,.TO_D|
|000054c0| 41 54 45 28 27 30 31 2d | 4a 41 4e 2d 30 31 27 2c |ATE('01-|JAN-01',|
|000054d0| 27 44 44 2d 4d 4f 4e 2d | 59 59 27 29 29 0a 4f 52 |'DD-MON-|YY')).OR|
|000054e0| 20 74 2e 6d 74 69 6d 65 | 20 3e 20 69 2e 69 74 69 | t.mtime| > i.iti|
|000054f0| 6d 65 20 4f 52 20 4e 56 | 4c 28 69 2e 65 78 70 69 |me OR NV|L(i.expi|
|00005500| 64 2c 39 39 39 39 29 20 | 3e 20 76 2e 65 78 70 69 |d,9999) |> v.expi|
|00005510| 64 29 0a 2c 00 05 03 c2 | 05 48 18 2d 2d 2d 2d 2d |d).,....|.H.-----|
|00005520| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |--------|--------|
|00005530| 2d 2d 2d 02 c1 11 03 c2 | 02 5e c1 53 45 4c 45 43 |---.....|.^.SELEC|
|00005540| 54 20 74 2e 2a 20 46 52 | 4f 4d 20 65 78 75 74 61 |T t.* FR|OM exuta|
|00005550| 62 20 74 2c 69 6e 63 65 | 78 70 20 69 2c 20 69 6e |b t,ince|xp i, in|
|00005560| 63 76 69 64 20 76 0a 57 | 48 45 52 45 20 74 2e 6e |cvid v.W|HERE t.n|
|00005570| 61 6d 65 20 20 3d 20 69 | 2e 6e 61 6d 65 28 2b 29 |ame  = i|.name(+)|
|00005580| 20 41 4e 44 20 74 2e 6f | 77 6e 65 72 69 64 20 3d | AND t.o|wnerid =|
|00005590| 20 69 2e 6f 77 6e 65 72 | 23 28 2b 29 20 41 4e 44 | i.owner|#(+) AND|
|000055a0| 0a 4e 56 4c 28 69 2e 74 | 79 70 65 2c 32 29 20 3d |.NVL(i.t|ype,2) =|
|000055b0| 20 32 20 41 4e 44 0a 28 | 74 2e 6d 6f 64 69 66 69 | 2 AND.(|t.modifi|
|000055c0| 65 64 20 3d 20 31 20 4f | 52 20 74 2e 6d 74 69 6d |ed = 1 O|R t.mtim|
|000055d0| 65 20 3e 20 69 2e 69 74 | 69 6d 65 20 4f 52 0a 4e |e > i.it|ime OR.N|
|000055e0| 56 4c 28 69 2e 65 78 70 | 69 64 2c 39 39 39 39 29 |VL(i.exp|id,9999)|
|000055f0| 20 3e 20 76 2e 65 78 70 | 69 64 29 0a 08 00 8e 0c | > v.exp|id).....|
|00005600| 06 01 00 00 f3 04 00 01 | 8e 0c 00 00 08 00 00 00 |........|........|
|00005610| 00 00 00 00 01 00 94 02 | 00 01 3b 0a 00 00 00 00 |........|..;.....|
|00005620| 01 00 00 00 00 00 00 00 | 00 00 0d 00 5c 00 00 00 |........|....\...|
|00005630| 4c 02 00 01 09 00 09 02 | 00 80 00 00 3b 0a 00 00 |L.......|....;...|
|00005640| 00 01 02 00 ff ff 16 00 | 49 01 33 01 33 01 00 00 |........|I.3.3...|
|00005650| 02 00 9a 01 49 01 00 00 | 00 00 00 00 00 00 00 00 |....I...|........|
|00005660| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005670| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005680| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005690| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000056a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000056b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000056c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000056d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000056e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000056f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005700| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005710| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005720| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005730| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005740| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005750| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005760| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005770| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005780| 00 00 00 00 00 00 00 00 | 00 2c 00 05 03 c2 05 4c |........|.,.....L|
|00005790| 18 2d 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |.-------|--------|
|000057a0| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 02 c1 10 02 c1 2b 2a |--------|-.....+*|
|000057b0| 53 45 4c 45 43 54 20 2a | 20 66 72 6f 6d 20 65 78 |SELECT *| from ex|
|000057c0| 75 63 6f 6c 20 57 48 45 | 52 45 20 74 6f 77 6e 65 |ucol WHE|RE towne|
|000057d0| 72 69 64 20 3d 20 75 69 | 64 0a 2c 00 05 03 c2 05 |rid = ui|d.,.....|
|000057e0| 4b 18 2d 2d 2d 2d 2d 2d | 2d 2d 2d 2d 2d 2d 2d 2d |K.------|--------|
|000057f0| 2d 2d 2d 2d 2d 2d 2d 2d | 2d 2d 02 c1 10 03 c2 06 |--------|--......|
|00005800| 05 fe f8 01 53 45 4c 45 | 43 54 20 6f 24 2e 6f 62 |....SELE|CT o$.ob|
|00005810| 6a 23 2c 20 75 24 2e 6e | 61 6d 65 2c 20 6f 24 2e |j#, u$.n|ame, o$.|
|00005820| 6f 77 6e 65 72 23 2c 20 | 6f 24 2e 6e 61 6d 65 2c |owner#, |o$.name,|
|00005830| 20 63 24 2e 6e 61 6d 65 | 2c 20 63 24 2e 6c 65 6e | c$.name|, c$.len|
|00005840| 67 74 68 2c 0a 63 24 2e | 70 72 65 63 69 73 69 6f |gth,.c$.|precisio|
|00005850| 6e 2c 20 63 24 2e 73 63 | 61 6c 65 2c 20 63 24 2e |n, c$.sc|ale, c$.|
|00005860| 74 79 70 65 23 2c 20 63 | 24 2e 6e 75 6c 6c 24 2c |type#, c|$.null$,|
|00005870| 0a 44 45 43 4f 44 45 28 | 53 55 42 53 54 52 28 63 |.DECODE(|SUBSTR(c|
|00005880| 6f 6e 24 2e 6e 61 6d 65 | 2c 31 2c 35 29 2c 20 27 |on$.name|,1,5), '|
|00005890| 53 59 53 5f 43 27 2c 20 | 27 27 2c 20 4e 56 4c 28 |SYS_C', |'', NVL(|
|000058a0| 63 6f 6e 24 2e 6e 61 6d | 65 2c 20 27 27 29 29 2c |con$.nam|e, '')),|
|000058b0| 0a 63 24 2e 63 6f 6c 23 | 2c 20 63 6f 6d 24 2e 63 |.c$.col#|, com$.c|
|000058c0| 6f 6d 6d 65 6e 74 24 2c | 20 63 24 2e 64 65 66 61 |omment$,| c$.defa|
|000058d0| 75 6c 74 24 2c 20 4e 56 | 4c 28 63 24 2e 64 65 66 |ult$, NV|L(c$.def|
|000058e0| 6c 65 6e 67 74 68 2c 20 | 30 29 0a 46 52 4f 4d 20 |length, |0).FROM |
|000058f0| 73 79 73 2e 63 6f 6c 24 | 20 63 24 2c 20 73 79 73 |sys.col$| c$, sys|
|00005900| 2e 6f 62 6a 24 20 6f 24 | 2c 20 73 79 73 2e 75 73 |.obj$ o$|, sys.us|
|00005910| 65 72 24 20 75 24 2c 20 | 73 79 73 2e 63 64 65 66 |er$ u$, |sys.cdef|
|00005920| 24 20 63 64 24 2c 0a 73 | 79 73 2e 63 6f 6e 24 20 |$ cd$,.s|ys.con$ |
|00005930| 63 6f 6e 24 2c 20 73 79 | 73 2e 63 6f 6d 24 20 63 |con$, sy|s.com$ c|
|00005940| 6f 6d 24 0a 57 48 45 52 | 45 20 63 24 2e 6f 62 6a |om$.WHER|E c$.obj|
|00005950| 23 20 3d 20 6f 24 2e 6f | 62 6a 23 20 61 6e 64 20 |# = o$.o|bj# and |
|00005960| 6f 24 2e 6f 77 6e 65 72 | 23 20 3d 20 75 24 2e 75 |o$.owner|# = u$.u|
|00005970| 73 65 72 23 20 61 6e 64 | 0a 63 24 2e 6e 75 6c 6c |ser# and|.c$.null|
|00005980| 24 20 3d 20 63 64 24 2e | 63 6f 6e 23 28 2b 29 20 |$ = cd$.|con#(+) |
|00005990| 61 6e 64 20 63 24 2e 6f | 62 6a 23 20 3d 20 63 64 |and c$.o|bj# = cd|
|000059a0| 24 2e 6f 62 6a 23 28 2b | 29 20 61 6e 64 0a 63 64 |$.obj#(+|) and.cd|
|000059b0| 24 2e 63 6f 6e 23 20 3d | 20 63 6f 6e 24 2e 63 6f |$.con# =| con$.co|
|000059c0| 6e 23 28 2b 29 20 61 6e | 64 0a 63 24 2e 6f 62 6a |n#(+) an|d.c$.obj|
|000059d0| 23 20 3d 20 63 6f 6d 24 | 2e 6f 62 6a 23 28 2b 29 |# = com$|.obj#(+)|
|000059e0| 20 61 6e 64 20 63 24 2e | 63 6f 6c 23 20 3d 20 63 | and c$.|col# = c|
|000059f0| 6f 6d 24 2e 63 6f 6c 23 | 28 2b 29 0a 08 00 8e 0c |om$.col#|(+).....|
|00005a00| 06 01 00 00 f4 04 00 01 | 8f 0c 00 00 0d 00 00 00 |........|........|
|00005a10| 00 00 00 00 01 00 66 00 | 00 01 79 07 00 00 00 00 |......f.|..y.....|
|00005a20| 02 00 00 00 00 00 00 00 | 00 00 1a 00 43 00 00 00 |........|....C...|
|00005a30| 3f 02 00 01 06 00 06 cf | 00 80 00 00 77 07 00 00 |?.......|....w...|
|00005a40| 00 00 18 00 43 00 00 00 | 41 02 00 01 06 00 01 02 |....C...|A.......|
|00005a50| 00 80 00 00 78 07 00 00 | 00 06 08 00 ff ff 36 00 |....x...|......6.|
|00005a60| 3e 02 08 02 08 02 00 00 | 01 00 01 00 00 00 01 00 |>.......|........|
|00005a70| 00 00 01 00 00 00 01 00 | 00 00 01 00 07 00 8d 03 |........|........|
|00005a80| 64 03 31 03 ff 02 d1 02 | 9e 02 73 02 3e 02 00 00 |d.1.....|..s.>...|
|00005a90| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005aa0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005ab0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005ac0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005ad0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005ae0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005af0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005b00| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005b10| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005b20| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005b30| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005b40| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005b50| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005b60| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005b70| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005b80| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005b90| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005ba0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005bb0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005bc0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005bd0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005be0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005bf0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005c00| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005c10| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005c20| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005c30| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005c40| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005c50| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005c60| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005c70| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005c80| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005c90| 00 00 00 00 00 00 6c 00 | 12 00 02 c1 08 02 c1 08 |......l.|........|
|00005ca0| 02 c1 1f 01 80 11 52 5f | 43 4f 4e 53 54 52 41 49 |......R_|CONSTRAI|
|00005cb0| 4e 54 5f 4e 41 4d 45 02 | c1 02 02 c1 1f 01 80 ff |NT_NAME.|........|
|00005cc0| ff 02 c1 02 ff ff ff ff | ff ff ff 6c 00 12 00 02 |........|...l....|
|00005cd0| c1 07 02 c1 07 02 c1 1f | 01 80 07 52 5f 4f 57 4e |........|...R_OWN|
|00005ce0| 45 52 02 c1 02 02 c1 1f | 01 80 ff ff 02 c1 02 ff |ER......|........|
|00005cf0| ff ff ff ff ff ff 6c 00 | 12 00 02 c1 06 02 c1 06 |......l.|........|
|00005d00| 02 c1 1b 01 80 10 53 45 | 41 52 43 48 5f 43 4f 4e |......SE|ARCH_CON|
|00005d10| 44 49 54 49 4f 4e 02 c1 | 09 02 c1 1b 01 80 ff ff |DITION..|........|
|00005d20| 01 80 ff ff ff ff ff ff | ff 6c 00 12 00 02 c1 05 |........|.l......|
|00005d30| 02 c1 05 02 c1 1f 01 80 | 0a 54 41 42 4c 45 5f 4e |........|.TABLE_N|
|00005d40| 41 4d 45 02 c1 02 02 c1 | 1f 01 80 ff ff 02 c1 02 |AME.....|........|
|00005d50| ff ff ff ff ff ff ff 6c | 00 12 00 02 c1 04 02 c1 |.......l|........|
|00005d60| 04 02 c1 03 01 80 0f 43 | 4f 4e 53 54 52 41 49 4e |.......C|ONSTRAIN|
|00005d70| 54 5f 54 59 50 45 02 c1 | 02 02 c1 03 01 80 ff ff |T_TYPE..|........|
|00005d80| 01 80 ff ff ff ff ff ff | ff 6c 00 12 00 02 c1 03 |........|.l......|
|00005d90| 02 c1 03 02 c1 1f 01 80 | 0f 43 4f 4e 53 54 52 41 |........|.CONSTRA|
|00005da0| 49 4e 54 5f 4e 41 4d 45 | 02 c1 02 02 c1 1f 01 80 |INT_NAME|........|
|00005db0| ff ff 02 c1 02 ff ff ff | ff ff ff ff 6c 00 12 00 |........|....l...|
|00005dc0| 02 c1 02 02 c1 02 02 c1 | 1f 01 80 05 4f 57 4e 45 |........|....OWNE|
|00005dd0| 52 02 c1 02 02 c1 1f 01 | 80 ff ff 02 c1 02 ff ff |R.......|........|
|00005de0| ff ff ff ff ff ac 00 01 | 07 00 07 00 01 00 04 f4 |........|........|
|00005df0| 00 00 01 00 04 f4 00 00 | 03 c2 03 38 0d 00 8f 0c |........|...8....|
|00005e00| 06 01 00 00 f5 04 00 01 | 8f 0c 00 00 0a 00 00 00 |........|........|
|00005e10| 00 00 00 00 01 00 66 00 | 00 01 87 07 00 00 00 00 |......f.|........|
|00005e20| 02 00 00 00 00 00 00 00 | 00 00 0e 00 44 00 00 00 |........|....D...|
|00005e30| 46 02 00 01 06 00 01 cf | 00 80 00 00 85 07 00 00 |F.......|........|
|00005e40| 00 00 10 00 44 00 00 00 | 46 02 00 01 06 00 0c 02 |....D...|F.......|
|00005e50| 00 80 00 00 86 07 00 00 | 00 06 05 00 ff ff 30 00 |........|......0.|
|00005e60| d7 02 a7 02 a7 02 00 00 | 01 00 01 00 00 00 01 00 |........|........|
|00005e70| 00 00 01 00 00 00 01 00 | 00 00 01 00 04 00 8d 03 |........|........|
|00005e80| 64 03 31 03 02 03 d7 02 | 00 00 00 00 00 00 00 00 |d.1.....|........|
|00005e90| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005ea0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005eb0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005ec0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005ed0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005ee0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005ef0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005f00| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005f10| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005f20| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005f30| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005f40| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005f50| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005f60| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005f70| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005f80| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005f90| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005fa0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005fb0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005fc0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005fd0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005fe0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00005ff0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00006000| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00006010| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00006020| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00006030| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00006040| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00006050| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00006060| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00006070| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00006080| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00006090| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000060a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000060b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000060c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000060d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000060e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000060f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00006100| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00006110| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00006120| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 6c |........|.......l|
|00006130| 00 12 00 02 c1 05 02 c1 | 05 02 c1 17 01 80 08 50 |........|.......P|
|00006140| 4f 53 49 54 49 4f 4e 02 | c1 03 02 c1 17 01 80 ff |OSITION.|........|
|00006150| ff 01 80 ff ff ff ff ff | ff ff 6c 00 12 00 02 c1 |........|..l.....|
|00006160| 04 02 c1 04 02 c1 1f 01 | 80 0b 43 4f 4c 55 4d 4e |........|..COLUMN|
|00006170| 5f 4e 41 4d 45 02 c1 02 | 02 c1 1f 01 80 ff ff 02 |_NAME...|........|
|00006180| c1 02 ff ff ff ff ff ff | ff 6c 00 12 00 02 c1 03 |........|.l......|
|00006190| 02 c1 03 02 c1 1f 01 80 | 0f 43 4f 4e 53 54 52 41 |........|.CONSTRA|
|000061a0| 49 4e 54 5f 4e 41 4d 45 | 02 c1 02 02 c1 1f 01 80 |INT_NAME|........|
|000061b0| ff ff 02 c1 02 ff ff ff | ff ff ff ff 6c 00 12 00 |........|....l...|
|000061c0| 02 c1 02 02 c1 02 02 c1 | 1f 01 80 05 4f 57 4e 45 |........|....OWNE|
|000061d0| 52 02 c1 02 02 c1 1f 01 | 80 ff ff 02 c1 02 ff ff |R.......|........|
|000061e0| ff ff ff ff ff ac 00 01 | 04 00 04 00 01 00 04 f5 |........|........|
|000061f0| 00 00 01 00 04 f5 00 00 | 03 c2 03 3a 0a 00 8f 0c |........|...:....|
|00006200| 06 01 00 00 f6 04 00 01 | 8f 0c 00 00 0f 00 00 00 |........|........|
|00006210| 00 00 00 00 01 00 66 00 | 00 01 90 07 00 00 00 00 |......f.|........|
|00006220| 02 00 00 00 00 00 00 00 | 00 00 03 00 45 00 00 00 |........|....E...|
|00006230| 4a 02 00 01 06 00 08 cf | 00 80 00 00 90 07 00 00 |J.......|........|
|00006240| 00 00 16 00 44 00 00 00 | 4c 02 00 01 06 00 0d 02 |....D...|L.......|
|00006250| 0a 00 00 00 00 00 00 00 | 00 06 0b 00 ff ff 3c 00 |........|......<.|
|00006260| eb 01 af 01 af 01 00 00 | 01 00 01 00 00 00 01 00 |........|........|
|00006270| 00 00 01 00 00 00 01 00 | 00 00 01 00 0a 00 8d 03 |........|........|
|00006280| 66 03 40 03 19 03 ee 02 | c4 02 99 02 6f 02 42 02 |f.@.....|....o.B.|
|00006290| 16 02 eb 01 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000062a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000062b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000062c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000062d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000062e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000062f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00006300| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00006310| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00006320| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00006330| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00006340| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00006350| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00006360| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00006370| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00006380| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|00006390| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000063a0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000063b0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000063c0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000063d0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000063e0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
|000063f0| 00 00 00 00 00 00 00 00 | 00 00 00 00 00 00 00 00 |........|........|
+--------+-------------------------+-------------------------+--------+--------+