Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How to generate text data that can be later imported with SQLLoader?

Re: How to generate text data that can be later imported with SQLLoader?

From: kru <kru_at_messer.de>
Date: Tue, 6 Mar 2001 11:54:14 +0100
Message-ID: <982fib$qep$1@news.messer.de>

Hi Scott,

why not try exp and imp tools to perform table export / import ?  You can duplicate tables in different databases easily. What system is your frontend ? What tools do you use.

To import data with the loader utility, I use a pipe seperator and streamed text
in general. As a UNIX guy, I like that very much, especially with all that awk , perl yacc tools around here to manipulate the data before importing

Rgds

    Christian

Scott Kerr schrieb in Nachricht ...
>How to generate text data that can be later imported with SQLLoader?
>
>I can do it by saving the database data display with the save list command.
>Anything else?
>
>Thanks,
>
>Scott
>
>
>
>
Received on Tue Mar 06 2001 - 04:54:14 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US