RE: Re: Oracle vs Mysql
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of [EMAIL PROTECTED] Sent: Tuesday, 20 January 2004 23:59 To: Multiple recipients of list ORACLE-L Subject: Re: Re: Oracle vs Mysql if Oracle is offshoring its develeoping of its database, everyone else will also... so much for job security. anyone I heard postgre sql has multi-versioning? Is it implemented like Oracle? No, its implementation is different. For deletes, it doesn't reclaim space immediately. Instead, it marks a flag indicating at what point (analogous to SCN) the row became deleted, and relevant transactions can still see the row, whereas future transactions can't. Works quite well in practice. The obvious question is what happens to these rows once all transactions have moved on?. Currently, there's a maintenance job (called Vacuum) that needs to be run to reclaim the space ... at the Linix.conf.au last week there was a presentation that showed a new lazy daemon that would do this automagically. Updates are handled as a delete+insert, with similar control. One big benefit - you'll never have to size a rollback/undo tablespace, or see 1555 errors :-) :-) :-) So UDB is the new DB2? Oracle claims that DB2 is not one database but a different database for different Operating Systems, is this true? Is it true with UDB? It used to be, but IBM is tidying things up. The Linux/Unix/Windoze stuff is all identical (it's the old common server reborn), and they've made a big effort at harmonising the zOS (and to a lesser extent, AS400) forms. The biggest improvement in the last couple of years was ANSI standard stored procedures (ANSI Stored Persistent Modules). Very nice - the structured error handling alone is amazingly good. You can still find the occasional version lag, where one platform won't have a new feature until a minor version later than another. Ciao Fuzzy (my coffee coaster has something written on it ... IBM DB2 Certified Database ... ... what the *#^$!?!?) :-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: MS Access
viraj2 wrote: Hi all, I was wondering if any one out here knows if there is a good list (mailing list) for discussing MS Access problems. I am specifically looking for migrating/converting large Access database into Oracle database. I need to know what will be the steps to convert such a database into an Oracle database. Also need to learn Access from start. Please reply fast, I need to dive into this one. Thanks and Regards, Raja Oracle has a product called Migration Workbench that converts various other db's to Oracle. Can't vouch for it performance, never having used it before though. The workbench itself is quite useful - funnily enough, as much for the manual as for the product itself. It gives a fairly good run-down to approaching migration, which can be applied to just about any DB. The only gotchas I encountered with the workbench are its picky requirements for exact installer versions, etc. (nothing new there for Oracle). Ciao Fuzzy :-) -- The contents of this post are my opinions only If swallowed seek medical advice -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Oracle vs Mysql
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Ryan Sent: Thursday, 15 January 2004 09:05 To: Multiple recipients of list ORACLE-L Subject: Re: Oracle vs Mysql i thought postgre was a for profit company? how do they generate revenues? Don't confuse the PostgreSQL dev team with PostgreSQL Inc. The latter makes some commercially licenced add-ons for PostgreSQL, but the db itself is released under the Berkeley licence. Completely free for commercial use. Unlike MySQL, where you need to licence the server, AND licence the connectivity for commercial use. Ciao Fuzzy :-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: oaktable people
-Original Message- From: Mogens Nørgaard [mailto:[EMAIL PROTECTED] Sent: Friday, 9 January 2004 09:50 To: Multiple recipients of list ORACLE-L Subject: Re: oaktable people Heh-heh. It should be said in all fairness that we don't really spend much time with our website (keeping it updated, for instance - just to mention one minor detail), so we certainly understand if people are asking for directions there :). One very un-serious question: Is it actually possible to do a revoke all from grant;? Mogens It is quite possibly the worst name to have as a DBA - thus my usual use of my nickname, Fuzzy. My personal favourite is grant [whatever priv] to grant with grant option;. One small benefit is you can be sure the apps we develop never have any problems with reserved words :-) Ciao Grant/Fuzzy :-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: oaktable people
-Original Message- From: Niall Litchfield [mailto:[EMAIL PROTECTED] Sent: Thursday, 8 January 2004 09:09 To: Multiple recipients of list ORACLE-L Subject: RE: oaktable people Pete commented that Aussies are ALWAYS great communicators, just a bit direct for some people sometime. :) Unfortunately they keep communicating how great their cricketers are in comparison to ours. Usually *to* ours. So we sulk, refuse to play and then whinge. Actually now I think about it what better description of a DBA could there be. I take it all back. Niall But we let you win the rugby. :-) :-) :-) (Before Jared stomps on the off-topic post, are there any Oaktable links on the MiracleAS web site? I'm having trouble finding them, and I could swear I've been there before - reading Mogen's description of the table) Ciao Fuzzy :-) -- The contents of this post are my opinions only If swallowed seek medical advice -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: oaktable people
D'oh ... just spotted the link to Oaktable - hidden, of all places, under Links. Who'd a thought ... Ciao Fuzzy :-) -- The contents of this post are my opinions only If swallowed seek medical advice -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: oracle client on PC's
-Original Message- From: Jared Still [mailto:[EMAIL PROTECTED] Sent: Wednesday, 7 January 2004 07:45 To: Multiple recipients of list ORACLE-L Subject: Re: oracle client on PC's What is a 'wire-protocol' ODBC driver? Jared It's an ODBC driver that either speaks the native network protocol for the DB by itself, or talks via a very thin layer to a server side component that then translates. Both options mean no typical DB client is required on the machine running the ODBC app. Merant/DataDirect/Whatever-they're-called-this-week make quite a few of these. Ciao Fuzzy :-) -- The contents of this post are my opinions only If swallowed seek medical advice -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
ANSI join syntax and Oracle 8i
Does anyone know if the ANSI join syntax (LEFT OUTER JOIN, RIGHT OUTER JOIN, instead of (+) =, etc.) was backported to 8i? Ciao Fuzzy :-) -- The contents of this post are my opinions only If swallowed seek medical advice -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: ANSI join syntax and Oracle 8i
-Original Message- From: Jonathan Gennick [mailto:[EMAIL PROTECTED] Sent: Monday, 22 December 2003 11:59 To: Multiple recipients of list ORACLE-L Subject: Re: ANSI join syntax and Oracle 8i Sunday, December 21, 2003, 7:14:27 PM, Grant Allen ([EMAIL PROTECTED]) wrote: GA Does anyone know if the ANSI join syntax (LEFT OUTER JOIN, RIGHT OUTER JOIN, instead of (+) =, GA etc.) was backported to 8i? No, it was not. Best regards, Thanks Jonathan - I had a feeling that was the case, just making sure. Ciao Fuzzy :-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Career Advice
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Thursday, 18 December 2003 11:34 To: Multiple recipients of list ORACLE-L Subject: Re: Career Advice Perl: Since you're working with Oracle, if you were to buy only one book, you might consider: http://www.oreilly.com/catalog/oracleperl A copy of which has just landed on my desk. Much kudos to yourself and Andy. Ciao Fuzzy :-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: http://www.wintercorp.com/vldb/2003_TopTen_Survey/TopTenWinners.a sp
They hire a DBA to run sp_lock a lot! evil grin Ciao Fuzzy :-) -- The contents of this post are my opinions only If swallowed seek medical advice -Original Message- From: Ryan [mailto:[EMAIL PROTECTED] Sent: Friday, 12 December 2003 09:30 To: Multiple recipients of list ORACLE-L Subject: Re: http://www.wintercorp.com/vldb/2003_TopTen_Survey/TopTenWinners.a sp also, how do people scale sql server to that many concurrent users if reads block writes? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: rebuilding indexes - sure to cause a ruckus
BTW, does anyone know what a rocket scientist refers to when they say Hey, this is all quite easy, it sure ain't ? ? Cheers ;) Richard Surely the Rocket Scientist version must be Hey, this is all quite easy, it sure ain't index rebuilding very evil grin Ciao Fuzzy :-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Oracle Client (9.2.0.4)
-Original Message- From: Anders Bengtsson [mailto:[EMAIL PROTECTED] Sent: Tuesday, 9 December 2003 23:24 To: Multiple recipients of list ORACLE-L Subject: Oracle Client (9.2.0.4) Hi, I find the information concerning upgrading to Oracle 9.2.0.4 on the server and upgrading to ODP.NET 9.2.0.4.01 on the client a little confusing. Se readme for patchset nr 3262475 The upgrade on the server to 9.2.0.4 is ok and the upgrade on the client is no problem. But should you install the ODP.NET also on the server or is this only a client install? It's a client side driver ... so unless your Oracle server is also running client code requiring ODP.Net, don't install it on the server. If you do need to install it on the server, patch the server to 9.2.0.4 first! If you don't, you'll have copious DLL version mismatches (with missing and invalid entry points), and nothing will start (no instances, nothing (except maybe a listener :-)). Culprits include orageneric.dll, etc. (can you tell I made this mistake myself?). Reinstalling 9.2.0.1 is the only option if you make this mistake (the databases themselves are fine - just a wasted afternoon watching the Oracle installer). The 9.2.0.4 patch for the server is quite painless ... just takes a while to run catupgrade.sql (or whatever it was called). Furthermore, Does Oracle Client (9.2.0.4) exists? The ODP.NET 9.2.0.4.01 includes only Oracle Client 9.2.0.1 and I can't find 9.2.0.4 anywhere. It is mentioned but I can't find It. No, there's no 9.2.0.4 client patch for windows. You can apply the ODP.Net provider directly to a 9.2.0.1 client - though it will prompt you to upgrade the installer to 2.2.0.18 first (a painless exercise). I would be delighted if someone could explain to me how this installations should be done. We have a Windows Plattform, both on the server and the client. Hope that helps, Anders. Ciao Fuzzy :-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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 option licensing
-Original Message- Sent: Thursday, 4 December 2003 01:25 To: Multiple recipients of list ORACLE-L As of 9iR2, partitioning is still licensed separately as a $10K (retail) extra charge per processor. So, the total retail comes to a painful $50K per processor for 9i + Partitioning. Also, remember that support costs X% of the licensing per year, depending on your support level. You'll have to confirm the exact numbers with your sales rep. You can estimate about 22%, as I recall. We just increased our licensing a few months ago. Get the fastest processors you can. Anyone know how 10g will be licensed? --- Yep, absolutely no change in licensing for 10g - this from the 10g roadshow that just went through town. So you'll be able to visualise and provision yourself all the way to bankruptcy :-) Ciao Fuzzy :-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
Experiences with Oracle and MS .Net data providers
Hi all, Would really like to hear any feedback regarding anyone comparing these two .Net data providers (or even some of the others out there - Datadirect, etc.). We're at decision making time, and things like the differences in calling stored procs, returning Ref Cursors, are starting to mean we need to pick one. My gut says go with the Oracle one (keep the technology stack based on the one vendor), but they kludge too many things. (just like in ADO, where they ignored the standard for stored proc calling). Anyway, any comments about your use, likes and dislikes of either would be much appreciated. Ciao Fuzzy :-) -- The contents of this post are my opinions only If swallowed seek medical advice -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Local connect to database (default connection)
VirVit, Looks to me like ORACLE_SID isn't specified in your windows environment. Check the registry under HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\HOME0 for a string key called ORACLE_SID. If it's there, set it to your SID. If it's not, add it and set it to your SID. Alternatively, set an environment variable named ORACLE_SID to your desired SID. Ciao Fuzzy :-) -- The contents of this post are my opinions only If swallowed seek medical advice -Original Message- From: VirVit [mailto:[EMAIL PROTECTED] Sent: Thursday, 20 November 2003 15:40 To: Multiple recipients of list ORACLE-L Subject: Local connect to database (default connection) Hello! I have next problem: I've setup Listener and TNS Names and I can connect to database but only when SID is specified. I want to specify default database to connect to. D:\Backup\oraclesqlplus cheques/cheques SQL*Plus: Release 9.0.1.3.0 - Production on ? 20 08:33:55 2003 (c) Copyright 2001 Oracle Corporation. All rights reserved. ERROR: ORA-12560: TNS:protocol adapter error D:\Backup\oraclesqlplus cheques/[EMAIL PROTECTED] SQL*Plus: Release 9.0.1.3.0 - Production on ? 20 08:34:56 2003 (c) Copyright 2001 Oracle Corporation. All rights reserved. Connected to: Oracle9i Enterprise Edition Release 9.2.0.4.0 - Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.4.0 - Production -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
Oracle shared object files on Solaris, and ELF class.
Hi all, Looking for possible causes for a ELFCLASS64 version of /oracle/product/8.1.7/lib/libobk.so accidentally cropping up for a 32-bit install. This was on a client site ... so some details I can't disclose ... but it's a clean 8.1.7.0.0 install under Solaris (8 I think). Caused the client shadow process to bomb out with a fatal error (Looked like this in the trace file dlopen gets error 'ld.so.1: ora_s000_ORCL: fatal: /u01/app/oracle/product/8.1.7/lib/libobk.so: wrong ELF class: ELFCLASS64 ' when opening object ) Failing that, does anyone know of a utility that can check the elf class of .so files under Solaris? A google (and search on sun.com) for such a beast drew a blank. Thanks Fuzzy :-) -- The contents of this post are my opinions only If swallowed seek medical advice -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: OT (DB2)
-Original Message- From: Robertson Lee - lerobe [mailto:[EMAIL PROTECTED] Sent: Wednesday, 12 November 2003 00:45 To: Multiple recipients of list ORACLE-L Subject: OT (DB2) Hi, Anyone out there who used to be subscribed to the DB2-L listserv. Since it moved hosts, I have received no more emails and cannot register for the new one. Regards Lee Lee, it's definitely up and running, and Phil (Gunning) said that existing subscriptions had migrated. Here's the footer from current messages - might help troubleshoot your subscription. Welcome to the IDUG DB2-L list. To change your subscription options or subscribe or to cancel your subscription, visit the IDUGDB2-L archives webpage at http://www.idugdb2-l.org/archives/db2-l.html. From that page select Join or Leave the list. The IDUG List Admins can be reached at [EMAIL PROTECTED] Ciao Fuzzy :-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: [OOT] digest
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, 31 October 2003 13:44 To: Multiple recipients of list ORACLE-L Subject: [OOT] digest dear Palls, how could I join thi mailing list with digest mode ? best regards, édy kurniawan The ListGuru server seems to accept most Listserv-compatible commands. So, send a message to [EMAIL PROTECTED] (... not to [EMAIL PROTECTED]), with the following command in the body set ORACLE-L DIGEST (That assumes you are already subscribed to the list). Ciao Fuzzy :-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: MSSQL Link Server connection failure to Oracle 817
-Original Message- From: Denham Eva [mailto:[EMAIL PROTECTED] Sent: Tuesday, 28 October 2003 22:09 To: Multiple recipients of list ORACLE-L Subject: MSSQL Link Server connection failure to Oracle 817 Hello, To my surprise I see there alot of us on this list, use MSSQL and Oracle in the same environment. Guilty. (I promise I won't mention DB2 as well) So please forgive me for asking this but it is a huge issue here at my work. The problem is like this, we have a MSSQL 2000 box connecting to Oracle 817, via Linked servers using OLEDB. The jobs will run fine for awhile, but then suddenly fail with the following error Executed as user: TFMC\Administrator. OLE DB provider 'MSDASQL' reported an error. [SQLSTATE 42000] (Error 7399) Driver's SQLSetConnectAttr failed] [SQLSTATE 01000] (Error 7312) OLE DB error trace [OLE/DB Provider 'MSDASQL' IDBInitialize::Initialize returned 0x80004005: ]. [SQLSTATE 01000] (Error 7300). The step failed. OK, this is specifically the MS driver being used here, but when Oracle drivers are used, we have the same issues. Both Databases are on HP/Compaq servers, and the Windows 2000 platform. I have loaded the newest patches for OLEDB on the MSSQL for the Oracle Client, but nothing helps. Has anyone experienced this issue before? Denham, From my experience, you're in for a torrid time. The 0x80004005 error is returned from the Win32 load library call (can't remember the exact method name, but basically it's the standard load this DLL call). 0x80004005 means ... wait for it ... FAILED. That's it. That's all MS wrote for this error. As you can see from your error dump, the ::Initialize method was being called, which implicitly loads the provider (and thus the DLL). The other thing I notice from your error is that you are NOT using the MS or Oracle native providers. You are using the OLEDB to ODBC bridge (MSDASQL ... instead of MSDAORA or OraOLEDB). This is a dog's breakfast. Try changing to whichever of the other two you haven't tried, and see if the error persists. Ciao Fuzzy :-) -- The contents of this post are my opinions only If swallowed seek medical advice -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: dba interview questions
-Original Message- From: Mladen Gogala [mailto:[EMAIL PROTECTED] Sent: Wednesday, 29 October 2003 05:44 To: Multiple recipients of list ORACLE-L Subject: Re: dba interview questions How about Life of Brian? That's even better then the Holy Grail. You're right, Mladen ... because we're all individuals. Ciao Fuzzy :-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: anyone have opinions on the future of the 'grid'?
Title: RE: anyone have opinions on the future of the 'grid'? Oracle confirmed at the road show event I went to yesterday that "pricing will not change". Let's see how many people are happy to buy 100's of EE CPU licences :-) And my favourite bit? The new OEM is all singing, all dancing ... but must be hosted by 10gAS. (Though that's probably the case with EM under 9i .. just don't use it often enough to know). Ciao Fuzzy :-) --The contents of this post are my opinions only If swallowed seek medical advice -Original Message-From: Whittle Jerome Contr NCI [mailto:[EMAIL PROTECTED]Sent: Wednesday, 29 October 2003 03:00To: Multiple recipients of list ORACLE-LSubject: RE: anyone have opinions on the future of the 'grid'? Oracle will probably think so with their per CPU pricing. Jerry Whittle ASIFICS DBA NCI Information Systems Inc. [EMAIL PROTECTED] 618-622-4145 -Original Message- From: AK [SMTP:[EMAIL PROTECTED] S Does it mean that a network with 100 computers of 1 cpu each is almost equivalent to 100 cpu giant computer ?? -ak
RE: starting/stopping DB2
-Original Message- From: Jonathan Gennick [mailto:[EMAIL PROTECTED] Sent: Wednesday, 29 October 2003 10:49 To: Multiple recipients of list ORACLE-L Subject: starting/stopping DB2 Does anyone here use DB2? I need a bit of an education on how to start and stop DB2 under Windows XP. If you can help, please contact me offlist. Thanks. Best regards, Jonathan Gennick (apologies for the heresy, everyone. My mail server seems to have a problem with Jonathan's address) Jonathan, You can use the services control panel to start and stop the database instance(s), and the administration instance. The default database instance is usually called DB2 - DB2 under version 7.x, and a similar name under v8.x. The admin instance is usually called DB2 - DB2DAS00 (under v8.x it has a slightly different name that escapes me right now). You can also use the start and stop scripts from the DB2 command environment. db2start and db2stop for the database instance that matches your current environment settings (DB2INSTANCE env var, similar to your SID env var for Oracle), and db2admin start / db2admin stop for the admin instance. You may also have the java applet server, licencing server, governor, and warehouse servers running (depending on what version you installed). Let me know if you need help with these. Ciao Fuzzy :-) -- The contents of this post are my opinions only If swallowed seek medical advice -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Oracle pricing ain't going down
-Original Message- From: Rothouse, Michael [mailto:[EMAIL PROTECTED] Sent: Monday, 27 October 2003 00:04 To: Multiple recipients of list ORACLE-L Subject: RE: Oracle pricing ain't going down I realized in my hasty response that I failed to complete my thought/question. My response should have been: IOT and clustered indexes are not comparable to each other. Are they? As you mention, by definition they do appear similar. I originally thought more about how they are used as it appears (from my experiences anyway) that clustered indexes are utilized more frequently in SQL Server/Sybase than IOTs in Oracle. I too am curious as to when it is an advantage or disadvantage to utilize an IOT. I read somewhere that IOTs are best suited for lookup tables. Tables with a large number of columns are not a very good IOT candidate. I'm just not experienced enough in understanding why that is. Given I threw up the little list, I'll throw in my two cents. My understanding of the difference between Oracle IOTs and SQL Server tables with clustered indexes is as follows. Oracle IOT: (Quoting Oracle SQL Syntax guide) Oracle maintains the table rows (both primary key column values and nonkey column values) in an index built on the primary key. Which to me means the IOT structure contains complete rows in all blocks of the index structure - root block, branch blocks, leaf blocks. (I'm willing to be corrected here ... in fact, I'd like someone to :-) ). SS table w. clustered index: A SQL Server clustered index builds a standard b-tree structure for the root and branch pages, but leaf pages are the actual data pages themselves (a page in SS2000 is eight 8kB extents), rather than pointers to the data pages (as per a standard index). As such, only the leaf pages contain complete data rows. A minor difference, but a difference none the less. Any criticisms welcome (it's a Monday, and the coffee has run out. Believe me, nothing you say can affect me now :-) ). Ciao Fuzzy :-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Oracle pricing ain't going down
[ .. snip snip ..] Sorry, correcting my own transposition (a page in SS2000 is eight 8kB extents) That should have read an extent is eight 8kB pages in SS2000. I'll go back to my cave, now. Ciao Fuzzy :-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Oracle pricing ain't going down
-Original Message- From: Ryan [mailto:[EMAIL PROTECTED] Sent: Friday, 24 October 2003 12:44 To: Multiple recipients of list ORACLE-L Subject: Re: Oracle pricing ain't going down what is MSEE lacking in? sound of can of worms opening Here's a start. MSSQLServer EE has ... No bitmap indexes, no partitioned indexes, no function-based indexes, no domain indexes, no reverse key indexes, no object tables, no before triggers (can be kludged, not pretty), no multiple actions per trigger event, no 3rd-party language support a la Oracle's JVM and pro*... modules, no built-in OLAP (it's a weird bolt-on), no control over extent size, no control over block size, no star query optimisation, no sequences, no synonyms, no packages, no structured exception handling in stored proc language (TSQL), no MINUS union operator, no multiplexing or mirroring of log files, no cyclical log management, no escalation-free locking, no index organised tables. (Working with both every day, do you get the feeling I've been asked this before? :-)) Half of those things are available in Oracle SE One :-) Ciao Fuzzy :-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Boolean dates...
-Original Message- Sent: Thursday, 23 October 2003 01:39 To: Multiple recipients of list ORACLE-L I think what your boss really means is 'julian' date. Does he also want his database in mauve? - Nice Dilbert reference, Jared. One of my favourites ... stuck prominently on my wall. Ciao Fuzzy :-) -- The contents of this post are my opinions only If swallowed seek medical advice -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Mauve databases use least RAM
-Original Message- From: Mladen Gogala [mailto:[EMAIL PROTECTED] Sent: Thursday, 23 October 2003 06:00 To: Multiple recipients of list ORACLE-L Subject: Mauve databases use least RAM I just received Effective Oracle by Design and reading the foreword I noticed not only the familiar names of Connor McDonald, Anjo Kolk and Mogens Norgaard, but I also saw this list mentioned explicitly. Is Mr. Tom Kyte a member of this list? Does he read it? Does his staff read it? I was wandering why so few oracle employees (to my knowledge, Vladimir is the only one) takes part in this list. Mladen Gogala Oracle DBA At the risk of opening old wounds, after what happened with Howard Rogers, I think it's a brave Oracle employee who participates in extra-curricular activities that involve the products of their employer. We are richer for it when it happens (thanks Pete, Vladimir), but I don't blame anyone at Oracle for their discretion. Ciao Fuzzy :-) (And yes, I can give you a dissertation on how the work-for-hire doctrine under Australian copyright and employment law works. Whether or not this leads you to form the same abuse of process conclusions against Oracle as I did, is entirely a matter for the reader :-) ). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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 Pull Second Row from 100 ROWS
-- The contents of this post are my opinions only If swallowed seek medical advice -Original Message- From: Muqthar Ahmed [mailto:[EMAIL PROTECTED] Sent: Wednesday, 22 October 2003 06:44 To: Multiple recipients of list ORACLE-L Subject: How To Pull Second Row from 100 ROWS Hi, Is there a way to pull ONLY 2nd row from the selected rows. Thanks Muqthar Ahmed DBA Others have shown the proprietary Oracle way. Assuming your instance has the necessary plumbing, you can use the OLAP approach ... which also happens to transport to other RDBMS. SELECT a.blah, a.blahblah ... FROM ( SELECT ROW_NUMBER() OVER (blah) AS row_number, blah, blahblah FROM your table [where ...] ) a WHERE a.row_number =2; Enjoy! Ciao Fuzzy :-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: SQL Operation and Row size
-Original Message- From: Stephane Faroult [mailto:[EMAIL PROTECTED] Sent: Thursday, 16 October 2003 07:14 To: Multiple recipients of list ORACLE-L Subject: Re: SQL Operation and Row size Daniel Fink wrote: When retrieving data, does Oracle place just the columns of interest into the result set or does it place the entire row in the result set (and filter out the columns of interest later)? I'd say just the columns of interest. Can be checked by looking at the number of buffer gets on a table with some noticeable chaining, comparing select * to select pkcol. Following on from this, I've always been curious where result sets that include computed or literal values get stored. It's not possible to cache the block of something that was never in a block to begin with (though I'm willing to be corrected on that :-)). Would it be a temp segment created for just the computed/literal values; temp segments for the whole result set; somewhere in UGA/PGA; or somewhere else entirely? Any light shed on this would satisfy my curiosity. Ciao Fuzzy :-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: 8.1.7 Support Extension?
-Original Message- From: Mercadante, Thomas F [mailto:[EMAIL PROTECTED] Sent: Thursday, 16 October 2003 02:24 To: Multiple recipients of list ORACLE-L Subject: RE: 8.1.7 Support Extension? Man! I'm gonna have to migrate off of my IBM PCJr. Tom, relax ... just choose the obvious Strategic Platform :-) Microsoft Windows 98 Ciao Fuzzy :-) -- The contents of this post are my opinions only If swallowed seek medical advice -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
Perl DBI and Activestate 5.8.0
I seem to remember there were issues with DBI, DBD::Oracle and activestate 5.8.x distros. Can anyone (Jared?) remind me of any gotchas? (I've tried the list archive, but can't get through at the moment). Platform is win2003, 9iR2. Ciao Fuzzy :-) -- The contents of this post are my opinions only If swallowed seek medical advice -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Physical I/O and databases other than oracle
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Friday, October 03, 2003 3:15 AM To: Multiple recipients of list ORACLE-L Subject: Re: Physical I/O and databases other than oracle my email states that in oracle this isnt true. HOWEVER, what about other databases? At the risk of trivialising things, there are basically no differences with other databases. It's a question of how quickly the DBA community for a given database has woken up to the fact that BCHR is a rarely-useful measure. For instance, the DB2 people worked this out a long time ago (though they still focus heavily on buffer pool tuning, as many of them genuinely have physical i/o issues with the huge batch jobs they run). As for the SQL Server people, the light is only just starting to dawn. 90% or more of the performance posts to the sql2k list (see www.sswug.com) start with My windoze box has 2GB of RAM, and my instance has 99.999% hit ratio, but performance is still a dog. Help me add more memory. Gentle attempts at suggesting they attempt to find the real culprit, rather than guess, are howled down in the stamped of the hit ratio mob. Ciao for now Fuzzy (It's good to be back) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Oracle to MSSQL conversion?
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Wolfe Stephen S GS-11 6 MDSS/SGSI Sent: Thursday, July 31, 2003 22:05 To: Multiple recipients of list ORACLE-L Subject: RE: Oracle to MSSQL conversion? SNIP What would be the point of installing two SQL Server servers on the same box? Similar to setting up 2 or more instances on one host? No point that I can think of, I just know it can be done. Timothy described one reason - differing sort orders, which also can imply differing code pages/character sets ... sometime a reason for having multiple Oracle instances as well. Another reason for having multiple SQL Server instances is differing security models. SQL server can operate with windows authentication only, or combined windows authentication and traditional username/passwords managed by the server. For those with strict security needs, some people run a separate instance configured to allow mixed authentication for off-the-shelf apps that can't be changed. This would be analogous in Oracle to having one instance that only allowed global or external authentication, and another that allowed those as well as normal Oracle logins. Ciao Fuzzy :-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Oracle to MSSQL conversion?
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Wolfe Stephen S GS-11 6 MDSS/SGSI Sent: Thursday, July 31, 2003 19:09 To: Multiple recipients of list ORACLE-L Subject: RE: Oracle to MSSQL conversion? I think I understand what you have said, Oracle runs an instance per database where MSSQL is one instance running multiple databases. Is this right thinking? Yep, spot on. Ciao Fuzzy :-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Oracle to MSSQL conversion?
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Boivin, Patrice J Sent: Thursday, July 31, 2003 12:59 To: Multiple recipients of list ORACLE-L Subject: RE: Oracle to MSSQL conversion? I have a question re. these conversions... If an Oracle database has 120 tablespaces, how does that translate in MSSQL speak? The closest analogy is Filegroups. Serve very similar purpose (to abstract the physical storage), but aren't quite as sophisticated (no surprises there) (One of the tablespaces is USERS, home of dozens of schemas; the others are either RB, SYSTEM, TEMP or application tablespaces) How many separate schemas-tablespaces can MSSQL hold per server? No practical limit on schemas, don't know about Filegroups. Be warned that some people will try to convince you an Oracle schema equates to a SQLServer database. They're talking rubbish. A schema is a schema in both. Ciao Fuzzy :-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Oracle to MSSQL conversion?
Maybe now is a good time for me to ask these question since it is related to this thread's subject, can you say that an Oracle instance is essentially the same as a MSSQL database? I ask this because a MSSQL server can support multiple databases which can be configured different ways. But there are more things that the SQL Server database has controlled by its instance than things it can set itself (e.g. performance parameters, security settings, user sort space, processor affinity, connection handling etc. etc. are all instance settings). It's more accurate to say that an Oracle instance is closer to a SQL Server instance than a database, but is by no means exactly the same. Oracle just doesn't have the concept of multiple database support in one instance (and I mean database, not schema). That's not necessarily a bad thing, just means they are different to SQL Server (and DB2, Informix, Sybase and others which all have this). I'll stop there ... enough people on the list have heard my rant about this before :-) Ciao Fuzzy :-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Emacs on SQLPlus, er uh... SQLPlus on emacs.
LOL--I'm the sole ultraedit fan in a den of textpad users have had many conversations that start with the phrase yeah, but can your editor do this I was of the opinion that they were pretty much equal until someone (Dennis Williams?) wrote in reminding me of ue's ability to open/edit/save a file on a remote host via ftp. It appears that tp does that only w/a supporting batch file (yuck!). Imagine my delighted cackling, having proven once and for all that ue is the one true windows text editor... 8^) It's never been an issue for me ... tightVNC being the wonderful beast it is, I've gotten used to in-place editing through a vnc session. Big benefit being that a dropped session can be picked up again ... not easy if your FTP transfer fails :-). That said, I can see the benefits of bringing the mountain to you :-) Ciao Fuzzy :-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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 German here ? Character set
Title: Any German here ? Character set I'd recommend WE8ISO8859P15 (I think that's it) ... the difference is Euro support! Ciao Fuzzy :-) -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Goulet, DickSent: Wednesday, July 30, 2003 15:29To: Multiple recipients of list ORACLE-LSubject: RE: Any German here ? Character set WE8ISO8859P1, supports most western europe needs. Dick GouletSenior Oracle DBAOracle Certified 8i DBA -Original Message-From: NGUYEN Philippe (Cetelem) [mailto:[EMAIL PROTECTED]Sent: Wednesday, July 30, 2003 10:04 AMTo: Multiple recipients of list ORACLE-LSubject: Any German here ? Character set Hi List, could you please tell me wich Character Set you are using in your database ? Thank in advance! Philippe
RE: Emacs on SQLPlus, er uh... SQLPlus on emacs.
Hi I use vi on Unix and textpad on windoze. I like to write macros for vi so it types repetitive code for me...:-), although I should probably use an editor with more powerful macro facilities. cheers Pete Pete! Another textpad fan ... way to go! An outstanding text editor for windows (even better than ultraedit in my opinion) Ciao Fuzzy :-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Number of processors and standard edition
My memory is 4 ... and with typical Oracle Licensing Shennanigans attached ... I remember a few cases from 2001 where clients where arguing whether SE could be licenced for up to and including 4, or up to but not including 4. But given that's a two-year-old memory, I can pretty much guarantee Oracle licencing has changed 28 times since then :-) Ciao Fuzzy :-) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Farnsworth, Dave Sent: Tuesday, July 29, 2003 18:04 To: Multiple recipients of list ORACLE-L Subject: Number of processors and standard edition I am trying to find any info on if there is a maximum number pf processors that a server can have and have Oracle standard edition run on it. Just looking to see if there is a cutoff point in the number of processors where I would be forced to go to Enterprise Edition of Oracle 8i.. I'm looking through the concepts docs but have not yet found this info. Thanks, Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: ODBC Patch 8.1.5.7 where to download
Title: ODBC Patch 8.1.5.7 where to download technet.oracle.com. Follow the download links. Ciao Fuzzy :-) -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of [EMAIL PROTECTED]Sent: Friday, July 18, 2003 15:49To: Multiple recipients of list ORACLE-LSubject: ODBC Patch 8.1.5.7 where to download Hi list, I need Oracle Patch 8.1.5.7 for ODBC Driver. I haven't found it on metalink. Could someone please send me a mail with this patch or direct me to a download location? TIA regards Volker Schoen E-Mail: [EMAIL PROTECTED] http://www.inplan.de
RE: SHOW ERRORS not working
This used to get me all the time. I'm pretty sure you need to issue SET SERVEROUTPUT ON; to see the output. Ciao Fuzzy :-) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Farnsworth, Dave Sent: Monday, July 21, 2003 16:45 To: Multiple recipients of list ORACLE-L Subject: SHOW ERRORS not working I have a developer that has ALTER ANY PROCEDURE rights. He changes a procedure, then compiles it and it says there are errors. But when he does a SHOW ERRORS in SQPlus, it shows nothing. If I do the same thing I can see the errors from the compiled procedure. I assume this is a permissions thing but have not been able to figure this one out. Anyone have any ideas on this? Thanks, Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: SHOW ERRORS not working
Nope, in fact this is a good example of my failure to read the whole question before replying. I thought Dave said no output was showing ... but he really said no errors were showing after the response that there were errors. My bad. I blame the fact it's Monday :-) I think the other suggests on user_errors etc. are on the right track. Ciao Fuzzy :-) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of [EMAIL PROTECTED] Sent: Monday, July 21, 2003 17:44 To: Multiple recipients of list ORACLE-L Subject: Re: RE: SHOW ERRORS not working you sure? Ive noticed this before. SHOW ERRORS is a function. Do you know where its created? you can find the code and then just craete the show errors function? might be in sql.bsq From: Grant Allen [EMAIL PROTECTED] Date: 2003/07/21 Mon PM 12:24:24 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: SHOW ERRORS not working This used to get me all the time. I'm pretty sure you need to issue SET SERVEROUTPUT ON; to see the output. Ciao Fuzzy :-) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Farnsworth, Dave Sent: Monday, July 21, 2003 16:45 To: Multiple recipients of list ORACLE-L Subject: SHOW ERRORS not working I have a developer that has ALTER ANY PROCEDURE rights. He changes a procedure, then compiles it and it says there are errors. But when he does a SHOW ERRORS in SQPlus, it shows nothing. If I do the same thing I can see the errors from the compiled procedure. I assume this is a permissions thing but have not been able to figure this one out. Anyone have any ideas on this? Thanks, Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Estimating User Load on the system
I'll add my favourite - and currently overlooked - point. Network. Not the entire network as a whole, but specific server things like NIC performance, protocol stack performance, MTU (see recent excellent post by Matt on jumbo frames), and all that jazz. my 2¢ Ciao Fuzzy ;-) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of DENNIS WILLIAMS Sent: Monday, July 14, 2003 17:49 To: Multiple recipients of list ORACLE-L Subject: RE: Estimating User Load on the system Raj I'll second Jared's idea. Don Burleson in his book Oracle9i High-Performance Tuning with STATSPACK makes a strong point that looking at system load must start with the underlying system. Any look at Oracle performance must begin with an understanding of what the system load was at that time. As Jared points out, the three components are CPU, I/O, and memory. For example, you may find that one of these target users is the high CPU consumer from an Oracle perspective at a point in time. Now, if you discovered the system CPUs weren't being taxed at that time your conclusions might be different than if you discovered the system CPUs were pegged at 100% at that time. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, July 14, 2003 10:19 AM To: Multiple recipients of list ORACLE-L Load on a system is in general comprised of three components: CPU, memory and IO. If you have something in place to track those on a per user basis, then you're doing well. You might consider also tracking other users, so that you have a basis for comparison. Jared On Monday 14 July 2003 07:04, Jamadagni, Rajendra wrote: I have been asked to compute the load put on the system by a 'select group of userids'. I know these users and have put something in place where I sample periodically following 1. session stats 2. session io 3. system stats 4. number of sessions 5. v$transaction Am I missing something? Has anyone done this before? If so, what have you computed ? TIA Raj -- - - Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: LISTENER ON LINUX
use ps -lax instead Ciao Fuzzy :-) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Seema Singh Sent: Friday, July 11, 2003 17:20 To: Multiple recipients of list ORACLE-L Subject: LISTENER ON LINUX Hi When I try to see listener process on Linux box by ps -ef |grep tns .It doen't show but when I tried to see the status thru lsnrctl status listener_name .its shows service handler. How to check whether listener is running or not and how to start that? thx -seema _ STOP MORE SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: ER Tools (was: erwin)
SDesigner became PowerDesigner when Sybase bought/rebranded things. There's an open source product I've been testing ... DBDesigner by fabForce. Not too bad, but I haven't really stretched it so far. www.fabforce.net Ciao Fuzzy :-) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Luis deUrioste Sent: Monday, July 07, 2003 22:19 To: Multiple recipients of list ORACLE-L Subject: RE: ER Tools (was: erwin) There was a Tool I used in the past, Sdesigner, simple to use. Also if all you need is an older version of Designer, what you could always do is buy one of the books that bundle with a copy of developer 2.1 or 6i. -Original Message- Sent: Monday, July 07, 2003 1:29 PM To: Multiple recipients of list ORACLE-L Anyone care to ballpark a $$$ on the registered version of ERwin? I'm guessing it's expensive, and Computer ASSociates doesn't exactly trip my trigger. I'm trying to find a low-cost ER tool in order to get some simple data modeling done. So far, this is what I've found (VERY briefly): 1) Visio. Needs Enterprise edition. The UI is a pain, as far as I'm concerned. Pain, pain, pain. Cheapest viable option so far at less than $500/user. It can be used for more than just data modeling. 2) Oracle 9iDS. Hugely bloated. Relies on a 3GB (minimum) repository for some stupid reason. Apparently can't buy just Designer, which is all we need. Difficult to get started (concepts and management of workspace, container). Slow on a 2.4Ghz PC w/512MB RAM, although this may be due to me having to create the [EMAIL PROTECTED] repository DB on the same PC. Very comprehensive, though, from what I've seen. Can't access drawings from the OS, since they're (probably) in the repository. 3) No freeware tools such as dia, VisioModeler (pre-MS version of Visio), OpenOffice, or Koffice seemed to be able to draw crow's foot diagrams. 4) Sybase PowerBuilder. Didn't check out the download yet, although a demo of an older version (v6) seems like it would work. Not impressed with Sybase in general and it's probably in the $1Ks/user. 5) Data Architect from TheKompany.com only does physical modelling and their Kivio product doesn't seem to support crow's foot. 6) DeZign from datanamic.com. Haven't downloaded the demo yet, but the single screenshot looks promising. And at $149/user or $119/user for 10 licenses, I'm hoping... I've been looking thru past messages found on orafaq.com (better searching than fatcity.com) and this is the majority of what I've been able to find. Anyone have more to add? Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- From: Jay Wade [mailto:[EMAIL PROTECTED] Sent: Monday, July 07, 2003 9:49 AM To: Multiple recipients of list ORACLE-L Subject: Re: erwin hello: The below has info about the product: http://www3.ca.com/Solutions/Product.asp?ID=260 The below has the download link: http://www3.ca.com/Solutions/Collateral.asp?CID=33655ID=260 From: [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: erwin Date: Mon, 07 Jul 2003 04:54:25 -0800 How can I found a trial version of erwin Danke... Arslan. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Luis deUrioste INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting
RE: Sybase to Oracle
Yep, it's certainly possible. And from both ends. You can use the Oracle Transparent Gateway product, or the equivalent Sybase gadget (its name escapes me at the moment). Really depends from which end you wish to do the driving. Ciao Fuzzy :-) -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Jay Krishnan RSent: Tuesday, July 08, 2003 11:39To: Multiple recipients of list ORACLE-LSubject: Sybase to OracleDear All I have a small doubt regarding Sybase-Oracle data transfer. Is it possible to transfer data online from Sybase to Oracle. Any info on the same would be highly appreciated. Thanks in advance. Best RegardsJay
RE: WHY IT DOES NOT WORK == rman target / as sysdba THANKS
You always connect as a sysdba privileged user when using RMAN ... so just
issue
rman target /
(or rman target / nocatalog if you're not using a catalog)
(Wow! I answered an RMAN question ... and I knew nothing about it 12 months
ago)
Ciao
Fuzzy
:-)
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of
Roger Xu
Sent: Friday, June 27, 2003 16:25
To: Multiple recipients of list ORACLE-L
Subject: WHY IT DOES NOT WORK == rman target / as sysdba THANKS
bigtex:oraadm 7% rman target / as sysdba
Argument Value Description
--
---
target quoted-string connect-string for target database
catalog quoted-string connect-string for recovery catalog
nocatalognone if specified, then no recovery catalog
cmdfile quoted-string name of input command file
log quoted-string name of output message log file
tracequoted-string name of output debugging message log file
append none if specified, log is opened in append mode
debugoptional-args activate debugging
msgnonone show RMAN- prefix for all messages
send quoted-string send a command to the media manager
pipe string building block for pipe names
timeout integernumber of seconds to wait for pipe input
--
---
Both single and double quotes (' or ) are accepted for a
quoted-string.
Quotes are not required unless the string contains embedded
white-space.
RMAN-00571:
===
RMAN-00569: === ERROR MESSAGE STACK FOLLOWS
===
RMAN-00571:
===
RMAN-00552: syntax error in command line arguments
RMAN-01005: syntax error: found identifier: expecting one
of: append, at, auxiliary, catalog, cmd
file, clone, debug, log, msglog, mask, msgno, nocatalog,
pipe, rcvcat, slaxdebug, send, target, time
out, trace
RMAN-01008: the bad identifier was: as
RMAN-01007: at line 0 column 4 file: command line arguments
bigtex:oraadm 8% rman target system/manager
Recovery Manager: Release 9.2.0.3.0 - 64bit Production
Copyright (c) 1995, 2002, Oracle Corporation. All rights reserved.
connected to target database: DV2 (DBID=3650624848)
RMAN exit
Recovery Manager complete.
bigtex:oraadm 9% sqlplus / as sysdba
SQL*Plus: Release 9.2.0.3.0 - Production on Thu Jun 26 16:20:02 2003
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected to:
Oracle9i Enterprise Edition Release 9.2.0.3.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.3.0 - Production
SQL show user
USER is SYS
SQL exit
Disconnected from Oracle9i Enterprise Edition Release
9.2.0.3.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.3.0 - Production
bigtex:oraadm 10%
Roger Xu
Database Administrator
Dr Pepper Bottling Company of Texas
(972)721-8337
__
__
This email has been scanned for all viruses by the MessageLabs Email
Security System. For more information on a proactive email security
service working around the clock, around the globe, visit
http://www.messagelabs.com
__
__
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Roger Xu
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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.net
--
Author: Grant Allen
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
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: ADO and bind variables (was RE: Performance improvement required :-))
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Pardee, Roy E Sent: Friday, June 13, 2003 20:10 To: Multiple recipients of list ORACLE-L Subject: ADO and bind variables (was RE: Performance improvement required :-)) This is interesting--if I use ADO with the ODBC provider (as the code does below), I get the same results. But if I use just ADO (that is, ms' OLE DB provider for oracle (MSDAORA.1)) then I don't get bind vars. (I'm doing INSERTs in my code, not SELECTs). I wonder if oracle's native OLE DB provider works any differently--I would bet that it does... Cheers, -Roy Roy, I tried with the Oracle provider (OraOLEDB.Oracle.1), and the bind variables work. Another reason to stick with the Oracle provider :-) Ciao Fuzzy :-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: DBLink to SQL Server problem
It's more accurate to say SQL Server *can be* case sensitive ... or not, as desired and configured. The kicker is as you describe ... if it's set to be case sensitive instead of insensitive, all object names, column names, etc. are treated that way, not just strings in char, varchar and similar fields. Ciao Fuzzy :-) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Igor Neyman Sent: Wednesday, April 02, 2003 16:19 To: Multiple recipients of list ORACLE-L Subject: Re: DBLink to SQL Server problem Dave, SQL Server is case-sensitive, when it comes to table names, column names. When stored in SQL Server data dictionary, they aren't converted into upper-case, as it is with Oracle (unless you use quotes around names). So, try to use the exact case when specifying field names (as they are stored in SQL Server data dictionary). Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, April 02, 2003 9:34 AM I created a DBLink to a SQL Server database following DocID: 114820.1. It seemed to work fine until I tried a real query. If I do something like a SELECT COUNT(*) or SELECT * it works fine; tdispach select count(*) from [EMAIL PROTECTED]; COUNT(*) - 1207 But if I try to select on a specific field or have a WHERE clause specifying a filed I get this; tdispach select mpp_id from [EMAIL PROTECTED]; select mpp_id from [EMAIL PROTECTED] * ERROR at line 1: ORA-00904: invalid column name I know that the column name is correct so something else is not translating properly. I tried a fully qualified column name of MANPOWERPROFILE.MPP_ID and that got the same error. I don't see any setting in my DSN that could effect this. Anyone have any ideas, hunches or clues? Thanks, Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Igor Neyman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Oracle encouraging Linux software developers
IBM is loudly touting how much money they will be spending on Linux. Has anyone seen any sales statistics for DB2 on non-IBM platforms? I feel that IBM has a challenge to convince buyers to consider DB2 on Linux. Dennis Williams DBA, 40%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] Dennis, Humourously ... at least in Oz, the number one Unix platform for DB2 is Solaris. IBM will probably turn this around ... they are being quite clever with the 5L releases of AIX, by enabling compatibility with both AIX and Linux binaries. So they feed you a little Linux box, wait for you to decide you need something bigger, ease you on to an AIX 5L box still running your linux code (but now you're paying AIX licencing), and then roll in with the usual IBM steamroller. That said, I've just had a free 3-day training course from them, so nothing like biting the hand that feeds, so to speak :-) Ciao Fuzzy :-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Oracle connection through Crystal Reports
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Juan Antonio Félix Sarabia Sent: Thursday, March 27, 2003 21:49 To: Multiple recipients of list ORACLE-L Subject: Oracle connection through Crystal Reports Hi All. I´m trying to connect to a oracle database 8i for using it with crystal reports 9. I have win2000 professional, I tried to use 'CR Oracle ODBC Driver 4.10' but it appears a error system with the number 126 when i try to do a test connection. The message is something like that 'can´t load driver ...'. I tried to use 'More Data Sources' option in Crystal reports but it not appears the option to choose an oracle data source. I have installed oracle SQL *Net Client 2.3.2.1.6A because i use Oracle developer 2000. would somebody help me please ? Thanks. Juan, Your crystal reports bin directory (or equivalent) is probably not on the path. Add it, and it should work. Ciao Fuzzy :-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
Using the /*+ append */ insert hint
Hi all, In a discussion with an Oracle rep last week it was suggested we use the /*+ append */ insert hint to allow some inserts to use direct-path. The suggestion is interesting - the business logic won't have any problems with the limitations this implies. Has anyone had any experience with this hint? Specifically, does anyone know what would happen on Oracle 7.3.x or 8.0.x if I used this (assuming it's supported ... would it silently ignore the hint if not supported?) Thanks Fuzzy :-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Using the /*+ append */ insert hint
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Connor McDonald Sent: Monday, March 17, 2003 13:34 To: Multiple recipients of list ORACLE-L Subject: Re: Using the /*+ append */ insert hint APPEND came in at 8.0 so it will work there. The hint can be very useful, but it works best with unindexed tables (that are set to NOLOGGING). If tables are indexed, then you still might get some benefit but the gains are not as dramatic. Of course, anything in NOLOGGING mode often requires a rethink of your backup strategy. hth connor Thanks Connor (and Darrell in the previous post). Connor, I saw a post that suggested you might be heading back to Oz - is that true? Ciao Fuzzy :-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Using the /*+ append */ insert hint
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Toepke, Kevin M Sent: Monday, March 17, 2003 13:24 To: Multiple recipients of list ORACLE-L Subject: RE: Using the /*+ append */ insert hint From experience, do not use the APPEND hint for singular inserts. You will get tons of wasted space. Only use it for bulk inserts such as INSERT INTO .. SELECT FROM, sqlldr, PL/SQL bulk inserts and the like. Converting from buld inserts without the append hint to bulk inserts with the append hint, I've seen as much as a 50% reduction in execution time. That's pretty much what we're targeting. Bulk inserts using insert ... select ... , possibly in the millions of rows. That kind of speed increase would be good. Ciao Fuzzy :-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Quick question on cursor resource use
Yeah, OK, the 50 figure was just to provoke some responses :-). I'll go ahead and watch the various v$ views as I increase the cursor level, and see if there's anything nasty there (I'm not expecting any problems). Ciao Fuzzy :-) -Original Message- Sent: Tuesday, March 11, 2003 16:50 To: Multiple recipients of list ORACLE-L I wouldn't hesitate to set it to 500 or a even 1000 if your appliation really needs this many. But if you think about 10's of thousands, I would start really looking af the application to understand if it were written correctly. The major memory is not allocated by setting the parameter, but it will be allocated when you actually start opening and using cursors. (I have also seen people increasing it only because the application was buggy and didn't close cursors after use. This is not a good idea) /Bjørn. Grant Allen wrote: -Original Message- WILLIAMS Sent: Monday, March 10, 2003 15:45 To: Multiple recipients of list ORACLE-L Fuzzy What is prompting you to increase OPEN_CURSORS? Is your application currently receiving an error from running out of cursors? Yes, it's returning ORA-01000 - having looked at the SQL, it's perfectly understandable why - a whole bunch of concurrently submitted SQL, with lots of recursive SQL spawned by Oracle to support it. So I'm not complaining about getting the error. I just want some ideas about the resource hit if I up this to 500, 1000, 50? The Oracle architecture stuff was silent on the subject. Ciao Fuzzy :-) -- Bjørn Engsig, Miracle A/S Member of Oak Table Network [EMAIL PROTECTED] - http://MiracleAS.dk -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Quick question on cursor resource use
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of DENNIS WILLIAMS Sent: Monday, March 10, 2003 15:45 To: Multiple recipients of list ORACLE-L Subject: RE: Quick question on cursor resource use Fuzzy What is prompting you to increase OPEN_CURSORS? Is your application currently receiving an error from running out of cursors? Yes, it's returning ORA-01000 - having looked at the SQL, it's perfectly understandable why - a whole bunch of concurrently submitted SQL, with lots of recursive SQL spawned by Oracle to support it. So I'm not complaining about getting the error. I just want some ideas about the resource hit if I up this to 500, 1000, 50? The Oracle architecture stuff was silent on the subject. Ciao Fuzzy :-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: POLL: Database to DBA ratio
[EMAIL PROTECTED] 03/11/03 09:59AM I'm trying to build a case for management that we need additional DBAs so I'd like to take a quick poll if I may. What is the ratio of Oracle databases to DBAs in your shop? This includes development and production databases. At our shop it's 33:1. It fluctates pretty wildly for us depending on the RD effort at any one point in time. But it's not unusual for us to have 50:3, though the 50 are of mixed types (Oracle, DB2, SQLServer etc.) Ciao Fuzzy :-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
Quick question on cursor resource use
Hi all, I'm trying to determine the resource footprint of a cursor - we're fiddling with open_cursors in init.ora, and I want to get an idea of the possible impact on memory, etc., if I bump this up from 100 to 500. As these are allocated per session, I assume they probably consume stack or heap space in the PGA. Anyone know how much, or if there's a basic overhead + variable component based on SQL statement used? Thanks Fuzzy :-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Purely for your amusement
Heh. 6 tables, 2 where statements, one of which is an outer. Gotta love it. I'm thinking of building a tool that intercepts dumb SQL and emails back a raspberry. Whaddya think, is there a market for such a utility? Oh yeah ... I'll buy two copies, so long as I can customise the second one to respond with Data! You don't need no stinkin' data! Ciao Fuzzy :-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: DBV
Jeremiah, [snip] BTW, I can't find any way to tell DBV to verify more than one datafile at a time. Is there? Doesn't look like it. I tried dbv blocksize=8192 file=system01.dbf,tools01.dbf dbv blocksize=8192 file*.dbf dbv blocksize=8192 file=(system01.dbf,tools01.dbf) and a few other variants. It would either barf, or only verify the last file. Of course, I also couldn't get it to give me any command line help, and I'm too lazy to go RTFM ... so wiser minds may know something ... Ciao Fuzzy :-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Performance issue
Hi Lisetrs, I have enough free memory from shared_pool_size and I run stats every week but the BD still shows up the low hit ratio and some times the later full down to 15%! Here is some informations: Are any of the users complaining that their business functions are performing poorly? If not, you should follow these steps 1. Stop looking at hit ratios 2. Go to your local and buy a very good beer (I'd recommend Coopers (Australian) or Leffe (Belgian)) 3. Tell yourself I must learn the benefits of 10046 event tracing 4. Enjoy the beer. (Oh, and if the users are complaining, I'd recommend the same :-) ) Ciao Fuzzy :-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: GRRRRR OWS
LOL Thank you Stephen ... I needed that laugh. Ciao Fuzzy :-) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Stephen Lee Sent: Wednesday, February 19, 2003 21:44 To: Multiple recipients of list ORACLE-L Subject: RE: GR OWS A good website for appropriate telephone technique can be found at www.roydmercer.com Roy D. Mercer is such an inspiration that we even have test databases named ROY and MERCER. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Which is beter a cursor or a for loop?
-Original Message- Sent: 24 February 2003 08:39 To: Multiple recipients of list ORACLE-L Hello, I was just asked by one of our developers which is beter to use:- a cursor or a for loop? I must admit I am not sure humour on That's like asking I have a Porsche. What's the fastest way to make it move ... to push it, or pull it? The answer would have to be neither ... drive the thing the way it's been engineered to perform. humour off If your developers don't understand the power of set-based logic in RDBMS, then now's the time to teach them. (Yeah, OK, depending on the complexity of the 'do lots of database stuff', you might need to resort to cursors or loops. But these shouldn't be the first option!) Just my 2¢ Ciao Fuzzy :-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: RMAN gui...in OEM 9.x i
I will echo Joe's sentiments on knowing the command line. It has the added benefits of not doing things you were unaware of after pushing the 'go' button, as the much better understanding of RMAN you will attain by learning to do it from the keyboard. Jared I'll echo Jared's comments here. I've basically taught myself RMAN this week - all via the console - and don't regret a minute of it. Don't be scared ... you can start with commands as simple as 'BACKUP DATABASE;' and 'RESTORE DATABASE; RECOVER DATABASE;' and build up from there (at least in 9.x). Another advantage of the console is the status messages provided during backup and recovery ... better than watching spinning wheels or an hour-glass in a GUI! Ciao Fuzzy :-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Programming languages that make DBA's lives easier
Now this thread has gone on for a while so its time for my contribution :-). PL/SQL is such a necessary although pedestrian language that its not interesting. Of the scripting languages TCL, PERL, and Python all include facilities for embedding them into other code or adding other code to them. What we should do is mount an Open Source project to embed Perl and TCL into Python so that we could create one large abomination in which any syntax or facility that pleases us could be used. Concealing your intellectual property would be simple. Write whatever suites you at the time, no one, not even you, will be able to figure out what you wrote after you've been away for it a week. A week? All I need is a night at the pub to make my code unreadable ... (mmm, maybe I shouldn't have admitted that in public :-) ) Ciao Fuzzy :-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
RMAN ready or not!
OK, after reading many of the posts on RMAN (Robert Freeman's book is now on the shopping list), I took the plunge and spent all day yesterday hacking away with it. Fun, fun, fun (well, as fun as backups could be). Couple of questions - tablespace backups. If I have a tablespace backup, how portable is this (I realise this is a different kettle of fish to transportable tablespaces, just exploring the possibilities). Could I restore this to a different database? What about restoring it to the same database with missing dependencies (e.g. FK relationships to tables that have since been dropped)? Just tinkering. Ciao Fuzzy :-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Service startup on Windows 2000 fails
Lisa, I'd suggest checking the application log in Windows event viewer - usually contains something even if the on-screen response suggests no error returned. You should see things like Audit trail: ACTION : 'SHUTDOWN' DATABASE USER: '/' PRIVILEGE : SYSDBA CLIENT USER: SYSTEM CLIENT TERMINAL: STUPIDMACHINE STATUS: 0 . and a bunch of PGA instantiation events for SMON, PMON, etc (e.g. Initializing PGA for process RECO in instance stupid1) Given your services are failing, you should see a bunch of errors (whether they're useful is another story ...) If that fails to shed any light, also try the listener log / alert log, and see if there are any tell tale errors there. Ciao Fuzzy :-) (and yes, my windoze box is called STUPIDMACHINE ... that way it knows when I'm talking to it :-) ) -Original Message- Sent: Wednesday, February 19, 2003 14:09 To: Multiple recipients of list ORACLE-L Good morning everyone, Windows 2000 sp3, ver 8.1.7.2 I have NO IDEA what is going on here. I can't start any of the services associated with Oracle, not with my logon, not with local admin, not with a local account with appropriate permissions, nothing. Here's what I've tried: Followed note on metalink stating to add local security policies: Act as part of operating system, increase quotas, log on as batch job, replace a process level token, and rebooted. All logons are part of the administrator and the ORA_DBA group. I am able to log in as each of these local accounts, the accounts are not locked or messed up. I have double-checked the password in the properties tab. Local system account also fails with same error. Here's the error I receive when I try to manually start the listener service: Could not start the OracleOraHome81TNSListener service on Local Computer. The service did not return an error This could be an internal Windows error or an internal service error. If the problem persists, contact your system administrator. I am clueless and so is the sysadmin. I am just thankful this is a test system instead of production... I know next to nothing about windows. Any suggestions would be helpful. Thanks Lisa Koivu Oracle Database Administrator Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA 33063 Office: 954-935-4117 Fax:954-935-3639 Cell:954-683-4459 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Koivu, Lisa INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --- -- 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.net -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
When were Locally Managed Tablespaces introduced?
I'm not having much luck - I thought it was with 9i, but the new features guide doesn't list it. So now I'm trawling through old new features guides ... and thought some bright people out there might remember (faster than I can find it in a bunch of pdfs, web pages, etc.). Ciao Fuzzy :-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Oracle Migration Workbench for Sybase
Hello Listers, Anyone used this tool? What was your experience like? I am planning on using it to move about 20GB of data from a Sybase 11.x database to Oracle 8i (Rel 3). This is a one time activity. Flat file route (using Sybase 'bcp') is the alternate solution. I would like see if we could use OMWB for this. The doc says I need Sybase Adaptive Server ODBC driver Release 3.11.00.01. Searched Sybase web site for this driver, but failed to locate it. Any ideas about its source? It's bundled with the Sybase client ... and Sybase were terrible when it came to making it available if you weren't a licenced user (no surprise, really). Does the customer (assuming this isn't you) still have the Sybase 11 CD? If not, I might be able to help out ... but I'll have to troll through a bunch of old CDs at home. Ciao Fuzzy :-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: books recommendations
And of course Jonathan Lewis' Practical Oracle8i is another must-have, though we are all waiting for the 9i edition (nudge, nudge). I seem to remember Jonathan cursing the publisher for putting a version on the book - the vast bulk of the material being relevant for all of 8i and 9i. However, I may be unfairly misquoting him, so I'll leave the authorative comments to him. Ciao Fuzzy :-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
Base conversion
For very obscure reasons (read: one of those developer decisions that you want to use a time-machine to go back and change), we're storing some information in base-36 (0,1,2,3...8,9,A,B,C,...,Y,Z) in a varchar field. And you thought hexadecimal was fun :-) Now some bright spark would like me to build some PL/SQL to do base conversion - in the first instance from base 36 to base 10 (i.e decimal). Has anyone done something similar in the past ... that I could borrow or co-opt? As you've guessed, the deadline is yesterday :-) Ciao Fuzzy :-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: New Schema or New Database?
Our DBA group has recently been getting numerous requests for new databases (training, inventory, customer contacts, etc..) from different departments within the company. Our normal procedure is to create a new instance for the database, create the schema, users, etc..., set up backups and turn it over. However, with the volume of requests we are now getting, we are pondering the idea of creating just one instance and giving each database request its own tablespace and schema. (similar to informix and sybase architecture). Glenn, Be careful with this often-quoted truism - an Oracle schema is NOT the same as a database in Sybase, Informix, SQL Server or DB2. (For those who have heard my rant on this before, now is the time to groan and hit the Delete button). A schema is a schema ... the same concept exists in all of the DBs mentioned above. Apart from the problems already highlighted (no independent tuning, no independent upgrades/patches to Oracle, no fine control on some privileges (resource, dba, etc.)), there are also backup and restore problems. If sub-section A calls to say Quick!, it's gone down the tubes, restore last night's backup, think of the complication you'll face when sub-section B says no way. It can be done, but involves a lot more efforts (e.g. restoring to another instance, exporting the schema, then importing it - instead of just a normal restore). If that doesn't put you off (and it doesn't have to), then try it out. Just don't refer to it as being like a database in informix of sybase :-) :-) :-) Ciao Fuzzy :-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: doubt
Excuse the heresy for answering an SS question on this list. Jai, you can fight with the INFORMATION_SCHEMA views, or use sp_help to see all the objects for allusers(not just tables). If you looking for just tables, and only for a given user, use select o.namefrom sysobjects o, sysusers u where o.uid = u.uidand o.xtype = 'U'and u.name = 'yourusernamehere' (obviously change the yourusernamehere bit to the username desired). You might want to try the usenet comp.databases.ms-sqlserver group for more info. Ciao Fuzzy (yech ... I'm sorry, the MS brainwashing must be stronger than I thought ... I have this irresistible urge to clap my hands and sway back and forth with a moronic grin on my face after thinking of SQL Server. Can anyone suggest a therapist? :-) :-) :-) ). -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of [EMAIL PROTECTED]Sent: Thursday, January 02, 2003 14:04To: Multiple recipients of list ORACLE-LSubject: doubtDear all, we use "select * from tab" to list all objects in a particular user in oracle. could you tell me the equivalent query in sql server ? Regards Jai
RE: Footprint of 9i
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Bob Metelsky Sent: Thursday, December 19, 2002 13:49 To: Multiple recipients of list ORACLE-L Subject: Footprint of 9i All I'm about to consider rolling out 9i here and I'm wondering what type of footprint most people are seeing. In other words how large of an install is a database administrators (enterprise edition)? I've installed 9i at home on WINNT server, Win XP Pro and Suse Linux 8 all were about 2G. I also noticed that even if I tried to remove some components I did not think I needed that the installation size/footprint was not really affected Also a worthwhile note is that my current (enterprise edition) install of 8 17 on win2k server is about 1G This issue is we all run the same size drives here and really cant afford to loose 2G 1G maybe So is it true that overall installing the Enterprise edition of 9i that one could not expect to be much below 2G?? If not, we may have to add a drive for the dba's which is not going to go over big. thanks Bob Bob, No surprises, you're not alone. The easiest 400MB to 500MB to remove are the templates and demo files for the starter instances and schemas. Try deleting %ORACLE_HOME%\assistants\dbca\templates\* to free up 300MB (these are the 'OLTP' and 'Data warehouse' templates used by the dbassist tool - if you don't use them for creating instances, get rid of them), and %ORACLE_HOME%\demo\schema\* to free up 100MB of the scripts used to create the sample schemas - again if you don't use them. There might be more that can be removed ... doco and the like ... but that's a start. Ciao Fuzzy :-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Oracle on windows and shadow thread file access
Maybe not all of the data files, but the users dedicated server process will open datafiles as needed to read data into the block buffer. Now I don't know if I've helped any, or just added to the confusion. Jared No, that was pretty much what I wanted to know - was there any time when a user's dedicated server process - as opposed to smon, pmon, chpt, arch, lgwr, dbwr, etc. - actually acquired a file handle and opened the file. Thanks for the discussion on this. Ciao Fuzzy :-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
Oracle on windows and shadow thread file access
Saw an interesting post in comp.databases.oracle.server postulating that if a shadow thread needed an open file handle on all files in a instance (or even some of them), the process handle limit in windows could constrain user scalability (e.g. too many users would result in ora-12500 unable to spawn errors and the like). (Let's ignore MTS/shared server mode for the moment) Sounded interesting, but I thought I'd ask if anyone knows whether a shadow thread (or process under unix) does open a handle on each file (control, data, redo), some of them, or none of them? Ciao Fuzzy :-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Oracle on windows and shadow thread file access
Thanks Jeff. The more I thought of it, the more I thought this had to be the case (e.g. only SMON, PMON, ARCH, etc. actually handled file access), but the topic raised just enough curiosity in my mind to seek another opinion. Ciao Fuzzy :-) None...only the oracle background processes (threads in Winblows) access the datafiles/logfiles etc. All other communication is done through the SGA. On some Unix variants you _can_ reach a file_open max kernel parameter because each process (in a dedicated server scenario) opens it's own stdin/stdout/stderr. I guess the same could be true of processes running under windows too. So in the limit...you could hit a wall but only due to the per-process overhead. Cheers Jeff Herrick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Open Source Security Comes Under Fire
Title: BackupExec & Oracle You've got to love blinkered analyst reports - SQL Server alone has had nearlya dozen critical security issues this year (http://support.microsoft.com/default.aspx?scid=kb;en-us;Q316333id=Q316333). But I guess that doesn't count :-) Ciao Fuzzy (yes, I'm back - made it to the UK in mostly one piece) -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Boivin, Patrice JSent: 27 November 2002 14:24To: Multiple recipients of list ORACLE-LSubject: OT: Open Source Security Comes Under Fire FYI. http://www.eweek.com/article2/0,3959,720533,00.asp Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systmes Technology Services | Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Rgion des Maritimes, MPO E-Mail: [EMAIL PROTECTED]
Help on resolving block number and file number from 10046 trace to table or index
Hi all, For some reason my 9.0.1 windows install has no tkprof binary, so I'm trying to decipher some 10046 output. I've got a bunch of WAIT #1: nam='db file sequential read' ela= 6467 p1=7 p2=219340 p3=1 For this event, p1 is the file, and p2 is the block. Any ideas on how to track down what object this is (i.e. table, index or whatever)? thanks Fuzzy :-) -- Woo Hoo! - H. Simpson -- The contents of this post are my opinions only If swallowed seek medical advice (Apologies for the excess signature) This email message (and attachments) may contain information confidential to TOWER Software. If you are not the intended recipient you cannot use, distribute or copy the message or message attachments. If you are not the intended recipient, please notify the sender by return email immediately and delete all copies of the message and attachments. Opinions, conclusions and other information in this message and attachments that do not relate to the official business of TOWER Software, are not given or endorsed by it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Are ODBC connection handles shareable over multiple threads?
Rodrigues, Bryan[SMTP:[EMAIL PROTECTED]] wrote: Grant, Thanks for the short answer, is there anything in the long answer, that I should warn the developer of? We had some nasty problems with early version 8 drivers with thread safety, but I could never determine if this was our code or Oracle's. As of the 8.1.7.3 rewrite of the Oracle drivers, these seemed to disappear, so using 8.1.7.6 should be fine. Ciao Fuzzy :-) -- Woo Hoo! - H. Simpson -- The contents of this post are my opinions only If swallowed seek medical advice (Apologies for the excess signature) This email message (and attachments) may contain information confidential to TOWER Software. If you are not the intended recipient you cannot use, distribute or copy the message or message attachments. If you are not the intended recipient, please notify the sender by return email immediately and delete all copies of the message and attachments. Opinions, conclusions and other information in this message and attachments that do not relate to the official business of TOWER Software, are not given or endorsed by it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Are ODBC connection handles shareable over multiple threads?
Rodrigues, Bryan[SMTP:[EMAIL PROTECTED]] wrote: Hi everyone, A developer who is working on an application to retrieve data from an 8.1.7 database using ODBC asked me this question, Are the connection handles for the odbc version 8.1.7.6 shareable across multiple threads?. I had to tell him I didn't know but I would look it up and ask around if anyone knew. So as I do research on my side, If someone could give me an answer or a good place to find the answer, I would be thankful. Bryan, The short answer is yes, they are. Ciao Fuzzy :-) -- Woo Hoo! - H. Simpson -- The contents of this post are my opinions only If swallowed seek medical advice (Apologies for the excess signature) This email message (and attachments) may contain information confidential to TOWER Software. If you are not the intended recipient you cannot use, distribute or copy the message or message attachments. If you are not the intended recipient, please notify the sender by return email immediately and delete all copies of the message and attachments. Opinions, conclusions and other information in this message and attachments that do not relate to the official business of TOWER Software, are not given or endorsed by it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Falling off my seat ( 9i R2)
Cornio, Georgette Ms USACFSC[SMTP:[EMAIL PROTECTED]] wrote: I just loaded 9.2.0 on a Win 2K yesterday, ran the DBCA and saw neither action. When I checked the scripts it generated, it still used the standard passwords for SYS SYSTEM. Are your setups for WIN or UNIX/LINUX ? It was on win2k ... from a technet download on Tuesday. SQL*Plus banner is Oracle9i Release 9.2.0.1.0 - Production. I'll be doing the same later today on Linux (RH7.3) Ciao Fuzzy :-) -- Woo Hoo! - H. Simpson -- The contents of this post are my opinions only If swallowed seek medical advice (Apologies for the excess signature) This email message (and attachments) may contain information confidential to TOWER Software. If you are not the intended recipient you cannot use, distribute or copy the message or message attachments. If you are not the intended recipient, please notify the sender by return email immediately and delete all copies of the message and attachments. Opinions, conclusions and other information in this message and attachments that do not relate to the official business of TOWER Software, are not given or endorsed by it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
Falling off my seat ( 9i R2)
Hi all, Just thought I'd comment on the fact 9i R2 dbassist-created databases actually prompt for SYS and SYSTEM passwords now ... no more you-know-what. This just isn't on! You can't just go throwing in sensible security changes like that :-) :-) :-) [very big grin] Ciao Fuzzy :-) -- Woo Hoo! - H. Simpson -- The contents of this post are my opinions only If swallowed seek medical advice (Apologies for the excess signature) This email message (and attachments) may contain information confidential to TOWER Software. If you are not the intended recipient you cannot use, distribute or copy the message or message attachments. If you are not the intended recipient, please notify the sender by return email immediately and delete all copies of the message and attachments. Opinions, conclusions and other information in this message and attachments that do not relate to the official business of TOWER Software, are not given or endorsed by it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: _spin_count Revealed
Fink, Dan[SMTP:[EMAIL PROTECTED]] wrote: I have learned that my information was incorrect. A negative value for spin count is not to be used for reversing transactions. It is to be used for those systems in the southern hemisphere to insure that the disks spin counter-clockwise. I sincerely apologize for this mistake and hope the list will forgive me. Dan Dan, You're forgetting about the _counter_corriolis_effect parameter, introduced in 9i. If you set this to true, then you need to flip you're setting for _spin_count. I've also found it useful to buy hard drives with synchromesh to make gear changes smoother :-) Ciao Fuzzy :-) -- Woo Hoo! - H. Simpson -- The contents of this post are my opinions only If swallowed seek medical advice (Apologies for the excess signature) This email message (and attachments) may contain information confidential to TOWER Software. If you are not the intended recipient you cannot use, distribute or copy the message or message attachments. If you are not the intended recipient, please notify the sender by return email immediately and delete all copies of the message and attachments. Opinions, conclusions and other information in this message and attachments that do not relate to the official business of TOWER Software, are not given or endorsed by it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: mixed case text
Sivan Rabinovitz[SMTP:[EMAIL PROTECTED]] wrote:
Do you know initcap function?
SELECT INITCAP('the soap') Capitals FROM DUAL;
Capitals
-
The Soap
OK, how about Jaap van der Meer. Or any of a thousand other real-world
names that people, places and events have. Bottom line is the db is there
to serve the user, and when it comes to text, it's not the db's job to
insist on an out-of-date quirk of 20+ year old systems, or tell humans to
change the way they communicate. Store it twice( the second in all-upper),
or use function-based indexes, to get the back end to behave. Don't force
the users to deal with Oracle's case-sensitive limitations.
(Sorry Sivan, this rant isn't really aimed at you - just one of my pet
peeves)
Just my 2¢
Ciao
Fuzzy
:-)
--
Woo Hoo! - H. Simpson
--
The contents of this post are my opinions only
If swallowed seek medical advice
(Apologies for the excess signature)
This email message (and attachments) may contain information confidential to
TOWER Software. If you are not the intended recipient you cannot use,
distribute or copy the message or message attachments. If you are not the
intended recipient, please notify the sender by return email immediately and
delete all copies of the message and attachments. Opinions, conclusions and
other information in this message and attachments that do not relate to the
official business of TOWER Software, are not given or endorsed by it.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Grant Allen
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: Who don't I see my posting ?
Diego Cutrone[SMTP:[EMAIL PROTECTED]] wrote: ok, I'm sorry Joe. But I really do not see my own postings. Send a help message to [EMAIL PROTECTED], ( e.g. put HELP ORACLE-L as the subject/body). This should return some useful info about the options available to you. While the engine running this list isn't ListServ, it probably has the same features, which include the option not to be sent you own posts, etc. (Jared might be able to confirm this). Ciao Fuzzy ;-) -- Woo Hoo! - H. Simpson -- The contents of this post are my opinions only If swallowed seek medical advice (Apologies for the excess signature) This email message (and attachments) may contain information confidential to TOWER Software. If you are not the intended recipient you cannot use, distribute or copy the message or message attachments. If you are not the intended recipient, please notify the sender by return email immediately and delete all copies of the message and attachments. Opinions, conclusions and other information in this message and attachments that do not relate to the official business of TOWER Software, are not given or endorsed by it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Grant Allen 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: Can DB tell if connection from odbc?
Denham Eva[SMTP:[EMAIL PROTECTED]] wrote: Hello Gurus Is there anyway that Oracle 817/Win2K can pick up whether the user is connecting via ODBC at all? As I understand it the ODBC comes in through the Net8 and therefore the above is not possible. Denham, It might be possible, but it depends on what the ODBC-based application is. If it's a custom built program, you're probably out of luck. If it's something like Access, Excel, Lotus 123, etc., then almost all of these rely on issuing select * from all_catalog when they connect (the SQL call generated from the ODBC SQLTables API call), to see what tables are available. So you could write some kind of auditing procedure to track which users are making this call, and spot them that way. Not perfect, but might work for you. Ciao Fuzzy :-) -- Woo Hoo! - H. Simpson -- The contents of this post are my opinions only If swallowed seek medical advice (Apologies for the excess signature) This email message (and attachments) may contain information confidential to TOWER Software. If you are not the intended recipient you cannot use, distribute or copy the message or message attachments. If you are not the intended recipient, please notify the sender by return email immediately and delete all copies of the message and attachments. Opinions, conclusions and other information in this message and attachments that do not relate to the official business of TOWER Software, are not given or endorsed by it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Grant Allen 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: Moving to UK - what are Oracle contracts like?
[EMAIL PROTECTED] wrote: Grant, I agree with Lewis, things are tight here. Very hard to find work and you have to compete hard on rate to have a chance. You have to work as a ltd company - does not cost much to set up , or use an umbrella company. I would recommend joing the Professional Contractors Group (http://www.pcgroup.org.uk/) if you are considering contracting. The insurance is worthwhile but the discussion forums (general, ir35 matters, technical, commercial, accounting) etc can be very useful. Conversely I am thinking about Australia (Sydney) long-term - why are you leaving there and coming to sunny England? John Thanks to everyone for the feedback - very useful. John, Sydney's pretty quiet right now - I've got friends on both sides; contractors and recruiters - and they are all feeling the pinch. As it stands, it looks like I'll be getting a permanent position wearing my jack-of-all-dbs, master-of-none hat in the M4 corridor - but all of the contracting info that's been provided will certainly help when I take the plunge. Hope to see some of you over there - you can spot me by the IV drip filled with coffee :-) Ciao Fuzzy :-) -- Woo Hoo! - H. Simpson -- The contents of this post are my opinions only If swallowed seek medical advice (Apologies for the excess signature) This email message (and attachments) may contain information confidential to TOWER Software. If you are not the intended recipient you cannot use, distribute or copy the message or message attachments. If you are not the intended recipient, please notify the sender by return email immediately and delete all copies of the message and attachments. Opinions, conclusions and other information in this message and attachments that do not relate to the official business of TOWER Software, are not given or endorsed by it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Grant Allen 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).
OT: Moving to UK - what are Oracle contracts like?
Very sorry about OT post - please feel free to flame/respond to me personally. I'm moving to the UK, and wonder what structure most contractors are employed under. I've read about IR35 (pretty much the same as the alienation of income rule here is Aus). Do people work as sole traders, set up their own plc, work for a body shop, or some combination of the above? Apologies again for the bandwidth consumption. Ciao Fuzzy :-) -- Woo Hoo! - H. Simpson -- The contents of this post are my opinions only If swallowed seek medical advice (Apologies for the excess signature) This email message (and attachments) may contain information confidential to TOWER Software. If you are not the intended recipient you cannot use, distribute or copy the message or message attachments. If you are not the intended recipient, please notify the sender by return email immediately and delete all copies of the message and attachments. Opinions, conclusions and other information in this message and attachments that do not relate to the official business of TOWER Software, are not given or endorsed by it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Grant Allen 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: db2
Gordon, Emery {PDBI~Palo Alto}[SMTP:[EMAIL PROTECTED]] wrote:
Has anyone compared IBMs DB2 offerings against Oracle tools. There
appears
to be a produce very close to JDeveloper and the tools claim to compete
well
in the mid tier database market.
Emery Gordon
It's very much a case of what's your poison. If you're talking about
IBM's Visual Age for Java, it is just as
nice/easy/hard/difficult/cumbersome/annoying/great/quick/slow etc. as JDev.
The interface took a little while to get used to ... and my one big beef was
it took me a while to find where the hell it was actually storing my source
code (yeah, I'm an old jdk command line dinosaur, I like seeing the raw
source).
Ciao
Fuzzy
:-)
--
Woo Hoo! - H. Simpson
--
The contents of this post are my opinions only
If swallowed seek medical advice
(Apologies for the excess signature)
This email message (and attachments) may contain information confidential to
TOWER Software. If you are not the intended recipient you cannot use,
distribute or copy the message or message attachments. If you are not the
intended recipient, please notify the sender by return email immediately and
delete all copies of the message and attachments. Opinions, conclusions and
other information in this message and attachments that do not relate to the
official business of TOWER Software, are not given or endorsed by it.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Grant Allen
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: MUST read Oracle Architecture - Abrief Intro
John Weatherman[SMTP:[EMAIL PROTECTED]] wrote: In general, I agree with the majority opinion that seems to be saying that Oracle chugs along perfectly happy when the date changes. Time based recovery might have some issues, so I'd run a hot after the change so I could use it as my basis in a restore. The real question in my mind is ... What does the APP do with the dates. If you've got a time finder type app, you may need some data cleanup scripts to make sure calculations done on the stored data come out rightperson clocks in at 7:00 and out at 5:00, that 7 may need to be brought forward to get the overtime off the clock, for instance. Someone else mentioned an accounting issue if invoice 2 goes out before invoice 1. These sorts of issues need to be discussed with power users. This one in particular is fun to argue with accounts/purchasing people. Even when they have valid date and time data, they start getting really antsy (sp?) when you say the invoice number is just a unique identifier, it has no inherent meaning. I should take the digital camera with me next time so I can take a snap of the cherry-red colour their face goes :-) (Of course, this assumes that the accounting system handles the very date/time problem you're trying to tackle :-) ). Ciao Fuzzy :-) -- Woo Hoo! - H. Simpson -- The contents of this post are my opinions only If swallowed seek medical advice (Apologies for the excess signature) This email message (and attachments) may contain information confidential to TOWER Software. If you are not the intended recipient you cannot use, distribute or copy the message or message attachments. If you are not the intended recipient, please notify the sender by return email immediately and delete all copies of the message and attachments. Opinions, conclusions and other information in this message and attachments that do not relate to the official business of TOWER Software, are not given or endorsed by it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Grant Allen 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).
What do I call these Oracle/db things in Dutch?
Hi all, I'm trying to explain to some customers of ours in The Netherlands what I mean by some database terms - but my Dutch is limited to things about food ( broodjes, poffertjes, etc.), and their English is very good - but just not about databases. Any ideas what terms I'd use to describe referential integrity, cursors and extents? (Anjo, are you out there?) Thanks / Ahlsterbleift Fuzzy :-) -- Woo Hoo! - H. Simpson -- The contents of this post are my opinions only If swallowed seek medical advice (Apologies for the excess signature) This email message (and attachments) may contain information confidential to TOWER Software. If you are not the intended recipient you cannot use, distribute or copy the message or message attachments. If you are not the intended recipient, please notify the sender by return email immediately and delete all copies of the message and attachments. Opinions, conclusions and other information in this message and attachments that do not relate to the official business of TOWER Software, are not given or endorsed by it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Grant Allen 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: the ora certified masters cert, yet again
Don Granaman[SMTP:[EMAIL PROTECTED]] wrote: What do you hate/find-frustrating about Oracle? (Let me count the ways... process terminated with ORA-22053) That could easily be the most revealing interview question ever conceived! I love it!!! It works wonderfully for me. I've seen a few faces go completely blank ... and a few go cherry-red as they start frothing at the mouth mumbling ORA-00600 ... ORA-01555 It's almost like free therapy for them :-) I'm amazed at the number of times someone that is supposedly qualified can't answer a very simple, but unexpected, practical question. I used to always start out with a few indicator questions to determine strengths, weaknesses and which way to go. One such was If you find a file named 'afiedt.buf', how was it probably created? That particular question caught two very confident applicants without the foggiest clue a few years ago. One was the Oracle Wizard at his current company. (Seriously. It was the official job title on his business card! ... even though he had been out of college less than a year.) The other was an extremely smug 7 8 OCP DBBS who claimed many years of experience and opened our conversation, immediately after the handshake and introductions, with I'm one of the best Oracle DBAs around - if not THE best.. When I asked this question after a few minutes of pleasant generalities, his smirk disappeared, his jaw dropped and he just sat there staring at me with the best deer in the headlights look I've ever seen. [It must not have been in the Self Test Software Practice Exams or the Exam Cram books.] I laughed a lot at that ... not least because I'd been an Oracle DBA for three or four years before someone mentioned edit in SQL*Plus, and I said ... Edit?! You mean this piece-of-[expletive] has an edit command!? WHY DIDN'T YOU TELL ME!?. Needless to say I then went and read the manual. BTW: Grant: Can I buy that .sig from you? I'll do you a trade :-) Ciao Fuzzy :-) -- Woo Hoo! - H. Simpson -- The contents of this post are my opinions only If swallowed seek medical advice (Apologies for the excess signature) This email message (and attachments) may contain information confidential to TOWER Software. If you are not the intended recipient you cannot use, distribute or copy the message or message attachments. If you are not the intended recipient, please notify the sender by return email immediately and delete all copies of the message and attachments. Opinions, conclusions and other information in this message and attachments that do not relate to the official business of TOWER Software, are not given or endorsed by it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Grant Allen 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: the ora certified masters cert, yet again
Rachel Carmichael[SMTP:[EMAIL PROTECTED]] wrote: this goes back to a thread from maybe a year ago... what sort of questions do you ask on interviews. I may ask other questions based on what we are specifically looking for or building off something the interviewee says but I always include the following questions: 1) what was your worst nightmare as a DBA and how did you resolve it 2) what are you most proud of doing 3) how do you learn new things about Oracle gee, not ONE multiple choice question among them! [stops lurking for a change] I always throw in What do you like most about Oracle? and What do you hate/find-frustrating about Oracle?. Most can answer the first, but you can often get a good idea of what people have (or haven't!) experienced with their answer to the second. Ciao Fuzzy :-) [goes back to lurking] -- Woo Hoo! - H. Simpson -- The contents of this post are my opinions only If swallowed seek medical advice (Apologies for the excess signature) This email message (and attachments) may contain information confidential to TOWER Software. If you are not the intended recipient you cannot use, distribute or copy the message or message attachments. If you are not the intended recipient, please notify the sender by return email immediately and delete all copies of the message and attachments. Opinions, conclusions and other information in this message and attachments that do not relate to the official business of TOWER Software, are not given or endorsed by it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Grant Allen 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: comp.databases.oracle newsgroups
Henry Poras[SMTP:[EMAIL PROTECTED]] wrote: Is anyone else having problems with the comp.databases.oracle.* newsgroups? I haven't seen a new message in the last three days. Henry Nope - I'm getting new traffic - 200+ messages yesterday, another 168 today in c.d.o.server alone. Might be a spooling delay on or beyond your NNTP server. It happens to me occasionally. Ciao Fuzzy :-) -- Woo Hoo! - H. Simpson -- The contents of this post are my opinions only If swallowed seek medical advice (Apologies for the excess signature) This email message (and attachments) may contain information confidential to TOWER Software. If you are not the intended recipient you cannot use, distribute or copy the message or message attachments. If you are not the intended recipient, please notify the sender by return email immediately and delete all copies of the message and attachments. Opinions, conclusions and other information in this message and attachments that do not relate to the official business of TOWER Software, are not given or endorsed by it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Grant Allen 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).
