top 10 oracle quirks

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Thu, 7 Aug 2003 14:43:23 +0100
Message-ID: <E2F6A70FE45242488C865C3BC1245DA7040B4DF2@lnewton.leeds.lfs.co.uk>

Hi Brian,

no need to put dual into a read only tablespace under 9i, you can't write to it anymore !

SELECT * FROM dual

DUMMY

X
1 row selected

INSERT INTO dual VALUES 'Y'
ORA-03001: unimplemented feature

SELECT * FROM dual
DUMMY

X
1 row selected

Cheers,
Norm.

Norman Dunbar
Database/Unix administrator
Lynx Financial Systems Ltd.
mailto:Norman.Dunbar_at_LFS.co.uk

Tel: 0113 289 6265
Fax: 0113 289 3146
URL: http://www.Lynx-FS.com
-------------------------------------

-----Original Message-----
From: news_at_igsrsparc2.er.usgs.gov (Janet Walz (GD) x6739) [mailto:news_at_igsrsparc2.er.usgs.gov]On Behalf Of Brian Peasland Posted At: Thursday, August 07, 2003 2:08 PM Posted To: misc
Conversation: top 10 oracle quirks
Subject: Re: top 10 oracle quirks

> Dual. Particularly inserting into it.

I'm going to start a movement to put DUAL into its own tablespace and make it READ ONLY!!!

Cheers,
Brian

-- 
===================================================================

Brian Peasland
dba_at_remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
 the three"

Received on Thu Aug 07 2003 - 08:43:23 CDT