|
View previous topic :: View next topic
|
| Author |
Message |
bipinpeter
Active User
.jpg)
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 |
|
|
|
|
