OraFAQ Forum: Server Administration » Loading dbf files into database

Home » RDBMS Server » Server Administration » Loading dbf files into database

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Loading dbf files into database [message #251059]

Thu, 12 July 2007 06:01

yogesh.84
Messages: 7
Registered: July 2007
Location: India

Junior Member

hi all,
Can any one help me out in loading the .dbf files to oracle (i am using 9i version)databse.If possible please lemme know the details of the process (hey i am neew to this database thinks!)

guys hoping for ur support
thanks & Regards,
yogesh

Report message to a moderator

Re: Loading dbf files into database [message #251066 is a reply to message #251059]

Thu, 12 July 2007 06:17

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

What is a .dbf file?
If you think of a database file.
Each one is private to a database and cannot be "load" in another one.

Regards
Michel

Report message to a moderator

Re: Loading dbf files into database [message #251072 is a reply to message #251066]

Thu, 12 July 2007 06:27

yogesh.84
Messages: 7
Registered: July 2007
Location: India

Junior Member

hi michel,
Probably i have not framed my question correctly.here it is- suppose i have dbf files on my local drives and i wanted to load these data files into database, then how do i do it,as in case of csv files control files works fine but i don't know how to do it with dbf files(database files).

thanks for showing intrest,
yogesh

Report message to a moderator

Re: Loading dbf files into database [message #251075 is a reply to message #251072]

Thu, 12 July 2007 06:29

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

My answer was maybe not clear: you can't.

Regards
Michel

[Updated on: Thu, 12 July 2007 06:30]

Report message to a moderator

Re: Loading dbf files into database [message #251080 is a reply to message #251075]

Thu, 12 July 2007 06:33

yogesh.84
Messages: 7
Registered: July 2007
Location: India

Junior Member

any ways i am keen to here it, if u can

regards,
yogesh

Report message to a moderator

Re: Loading dbf files into database [message #251097 is a reply to message #251080]

Thu, 12 July 2007 07:03

pablolee
Messages: 2882
Registered: May 2007
Location: Scotland

Senior Member

Michel Cadot wrote on Thu, 12 July 2007 12:29

My answer was maybe not clear: you can't.

Regards
Michel

The key bit being You can't

Report message to a moderator

Re: Loading dbf files into database [message #251105 is a reply to message #251059]

Thu, 12 July 2007 07:12

yogesh.84
Messages: 7
Registered: July 2007
Location: India

Junior Member

Oops i took it as that i can't understand bcoz of complexity involved in the process.any ways it can be done that i know because there are some ppl in my organization who used to do it, but the process they use is pretty cumbersome, thats i wanted to discuss over here if any 1 knows a better way out to do this task.

thanks,
yogesh

Report message to a moderator

Re: Loading dbf files into database [message #251110 is a reply to message #251105]

Thu, 12 July 2007 07:18

pablolee
Messages: 2882
Registered: May 2007
Location: Scotland

Senior Member

If it is a process that can be done, then the question that you are asking is leading the readers down the wrong track, because what you appear to be asking cannot (as Michel says) be done.
Please clarify your position (maybe telling us what the people (I'm assuming that is what you meant by ppl) are doing to 'load dbfs' into a database

Report message to a moderator

Re: Loading dbf files into database [message #251114 is a reply to message #251105]

Thu, 12 July 2007 07:23

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

You can do it through "transportable tablespace" but this is not ANY data files, this is data files with very precise conditions used in a precise way.

Regards
Michel

Report message to a moderator

Re: Loading dbf files into database [message #251149 is a reply to message #251105]

Thu, 12 July 2007 09:18

joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA

Senior Member

You cannot load a DBF file into a database, but it's not that you can't, it does not make any sense. An analogy if you please...it's like asking someone to load Windows XP into Excel.
As Michel stated, there are transportable tablespaces, but these are not just DBF files (and not necessarily DBF files at all), they are a logical conglomeration of multiple files.

Report message to a moderator

Re: Loading dbf files into database [message #251151 is a reply to message #251059]

Thu, 12 July 2007 09:22

MarcL
Messages: 455
Registered: November 2006
Location: Connecticut, USA

Senior Member

Now if your real question is can I transfer the data from the dbf into an Oracle table there are many different tools to accomplish this.

Report message to a moderator

Re: Loading dbf files into database [message #251153 is a reply to message #251151]

Thu, 12 July 2007 09:31

yogesh.84
Messages: 7
Registered: July 2007
Location: India

Junior Member

hi marc,
yup, you got it right, but can you spare some minutes to share easiest way to do show

p.s.-I m new to this database thing, (i am from statistics background), so guys plz pardon me for mistakes(which may seem to be a very trivial or may be stupid to be asked)

thanks,
yogesh

Report message to a moderator

Re: Loading dbf files into database [message #251170 is a reply to message #251151]

Thu, 12 July 2007 10:22

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Marc,

I'm curious to know what are the "many different tools" that can extract data from Oracle data files.

Regards
Michel

Report message to a moderator

Re: Loading dbf files into database [message #251175 is a reply to message #251059]

Thu, 12 July 2007 10:27

MarcL
Messages: 455
Registered: November 2006
Location: Connecticut, USA

Senior Member

He didn't say Oracle data files.

I was assuming DBASE or FoxPro or some other database that uses .dbf extensions.

If he is referring to an Oracle .dbf file you are right, there is no way that I know of to do this.

{OOOPS He did, my bad))

[Updated on: Thu, 12 July 2007 10:27]

Report message to a moderator

Re: Loading dbf files into database [message #251176 is a reply to message #251170]

Thu, 12 July 2007 10:27

ThomasG
Messages: 3212
Registered: April 2005
Location: Heilbronn, Germany

Senior Member

Quote:

I'm curious to know what are the "many different tools" that can extract data from Oracle data files.

Well, I'm still waiting patiently if yogesh.84 will ever tell us if these so-called "*.dfb files" are really Oracle data files, or something else completely, like Foxpro Data files or whatever.

/forum/fa/1598/0/

{He did? Still haven't spotted it. Only the sentence where he mentionened he knew how to hande csv and controllfiles, but there it could be other data files, too.}

[Updated on: Thu, 12 July 2007 10:34]

Report message to a moderator

Re: Loading dbf files into database [message #251698 is a reply to message #251059]

Mon, 16 July 2007 02:21

yogesh.84
Messages: 7
Registered: July 2007
Location: India

Junior Member

hi all,
At first let me regret all of you for being late. Since i was out of station because of some official work. so i could not respond promptly. For clarification on dbf files please refer to MarcL post msg #251175 ( he got it right) and yeah its not an oracle dbf's.

MarcL can you please give idea on any of the convinient methods which can load those dbf's !!!(off course other than oracle one's)

Thanks,
yogesh

Report message to a moderator

Re: Loading dbf files into database [message #251715 is a reply to message #251698]

Mon, 16 July 2007 03:27

sdecman
Messages: 20
Registered: July 2005
Location: Ljubljana, Slovenia

Junior Member

I had the same problem a few years back. We were migrating data from old dBase database into Oracle. The good news is, this can be done. The bad news is, it's not easy. If you want it easy, you will have to pay for a data migration tool (consult Google).

The hard (but free) way is the use of java. If my memory serves me, there is a java library called javadbf but you'll have to do some fancy java programming. It took me one month just to extract that few thousand rows. BTW, you have to know the table structure inside the dbf file in order to extract anything.

Cheers

Report message to a moderator

Re: Loading dbf files into database [message #251875 is a reply to message #251059]

Tue, 17 July 2007 01:09

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

Michel, if someone use in rman set newname to dbf file then will it work?

Report message to a moderator

Re: Loading dbf files into database [message #251888 is a reply to message #251875]

Tue, 17 July 2007 01:48

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Arju,
I don't understand your question.
I reread my post and really don't see any relation with your post. I think you are refering to another topic.
Can you precise?

Regards
Michel

Report message to a moderator

Re: Loading dbf files into database [message #251907 is a reply to message #251059]

Tue, 17 July 2007 02:21

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

The poster wanted to load .dbf file in new database. I wanted to mention if I have a datafile .dbf and I use (RMAN SET NEWNAME) for that datafile then should not it work? I just wanted from you it should possible .

Report message to a moderator

Re: Loading dbf files into database [message #251909 is a reply to message #251907]

Tue, 17 July 2007 02:24

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

No, it will not.
Set newname just gives an alias for the file in order to RMAN to complete the next steps. It does not change the file itself and above all the database name and id inside the file.

(Generally speaking as OP now admitted that this dbf file in not an Oracle one.)

Regards
Michel

Report message to a moderator

Re: Loading dbf files into database [message #251914 is a reply to message #251059]

Tue, 17 July 2007 02:37

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

Ok, Michel, Thanks for clarifying. Now if it is an oracle data file and if I set the DBID and SID (of the new database)according to the name of the database from which I took backup then would it possible?

Report message to a moderator

Re: Loading dbf files into database [message #251939 is a reply to message #251914]

Tue, 17 July 2007 03:45

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

You can't set DBID. There is no way.

Regards
Michel

Report message to a moderator

Re: Loading dbf files into database [message #251947 is a reply to message #251059]

Tue, 17 July 2007 04:10

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

I did this in this way...

SQL> shutdown immediate;
ORA-01109: database not open


Database dismounted.
ORACLE instance shut down.
SQL> !rman

Recovery Manager: Release 10.2.0.1.0 - Production on Tue Jul 17 15:07:57 2007

Copyright (c) 1982, 2005, Oracle.  All rights reserved.

RMAN> set dbid=123456;

executing command: SET DBID

Report message to a moderator

Re: Loading dbf files into database [message #251951 is a reply to message #251947]

Tue, 17 July 2007 04:15

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

You don't set the DBID of the database, you just tell RMAN that you will use a database with this DBID.
Try to set DBID to any value (but not the actual), then try to start the database with RMAN...

Regards
Michel

Report message to a moderator

Re: Loading dbf files into database [message #251952 is a reply to message #251059]

Tue, 17 July 2007 04:19

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

Thanks again to you Michel.

Report message to a moderator

Re: Loading dbf files into database [message #253827 is a reply to message #251939]

Wed, 25 July 2007 00:38

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

Michel Cadot wrote on Tue, 17 July 2007 14:45

You can't set DBID. There is no way.

Regards
Michel

What about DBNEWID Utility(OF COURSE I AM SAYING THIS UTILITY WHEN IT INTRODUCED)?

[Updated on: Wed, 25 July 2007 00:44]

Report message to a moderator

Re: Loading dbf files into database [message #253836 is a reply to message #253827]

Wed, 25 July 2007 01:07

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

DBNEWID changes the DBID but don't let you set the value you want.

Regards
Michel

Report message to a moderator

Re: Loading dbf files into database [message #255447 is a reply to message #251059]

Tue, 31 July 2007 23:19

annu-agi
Messages: 238
Registered: July 2005
Location: Karachi

Senior Member

u just have to do one thing that is export your file in CSV( column seprated values) form and then import through sqlloader ..first try a test and when u get fiiliar then make a process for ur data

REgards
Anwer

Report message to a moderator

Re: Loading dbf files into database [message #255451 is a reply to message #251059]

Tue, 31 July 2007 23:39

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

annu-agi,

OP clearly stated "post msg #251175 ( he got it right) and yeah its not an oracle dbf's."

>u just have to do one thing that is export your file in CSV( column seprated values) form

If the DBF is not Oracle in origin, EXACTLY how should an export,
which requires an open Oracle DB, be able to access the data within this non-Oracle file?

Have the courtesy to write in plain English. A lot of people (me, amongst others ) are not native English speaking and don't feel encouraged when they have to decipher some gobbledygook. Especially abbreviations like "U", "Ur", "U r", "Plz", "prb", "qry" tend to get on people's nerves. If you don't take time to write in proper English, how can you expect that others would answer properly?

Report message to a moderator

Re: Loading dbf files into database [message #255458 is a reply to message #255451]

Wed, 01 August 2007 00:02

yogesh.84
Messages: 7
Registered: July 2007
Location: India

Junior Member

but don't you people think the problem with the csv files are handling of huge data ?? by huge i mean that something approximately millions of records or even more than that and around 300 fields (columns in it)....

and yeah now i think i am being plain enough in my english so Cool

and ya i never expected this much response guys, so i am feeling a bit lucky about it and many thanks to all of you Smile

.

though i have almost solved this problem (using some process) but it does not create log sort of things so it's not easy to verify correctly whether process has run totally correct ?(if any one intrested in knowing the process i would love to share and discuss as well !!!)

thanks

Report message to a moderator

Previous Topic:	Query Regarding flush shared_pool
Next Topic:	Find top sql - need advice

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Feb 25 03:31:45 CST 2025