import .lst files

[faathir88]

can anyone help me??
i have .lst file and i want to import that file into a table. how to do that?? thanks for your answers..

[debasisdas]

to import to oracle database you need a .DMP file.

[faathir88]

to import to oracle database you need a .DMP file.

how can i create it in oracle??thanks. ..

[debasisdas]

you need to use the EXPORT utility for the same.

[faathir88]

you need to use the EXPORT utility for the same.

here, i have .lst file

MDF RK SEK DP KJM_SEK
----- ------- -------- -------- ---------- -----
CBB RA S001 RA01 2
CBB RA S001 RA03 2
CBB RA S001 RA05 2
CBB RA S001 RA09 2

n i want to insert them into (let's say temp table)
how is it then in a simple way just using sql command??

thx

[amitpatel66]

here, i have .lst file

MDF RK SEK DP KJM_SEK
----- ------- -------- -------- ---------- -----
CBB RA S001 RA01 2
CBB RA S001 RA03 2
CBB RA S001 RA05 2
CBB RA S001 RA09 2

n i want to insert them into (let's say temp table)
how is it then in a simple way just using sql command??

thx

Either you need DMP file as suggested in the above post or you need a .csv or a .dat file (flat file with a delimiter) to upload them in to oracle database using SQL LOADER. the sample data above contains the column names and it is not in the correct format that it can be uploaded easily.