Home >> FAQs/Tutorials >> Oracle Tutorials
Oracle Tutorials - Quickest Way to Export Data to a Flat File
(Continued from previous topic...)
What Is the Quickest Way to Export a Table to a Flat File?
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:
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.
(Continued on next topic...)
- What Is the Simplest Tool to Run Commands on Oracle Servers?
- What Is the Quickest Way to Export a Table to a Flat File?
- How To Export Data with a Field Delimiter?
- What Is SQL*Loader?
- What Is a SQL*Loader Control File?
- How To Load Data with SQL*Loader?
- What Is an External Table?
- How To Load Data through External Tables?
- What Are the Restrictions on External Table Columns?
- What Is a Directory Object?
- How To Define an External Table in a Text File?
- How To Run Queries on External Tables?
- How To Load Data from External Tables to Regular Tables?
- What Is the Data Pump Export Utility?
- What Is the Data Pump Import Utility?
- How To Invoke the Data Pump Export Utility?
- How To Invoke the Data Pump Import Utility?
- What Are Data Pump Export and Import Modes?
- How To Estimate Disk Space Needed for an Export Job?
- How To Do a Full Database Export?
- Where Is the Export Dump File Located?
- How To Export Your Own Schema?
- How To Export Several Tables Together?
- What Happens If the Imported Table Already Exists?
- How To Import One Table Back from a Dump File?
- What Are the Original Export and Import Utilities?
- How To Invoke Original Export/Import Utilities?