Results 1 to 4 of 4
  1. #1
    Join Date
    Jan 2004
    Posts
    12

    Unanswered: Best practice for Live Database Maintenance

    Hi,
    I am working on a project in Oracle 10g/Java-JSP combination. Very frequently we need to execute DML statements directly from SQL prompt as the system is quite buggy and we have to update/delete data in order to run the system. Although we are trying to streamline the application but it will take some time. Meanwhile I need to control direct data updation acitivity as much as possible.

    Is there any best practice guide available in the net ?

    Or else can any experienced folk guide me in this regard ?


    Thanks in advance.
    kaushik mitra

  2. #2
    Join Date
    Nov 2007
    Location
    Connecticut
    Posts
    40
    Put the delete/update activity in stored procs to avoid ad-hoc code that may delete something you need
    Code:
    select * from client where clue > 0;
    0 rows returned

  3. #3
    Join Date
    Jan 2004
    Posts
    12
    Thanks,
    This is exactly what is done in application code(most of DMLs are placed in procedures). But in some cases we have to pass direct DML statement from SQL to rectify some data problem. I want to implement a best practice to be followed at the time of this ad-hoc DML statement execution.
    kaushik mitra

  4. #4
    Join Date
    Nov 2007
    Location
    Connecticut
    Posts
    40
    That's a difficult call to make --- but I would ensure that only a few people are responsible for the ad-hoc work so the env is controlled a bit --

    You could consider using the flashback query functionality for the keytables that you delete/update from -- In this way , you can snap back in-time for faulty/mistaken delete/updates and rectify without having to restore your database from a backup (hot/cold/exp)
    Code:
    select * from client where clue > 0;
    0 rows returned

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •