Re: top 10 oracle quirks

I should have put ';)' on my post. Sorry. It was a joke............

Cheers,
Brian

Norman Dunbar wrote:
>
> 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"

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

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"