DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Information lost

  1. #1
    Join Date
    Oct 2004
    Posts
    8

    Information lost

    Hi,

    A couple of day ago I created three tables in my database. I used it the same day and retrieved some information from it.

    Today when I logged on all the inserts in my database was lost, but the tables was still there.

    Any idea what I did wrong?

    Mabye I needed to do some commits before logging out.

    Grateful for all help I can get.

    /Stefan

  2. #2
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,166
    Any number of things could have happened to your data, and whther or not you can find out what happened is dependent on whether you have auditing turned on for the right event, you can use log miner against your archive logs, assuming that you are in archivelog mode, or are able to conduct a Bogartequse style search for the strawberry ice cream.

    Did someone delete the data? Did you either delete the data or do a rollback? Did you use a program like Toad and do you have it doing implicit commits? I use SQL Navagator, if I insert rows into a table and then exit Sql Nav, it will tell me that I have uncommitted transactions. If I tell it not to commit the transactions it does a rollback.

    From reading your question, it sounds like the data wasn't that important. Perhaps you could just reenter the data.

  3. #3
    Join Date
    Sep 2003
    Location
    over the hill and through the woods
    Posts
    995

    Re: Information lost

    Mabye I needed to do some commits before logging out.
    Think you found the answer to your missing data.
    Oracle it's not just a database it's a lifestyle!
    --------------
    BTW....You need to get a girlfriend who's last name isn't .jpg

  4. #4
    Join Date
    Oct 2004
    Posts
    8
    It wasn't all that inportant, just a project for my comp. science class.

    I think I'll reenter my data and remember to commit it.

    Thanks for your help

Posting Permissions

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


Click Here to Expand Forum to Full Width