Hello,
Sometime you should make backup for a table and then delete all from original table.
You can do it which next steps.
First of all you have check data in original table:
1. select * from CHOICE_VALUES
When you know count of rows this is a time for backup table:
2. create table CHOICE_VALUES_backup as select * from CHOICE_VALUES;
Delete old data from original table.
3. delete from CHOICE_VALUES;
4. commit;
Good luck....
No comments:
Post a Comment