Re: Creating Temporary Tables in Oracle

Jerry Gitomer (jgitomer_at_ictgroup.com) wrote:
: 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.

Sure? The same user in another session will be able to see the table once it is created because create table is a DDL command and Oracle (7 at least) implicitly commits the current transaction before and after every DDL statement. It is data inserted into the table that will not be visible until a commit.

: 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 - 08:43:49 CST