OraFAQ Forum: Server Utilities » How to import data in Oracle

Home » RDBMS Server » Server Utilities » How to import data in Oracle

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

How to import data in Oracle [message #195920]

Tue, 03 October 2006 02:52

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

Report message to a moderator

Re: How to import data in Oracle [message #195928 is a reply to message #195920]

Tue, 03 October 2006 03:25

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

hi
use sql*loader utility

Report message to a moderator

Re: How to import data in Oracle [message #195932 is a reply to message #195928]

Tue, 03 October 2006 03:47

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.

Report message to a moderator

Re: How to import data in Oracle [message #195964 is a reply to message #195932]

Tue, 03 October 2006 06:16

Littlefoot
Messages: 21823
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.

Report message to a moderator

Re: How to import data in Oracle [message #196022 is a reply to message #195920]

Tue, 03 October 2006 14:13

Barbara Boehmer
Messages: 9101
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

Report message to a moderator

Re: How to import data in Oracle [message #196024 is a reply to message #195920]

Tue, 03 October 2006 14:15

Barbara Boehmer
Messages: 9101
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".

Report message to a moderator

Previous Topic:	Conditional multiple loading by SQL Loader
Next Topic:	partitioned counter values

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Dec 25 23:35:47 CST 2024