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
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.
How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?
How do you open a cluster administrator? : sql server DBA
What are the commands you'd issue to show the explain plan for "select * from dual"?
who owns the operating system files created by the utl_file package?
In what script is "snap$" created? In what script is the "scott/tiger" schema created?
what do you understand by fine-grained auditing?
what are the benefits of flashback feature?
what is a crs resource?
how can you record information about current session?
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
You create a private database link and upon
connection, fails with: ORA-2085: connects to
What happens on checkpoint? : sql server DBA
can u plz tell me what r the mandatory skills for getting job as a sql dba......plz send me all details thank you my id :k.mohann.mohan@gmail.com