Re: Create of Temp tables

"Tony Andrews" <[email protected]> Tue, 8 Apr 2003 14:18:54
Newsgroups gmane.comp.db.oracle.devel
Message-ID <LYRIS-1796914-944047-2003.04.08-13.59.14--gcdod-oracle#[email protected]>
> I am using oracle 8.1.5 and when the below statement get executed, gives 
me a error

> create global temporary table tt_cty
(> 
c> ty varchar2(2),
c> ty_name varchar2(60)
)>  on commit preserve rows

> ORA-14451: unsupported feature with temporary table

According to Oracle Error maunal:

"Cause: An attempt was made to create an IOT, specify physical attributes, 
specify partition or parallel clause"

Did you do any of those things?
---
Change your mail options at http://p2p.wrox.com/manager.asp or 
to unsubscribe send a blank email to [email protected].