Oracle data export txt and import txt

Oracle data export txt and import txt ORACLE data export TXT and import from TXT: Export to TXT file: 1. Open the CMD window with PL/SQL DEV. 2. spool d:/output.txt; 3. set heading off; -- remove header 4, select * from usergroup; 5. Import spool off; www.2cto.com TXT to ORACLE: 1. Use "Text Importer" under TOOLS of PL/SQL DEV ". 2. input the TXT file (output.txt) in the "Data from textfileworkflow" tab ). 3. Set the field count, field separator, and line Separator under "Configuration. 4. Select the user and table of the database to be imported under the "Data to Oracle" tab. 5. Set the correspondence and data type between the TXT field and the target table field under Fields. 6. Click "Import" below.