Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Not getting headers in text file when i used odisqlunload tool?

ARIVEMULA KAVYA KUMARI LERA TECHNOLOGY PVT LTDDec 17 2015 — edited Jan 20 2016

Hi,

I am try load oracle table data to text file.

for this i have created procedure. select command on target. I have used technology as "odi tools".

in command panel, i have placed below code

OdiSqlUnload "-FILE=D:\TEXT\sucess_log.txt" "-DRIVER=oracle.jdbc.OracleDriver" "-URL=jdbc:oracle:thin:@192.0.0.0:1521:odi" "-USER=odi" "-PASS=hpfHiT7Ql0Hd79KUseSWYAVIA" "-FILE_FORMAT=VARIABLE" "-FIELD_SEP= | " "-ROW_SEP=\r\n" "-DATE_FORMAT=yyyy/MM/dd HH:mm:ss" "-CHARSET_ENCODING=ISO8859_1" "-XML_CHARSET_ENCODING=ISO-8859-1"

SELECT * FROM SNP_SESSION

after execute the procedure , i am getting data in textfile.

but i didnt get column headings in text file . column names like (SESS_NO,JOB_TYPE,JOB_NAME,TABLE_NAME,JOB_BEGIN,JOB_END,Time_in_Minutes,ERROR_MESSAGE,SESS_STATUS)

my requirement is , i want to get those column names into text file...

Please help me,

Thanks in advance,

a.kavya.

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 17 2016

Added on Dec 17 2015

#11g, #business-intelligence-applications, #data-integrator, #odi, #system-management-and-integration

3 comments

789 views