View previous topic :: View next topic
|
Author |
Message |
bipinpeter
Active User
Joined: 18 Jun 2007 Posts: 213 Location: Cochin/Kerala/India
|
|
|
|
Hi All,
Currently in one of the table, the load happens with
LOAD RESUME option. I want to change that to LOAD REPLACE. For this what all thing i have to take care?
Is any problem there if change LOAD RESUME to LOAD REPLACE |
|
Back to top |
|
|
sivaram.ch
New User
Joined: 28 Jun 2005 Posts: 11
|
|
|
|
Load Replace will replaces all the data whatever you had in the table earlier.If you donot have any problem in replacing it you can use the clause. |
|
Back to top |
|
|
ssmukul
New User
Joined: 22 Jan 2008 Posts: 19 Location: India
|
|
Back to top |
|
|
GuyC
Senior Member
Joined: 11 Aug 2009 Posts: 1281 Location: Belgium
|
|
|
|
sivaram.ch wrote: |
Load Replace will replaces all the data whatever you had in the table earlier.If you donot have any problem in replacing it you can use the clause. |
Actually : Load Replace will replaces all the data whatever you had in the tableSPACE earlier
so if you have more than 1 table in a tablespace , the other tables will be empty. |
|
Back to top |
|
|
|