Path: newssvr20.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!in.100proofnews.com!in.100proofnews.com!cyclone.bc.net!newsfeed.stanford.edu!postnews1.google.com!not-for-mail From: joel-garry@home.com (Joel Garry) Newsgroups: comp.databases.oracle.misc Subject: Re: top 10 oracle quirks Date: 8 Aug 2003 13:21:39 -0700 Organization: http://groups.google.com/ Lines: 85 Message-ID: <91884734.0308081221.1fe8bd9d@posting.google.com> References: <5370feb0.0308051514.63612234@posting.google.com> <91884734.0308061545.71a92cfa@posting.google.com> <3F324F15.B06C7F0A@remove_spam.peasland.com> <1a75df45.0308080303.188d7bf6@posting.google.com> NNTP-Posting-Host: 67.116.125.178 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Trace: posting.google.com 1060374100 18022 127.0.0.1 (8 Aug 2003 20:21:40 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: 8 Aug 2003 20:21:40 GMT Xref: newssvr20.news.prodigy.com comp.databases.oracle.misc:130387 vslabs@onwe.co.za (Billy Verreynne) wrote in message news:<1a75df45.0308080303.188d7bf6@posting.google.com>... > Norman Dunbar wrote in message : > > > no need to put dual into a read only tablespace under 9i, you can't > > write to it anymore ! > > What!? HUH! DAMMIT!!! > > SQL> select object_type, owner from dba_objects where object_name = 'DUAL'; > > OBJECT_TYPE OWNER > ------------------ ------------------------------ > TABLE SYS > SYNONYM PUBLIC > > SQL> drop public synonym dual; > > Synonym dropped. > > SQL> create table xdual as select * from dual > > Table created. > > SQL> create public synonym dual for xdual; > > Synonym created. > SQL> insert into xdual values ( 'Y' ); > > 1 row created. > > SQL> commit; > > Commit complete. > > SQL> select sysdate from dual; > > SYSDATE > --------- > 08-AUG-03 > > > hmm..... darnit! > > [changed connection from SYS to a normal db user...] > SQL> select sysdate from dual; > > SYSDATE > --------- > 08-AUG-03 > 08-AUG-03 > > > ah.... [satisfied grin] > > > [few minutes later on the phone] > > me : "Yes, the dual table always give problems when you > use SELECT in uppercase, dual in lowercase, in an > Oracle schema called PROD when connecting via MS-Access. > It is Microsoft thing." > ... > "Er yes.. I can possibly implement a work around.. but > that will require some overtime and some serious wizzardy.. > but I'm sure I can pull it off." > ... > "Good. I will start on it right away. By the way, I'm busy > putting a mail together about my contract extension and > hourly rate increase. Can you have an urgent look at that?" > ... > "Great!" >-- >[just a normal day in the life of an Oracle DBA From Hell] Billy, you are now officially an Oracle demigod, I mean, Oracle demon, I mean daemon, uh, whatever, LOL! Simple, to the point, relevant code small enough to put in an old-fashioned .sig, truly a classic post. Drinking all that coffee made from water delivered through lead pipes has really paid off! :-) jg -- @home.com is bogus. http://www.signonsandiego.com/news/uniontrib/fri/business/news_1b8prgn.html