Home » RDBMS Server » Backup & Recovery » ORACLE dump file to txt file (Oracle 10g to Sybase 12.5)
ORACLE dump file to txt file [message #502788] Sat, 09 April 2011 12:27 Go to next message
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
Re: ORACLE dump file to txt file [message #502790 is a reply to message #502788] Sat, 09 April 2011 13:02 Go to previous messageGo to next message
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/
Re: ORACLE dump file to txt file [message #502792 is a reply to message #502788] Sat, 09 April 2011 13:55 Go to previous message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
See T. Kyte blog: How Can I unload data to a flat file

Regards
Michel


Previous Topic: TSPITR
Next Topic: Archive Log Errors
Goto Forum:
  


Current Time: Thu Mar 28 07:09:14 CDT 2024