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?
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: 60017
Registered: March 2007
Location: Nanterre, France, http://...
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
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: 19893
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
+ external tables feature
Previous Topic: Using OO40 and DateTime stamps
Next Topic: Zip the dmp file in windows 2003
Goto Forum:
  


Current Time: Mon Dec 22 10:04:27 CST 2014

Total time taken to generate the page: 0.11789 seconds