OraFAQ Forum: Designer

Home » Developer & Programmer » Designer » migration

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

migration [message #90650]

Sat, 26 June 2004 01:06

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

�

Report message to a moderator

Re: migration [message #90664 is a reply to message #90650]

Sun, 11 July 2004 02:28

Ach
Messages: 26
Registered: April 2004

Junior Member

Did you use different Data sources such as ODBC for Oracle and data providers?

Report message to a moderator

Re: migration [message #90706 is a reply to message #90650]

Fri, 20 August 2004 05:41

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

Report message to a moderator

Previous Topic:	Storage space consumed by NUMBER datatype
Next Topic:	How to Find Which INIT.ORA and TNSNAMES

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Apr 14 05:06:29 CDT 2025