Re: Create of Temp tables
"Robert Rainville" <[email protected]> Wed, 9 Apr 2003 13:36:00 -0400
| Newsgroups | gmane.comp.db.oracle.devel |
|---|---|
| Message-ID | <LYRIS-1796914-946152-2003.04.09-18.32.27--gcdod-oracle#[email protected]> |
Try specifying storage But this does Work on Oracle 9i -----Original Message----- From: Tony Andrews [mailto:[email protected]]=20 Sent: Tuesday, April 08, 2003 10:19 AM To: Oracle Subject: [oracle] Re: Create of Temp tables > I am using oracle 8.1.5 and when the below statement get executed, gives=20 me a error > create global temporary table tt_cty (>=20 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,=20 specify partition or parallel clause" Did you do any of those things? --- Change your mail options at http://p2p.wrox.com/manager.asp or=20 to unsubscribe send a blank email to %%email.unsub%%. --- Change your mail options at http://p2p.wrox.com/manager.asp or to unsubscribe send a blank email to [email protected].