Re: Table contents gone after disconnect
Date: Wed, 8 Oct 2008 19:36:48 -0700 (PDT)
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 <gamito_at_gmail.com> To: oracle-l_at_freelists.org 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
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.