Removing old registers from databases larer than 100GB
Posted by: marcelo marcelo
Date: March 13, 2017 07:12AM

Hi friends

I have a database that have more than 100Gb of data and this is slowing the program queryes. I need to know if is possible to exclude, of principal DB, data older than, for example 6 months.

The basic idea it not to complete exclude these data but, move to other database, where data will remain acessible for admins (not the principal program) as "backup"; so the principal db will running with data from last 6 months (from now for sure)

Is this possible ? How can I do it ?

thank in advance

marcelo

Options: ReplyQuote


Subject
Written By
Posted
Removing old registers from databases larer than 100GB
March 13, 2017 07:12AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.