Database Backup and Recovery (MOSC)

MOSC Banner

Huge Data(250 GB) in a table

edited Nov 25, 2011 3:29AM in Database Backup and Recovery (MOSC) 6 commentsAnswered
Hi,

we have 250 GB data in a table(partitioned day wise), which is only recent 3 months data, where not frequently queried by the application but if any request comes then only people fetch data from the table.so, instead of keeping such a big table in a DB, we would like to free up space in the DB,

So 1) need to be backed up by using RMAN or datapump, whenever we required then restore in the DB

     2) would like to keep the data in a various flat file (1 week of data each), then if requited queried from the flat file

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center