Re: Tablespace Offline on Oracle 817i

wy_at_fudan.edu (wy) wrote in message news:<e8d0244c.0406302035.36d9ac3a_at_posting.google.com>...
> 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?

If you can make the tablespace read-only, you may be able to read it from the cd. The alter tablespace read-only actually works after all transactions against the tablespace have committed.

Of course, if you are moving a tablespace it should be offline.

As someone else mentioned, you may want to check out transportable tablespaces.

jg

--
@home.com is bogus.
The jaunty billionaire: 
http://www.signonsandiego.com/uniontrib/20040701/news_1b1oracle.html