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
7240 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

What happens on checkpoint? : sql server DBA

0 Answers

Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.

0 Answers

List out some of the requirements to setup a sql server failover cluster.? : sql server DBA

0 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 do you open a cluster administrator? : sql server DBA

0 Answers

I want to export only structure of the table from oracle database. In that table to used the some partition. To export the table in general way then compilation error was occured i.e-EXP-00003: no storage definition found for segment(11, 2771). Please tell me the correct export command parameter to export the partitioned table. Thanks in Advance..........

1 Answers

What authentication modes does sql server support? : sql server DBA

0 Answers

What is replication? : sql server DBA

0 Answers

Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.

0 Answers

Explain the use of setting GLOBAL_NAMES equal to TRUE.

1 Answers

Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down? : sql server DBA

0 Answers

For more DB Administration Interview Questions Click Here