Which bulk loading is better in performance
1. Oracle 7 Load
2. Oracle OCI Load
I have to every time delete the table and insert the records. In #2 we don't have the option to delete the table in oracle.
bulk loading
Moderators: chulett, rschirm, roy
Your question is not clear is it DELETE or TRUNCATE. if delete then are you using any key for deletion. If deletion then I suppose you can not do it through BULK loading.
If TRUNCATE/LOAD then use ORACLE 7 BULK LOAD to create Control file and load using sql loader(sqlldr). In CTL you can specify TRUNCATE or REPLACE OR APPEND OR INSERT only. This is faster for TRUNCATE/LOAD
Please correct me if I am wrong.
If TRUNCATE/LOAD then use ORACLE 7 BULK LOAD to create Control file and load using sql loader(sqlldr). In CTL you can specify TRUNCATE or REPLACE OR APPEND OR INSERT only. This is faster for TRUNCATE/LOAD
Please correct me if I am wrong.
Thanks, BK
-
- Participant
- Posts: 26
- Joined: Tue Dec 18, 2007 6:31 am
Ok.On your way..
You want to delete all the records in the table , or only the records that have been loaded yesterday.
If only the records loaded yesterday
------------------------------------
1. Use DATE parameter as key and use ORACLE OCI stage only (not bulk)
2. Write user defined sql.
3. Delete * from table where
Record_Date >= Date1 and Record_Date < Date2
4. Provided your table contains Record_Date(date on which the data is loaded).
I have given both the solution(Delete full table or only selected data). Since I don't know the data format,i am writing user defined sql. In case of full table delete , use TRUNCATE.Delete will be slow and uses more system resources on data base side.
You want to delete all the records in the table , or only the records that have been loaded yesterday.
If only the records loaded yesterday
------------------------------------
1. Use DATE parameter as key and use ORACLE OCI stage only (not bulk)
2. Write user defined sql.
3. Delete * from table where
Record_Date >= Date1 and Record_Date < Date2
4. Provided your table contains Record_Date(date on which the data is loaded).
I have given both the solution(Delete full table or only selected data). Since I don't know the data format,i am writing user defined sql. In case of full table delete , use TRUNCATE.Delete will be slow and uses more system resources on data base side.
Thanks, BK