RE: Table contents gone after disconnect
Date: Wed, 8 Oct 2008 16:32:38 -0500
May be "commit"... check your sqlplus environment and make it autocommit to "on"
From: Mário Gamito [mailto:gamito_at_gmail.com] Sent: Wednesday, October 08, 2008 5:21 PM To: oracle-l_at_freelists.org
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
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.