Data Archiving

[Former Member]

Hai Friends,

We have a Z table which contains around 400000 data. i want to archive this. is this possible only with the BASIS team or any other altenatives. if so explain me the process.

[Former Member]

Hi,

It really depends on what your reasons are for archiving, do you need to free up space in the database or just improve the performance of these table by removing old entries?

If you just need to improve performance then create a copy of your Z table definition and copy 'out of date' records to this copy table. Create a report than can run periodically to copy records from you current table to the copy based on some criteria.

If you need to free up space in the database you will have to use whatever archiving strategy is in place on your system currently.

Regards,

Nick

[Former Member]

Hi

I dont think there is another solution then either to delete the records which are not required , to free up the space...or its better to create a new Ztable.

Else contact Basis team at your end if they have mechanism for table data archiving

Thanks!

Prashant