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


Please Help Members By Posting Answers For Below Questions

what is the role of dip user in our database?

2051


What is a system database and what is a user database? : sql server DBA

600


how can a session indicate its interest in receiving alerts?

565


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.

1704


what are the differences of where and if in SAS?

1664






what do you understand by flashback feature of oracle?

560


what is the use of recording information about current session?

573


Explain about your sql server dba experience? : sql server DBA

549


What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?

1974


what is a user-defined lock?

590


What is the default fill factor value? : sql server DBA

574


What is dcl? : sql server DBA

650


Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?

2191


Explain materialized views and how they are used.

1896


What are the commands used in dcl? : sql server DBA

579