Home » RDBMS Server » Server Utilities » Command line Export Tool
Command line Export Tool [message #368114] Thu, 03 August 2000 11:05 Go to next message
Lee
Messages: 56
Registered: May 1999
Member
Does any one know of any Export tool that will export into a flat file, and will be used from the command line.
Thank you.
Re: Command line Export Tool [message #368118 is a reply to message #368114] Mon, 07 August 2000 05:00 Go to previous message
Frank Naude
Messages: 4579
Registered: April 1998
Senior Member
Hi,

You can use SQL*Plus to spool data to a flat file. Look at this example:

SET ECHO OFF NEWPAGE 0 SPACE 0 PAGESIZE 0 FEED OFF HEAD OFF TRIMSPOOL ON
SPOOL myfile
SELECT * FROM TAB;
SPOOL OFF
EXIT;

Hope it helps.

Best regards
Frank Naude
Previous Topic: Migrating Informix database to Oracle8
Next Topic: Re: editing oracle dump file
Goto Forum:
  


Current Time: Thu Mar 28 13:30:46 CDT 2024