Path: newssvr20.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!pd2nf1so.cg.shawcable.net!residential.shaw.ca!sjc70.webusenet.com!news.webusenet.com!cyclone.bc.net!newsfeed.stanford.edu!postnews1.google.com!not-for-mail From: vslabs@onwe.co.za (Billy Verreynne) Newsgroups: comp.databases.oracle.misc Subject: Re: top 10 oracle quirks Date: 8 Aug 2003 04:03:42 -0700 Organization: http://groups.google.com/ Lines: 73 Message-ID: <1a75df45.0308080303.188d7bf6@posting.google.com> References: <5370feb0.0308051514.63612234@posting.google.com> <91884734.0308061545.71a92cfa@posting.google.com> <3F324F15.B06C7F0A@remove_spam.peasland.com> NNTP-Posting-Host: 198.54.206.91 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Trace: posting.google.com 1060340623 25991 127.0.0.1 (8 Aug 2003 11:03:43 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: 8 Aug 2003 11:03:43 GMT Xref: newssvr20.news.prodigy.com comp.databases.oracle.misc:130364 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]