| Re: data unload [message #101887] |
Sat, 10 November 2001 01:26  |
Anzer
Messages: 2
Registered: November 2001
|
Junior Member |
|
|
Oracle does not have any Unload tools
but we can use sql*plus to format and then spool the data
set echo off newpage 0 space 0 pagesize 0 feed off head off trimspool on
spool data1.txt
select col1,col2 , col3
from tab1
where col2 = 'XYZ';
spool off
----------------------------------------------------------------------
|
|
|
|
| Re: data unload [message #104203 is a reply to message #101887] |
Wed, 18 August 2004 09:03  |
Bob Shuster
Messages: 2
Registered: August 2004
|
Junior Member |
|
|
|
try FastReader from WisdomForce www.wisdomforce.com . It is third party util that unload huge oracle tables into text file in extremely fast way and generates ctl files
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
