Re: Temp Tables

Think of Oracle "temporary tablespaces" as SQLServer tempdb.

As stated elsewhere in the thread there isn't an equivalent in Oracle to the #tablename in SQLServer.

There was a long-running thread a few months back on this very topic.

SteveM
  "John Becker" <jbecker2_at_ix.netcom.com> wrote:
> Sorry up front for this question, if it appears stupid, but...
>
> I have a lot of experience with SQL Server, but am just starting with
> Oracle. In SQL Server, you can designate a table as temporary by prefacing
> the table name with a:
> # - meaning table's life span's the active connection, and is visible
> only to the active connection,
> - or -
> ## - meaning table's life span's the active connection, and is visible to
> all other active connections
>
> Is there anything similiar in Oracle? I have seen the the temporary
> tablespace designator, but it seems as though management of any objects
> created within is up to the user.
>
> Thanks in Advance,
> John
>
>

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Fri Jan 22 1999 - 03:36:23 CST