| sqlloader with nologging mode [message #313564] |
Sun, 13 April 2008 14:43  |
pankajkmeena
Messages: 46
Registered: September 2007
|
Member |
|
|
In partitioned table both table and partition NOLOGGING attribute is set. But during upload of data via SQLLOADER (direct=N) redo is generating.
Is there is any way of supressing redo generation during data load.
thankx
|
|
|
|
|
|
| Re: sqlloader with nologging mode [message #313567 is a reply to message #313565] |
Sun, 13 April 2008 14:57  |
pankajkmeena
Messages: 46
Registered: September 2007
|
Member |
|
|
thankx
actually i want solution of below problem
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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
