Re: tempory tables dropped automatically when user logs out

Hi,
 if you're using Oracle 8i there's native support for temporary tables. To create a temporary table:
CREATE GLOBAL TEMPORARY TABLE <table_name> <normal table definition>
ON COMMIT [DELETE|PRESERVE] ROWS. "Corto Maltese" <corto_at_castel.nl> ha scritto nel messaggio news:8ptan8$pvr$1_at_nnrp1.deja.com...
> Hi,
>
> Is there a possibility to drop the earlier created tables from the
> users when they log out?
> I want to create tables with Forms or ReporWriter reports to simplify
> the selection of data, if possible the tables should be released
> automatically when the report or form is closed or ready.
> This to still have the advantage to use tables with complicated
> selections (make it faster and easier). I need the tables dropped to
> avoid pollution of the tablespace. Additionally: the users are
> (initially) not able (rights) to create tables, this should be solved
> also.
>
> I was thinking if there was a possibility to give the users permission
> to create tables on a temp tablespace in combination of something that
> ensures you the tables are dropped (of that specific user or connection
> and not the one's of his colleagues) when the form or report is ready
> or exited.
>
> Best regards and have a nice weekend.
>
> CM.
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Wed Sep 20 2000 - 00:00:00 CEST