Re: Tablespace Offline on Oracle 817i

• Post for FREE via your newsreader at post.usenet.com ****

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

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=

• Usenet.com - The #1 Usenet Newsgroup Service on The Planet! *** http://www.usenet.com Unlimited Download - 19 Seperate Servers - 90,000 groups - Uncensored -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=