Re: Can I create temp table in Oracle.

I dont know guys but I try to create a table in a tablespace that is temporary I get the following.

ERROR at line 1:
ORA-02195: Attempt to create PERMANENT object in a TEMPORARY tablespace

When a tablespace is "temporary", Oracle does not protect that space against crashes the same way
it does for a regular tablespace.

Sylvain Leclerc, DBA
INT Systèmes d'information
Membre du Groupe Magrit
sleclerc_at_magrit.com

> -----Original Message-----
> From: Billy Verreynne [SMTP:vslabs_at_onwe.co.za]
> Posted At: Friday, October 30, 1998 2:05 AM
> Posted To: server
> Conversation: Can I create temp table in Oracle.
> Subject: Re: Can I create temp table in Oracle.
>
> cljones wrote in message <36392DFC.100B_at_concentric.net>...
> >Hey - yes you can -
> >
> >create tablespace tmp temporary
> >create table temp
> >tablespace tmp;
>
> Nice idea. You can go and create tables and even indexes in a
> temporary
> tablespace, but that is unfortunately nowhere near what a temp table
> is in
> SQL-Server (which functionality the original poster wanted to use in
> Oracle).
>
> I assume that the table will be deleted automatically when the
> instance is
> shutdown?
>
> regards,
> Billy
>
Received on Fri Oct 30 1998 - 07:59:29 CST