Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: temp table
Hi Denis,
Sorry I don't think you can create a temporary table that Oracle drops automatically. I am curious as to why you want to create one and how you would use it.
Providing each of your users has their own Oracle login they can all run the same script at the same time without bombing out since each will get his/her own output table. Remember that I can access my table foo as SELECT * FROM foo while you will have to access SELECT * FROM jerry.foo (this assumes that I am user jerry and that I have granted you permission to access the table).
Regards
Jerry
Denis Langlais wrote:
>
> Does anyone know how to create temporary tables in Oracle
> which will be dropped automatically.
>
> create table abc as
> select * from table xyz
> tablespace TEMP_TB;
>
> Also, If many people are running the same script they won't
> bomb out because the table already exists?
> --
>
> ----
> You can email me: Denis Langlais using the following address
> langlais_at_ibm.net
--
Jerry Gitomer Since I know how to spell DBA I became one.
jgitomer_at_p3.net
Received on Mon Apr 13 1998 - 22:29:12 CDT