I am using 32 bit TimesTen database so the data population is max 150k records so can i replicate the data from TimesTen database to Oracle database and clean(flush the data) in TimesTen so that i can ensure that i can insert more data via TimesTen database.What is the task you are trying to resolve? If you need to insert a lot of data in Oracle DB why do you use TimesTen for that? You can insert data in Oracle directly instead of using TimesTen.
What is the task you are trying to resolve? If you need to insert a lot of data in Oracle DB why do you use TimesTen for that? You can insert data in Oracle directly instead of using TimesTen.I expect this question from some one else in the Forum.
The thing is that i need to Insert Millions of data in a single go with less time,I tried with Oracle and TimesTen ,TimesTen is bit faster than Oracle for Inserting the data and where as the replication time and insertion time from TimesTen to Oracle(with replication time) is little bit less when compared to direct oracle insertion.I am sorry, but I don't believe you. Lets compare.
My project does not deals with Parallel query as of nowWhy don't you use that? What is the aim of your project?
I have checked with the replication option from TimesTen to Oracle i am gaining 60 sec for 100 records.60 sec. for inserting 100 records? I think there is a problem with Oracle db server.
If you did not believe please come back with the figure which you have got.Absolutely agree. Test (I use very old desktop and Vmware virtual machine):
11 sec for insert 632797 records. I didn't use parallelism and direct load (Append).
SQL> set timing on SQL> create table test_table as select * from dba_source; Table created. Elapsed: 00:00:11.27 SQL> select count(*) from test_table; COUNT(*) ---------- 632797 Elapsed: 00:00:00.29 SQL>