Home » RDBMS Server » Server Utilities » import oracle8i
import oracle8i [message #368395] Wed, 13 December 2000 01:40 Go to next message
Harsha
Messages: 8
Registered: December 2000
Junior Member
Hi,
Can anyone tell me how to convert a datafile(non-oracle)to a oracle db...or import on a regular basis from a datafile(non-oracle) to a oracle db
Thanks
Re: import oracle8i [message #368397 is a reply to message #368395] Wed, 13 December 2000 08:15 Go to previous messageGo to next message
Bala
Messages: 205
Registered: November 1999
Senior Member
Hi,
From which format to oracle?
There are some utilities available for migrating data from other format to oracle.
But if you can tell from which format you want to import the data to oracle, then i can suggest something.

If you have data in text format you can use oracle utility sql loader to import the data into oracle. There is a generic migration tool datajunction using which you can import data from most of the available formats to oracle.....

Bala.
Re: import oracle8i [message #368409 is a reply to message #368395] Thu, 14 December 2000 21:20 Go to previous message
Harsha
Messages: 8
Registered: December 2000
Junior Member
Thank you Bala
The file is in either text/ASCII format. I'll try both the options you have mentioned.
Previous Topic: Re: SQLLDR..Load 3rd or 4th field in CSV file
Next Topic: Attach to other session
Goto Forum:
  


Current Time: Tue Apr 16 03:30:55 CDT 2024