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

Which types of backups you can take in Oracle? 2. A database is running in NOARCHIVELOG mode then which type of backups you can take? 3. Can you take partial backups if the Database is running in NOARCHIVELOG mode?

1 Answers

what are the benefits of flashback feature?

0 Answers Oracle,

what do you understand by flashback feature of oracle?

0 Answers Oracle,

What is the difference between clustered and non-clustered index? : sql server DBA

0 Answers

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

0 Answers Oracle,

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

0 Answers

From the database level, how can you tell under which time zone a database is operating?

1 Answers

Can we take incremental backups in datapump?

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

how can you process messages in order asynchronously?

0 Answers Oracle,

how can you schedule a job in database?

0 Answers Oracle,

I lost one datafile i dont have backup how can you recover that???

2 Answers HP,

For more DB Administration Interview Questions Click Here