1. Categories >> Software >> Databases >> DB Administration
  2. Suggest New Category

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

Question Posted / venubabu polineni

Answers were Sorted based on User's Feedback



hi, suppose i created one table after few days i did some insert,update how can i know when will ..

Answer / prashe

select OWNER,OBJECT_NAME,CREATED,LAST_DDL_TIME,from
dba_objects where OBJECT_NAME='&object_name';
for DDL command.

Is This Answer Correct ?    2 Yes 0 No

hi, suppose i created one table after few days i did some insert,update how can i know when will ..

Answer / 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

hi, suppose i created one table after few days i did some insert,update how can i know when will ..

Answer / gogune suresh kumar

For DDL operations query user_objects table.
For DML you need to create a trigger for that.

Is This Answer Correct ?    1 Yes 3 No

Post New Answer

More DB Administration Interview Questions

How do you trace the traffic hitting a sql server? : sql server DBA

0 Answers  

what is the difference between hot backup n rman backup?

1 Answers   Value Labs,

what is logical system in sap basis

0 Answers  

What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA

0 Answers  

what is the purpose of catlaog in oracle rman?

2 Answers   Value Labs,




Oracle client is not able to connect to Oracle server although tnsnames.ora file has valid enteries. Oracle error message is “ cannot resolve net service name”. Mention any three reasons.

0 Answers  

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

0 Answers   Oracle,

What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA

0 Answers  

When a user process fails, what background process cleans up after it?

1 Answers  

What is replication? : sql server DBA

0 Answers  

How would you go about increasing the buffer cache hit ratio?

2 Answers  

What type of index should you use on a fact table?

1 Answers  

For more DB Administration Interview Questions Click Here
Categories