how can you get actual data change values from previous transactions in oracle?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More DB Administration Interview Questions

how can you initialize log miner?

0 Answers   Oracle,


when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.

0 Answers  


You're getting high "busy buffer waits" - how can you find what's causing it?

1 Answers  


How do you open a cluster administrator? : sql server DBA

0 Answers  


What purpose does the model database server? : sql server DBA

0 Answers  






. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?

0 Answers  


What column differentiates the V$ views to the GV$ views and how?

3 Answers  


how can a session indicate its interest in receiving alerts?

0 Answers   Oracle,


how can you process messages in order asynchronously?

0 Answers   Oracle,


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

0 Answers  


Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.

0 Answers  


How would you extract DDL of a table without using a GUI tool?

0 Answers  


Categories