Re: Creating Temporary Tables in Oracle

Hi,

    When you create a table in an Oracle session it is not visible to any other user, including other sessions for the same user, until a commit is done. If you can avoid doing an implicit commit until you are ready to drop the table (and of course don't do an explicit commit) you will not have a problem.

If a commit is done there is no way of preventing anyone logged in with the same username from finding out the name of the table and, once they know the name, insert, delete, update, or even drop the table as well as select ing from it.

Picture the following scenario. You create a table giving it an esoteric name unknown to your co-workers. Joe the practical joker logs in using the same username and does a:

    SELECT TABLE_NAME FROM USER_TABLES; Joe sees a strange new table and goes exploring ....

regards

Jerry

sumanm_at_my-dejanews.com wrote in message <7188li$ogo$1_at_nnrp1.dejanews.com>...
>How can I create temporary tables in Oracle ?
>I know that SQL Server supports temporary tables.
>Basically, I need to create a temporary table containing
>a subset of the data from another table. Then I want
>to update some rows in that temporary table,
>use it and later drop it.
>
>I don't want anyone else who has logged on using the
>same userid/pwd to see my temporary table.
>
>How do I achieve that ?
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Thu Oct 29 1998 - 07:08:06 CST