There are 2 ways of deleting records from table in database.
Option 1 :
Option 2 :
Option 1 :
truncate table JDESY910.F00950; or
delete JDESY910.F00950;
insert into JDESY910.F00950 select * from SMYEONG.F00950B;
Option 2 :
drop JDESY910.F00950;
Create table "JDESY910".F00950 as select * from "SMYEONG"."F00950B" where '1' = '1'
* this method will not create indexes and not good for big transaction table
Hope that helps....
No comments:
Post a Comment