loading 1 million rows
hi all, i have a problem that would like to solve in the faster possible way.
i have a table with primary keys that that 1 million row. this table is not partition. i would like to load 1 million row into that table.
i am afraid that it will take a long time due to the primary key and analizing the table. not sure if sqlldr will be a good choice. i am using oracle 10g
can somebody give some suggesstions on how to load this data the fastest way available in oracle 10g?
by the way, the 1 million row is located in multiple files. i also have 1 million row in a staging table, would insert alone be fast to insert this 1 million in another table that already have 1 million rows