Home » RDBMS Server » Server Utilities » How to import data in Oracle
How to import data in Oracle [message #195920] Tue, 03 October 2006 02:52 Go to next message
kamran.it
Messages: 265
Registered: September 2005
Location: Karachi
Senior Member
Dear Sir

I have converted Foxpro Database through SQLWays 3.9 Wizard in text file, now I kindly ask you how can I import this txt file in oracle.


Best regards

Kamran
Re: How to import data in Oracle [message #195928 is a reply to message #195920] Tue, 03 October 2006 03:25 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

hi
use sql*loader utility
Re: How to import data in Oracle [message #195932 is a reply to message #195928] Tue, 03 October 2006 03:47 Go to previous messageGo to next message
kamran.it
Messages: 265
Registered: September 2005
Location: Karachi
Senior Member
I Never use this utility please tell me how can i use this SQL Loader.
Re: How to import data in Oracle [message #195964 is a reply to message #195932] Tue, 03 October 2006 06:16 Go to previous messageGo to next message
Littlefoot
Messages: 20891
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Everything was once done for the first time, right? Now it is time to read the documentation about SQL*Loader and learn how to use it.

If there aren't special cases, I guess you won't have problems to successfully load data using this Oracle utility.
Re: How to import data in Oracle [message #196022 is a reply to message #195920] Tue, 03 October 2006 14:13 Go to previous messageGo to next message
Barbara Boehmer
Messages: 8625
Registered: November 2002
Location: California, USA
Senior Member
Here are some examples:

http://www.orafaq.com/forum/m/73835/43710/?srch=foxpro#msg_73835

And here is another method:

http://www.orafaq.com/forum/m/72384/43710/?srch=foxpro#msg_72384
Re: How to import data in Oracle [message #196024 is a reply to message #195920] Tue, 03 October 2006 14:15 Go to previous message
Barbara Boehmer
Messages: 8625
Registered: November 2002
Location: California, USA
Senior Member
You can also load the data by creating an "external table". You can find examples by searching the online documentation for "external table".
Previous Topic: Conditional multiple loading by SQL Loader
Next Topic: partitioned counter values
Goto Forum:
  


Current Time: Sat Dec 03 17:58:52 CST 2016

Total time taken to generate the page: 0.08449 seconds