OraFAQ Forum: Server Utilities » Conversion of Oracle database to text file (merged)

Home » RDBMS Server » Server Utilities » Conversion of Oracle database to text file (merged)

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

Conversion of Oracle database to text file (merged) [message #268808]

Wed, 19 September 2007 15:51

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.

Report message to a moderator

Re: Conversion of Oracle database to text file [message #268810 is a reply to message #268808]

Wed, 19 September 2007 16:12

BlackSwan
Messages: 26766
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

Report message to a moderator

Re: Conversion of Oracle database to text file [message #268812 is a reply to message #268810]

Wed, 19 September 2007 16:23

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!

Report message to a moderator