Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Tablespace Offline on Oracle 817i
Ed Stevens <nospam_at_noway.nohow> wrote in message news:<e368e0ljdl0b23tple6kskbdo5f2ppg9f4_at_4ax.com>...
> On 30 Jun 2004 21:35:41 -0700, wy_at_fudan.edu (wy) wrote:
>
> >Hello,
> >
> >I would like to know if Oracle817i support that making the tablespace
> >offline and moving the datafiles to secondary device(in CD) for the history
> >data,and move them back when I need the data again.Should all these work be
> >done when database is online or offline?
> >
> >
> >wy
>
> I can't think of a reason you couldn't, but also can't think of a
> reason why you would want to. My guess is that if we knew what *real*
> problem you were trying to solve, we might be able to suggest a better
> solution.
The database increases by 50-80g each month and the recent data which
are readonly are saved in primary storage device(harddisk).
when the data are older than one year,we want to move them from
primary storage device to secondary storage device(CDs) instead of
importing & exporting.
The tables are partitioned for each month data.
Any suggustions?
Received on Thu Jul 01 2004 - 21:24:21 CDT
![]() |
![]() |