I want to reuse a piece of code inside a stored procedure.
This piece of code need to be invoked multiple times inside
the procedure based on some different conditions. How to
achieve this?
1. how do you delete duplicate rows in a table?
2. can you disable and enable primary key?
3. how do you move tables from one tablespace to another
tablespace?????
Other than making use of the statspack utility, what would
you check when you are monitoring or running a health check
on an Oracle 8i or 9i database?
135
I have kept recovery catalog on same target database and
taken backup of target DB to disk. deleted the target DB &
tried to restore and revoer DB using the backup on disk
but it is not possible, how do we restore & recover DB
214
I lost one datafile i dont have backup how can you recover that???
You have found corruption in a tablespace that contains
static tables that are part of a database that is in
NOARCHIVE log mode. How would you restore the tablespace
without losing new data in the other tablespaces?
597
You create a private database link <link name> and upon
connection, fails with: ORA-2085: <Link name> connects to
<fully qualified remote db name>. What is the problem? How
would you go about resolving this error?
205
Give the stages of instance startup to a usable state where
normal users may access it.
348
How does propagation differ between Advanced Replication and
Snapshot Replication (read-only)?