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
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

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: 64102
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.

Regards
Michel
Previous Topic: concatenation using sql loader
Next Topic: loading data in table by using sql loader
Goto Forum:
  


Current Time: Fri Dec 02 20:39:50 CST 2016

Total time taken to generate the page: 0.06456 seconds