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

What's the benefit of "dbms_stats" over "analyze"?

1 Answers  

What types of replication are supported in sql server? : sql server DBA

0 Answers  

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

0 Answers  

Why does Oracle not permit the use of PCTUSED with indexes?

0 Answers  

What the different topologies in which replication can be configured? : sql server DBA

0 Answers  




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

0 Answers  

How would you best determine why your MVIEW couldn't FAST REFRESH?

0 Answers  

what do you understand by flashback feature of oracle?

0 Answers   Oracle,

what is the differnce between process and thread ?

1 Answers   IBM,

If we issue alter database begin backup. What happens to database?

2 Answers  

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  

Can you redefine a table online?

0 Answers   Oracle,

For more DB Administration Interview Questions Click Here
Categories