RE: Anyone have a copy of DUL ??

Hi Juan, I read the link this morning but be the server seems to have gone bonks -Page Not Found error!! I hope the doc has not been maliciously deleted!! Any other reference to the doc?? Best regards, CSW Simon. -Original Message- Sent: Thursday, September 18, 2003 3:40 PM To:

Re: Anyone have a copy of DUL ??

Hi Simon, seems to be there now, just tried it 4:50pm UK time. kind regards Pete -- Pete Finnigan email:[EMAIL PROTECTED] Web site: http://www.petefinnigan.com - Oracle security audit specialists Book:Oracle security step-by-step Guide - see http://store.sans.org for details. -- Please see

Re: Anyone have a copy of DUL ??

Bernard of Oracle Holland made DUL (Direct UnLoader) several years ago. I took the very last internals class conducted by Oracle Support EMEA Vice President Andre Bakker (the only VP to conduct internals classes, I think. I also think he quit Support in disgust some time later :-) ), and we

Anyone have a copy of DUL ??

There are DUL?s manual. http://www.fors.com/velpuri2/dul_ucg8.html May be interesting for someone. -Mensaje original- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] nombre de Pete Finnigan Enviado el: jueves, 18 de septiembre de 2003 13:55 Para: Multiple recipients of list ORACLE-L

RE: Anyone have a copy of DUL ??

Wouldn't something like DUL need to read Oracle's dictionary? My impression is that a lot of stuff in the data files is heavily encoded, like date and number formats. Wouldn't you need the dictionary to understand where one column stops and the next starts, and maybe even where one row ends and

Re: Anyone have a copy of DUL ??

Call Oracle Support ;) Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, September 18, 2003 3:39 PM There are DUL?s manual. http://www.fors.com/velpuri2/dul_ucg8.html May be interesting for someone. -Mensaje

RE: Anyone have a copy of DUL ??

Title: RE: Anyone have a copy of DUL ?? at about 10K/hr make sure you have PO on hand. From what I have heard, they install, work and de-install. You just get to see the end result. If you can get DUL copy, you could also send email to uncle Larry and ask for Oracle source code. Raj

RE: Anyone have a copy of DUL ??

Title: RE: Anyone have a copy of DUL ?? probably not, in absence of DD it will probably dump column id and table ids and rowids. If you dump a block, you will see that column length is also stored to indicate how many bytes to read. Raj -Original Message- From: DENNIS WILLIAMS

RE: Anyone have a copy of DUL ??

I do it but there say don´t have DUL -Mensaje original- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] nombre de Tanel Poder Enviado el: jueves, 18 de septiembre de 2003 15:50 Para: Multiple recipients of list ORACLE-L Asunto: Re: Anyone have a copy of DUL ?? Call Oracle Support

Re: Anyone have a copy of DUL ??

Hi! Yes, you have to start from very beginning, you have be able to decode number date columns, have to know internal row structure, block structure, be able to find the start of tab$ and clu$, you have to be able to read extent maps from segment headers (in LMT you don't have anything in uet$

Re: Anyone have a copy of DUL ??

Hi Juan, There are some interesting papers on the rest of this site as wqell if you scroll around the directories. kind regards Pete -- Pete Finnigan email:[EMAIL PROTECTED] Web site: http://www.petefinnigan.com - Oracle security audit specialists Book:Oracle security step-by-step Guide - see

RE: Anyone have a copy of DUL ??

PROTECTED] Sent: Thu 9/18/2003 11:14 AM To: Multiple recipients of list ORACLE-L Cc: Subject:Re: Anyone have a copy of DUL ?? Dennis, i dont think those 2 items you mentioned are that encoded, using the dump command you can see how they are stored. joe DENNIS WILLIAMS wrote: Wouldn't

Re: Anyone have a copy of DUL ??

Regular blockdump interprets the result into human readable format. However, if you set event 10289 at level 1, you'll have hexdumps instead can continue from there :) Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, September 18,

Re: Anyone have a copy of DUL ??

original- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] nombre de Tanel Poder Enviado el: jueves, 18 de septiembre de 2003 15:50 Para: Multiple recipients of list ORACLE-L Asunto: Re: Anyone have a copy of DUL ?? Call Oracle Support ;) Tanel. - Original Message - To: Multiple

