Re: Table contents gone after disconnect

Did you commit at the end?

Joe

• Original Message ----- From: "Mário Gamito" [gamito_at_gmail.com] Sent: 10/08/2008 10:21 PM CET To: oracle-l_at_freelists.org Subject: Table contents gone after disconnect

Hi,

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
--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Wed Oct 08 2008 - 16:28:18 CDT