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: 63937
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: concatenation using sql loader
Next Topic: loading data in table by using sql loader
Goto Forum:

Current Time: Fri Oct 28 00:14:01 CDT 2016

Total time taken to generate the page: 0.05500 seconds