Re: Anyone have a copy of DUL ??

Dennis, i dont think those 2 items you mentioned are that encoded, using the dump command you can see how they are stored. joe DENNIS WILLIAMS wrote: Wouldn't something like DUL need to read Oracle's dictionary? My impression is that a lot of stuff in the data files is heavily encoded, like

RE: Anyone have a copy of DUL ??

Tanel, Richard That was what my innocent question related to. I had played with LogMiner without a dictionary and it was challenging. Naturally with a program you can take care of some of those issues in the program. Anyway, from the replies this sounds feasible and probably really useful.

RE: Anyone have a copy of DUL ??

of list ORACLE-L Asunto: Re: Anyone have a copy of DUL ?? Call Oracle Support ;) Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, September 18, 2003 3:39 PM There are DUL?s manual. http://www.fors.com/velpuri2/dul_ucg8

RE: Anyone have a copy of DUL ??

: Anyone have a copy of DUL ?? Call Oracle Support ;) Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, September 18, 2003 3:39 PM There are DUL?s manual. http://www.fors.com/velpuri2/dul_ucg8.html May be interesting

Re: Anyone have a copy of DUL ??

PROTECTED] [mailto:[EMAIL PROTECTED] nombre de Tanel Poder Enviado el: jueves, 18 de septiembre de 2003 15:50 Para: Multiple recipients of list ORACLE-L Asunto: Re: Anyone have a copy of DUL ?? Call Oracle Support ;) Tanel. - Original Message - To: Multiple recipients

RE: Anyone have a copy of DUL ??

: Anyone have a copy of DUL ?? Call Oracle Support ;) Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, September 18, 2003 3:39 PM There are DUL?s manual. http://www.fors.com/velpuri2/dul_ucg8.html May be interesting

Re: Anyone have a copy of DUL ??

Hi Mark I agree with you Mark, even if its supplied by Oracle technicians - it is as you say possible to by-pass security completely. Does anyone in Oracle check that the field support personnel dispatched to a site ( in urgency ) are dumping data for the owner of it? - I covered the issue of

RE: Anyone have a copy of DUL ??

Well if they can hack at it with Perl it's not really the tool that's the problem and preventing access to the tool is not a solution. -Original Message- Sent: Thursday, September 18, 2003 10:35 AM To: Multiple recipients of list ORACLE-L One problem I see with giving this away free

Re: Anyone have a copy of DUL ??

Hi Pete I have used Dul many times at customer sites when I was employed by Oracle Denmark. Every time the customer management had to verify by phone and fax that they understood the full impact of using Dul. Oracle have disclaimer that explains the problems with missing transaction

Re: Anyone have a copy of DUL ??

Juan I have the URL that you can get a copy from but you need access to Oracle's network. Wrote about it in Select Journal. In 1999 - I wrote: DUL - Data recovery UnLoader DUL or Data recovery UnLoader is a utility that that will generate either a data file or an Oracle Export file by reading

RE: Anyone have a copy of DUL ??

of list ORACLE-L Asunto: Re: Anyone have a copy of DUL ?? Call Oracle Support ;) Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, September 18, 2003 3:39 PM There are DUL?s manual. http://www.fors.com

Re: Anyone have a copy of DUL ??

Peter, I used DUL (one of my last 40 hour days) under extreme urgency. We didn't have to fax anything, but then, our senior Vice President did call Ray Lane's secretary to get Field Support to pull someone in off vacation to come to our site, so I guess that's pretty good verification. The

RE: Anyone have a copy of DUL ??

-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Tanel Poder A lot easier would be to write an online dul, which queries data dictionary for location of extents and object definitions for example and then scans only relevant datablocks. I think that

RE: Anyone have a copy of DUL ??

Forgetting about a piddly, little-known OS called Neanderthal Technology. Where default Oracle installation tosses everything out there with full control for everyone -- or it used to do that. But even if you change the permissions, anybody that needs to do anything on the box must have

Re: Anyone have a copy of DUL ??

Yes, there are. The paper that explains the naming of X$ tables I found to be particularly interesting. Jared On Thu, 2003-09-18 at 08:14, Pete Finnigan wrote: Hi Juan, There are some interesting papers on the rest of this site as wqell if you scroll around the directories. kind regards

