Archiving older data

Hi,
Like in Oracle high water mark concept is there, which takes the older data
into another partition and archives them to keep the running production tabl
e short. Similarly is there any similar concept is there in Oracle.
Thanks in advance
Regards,
SunilSunil
>Similarly is there any similar concept is there in Oracle.
Did you mean in SQL Server?
If you do please take a look at this very useful article
http://vyaskn.tripod.com/sql_archive_data.htm
"Sunil" <anonymous@.discussions.microsoft.com> wrote in message
news:35F449AD-92EC-42DB-AA37-340BFC261223@.microsoft.com...
> Hi,
> Like in Oracle high water mark concept is there, which takes the older
data into another partition and archives them to keep the running production
table short. Similarly is there any similar concept is there in Oracle.
>
> Thanks in advance
> Regards,
> Sunil