RE: Table contents gone after disconnect

From: Channa, Santhosh <>
Date: Wed, 8 Oct 2008 16:32:38 -0500
Message-ID: <>

May be "commit"... check your sqlplus environment and make it autocommit to "on"

Santhosh Channa

-----Original Message-----

From: Mário Gamito [] Sent: Wednesday, October 08, 2008 5:21 PM To:
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 - 16:32:38 CDT

Original text of this message