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
how can you initialize log miner?
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.
You're getting high "busy buffer waits" - how can you find what's causing it?
How do you open a cluster administrator? : sql server DBA
What purpose does the model database server? : sql server DBA
. 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?
What column differentiates the V$ views to the GV$ views and how?
how can a session indicate its interest in receiving alerts?
how can you process messages in order asynchronously?
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
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.
How would you extract DDL of a table without using a GUI tool?