<<Previous Next>>
Oracle - What
is an Oracle Recycle Bin? - April 10, 2009
at 11:00 AM
What is an Oracle Recycle
Bin?
- The tables that have been dropped can be retrieved back using
the reycle bin feature of Oracle.
- They can be recovered back by the Flashback Drop action.
- Recycle bin can be turned on or off in the recyclebin=on/off
from the parameter file. It can also be turned on or off for an
instance.
- With the SYSTEM privilege, the recycle bin feature can be
turned on or off on the running instance by using an SQL*Plus
command.
Also read
Internal exceptions are raised implicitly by the run-time system.
However, user-defined exceptions must be raised explicitly by RAISE
statements................
Import and Export utilities are helpful in following ways: They
can be used for backup and recovery process, they can also be used
while moving database between two different...............
A recent copy of a table or a subset of rows or cols of a table
is called as snapshot in oracle. A snapshot is more useful in
distributed computing environment. We can create..........
It is a database tool that allows data to be loaded from external
files into database tables, It is available as part of the free
Oracle 10g Expression Edition..........
Locking protect table when several users are accessing the same
table. Locking is a concurrency control technique in oracle. It
helps in data integrity while allowing maximum...........
|
