OraFAQ Forum: Server Utilities » import access database on my pc to oracle on unix m/c

Home » RDBMS Server » Server Utilities » import access database on my pc to oracle on unix m/c

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

import access database on my pc to oracle on unix m/c [message #368201]

Thu, 28 September 2000 18:02

srinivas guntuka
Messages: 1
Registered: September 2000

Junior Member

No Message Body

Report message to a moderator

Re: import access database on my pc to oracle on unix m/c [message #368210 is a reply to message #368201]

Mon, 02 October 2000 12:05

Bala
Messages: 205
Registered: November 1999

Senior Member

Hi,

1.Export the data in the access tables as fixed width or delimited text file.
2. Create control file and use sql loder to load
the data from your workstation.

3. Or ftp the text files to Unix server and
use the sql loader to load the data.

Thanks
Bala

Report message to a moderator

Previous Topic:	What is the order of Export and Import
Next Topic:	Loading multiple flat files into multiple tables

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 19 06:27:25 CDT 2024