Re: Backup older data

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Tue, 4 Dec 2001 11:32:33 -0000
Message-ID: <3c0cb457$0$8511$ed9e5944@reading.news.pipex.net>

Interesting problem.

My first thought would be to consider storing the images as BFiles. You could then update the file location - perhaps toa tape device or removable storage? Perhaps transportable tablespaces might be a solution as well.

I think initially though I'd probably just export the data and delete.

I'd be interested to see what others do with this sort of problem. (Assuming buy more disks isn't a valid answer.).

--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer

******************************************
"Brian Tkatch" <SPAMBLOCK.Maxwell_Smart_at_ThePentagon.com.SPAMBLOCK> wrote in
message news:3c0bfabc.1238085484_at_news.alt.net...


> Oracle 8i

>

> We have a number of images kept in BLOB fields that are taking up

> quite a bit of space. We have storage limitations, and have decided

> that much of the stored images are not for common retrieval. As such,

> until we better our storage, we need to relocate this data.

>

> What would be a good method of doing that? Export the table/field?

> Somehow backup the TABLESPACE for later use? We have storage space on

> other systems, just not on this one.

>

> Brian

Received on Tue Dec 04 2001 - 05:32:33 CST