Collections:
Quickest Way to Export Data to a Flat File in Oracle
What Is the Quickest Way to Export a Table to a Flat File in Oracle?
✍: FYIcenter.com
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.
⇒ Export Data with Field Delimiters in Oracle
⇐ Simplest Tool to Run Commands on Oracle Server in Oracle
2018-06-27, 1699🔥, 0💬
Popular Posts:
How To Drop a Stored Procedure in Oracle? If there is an existing stored procedure and you don't wan...
Is PL/SQL Language Case Sensitive in Oracle? PL/SQL language is not case sensitive: Reserved words a...
Where to find answers to frequently asked questions on Downloading and Installing SQL Server 2005 Ex...
How To Create a Table Index in Oracle? If you have a table with a lots of rows, and you know that on...
How To Change the Password for Your Own User Account in MySQL? If you want to change the password of...