Re: Table contents gone after disconnect

  • From: Fuad Arshad <fuadar@xxxxxxxxx>
  • To: gamito@xxxxxxxxx, oracle-l@xxxxxxxxxxxxx
  • 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@xxxxxxxxx>
To: oracle-l@xxxxxxxxxxxxx
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

Other related posts: