all hope for you.
I need to export a huge table (900 fields, 1 000 000 strings) in to txt ansi file. UTL_FILE takes a lot of time. It is not suitable in this task. I'am trying to use Oracle Datapump, but i can't receive txt file with ansi symbols in it (only 2TTЁ©QRўҐEJЉ•). Can anybody advice me anything. Thank you in advance.
Oracle Data Pump can only export in its proprietary binary format.
If you want to export data to text you have only a few options:
Googling "SQL Unloader" comes up with a few ready-made solutions that you might be able to use directly or modify for your needs.