I am working on a application where all the records older than 6 months need to be move to history tables in the same schema, but on a different table space.
Looking for a stored procedure which can preform this process.
For ex. TABLE_A (live, latest 6 months) ==> TABLE_A_H (archive, older than 6 months, up to 8 years).
So far no is..
Thanks in Advance