Re: Table contents gone after disconnect

From: Fuad Arshad <>
Date: Wed, 8 Oct 2008 19:36:48 -0700 (PDT)
Message-ID: <>

are you committing the contents
i.e issuing a commit after the inserts.

when you say exit is it by X'ing out or by typing the exit. if it is X'ing you might just be rolling back your transaction  

  • Original Message ---- From: Mário Gamito <> To: Sent: Wednesday, October 8, 2008 4:21:14 PM Subject: Table contents gone after disconnect


I've installed Oracle 10g in Windows and everything seems to be running smoothly.

Well, not quite. I've created a database and a table just for the sake of testing.
I can do INSERTs in the table alright and if I do SELECTs over it, it gives back what I've inserted before.

Now, if I disconnect the database and connect again, all the values I've inserted before are gone. The table is empty. It is as if nothing has been writen to the disk.

I've googled a while, but found no answer.

Any help would be appreciated.

Warm Regards,
Mário Gamito
-- Received on Wed Oct 08 2008 - 21:36:48 CDT

Original text of this message