Partitions restore

From: Yechiel Adar <adar666_at_inter.net.il>
Date: Thu, 02 Nov 2006 21:11:01 +0200
Message-ID: <454A42C5.4020707@inter.net.il>

Oracle 9206 on windows RAC.
We have am imaging system for checks.
Each morning each employee in the bank retrieve the images of the checks, that belong to the account he is responsible for, and decide if to honor them or bounce them. Grey images(each about 30KB) are kept for 90 days and black and white are kept for 1 year. After the first scan the images are not used again, unless there is something to check.
By the nature of the application the users use mostly the last partition.

In a meeting today someone suggest the following:

1) Put each partition (or several partitions) in a separate tablespace.
2) Backup the whole database.
3) In case of needing to restore, you can restore the system tablespace

and the tablespaces containing the most recent partitions and activate the database.
4) While the users are working you can restore the other tablespace containing the historical images that are not usually used.

This sounds fine but I started to wonder if Oracle will let me work on a table that contain partitions that should be there but does not exist.

--

Adar Yechiel
Rechovot, Israel

--

http://www.freelists.org/webpage/oracle-l Received on Thu Nov 02 2006 - 13:11:01 CST