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
Answer Posted / 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 |
Post New Answer View All Answers
What is the difference between clustered and non-clustered index? : sql server DBA
How can you control the amount of free space in your index pages? : sql server DBA
how can you connect from 10g user to 11g user??
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
You create a private database link and upon
connection, fails with: ORA-2085: connects to
What purpose does the model database server? : sql server DBA
What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA
what is the use of ocr?
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.
What are the different types of database compression introduced in sql server 2008? : sql server DBA
What is the default fill factor value? : sql server DBA
I have A,B,C servers.i want to 3 servers jobs move to D server(target server)..how? note: i said that take the backup of msdb and restore to the target server..he said while restoring jobs replaced. what is the solution
What is transparent data encryption? : sql server DBA
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.
What the different topologies in which replication can be configured? : sql server DBA