Home » Developer & Programmer » Designer » migration
migration [message #90650] Sat, 26 June 2004 01:06 Go to next message
AKheel
Messages: 16
Registered: August 2003
Junior Member
Hai Every ome!!!!!

I am facing a problem when migrating a Access database ..

I have a *.mdb file with only one table in it.. & contains data.

I want to migrate this *.mdb into oracle 8.0.5 dtabase while adding the file Iam getting the following err:"General problem opening database file"

can anyone help me in this regards..

Thanks in Advance!!

 
Re: migration [message #90664 is a reply to message #90650] Sun, 11 July 2004 02:28 Go to previous messageGo to next message
Ach
Messages: 26
Registered: April 2004
Junior Member
Did you use different Data sources such as ODBC for Oracle and data providers?
Re: migration [message #90706 is a reply to message #90650] Fri, 20 August 2004 05:41 Go to previous message
Balaji
Messages: 102
Registered: October 2000
Senior Member
hi Akheel
as Ash said use the ODBC tools or try this method.
1. Export the .mdb file to a .txt
2. Create an oracle table with the same columns as the .mdb file.
3. Load the data into the oracle table using SQL*LOADER.

With best wishes
balaji
Previous Topic: Storage space consumed by NUMBER datatype
Next Topic: How to Find Which INIT.ORA and TNSNAMES
Goto Forum:
  


Current Time: Thu Mar 28 11:52:55 CDT 2024