RE: Oracle Version on Unix
E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists -------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shaw John-P55297 INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: methodology to keep only certain programs to connect to
use v_$mystat - it has the sid - then do your join with v$session -Original Message-From: JOE TESTA [mailto:[EMAIL PROTECTED]]Sent: Tuesday, September 10, 2002 10:58 AMTo: Multiple recipients of list ORACLE-LSubject: methodology to keep only certain programs to connect to I've been tasked to ensure only certain app programs access the database. I'm thinking on-logon trigger, check the program field from v$session. unfortunately v$session is for all sessions, i can't seem to find the view that tells me only MY info during login. I only want the sid, serial#, username and program for my just now connection to the database. Does this exist or am I going about this the wrong way? We're thinking of checking those fields to make sure sql*plus, toad, etc can't connect as a particular user(even though the password is known out in the community). any ideas would be greatly appreciated. joe
RE: Oracle Parner Network
We are OPN members - we have one database for our internal use and pay full price for it and support. In addition we have a bunch of purely development databases - on differing platforms (linux, solaris) that we download and use for no additional fee's. -Original Message- Sent: Friday, August 30, 2002 7:04 AM To: Multiple recipients of list ORACLE-L Hey all, While reviewing our annual maintenance agreement ($5,000) and considering an additional $30K license purchase, our savvy network admin suggested we look into Oracle's Partner Network. After some research, phone conversations, and pouring through the license agreement with a fine-tooth comb, I realized that's it's a win-win for us. Instead of spending $35,000 on renewals and new license purchases, we spend $2,000 to join OPN as a member associate and then pay $39.20 per seat for dev support (equivalent to our current Silver level) on the db suite. Yes, the catch is you have to be using Oracle solely for dev (and not for internally deployed apps that run your business) but it has turned out to be a no-brainer moneywise. Curious if anyone else out there has had experience with this . . . not that I'm sceptical or anything, but we tried to find a catch and couldn't! thanks bill -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Magaliff, Bill INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shaw John-P55297 INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: working with datafile > 2Gb in HadHat 7.3
It was a bug on windows - with auto extend on and crossing 4Gb filesize. -Original Message- Sent: Friday, August 30, 2002 6:58 AM To: Multiple recipients of list ORACLE-L I read something about Oracle on Windows not being able to extend past the 2G limit, but haven't verified. I believe it has to do with Oracle on Windows, not windows or hardware. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin & Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] -Original Message- Sent: Thursday, August 29, 2002 5:34 PM To: Multiple recipients of list ORACLE-L Subject:RE: working with datafile > 2Gb in HadHat 7.3 Ltiu, >>Intel hardware can only handle 2Gb files sizes max. Are you sure? I don't think that's true. -Original Message- Sent: Thursday, August 29, 2002 2:44 PM To: Multiple recipients of list ORACLE-L It doesn't really matter what OS you have. Intel hardware can only handle 2Gb files sizes max. Even if the hardware can support large files, it is still recommended that you do not have large datafiles. You need to partition your tablespaces into multiple datafiles. This facilitates backups and restores and you can put the datafiles into different hard drives increasing i/o performance. ltiu Adriano Freire wrote: >Ok ltiu, >REDHAT 7.3 kernel-2.4.18-10 > >- Original Message - >To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> >Sent: Thursday, August 29, 2002 1:18 PM > > > > >>What's HadHat 7.3? >> >>A new Linux distro pattered after RedHat 7.3? >> >>ltiu >> >>Adriano Freire wrote: >> >> >> >>>Gurus, >>> >>>I've some problems with datafiles > 2Gb in HadHat 7.3. I'm using >>>datafile type ext3 and >>>when i try create a datafile with 2Gb the database is catching. >>>Anybody have the some problem? >>>any suggestion? >>> >>>Thanks >>> >>>Adriano. >>> >>> >> >> >>-- >>Please see the official ORACLE-L FAQ: http://www.orafaq.com >>-- >>Author: ltiu >> INET: [EMAIL PROTECTED] >> >>Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 >>San Diego, California-- Public Internet access / Mailing Lists >> >>To REMOVE yourself from this mailing list, send an E-Mail message >>to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >>the message BODY, include a line containing: UNSUB ORACLE-L >>(or the name of mailing list you want to be removed from). You may >>also send the HELP command for other information (like subscribing). >> >> > > > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seefelt, Beth INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists -------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the mess
Another Transferring data from one table to another fast Q
Title: RE: Transferring data from one table to another How about if your table has (I didn't do it) a LONG column. CTAS doesn't work and I don't see the nologging option for the ccopy command - in 8.1.6 anyway. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]Sent: Monday, August 12, 2002 11:24 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Transferring data from one table to another CTAS with nologging. Could create a simple script to do this. -Original Message- From: Peter R [mailto:[EMAIL PROTECTED]] Sent: Monday, August 12, 2002 11:18 AM To: Multiple recipients of list ORACLE-L Subject: RE: Transferring data from one table to another Iam planning to copy 18-40Million rows thru CTAS!! My question is which one is efficient, CTAS or using cursor in pl/sql Procedure!! thanks peter. >From: Abdul Aleem <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: RE: Transferring data from one table to another >Date: Sun, 11 Aug 2002 23:23:19 -0800 > >Thank you, Amjad, >The problem is that then I have to write a procedure for each of the >tables. >I was looking for something that could be set at database level and would >apply to every table. > >Aleem > > -Original Message- >Sent: Monday, August 12, 2002 10:43 AM >To: Multiple recipients of list ORACLE-L >Subject: RE: Transferring data from one table to another > >well if u wanna commit after 1000 records u could very well use a cursor >and within the loop keep a counter which will indicate the no. of records >inserted...upon reaching 1000 records just commit and reinitialize the >counter.. > >i have written the "Pseudo" code below: > >declare > cursor c1 is > SELECT * from schema2.abc; >cntr number := 0; >begin > for c1_abc in c1 loop > insert into schema1.abc values contained in c1_abc; > cntr := cntr +1; > if (cntr = 1000) then > cntr := 0; > commit; > end if; > end loop; >/* the following commit is 4 last set of records that might not b >commited*/ >commit; >end; > >rgds, >Ams. >www.medicomsoft.com > > > >-Original Message- >Sent: Monday, August 12, 2002 8:23 AM >To: Multiple recipients of list ORACLE-L > > >Hi, > >We are transferring data from one table in a schema to another table in >another schema with identical fields using >INSERT INTO schema1.abc (SELECT * from schema2.abc) >The source table has 1.6 million records. The tablespace increases to >consume full disk space and yet seems to be demanding more so the operation >doesn't complete. > >Is there a possibility to process commit after every 1,000 records? >Is there any other way of doing it? > >TIA! > >Aleem >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Abdul Aleem > INET: [EMAIL PROTECTED] > >Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 >San Diego, California -- Public Internet access / Mailing Lists > >To REMOVE yourself from this mailing list, send an E-Mail message >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >the message BODY, include a line containing: UNSUB ORACLE-L >(or the name of mailing list you want to be removed from). You may >also send the HELP command for other information (like subscribing). > > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Amjad Saiyed > INET: [EMAIL PROTECTED] > >Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 >San Diego, California -- Public Internet access / Mailing Lists > >To REMOVE yourself from this mailing list, send an E-Mail message >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >the message BODY, include a line containing: UNSUB ORACLE-L >(or the name of mailing list you want to be removed from). You may >also send the HELP command for other information (like subscribing). >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Abdul Aleem > INET: [EMAIL PROTECTED] > >Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 >San Diego, California -- Public Internet access / Mailing Lists > >To REMOVE yourself from this mailing list, send an E-Mail message >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >the message BODY, include a line containing: UNSUB ORACLE-L >(or the name of mailing
RE: Foxbase to Oracle
Visual FoxPro has an upsize wizard that can go directly to Oracle. It would still be a lot cheaper to keep it in FoxPro over the cost of Oracle. -Original Message- Sent: Tuesday, July 30, 2002 12:45 PM To: Multiple recipients of list ORACLE-L Dennis: Foxbase was originally called 10-base before Fox Systems change the name. Foxbase was changed to FoxPro and then purchased by Microsoft and called Microsoft FoxPro, and then Microsoft Visual FoxPro. I would highly recommend investigating the MSFT solution. Sorry guys, but this is a realistic solution. Oracle, for eight users, will probably cost too much for the implementation. If you need to convert to Oracle, do the following: 1. Convert to FoxPro 2. Bridge Visual FoxPro to SQLServer and use the Data Transformation Services (DTS) to migrate the data to Oracle. Thank You Stephen P. Karniotis Product Architect Compuware Corporation Direct: (248) 865-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web:www.compuware.com -Original Message- Sent: Tuesday, July 30, 2002 12:09 PM To: Multiple recipients of list ORACLE-L Subject:Foxbase to Oracle Hi All - We have a small application that was written in Foxbase under DOS. While it runs fairly well most of the time, the management wants to migrate it to a windows-based application. We are open to any mainstream application and database solutions at this point, although our budget is very tight and this application has only about 8 users max. My question is - does Oracle provide a good tool for migration from Foxbase? This is a small application and have only about a dozen tables, my main challenge would be the application code. If Oracle turns out to be too expensive, what is the least expensive, least painful migration path? Another attractive option seems to be Visual FoxPro, which I know little about. I want to bounce it off the list first before we make the choice. TIA Dennis Meng Database Administrator Focal Communications Corp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). The contents of this e-mail are intended for the named addressee only. It contains information that may be confidential. Unless you are the named addressee or an authorized designee, you may not copy or use it, or disclose it to anyone else. If you received it in error please notify us immediately and then destroy it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Karniotis, Stephen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shaw John-P55297 INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
dblink / global names explanation please
8.1.6 on NT I have java installed and a java email package on instance A on a server. One the same server on instance B with global names set to false I created a public database link to instance A, then created a public synonym javamail for my email routine at A. This worked. On a third instance ( C ) on this same server with gobal names set to true (do you see where this is going) I did the same thing as I had done on instance B - but I couldn't use a short name - I had to use the full A.moto.com. Then I created a public synonym for the [EMAIL PROTECTED] This kept returning an error - couldn't find class com/moto/utils/mail - this is a home grown java class in the database A. I could not find anything different between the two setups other than one had global names set to false and the other had global names set to true (after many hours of looking and head banging) - so I just tried setting global names to false on instance C and bounced the database - went back and created a new short named public database link and then created the public synonym. It now worked ? WHY ?? can any one tell why this works or doesn't as the case may be? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shaw John-P55297 INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Forms Question
It is in forms 5 and 6 -Original Message- Sent: Thursday, June 27, 2002 9:19 AM To: Multiple recipients of list ORACLE-L Is it possible to order by a non-base table item in a form? Michael Cupp, Jr. Shonac Corporation 4150 East Fifth Avenue Columbus Ohio 43219 Phone: 614-238-4240 Fax: 614-238-4203 e-mail: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Michael Cupp INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shaw John-P55297 INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: database 9iR2 and client-server with Forms 6i / RE: (Fwd) Re:
you only need 9ias if you are running webforms and then you only need 9ias if you are running in servlet mode. I found that Client server works fine. THere were problems with our package specifications, but once I corrected them it seemed to work. -Original Message- Sent: Monday, June 24, 2002 11:34 AM To: Multiple recipients of list ORACLE-L My understanding is that the "developer" mode is still client-server, but to do the deployment (more or less "runtime"?), you have to also have 9iAS set up and running. Can you execute a form in client-server mode in the same manner as a user would (in other words, not in "developer" mode)? Thanks, Eric On 24 Jun 2002 at 6:08, Shaw John-P55297 wrote: Date sent: Mon, 24 Jun 2002 06:08:28 -0800 To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > 9iR2 enterprise from the otn download Forms 6i 6.0.8.10.3 on W2K Dell > > -Original Message- > Sent: Friday, June 21, 2002 12:07 PM > To: Multiple recipients of list ORACLE-L > > > in pure client-server mode? > > if so: > > "quick, someone tell oracle tech support" !!! :) > > what versions of the database? "personal", "standard", "enterprise", etc??? > > > On 21 Jun 2002 at 5:23, Shaw John-P55297 wrote: > > Date sent:Fri, 21 Jun 2002 05:23:20 -0800 > To: Multiple recipients of list ORACLE-L > <[EMAIL PROTECTED]> > Send reply to:[EMAIL PROTECTED] > > > I have 9iR2 and forms 6i on my pc and its running ok so far. > > > > -Original Message- > > Sent: Friday, June 21, 2002 5:08 AM > > To: Multiple recipients of list ORACLE-L > > > > > > > > --- Forwarded message follows --- > > ... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eric D. Pierce INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shaw John-P55297 INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: (Fwd) Re: Upgrading from Forms 5, Oracle 7
9iR2 enterprise from the otn download Forms 6i 6.0.8.10.3 on W2K Dell -Original Message- Sent: Friday, June 21, 2002 12:07 PM To: Multiple recipients of list ORACLE-L in pure client-server mode? if so: "quick, someone tell oracle tech support" !!! :) what versions of the database? "personal", "standard", "enterprise", etc??? On 21 Jun 2002 at 5:23, Shaw John-P55297 wrote: Date sent: Fri, 21 Jun 2002 05:23:20 -0800 To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Send reply to: [EMAIL PROTECTED] > I have 9iR2 and forms 6i on my pc and its running ok so far. > > -Original Message- > Sent: Friday, June 21, 2002 5:08 AM > To: Multiple recipients of list ORACLE-L > > > > --- Forwarded message follows --- > ... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eric D. Pierce INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shaw John-P55297 INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: (Fwd) Re: Upgrading from Forms 5, Oracle 7
tice is generated. Customers may also view this file via MetaLink under | "Product Lifecycle" ==> "Certifications" ==> "1. View Certifications by | Product" ==> "Desupport Advisories and Notices" ==> | | "Upcoming Oracle Product Desupports" or by searching for Doc ID: 190435.1. | | Product & Product Version(s) Platform(s): *Oracle Server 9.2.0.1 | & Platform Version(s): ALL Platforms | End of ECS Date : 30-SEP-2005 | End of EAS Date : 30-SEP-2008 | End of EMS Date : 30-SEP-2007 | | Migration Path Notes : TBD | | *NOTE: Oracle Server includes Client, Enterprise Edition, Parallel Server, | Personal Edition, RAC & Standard Edition Server. | |--- - | | For further assistance with Obsolescence &/or this file, please contact | [EMAIL PROTECTED] | Last modified: Wednesday, 19-Jun-2002 15:21:22 PDT. ---end--- The below is from Document #148054.1 ... | 8.1.7 (8i) | Platform(s): Platform Version(s): ALL Platforms ALL | | Desupport End Dates: Error Correction Support (ECS): 31-DEC-2003 | Extended Assistance Support (EAS): 31-DEC-2006 | Extended Maintenance Support (EMS): 31-DEC-2005 ... --- > > Do we have a decision from Oracle on whether Developer 6i will > be supported against 9.2? haaa haaa haa haaa (insert insane cackling sounds) > > I would love to get a stable platform upgrade in this next year > so that I would not have to touch these sites for another 5-10 > years. (insert more insane cackling sounds) > > [Political comment] > I would love it even more to get a stable and affordable 9iAS > forms and reports server in place for these 10-50 user > customers. (insert even more insane cackling sounds) According to one investment guy on the ORACLE-L dba list recently, Oracle's business model is getting pretty precarious, incursions by MS SQL Server and IBM/DB2 into Oracle's market share are really causing problems. I guess Oracle's business strategy is to batten the hatches, cut costs wherever possible (including outsourcing tech support?), and hope to weather the storm without losing too many investors. As such, it may be wishful thinking to hope that Oracle will be motivated to continue any sort of robust support for client-server for very much longer. (Unless the customers get really p*ssed off and start nagging like h*ll?). :):):) side note: On the ODTUG Java list a while ago, there was a major discussion between some old time Oracle customers about the pros/cons of using Oracle's up and coming JAVA mid-tier stuff vs. using MS .net (ASP?), which apparently has the capability of running in something like client-server mode. The Oracle employees did their best to try to make a case for spending all the extra money on 3-tier JAVA/Oracle (basically saying that there were benefits to "standards" that may not be apparent in the short run, and implying that .net is going to just be another funky, inflexible, transitory MS thing that people will have to abandon before the assumed/implied/expected end-of-lifecycle is actually over. (more crazed cackling) It may be that Oracle has seen the "handwriting on the wall", and basically conceded defeat on the low end of the LAN market. You may remember how much of giant flop Oracle's last, great marketing project with Novell was. regards, ep --- End of forwarded message --- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eric D. Pierce INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shaw John-P55297 INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Slow select distinct
If not distinct there's about 9900 records, there are some physical rw' going on but I've bumped sort area up to 2M. -Original Message- Sent: Monday, April 29, 2002 5:38 PM To: Multiple recipients of list ORACLE-L John, If you don't use the DISTINCT, how many records are returned? The problem is that DISTINCT forces a sort, no way around it. Are you sorting in memory or disk? Dan Fink -Original Message- John-P55297 Sent: Monday, April 29, 2002 3:44 PM To: Multiple recipients of list ORACLE-L I got a query that selects a list of addresses based an occurence at that location. this query comes back in less than 2 seconds without a distinct clause on the concatenated name. When I add the distict clause it takes over 40 seconds. I've tried adjusting various sort area sizes and buffer sizes to see if I can speed this up. Anybody have a clue if there is something in particular that I can check. 8.1.6 on NT rules based. wtihout the distinct clause it brings back about 10,000 records. select DISTINCT LTRIM(L.STREET_ADDRESS_BEGIN||' '||L.STREET_NAME_PREFIX||' '||L.STREET_NAME||' '||L.STREET_NAME_SUFFIX) WRECKS FROM LOCATION L, STREET_REQS SR WHERE L.ID = SR.ID AND L.STREET_NAME IS NOT NULL AND SR.TYPE IN ('KED','KAD') AND SR.CODE LIKE 'O%' AND SR.ORIG_STREET_REQ_ID IS NULL -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shaw John-P55297 INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Daniel W. Fink INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shaw John-P55297 INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RE: Slow select distinct
Thanks for the idea - however the alternative you suggested actually ran slower. It's seems to be the size of the distinct sort. -Original Message- Sent: Tuesday, April 30, 2002 9:59 AM To: Multiple recipients of list ORACLE-L >- Original Message - >From: Shaw John-P55297 <[EMAIL PROTECTED]> >To: Multiple recipients of list ORACLE-L ><[EMAIL PROTECTED]> >Sent: Tue, 30 Apr 2002 06:13:42 > >Unfortunately there are duplicates so they do need >the distinct clause. I >have tried several permutations of the query and >distinct clauses including >the most popular alternative: >select distinct wrecks >from >(select DISTINCT LTRIM(L.STREET_ADDRESS_BEGIN||' >'||L.STREET_NAME_PREFIX||' >'||L.STREET_NAME||' '||L.STREET_NAME_SUFFIX) WRECKS > >FROM LOCATION L, > STREET_REQS SR >WHERE L.ID = SR.ID > AND L.STREET_NAME IS NOT NULL > AND SR.TYPE IN ('KED','KAD') > AND SR.CODE LIKE 'O%' > AND SR.ORIG_STREET_REQ_ID IS NULL); >However it all seems to go back to the sort on the >9500 rows being returned. > Try a 'divide and conquer' approach then, eliminating duplicates first as they might occur from several rows in STREET_REQS matching the same row in LOCATION, then by eliminating the remaining duplicates. Should lighten the burden of sorting. What about : select DISTINCT LTRIM(L.STREET_ADDRESS_BEGIN||' '||L.STREET_NAME_PREFIX||' '||L.STREET_NAME||' '||L.STREET_NAME_SUFFIX) WRECKS FROM LOCATION L, (select DISTINCT ID FROM STREET_REQS WHERE TYPE IN ('KED','KAD') AND CODE LIKE 'O%' AND ORIG_STREET_REQ_ID IS NULL) SR WHERE L.ID = SR.ID AND L.STREET_NAME IS NOT NULL; Regards, Stephane Faroult Oriole -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroul INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shaw John-P55297 INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Slow select distinct
Unfortunately there are duplicates so they do need the distinct clause. I have tried several permutations of the query and distinct clauses including the most popular alternative: select distinct wrecks from (select DISTINCT LTRIM(L.STREET_ADDRESS_BEGIN||' '||L.STREET_NAME_PREFIX||' '||L.STREET_NAME||' '||L.STREET_NAME_SUFFIX) WRECKS FROM LOCATION L, STREET_REQS SR WHERE L.ID = SR.ID AND L.STREET_NAME IS NOT NULL AND SR.TYPE IN ('KED','KAD') AND SR.CODE LIKE 'O%' AND SR.ORIG_STREET_REQ_ID IS NULL); However it all seems to go back to the sort on the 9500 rows being returned. -Original Message- Sent: Monday, April 29, 2002 5:53 PM To: Multiple recipients of list ORACLE-L Shaw John-P55297 wrote: > > I got a query that selects a list of addresses based an occurence at that > location. > this query comes back in less than 2 seconds without a distinct clause on > the concatenated name. When I add the distict clause it takes over 40 > seconds. I've tried adjusting various sort area sizes and buffer sizes to > see if I can speed this up. Anybody have a clue if there is something in > particular that I can check. > 8.1.6 on NT rules based. wtihout the distinct clause it brings back about > 10,000 records. > select DISTINCT LTRIM(L.STREET_ADDRESS_BEGIN||' '||L.STREET_NAME_PREFIX||' > '||L.STREET_NAME||' '||L.STREET_NAME_SUFFIX) WRECKS > FROM LOCATION L, > STREET_REQS SR > WHERE L.ID = SR.ID > AND L.STREET_NAME IS NOT NULL > AND SR.TYPE IN ('KED','KAD') > AND SR.CODE LIKE 'O%' > AND SR.ORIG_STREET_REQ_ID IS NULL Checking the execution plan in both case could have been interesting. In any case, DISTINCT is rarely necessary with a join. Look at your query. Everything comes from the LOCATION table, STREET_REQS just happens to be here to provide a filter. Unless LOCATION holds duplicates for the columns you want to bring back, you can avoid the DISTINCT. Both 'IS NULL' and 'IS NOT NULL' (less sure about the later with latest versions) usually translate as 'full scan', so forget them if you wish to get quickly to the data. Hopefully (and your DISTINCT-less result seems to indicate this) the TYPE and/or CODE conditions are very selective. If scanning LOCATION is not too painful, this can give good results : select LTRIM(L.STREET_ADDRESS_BEGIN||' '||L.STREET_NAME_PREFIX||' '||L.STREET_NAME||' '||L.STREET_NAME_SUFFIX) WRECKS FROM LOCATION L WHERE L.STREET_NAME IS NOT NULL AND EXISTS (SELECT NULL FROM STREET_REQS SR WHERE SR.TYPE IN ('KED','KAD') AND SR.CODE LIKE 'O%' AND SR.ORIG_STREET_REQ_ID IS NULL AND SR.ID = L.ID) Another solution could be: select LTRIM(L.STREET_ADDRESS_BEGIN||' '||L.STREET_NAME_PREFIX||' '||L.STREET_NAME||' '||L.STREET_NAME_SUFFIX) WRECKS FROM LOCATION L WHERE L.STREET_NAME IS NOT NULL AND L.ID IN (SELECT SR.ID FROM STREET_REQS SR WHERE SR.TYPE IN ('KED','KAD') AND SR.CODE LIKE 'O%' AND SR.ORIG_STREET_REQ_ID IS NULL) However, this is unlikely to be efficient if the inner query returns 10,000 rows. Do not play with parameters before having tried everything else. -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shaw John-P55297 INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Slow select distinct
I got a query that selects a list of addresses based an occurence at that location. this query comes back in less than 2 seconds without a distinct clause on the concatenated name. When I add the distict clause it takes over 40 seconds. I've tried adjusting various sort area sizes and buffer sizes to see if I can speed this up. Anybody have a clue if there is something in particular that I can check. 8.1.6 on NT rules based. wtihout the distinct clause it brings back about 10,000 records. select DISTINCT LTRIM(L.STREET_ADDRESS_BEGIN||' '||L.STREET_NAME_PREFIX||' '||L.STREET_NAME||' '||L.STREET_NAME_SUFFIX) WRECKS FROM LOCATION L, STREET_REQS SR WHERE L.ID = SR.ID AND L.STREET_NAME IS NOT NULL AND SR.TYPE IN ('KED','KAD') AND SR.CODE LIKE 'O%' AND SR.ORIG_STREET_REQ_ID IS NULL -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shaw John-P55297 INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Clob, toad, and a trigger not working
I've encountered a weird error (no it's not my boss). It's on W2K and happens on 8.1.6 an 9i. I've got two tables with clobs CREATE TABLE CLOB_TEST ( EIDNUMBER, CLOB_TEST CLOB ) ; -- CREATE TABLE CLOB_TEST_AFTER ( EIDNUMBER, CLOB_TEST CLOB ) ; and created the following trigger: CREATE OR REPLACE TRIGGER CLOB_TEST_AI AFTER INSERT ON CLOB_TEST FOR EACH ROW DECLARE buffer long; len number(10); eid number; clobber clob; sql_stmt varchar2(100); BEGIN eid := :NEW.EID; clobber := :NEW.CLOB_TEST; len := dbms_lob.getlength(clobber); DBMS_LOB.READ(clobber,len,1,buffer); insert into clob_test_after (eid, clob_test) values (eid, buffer); END; This trigger works fine when I do an insert into the first table from sqlplus but when I do an insert from TOAD or another third party application I get the following error messages: ora-21560 argument 2 is null, invalid, or out of range ora-06512 at sys.dbms_lob line 648 ora-06512 at clob_test_ai line 17 ora-04088 error during execution of trigger clob_test_ai Anyone know why this error occurs from third party stuff and not from sqlplus - or better yet a work around? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shaw John-P55297 INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Any issues with Developer 6i running against Oracle 9i
Just started testing it. So far the only problems I've had is pl/sql stuff - package body constants differing from specs, and one proc where they referenced rowid: type xyz is table of rowid index by binary_integer; where there was a bug workaround and now the workaround doesn't work. -Original Message- Sent: Tuesday, April 23, 2002 9:14 AM To: Multiple recipients of list ORACLE-L Hi All, Does anyone know of any problems of running forms/reports 6i against Oracle 9i on WinNT? Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shaw John-P55297 INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Execution plan optimizer Question
8.1.6 on NT The product that I support is still Rule based. I am planning to bring it over to Cost based in the near future. What I wanted to do was to set the init parameter to 'RULE' and then run statistics on the database. My boss says we can't do this because "the execution plan was different for the "set to rule and have statistics" vs. "set to choose and no statistics". I haven't heard this before - can anybody point me to the Fine Manual to confirm or refute this. Perhaps this is another of those fine urban legends? For the time being I am starting out with a small test database. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shaw John-P55297 INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: User_product_profile and sqlplusw
I had to try it out, this works on 9i and W2K. insert into product_user_profile (product,userid,attribute,char_value) values ('SQL*Plus','TRACK','INSERT','DISABLED'); Connected to: Oracle9i Enterprise Edition Release 9.0.1.1.1 - Production With the Partitioning option JServer Release 9.0.1.1.1 - Production SQL> insert into test (aa,bb) values ('A',1); SP2-0544: invalid command: insert SQL> insert into test (aa,bb) values ('A',1); SP2-0544: invalid command: insert SQL> connect system/manager Connected. SQL> delete from product_user_profile; 1 row deleted. SQL> commit; Commit complete. SQL> insert into test (aa,bb) values ('A',1); 1 row created. SQL> -Original Message- Sent: Tuesday, April 16, 2002 7:53 AM To: Multiple recipients of list ORACLE-L Thanks but that does not work either. Rick Shaw John-P55297 To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Subject: RE: User_product_profile and sqlplusw Sent by: root@fatcity. com 04/15/2002 05:58 PM Please respond to ORACLE-L I haven't tried this for a while, but I think it's case sensitive. try 'sqlplusw.exe' -Original Message- Sent: Monday, April 15, 2002 4:13 PM To: Multiple recipients of list ORACLE-L Hi, I have successfully restricted insert,update,delete using product_user_profile if the user users sqlplus at the command prompt. However I cannot get it to work if they use sqlplusw.exe. Any ideas what entry I have to use to enforce this. This is what I used to restrict product access with sqlplus.exe This works for command prompt sqlplus insert into SYSTEM.PRODUCT_USER_PROFILE(PRODUCT,USERID,ATTRIBUTE,CHAR_VALUE) values ('SQLPlus','USER_ID','INSERT','DISABLED') ; This does not work for windows sqlplus insert into SYSTEM.PRODUCT_USER_PROFILE(PRODUCT,USERID,ATTRIBUTE,CHAR_VALUE) values ('SQLPlusw','USER_ID','INSERT','DISABLED') ; Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shaw John-P55297 INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shaw John-P55297 INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: User_product_profile and sqlplusw
I haven't tried this for a while, but I think it's case sensitive. try 'sqlplusw.exe' -Original Message- Sent: Monday, April 15, 2002 4:13 PM To: Multiple recipients of list ORACLE-L Hi, I have successfully restricted insert,update,delete using product_user_profile if the user users sqlplus at the command prompt. However I cannot get it to work if they use sqlplusw.exe. Any ideas what entry I have to use to enforce this. This is what I used to restrict product access with sqlplus.exe This works for command prompt sqlplus insert into SYSTEM.PRODUCT_USER_PROFILE(PRODUCT,USERID,ATTRIBUTE,CHAR_VALUE) values ('SQLPlus','USER_ID','INSERT','DISABLED') ; This does not work for windows sqlplus insert into SYSTEM.PRODUCT_USER_PROFILE(PRODUCT,USERID,ATTRIBUTE,CHAR_VALUE) values ('SQLPlusw','USER_ID','INSERT','DISABLED') ; Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shaw John-P55297 INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Is it possible to remove default (TOAD users)
8.1.6 NT TOAD I have a developer assign a default value to a column, and they don't want it anymore. I can reset the default to be NULL (the default default so to speak) but they are able to see the fact that there is a default in TOAD on that column and of course the other columns don't have a default of NULL on them so they would like it removed - it makes them nervous. Is there any way to just get rid of the default showing up without deleting and re-adding the column? Should I tell them not to meddle anymore? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shaw John-P55297 INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: migrate from 8i to 9i
containing: UNSUB > > ORACLE-L > > (or the name of mailing list you want to be > removed > > from). You may > > also send the HELP command for other information > > (like subscribing). > > > __ > Do You Yahoo!? > Yahoo! Tax Center - online filing with TurboTax > http://taxes.yahoo.com/ > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Kader Ben > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: > (858) 538-5051 > San Diego, California-- Public Internet > access / Mailing Lists > > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). __ Do You Yahoo!? Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnson Poovathummoottil INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shaw John-P55297 INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Another partitioning question part 2
partition by range(owner_id,type) (partition p1 values less than (2000) and type ='X' tablespace test, partition p2 values less than (5000) and owner_table ='X' tablespace test, partition p3 values less than (10000) and owner_table ='X' tablespace test, partition p4 values less than (5) and owner_table ='X' tablespace test, partition p5 values less than (10) and owner_table ='X' tablespace test) partition p6 values less that (10) and owner_table !='X' tablespace test; -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shaw John-P55297 INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists -------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shaw John-P55297 INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Another partitioning question
Thanks for the help. -Original Message- Sent: Friday, March 15, 2002 11:28 AM To: Multiple recipients of list ORACLE-L John - At last a question I can answer! Anyway I think so. You can partition on a concatenated key. I just did this on our data warehouse and brought query times from over 2 minutes to under 10 seconds. Here is what my partition looks like. create table sumacctfact2 nologging pctfree 5 partition by range ( periodgrain, periodenddate ) ( partition sum_fy_01 values less than ('FY', to_date('01011999','mmdd')) tablespace data_fy_01 storage ( maxextents unlimited ), partition sum_fy_02 values less than ('FY', to_date('01012000','mmdd')) tablespace data_fy_02 storage ( maxextents unlimited ), partition sum_fy_03 values less than ('FY', to_date('01012001','mmdd')) tablespace data_fy_03 storage ( maxextents unlimited ), partition sum_fy_04 values less than ('FY', to_date('02012001','mmdd')) tablespace data_fy_04 storage ( maxextents unlimited ), Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, March 15, 2002 10:38 AM To: Multiple recipients of list ORACLE-L I think what my boss is asking me to do is not possible, but since I don't have much experience with partitioning I thought I'd ask here (I did read some of manuals but didn't find an answer that suited my conditions). My boss wants a table partitioned by 2 columns - seq_no and type. If the type = 'X' then it's just a range partition, but then he wants another partition that contains all data that type!='X' but is inclusive of the entire range. Is this possible? Something like (I know this syntax isn't correct ) create table test_part( id number(11) unique, owner_id number(11) not null, type varchar2(30) not null, name varchar2(40)) partition by range(owner_id,type) (partition p1 values less than (2000) and type ='X' tablespace test, partition p2 values less than (5000) and owner_table ='X' tablespace test, partition p3 values less than (1) and owner_table ='X' tablespace test, partition p4 values less than (5) and owner_table ='X' tablespace test, partition p5 values less than (100000) and owner_table ='X' tablespace test) partition p6 values less that (10) and owner_table !='X' tablespace test; -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shaw John-P55297 INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shaw John-P55297 INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Another partitioning question
I think what my boss is asking me to do is not possible, but since I don't have much experience with partitioning I thought I'd ask here (I did read some of manuals but didn't find an answer that suited my conditions). My boss wants a table partitioned by 2 columns - seq_no and type. If the type = 'X' then it's just a range partition, but then he wants another partition that contains all data that type!='X' but is inclusive of the entire range. Is this possible? Something like (I know this syntax isn't correct ) create table test_part( id number(11) unique, owner_id number(11) not null, type varchar2(30) not null, name varchar2(40)) partition by range(owner_id,type) (partition p1 values less than (2000) and type ='X' tablespace test, partition p2 values less than (5000) and owner_table ='X' tablespace test, partition p3 values less than (1) and owner_table ='X' tablespace test, partition p4 values less than (5) and owner_table ='X' tablespace test, partition p5 values less than (10) and owner_table ='X' tablespace test) partition p6 values less that (10) and owner_table !='X' tablespace test; -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shaw John-P55297 INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Partitioning question
You're right about the performance - they (the ones before I got here) tried to run the stats and use choose and the performance was terrible. Now it is not an option to use CBO. One of my tasks is to set up an environment and take it to CBO, but this is not the immediate priority. -Original Message- Sent: Thursday, March 14, 2002 12:25 PM To: Multiple recipients of list ORACLE-L John, First question, how do you know that your application is rule based? Most application scan be switched to cost optimization with no changes, although I will admit performance sometimes goes south. I prefer to set the database to 'choose' mode which allows the best of both worlds. Dick Goulet Reply Separator____ Author: Shaw John-P55297 <[EMAIL PROTECTED]> Date: 3/14/2002 9:33 AM I am new to the world of partitioning. 816 on W2K. In a white paper on metalink "How to Implement Partitioning in Oracle Versions 8 and 8i " it states that "The RULE-based optimizer does not take the partitioning of tables and indexes into account." My question is - if your application is still rule based is there any value to partitioning? Some of the tables are over 30 million rows and 5G. If my understanding is correct I wouldn't see any performance improvement but would make maintenance simpler. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shaw John-P55297 INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shaw John-P55297 INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Partitioning question
I am new to the world of partitioning. 816 on W2K. In a white paper on metalink "How to Implement Partitioning in Oracle Versions 8 and 8i " it states that "The RULE-based optimizer does not take the partitioning of tables and indexes into account." My question is - if your application is still rule based is there any value to partitioning? Some of the tables are over 30 million rows and 5G. If my understanding is correct I wouldn't see any performance improvement but would make maintenance simpler. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shaw John-P55297 INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Cost vs Rule
The following is from the Tim Gorman paper · OPTIMIZER_INDEX_CACHING This initialization parameter represents a percentage value, ranging between the values of 0 and 99. The default value of 0 indicates to the CBO that 0% of database blocks accessed using indexed access can be expected to be found in the Buffer Cache of the Oracle SGA. This implies that all index accesses will require a physical read from the I/O subsystem for every logical read from the Buffer Cache, also known as a 0% hit ratio on the Buffer Cache. This parameter applies only to the CBO's calculations of accesses for blocks in an index, not for the blocks in the table related to the index. · OPTIMIZER_INDEX_COST_ADJ This initialization parameter is also a percentage value, ranging between 1 and 1, representing a comparison between the relative cost of physical I/O requests for indexed access and full table-scans. The default value of 100 indicates to the cost-based optimizer that indexed access is 100% as costly (i.e., equally costly) as FULL table scan access. As it turns out, the default values for each of these parameters are wildly unsuitable and unrealistic. I'll prove this assertion later in this paper, but for now, suffice to say that OPTIMIZER_INDEX_CACHING should be set to 90 and OPTIMIZER_INDEX_COST_ADJ should be set to a value which usually ranges between 10 and 50 for most online transaction processing (OLTP) systems, For data warehousing or other decision-support systems (DSS), it might be prudent to simply set this parameter to 50. -Original Message- Sent: Thursday, March 07, 2002 2:54 PM To: Multiple recipients of list ORACLE-L just changed index_cost_adj from 100 to 1 what is index_caching? -Original Message- Sent: Thu, March 07, 2002 3:04 PM To: Multiple recipients of list ORACLE-L have you tried adjusting optimzer_index_caching and optimizer_index_cost_adj? -Original Message- Sent: Thursday, March 07, 2002 1:23 PM To: Multiple recipients of list ORACLE-L I work in a dev shop - most of the sql is canned and pretty basic. We've been running CBO in all of our dev environments, but we have a few long txns that just take forever. At the request of some savvy developers, I turned on RBO, and it brought down execution times dramatically. I've been analyzing affected tables often (we do a lot of bulk load/unload for testing), and have played with partitioning and clustering, particularly on one table that's just a dog. CBO will always do a FTS where RBO uses the PK to retrieve data. Where to go next? I've been unable to alter the costs dramatically enough to make any real difference in execution time. thx -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Magaliff, Bill INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shaw John-P55297 INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Magaliff, Bill INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shaw John-P55297 INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists --
RE: Cost vs Rule
have you tried adjusting optimzer_index_caching and optimizer_index_cost_adj? -Original Message- Sent: Thursday, March 07, 2002 1:23 PM To: Multiple recipients of list ORACLE-L I work in a dev shop - most of the sql is canned and pretty basic. We've been running CBO in all of our dev environments, but we have a few long txns that just take forever. At the request of some savvy developers, I turned on RBO, and it brought down execution times dramatically. I've been analyzing affected tables often (we do a lot of bulk load/unload for testing), and have played with partitioning and clustering, particularly on one table that's just a dog. CBO will always do a FTS where RBO uses the PK to retrieve data. Where to go next? I've been unable to alter the costs dramatically enough to make any real difference in execution time. thx -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Magaliff, Bill INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shaw John-P55297 INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
alter index rebuild online
I'm still back on 8.1.6 and when I tried to use 'alter index rebuild online' I got corrupted indexes. I saw on metalink that it's supposed to be fixed by 8.1.7.1 - anybody using successfully now? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shaw John-P55297 INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: LIKE and % operator
The search is case sensitive, try something like select * from sonusrpt where upper(subject) like '%GENERAL%'; -Original Message- Sent: Monday, March 04, 2002 2:33 PM To: Multiple recipients of list ORACLE-L I am running oracle8i on solaris8. I have a word ( General ) in my column named "subject", I try to run SQL using LIKE and % to grep any data having the word ( General ) but it displayed no rows selected. Does someone have any idea why? Below is my SQL I used. SQL> select * from sonusrpt where subject like '%general%'; no rows selected. Thanks, David -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shaw John-P55297 INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: How's the job market?
Not like it was last the couple of years. If you just scan monster and hotjobs there appear to be a lot, but in reality the market is a lot softer. Most places don't seem to be willing to pay for relocation right now because there is a lot of local talent available, especially in major telecom markets. My current employer was planning on hiring 50 additional Oracle types (mainly developers) up until December but now have a hiring freeze and cut out 2 consultants. I know of at least 2 companies that have recinded offers they had made. Start networking early. -Original Message- Sent: Friday, March 01, 2002 8:48 AM To: Multiple recipients of list ORACLE-L This is not a resume and I am not looking for a job. But... My company keeps losing people in the DBA group and not replacing them. We have more work than we have ever had but we still don't replace people. Management is looking at hiring an outside company to monitor the databases and provide monthly reports. I am just afraid the clock is ticking. I have over ten years as a DBA in ADABAS, Oracle, and SQL Server. I am familiar with Honeywell, IBM, Unix, and MS servers. I have been here for years and I don't want to leave but my question for the group is, what is the job market like and how tuff would it be to find a job if I needed to do so? Ron -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shaw John-P55297 INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Re[2]: address parse
usually street number street name and street type, but it could also include street prefix , apartment number, and directional suffix. -Original Message- Sent: Tuesday, February 26, 2002 2:30 PM To: Multiple recipients of list ORACLE-L Shaw, S> street address How is it formatted? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Eskridge INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shaw John-P55297 INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: address parse
street address -Original Message- Sent: Tuesday, February 26, 2002 10:55 AM To: Multiple recipients of list ORACLE-L S> Anybody already have an address string parser (plsql) already written that S> they would care to share? Address? IP? Internet mail? USPS? Memory address? URL? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Eskridge INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shaw John-P55297 INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
address parse
Title: RE: UWIN and Oracle Anybody already have an address string parser (plsql) already written that they would care to share?
RE: Weird ODBC Issue
Do they have primary keys? I seem to remeber that Access needed the Oracle table to have a primary key on it. -Original Message- Sent: Friday, February 15, 2002 4:43 PM To: Multiple recipients of list ORACLE-L No clue. User installed. -Original Message- Sent: Friday, February 15, 2002 4:14 PM To: Multiple recipients of list ORACLE-L What ODBC Driver are you using? I've seen this with certain builds of Microsoft's driver, really quirky on W98. David A. Barbour Oracle DBA, OCP AISD 512-414-1002 "Bellows, Bambi" To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Subject: Weird ODBC Issue Sent by: [EMAIL PROTECTED] om 02/15/2002 11:34 AM Please respond to ORACLE-L I'm not exactly sure why, but I have a user who wants to see Oracle tables in Access. Whatever. So, the user can go into our pal SCOTT/TIGER no problem and look at tables from user_tables (not all_tables, which I find weird, but, what the hay). But, if the user tries to go into APPS/APPS, he can only see one table, and that one is owned by ADS. Anyone have similar problems? Any clue as to a resolution? Let me know... Yer pal, Bambi. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bellows, Bambi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bellows, Bambi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shaw John-P55297 INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: HOW TO KNOW INDEX NOT IN USE?
Title: RE: HOW TO KNOW INDEX NOT IN USE? I can get it. -Original Message-From: Aponte, Tony [mailto:[EMAIL PROTECTED]]Sent: Tuesday, February 05, 2002 11:21 AMTo: Multiple recipients of list ORACLE-LSubject: RE: HOW TO KNOW INDEX NOT IN USE? Nope. Same behavior for me. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, February 05, 2002 11:01 AM To: Multiple recipients of list ORACLE-L Subject: RE: HOW TO KNOW INDEX NOT IN USE? Can anyone else get to this article? My browser gets redirected to http://download-west.oracle.com/otndoc/oracle9i/901_doc/appdev.901/a89852/d_metada.htm#1656 Jared àãø éçéàì <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 02/05/02 12:45 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject: RE: HOW TO KNOW INDEX NOT IN USE? Hello Seema Oracle magazine for 01-02/2002 has on page 91 an article that gives step by step instructions on this issue for 9i. They also have a reference to: http://www.oracle.com/oramag/oracle/jan02/metadata.html Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED] > -Original Message- > From: Seema Singh [SMTP:[EMAIL PROTECTED]] > Sent: Mon, February 04, 2002 7:55 PM > To: Multiple recipients of list ORACLE-L > Subject: HOW TO KNOW INDEX NOT IN USE? > > Hi > I there any view which can tell us which indexes are not in use? > Thx > -Seema > > > > _ > Chat with friends online, try MSN Messenger: http://messenger.msn.com > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Seema Singh > INET: [EMAIL PROTECTED] > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California -- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- > This e-mail was scanned by the eSafe Mail Gateway > -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?= INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). >W±ëzØ^¡÷âr&¥9,BÅm¶ÿà (§Ú©Ê&ëa¢² 2ZçR¶)e§b³+¢aZ´(È×ÂäIêïǬó9ßÎtçQ@_Î|ç9ÓRjpâz jX¢¹âhû'׫ëZqǬ³óX§¸¬¶ÄèDCTL¨º»÷ë¢kaÉX§X¬¶Ç§u©Ä1¨¥ë,j ¸¬´k«¹ör+rr§¢×\²¥)à¡òâ²Ñ®®æ§v)í é²Æ xb)Üç^jX§yÊ'µ¨§x5%9,Bè®Ø^©¡ùX§X¬·*.Á©í¶Þ騽ç_®¢éÉ©l¢Ç§vØ^BÏr¦jw_¢º- êâú+«b¢ybë.nÇ+¸§
OEM question
I have 2 8.1.6 instances running on a NT4 (sp6) server using the same listener. With Enterprise manager (oem server is a different machine), I can see - discover one of the instances but not the other. If I use toad or sqlplus I can connect to the other instance. Any guesses as to what I need to do to see this other instance with enterprise manager? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shaw John-P55297 INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: SCOTT/TIGER
Back when I used GUPTA (now I think it's called Centura), those guys claimed it was Bruce Scott (one of the co founders of Oracle) and the ever popular cat . -Original Message- Sent: Thursday, January 24, 2002 7:51 AM To: Multiple recipients of list ORACLE-L Well, Scott Gossett has certainly been with Oracle a long time, he definitely teaches the advanced seminars (take them if you can), he's one of the best instructors with Oracle University (and for the other instructors I know that haunt this list, please note "one of" -- you guys are great as well) I'll have to ask him the next time I talk to him. Rachel --- "Vergara, Michael (TEM)" <[EMAIL PROTECTED]> wrote: > The name I was given is Scott Gossett. My team leader and one > of our team members took the advanced seminars last year, and > their instructor was Scott, and he admitted his notoriety. > > -Original Message- > Sent: Wednesday, January 23, 2002 4:00 PM > To: Multiple recipients of list ORACLE-L > > > there are several instructors named Scott how do you know which > one > it is or even if it's one of the instructors? > > > --- "Vergara, Michael (TEM)" <[EMAIL PROTECTED]> wrote: > > Ok...it's true. Take the Oracle Technical seminars and you too may > > get to meet Scott, Live and In Person. Unfortunately, Tiger is > > waiting > > for Scott at the Rainbow Bridge, but Scott is still there (at least > > he was last year...you know how Oracle's been lately). > > > > -Original Message- > > Sent: Wednesday, January 23, 2002 10:26 AM > > To: Multiple recipients of list ORACLE-L > > > > > > I was once told with certainty from an Oracle instructor that Scott > > was > > an early developer, and Tiger was his cat. But without actually > > meeting > > Scott I take this with a grain of salt. I expect there are many > > urban > > legends surrounding this. > > > > Jim > > > > -Original Message- > > Sent: Wednesday, January 23, 2002 11:45 AM > > To: Multiple recipients of list ORACLE-L > > > > > > Anyone out there know the history of this? > > -- > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Vergara, Michael (TEM) > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing > Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Great stuff seeking new owners in Yahoo! Auctions! http://auctions.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shaw John-P55297 INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Going to Cost
I have a large app that is still running rule based, we are finally going to take the plunge and try to start going cost based. The first time we tried this the performance was terrible in a lot of places. Does anyone have any good white papers or hints/tips on what to look for on areas that might be problems or pitfalls? tia ... --- ... . .-.. .--. -- . .. .. -... . . -. .--. .-. --- -... .-.. John B. Shaw (ribit) / o o ( -- ) /\( , ,)/\ ^^ ^^ ^^ ^^ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shaw John-P55297 INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).