Home » Infrastructure » Windows » converting text file data to a table on oracle 10g (Oracle 10g(on linux))
converting text file data to a table on oracle 10g [message #306212] Thu, 13 March 2008 05:20 Go to next message
sudh11482
Messages: 16
Registered: September 2007
Location: Lucknow
Junior Member
how can i convert data in the text file to a table in
Oracle 10G and vice versa?

Report message to a moderator

Re: converting text file data to a table on oracle 10g [message #306217 is a reply to message #306212] Thu, 13 March 2008 05:43 Go to previous messageGo to next message
Michel Cadot
Messages: 68785
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
In your title you have "Oracle 10g(on linux)", why do you post this in Windows forum?

SQL*Plus+spool - SQL*Loader.

Regards
Michel

Report message to a moderator

Re: converting text file data to a table on oracle 10g [message #306224 is a reply to message #306217] Thu, 13 March 2008 06:24 Go to previous message
Littlefoot
Messages: 21826
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
+ external tables feature

Report message to a moderator

Previous Topic: Using OO40 and DateTime stamps
Next Topic: Zip the dmp file in windows 2003
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Sep 13 03:47:51 CDT 2026
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.