Home » RDBMS Server » Server Utilities » Data load from .mdb, .dbf files(Urgent)
Data load from .mdb, .dbf files(Urgent) [message #72494] Mon, 30 June 2003 03:53 Go to next message
kothari Alpesh
Messages: 27
Registered: December 2001
Junior Member
Dear All,
I have .mdb/.dbf file. so How can i load the data into the oracle Database directly from the .mdb/.dbf files

Alpesh,

Report message to a moderator

Re: Data load from .mdb, .dbf files(Urgent) [message #72503 is a reply to message #72494] Tue, 01 July 2003 13:30 Go to previous messageGo to next message
Barbara Boehmer
Messages: 9097
Registered: November 2002
Location: California, USA
Senior Member
The method I use is to export them to ascii text files, create Oracle tables of comparable structure, then use SQL*Loader to load the data from the text files to the Oracle tables.

You might also be able to use ODBC.

If you have Oracle 9i, you might be able to use external tables.

Report message to a moderator

Re: Data load from .mdb, .dbf files(Urgent) [message #72507 is a reply to message #72494] Wed, 02 July 2003 13:44 Go to previous message
Barbara Boehmer
Messages: 9097
Registered: November 2002
Location: California, USA
Senior Member
Please click on the link below for information about ODBC. You can also find more information in the Oracle on-line documentation.

Report message to a moderator

Previous Topic: Orapwd & failed to create database
Next Topic: Taking Backup with Imp/Exp
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Jun 30 09:54:05 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.