Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Identifying and extracting an old data over three years

536473Nov 22 2006 — edited Jan 2 2007

Hi guys,

I am looking for a recommendation to shrink database of its current size to at least 60% percent by moving data over 3 years old to an archive area on a separate file system using Oracle 8.1.7.

Can you please provide me any ideas including concern scripts and data dictionary views where I can find out old data and transfer to the archive location as described.

Thanks in advance.

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 30 2007

Added on Nov 22 2006

#general-database-discussions

83 comments

3,377 views