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: Multiple recipients of list ORACLE-L 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 Asunto: Re: How to extract data directly from a datafile ? Hi Tanel, A free DUL in C would be very nice to have and to study the source code of. maybe you should also contact Kurt van Meerbeek of jDUL project on sourceforge, maybe you have some ideas or info he doesn't have that could help his efforts or of course Richard's efforts. 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 the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Finnigan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Juan Miranda INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
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 the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Finnigan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
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 talked about a severe case we had in Denmark at that time. Basically, a company that made technical specs (including drawings) for some very advanced, high-speed transportation things, had not taken a backup of their system tablespace for 18 months. Then the system01.dbf file did its own thing, and their database didn't really feel good. Andre told me that he had a guy who was working on a tool that might be able to help us out. But it was in beta, etc., etc. So I went back to Denmark, called Bernhard, and we agreed that he would fix the bugs as we encountered them. I sent one of my guys - Christian Fabricius - online, and he was gone for three days, but got all the technical drawings out of the datafiles (Bernhard had to fix two or three things as we went along - a tribute to his coding skills). All that time, practially, Bernhard was online. Rock'n'roll. We were very proud. First time in history. Blah blah blah. When my manager went to a meeting with the customer a week later we were all expecting joy and happiness and perhaps some gratefullness from the customer. But no. He was furious. Why hadn't we told him that it was neccessary to take a backup of the system tablespace? Where in the documentation did it clearly state that that was required? It was all our fault. And we didn't even charge them more than normal hourly rates. I never tried the other suggestion Andre had (and which he had used many times himself): Create a dummy database that has the same datafiles as the problem database. Then take the file headers from the dummy database and patch on top of the real database. Then you can start up, since the information in the file headers match. Andre was one cool guy. He's enjoying early retirement, he claims. Mogens Rachel Carmichael wrote: Kevin Loney tells the story of making a call to the data center from the CIO's office and asking them to make a copy of the backup tapes and leave them at reception. since the call came from the CIO's office, they made the copy --- Pete Finnigan [EMAIL PROTECTED] wrote: Hi Peter Glad to hear that there are controls in Oracle for use of DUL, I was thinking of a case where i heard that one guy rang up the backup storage company for a large company and requested a set of backup tapes be left at reception at the company and he just walked in off the street and took them. Mitnik tells similar stories in his book. Thanks for the internal Oracle insight Peter, kind regards Pete In article [EMAIL PROTECTED], Peter Gram [EMAIL PROTECTED] writes 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 consistency of the data saved by Dul and the security issues. The customer has to sign and fax the disclaimer back to Oracle before we came on site .-) After I left Oracle several people ask me if would write a Dul and I declined. I'm of the opinion that Dul should stay behind the Oracle firewall. /peter Pete Finnigan wrote: 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 DUL with regards to security is the SANS Oracle security step-by-step book - action 6.5.1 kind regards Pete In article [EMAIL PROTECTED], Mark Leith [EMAIL PROTECTED] writes One problem I see with giving this away free is that you will be supplying a tool that allows you to extract data from the database, bypassing all inbuilt security. A BIG no no. I suppose that also applies to this kind of tool even under a paid license structure. -- 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 the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Finnigan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED]
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 Asunto: Re: How to extract data directly from a datafile ? Hi Tanel, A free DUL in C would be very nice to have and to study the source code of. maybe you should also contact Kurt van Meerbeek of jDUL project on sourceforge, maybe you have some ideas or info he doesn't have that could help his efforts or of course Richard's efforts. 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 the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Finnigan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Juan Miranda INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
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 the next begins? Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, September 18, 2003 7:40 AM To: Multiple recipients of list ORACLE-L 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 Asunto: Re: How to extract data directly from a datafile ? Hi Tanel, A free DUL in C would be very nice to have and to study the source code of. maybe you should also contact Kurt van Meerbeek of jDUL project on sourceforge, maybe you have some ideas or info he doesn't have that could help his efforts or of course Richard's efforts. 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 the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Finnigan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Juan Miranda INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
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 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 Asunto: Re: How to extract data directly from a datafile ? Hi Tanel, A free DUL in C would be very nice to have and to study the source code of. maybe you should also contact Kurt van Meerbeek of jDUL project on sourceforge, maybe you have some ideas or info he doesn't have that could help his efforts or of course Richard's efforts. 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 the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Finnigan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Juan Miranda INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
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 -Original Message- From: Tanel Poder [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 18, 2003 9:50 AM To: Multiple recipients of list ORACLE-L Subject: Re: Anyone have a copy of DUL ?? Call Oracle Support ;) Tanel. This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*1
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 [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 18, 2003 9:45 AM To: Multiple recipients of list ORACLE-L Subject: 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 the next begins? Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, September 18, 2003 7:40 AM To: Multiple recipients of list ORACLE-L 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]]En nombre de Pete Finnigan Enviado el: jueves, 18 de septiembre de 2003 13:55 Para: Multiple recipients of list ORACLE-L Asunto: Re: How to extract data directly from a datafile ? Hi Tanel, A free DUL in C would be very nice to have and to study the source code of. maybe you should also contact Kurt van Meerbeek of jDUL project on sourceforge, maybe you have some ideas or info he doesn't have that could help his efforts or of course Richard's efforts. 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 the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Finnigan INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Juan Miranda INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*2
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 ;) 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 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 Asunto: Re: How to extract data directly from a datafile ? Hi Tanel, A free DUL in C would be very nice to have and to study the source code of. maybe you should also contact Kurt van Meerbeek of jDUL project on sourceforge, maybe you have some ideas or info he doesn't have that could help his efforts or of course Richard's efforts. 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 the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Finnigan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Juan Miranda INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Juan Miranda INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
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$ nor fet$ tables), you got to be able to read chained migrated rows, cluster tables (some base tables are clustered), read rollback segments if want consistent data... ... etc. That way it's possible to read data out from any datafile. The problem is that if you're missing data dictionary (have lost system TS) and don't have a reasonable backup, you don't know the names of your tables nor column names. 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. That way one doesn't have to start decoding data dictionary from scratch. But this approach has other problems like data consistency issues (if some blocks have been modified in buffer cache haven't been written to datafiles). Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, September 18, 2003 4:44 PM 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 the next begins? Dennis Williams DBA, 80%OC P,100%DBALifetouch,[EMAIL PROTECTED] hursday,September18,2003740AMToMultiplerecipientsoflistORACLE-LThereareDULsm anual.httpwww.fors.comvelpuri2dul_ucg8.htmlMaybeinterestingforsomeone.-M ensaje 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 Asunto: Re: How to extract data directly from a datafile ? Hi Tanel, A free DUL in C would be very nice to have and to study the source code of. maybe you should also contact Kurt van Meerbeek of jDUL project on sourceforge, maybe you have some ideas or info he doesn't have that could help his efforts or of course Richard's efforts. 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 the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Finnigan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Juan Miranda INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru')
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 http://store.sans.org for details. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Finnigan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Anyone have a copy of DUL ??
Indeed, the row directory is in the block header. And like Raj said, there is a length value to tell you how far to read. The values are encoded in Oracle's internal format, such as the 7 bytes coding for Date type. Richard Ji -Original Message- From: Joe Testa [mailto:[EMAIL 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 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 the next begins? Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, September 18, 2003 7:40 AM To: Multiple recipients of list ORACLE-L 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 Asunto: Re: How to extract data directly from a datafile ? Hi Tanel, A free DUL in C would be very nice to have and to study the source code of. maybe you should also contact Kurt van Meerbeek of jDUL project on sourceforge, maybe you have some ideas or info he doesn't have that could help his efforts or of course Richard's efforts. 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 the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Finnigan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). winmail.dat
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, 2003 6:14 PM 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 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 the next begins? Dennis Williams DBA, 80%OCP,100%DBALifetouch,[EMAIL PROTECTED] SentThursday,September18,2003740AMToMultiplerecipientsoflistORACLE-LThereare DULsmanual.httpwww.fors.comvelpuri2dul_ucg8.htmlMaybeinteresting 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 Asunto: Re: How to extract data directly from a datafile ? Hi Tanel, A free DUL in C would be very nice to have and to study the source code of. maybe you should also contact Kurt van Meerbeek of jDUL project on sourceforge, maybe you have some ideas or info he doesn't have that could help his efforts or of course Richard's efforts. 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 the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Finnigan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Anyone have a copy of DUL ??
They give DUL only for big money for customers with big problems (e.g. not solvable otherwise) Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, September 18, 2003 6:04 PM 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 ;) 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 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 Asunto: Re: How to extract data directly from a datafile ? Hi Tanel, A free DUL in C would be very nice to have and to study the source code of. maybe you should also contact Kurt van Meerbeek of jDUL project on sourceforge, maybe you have some ideas or info he doesn't have that could help his efforts or of course Richard's efforts. 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 the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Finnigan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Juan Miranda INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Juan Miranda INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
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 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 the next begins? Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, September 18, 2003 7:40 AM To: Multiple recipients of list ORACLE-L 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 Asunto: Re: How to extract data directly from a datafile ? Hi Tanel, A free DUL in C would be very nice to have and to study the source code of. maybe you should also contact Kurt van Meerbeek of jDUL project on sourceforge, maybe you have some ideas or info he doesn't have that could help his efforts or of course Richard's efforts. 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 the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Finnigan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
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. Naturally if you expect to become the next Bill Gates, then Oracle could easily cut you off by making DUL generally available. But you could give it away for free as a way of creating credentials for yourself in the Oracle community. Also, you could probably get plenty of opportunities from desperate clients to help them extract their data. In some of these situations, money doesn't mean so much. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, September 18, 2003 10:35 AM To: Multiple recipients of list ORACLE-L 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, 2003 6:14 PM 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 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 the next begins? Dennis Williams DBA, 80%OCP,100%DBALifetouch,[EMAIL PROTECTED] SentThursday,September18,2003740AMToMultiplerecipientsoflistORACLE-LThereare DULsmanual.httpwww.fors.comvelpuri2dul_ucg8.htmlMaybeinteresting 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 Asunto: Re: How to extract data directly from a datafile ? Hi Tanel, A free DUL in C would be very nice to have and to study the source code of. maybe you should also contact Kurt van Meerbeek of jDUL project on sourceforge, maybe you have some ideas or info he doesn't have that could help his efforts or of course Richard's efforts. 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 the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Finnigan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE
RE: Anyone have a copy of DUL ??
1) it's Field Support not Tech Support that has it 2) Oracle does not sell nor does it release the code for DUL. A field support technician comes to your site, installs it, runs it and removes it. You pay a fee for this. when I used it (in '98), the fee was $5k per every 8 hour period, with a minimum of $10K as the starting fee. --- Juan Miranda [EMAIL PROTECTED] wrote: 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 ;) 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 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 Asunto: Re: How to extract data directly from a datafile ? Hi Tanel, A free DUL in C would be very nice to have and to study the source code of. maybe you should also contact Kurt van Meerbeek of jDUL project on sourceforge, maybe you have some ideas or info he doesn't have that could help his efforts or of course Richard's efforts. 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 the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Finnigan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Juan Miranda INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Juan Miranda INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL
RE: Anyone have a copy of DUL ??
One problem I see with giving this away free is that you will be supplying a tool that allows you to extract data from the database, bypassing all inbuilt security. A BIG no no. I suppose that also applies to this kind of tool even under a paid license structure. How many of you would shout at Cool-Tools for giving away a tool such as this, that your developers can use to hack your data files? ;) Nice idea in concept - huge liability it reality. -Original Message- Rachel Carmichael Sent: 18 September 2003 17:15 To: Multiple recipients of list ORACLE-L 1) it's Field Support not Tech Support that has it 2) Oracle does not sell nor does it release the code for DUL. A field support technician comes to your site, installs it, runs it and removes it. You pay a fee for this. when I used it (in '98), the fee was $5k per every 8 hour period, with a minimum of $10K as the starting fee. --- Juan Miranda [EMAIL PROTECTED] wrote: I do it but there say don4t 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 ;) 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 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 Asunto: Re: How to extract data directly from a datafile ? Hi Tanel, A free DUL in C would be very nice to have and to study the source code of. maybe you should also contact Kurt van Meerbeek of jDUL project on sourceforge, maybe you have some ideas or info he doesn't have that could help his efforts or of course Richard's efforts. 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 the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Finnigan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Juan Miranda INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Juan Miranda INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing
Re: Anyone have a copy of DUL ??
You can't bypass Oracle security (well if configured and patched well) from remote with any tools (at least I surely hope so that there wouldn't be any backdoors). There is no magic tool which can log on to Oracle without password from remote and start scanning all the datafiles. This DUL works only when having direct access to datafile itself! This means direct access, not even some sysdba remote login. So there is no more security risk in letting a user access the physical datafile with DUL than with vi editor. In latter case one just has to work more to figure out the physical data structure. Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, September 18, 2003 7:35 PM One problem I see with giving this away free is that you will be supplying a tool that allows you to extract data from the database, bypassing all inbuilt security. A BIG no no. I suppose that also applies to this kind of tool even under a paid license structure. How many of you would shout at Cool-Tools for giving away a tool such as this, that your developers can use to hack your data files? ;) Nice idea in concept - huge liability it reality. -Original Message- Rachel Carmichael Sent: 18 September 2003 17:15 To: Multiple recipients of list ORACLE-L 1) it's Field Support not Tech Support that has it 2) Oracle does not sell nor does it release the code for DUL. A field support technician comes to your site, installs it, runs it and removes it. You pay a fee for this. when I used it (in '98), the fee was $5k per every 8 hour period, with a minimum of $10K as the starting fee. --- Juan Miranda [EMAIL PROTECTED] wrote: I do it but there say don4t 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 ;) 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 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 Asunto: Re: How to extract data directly from a datafile ? Hi Tanel, A free DUL in C would be very nice to have and to study the source code of. maybe you should also contact Kurt van Meerbeek of jDUL project on sourceforge, maybe you have some ideas or info he doesn't have that could help his efforts or of course Richard's efforts. 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 the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Finnigan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Juan Miranda INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru
RE: Anyone have a copy of DUL ??
Mark, I see what you are talking about, but my developers don't have access to data files. Heck, I don't have access to data files in production. The production DBA controls the account. I totally agree that a tool such as this in the wrong hands can be very dangerous, same thing applies for other tools, ethereal, kismet etc. I do believe the benefit of such a tool available out weights the risk of it. I'd like to hear other list members opnion on it. Yours turely Richard Ji -Original Message- Sent: Thursday, September 18, 2003 12:35 PM To: Multiple recipients of list ORACLE-L One problem I see with giving this away free is that you will be supplying a tool that allows you to extract data from the database, bypassing all inbuilt security. A BIG no no. I suppose that also applies to this kind of tool even under a paid license structure. How many of you would shout at Cool-Tools for giving away a tool such as this, that your developers can use to hack your data files? ;) Nice idea in concept - huge liability it reality. -Original Message- Rachel Carmichael Sent: 18 September 2003 17:15 To: Multiple recipients of list ORACLE-L 1) it's Field Support not Tech Support that has it 2) Oracle does not sell nor does it release the code for DUL. A field support technician comes to your site, installs it, runs it and removes it. You pay a fee for this. when I used it (in '98), the fee was $5k per every 8 hour period, with a minimum of $10K as the starting fee. --- Juan Miranda [EMAIL PROTECTED] wrote: I do it but there say don4t 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 ;) 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 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 Asunto: Re: How to extract data directly from a datafile ? Hi Tanel, A free DUL in C would be very nice to have and to study the source code of. maybe you should also contact Kurt van Meerbeek of jDUL project on sourceforge, maybe you have some ideas or info he doesn't have that could help his efforts or of course Richard's efforts. 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 the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Finnigan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Juan Miranda INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http
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 DUL with regards to security is the SANS Oracle security step-by-step book - action 6.5.1 kind regards Pete In article [EMAIL PROTECTED], Mark Leith [EMAIL PROTECTED] writes One problem I see with giving this away free is that you will be supplying a tool that allows you to extract data from the database, bypassing all inbuilt security. A BIG no no. I suppose that also applies to this kind of tool even under a paid license structure. -- 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 the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Finnigan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
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 is that you will be supplying a tool that allows you to extract data from the database, bypassing all inbuilt security. A BIG no no. I suppose that also applies to this kind of tool even under a paid license structure. How many of you would shout at Cool-Tools for giving away a tool such as this, that your developers can use to hack your data files? ;) Nice idea in concept - huge liability it reality. -Original Message- Rachel Carmichael Sent: 18 September 2003 17:15 To: Multiple recipients of list ORACLE-L 1) it's Field Support not Tech Support that has it 2) Oracle does not sell nor does it release the code for DUL. A field support technician comes to your site, installs it, runs it and removes it. You pay a fee for this. when I used it (in '98), the fee was $5k per every 8 hour period, with a minimum of $10K as the starting fee. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
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 consistency of the data saved by Dul and the security issues. The customer has to sign and fax the disclaimer back to Oracle before we came on site .-) After I left Oracle several people ask me if would write a Dul and I declined. I'm of the opinion that Dul should stay behind the Oracle firewall. /peter Pete Finnigan wrote: 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 DUL with regards to security is the SANS Oracle security step-by-step book - action 6.5.1 kind regards Pete In article [EMAIL PROTECTED], Mark Leith [EMAIL PROTECTED] writes One problem I see with giving this away free is that you will be supplying a tool that allows you to extract data from the database, bypassing all inbuilt security. A BIG no no. I suppose that also applies to this kind of tool even under a paid license structure. -- Peter Gram, Miracle A/S Phone : +45 2527 7107, Fax : +45 4466 8856, Home +45 3874 5696 mail : [EMAIL PROTECTED] - http://MiracleAS.dk Upcoming events: DatabaseForum 2003, Lalandia 2-4 October Visit http://miracleas.dk/events/DBF2003/invitation.html Miracle Master Class with Tom Kyte, 12-14 January 2004 smime.p7s Description: S/MIME cryptographic signature
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 the database's datafiles! Cool huh? Apparently it is for internal use only by the Oracle Technical Support staff only. Most of you would not have access to this site but if you did, this is where you would find it http://www-sup.nl.oracle.com/dul There is one catch. I have been informed that it is available for Windows only. Then I found out in 2001: Oracles DUL Data recovery UnLoader Many many moons ago in a previous issue of Select (1999), I wrote of an internally used product by the worldwide support team. This product was called the DUL or Data UnLoader. The utility will read an Oracle datafile and extract data from it. Even from a crashed database. In fact, it was written as a recovery tool for a totally knackered database. The output is a SQL*Loader control file and its data input file. All it requires is the datafile. It does not even need the SYSTEM datafile. Because it is such a power tool, if used unethically, the information gathered can be damaging to the company. At that time, it only ran on Windows and I gave a URL where it can be found. http://www-sup.nl.oracle.com/dul Only one catch. The site was accessible only within Oracle. If you have a friend working at Oracle, you may want to ask him/her nicely to get it for you. If you have a genuine need for the product, you might want to try Oracle Worldwide support. Do I have a copy? Maybe. Try mailing to [EMAIL PROTECTED] . DUL is NOT a supported Oracle product, it is not even an Oracle product. DUL is for support and internal Oracle use only. Since then, the product has been enhanced and is current version is Ver. 8 and there is also a Solaris port. The irony of this product is that there is a rumor that the author of the program would like to commercialize it as he developed it in his own time but Oracle is not having a bar of it. I believe negotiation may be going on. What version of O/S were you intending on using it on? Note the email [EMAIL PROTECTED] that you might find useful. ta tony At 04:39 AM 18/09/2003 -0800, you wrote: 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]]En nombre de Pete Finnigan Enviado el: jueves, 18 de septiembre de 2003 13:55 Para: Multiple recipients of list ORACLE-L Asunto: Re: How to extract data directly from a datafile ? Hi Tanel, A free DUL in C would be very nice to have and to study the source code of. maybe you should also contact Kurt van Meerbeek of jDUL project on sourceforge, maybe you have some ideas or info he doesn't have that could help his efforts or of course Richard's efforts. 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 the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Finnigan INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Juan Miranda INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Anyone have a copy of DUL ??
What DBA, in their right mind, is going to give any user or developer file level access to their datafiles? That is what user and group permissions are there to restrict. All our db's have 600 level file permissions for oracle user access only. If we have to bring someone on site for using a tool such as DUL, you can bet that we dba's will either be the keyboard jockey, or breathing down the necks of the consultant as they work. Non-dba access to the datafiles is just stupid, and anyone who would allow it deserves everything they get. Rodd On Thu, 2003-09-18 at 11:35, Mark Leith wrote: One problem I see with giving this away free is that you will be supplying a tool that allows you to extract data from the database, bypassing all inbuilt security. A BIG no no. I suppose that also applies to this kind of tool even under a paid license structure. How many of you would shout at Cool-Tools for giving away a tool such as this, that your developers can use to hack your data files? ;) Nice idea in concept - huge liability it reality. -Original Message- Rachel Carmichael Sent: 18 September 2003 17:15 To: Multiple recipients of list ORACLE-L 1) it's Field Support not Tech Support that has it 2) Oracle does not sell nor does it release the code for DUL. A field support technician comes to your site, installs it, runs it and removes it. You pay a fee for this. when I used it (in '98), the fee was $5k per every 8 hour period, with a minimum of $10K as the starting fee. --- Juan Miranda [EMAIL PROTECTED] wrote: I do it but there say don4t 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 ;) 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 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 Asunto: Re: How to extract data directly from a datafile ? Hi Tanel, A free DUL in C would be very nice to have and to study the source code of. maybe you should also contact Kurt van Meerbeek of jDUL project on sourceforge, maybe you have some ideas or info he doesn't have that could help his efforts or of course Richard's efforts. 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 the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Finnigan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Juan Miranda INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may
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 product does what it says it will do... and I hope I NEVER have to use it again. Rachel --- Peter Gram [EMAIL PROTECTED] wrote: 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 consistency of the data saved by Dul and the security issues. The customer has to sign and fax the disclaimer back to Oracle before we came on site .-) After I left Oracle several people ask me if would write a Dul and I declined. I'm of the opinion that Dul should stay behind the Oracle firewall. /peter Pete Finnigan wrote: 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 DUL with regards to security is the SANS Oracle security step-by-step book - action 6.5.1 kind regards Pete In article [EMAIL PROTECTED], Mark Leith [EMAIL PROTECTED] writes One problem I see with giving this away free is that you will be supplying a tool that allows you to extract data from the database, bypassing all inbuilt security. A BIG no no. I suppose that also applies to this kind of tool even under a paid license structure. -- Peter Gram, Miracle A/S Phone : +45 2527 7107, Fax : +45 4466 8856, Home +45 3874 5696 mail : [EMAIL PROTECTED] - http://MiracleAS.dk Upcoming events: DatabaseForum 2003, Lalandia 2-4 October Visit http://miracleas.dk/events/DBF2003/invitation.html Miracle Master Class with Tom Kyte, 12-14 January 2004 ATTACHMENT part 2 application/x-pkcs7-signature name=smime.p7s __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
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 in most Oracle databases, along with the software is included an online DUL. If I remember right it's called something like SQL. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jacques Kilchoer INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
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 administrator privileges; so tightening up the permissions is bit like trying to piss up a rope. -Original Message- What DBA, in their right mind, is going to give any user or developer file level access to their datafiles? That is what user and group permissions are there to restrict. All our db's have 600 level file permissions for oracle user access only. If we have to bring someone on site for using a tool such as DUL, you can bet that we dba's will either be the keyboard jockey, or breathing down the necks of the consultant as they work. Non-dba access to the datafiles is just stupid, and anyone who would allow it deserves everything they get. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
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 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 the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Finnigan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
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, 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 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 the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Finnigan INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*1
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 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 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 the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Finnigan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Weaver, Walt INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
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 keeps going tries to extract as much as possible. Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, September 18, 2003 10:19 PM -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 in most Oracle databases, along with the software is included an online DUL. If I remember right it's called something like SQL. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jacques Kilchoer INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
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 of list ORACLE-L 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 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 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 the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Finnigan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Weaver, Walt INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Richard Ji INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
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 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 keeps going tries to extract as much as possible. Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, September 18, 2003 10:19 PM -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 in most Oracle databases, along with the software is included an online DUL. If I remember right it's called something like SQL. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jacques Kilchoer INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Richard Ji INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Anyone have a copy of DUL ??
Okay, okay, I'll check the archives. --Walt shuffling around his office trying to find his web browser -Original Message- From: Richard Ji [mailto:[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 of list ORACLE-L 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 a copy of DUL ?? Yes, there are. The paper that explains the naming of X$ tables I found to be particularly interesting. Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Weaver, Walt INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Anyone have a copy of DUL ??
:) www.fors.com/velpuri2 -Original Message- Sent: Thursday, September 18, 2003 5:55 PM To: Multiple recipients of list ORACLE-L Okay, okay, I'll check the archives. --Walt shuffling around his office trying to find his web browser -Original Message- From: Richard Ji [mailto:[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 of list ORACLE-L 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 a copy of DUL ?? Yes, there are. The paper that explains the naming of X$ tables I found to be particularly interesting. Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Weaver, Walt INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Richard Ji INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
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, September 19, 2003 12:19 AM 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 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 keeps going tries to extract as much as possible. Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, September 18, 2003 10:19 PM -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 in most Oracle databases, along with the software is included an online DUL. If I remember right it's called something like SQL. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jacques Kilchoer INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Richard Ji INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
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 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 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 the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Finnigan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- 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 the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Finnigan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
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 skimming over this thread and missed it. -- 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 the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Finnigan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
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 PROTECTED] Behalf Of Richard Ji And DUL doesn't need a running instance to do it's job. All it needs are as much data files as you got. -Original Message- 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 keeps going tries to extract as much as possible. Tanel. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jacques Kilchoer INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
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: http://www.orafaq.net -- Author: Khedr, Waleed INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
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. Jared On Thu, 2003-09-18 at 16:30, Khedr, Waleed wrote: 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: http://www.orafaq.net -- Author: Khedr, Waleed INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).