Home » Infrastructure » Windows » data migration (data migration)
data migration [message #275636] Mon, 22 October 2007 03:03 Go to next message
masterborj
Messages: 21
Registered: October 2007
Location: Philippines
Junior Member

need help!!!how could i migrate my data from a dos base .dbf data into oracle 10g database...
Re: data migration [message #275637 is a reply to message #275636] Mon, 22 October 2007 03:13 Go to previous messageGo to next message
Michel Cadot
Messages: 59136
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
From where comes this .dbf file? Oracle?

Regards
Michel
Re: data migration [message #275640 is a reply to message #275637] Mon, 22 October 2007 03:21 Go to previous messageGo to next message
masterborj
Messages: 21
Registered: October 2007
Location: Philippines
Junior Member

i use clipper and visual faxpro 7 for that .dbf file and i want to migrate it to oracle
Re: data migration [message #275645 is a reply to message #275640] Mon, 22 October 2007 03:37 Go to previous messageGo to next message
Michel Cadot
Messages: 59136
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You can't.

Regards
Michel
Re: data migration [message #275649 is a reply to message #275636] Mon, 22 October 2007 03:45 Go to previous messageGo to next message
masterborj
Messages: 21
Registered: October 2007
Location: Philippines
Junior Member

but what are the kind of databases i can convert into an oracle database
Re: data migration [message #275656 is a reply to message #275649] Mon, 22 October 2007 04:09 Go to previous messageGo to next message
Michel Cadot
Messages: 59136
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
None.
You have to unload your data in csv format and load them with SQL*Loader.

Regards
Michel
Re: data migration [message #275657 is a reply to message #275636] Mon, 22 October 2007 04:17 Go to previous messageGo to next message
masterborj
Messages: 21
Registered: October 2007
Location: Philippines
Junior Member

and how will i do that?is it possible if compile my database into microsoft access then the table one by one import it to oracle?
Re: data migration [message #275665 is a reply to message #275657] Mon, 22 October 2007 04:38 Go to previous messageGo to next message
Michel Cadot
Messages: 59136
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes, you can do it as MS Access can connect to Oracle using ODBC.
For details, post your question in MS/Access forum.

Regards
Michel
Re: data migration [message #275668 is a reply to message #275636] Mon, 22 October 2007 04:41 Go to previous messageGo to next message
masterborj
Messages: 21
Registered: October 2007
Location: Philippines
Junior Member

so now my only problem is how will i incorporate my old dbase to aceess.by the way thnks...
Re: data migration [message #275670 is a reply to message #275668] Mon, 22 October 2007 04:42 Go to previous message
Michel Cadot
Messages: 59136
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
This is a question for a MS/Access forum not an Oracle one but who knows maybe someone here knows the answer...

Regards
Michel
Previous Topic: Critical patches for Windows XP
Next Topic: oracle.exe running
Goto Forum:
  


Current Time: Thu Sep 18 19:40:49 CDT 2014

Total time taken to generate the page: 0.08726 seconds