July 9, 2008 at 4:52 am
Hi All
I need help with archiving data on one of the tables in Production (IAS), The table has over 69mil records, so i need to keep data up to 3 months for reporting but i dont want to delete it and the tricky part it's also a replicated enviroment.
Any solution is welcomed!!
Thx
Jnr DBA
It's better to fail while trying, rather than fail without trying!!!
July 9, 2008 at 9:58 am
Can you create an Archive database (or table), move the data there, delete it from the main database, and then the reports that might need the old data can use a Union All operator to query from both tables at the same time?
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
July 9, 2008 at 10:32 am
Hi
I agree with GSquared answer, coz this way you can save data and from performance point of view also it is good. But curious to know do you have partitions on this table?
Thanks -- Vj
July 10, 2008 at 12:00 am
Hi
No partition on the table
Thx
It's better to fail while trying, rather than fail without trying!!!
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply