Thanks Chuck, this is exactly what my understanding was before i came across this scenario today and found there is something called table extension also.

Interestingly the following 2 tables are on extension not rotation

sys_audit

sys_email

and i don't thing this data is lost ever, like in the case of rotation.