<<Previous Next>>
Oracle - What
is an Archiver? - April 10, 2009 at 11:00
AM
What is an Archiver?
Archiving is the process of removing of old
data and unused data from the main databases. This process keeps
databases smaller, more manageable and thus acquires performance
gain. To archive data, you can either delete data from the database
or copy the data to a history table and delete that data from the
database.
Also read
What is the content view and stacked view?, Explain the different
types of canvas views, Explain the significance of OR REPLACE, FORCE
and NOFORCE while creating view.............
Apart from IN, OUT, IN OUT parameters, oracle 8i offers another
parameter called NOCOPY...............
A snapshot log is a copy of the master table. The snapshot table
is updated using batch updates, The log can also be used to track
the rows that have been updated in the master table.........
| 
