Re: Table contents gone after disconnect

From: Dan Norris <>
Date: Wed, 8 Oct 2008 19:29:32 -0500
Message-ID: <>

This is (must be) a global temporary table and its contents are only valid for your session (possibly only for your transaction). The table data is stored in temporary space and is deallocated when your session disconnects. Look for GLOBAL TEMPORARY TABLE in the docs and you'll find it.


On Wed, Oct 8, 2008 at 4:21 PM, Mário Gamito <> wrote:

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

Received on Wed Oct 08 2008 - 19:29:32 CDT

Original text of this message