Re: Global Temp Table (PRESERVE ROWS) truncating unexpectedly

From: Frank van Bortel <frank.van.bortel_at_gmail.com>
Date: Sun, 23 Sep 2007 12:47:14 +0200
Message-ID: <fd5g7i$3lv$1@news6.zwoll1.ov.home.nl>

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

pmmgpgp_at_gmail.com wrote:
> I love "GLOBAL TEMPORARY TABLEs" (GTT). I
> have been using them for awhile, and find
> them to be a great tool.
>
> We are rac'ed but I am logging into one specific
> instance.
>
> My IDE is pl/sql developer version 7.1.2 and is configured for
> "Dual Sessions".
>
> I am working on a new package that utilizes
> three GTTs and all are declared to "PRESERVE ROWS".
>
> CREATE GLOBAL TEMPORARY TABLE my_temp_table (
> column1 NUMBER,
> column2 NUMBER
> ) ON COMMIT PRESERVE ROWS
>

You can preserve anything you like, but upon disconnection, your data is gone.

Try simple, plain SQL*Plus - we all have that whenever someone wants to rebuild your case.
Right now, I fail so see any 'insert into CR_ONYX_SHAPSHOT'. - --
Regards,
Frank van Bortel

Top-posting is one way to shut me up...
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (MingW32)

iD8DBQFG9kQyLw8L4IAs830RAn6UAJ9pxXF9YA9rKxIm2nSD9YjZoGDSggCfdDSk NE0wFBCE2R+gM2lpmIThA2Y=
=fpbn
-----END PGP SIGNATURE----- Received on Sun Sep 23 2007 - 05:47:14 CDT