Home » RDBMS Server » Server Administration » Loading dbf files into database
icon8.gif  Loading dbf files into database [message #251059] Thu, 12 July 2007 06:01 Go to next message
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
Re: Loading dbf files into database [message #251066 is a reply to message #251059] Thu, 12 July 2007 06:17 Go to previous messageGo to next message
Michel Cadot
Messages: 64120
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: Loading dbf files into database [message #251072 is a reply to message #251066] Thu, 12 July 2007 06:27 Go to previous messageGo to next message
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
Re: Loading dbf files into database [message #251075 is a reply to message #251072] Thu, 12 July 2007 06:29 Go to previous messageGo to next message
Michel Cadot
Messages: 64120
Registered: March 2007
Location: Nanterre, France, http://...
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 Go to previous messageGo to next message
yogesh.84
Messages: 7
Registered: July 2007
Location: India
Junior Member
any ways i am keen to here it, if u can

regards,
yogesh
Re: Loading dbf files into database [message #251097 is a reply to message #251080] Thu, 12 July 2007 07:03 Go to previous messageGo to next message
pablolee
Messages: 2834
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
Re: Loading dbf files into database [message #251105 is a reply to message #251059] Thu, 12 July 2007 07:12 Go to previous messageGo to next message
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
Re: Loading dbf files into database [message #251110 is a reply to message #251105] Thu, 12 July 2007 07:18 Go to previous messageGo to next message
pablolee
Messages: 2834
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
Re: Loading dbf files into database [message #251114 is a reply to message #251105] Thu, 12 July 2007 07:23 Go to previous messageGo to next message
Michel Cadot
Messages: 64120
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: Loading dbf files into database [message #251149 is a reply to message #251105] Thu, 12 July 2007 09:18 Go to previous messageGo to next message
joy_division
Messages: 4641
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.
Re: Loading dbf files into database [message #251151 is a reply to message #251059] Thu, 12 July 2007 09:22 Go to previous messageGo to next message
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.
Re: Loading dbf files into database [message #251153 is a reply to message #251151] Thu, 12 July 2007 09:31 Go to previous messageGo to next message
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
Re: Loading dbf files into database [message #251170 is a reply to message #251151] Thu, 12 July 2007 10:22 Go to previous messageGo to next message
Michel Cadot
Messages: 64120
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: Loading dbf files into database [message #251175 is a reply to message #251059] Thu, 12 July 2007 10:27 Go to previous messageGo to next message
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 Go to previous messageGo to next message
ThomasG
Messages: 3189
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.

./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 Go to previous messageGo to next message
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
Re: Loading dbf files into database [message #251715 is a reply to message #251698] Mon, 16 July 2007 03:27 Go to previous messageGo to next message
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
Re: Loading dbf files into database [message #251875 is a reply to message #251059] Tue, 17 July 2007 01:09 Go to previous messageGo to next message
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?
Re: Loading dbf files into database [message #251888 is a reply to message #251875] Tue, 17 July 2007 01:48 Go to previous messageGo to next message
Michel Cadot
Messages: 64120
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: Loading dbf files into database [message #251907 is a reply to message #251059] Tue, 17 July 2007 02:21 Go to previous messageGo to next message
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 .
Re: Loading dbf files into database [message #251909 is a reply to message #251907] Tue, 17 July 2007 02:24 Go to previous messageGo to next message
Michel Cadot
Messages: 64120
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: Loading dbf files into database [message #251914 is a reply to message #251059] Tue, 17 July 2007 02:37 Go to previous messageGo to next message
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?
Re: Loading dbf files into database [message #251939 is a reply to message #251914] Tue, 17 July 2007 03:45 Go to previous messageGo to next message
Michel Cadot
Messages: 64120
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You can't set DBID. There is no way.

Regards
Michel
Re: Loading dbf files into database [message #251947 is a reply to message #251059] Tue, 17 July 2007 04:10 Go to previous messageGo to next message
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

Re: Loading dbf files into database [message #251951 is a reply to message #251947] Tue, 17 July 2007 04:15 Go to previous messageGo to next message
Michel Cadot
Messages: 64120
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: Loading dbf files into database [message #251952 is a reply to message #251059] Tue, 17 July 2007 04:19 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Thanks again to you Michel.
Re: Loading dbf files into database [message #253827 is a reply to message #251939] Wed, 25 July 2007 00:38 Go to previous messageGo to next message
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 Go to previous messageGo to next message
Michel Cadot
Messages: 64120
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
DBNEWID changes the DBID but don't let you set the value you want.

Regards
Michel
Re: Loading dbf files into database [message #255447 is a reply to message #251059] Tue, 31 July 2007 23:19 Go to previous messageGo to next message
annu-agi
Messages: 202
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
Re: Loading dbf files into database [message #255451 is a reply to message #251059] Tue, 31 July 2007 23:39 Go to previous messageGo to next message
BlackSwan
Messages: 25041
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?


Re: Loading dbf files into database [message #255458 is a reply to message #255451] Wed, 01 August 2007 00:02 Go to previous message
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
Previous Topic: Query Regarding flush shared_pool
Next Topic: Find top sql - need advice
Goto Forum:
  


Current Time: Tue Dec 06 14:03:41 CST 2016

Total time taken to generate the page: 0.07514 seconds