Home » RDBMS Server » Server Utilities » DIRECT PATH SQLLOADER (ORACLE 9i -- win2000)
DIRECT PATH SQLLOADER [message #311351] Fri, 04 April 2008 04:05 Go to next message
Messages: 46
Registered: September 2007
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

Re: DIRECT PATH SQLLOADER [message #311359 is a reply to message #311351] Fri, 04 April 2008 04:26 Go to previous message
Michel Cadot
Messages: 65155
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Thank you to read forum guidelines and not post your title in UPPER CASE.

Previous Topic: Import and export
Next Topic: expdp - error
Goto Forum:

Current Time: Wed Aug 23 22:15:15 CDT 2017

Total time taken to generate the page: 0.01632 seconds