How do I delete data from a large-volume custom object in Sandbox

Question

We have a Sandbox environment with storage limit 2 GB, while alone Order_item__c storage amount is 1.8 GB.

We are trying to delete the record using the filter Year<=2013 from Order_item__c module. How do we deal with mass deletion of records with based on year filter using workbench?

Answer 1

You can write a one time batch and execute it using anonymous window in dev console.

Answer 2

Not sure if Year is a custom field. You will need to run this script (or a similiar script) in the Developer Console. Create a list to gather the records you want to delete, then delete that list.

//Create List of Desired Records to Delete
List<Order_item__c> delLst = [SELECT id FROM Order_item__c WHERE Year__c <= 2013 LIMIT 50000] ;
//Delete List
delete delLst;

Answer 3

You might probably want to refresh your existing sandbox and use Sandbox templates:

Sandbox templates allow you to pick specific objects and data to copy to your Full or Partial Copy sandbox to control the size and content of each sandbox. Sandbox templates are only available for use with Full or Partial Copy sandboxes.

When you create a sandbox template, you select the object data (standard and custom) to copy during the creation or refresh of a sandbox.

If you don't want to refresh the sandbox now, you could go with one of the below options:

1. Run a one-time batch job to delete the records you want. This will require Apex coding.

2. Run a query in the data loader to fetch all the records you wish to delete and then perform the delete operation using the data loader.

Answer 4

You can operate on the results of a SOQL query. Would be simple enough to query using SELECT Id FROM Order_item__c WHERE Year<=2013. Be certain to use the proper field names of course.

Edit

Its been to run that as anonymous APEX using something like

DateTime MyDT = DateTime.newInstance(2012, 31, 12, 24, 59, 59);
list<Order_item__c>mylist=[SELECT ID FROM Order_item__c WHERE CreatedDate <=: MyDT  Limit 10000] ;   
Delete mylist;