RE: Anyone have a copy of DUL ??

2003-09-22 Thread waibals
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 ??

2003-09-22 Thread Pete Finnigan
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 ??

2003-09-21 Thread Mogens Nørgaard
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 ??

2003-09-18 Thread Juan Miranda


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 ??

2003-09-18 Thread DENNIS WILLIAMS
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 ??

2003-09-18 Thread Tanel Poder
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 ??

2003-09-18 Thread Jamadagni, Rajendra
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 ??

2003-09-18 Thread Jamadagni, Rajendra
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 ??

2003-09-18 Thread Juan Miranda
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 ??

2003-09-18 Thread Tanel Poder
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 ??

2003-09-18 Thread Pete Finnigan
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 ??

2003-09-18 Thread Richard Ji
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 ??

2003-09-18 Thread Tanel Poder
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 ??

2003-09-18 Thread Tanel Poder
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 ??

2003-09-18 Thread Joe Testa
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 ??

2003-09-18 Thread DENNIS WILLIAMS
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 ??

2003-09-18 Thread Rachel Carmichael
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 ??

2003-09-18 Thread Mark Leith
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 ??

2003-09-18 Thread Tanel Poder
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 ??

2003-09-18 Thread Richard Ji
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 ??

2003-09-18 Thread Pete Finnigan
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 ??

2003-09-18 Thread Orr, Steve
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 ??

2003-09-18 Thread Peter Gram
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 ??

2003-09-18 Thread tjambu_fatcity

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:


Oracle’s 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 ??

2003-09-18 Thread Rodd Holman
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 ??

2003-09-18 Thread Rachel Carmichael
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 ??

2003-09-18 Thread Jacques Kilchoer
 -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 ??

2003-09-18 Thread Stephen Lee

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 ??

2003-09-18 Thread Jared Still
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 ??

2003-09-18 Thread Jamadagni, Rajendra
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 ??

2003-09-18 Thread Weaver, Walt
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 ??

2003-09-18 Thread Tanel Poder
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 ??

2003-09-18 Thread Richard Ji
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 ??

2003-09-18 Thread 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.

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 ??

2003-09-18 Thread Weaver, Walt
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 ??

2003-09-18 Thread Richard Ji
:)

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 ??

2003-09-18 Thread Tanel Poder
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 ??

2003-09-18 Thread Pete Finnigan
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 ??

2003-09-18 Thread Pete Finnigan
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 ??

2003-09-18 Thread Jacques Kilchoer
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 ??

2003-09-18 Thread Khedr, Waleed

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 ??

2003-09-18 Thread Jared Still
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).