Unanswered: Deleting 10 millions records from 90 million
I have 2 big tables in a high transaction system. It contins 9 months of data [90 million]. Each table have around 40 columns [ The total datafiles allocated is 30 GB for both tables and 40 GB for the indexes]. Table is not partitioned. Now I have only 4 GB left in the Server. I Want to delete first month data [10 millions]. I cannot go by delete for a sample of 300 thousands it took 3 hrs.
Because of the non-availabilty of diskspace I can't use create table as to move to a temp table and truncate the table and then recreate the table from temp table.
Is there is any possibility to export a logical backup and import the selected data with some filter condition.