Welcome Guest ( Log In | Register )


 
 
 
 
 
 

 
 
Oracle 

Performance Tuning Reference poster
 
Oracle training in Linux 

commands
 
Oracle training Weblogic Book
 
Easy Oracle Jumpstart
 
Oracle training & performance tuning books
 
Burleson Consulting Remote DB Administration
 
 
 
Reply to this topicStart new topic
> GET DATA FROM *.DBF FILE WITHOUT INSTALLING ORACLE, GET DATA FROM *.DBF FILE WITHOUT INSTALLING ORACLE
revelation
post Apr 2 2008, 11:54 AM
Post #1


Newbie
*

Group: Members
Posts: 3
Joined: 2-April 08
Member No.: 20,335



Hi all..
Just to the point.

Case:
I take all *.dbf file from oracle 9i installed in Solaris 9.2 system.

I want to read the content/data from those .dbf files on my PC (Windows XP).

Question:
1. Is it possible to read the data from those .dbf file without installing oracle in my PC?

2. Is there any tool to do it?

3. If it is not possible, is there another way that should I do to get the data?

Any comment, answer, recommendation will greatly appreciated. Thanks a lot.
Go to the top of the page
 
+Quote Post
dave
post Apr 2 2008, 12:17 PM
Post #2


Advanced Member
***

Group: Members
Posts: 5,206
Joined: 8-October 04
Member No.: 785



oracle consulting will do it for you for a large fee
so will dude
Go to the top of the page
 
+Quote Post
revelation
post Apr 2 2008, 01:40 PM
Post #3


Newbie
*

Group: Members
Posts: 3
Joined: 2-April 08
Member No.: 20,335



QUOTE (dave @ Apr 2 2008, 05:18 PM) *
oracle consulting will do it for you for a large fee
so will dude



So, it means only one solution, contact the oracle?
Go to the top of the page
 
+Quote Post
dave
post Apr 2 2008, 03:16 PM
Post #4


Advanced Member
***

Group: Members
Posts: 5,206
Joined: 8-October 04
Member No.: 785



or dude http://www.ora600.nl/introduction.htm

you need to understand an oracle block to extract data from it.

Simplest way is to just install oracle!
Go to the top of the page
 
+Quote Post
HAL9000
post Apr 10 2008, 01:45 PM
Post #5


Advanced Member
***

Group: Members
Posts: 879
Joined: 25-September 07
Member No.: 12,336



"Is it possible to read the data from those .dbf file without installing oracle in my PC?"

They are just data files, any editor can read them. You can also use "strings"

root> strings '/u01/app/oracle/mydata.dbf'

Also see BBED:

http://www.dba-oracle.com/t_bbed.htm

Also see DUL and JDUL, all open source:

http://dba.ipbhost.com/index.php?showtopic=5042

Here is a Rama Velpuri note on DUL:

http://www.fors.com/velpuri2/dul_ucg8.html

Here is the download for JDUL, a later Java version:

http://sourceforge.net/projects/jdul
Go to the top of the page
 
+Quote Post

Reply to this topicStart new topic
1 User(s) are reading this topic (1 Guests and 0 Anonymous Users)
0 Members:

 

Lo-Fi Version Time is now: 1st September 2014 - 03:59 PM