OraFAQ Forum: Backup & Recovery » ORACLE dump file to txt file

Home » RDBMS Server » Backup & Recovery » ORACLE dump file to txt file (Oracle 10g to Sybase 12.5)

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

ORACLE dump file to txt file [message #502788]

Sat, 09 April 2011 12:27

pranab123
Messages: 1
Registered: April 2011

Junior Member

Oracle10g to Sybase12.5 Migration:-
How a Oracle dump file can be converted to any text file/xls file which will be loaded in sybase database later through BCP.
means
1.Exporting objects as dump file from Oracle.
2.Is there any tool/process available that can convert this into csv/txt/xls file.
3.This files can be loaded in sybase.

Thanks,
Pranab
Sybase Developer

Report message to a moderator

Re: ORACLE dump file to txt file [message #502790 is a reply to message #502788]

Sat, 09 April 2011 13:02

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>2.Is there any tool/process available that can convert this into csv/txt/xls file.
use SQL

It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/

Report message to a moderator

Re: ORACLE dump file to txt file [message #502792 is a reply to message #502788]

Sat, 09 April 2011 13:55

Michel Cadot
Messages: 68770
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

See T. Kyte blog: How Can I unload data to a flat file

Regards
Michel

Report message to a moderator

Previous Topic:	TSPITR
Next Topic:	Archive Log Errors

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 05 01:46:21 CDT 2025