hi, suppose i created one table after few days i did some insert,update how c

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

3 Answers
6958 Views
IBM, I also Faced
E-Mail Answers

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

Explain CREATE DATABASE syntax?

2 Answers

wat is global index and local indes

1 Answers Oracle,

How to make a replica of existing oracle server to another server?

3 Answers

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

0 Answers

How do you add a data file to a tablespace?

3 Answers

What is the difference between the SQL Loader and IMPORT utilities?

3 Answers

What command would you use to create a backup control file?

2 Answers

Can you redefine a table online?

0 Answers Oracle,

what is the difference between hot backup n rman backup?

1 Answers Value Labs,

how can you generate profile of pl/sql applications to identify performance bottlenecks?

0 Answers Oracle,

Which environment variables are absolutely critical in order to run the OUI?

2 Answers

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

1 Answers

For more DB Administration Interview Questions Click Here