0

Is it possible to create a savepoint and to rollback only a partition of a table? Lets assume I created a monthly partition and subpartitions with a group_id for table x.

Now i run some stored procedures to alter the content in table x for a certain group id in a certain month. Before I run the stored procedure, i want to create a savepoint for the partition/subpartition and if necessary I want to rollback only the altered partion/subpartition and not the whole table.

I am asking for oracle and MSSQL.

Improve this question
1
  • @Rusty thanks, but what about MS SQL? Someone here who can an answer for MS SQL?
    – Fulley
    Commented Mar 6, 2015 at 16:04

2 Answers 2

Reset to default
2

Unfortunately this is not possible in SQL Server - you can of course create a backup, or create snapshots on the server (HyperV for example) to accomplish this. Other than that, it's not possible to only do it for a table - the closest I'd consider is differential back/restore.

Improve this answer
1

No, it is not possible to do it that way (at least in Oracle). There are no conditional savepoints/rollbacks

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.