Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Tablespace Offline on Oracle 817i
Hi
> 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?
There's no problem to taking tablespaces online/offline when the database is online. Of course you cannot have transactions running on this tablespace... You should have a look to transportable tablespaces too.
Chris
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
![]() |
![]() |