Export and Import table from or to text file

lawbenny · #1 (**permalink**) 11-12-03, 08:29

Hello all,

Do you guys have any idea?
I want to export my table to a text file
and import a text file to a table

Thanks a lot!!!

ndu35 · #2 (**permalink**) 11-12-03, 09:17

for export, you can use sqlplus and spool the result in a file or write pl/sql proc with utl_file to write a file

for importing a text file, use sql*loader utility

hope this help you

Quote:

Originally posted by lawbenny
Hello all,

Do you guys have any idea?
I want to export my table to a text file
and import a text file to a table

Thanks a lot!!!

Internet Services

Web Development

Digital Marketing

Consumer Tech