I have exported over 90million rows using export utility (ixf). Now I have to load into the new table and I dont need the logs generated.
In default, the LOAD will not logged. Is it correct ? the statement is below.
LOAD from ACCCCT.ixf of ixf insert into ACS (CUSTOMERNO,TIME_STAMP,BRANCH_CODE,SHORTNAME,MAGIC 1,ASV,ASTATUS,RESTDATETO,RESTUID,RESTCODE,RESTTEXT ,FREETEXT,OPENDATE,DEMOGRAPHICLOCN,VALIDFROM,VALID TO,STATUS,OPID_ENTRY,TIME_STAMP_ENTRY);
If the LOAD is fail then the table/tablespace will not accessable. The question is, how can I start the load again ?
Please share your experience.
Use the keyword "nonrecoverable" in your load command. Do not wait with you next backup after the load has finished.
With restart/terminate options you can wriggle yourself out of an pending load. Personally I've never been successful and a drop/create table worked better for me....