Re: SQL*LDR and EXP, IMP(Urgent)

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!
>
Received on Tue Dec 14 1999 - 13:44:49 CST