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

Report message to a moderator

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: 68766
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
From where comes this .dbf file? Oracle?

Regards
Michel

Report message to a moderator

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

Report message to a moderator

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: 68766
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
You can't.

Regards
Michel

Report message to a moderator

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

Report message to a moderator

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: 68766
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
None.
You have to unload your data in csv format and load them with SQL*Loader.

Regards
Michel

Report message to a moderator

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?

Report message to a moderator

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: 68766
Registered: March 2007
Location: Saint-Maur, France, https...
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

Report message to a moderator

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

Report message to a moderator

Re: data migration [message #275670 is a reply to message #275668] Mon, 22 October 2007 04:42 Go to previous message
Michel Cadot
Messages: 68766
Registered: March 2007
Location: Saint-Maur, France, https...
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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Aug 21 03:07:29 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.