Migrating from Access to Oracle

[palani12kumar]

hi..
i need ur help in switching from MSAccess to Oracle.

And this is my problem:
Currently im having a lot of records in access(which is currently our back-end).
Now i want to switch from Access to Oracle. I've to move all the records(a huge data base) in the Access database to Oracle.
Being new to this i dont know how to get with it!!!!!
Please help me in my problem. Is there any tool availale to over come this?
Waiting for your replies..........

[Dave44]

hi..
i need ur help in switching from MSAccess to Oracle.

And this is my problem:
Currently im having a lot of records in access(which is currently our back-end).
Now i want to switch from Access to Oracle. I've to move all the records(a huge data base) in the Access database to Oracle.
Being new to this i dont know how to get with it!!!!!
Please help me in my problem. Is there any tool availale to over come this?
Waiting for your replies..........

How many rows are we talking about?
Are the table structures going to be identicle?
Are you able to take the database offline while making the move?

[rectoverso]

there is an oracle tool that do this.

if you don't find that.

you can do an odbc connection from access to oracle and then insert your data
from access to oracle

but first check for the oracle tool it's a good tool and it works fine

How many rows are we talking about?
Are the table structures going to be identicle?
Are you able to take the database offline while making the move?

[palani12kumar]

its not a matter of rows.........
its the matter of a number of tables the data base....

[palani12kumar]

Since im new to this concepts....... can you please tell me something about that tool....? what tool is it and how to use it?

[r035198x]

Changed thread title.

[rectoverso]

Since im new to this concepts....... can you please tell me something about that tool....? what tool is it and how to use it?

check taht

http://download-east.oracle.com/docs/html/B10255_01/ch1.htm#1023960

[cwendell]

Please take a look at this link. APEX is a very nice product from Oracle that will allow you to build a web based application.

http://www.oracle.com/technology/products/database/application_express/migrations/mig_index.html

[venkataramana22]

hi..
i need ur help in switching from MSAccess to Oracle.

And this is my problem:
Currently im having a lot of records in access(which is currently our back-end).
Now i want to switch from Access to Oracle. I've to move all the records(a huge data base) in the Access database to Oracle.
Being new to this i dont know how to get with it!!!!!
Please help me in my problem. Is there any tool availale to over come this?
Waiting for your replies..........

hi palani,
to transfer tables fom access try dis

convert the access tables into text files
and create a ctl file for that,in that ctl file u have to menssion in oracle in which table u want to dump.
for that u have to create a strucure in in oracle.
after that in cmd promt
type......

sqlldr scott\tiger@<hostname> <path of ctl file with extension>
dis will solve ur problem
example of ctl file.......type in notepad and save it as .ctl

load data
infile 'f:\rc.txt'
insert into table alarmtype
fields terminated by ','
(CardNo,Enabled,CardID,Staff,Holder,DepartmentNo,P ositionName,PIN,
UserDefinable1,UserDefinable2,Site,Area,StartDate, ExpiredDate,Photo,Description)

[palani12kumar]

Thank you for your help.
I'll try those things and see whats happennig