3 Replies Latest reply on Dec 1, 2016 8:25 PM by SYED REHMAN

    How to reduce TDE size horizontally (rows, not removing columns) of an existing TDE?


      Hi experts,

      looking for some help. May be a simple one but I can't wrap my head around it.



      I have a TDE which I have been accumulating by incremental extracts for last few years - TDE has now grown too big (5 gb). The database it is sourcing data from keeps only last 1 month data - I need to reduce the size of data in existing TDE to last one year only - how can I achieve it?



      If I add a Filter on data extract level (data source edit mode) then it basically re-create extract from source which has only 1 month data???



      Any idea how can I achieve it?