hi,
suppose i created one table after few days i did some
insert,update how can i know when will i did ddl or dml
operation is undergone on that table
Answer Posted / naga bandaru
we should go with log minor or streams to find when DML
operation have been performed.
Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
what is the role of dip user in our database?
What is a system database and what is a user database? : sql server DBA
how can a session indicate its interest in receiving alerts?
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.
what are the differences of where and if in SAS?
what do you understand by flashback feature of oracle?
what is the use of recording information about current session?
Explain about your sql server dba experience? : sql server DBA
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
what is a user-defined lock?
What is the default fill factor value? : sql server DBA
What is dcl? : sql server DBA
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
Explain materialized views and how they are used.
What are the commands used in dcl? : sql server DBA