Guest_imported
New member
- Jan 1, 1970
- 0
Hi
We have requirement as follows:
Insert records into a table in refresh mode (Previousrecrods will be dropped) every time.This table ishandling accross 70 lakh records.
To cater the requirement we have created the table with
NO LOG INTIALLY. Using a batch program we have an ALTER
table command to enable the NO LOG OPTION.This is to delete the existing records automatically.
Command used :
ALTER TABLE TBL1 ACTIVATE NOT LOGGED INTIAALLY WITH EMPTY TABLE.
Couldyou please clarify whether:
1) This isbetter option than LOADING A EMPTY FILE suing LOAD utility.
2) Will there be any performance issue?
3) Is the table is physically altered during execution.
regards,
Nanda
We have requirement as follows:
Insert records into a table in refresh mode (Previousrecrods will be dropped) every time.This table ishandling accross 70 lakh records.
To cater the requirement we have created the table with
NO LOG INTIALLY. Using a batch program we have an ALTER
table command to enable the NO LOG OPTION.This is to delete the existing records automatically.
Command used :
ALTER TABLE TBL1 ACTIVATE NOT LOGGED INTIAALLY WITH EMPTY TABLE.
Couldyou please clarify whether:
1) This isbetter option than LOADING A EMPTY FILE suing LOAD utility.
2) Will there be any performance issue?
3) Is the table is physically altered during execution.
regards,
Nanda