| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.misc -> Re: SQL*LDR and EXP, IMP(Urgent)
Sybrand Bakker wrote:
>
> http://technet.oracle.com has ALL manuals onlin. You need to subscribe, but
> that's free and instantaneous.
> For the rest
> 1 yes, set linesize whatever
> 2 you need to use the append clause instead of replace or truncate or insert
> Constraints will be checked of course
> 3 Just import with ignore=y. Constraints will be checked. You will soon
> regret it. All violating records are dumped to output, 1 column per line.
>
> Hth,
>
> --
> Sybrand Bakker, Oracle DBA
> NJN <ibm_97_at_yahoo.com> wrote in message news:38569AE6.5A5BC97F_at_yahoo.com...
> > Oracle 8i for Solaris.
> >
> > Use the following statement to generate a flat file: (use CTRL-F as
> > delimiter)
> >
> > set termout off
> > set feedback off
> > set verify off
> > set heading off
> >
> > spool flatfile
> > select col_1||'ctrl-F'||col_2||'ctrl-F'||.......||col_end
> > from table;
> > spool off
> >
> > My questions:
> >
> > 1. This table has lots of columns, several are defined as varchar2(256).
> > Each row of table retrived in the flat file is divided into several
> > lines. How to fix this? set linesize...(?) Where can I find the help
> > info about sqlldr and sqlldr control file? I don't have the manual right
> > now.
> >
> > Anyway, does my way for generating flat file and loading into table
> > work?
> >
> > 2. Can SQLLDR be used to load data into existing table which already has
> > some data? If yes, how? I don't have to manual in my hand.
> >
> > 3. Can IMPORT be used to load into existing table which already has some
> > data? If yes, how?
> >
> > Thanks for help!!!! Pl,ease also email me a copy! Urgent without manual!
> >
and set trimspool on which will allow you to set a massive line size and not worry about trailing spaces in your spool file.
HTH
--
"Some days you're the pigeon, and some days you're the statue." Received on Tue Dec 14 1999 - 08:08:21 CST
 |
 |