Quickest Way to Export Data to a Flat File in Oracle

Q

What Is the Quickest Way to Export a Table to a Flat File in Oracle?

✍: FYIcenter.com

A

The quickest way to export a table to a flat file is probably to use the SQL*Plus SPOOL command. It allows you to record SELECT query result to a text file on the operating system. The following tutorial exercise shows you how control the output format, start the spooler, and dump all record from a table to a flat text file:

>mkdir \oraclexe\test
>sqlplus /nolog

SQL> connect HR/fyicenter

SQL> SET HEADING OFF;
SQL> SET FEEDBACK OFF;
SQL> SET LINESIZE 1000;
SQL> SPOOL \oraclexe\test\employees.txt;
SQL> SELECT * FROM EMPLOYEES;
......
SQL> SPOOL OFF;

You should get all records in employees.txt with fixed length fields.

 

Loading and Exporting Data in Oracle

⇒⇒Oracle Database Tutorials

2016-10-16, 171👍, 0💬