Re: Create of Temp tables

Hi,

U may need to upgrade to 8.1.6 or higer version.



Veerabhadra Rao
Oracle DBA (OCP 8,8i&9i)
(404)202 1245(Mobile)
(770)814 0626(Home)





>From: "Lakshmi Murthy" <[email protected]>
>Reply-To: "Oracle" <[email protected]>
>To: "Oracle" <[email protected]>
>Subject: [oracle] Create of Temp tables
>Date: Mon, 7 Apr 2003 15:33:26
>
>Hi,
>
>I am using oracle 8.1.5 and when the below statement get executed, gives
>me a error
>
>create global temporary table tt_cty
>(
>cty varchar2(2),
>cty_name varchar2(60)
>) on commit preserve rows
>
>ORA-14451: unsupported feature with temporary table
>
>Not sure what my next step is.
>
>Help me out.
>
>LN
>---
>Change your mail options at http://p2p.wrox.com/manager.asp or
>to unsubscribe send a blank email to %%email.unsub%%.

_________________________________________________________________
STOP MORE SPAM with the new MSN 8 and get 2 months FREE*  
http://join.msn.com/?page=features/junkmail


---
Change your mail options at http://p2p.wrox.com/manager.asp or 
to unsubscribe send a blank email to [email protected].