Home » RDBMS Server » Server Utilities » Conversion of Oracle database to text file (merged)
Conversion of Oracle database to text file (merged) [message #268808] Wed, 19 September 2007 15:51 Go to next message
rubhatta
Messages: 7
Registered: August 2007
Junior Member
Hello,

Is it possible to convert the existing oracle database(9i/10g) into a text file or csv file and vice versa. If so, what is the procedure?Also, I want to know whether this newly created text file can be read on normal office PC on windows. Is there any specified procedure to open the converted text file in windows environment?

I would be very thankful if I can get the required details.
Re: Conversion of Oracle database to text file [message #268810 is a reply to message #268808] Wed, 19 September 2007 16:12 Go to previous messageGo to next message
BlackSwan
Messages: 25035
Registered: January 2009
Location: SoCal
Senior Member
>Is it possible to convert the existing oracle database(9i/10g) into a text file or csv file and vice versa.

Yes, either format.

>If so, what is the procedure?

What ever you write in the procedure.

>Also, I want to know whether this newly created text file can be read on normal office PC on windows.

Likely NOT the case because the file would be generated on the DB server system.

>Is there any specified procedure to open the converted text file in windows environment?

vi fubar.txt
Re: Conversion of Oracle database to text file [message #268812 is a reply to message #268810] Wed, 19 September 2007 16:23 Go to previous messageGo to next message
rubhatta
Messages: 7
Registered: August 2007
Junior Member
Thank you for responding. Will you be able to give me some pointers regarding what to write in the procedure. I am new to this and any help would be highly appreciated.

Thanks a lot!
Re: Conversion of Oracle database into textfile [message #268815 is a reply to message #268808] Wed, 19 September 2007 17:21 Go to previous messageGo to next message
BlackSwan
Messages: 25035
Registered: January 2009
Location: SoCal
Senior Member
http://www.orafaq.com/forum/t/89622/74940/

Do NOT cross/multi-post.

Re: Conversion of Oracle database into textfile [message #268872 is a reply to message #268815] Wed, 19 September 2007 23:52 Go to previous message
d.c.b.a
Messages: 44
Registered: March 2005
Location: China
Member

http://www.dbatools.net/tag/Unload

Free OCI based utility, high performance
Previous Topic: sqlldr files in the directory from windows client
Next Topic: Loading data in remote machine using sqlldr command
Goto Forum:
  


Current Time: Sat Dec 03 19:58:03 CST 2016

Total time taken to generate the page: 0.10064 seconds