Find out the history of SQL queries
An update SQL query was executed on the server, which caused many problems later. How can I get the list of update queries executed in last 2 months, so that I can trace the exact problematic SQL query?
database-administration
how to drop partition without dropping data in MySQL?
I have a table like: Not exactly like above but similar to that…. Now assume that my table has 200000 rows and now I want to remove partitions on the table and reorganize them in accordance to requirement without MAX VALUE in it. Can any one help me to rearrange partition without dropping data or …
Error ORA-00054 resource busy and acquire with NOWAIT specified or timeout expired in oracle11g
Try to execute this first ,and check whether anyone from other session or your session put a lock on that table .If you have put a lock on that table,try to do commit/rollback .If someone else put a lock ,ask him/her or if you have rights kill his session .And then drop the table.
