View previous topic :: View next topic
|
Author |
Message |
santosh.ambaprasad
New User
Joined: 08 Mar 2009 Posts: 16 Location: London
|
|
|
|
Hello All, I hope some can share feed back on this...
I need to load a table with data. That table has index table defined. Am I correct in the following steps-
Load table
Force start table space after successful table
Rebuild Index
Run check data
Run check Index
Thanks |
|
Back to top |
|
|
Santoshkumar Sala
New User
Joined: 18 Jul 2010 Posts: 12 Location: Mumbai
|
|
|
|
LOAD DATA
LOG NO
COPY YES
RESUME YES
INDEX UPDATE
UNIQUECHECK NO
UPDATEDB2STATS YES
INTO TABLE
LOAD DATA
LOG NO
COPY YES
REPLACE
UPDATEDB2STATS YES
INTO TABLE |
|
Back to top |
|
|
Rohit Umarjikar
Global Moderator
Joined: 21 Sep 2010 Posts: 3053 Location: NYC,USA
|
|
Back to top |
|
|
|