Re: Archive data "nearly" online (Hierarchical Storage Management)

If the users rarely want the data, you could encourage them to query it as a separate table perhaps, so you could exchange the partitions out of the main table, exchange them into the archive table, then do the read-only/offline bit.

--

Jonathan Lewis
Yet another Oracle-related web site: www.jlcomp.demon.co.uk

coakleyj_at_hotmail.com wrote in message <7jjabj$ml8$1_at_nnrp1.deja.com>...
>Hi everyone.I am enquiring about Hierarchical Storage Management as an
>archiving strategy in conjunction with Oracle 8.So, in other words, we may
>want to archive data more than 4 years oldeach year, but keep it in a state
>that it can be very easily broughtonline at users request ( in a matter of
>minutes by a DBA - rather than having to go through an "import" procedure
>with Oracle Sql*loader orOracle import utility).What I was initially
>thinking of was using Oracle 8 partitioning, and have each year's data in a
>set of partitions and corresponding tablespacesof their own. Then, when the
>data is archived, simply take the appropriatetablespaces offline. My worry
>with this solution is that it is now crirical that the optimizer always
>eliminate the partitions that are in "offline" tablespaces,otherwise an
>error will be returned. I think that it may be difficult to design/develop
>the application to always successfully achieve this partitiion elimination.
>Has anyone done something similar?What (other, better and more fully
>supported) HSM solutions are avaliable that Oracle support, and how
>effective are they? What are the issues etc etc?Thanks in advance
>Coakleyj.
>
>
>Sent via Deja.com http://www.deja.com/
>Share what you know. Learn what you don't.
Received on Wed Jun 09 1999 - 14:26:56 CDT