RE: :) What you can't do in java you can do in perl
- From: Wolfson Larry - lwolfs <lawrence.wolfson@xxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Wed, 29 Sep 2004 12:50:50 -0500
Looks like I gave Wolfgang some bad advice:
Wolfgang,
Here's ascii list followed by partial hex dumps of a dmp file with
an editor tool we have
Last record in dmp file has 923 x'00's or nulls
If you have a small dmp file you're trying to process maybe I could
find where PERL is gagging.
Kinda surprised it would confuse length with EOF marker.
I don't think 'sed' would have that problem
Easy to test and see if file size the same.
>sed "s/Wolfgang/Breitlin/" expstat8A.dmp > nev.dmp
>ll *dmp
-rw-r--r-- 1 oracle dba 986112 Jun 17 23:00 expstat8A.dmp
-rw-r--r-- 1 oracle dba 854330 Sep 29 16:57 nev.dmp
>grep Breitlin new.dmp|wc
0 0 0
Ouch! They're not
>ll *dmp
-rw-r--r-- 1 oracle dba 986112 Jun 17 23:00 expstat8A.dmp
-rw-r--r-- 1 oracle dba 854330 Sep 29 16:57 nev.dmp
>diff expstat8A.dmp nev.dmp|pg
Binary files expstat8A.dmp and nev.dmp differ
986112-854330
-------------
131782
Maybe we need vi or my editor!
Larry
/usr/pub/ascii
|000 nul|001 soh|002 stx|003 etx|004 eot|005 enq|006 ack|007 bel|
|010 bs |011 ht |012 nl |013 vt |014 np |015 cr |016 so |017 si |
|020 dle|021 dc1|022 dc2|023 dc3|024 dc4|025 nak|026 syn|027 etb|
|030 can|031 em |032 sub|033 esc|034 fs |035 gs |036 rs |037 us |
|040 sp |041 ! |042 " |043 # |044 $ |045 % |046 & |047 ' |
|050 ( |051 ) |052 * |053 + |054 , |055 - |056 . |057 / |
|060 0 |061 1 |062 2 |063 3 |064 4 |065 5 |066 6 |067 7 |
|070 8 |071 9 |072 : |073 ; |074 < |075 = |076 > |077 ? |
|100 @ |101 A |102 B |103 C |104 D |105 E |106 F |107 G |
|110 H |111 I |112 J |113 K |114 L |115 M |116 N |117 O |
|120 P |121 Q |122 R |123 S |124 T |125 U |126 V |127 W |
|130 X |131 Y |132 Z |133 [ |134 \ |135 ] |136 ^ |137 _ |
|140 ` |141 a |142 b |143 c |144 d |145 e |146 f |147 g |
|150 h |151 i |152 j |153 k |154 l |155 m |156 n |157 o |
|160 p |161 q |162 r |163 s |164 t |165 u |166 v |167 w |
|170 x |171 y |172 z |173 { |174 | |175 } |176 ~ |177 del|
| 00 nul| 01 soh| 02 stx| 03 etx| 04 eot| 05 enq| 06 ack| 07 bel|
| 08 bs | 09 ht | 0a nl | 0b vt | 0c np | 0d cr | 0e so | 0f si |
| 10 dle| 11 dc1| 12 dc2| 13 dc3| 14 dc4| 15 nak| 16 syn| 17 etb|
| 18 can| 19 em | 1a sub| 1b esc| 1c fs | 1d gs | 1e rs | 1f us |
| 20 sp | 21 ! | 22 " | 23 # | 24 $ | 25 % | 26 & | 27 ' |
| 28 ( | 29 ) | 2a * | 2b + | 2c , | 2d - | 2e . | 2f / |
| 30 0 | 31 1 | 32 2 | 33 3 | 34 4 | 35 5 | 36 6 | 37 7 |
| 38 8 | 39 9 | 3a : | 3b ; | 3c < | 3d = | 3e > | 3f ? |
| 40 @ | 41 A | 42 B | 43 C | 44 D | 45 E | 46 F | 47 G |
| 48 H | 49 I | 4a J | 4b K | 4c L | 4d M | 4e N | 4f O |
| 50 P | 51 Q | 52 R | 53 S | 54 T | 55 U | 56 V | 57 W |
| 58 X | 59 Y | 5a Z | 5b [ | 5c \ | 5d ] | 5e ^ | 5f _ |
| 60 ` | 61 a | 62 b | 63 c | 64 d | 65 e | 66 f | 67 g |
| 68 h | 69 i | 6a j | 6b k | 6c l | 6d m | 6e n | 6f o |
| 70 p | 71 q | 72 r | 73 s | 74 t | 75 u | 76 v | 77 w |
| 78 x | 79 y | 7a z | 7b { | 7c | | 7d } | 7e ~ | 7f del|
Here's parts of a hex dump of a statid table
Beginning
BROWSE /expstat8A.dmp ---------------------------------------- LINE 00000000
COL 001 095
COMMAND ===>
SCROLL ==> PAGE
************************************* TOP OF DATA
**************************************
EXPORT:V09.02.00
0004554553533233233
301580F24A609E02E00
UDLEUSER
54445545
54C55352
RTABLES
5544445
2412C53
1024
3333
1024
0
3
0
MIDDLE
record or line number on left in EDIT mode.
EDIT expstat8A.dmp
---------------------------------------------------------- COLUMNS 001 088
COMMAND ===>
SCROLL ==> CSR
005167 c 0@ xh
1600C034000C0FFFFFFFF00760
23504E0032016EFEFEFEF70886
005168
01100C0
491504D
005169 c 0@ DOX8YE30THR C EMS_FILE Y2004_Q2_M04
DL_FILE_ID DL
1600C0340FF00005453443354500400C0008004455444400533335535433FF00445444454400
44
23504E003EF00B00F8815304821032015100D05D3F69C5C092004F12FD04EFF04CF69C5F9470
4C
005170 0@ \+` DOX8YE30THR C EMS_FILE Y2004_Q2_M05
DL_FILE_BLO
01100C034000C0526FF00005453443354500400C0008004455444400533335535433FF004454
4445444
493504E004504FCB0EF00B00F8815304821032015100D05D3F69C5C092004F12FD05EFF04CF6
9C5F2CF
005171 \. ), DOX8YE30THR C EMS_FILE Y2004_Q2_M06
DL_FILE_BLO
01100C052100C1221FF00005453443354500400C0008004455444400533335535433FF004454
4445444
496504FCEF50419C8EF00B00F8815304821032015100D05D3F69C5C092004F12FD06EFF04CF6
9C5F2CF
005172 ),M 2 DOX8YE30THR C EMS_FILE Y2004_Q3_M07
DL_FILE_BLO
01100C122400C1301FF00005453443354500400C0008004455444400533335535433FF004454
4445444
49E50419CD50412E8EF00B00F8815304821032015100D05D3F69C5C092004F13FD07EFF04CF6
9C5F2CF
A FEW RECORDS FARTHER
EDIT expstat8A.dmp
---------------------------------------------------------- COLUMNS 001 088
COMMAND ===>
SCROLL ==> CSR
005215 = +_-!\ DOX8YE30THR C EMS_FILE Y2003_Q3_M09
01000C01300C25225FF00005453443354500400C0008004455444400533335535433FF
49540328D605BFD1CEF00B00F8815304821032015100D05D3F69C5C092003F13FD09EF
005216 FILE_CRC32 DLEUSER 6!> A(D V V %" +_G+b
xh
0444454543300444554500C03200B1011424100C00500C00500800C22100C2542600C0FFFFFF
FF00760
069C5F32332704C5535240366190E38C9184F403266403266100403529605BF7B22017EFEFEF
EF70886
005217 %" +_G+b DOX8YE30THR C EMS_FILE Y2003_Q4_M10
01000C22100C25426FF00005453443354500400C0008004455444400533335535433FF
496403529605BF7B2EF00B00F8815304821032015100D05D3F69C5C092003F14FD10EF
005218 FILE_CRC32 DLEUSER >F 3-#`aN =A =A -R +_O ;
xh
0444454543300444554500C04100B032266400C03400C03400800C02500C2541300C0FFFFFFF
F00760
069C5F32332704C5535240396880EC3D301E4032D14032D1100403CD2605BFFAB2017EFEFEFE
F70886
005219 -R +_O ; DOX8YE30THR C EMS_FILE Y2003_Q4_M11
01000C02500C25413FF00005453443354500400C0008004455444400533335535433FF
497403CD2605BFFABEF00B00F8815304821032015100D05D3F69C5C092003F14FD11EF
005220 FILE_CRC32 DLEUSER @%> "1 VE ! 'M 'M *' +_Y'X
xh
0444454543300444554500C04200B0231541200C02400C02400800C22100C2552500C0FFFFFF
FF00760
069C5F32332704C55352403E0590E8214659140337D40337D100403A72605BF9782017EFEFEF
EF70886
ENDS WITH 923 hex'00's
EDIT expstat8A.dmp
----------------------------------------------------------- 923 CHARS X'00'
COMMAND ===>
SCROLL ==> CSR
010287 + Acknowledged> Suspended
0210046666766666600577766666FF00FF
7BFC013BEF7C547549035305E454EF00FF
010288 CREATE INDEX "STATS" ON "STATS" ("STATID" , "TYPE" , "C5" , "C1" ,
"C2" , "C3" , "
4544542444452255455224422554552222554544222225554222224322222432222243222224
322222
32514509E458023414320FE0234143208234149420C02490520C023520C023120C023220C023
320C02
010289 EXIT
4545
5894
.A EXIT
4545
5894
.B
0000000000000000000000000000000000000000000000000000000000000000000000000000
000000000000
0000000000000000000000000000000000000000000000000000000000000000000000000000
000000000000
****** ************************************ BOTTOM OF DATA
************************************
**********************************************************************
The information contained in this communication is
confidential, is intended only for the use of the recipient
named above, and may be legally privileged.
If the reader of this message is not the intended
recipient, you are hereby notified that any dissemination,
distribution, or copying of this communication is strictly
prohibited.
If you have received this communication in error,
please re-send this communication to the sender and
delete the original message or any copy of it from your
computer system. Thank You.
--
http://www.freelists.org/webpage/oracle-l
Other related posts: