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.

Report message to a moderator

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: 4589
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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Feb 02 13:46:25 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.