> 
> Hello Ari
> Forget the first question of the day. I have find that I need a CTL file.
> My new question is: When I use the SQL*LOADER application the destination
> table must be empty.
> Is it possible that make an import in a non empty table
> 
> 
> Thank you 
> 
> Harold Levasseur  
> [hlevasseur@integrim.com]
> 
Harold,

In your control file, you can specify "INSERT", "APPEND", "REPLACE", or "TRUNCATE".
Insert, the default, will load data only if the table is empty.
Append will add new records.
Replace will delete the records in the table and replace them by loading new
        data, firing any triggers for each record.
Truncate will truncate the table and replace the old data with new data.


-Ari Kaplan
Independent Oracle DBA Consultant

<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->
<-> For 160+ Oracle tips, visit my Web Page:                      <->
<->                                                               <->
<->             www.arikaplan.com                                 <->
<->                                                               <->
<->             email: akaplan@interaccess.com                    <->
<-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><-><->

Back to Ari Kaplan's Home Page to Ari Kaplan's Home Page