RE: Anyone have a copy of DUL ??

Title: RE: Anyone have a copy of DUL ?? also check the one about log miner ... Raj -Original Message- From: Jared Still [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 18, 2003 4:25 PM To: Multiple recipients of list ORACLE-L Subject: Re: Anyone have a copy of DUL ?? Yes

RE: Anyone have a copy of DUL ??

Which site? I've been skimming over this thread and missed it. Thanks, --Walt Weaver Bozeman, Montana -Original Message- From: Jared Still [mailto:[EMAIL PROTECTED] Sent: Thursday, September 18, 2003 2:25 PM To: Multiple recipients of list ORACLE-L Subject: Re: Anyone have

Re: Anyone have a copy of DUL ??

Hi! Good point, but there are few issues. Unloading data with SQL is slower than doing it directly. Yes, direct export is very fast, but it doesn't have the flexibility DUL does - DUL is built do survive any corruptions in data, while your export just may fail or server process crashes, DUL just

RE: Anyone have a copy of DUL ??

- From: Jared Still [mailto:[EMAIL PROTECTED] Sent: Thursday, September 18, 2003 2:25 PM To: Multiple recipients of list ORACLE-L Subject: Re: Anyone have a copy of DUL ?? Yes, there are. The paper that explains the naming of X$ tables I found to be particularly interesting. Jared

RE: Anyone have a copy of DUL ??

And DUL doesn't need a running instance to do it's job. All it needs are as much data files as you got. Richard -Original Message- Sent: Thursday, September 18, 2003 5:00 PM To: Multiple recipients of list ORACLE-L Hi! Good point, but there are few issues. Unloading data with SQL is

RE: Anyone have a copy of DUL ??

-Original Message- From: Jared Still [mailto:[EMAIL PROTECTED] Sent: Thursday, September 18, 2003 2:25 PM To: Multiple recipients of list ORACLE-L Subject: Re: Anyone have a copy of DUL ?? Yes, there are. The paper that explains the naming of X$ tables I found

RE: Anyone have a copy of DUL ??

:[EMAIL PROTECTED] Sent: Thursday, September 18, 2003 3:20 PM To: Multiple recipients of list ORACLE-L Subject: RE: Anyone have a copy of DUL ?? See the original post which asked this question. -Original Message- Sent: Thursday, September 18, 2003 4:50 PM To: Multiple recipients

Re: Anyone have a copy of DUL ??

Correct, but I was talking about easily writable DUL before, a DUL which doesn't require decoding data dictionary. But use of this kind of loader would mostly be for learning purposes. Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday,

Re: Anyone have a copy of DUL ??

Hi Jared Yes, I read that one as well very interesting, I have not seen it before. There is also a BBED simple user manual, not elaborate but better than I have seen before. kind regards Pete In article [EMAIL PROTECTED], Jared Still [EMAIL PROTECTED] writes Yes, there are. The paper that

Re: Anyone have a copy of DUL ??

Hi Walt, probably someone else will reply before me as i am reading this offline but anyway for the meaning of x$ tables try http://www.fors.com/velpuri2 /X$/List%20of%20X$%20Tables kind regards Pete In article [EMAIL PROTECTED], Weaver, Walt [EMAIL PROTECTED] writes Which site? I've been

RE: Anyone have a copy of DUL ??

I realize that Oracle's DUL tool works for datafiles from a database that cannot be started. Far from me to argue with Mr. Poder, but I thought he meant by online DUL a DUL that would work when the instance is running. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL

RE: Anyone have a copy of DUL ??

Why all the interest about reading Oracle files? There is no magic in doing this! It does not matter how sophisticated the server is, the data simply resides in data files. You can view it easily using: cat file | strings Regards, Waleed -- Please see the official ORACLE-L FAQ:

RE: Anyone have a copy of DUL ??

Yeah! cat file | strings myfile.txt sqlldr data=myfile.txt piece of cake. ;) Guaranteed to work on BLOBs, LONG RAWs regardless of NLS settings. Waleed, either you're being facetious, or missing the point, I can't tell which. If this were coming from Mladen, there would be no doubt.