Re: Utility to dump an Oracle table

On Tue, 7 Feb 1995, Susan Wagner wrote:

> DB2 has a utility - I think it's called DSNUTIL. It will download a DB2
> table in fixed column flat file format. Does anyone know if there is an
> Oracle utility like this? We do not want to use export because direct
> load is faster than import and we are dealing with very large volumes.
>
>
>
No, but you can use the spool function to do the simliar things, first write a script like that :

---Cut Here---
set echo off
set pause off
set pagehead off
col col1 format ???
.
.
col coln fomrat ???
spool output.file

select col1, .... ,coln
from table
where blah, blah, blah ...

spool off
disconnect
---Cut Here---

And then run it, you can then get the flat file 'output.file' and load it to database using sql*loader.
Dose this help you?
-

      __       _        | Yick Ka Yuen, Henry | City Univserity of Hong Kong
 |_| |_  |\ | |_| \ /   | Email : 92908250_at_cpccux1.cityu.edu.hk
 | | |__ | \| | \  | .  | Computer Studies, Year 3/4 
-------------------------------------------------------------------------------