DIRECT PATH SQLLOADER [message #311351] |
Fri, 04 April 2008 04:05 |
pankajkmeena
Messages: 46 Registered: September 2007
|
Member |
|
|
Hi
i am having a large partitioned (50 GB) table in database running in no archieve mode .This table gets updated only using sqlloader .
Now in order to take incremental rman backup i want to unable archieve log mode .
But i dont want redo gets generated during insertion using sql-loader .
This is possible through direct path sql-load.
My problem is that this table is indexed on Four different columns .(1 uniq & 3 nonuniq). So will direct path load make then unusable and rebuilding them takes very much time.
Thankx in advance for your reply
[Updated on: Fri, 04 April 2008 04:20] Report message to a moderator
|
|
|
|