Re: What to look for in STATSPACK report
Hi Helmut, There are so many opinions about this that it's hard to point at one specific document or recommendation. If anything, start with stuff written by Graham Wood (who has done a good deal of the work on it), Bjorn Engsig (ditto), or such guys. Also, Tom Kyte has something about it in his new book, so go look on asktom.oracle.com for his opinions about it. If you hope to find threshold numbers for certain values, etc then someone would have automated it a lng time ago. There can be two reasons for this not having happened: It depends on the installation, situation, etc. - or a lot of system-level measurements are in reality useless. That's pretty much my opinion, but thankfully a lot of much smarter people disagree with me. Best regards, Mogens Daiminger, Helmut wrote: Hi! We want to introduce a performance monitoring policy here. We are using the STATSPACK utility. What are sections in statspack reports to look for? What are threshold numbers for these values? Does anybody have any power points or papers about it? This is 9.2 on HP-UX. Thanks, Helmut -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?= 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: What to look for in STATSPACK report
Helmet, Mogens makes a lot of good points as normal. As usual it's never as simple as we'd like it too be and it depends on how your system runs. One thing that is worth monitoring is changes in statistic values over time. For example if your buffer cache hit ratio is normally 85% during your peak on- line usage but then on it changes to 75% this indicates that something significant has changed and probably needs investigating. It doesn't necessarily mean you have a performance problem because if the users are happy that performance is good and batch is performing as expected then all's OK. (BTW I'm aware that buffer cache hit ratio statistics in isolation aren't a good indicator of performance good or bad.) HTH Cheers, Chris Quoting Mogens Nørgaard [EMAIL PROTECTED]: Hi Helmut, There are so many opinions about this that it's hard to point at one specific document or recommendation. If anything, start with stuff written by Graham Wood (who has done a good deal of the work on it), Bjorn Engsig (ditto), or such guys. Also, Tom Kyte has something about it in his new book, so go look on asktom.oracle.com for his opinions about it. If you hope to find threshold numbers for certain values, etc then someone would have automated it a lng time ago. There can be two reasons for this not having happened: It depends on the installation, situation, etc. - or a lot of system-level measurements are in reality useless. That's pretty much my opinion, but thankfully a lot of much smarter people disagree with me. Best regards, Mogens Daiminger, Helmut wrote: Hi! We want to introduce a performance monitoring policy here. We are using the STATSPACK utility. What are sections in statspack reports to look for? What are threshold numbers for these values? Does anybody have any power points or papers about it? This is 9.2 on HP-UX. Thanks, Helmut -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?= 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). Chris Dunscombe [EMAIL PROTECTED] - Everyone should have http://www.freedom2surf.net/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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: What to look for in STATSPACK report
Helmut, Performance, like beauty, is in the eye of the beholder. Ideal thresholds only exist in poor tuning courses and poor tuning books. IMHO, the wisest thing to do would be to collect information at a time when performance is perfectly satisfactory and use it as a baseline. Then check when there is some _significant_ difference with your baseline. If nobody complains, it means that you can probably allow pretty wide variations for some values. However, if users do really notice (and it's not purely psycho-somatic, as it sometimes is) some degradation, it will be time to enquire. But bear in mind that the most significant indicators will not necessarily be the same ones for all applications, nor even for all times of day. Also, be careful to collect some information about the actual, business-related work being done. I have seen people complaining that they didn't have the same performance as 6 months earlier and forgetting that they were processing twice as many invoices or whatever. Granted, a well-written application should scale. But at least it helps you explain even the most Oracle-challenged manager that it isn't a simple tuning matter (it will be harder to explain that it isn't a question of throwing more hardware to the problem either, but this is another story). HTH Stephane Faroult - --- Original Message --- - From: Daiminger, Helmut [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Sun, 18 Jan 2004 22:24:36 Hi! We want to introduce a performance monitoring policy here. We are using the STATSPACK utility. What are sections in statspack reports to look for? What are threshold numbers for these values? Does anybody have any power points or papers about it? This is 9.2 on HP-UX. Thanks, Helmut -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroult 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: Reasonable layout for DSS
Keith, First of all, please remember that, despite the popular perception that because data warehouses are read only (they aren't, by the way!), they do not place great demands on the I/O subsystem. The real facts are that data warehouses, because much of their I/O activity is uncacheable due to the greater percentage of full table scans and bulk data loads, often present far more demand on the I/O subsystem than any OLTP or operational system. Not sure whether your S/A realizes that or not... Further comments inline... on 1/16/04 10:44 AM, Henry, Keith at [EMAIL PROTECTED] wrote: Does this layout seem reasonable as a starting point for a Windows 2003/Oracle 9.2 DSS database? Volume 0 Mirrored 33 GBOS (Windows 2003) Not being a Windows administrator, I have no idea how much space Windows requires for it's root volume(s), but on UNIX it would be done a lot differently. Does the Windows OS really require 33Gb? Of course that probably includes swap space (which on UNIX is usually allocated to separate volumes). Anyway, no advise to offer here... Volume 1 Mirrored 33 GBOracle Home / Archive Logs / UNDO Volume 2 Mirrored 33 GBRedo / Temp / System The important thing I attempt to do is: * isolate data structures that generate high volumes of I/O from one another first * backfill the rest of the volume with data structures that essentially take up space but do not generate much volume of I/O So, by this principle, I think you have a good distribution of data structures amongst these two volumes. However, since you've obviously had to fight for your RAID-1 volumes, it is very much of a waste to place the ORACLE_HOME and the SYSTEM tablespace on them. There are each very low-volume data structures and they would each be quite happy on the lower-performing RAID-5 volumes... I'd replace each with busier data structures that are currently earmarked for the two RAID-5 volumes... Volume 3 RAID 5 409 GBData1 / Index2 Volume 4 RAID 5 409 GBData2 / Index1 This is fine, but please remember as a sidenote that the admonition to segregate table tablespaces from their related indexe tablespaces is pure bunk. Indexed scan operations are purely sequential (except for FAST full scans) -- there is little or no opportunity for parallelism of I/O because the I/O requests themselves are sequential in nature (as the wait-event name of db file sequential read suggests), and not parallel. Separating tables and indexes to different tablespaces has lots of excellent justification and is highly recoommended, but separating table tablespaces from their associated indexe tablespaces is completely unnecessary. No harm can come of it, but no benefit either. It's possible I could get the sa to split out another set of Mirrored drives from one of the RAID 5 volumes, but it was like pulling teeth to get any non-RAID 5 volumes. Obviously RAID-5 and RAID-1 represent the traditional tradeoff of performance versus cost. Both provide necessary fault-tolerance to the failure of a single drive. RAID-5 presents more usable space but has a clear impact on performance due to synchronization, most noticeably on writes. RAID-1 does not diminish the basic throughput of the drives but presents less usable space. The questions have to be: what is the minimum necessary space for this application and would be better performance of RAID-1 be an acceptable tradeoff? The configuration you describe presents 66 Gb of RAID-1 space and 818 Gb of RAID-5 space, totalling 884 Gb total (exclusing volume 0). Assuming that your storage is filled with 33G drives (an assumption based on the size of the RAID-1 volumes), that means that each RAID-5 LUN could represent 13- or 14-drive sets (i.e. 12x33 is pretty close to 409, leaving 1-2 drives for parity). So, following this tenuous chain of assumptions, that implies that you actually have 32 spindles in your configuration (i.e. two each from volumes 1 and 2 and 14 each from volumes 3 and 4). This means that you could potentially create four RAID-1 sets/volumes/LUNs of 8 drives apiece, yielding about 528Gb total usable space. Is this sufficient for this application, or not? In terms of space, 884 Gb is always preferable to 528 Gb, but in terms of performance, RAID-1 in four 8-drive LUNs will undoubtedly perform much better. Another option represents one of the many middle grounds between the two extremes of 528 Gb (all RAID-1) and the present proposal of 884 Gb: three eight-drive LUNs of RAID-1 (i.e. 3 x 4 x 33 = 396 Gb) plus one eight-drive LUN of RAID-5 (i.e. 231 Gb), for a total of 627 Gb. Then, the plan would be to put the data structures with lower volumes of I/O activity (especially less intense write activity) on the single RAID-5 volume and the volumes with the higher I/O activity on the RAID-1 volumes: - volume 1 (RAID-5 = 321 Gb): ORACLE_HOME, archived logs, SYSTEM, and certain index tablespaces -
extracting schema
Hi all , How can I produce extract schema script(tables , tiggers , objects, procedures ...) from database. Any tool , script , idea ? Thanks Arslan -- 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).
Re: What to look for in STATSPACK report
You will find a utility add on for statspack at Mogens company site, www.miracleas.dk. It is called YAPPPACK. You can use YAPPPACK ( notice the 3 P's, it is not a typo ) to generate response time graphs for your databases. There are many different numbers to look at in a statspack report, but for day to day monitoring, I find them fairly useless. I mean really, who's gonna read all that stuff? Or spend the rest of his life writing a genetic heuristic artificially intelligent algorithm that is smart enough to determine that something is out of bounds for a particular database? Use YAPPPACK to track response times. When response times spike abnormally, then dig into the statspack data. JMO, Jared On Sun, 2004-01-18 at 23:54, Mogens Nrgaard wrote: Hi Helmut, There are so many opinions about this that it's hard to point at one specific document or recommendation. If anything, start with stuff written by Graham Wood (who has done a good deal of the work on it), Bjorn Engsig (ditto), or such guys. Also, Tom Kyte has something about it in his new book, so go look on asktom.oracle.com for his opinions about it. If you hope to find threshold numbers for certain values, etc then someone would have automated it a lng time ago. There can be two reasons for this not having happened: It depends on the installation, situation, etc. - or a lot of system-level measurements are in reality useless. That's pretty much my opinion, but thankfully a lot of much smarter people disagree with me. Best regards, Mogens Daiminger, Helmut wrote: Hi! We want to introduce a performance monitoring policy here. We are using the STATSPACK utility. What are sections in statspack reports to look for? What are threshold numbers for these values? Does anybody have any power points or papers about it? This is 9.2 on HP-UX. Thanks, Helmut -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?= 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: 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).
Re: extracting schema
many tools will do that, but if you're on 9i, check out dbms_metadata package. joe [EMAIL PROTECTED] wrote: Hi all , How can I produce extract schema script(tables , tiggers , objects, procedures ...) from database. Any tool , script , idea ? Thanks Arslan -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joe Testa 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: ORA-904 after table rename
It turns out that the user had configured TOAD to use a table filter, which causes it to create and store a query. As you've probably guessed, the query was referencing a column which no longer exists. On a related note, I initially tried to capture the failing query using alter system set events='904 TRACE NAME ERRORSTACK', but no trace files were ever created. Any idea what the command should really have been? -Original Message- Norris, Gregory T [ITS] Sent: Friday, January 16, 2004 9:10 AM To: Multiple recipients of list ORACLE-L We're developing some schema update scripts for an in-house application, which includes renaming an existing table, and creating a new version using the original name. No problem... or so I thought. :( All seems well under OEM and SQL+, but I have a developer who consistently gets an ORA-904 error (invalid column name) when trying to access the new table under TOAD. I can't think of anything weird about this table, except that the original has some column-level grants (but not to his userid... he has select/insert/update/delete on both tables). I had him try exiting and restarting TOAD, in case it was caching something relevant, but that didn't make any apparent difference. Any idea what might be going on? SQL desc tool_request_old NameNull?Type --- TREQ_TOOLS_REQUEST_PKEY NOT NULL NUMBER(6) TREQ_PEOPLE_FKEYNOT NULL NUMBER(6) TREQ_SUBMIT_DATENOT NULL DATE TREQ_COMPLETE_DATE DATE TREQ_STATUS NOT NULL NUMBER(6) TREQ_COMMENTSVARCHAR2(2024) TREQ_BYPASS_STARTDATE TREQ_BYPASS_END DATE SQL desc tool_request NameNull?Type --- TREQ_ID NOT NULL NUMBER(6) TREQ_PERS_IDNOT NULL NUMBER(6) TREQ_STATUS_ID NOT NULL NUMBER(6) TREQ_SUBMIT_TMSTNOT NULL DATE TREQ_BYPASS_START_TMST DATE TREQ_BYPASS_END_TMST DATE TREQ_COMPLETE_TMST DATE TREQ_COMMENTSVARCHAR2(1024) -- My employers like me, but not enough to let me speak for them. Greg Norris Sprint LTD Database Administration -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Norris, Gregory T [ITS] 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: Norris, Gregory T [ITS] 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: SLA/metrics for RFP for programming services
At 11:04 AM 1/18/2004, Thomas Jeff wrote: Tim, Thanks for the reply. We are thinking more along the lines of metrics pertaining to identifying the required efficiency of the outsourced ETL task, e.g. time, resource utilization,throughput, etc, in essence some desired baseline resource profile. We are new to writing up RFPs at this level of granularity with respect to services, so if this all rather unreasonable, in yours (or anyone's) opinion, I'd like to know. So long as you have the ability to reasonably estimate things like LIO's for a task, I don't see this as at all unreasonable. I'd certainly rather have a quantifiable performance metric to hit than deal with the vagueness of fast enough. On the other hand, if you don't have a good basis on which to estimate the number of LIO's this ETL process would take if it is well-written, you may be setting an unreasonably high or unreasonably low bar. Since you're writing this RFP at a more granular level than you're accustomed to, I would suggest starting with metrics that are easier to understand and predict but tend to be less accurate. Wall clock time is readily understood, easy to verify, and reasonably easy to estimate. If I have other ETL processes that can load 10 million rows per hour from a file into a particular table structure and this ETL process will have a similar amount of data, a similar validation process, and a similar table structure, you can probably infer that 10 million rows per hour is a reasonable metric. If there are other things running at the same time, you'd have to qualify the requirement with the amount of CPU, RAM, I/O, etc that will be available to this new ETL process. Justin Cave It's not just a matter of defining that the deliverables are to be completed during X number of days for $ cost, but we are thinking that we need to identify some metrics that would help us to specify some acceptable performance criteria, against which we would monitor when performing some form of acceptance testing. It does us no good if the contracted ETL task capitalizes the box (like the runaway PL/SQL program mentioned by Ryan) and takes 3 days to complete. -Original Message- From: Tim Gorman [mailto:[EMAIL PROTECTED]] Sent: Friday, January 16, 2004 10:54 PM To: Multiple recipients of list ORACLE-L Subject: Re: SLA/metrics for RFP for programming services How about specific deliverables within a specific period of time for a total amount not-to-exceed? Cant think of any other metrics that matter... on 1/16/04 2:19 PM, Thomas Jeff at [EMAIL PROTECTED] wrote: If you were to write up a RFP for programming services, what kind, if any, metrics would you include to provide some measurements by which performance of the contract can be assessed? The tasks will typically be writing up ETL runs for our DW. CPU, LIO, wait events, etc? Thanks! Jeffery D Thomas DBA Thomson Information Services Thomson, Inc. Email: [EMAIL PROTECTED] Indy DBA Master Documentation available at: http://gkmqp.tce.com/tis_dba http://gkmqp.tce.com/tis_dba
linux
Hello list, sorry for the off topic question , but I thought that a question on unix would not ruffle too many feathers. what all changes will you make to convert linux to a Real time operating system ? Can anyone please help me with an answer and explanation ? -- 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).
Re: SLA/metrics for RFP for programming services
Title: Re: SLA/metrics for RFP for programming services Jeff, As youre aware, whatever metrics you choose will govern their behavior. Completed deliverables is a good start, but if youre looking for well-tuned deliverables you could add a tuning-review gate through which each deliverable has to pass? Failure to resolve any items raised by the tuning-review committee will mean non-completion of the deliverable. Resolution of items raised by the committee should include the contractor asserting the expected benefit of the item is not worth the cost/effort. As a housepainting contractor years ago, I bid fixed-price and was paid on deliverables, with 33% paid on signing the contract, 33% paid at a specifed half-way point, and 33% upon completion. Nowadays, I only do a few fixed-price jobs, but they are often structured similarly. Your tuning-review gateway for each deliverable would be logical as the specified half-way point, perhaps? Just an idea... There are ways to accomplish the letter of just about any metric but not the intent. So, getting too esoteric will likely lead to a distorted result. If contractor does not trust such a committee not to be fair, then perhaps there isnt enough trust (or desperation! :-) ) in the relationship to make it work anyway. Hope this helps... -Tim on 1/18/04 11:04 AM, Thomas Jeff at [EMAIL PROTECTED] wrote: Tim, Thanks for the reply. We are thinking more along the lines of metrics pertaining to identifying the required efficiency of the outsourced ETL task, e.g. time, resource utilization,throughput, etc, in essence some desired baseline resource profile. We are new to writing up RFPs at this level of granularity with respect to services, so if this all rather unreasonable, in yours (or anyone's) opinion, I'd like to know. It's not just a matter of defining that the deliverables are to be completed during X number of days for $ cost, but we are thinking that we need to identify some metrics that would help us to specify some acceptable performance criteria, against which we would monitor when performing some form of acceptance testing. It does us no good if the contracted ETL task capitalizes the box (like the runaway PL/SQL program mentioned by Ryan) and takes 3 days to complete. -Original Message- From: Tim Gorman [mailto:[EMAIL PROTECTED] Sent: Friday, January 16, 2004 10:54 PM To: Multiple recipients of list ORACLE-L Subject: Re: SLA/metrics for RFP for programming services How about specific deliverables within a specific period of time for a total amount not-to-exceed? Cant think of any other metrics that matter... on 1/16/04 2:19 PM, Thomas Jeff at [EMAIL PROTECTED] wrote: If you were to write up a RFP for programming services, what kind, if any, metrics would you include to provide some measurements by which performance of the contract can be assessed? The tasks will typically be writing up ETL runs for our DW. CPU, LIO, wait events, etc? Thanks! Jeffery D Thomas DBA Thomson Information Services Thomson, Inc. Email: [EMAIL PROTECTED] Indy DBA Master Documentation available at: http://gkmqp.tce.com/tis_dba http://gkmqp.tce.com/tis_dba
Re: What to look for in STATSPACK report
Helmut, Register with http://www.oraperf.com; and run those STATSPACK reports through the YAPP analyzer, which will reformat them in such a way that they make sense. All of the ratio stuff on the STATSPACK report is ignored by the YAPP analyzer, and instead the reformatting looks at things from the standpoint of response-time analysis, as described in the white papers at http://www.oraperf.com/whitepapers.html;. Yes, I know OraPerf is now owned by Veritas and the real URLs are different, but it'll always be just good old oraperf.com hopefully, no matter who Anjo works for... :-) Hope this helps... -Tim on 1/18/04 11:24 PM, Daiminger, Helmut at [EMAIL PROTECTED] wrote: Hi! We want to introduce a performance monitoring policy here. We are using the STATSPACK utility. What are sections in statspack reports to look for? What are threshold numbers for these values? Does anybody have any power points or papers about it? This is 9.2 on HP-UX. Thanks, Helmut -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Gorman 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: What is JAWS 4.0.2 for RAC? How to get it?
Great!!! May be this is your way of solving problems. --- On Fri 01/09, Mladen Gogala [EMAIL PROTECTED] wrote: To: [EMAIL PROTECTED] Date: Fri, 09 Jan 2004 17:04:25 -0800 Just go surfing to CA. Be sure to resemble seal as much as possible and jaws will come. ___ No banners. No pop-ups. No kidding. Introducing My Way - http://www.myway.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: quriyat 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: OS authentication; remote login; domain qualification
Hi Thanks for the info. Let me try this. Regards, B S Pradhan --- On Mon, 19 Jan 2004 Jared Still wrote : You must set OSAUTH_PREFIX_DOMAIN=true in the registry to use externally identified domain accounts. I can't recall if the default value is true or false, but try setting it explicitly. Jared On Sun, 2004-01-18 at 05:49, bhabani s pradhan wrote: Hi All, The client machine is an NT machine and it belongs to a domain GALAXY Oracle Db server is on Solaris. client sqlnet.ora has the following setting: NAMES.DIRECTORY_PATH= (TNSNAMES) LOG_DIRECTORY_CLIENT=c:\oracle\ora81\network\log USE_DEDICATED_SERVER=ON SQLNET_AUTHENTICATION_SERVICES=NTS initialization parameters: REMOTE_OS_AUTHENT=TRUE os_authent_prefix = - with an user name Without the domain remote connection is possible.. ** SQL create user USER1 identified externally 2 default tablespace ts1 3 temporary tablespace TEMP; User created. SQL grant connect to USER1; Grant succeeded. C:\sqlplus /@sn1 SQL*Plus: Release 8.1.7.0.0 - Production on Tue Dec 30 15:51:45 2003 (c) Copyright 2000 Oracle GALAXYoration. All rights reserved. Connected to: Oracle8i Enterprise Edition Release 8.1.7.4.0 - 64bit Production With the Partitioning option JServer Release 8.1.7.4.0 - 64bit Production SQL show user USER is USER1 SQL select username, osuser from v$session; USERNAME OSUSER -- -- SYS oracle USER1 USER1 *** But when i try the username with the NT domain it fails to connect remotely: * SQL create user GALAXY\USER1 identified externally 2 default tablespace ts1 3 temporary tablespace TEMP; User created. SQL grant connect to GALAXY\USER1; Grant succeeded. When I connect try using sqlplus /@sn1 it fails C:\sqlplus /@sn1 SQL*Plus: Release 8.1.7.0.0 - Production on Tue Dec 30 15:49:56 2003 (c) Copyright 2000 Oracle GALAXYoration. All rights reserved. ERROR: ORA-01017: invalid username/password; logon denied What I think issue here is, the connection is thru tns-listener and the NT domain and the server machine are different. Is there any solution for this / Is it possible to connect the remote unix DB server with OS authentication from an NT client with domain name ? Thanks and Regareds B S Pradhan -- 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).
SYS Privilege
Hi list, when I connect as sys/password as sysdba I get an error not sufficient privilege but I can connect internal, How can I set my SYS user to connect as sysdba. I am running on 8.1.7.4 Windows 2000 Professional edition. Thanks, Hamid Alavi Office : 818-737-0526 Cell phone : 818-416-5095 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hamid Alavi 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: linux
I would probably go to the http://www.realtimelinuxfoundation.org and see what's there. The next thing would be to start looking into other RT Unix systems and when all of the needed information is compiled, I would post an article with the solution on this list. On 2004.01.19 09:54, [EMAIL PROTECTED] wrote: Hello list, sorry for the off topic question , but I thought that a question on unix would not ruffle too many feathers. what all changes will you make to convert linux to a Real time operating system ? Can anyone please help me with an answer and explanation ? -- 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). -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala 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 backup
Sorry to respond to such an old thread (man I'm way behind), but what if the expected location of the archived logs isn't large enough? For example, let's say we have a 10G archive directory, and we dump 5-10G of logs per day. I have to go to a backup made a week ago. That's 35-70G worth of logs if I need to roll forward. Does RMAN try and cram 'em all in at once, or will it roll through them? That sure would be a nice feature. ;-) -- Rich Holland(913) 645-1950SAP Technical Consultant print unpack(u,92G5S\=\!A;F]T:5R(\'!EFP\@:%C:V5R\[EMAIL PROTECTED]); -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of DENNIS WILLIAMS Sent: Tuesday, October 28, 2003 3:00 PM To: Multiple recipients of list ORACLE-L Subject: RE: rman backup AK When you have RMAN back up archived logs, IIRC, in a recovery RMAN first restores those archived logs to the location that Oracle will expect them to be, and I believe that is done as part of the RESTORE DATABASE command. In my situation, I found no advantage from having RMAN store the archive logs, so I have no experience there, just what I've read in the manual. Only RMAN can perform the RESTORE DATABASE command, but once you complete that command, you can complete the recovery using svrmgrl. From everything I've seen, RMAN just issues the RECOVER DATABASE command to svrmgrl or SQL*Plus. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, October 28, 2003 1:15 PM To: Multiple recipients of list ORACLE-L Thanks Dennis for Reply, My confusion is , does RMAN sees only those archived logs which are backup using rman or it can use current archived log as well stored in original format at other disk ? -ak - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, October 28, 2003 10:49 AM AK - Unless you specify otherwise, RMAN will automatically apply archive logs to bring the database up to the time of failure (your recover database statement). This is why it is good to run disaster recovery tests on a regular basis, to ensure everything is ready, and you can try different recovery times. You will see that RMAN will not complete its recovery if the archived logs are not available. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, October 28, 2003 11:44 AM To: Multiple recipients of list ORACLE-L We take daily rman backup each nite at 10pm . Which means in worst case we risk one day of work. Now suppose something wrong goes before 10 pm . Then Can I recover my database till time using previous day rman backup and currently available archived logs. Or in nutshell is it possible to run { restore databse; recover database } from rman and then apply remaing archived logs from a separated disk ( not a rman backup ). Thanks, -ak -- 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: AK 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
RE: linux
Having never done it, I'll just refer you here: http://www.tldp.org/HOWTO/RTLinux-HOWTO.html Mark J. Bobak Oracle DBA ProQuest Company Ann Arbor, MI Imagination was given to man to compensate him for what he is not, and a sense of humor was provided to console him for what he is. --Unknown -Original Message- Sent: Monday, January 19, 2004 9:54 AM To: Multiple recipients of list ORACLE-L Hello list, sorry for the off topic question , but I thought that a question on unix would not ruffle too many feathers. what all changes will you make to convert linux to a Real time operating system ? Can anyone please help me with an answer and explanation ? -- 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: Bobak, Mark 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).
FW: Disk capacity planning
I dont think this one made it through on my first attempt. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Nullius in verba Upcoming events: - Performance Diagnosis101: 1/27 Atlanta - SQL Optimization101: 2/16 Dallas - Hotsos Symposium 2004: March 710 Dallas - Visit www.hotsos.com for schedule details... -Original Message- From: Cary Millsap [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 13, 2004 5:54 PM To: '[EMAIL PROTECTED]' Subject: RE: Disk capacity planning Counting bytes is far, far, FAR less important than counting I/O-per-second (IOps) requirements and making sure that you have enough total capacity to handle your systems peak I/O loads. Counting bytes is important too, but what many people find is that the byte-counting exercise will result in the sub-verdict of needing far fewer disk drives than youll really, truly need. The way Id recommend structuring your project is to evaluate the following: - How many bytes will you need to store your data? How many disks is that? Call the answer B. - How many disks will you need to meet your IOps requirements? Call the answer P. - How many disks will you need to meet your availability requirements? Call the answer A. - (Consider other attributes as necessary, like perhaps I/O throughput requirements) Roughly speaking, the number of disks youll need to buy is max(B, P, A, ). Its more complicated than that because youll need to segment your total drive set into sensibly-sized arrays, youll be able to buy some disks now then some later, and so on, but this is the general gist. The important thing is to have enough hardware to meet *all* of the constraints your business will place upon your system. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Nullius in verba Upcoming events: - Performance Diagnosis101: 1/27 Atlanta - SQL Optimization101: 2/16 Dallas - Hotsos Symposium 2004: March 710 Dallas - Visit www.hotsos.com for schedule details... -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Tuesday, January 13, 2004 12:29 AM To: Multiple recipients of list ORACLE-L Subject: Disk capacity planning Hi everyone! Can anybody point me to any good documentation regarding disk capacity planning? Sharing your experience or approach will also give me so much help. I'd like to know other people's approach on forecasting the growth of their databases particularly on determining the (growth) rate of disk space usage and on deciding when to add and how many disk to add on an Oracle server. Thanks in advance. Best Regards, Rhojel
RE: SYS Privilege
Hamid - Are you using sqlplus or sysmgr? Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, January 19, 2004 1:49 PM To: Multiple recipients of list ORACLE-L Hi list, when I connect as sys/password as sysdba I get an error not sufficient privilege but I can connect internal, How can I set my SYS user to connect as sysdba. I am running on 8.1.7.4 Windows 2000 Professional edition. Thanks, Hamid Alavi Office : 818-737-0526 Cell phone : 818-416-5095 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hamid Alavi 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).
MS Access
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
RE: ORA-904 after table rename
I went through a similar problem with the 904 error. I had to use oradebug to get a trace file to be produced. Good luck, Chris -Original Message- Sent: Monday, January 19, 2004 8:14 AM To: Multiple recipients of list ORACLE-L It turns out that the user had configured TOAD to use a table filter, which causes it to create and store a query. As you've probably guessed, the query was referencing a column which no longer exists. On a related note, I initially tried to capture the failing query using alter system set events='904 TRACE NAME ERRORSTACK', but no trace files were ever created. Any idea what the command should really have been? -Original Message- Norris, Gregory T [ITS] Sent: Friday, January 16, 2004 9:10 AM To: Multiple recipients of list ORACLE-L We're developing some schema update scripts for an in-house application, which includes renaming an existing table, and creating a new version using the original name. No problem... or so I thought. :( All seems well under OEM and SQL+, but I have a developer who consistently gets an ORA-904 error (invalid column name) when trying to access the new table under TOAD. I can't think of anything weird about this table, except that the original has some column-level grants (but not to his userid... he has select/insert/update/delete on both tables). I had him try exiting and restarting TOAD, in case it was caching something relevant, but that didn't make any apparent difference. Any idea what might be going on? SQL desc tool_request_old NameNull?Type --- TREQ_TOOLS_REQUEST_PKEY NOT NULL NUMBER(6) TREQ_PEOPLE_FKEYNOT NULL NUMBER(6) TREQ_SUBMIT_DATENOT NULL DATE TREQ_COMPLETE_DATE DATE TREQ_STATUS NOT NULL NUMBER(6) TREQ_COMMENTSVARCHAR2(2024) TREQ_BYPASS_STARTDATE TREQ_BYPASS_END DATE SQL desc tool_request NameNull?Type --- TREQ_ID NOT NULL NUMBER(6) TREQ_PERS_IDNOT NULL NUMBER(6) TREQ_STATUS_ID NOT NULL NUMBER(6) TREQ_SUBMIT_TMSTNOT NULL DATE TREQ_BYPASS_START_TMST DATE TREQ_BYPASS_END_TMST DATE TREQ_COMPLETE_TMST DATE TREQ_COMMENTSVARCHAR2(1024) -- My employers like me, but not enough to let me speak for them. Greg Norris Sprint LTD Database Administration -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Norris, Gregory T [ITS] 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: Norris, Gregory T [ITS] 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: Chris Stephens 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: extracting schema
Hi have a look at Chris O'Sullivans tool T.O.Y.S. at http://www.impacttoys.com that allows you to extract the schema from a database. kind regards Pete -- Pete Finnigan email:[EMAIL PROTECTED] Web site: http://www.petefinnigan.com - Oracle security audit specialists Book:Oracle security step-by-step Guide - see http://store.sans.org for details. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Finnigan 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
I think he is talking about 100GB database. Can PostgreSQL and MySQL handle that size? We used MySQL in some of the web projects, but it just stores small set of operational data and later on those data are moved to Oracle as a permenant store. For small set of data, MySQL is quite good, but it lacks features such as foreign key constraints, triggers etc. Eric - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, January 14, 2004 1:44 PM On 01/14/2004 12:44:25 PM, Jesse, Rich wrote: If you have the choice, look at PostgreSQL in addition to MySQL. From what I've seen, it's more mature than MySQL. I second that. PostgresSQL supports transactions and uses perl as its scripting language. From what little I read and saw (just a little pilot project with the goal to see what the heck is Postgres), it's a very decent database, with a decent performance and capabilities sufficient for a small, departmental database server. I know nothing of clustering, distributed database, database links, replication and alike. In other words, I wouldn't use it for an enterprise-wide server for GE or Wall-Mart, but it can be quite a convenient storage space for a small corner shop or a small department. Because of perl and DBI, exchanging data with other servers like oracle or UDB (DB2) is easy. -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala 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: eric king 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: SYS Privilege
What is the value of your remote_login_password init parameter? What is the value of SQLNET.AUTHENTICATION_SERVICES in sqlnet.ora file? -Original Message- Hamid Alavi Sent: Monday, January 19, 2004 2:49 PM To: Multiple recipients of list ORACLE-L Hi list, when I connect as sys/password as sysdba I get an error not sufficient privilege but I can connect internal, How can I set my SYS user to connect as sysdba. I am running on 8.1.7.4 Windows 2000 Professional edition. Thanks, Hamid Alavi Office : 818-737-0526 Cell phone : 818-416-5095 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hamid Alavi 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: Jay 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: SYS Privilege
sqlplus -Original Message- Sent: Monday, January 19, 2004 2:00 PM To: Multiple recipients of list ORACLE-L Hamid - Are you using sqlplus or sysmgr? Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, January 19, 2004 1:49 PM To: Multiple recipients of list ORACLE-L Hi list, when I connect as sys/password as sysdba I get an error not sufficient privilege but I can connect internal, How can I set my SYS user to connect as sysdba. I am running on 8.1.7.4 Windows 2000 Professional edition. Thanks, Hamid Alavi Office : 818-737-0526 Cell phone : 818-416-5095 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hamid Alavi 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: Hamid Alavi 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).
DBAzine Oracle Space Management handbook - Beware !!
In the interests of trying to highlight Oracle related material of questionable merit, I would like to draw your attention to (yet another) www.DBAzine.com document. This time, it's the recently available free download Oracle Space Management Handbook that has caught my attention. I have as usual contacted the Series Editor, the one and only Donald K. Burleson with my concerns and I have as usual received no reply. Within the pages of the above mentioned Handbook, you will find the following samples of expert advice: a.. Separate indexes from their tables to improve performance via reduced disk contention (with classic example) a.. Set pctincrease to 1 to coalesce fragmented tablespaces a.. Oracle guarantees that the undo entries will not be overwritten within the undo_retention period a.. A physical I/O is 10s of thousands of times slower than a memory I/O a.. Actually, a physical I/O is 14,000 times slower than a memory I/O a.. More that 1024 extents leads to performance problems with LMTs and look out for more that 5 extents generally a.. Rebuild tables that have the above numbers of extents to reduce performance problems a.. After rebuiulding a table, coalesce the tablespace a.. After a table move, a fast index rebuild can be used rather than a slow drop/re-create (as the invalid index is used during the rebuild) a.. Deleted space within an index is evidently not reused (with clear example) a.. Index access is so fast because deleted space is not reused a.. Any index with more than 4 extents should be rebuilt (even if using LMTs) a.. Ideally, indexes should fit into one extent a.. As deleted space is never reused, indexes must periodically be rebuilt a.. Place indexes into separate tablespaces with a uniform size that ensures no index has more than 4 extents a.. Index Row length is calculated as (sum of data length) + 1 (with the 10 byte rowid being of no consequence) a.. If the number of leaf blocks + branch blocks is less than the number of blocks in dba_segments, rebuild the index a.. Don't just rebuild indexes the once, but rebuild them twice, once in another tablespace so you can defragment the original tablespace and then re-create them again back in the original tablespace a.. Multiple block sizes should be used to improve performance, unconditionally a.. The System tablespace can (and should) have a block size different from the DB_BLOCK_SIZE a.. The size of the Default Pool is calculated as DB_CACHE_SIZE - (DB_RECYCLE_CACHE + DB_KEEP_CACHE) a.. . As remarkable as it might sound, the above recommendations are all found within the handbook, I kid you not !! Many of the articles appear to be years old (5 years + ?) with several of the chapters referring to Locally Managed Tablespaces as being relatively new. The issue of course is that all the above (and more) is utter tripe but the more unfortunate issue is that there is some good stuff in there, it's just that it's been buried among the rubbish. And as the handbook is obviously aimed at the newer Oracle audience (due to it's modest level of technical details), the truth and the myths become hopelessly mixed. The end result is a new bunch of Oracle folk who believe that more than 1 or 4 or 5 or 1024 extents is bad, believe indexes need to be rebuilt all the time, believe the Default pool is 1/2 it's actual size and are confused why the System TS block size can't differ from the db_block_size. With handbooks such as these still being developed, it's no wonder some of these myths never die as newbies simply don't have a fine enough sieve and fast water flow to separate the crap from the gold. Good grief !! All I can do is highlight these things in the hope it might do some good and urge some of these so-called experts to lift their game and produce materials that actually helps to advance the level of understanding in the Oracle community, rather than complicate, confuse and confound. Hence my definition of a real expert ... If experts can't correctly calculate the size of the Default Pool, perhaps they should spend more time reading than writing !! Cheers Richard -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Richard Foote 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. http://otn.oracle.com/tech/migration/workbench/index.html http://www.oracle.com/oramag/oracle/02-may/index.html?o32tools.html -- Bricklen Anderson, Database Administrator PresiNET Systems http://www.PresiNET.com Live Demo: https://www.presinet.com/secure/login -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bricklen Anderson 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).
All pakages under sys is invalid
All, I have an strange problem, most of the packages under SYS user are invalid when I compile it it's compile without error but when I back again the package still is invalid, anybody have any idea? Thanks in advance Hamid Alavi Office : 818-737-0526 Cell phone : 818-416-5095 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hamid Alavi 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: advice
At 07:59 AM 1/15/2004, you wrote: What else can I suggest to help them collect data that will be informative? My business card ;-) Wolfgang Breitling Oracle7, 8, 8i, 9i OCP DBA Centrex Consulting Corporation http://www.centrexcc.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Wolfgang Breitling 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).
Thanx - I cleared the exam -- another OCP question
Hi list , thanx a lot to all of you . i cleared the #1Z0-031 exam last week . thanx again for all the support given by you friends. Kind Regards, Prem. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J 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
Ryan, It's postgres.org. I'm not sure how they generate the operating revenue they need, but that's why they are not advertising like MySql AB is. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Wednesday, January 14, 2004 5:05 PM To: Multiple recipients of list ORACLE-L i thought postgre was a for profit company? how do they generate revenues? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, January 14, 2004 4:19 PM 1) DBI is a perl module to handle the communication with various databases. 2) Postgres is free. I believe that you can buy commercial support, but I don't know where. May be Rich can jump in with that. 3) DBI is free and so is perl. I'm cheap easy, but not free. On 01/14/2004 02:34:52 PM, Ryan wrote: what is DBI? is postgre free? Is it like linux where you pay for support? I cant find any licensing info on the website. Most shops dont need oracle, sql server, sybase, or DB2. Most applications are small. I was on a project where the government had an Oracle EE license on windows. They didnt even use foreign key constraints. Had a whopping 13 tables, 20 MB of data, and 10-15 users. Any free database could have handled that. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, January 14, 2004 1:44 PM On 01/14/2004 12:44:25 PM, Jesse, Rich wrote: If you have the choice, look at PostgreSQL in addition to MySQL. From what I've seen, it's more mature than MySQL. I second that. PostgresSQL supports transactions and uses perl as its scripting language. From what little I read and saw (just a little pilot project with the goal to see what the heck is Postgres), it's a very decent database, with a decent performance and capabilities sufficient for a small, departmental database server. I know nothing of clustering, distributed database, database links, replication and alike. In other words, I wouldn't use it for an enterprise-wide server for GE or Wall-Mart, but it can be quite a convenient storage space for a small corner shop or a small department. Because of perl and DBI, exchanging data with other servers like oracle or UDB (DB2) is easy. -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala 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: Ryan 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). -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala 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: Ryan 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
RE: SYS Privilege
here it is: remote_login_password= EXCLUSIVE sqlnet.authentication=(NTS) -Original Message- Sent: Monday, January 19, 2004 2:01 PM To: Multiple recipients of list ORACLE-L What is the value of your remote_login_password init parameter? What is the value of SQLNET.AUTHENTICATION_SERVICES in sqlnet.ora file? -Original Message- Hamid Alavi Sent: Monday, January 19, 2004 2:49 PM To: Multiple recipients of list ORACLE-L Hi list, when I connect as sys/password as sysdba I get an error not sufficient privilege but I can connect internal, How can I set my SYS user to connect as sysdba. I am running on 8.1.7.4 Windows 2000 Professional edition. Thanks, Hamid Alavi Office : 818-737-0526 Cell phone : 818-416-5095 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hamid Alavi 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: Jay 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: Hamid Alavi 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: SYS Privilege
Do you have that password in your password file? -Original Message- Sent: Monday, January 19, 2004 4:14 PM To: Multiple recipients of list ORACLE-L here it is: remote_login_password= EXCLUSIVE sqlnet.authentication=(NTS) -Original Message- Sent: Monday, January 19, 2004 2:01 PM To: Multiple recipients of list ORACLE-L What is the value of your remote_login_password init parameter? What is the value of SQLNET.AUTHENTICATION_SERVICES in sqlnet.ora file? -Original Message- Hamid Alavi Sent: Monday, January 19, 2004 2:49 PM To: Multiple recipients of list ORACLE-L Hi list, when I connect as sys/password as sysdba I get an error not sufficient privilege but I can connect internal, How can I set my SYS user to connect as sysdba. I am running on 8.1.7.4 Windows 2000 Professional edition. Thanks, Hamid Alavi Office : 818-737-0526 Cell phone : 818-416-5095 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hamid Alavi 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: Jay 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: Hamid Alavi 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). This e-mail, including attachments, may include confidential and/or proprietary information, and may be used only by the person or entity to which it is addressed. If the reader of this e-mail is not the intended recipient or his or her authorized agent, the reader is hereby notified that any dissemination, distribution or copying of this e-mail is prohibited. If you have received this e-mail in error, please notify the sender by replying to this message and delete this e-mail immediately. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Michael Milligan 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: SYS Privilege
the password still is chamge_on_install I could connect as a normal user means it's there but not enough privilege to connect as sysdba. -Original Message- Sent: Monday, January 19, 2004 3:25 PM To: Multiple recipients of list ORACLE-L Do you have that password in your password file? -Original Message- Sent: Monday, January 19, 2004 4:14 PM To: Multiple recipients of list ORACLE-L here it is: remote_login_password= EXCLUSIVE sqlnet.authentication=(NTS) -Original Message- Sent: Monday, January 19, 2004 2:01 PM To: Multiple recipients of list ORACLE-L What is the value of your remote_login_password init parameter? What is the value of SQLNET.AUTHENTICATION_SERVICES in sqlnet.ora file? -Original Message- Hamid Alavi Sent: Monday, January 19, 2004 2:49 PM To: Multiple recipients of list ORACLE-L Hi list, when I connect as sys/password as sysdba I get an error not sufficient privilege but I can connect internal, How can I set my SYS user to connect as sysdba. I am running on 8.1.7.4 Windows 2000 Professional edition. Thanks, Hamid Alavi Office : 818-737-0526 Cell phone : 818-416-5095 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hamid Alavi 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: Jay 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: Hamid Alavi 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). This e-mail, including attachments, may include confidential and/or proprietary information, and may be used only by the person or entity to which it is addressed. If the reader of this e-mail is not the intended recipient or his or her authorized agent, the reader is hereby notified that any dissemination, distribution or copying of this e-mail is prohibited. If you have received this e-mail in error, please notify the sender by replying to this message and delete this e-mail immediately. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Michael Milligan 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: Hamid Alavi 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: SYS Privilege
If you haven't done so, you need to set the environment variable ORACLE_SID. Jared Hamid Alavi [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01/19/2004 03:34 PM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: SYS Privilege the password still is chamge_on_install I could connect as a normal user means it's there but not enough privilege to connect as sysdba. -Original Message- Sent: Monday, January 19, 2004 3:25 PM To: Multiple recipients of list ORACLE-L Do you have that password in your password file? -Original Message- Sent: Monday, January 19, 2004 4:14 PM To: Multiple recipients of list ORACLE-L here it is: remote_login_password= EXCLUSIVE sqlnet.authentication=(NTS) -Original Message- Sent: Monday, January 19, 2004 2:01 PM To: Multiple recipients of list ORACLE-L What is the value of your remote_login_password init parameter? What is the value of SQLNET.AUTHENTICATION_SERVICES in sqlnet.ora file? -Original Message- Hamid Alavi Sent: Monday, January 19, 2004 2:49 PM To: Multiple recipients of list ORACLE-L Hi list, when I connect as sys/password as sysdba I get an error not sufficient privilege but I can connect internal, How can I set my SYS user to connect as sysdba. I am running on 8.1.7.4 Windows 2000 Professional edition. Thanks, Hamid Alavi Office : 818-737-0526 Cell phone : 818-416-5095 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hamid Alavi 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: Jay 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: Hamid Alavi 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). This e-mail, including attachments, may include confidential and/or proprietary information, and may be used only by the person or entity to which it is addressed. If the reader of this e-mail is not the intended recipient or his or her authorized agent, the reader is hereby notified that any dissemination, distribution or copying of this e-mail is prohibited. If you have received this e-mail in error, please notify the sender by replying to this message and delete this e-mail immediately. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Michael Milligan 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: Hamid Alavi 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,
RE: Oracle vs Mysql
Sounds like the old Oracle vs. Ingress battles. Oracle won because it was better at marketing. All detailed in the book The Difference Between God and Larry Ellison. I can see it now -- MySQL, the Oracle of the free databases. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, January 14, 2004 4:39 PM To: Multiple recipients of list ORACLE-L Ryan, It's postgres.org. I'm not sure how they generate the operating revenue they need, but that's why they are not advertising like MySql AB is. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Wednesday, January 14, 2004 5:05 PM To: Multiple recipients of list ORACLE-L i thought postgre was a for profit company? how do they generate revenues? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, January 14, 2004 4:19 PM 1) DBI is a perl module to handle the communication with various databases. 2) Postgres is free. I believe that you can buy commercial support, but I don't know where. May be Rich can jump in with that. 3) DBI is free and so is perl. I'm cheap easy, but not free. On 01/14/2004 02:34:52 PM, Ryan wrote: what is DBI? is postgre free? Is it like linux where you pay for support? I cant find any licensing info on the website. Most shops dont need oracle, sql server, sybase, or DB2. Most applications are small. I was on a project where the government had an Oracle EE license on windows. They didnt even use foreign key constraints. Had a whopping 13 tables, 20 MB of data, and 10-15 users. Any free database could have handled that. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, January 14, 2004 1:44 PM On 01/14/2004 12:44:25 PM, Jesse, Rich wrote: If you have the choice, look at PostgreSQL in addition to MySQL. From what I've seen, it's more mature than MySQL. I second that. PostgresSQL supports transactions and uses perl as its scripting language. From what little I read and saw (just a little pilot project with the goal to see what the heck is Postgres), it's a very decent database, with a decent performance and capabilities sufficient for a small, departmental database server. I know nothing of clustering, distributed database, database links, replication and alike. In other words, I wouldn't use it for an enterprise-wide server for GE or Wall-Mart, but it can be quite a convenient storage space for a small corner shop or a small department. Because of perl and DBI, exchanging data with other servers like oracle or UDB (DB2) is easy. -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala 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: Ryan 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). -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala 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: Ryan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051
RE: Thanx - I cleared the exam -- another OCP question
Prem - We had no doubt. I always figure when you've studied enough to doubt your study guide, you're ready to pass the exam. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, January 15, 2004 6:04 AM To: Multiple recipients of list ORACLE-L Hi list , thanx a lot to all of you . i cleared the #1Z0-031 exam last week . thanx again for all the support given by you friends. Kind Regards, Prem. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J 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).
RE: SYS Privilege
Use the ORAPWD.EXE utility and create a password file: Assume your DB name is test: 1. Find any files named testpwd.ora. 2. Delete these file(s) 3. Find orapwd.exe and, at the command line: c:\oracle\ora92\bin orapwd file=testpwd.ora password=ginger no spaces before or after the=signs. The sys as sysdba password will now be ginger. In the User Name: field of the SQL*Plus login screen, type: sys/[EMAIL PROTECTED] as sysdba of course substituting the name of your DB and your own password. HTH Michael Milligan Oracle DBA Ingenix, Inc. 2525 Lake Park Blvd. Salt Lake City, Utah 84120 This e-mail, including attachments, may include confidential and/or proprietary information, and may be used only by the person or entity to which it is addressed. If the reader of this e-mail is not the intended recipient or his or her authorized agent, the reader is hereby notified that any dissemination, distribution or copying of this e-mail is prohibited. If you have received this e-mail in error, please notify the sender by replying to this message and delete this e-mail immediately. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Michael Milligan 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 update maxphys on Solaris 8 ......
Janardhana, Check this link. http://sunsolve.sun.com/pub-cgi/retrieve.pl?doc=fsalert/23249 From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Janardhana Babu Donga Sent: Friday, January 16, 2004 12:09 PM To: Multiple recipients of list ORACLE-L Subject: How to update maxphys on Solaris 8 .. Dear List, Could someone tell me how to update the parameter maxphys on sun solaris 8 system. At present it is having a default value of 128K. I would like to change it to 1MB. There is no such parameter in /etc/system. I need this parameter to be updated as it seems to be controlling the MAX_IO_SIZE on the platform. -- Janardhana
ORA-06505 PL/SQL: variable requires more than 32767 bytes of contiguous memory
Dear DBAs, Good Morning. Using PL/SQL procedure I am trying to spool out Japanese Characters with VARCHR2(3600) size and I am getting this error. Here is my code. For your information it is Japanese Characters Spool c:\test.log Declare cursor c1 is select contact_details from test; begin DBMS_OUTPUT.ENABLE(100); For x in c1 loop DBMS_OUTPUT.PUT_LINE(''||x.contact_details||''); End loop; End; / Spool off Could you please suggest for other ideas I tried with UTL_FILE also.. Since my OS is English I am getting some Junk Characters Thank You Mudhalvan M.M -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mudhalvan, Moovarkku 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
If MySQL comes to have the same capabilities that many people expect from Oracle, marketing will have no effect. The huge differential in price point will be all that matters. Jared DENNIS WILLIAMS [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01/19/2004 04:04 PM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Oracle vs Mysql Sounds like the old Oracle vs. Ingress battles. Oracle won because it was better at marketing. All detailed in the book The Difference Between God and Larry Ellison. I can see it now -- MySQL, the Oracle of the free databases. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, January 14, 2004 4:39 PM To: Multiple recipients of list ORACLE-L Ryan, It's postgres.org. I'm not sure how they generate the operating revenue they need, but that's why they are not advertising like MySql AB is. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Wednesday, January 14, 2004 5:05 PM To: Multiple recipients of list ORACLE-L i thought postgre was a for profit company? how do they generate revenues? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, January 14, 2004 4:19 PM 1) DBI is a perl module to handle the communication with various databases. 2) Postgres is free. I believe that you can buy commercial support, but I don't know where. May be Rich can jump in with that. 3) DBI is free and so is perl. I'm cheap easy, but not free. On 01/14/2004 02:34:52 PM, Ryan wrote: what is DBI? is postgre free? Is it like linux where you pay for support? I cant find any licensing info on the website. Most shops dont need oracle, sql server, sybase, or DB2. Most applications are small. I was on a project where the government had an Oracle EE license on windows. They didnt even use foreign key constraints. Had a whopping 13 tables, 20 MB of data, and 10-15 users. Any free database could have handled that. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, January 14, 2004 1:44 PM On 01/14/2004 12:44:25 PM, Jesse, Rich wrote: If you have the choice, look at PostgreSQL in addition to MySQL. From what I've seen, it's more mature than MySQL. I second that. PostgresSQL supports transactions and uses perl as its scripting language. From what little I read and saw (just a little pilot project with the goal to see what the heck is Postgres), it's a very decent database, with a decent performance and capabilities sufficient for a small, departmental database server. I know nothing of clustering, distributed database, database links, replication and alike. In other words, I wouldn't use it for an enterprise-wide server for GE or Wall-Mart, but it can be quite a convenient storage space for a small corner shop or a small department. Because of perl and DBI, exchanging data with other servers like oracle or UDB (DB2) is easy. -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala 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: Ryan 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). -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala 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
ADMIN: Status of list server systems (and update about missing messages)
Folks -- I have good news and bad news. ;-) First the good news: Several people had mentioned that they've sent messages to some lists but have not seen the posts arrive back to them. These messages DID appear in the archives though. This started roughly 12-Jan-2004. I had previously researched this issue but could find no reason for it happening, nor a solution. Up until today, that is. The cuplrit was one of my load balancers for mailing list traffic. It was handling traffic correctly on some of the machines, but squirreling away messages sent to one specific server. I'd estimate about 1/8th of the messages sent to mailing lists since 12-Jan-2004 were not redistributed properly. I have since found and fixed the problem, so this shouldn't happen in the future. I suspect I was only able to re-send a portion of the missing messages, so my apologies for anyone who posted a message that didn't make it to a list. Also, my apologies to everyone who has to deal with the increased traffic of the old messages, plus current messages, plus the inevitable onslaught of re-posts that will occur in the next few days. Please be patient with each other. So the good news was: problem found, problem fixed, some catch up done, shouldn't happen again. The bad news is that this morning (roughly 7am PST), a construction crew near Fat City cut through a section of telecom cable that was critical for our connection to the net. They've been working feverishly on it all day, but Fat City was off the net most of the day. Until about 3pm PST. I believe things are about back to normal right now, but there's always a ramp-up time to truly get back to normal. My apologies to anyone who was affected by our downtime. If you have any questions or concerns about anything, please let me know. Thanks, Bruce Bergman ListMaster, Fat City Hosting -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bruce A. Bergman 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: extracting schema
Title: extracting schema If you are on 9I, you can use dbms_metadata.get_ddl. You can also use export/import without data to get schema definition. -Original Message- From: [EMAIL PROTECTED]on behalf of[EMAIL PROTECTED] Sent: Mon 1/19/2004 5:04 AM To: Multiple recipients of list ORACLE-L Cc: Subject: extracting schema Hi all , How can I produce extract schema script(tables , tiggers , objects, procedures ..) from database. Any tool , script , idea ?ThanksArslan--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.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).DISCLAIMER:This message is intended for the sole use of the individual to whom it is addressed, and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you are not the addressee you are hereby notified that you may not use, copy, disclose, or distribute to anyone the message or any information contained in the message. If you have received this message in error, please immediately advise the sender by reply email and delete this message.
RE: ORA-06505 PL/SQL: variable requires more than 32767 bytes of contiguous memory - Thank You !!!!!
Dear Friends, (B (BThank you so much. Yes i was able to solve this issue.. (B (BFYI ... I used CONVERT function (B (B (BUTL_FILE.PUT_LINE(fh,convert('"$BD9=j%^%M!<%8%c!(J","$BEj;qL>(J","CAPID","$B
Re: Oracle vs Mysql
It needs not to have the same capabilities, it needs to have capabilities that people are using. The primary capabilities that people need, in my opinion, are a decent scripting language, with the full complement of the database triggers, procedures, packages and functions, ability to store/access/administer huge objects, hundreds of gigabytes in size, a decent SQL implementation with plethora of functions and a support for standard APIs like JDBC, ODBC, OLE and DBI. A good compiler support with something similar to long extinct SQL*Module (originally an IBM technology) and there would be huge number of users. Fortunately for oracle, MySQL still has problems with the most basic things: transactions, versioning, locking and SQL implementation. My conclusion is that MySQL will never be much more then a toy, despite the hype, catchy name and apparent popularity. I see much more dangerous adversaries in UDB (artist formerly known as DB2) and PostgresSQL. If IBM decides to play open source on Unix, and there are rumors of IBM musing over such a move, Oracle would most probably be toast. I must say that after some oracle's mischiefs, I wouldn't be the last one to defect and switch the databases. I wasn't the last one to leave DEC either, despite the fact that I was teaching VMS courses in 1992. My point is that Oracle is extremely feature rich. Very few people are using more then 20% of the database capabilities. Initially, in V8, I worked hard to learn about the Object PL/SQL, datatypes and classes. Believe it or not, I've never seen it used in production. By now, I've forgotten it all. It's almost the same situation with Java in the database. Very few are using it. Most people test it, then say aha! and move on. Those two features will not make a whole lot of difference when a viable competitor emerges. Oracle 10g was written, for the most part outside of US. With beta testing this closed and restricted, it's not going to be tested thoroughly, not even close to thoroughly. What we are likely to get is an unstable, buggy and almost unusable gridlock version. Competitor might emerge sooner then some people are realizing. On 2004.01.19 20:42, [EMAIL PROTECTED] wrote: If MySQL comes to have the same capabilities that many people expect from Oracle, marketing will have no effect. The huge differential in price point will be all that matters. Jared DENNIS WILLIAMS [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01/19/2004 04:04 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Oracle vs Mysql Sounds like the old Oracle vs. Ingress battles. Oracle won because it was better at marketing. All detailed in the book The Difference Between God and Larry Ellison. I can see it now -- MySQL, the Oracle of the free databases. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, January 14, 2004 4:39 PM To: Multiple recipients of list ORACLE-L Ryan, It's postgres.org. I'm not sure how they generate the operating revenue they need, but that's why they are not advertising like MySql AB is. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Wednesday, January 14, 2004 5:05 PM To: Multiple recipients of list ORACLE-L i thought postgre was a for profit company? how do they generate revenues? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, January 14, 2004 4:19 PM 1) DBI is a perl module to handle the communication with various databases. 2) Postgres is free. I believe that you can buy commercial support, but I don't know where. May be Rich can jump in with that. 3) DBI is free and so is perl. I'm cheap easy, but not free. On 01/14/2004 02:34:52 PM, Ryan wrote: what is DBI? is postgre free? Is it like linux where you pay for support? I cant find any licensing info on the website. Most shops dont need oracle, sql server, sybase, or DB2. Most applications are small. I was on a project where the government had an Oracle EE license on windows. They didnt even use foreign key constraints. Had a whopping 13 tables, 20 MB of data, and 10-15 users. Any free database could have handled that. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, January 14, 2004 1:44 PM On 01/14/2004 12:44:25 PM, Jesse, Rich wrote: If you have the choice, look at PostgreSQL in addition to MySQL. From what I've seen, it's more mature than MySQL. I second that. PostgresSQL supports transactions and uses perl as its scripting language. From what little I read and saw (just a little pilot project with the goal to see what the heck is
RE: RAC
Dear All, I am posting this again as It seems to have got lost Regards Sriram Kumar -Original Message- Sent: Monday, January 19, 2004 1:26 PM To: '[EMAIL PROTECTED]' Importance: High Dear Guru's, Firstly, apology if this question sounds silly. I am intrested in setting up a RAC configuration at my home with a few desktop PC's. I would run either Win2K or Redhat Linux for the same. I am not sure whether I would be able to setup the RAC using a few desktop PC's. I look fwd to your advise in setting up the same. I believe an external storage is required for setting up RAC. Can I configure a 3rd pc's hard disk as a external storage for RAC??. Your views are very much appriciated. Thanks and Regards Sriram Kumar DISCLAIMER: This message contains privileged and confidential information and is intended only for the individual named.If you are not the intended recipient you should not disseminate,distribute,store,print, copy or deliver this message.Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system.E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted,corrupted,lost,destroyed,arrive late or incomplete or contain viruses.The sender therefore does not accept liability for any errors or omissions in the contents of this message which arise as a result of e-mail transmission. If verification is required please request a hard-copy version. -- 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).
Re: RE: Oracle vs Mysql
DENNIS WILLIAMS [EMAIL PROTECTED] wrote: Sounds like the old Oracle vs. Ingress battles. Oracle won because it was better at marketing. All detailed in the book The Difference Between God and Larry Ellison. I can see it now -- MySQL, the Oracle of the free Bzzzt. Oracle won because it actually delivered a database that could be recovered from after a system crash. Which Ingres never did despite their claims to the contrary. And because Oracle's product could actually deliver performance very similar to Ingres, despite the unilateral RTI claims that their code was vastly superior. A similar situation to Sybase, really. It's really very simple: Ingres lost because they did not over the years deliver any major improvement to the original Uni-developed code. They simply milked it out all it could, then folded. Typical attitude back then. And I don't give a hoot what the book says: I WAS there, back then. Cheers Nuno Souto [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nuno Pinto do Souto 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: Thanx - I cleared the exam
Hi Dennis , thanx a lot for your encouraging words. my morale being high , let me go ahead with the next exam . Thanks and Regards, Prem. -Original Message- From: [EMAIL PROTECTED] Prem - We had no doubt. I always figure when you've studied enough to doubt your study guide, you're ready to pass the exam. Dennis Williams -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J 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[2]: Oracle vs Mysql
Monday, January 19, 2004, 11:04:26 PM, Mladen Gogala ([EMAIL PROTECTED]) wrote: MG A good compiler support MG with something similar to long extinct SQL*Module (originally an IBM technology) I used to use a SQL Module compiler. Not with Oracle though. It's rare for me to run into someone else who likes that approach. Actually, it's rare for me to encounter someone who's even heard of it... Best regards, Jonathan Gennick --- Brighten the corner where you are http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED] Join the Oracle-article list and receive one article on Oracle technologies per month by email. To join, visit http://four.pairlist.net/mailman/listinfo/oracle-article, or send email to [EMAIL PROTECTED] and include the word subscribe in either the subject or body. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Gennick 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: ADMIN: Status of list server systems (and update about
Bruce, My hat is off to your hard work to keep lists like this running. I know that I (and I'm sure many others) appreciate the huge brain trust that has come together here. Thanks and keep up the good work!!! Stephen [EMAIL PROTECTED] 01/19/04 06:39PM Folks -- I have good news and bad news. ;-) First the good news: Several people had mentioned that they've sent messages to some lists but have not seen the posts arrive back to them. These messages DID appear in the archives though. This started roughly 12-Jan-2004. I had previously researched this issue but could find no reason for it happening, nor a solution. Up until today, that is. The cuplrit was one of my load balancers for mailing list traffic. It was handling traffic correctly on some of the machines, but squirreling away messages sent to one specific server. I'd estimate about 1/8th of the messages sent to mailing lists since 12-Jan-2004 were not redistributed properly. I have since found and fixed the problem, so this shouldn't happen in the future. I suspect I was only able to re-send a portion of the missing messages, so my apologies for anyone who posted a message that didn't make it to a list. Also, my apologies to everyone who has to deal with the increased traffic of the old messages, plus current messages, plus the inevitable onslaught of re-posts that will occur in the next few days. Please be patient with each other. So the good news was: problem found, problem fixed, some catch up done, shouldn't happen again. The bad news is that this morning (roughly 7am PST), a construction crew near Fat City cut through a section of telecom cable that was critical for our connection to the net. They've been working feverishly on it all day, but Fat City was off the net most of the day. Until about 3pm PST. I believe things are about back to normal right now, but there's always a ramp-up time to truly get back to normal. My apologies to anyone who was affected by our downtime. If you have any questions or concerns about anything, please let me know. Thanks, Bruce Bergman ListMaster, Fat City Hosting -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bruce A. Bergman 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: Stephen Andert 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).
Spool to Excel File
Dear Friends, I am trying to send output from SQLPlus to Excel file. If any one did the same before please let me know. Thank You Mudhalvan M.M -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mudhalvan, Moovarkku 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
It needs not to have the same capabilities, it needs to have capabilities that people are using. Um, that's what I said, or at least meant. On Mon, 2004-01-19 at 20:04, Mladen Gogala wrote: It needs not to have the same capabilities, it needs to have capabilities that people are using. The primary capabilities that people need, in my opinion, are a decent scripting language, with the full complement of the database triggers, procedures, packages and functions, ability to store/access/administer huge objects, hundreds of gigabytes in size, a decent SQL implementation with plethora of functions and a support for standard APIs like JDBC, ODBC, OLE and DBI. A good compiler support with something similar to long extinct SQL*Module (originally an IBM technology) and there would be huge number of users. Fortunately for oracle, MySQL still has problems with the most basic things: transactions, versioning, locking and SQL implementation. My conclusion is that MySQL will never be much more then a toy, despite the hype, catchy name and apparent popularity. I see much more dangerous adversaries in UDB (artist formerly known as DB2) and PostgresSQL. If IBM decides to play open source on Unix, and there are rumors of IBM musing over such a move, Oracle would most probably be toast. I must say that after some oracle's mischiefs, I wouldn't be the last one to defect and switch the databases. I wasn't the last one to leave DEC either, despite the fact that I was teaching VMS courses in 1992. My point is that Oracle is extremely feature rich. Very few people are using more then 20% of the database capabilities. Initially, in V8, I worked hard to learn about the Object PL/SQL, datatypes and classes. Believe it or not, I've never seen it used in production. By now, I've forgotten it all. It's almost the same situation with Java in the database. Very few are using it. Most people test it, then say aha! and move on. Those two features will not make a whole lot of difference when a viable competitor emerges. Oracle 10g was written, for the most part outside of US. With beta testing this closed and restricted, it's not going to be tested thoroughly, not even close to thoroughly. What we are likely to get is an unstable, buggy and almost unusable gridlock version. Competitor might emerge sooner then some people are realizing. On 2004.01.19 20:42, [EMAIL PROTECTED] wrote: If MySQL comes to have the same capabilities that many people expect from Oracle, marketing will have no effect. The huge differential in price point will be all that matters. Jared DENNIS WILLIAMS [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01/19/2004 04:04 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Oracle vs Mysql Sounds like the old Oracle vs. Ingress battles. Oracle won because it was better at marketing. All detailed in the book The Difference Between God and Larry Ellison. I can see it now -- MySQL, the Oracle of the free databases. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, January 14, 2004 4:39 PM To: Multiple recipients of list ORACLE-L Ryan, It's postgres.org. I'm not sure how they generate the operating revenue they need, but that's why they are not advertising like MySql AB is. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Wednesday, January 14, 2004 5:05 PM To: Multiple recipients of list ORACLE-L i thought postgre was a for profit company? how do they generate revenues? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, January 14, 2004 4:19 PM 1) DBI is a perl module to handle the communication with various databases. 2) Postgres is free. I believe that you can buy commercial support, but I don't know where. May be Rich can jump in with that. 3) DBI is free and so is perl. I'm cheap easy, but not free. On 01/14/2004 02:34:52 PM, Ryan wrote: what is DBI? is postgre free? Is it like linux where you pay for support? I cant find any licensing info on the website. Most shops dont need oracle, sql server, sybase, or DB2. Most applications are small. I was on a project where the government had an Oracle EE license on windows. They didnt even use foreign key constraints. Had a whopping 13 tables, 20 MB of data, and 10-15 users. Any free database could have handled that. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, January 14, 2004 1:44 PM On 01/14/2004 12:44:25 PM, Jesse, Rich wrote: If you
Re: Thanx - I cleared the exam
When I was doing my OCP exams, I didn't have Dennis to cheer me up, only Heineken. Not that I'm complaining. On 2004.01.19 23:34, Prem Khanna J wrote: Hi Dennis , thanx a lot for your encouraging words. my morale being high , let me go ahead with the next exam . Thanks and Regards, Prem. -Original Message- From: [EMAIL PROTECTED] Prem - We had no doubt. I always figure when you've studied enough to doubt your study guide, you're ready to pass the exam. Dennis Williams -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J 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). -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala 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: Spool to Excel File
Hi, You won't be able to write an Excel format directly but you can create a .csv file, which Excel will happily read in - you'll just have no real formatting options. Look into some of the sql*plus commands like set heading off, set verify off, set feedback off, set pages 0, set lines 1000, set trimspool on. Of course you might want different settings to the ones I proposed but you will find these commands useful to get rid of stuff you don't (or perhaps do) want in the file. If you really want to generate a legitimate Excel file then start searching the web for programs to do this. I have seen one or two that do this reasonably well but cannot remember names. Regards, Mark. Mudhalvan, Moovarkku To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] [EMAIL PROTECTED]cc: apan.co.jp Subject: Spool to Excel File Sent by: [EMAIL PROTECTED] .com 20/01/2004 15:44 Please respond to ORACLE-L Dear Friends, I am trying to send output from SQLPlus to Excel file. If any one did the same before please let me know. Thank You Mudhalvan M.M -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mudhalvan, Moovarkku 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). Privileged/Confidential information may be contained in this message. If you are not the addressee indicated in this message (or responsible for delivery of the message to such person), you may not copy or deliver this message to anyone. In such a case, you should destroy this message and kindly notify the sender by reply e-mail or by telephone on (03) 9612-6999 or (61) 3 9612-6999. Please advise immediately if you or your employer does not consent to Internet e-mail for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of Transurban Infrastructure Developments Limited and CityLink Melbourne Limited shall be understood as neither given nor endorsed by them. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Richard 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: Spool to Excel File
PRANK Try with spool c:\Program*Files\Microsoft*Office\Office\excel.exe /PRANK On 2004.01.19 23:44, Mudhalvan, Moovarkku wrote: Dear Friends, I am trying to send output from SQLPlus to Excel file. If any one did the same before please let me know. Thank You Mudhalvan M.M -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mudhalvan, Moovarkku 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). -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala 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: Spool to Excel File
Hi, Years ago, I stole this idea from: http://www.quest-pipelines.com/newsletter-v3/newsletter_1002.htm I've used it a few times, mostly to impress bystanders. It's got size limitations, but kinda cool anyhow. QUOTE Getting SQL Query Results into an Excel Spread Sheet By Pavel Luzanov This months script will help users get SQL query results into an Excel spread sheet. SET LINESIZE 999 VERIFY OFF FEEDBACK OFF SET MARKUP HTML ON ENTMAP ON SPOOL ON PREFORMAT OFF DEFINE table_name = 1 SPOOL table_name..xls SELECT * FROM table_name; SPOOL OFF SET MARKUP HTML OFF ENTMAP OFF SPOOL OFF PREFORMAT ON SET LINESIZE 80 VERIFY ON FEEDBACK ON REM Use this command to start Excel from char-mode sqlplus REM HOST start table_name..xls REM Use this command to start Excel from GUI-mode sqlplus HOST start excel.exe table_name..xls \QUOTE Regards, Mike Thomas --- Mudhalvan, Moovarkku [EMAIL PROTECTED] wrote: Dear Friends, I am trying to send output from SQLPlus to Excel file. If any one did the same before please let me know. Thank You Mudhalvan M.M -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mudhalvan, Moovarkku 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). __ Do you Yahoo!? Yahoo! Hotjobs: Enter the Signing Bonus Sweepstakes http://hotjobs.sweepstakes.yahoo.com/signingbonus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Michael Thomas 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: Thanx - I cleared the exam
When I was doing my OCP exams, I didn't have Dennis to cheer me up, only Heineken.Not that I'm complaining. but Mladen , i can't stop with just one : )) so i better stay away from it during exams. Regards, Prem. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J 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).