oracle9i export

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

lakshmananl - 30 Nov 2005 06:16 GMT

hello gurus,
i have a clarification in Export, can the export be done in flat text
file instead of a <file.dmp> file. whether it is possible in this,
since few say that this feature is available in DB2 and SQL server. If
so how this should be done in ORACLE9i?

thanks in advance

Reply to this Message

Terminator - 30 Nov 2005 08:41 GMT

Dear,

Do you know the sql loader this can help you in this matter.

Regards
RK

Reply to this Message

Terminator - 30 Nov 2005 09:00 GMT

Dear,

Do you know the sql loader this can help you in this matter.

Regards
RK

Reply to this Message

sybrandb@yahoo.com - 30 Nov 2005 09:11 GMT

Export can't be done in a flat file format.
Tables can be dumped to csv format easily using sql*plus and/or pl/sql
search for 'Sql Unloader' on http://asktom.oracle.com

Evidently, if you have the correct ODBC drivers, you can set up
heterogeneous gateway to either DB2 or Sqlserver, export directly,
without using flat files.

Signature

Sybrand Bakker
Senior Oracle DBA

Reply to this Message