How to archive and temporary delete tablespace

From: <markodudic_at_yahoo.com>
Date: 25 Mar 2005 07:08:24 -0800
Message-ID: <1111763304.038353.150080@l41g2000cwc.googlegroups.com>

Hello,

i have data for 3 months in 3 different tablespaces and i want to archive 2 tablespaces to different media (tape), delete datafiles or tabelspaces from databse and make it possible to bring it back later. i don't use partitioning.

to archive tabelspace: put tablespace offline delete tablespace datafile
to put it back online: copy tablespace from tape put tablespace online

Thanks, Marko Received on Fri Mar 25 2005 - 09:08:24 CST