Home » RDBMS Server » Server Utilities » sqlloader with nologging mode (ORACLE 9i -- winXP)
sqlloader with nologging mode [message #313564] Sun, 13 April 2008 14:43 Go to next message
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 #313565 is a reply to message #313564] Sun, 13 April 2008 14:52 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
>Is there is any way of supressing redo generation during data load.
NO
Re: sqlloader with nologging mode [message #313567 is a reply to message #313565] Sun, 13 April 2008 14:57 Go to previous message
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.

Previous Topic: Export for one month
Next Topic: How to calculate percentage completion while running SQL LOADER through shell script
Goto Forum:
  


Current Time: Wed Dec 07 22:21:17 CST 2016

Total time taken to generate the page: 0.13603 seconds