Skip to content
Read For Learn
Read For Learn
  • Database
    • Oracle
    • SQL
  • Programming
    • C
    • C++
    • Java
  • Web Development
    • Java Script
    • jQuery
    • PHP
Read For Learn
  • Database
    • Oracle
    • SQL
  • Programming
    • C
    • C++
    • Java
  • Web Development
    • Java Script
    • jQuery
    • PHP

database-administration

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?

Categories Oracle Tags database-administration, oracle, sql-update

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 …

Read more

Categories SQL Tags database, database-administration, database-partitioning, mysql, sql

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.

Categories oracle sqldeveloper Tags database-administration, oracle-sqldeveloper, oracle11g

Recommended Hostings

Cloudways: Realize Your Website's Potential With Flexible & Affordable Hosting. 24/7/365 Support, Managed Security, Automated Backups, and 24/7 Real-time Monitoring.

FastComet: Fast SSD Hosting, Free Migration, Hack-Free Security, 24/7 Super Fast Support, 45 Day Money Back Guarantee.

Recent Added Topics

  • Passing nonce at admin menu link
  • add code in functions.php will slow down the Execution speed?
  • How can i insert term in a specific language of Polylang?
  • Allow Contributor to edit published post and filter by page id
  • Custom Rest API POST endpoint with conditionally required parameters
  • add element with add_action to posts from a specific category ID
  • PHP Warning: Attempt to read property “term_id” on bool
  • Is there a way to migrate via wordpress dashboard?
  • Remove Body Classes
  • Is there a JavaScript equivalent of get_post_field?
© 2022 Read For Learn
  • Programming
    • C
    • C++
    • Java
    • javascript
    • Python
    • R
  • Web Development
    • Java Script
    • jQuery
    • PHP
    • WordPress
  • Database
    • Oracle
    • SQL
  • algorithm
  • asp.net
  • assembly
  • binary
  • c#
  • Git
  • hex
  • HTML
  • iOS
  • language angnostic
  • math
  • matlab
  • Microsoft Office
  • modx
  • root
  • Tips & Trick
  • Tools
  • windows