OCP Question (Perf Tuning)
Hello: I was looking through some OCP questions posted on the web and came across the one below. I believe the answer is (D), because the join type would be dependent on the number of rows within the table. Is this correct or does the OPTIMIZER_MODE set to FIRST_ROWS alter this behavior? The cost-based optimizer can choose between a nested loops join and a sort merge join operation. All tables are analyzed and the OPTIMIZER_MODE is set to FIRST_ROWS. Which execution plan will be the result? a. The sort-merge join. b. The nested loops join. c. This depends on some sort parameter values. d. This depends on the number of rows in each table. _ Check your PC for viruses with the FREE McAfee online computer scan. http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jay Wade 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: OCP Question (Perf Tuning)
Thanks for the help. Do you have any ideas to the FIRST_ROWS behavior in regards to NL? I've been looking and found http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96533/optimops.htm#39473 it goes into detail about using hints for joins but now how the FIRST_ROWS forces a join selection on anything other then sample size. I'm interested to know more about the behavior and the links that I am finding don't seem to offer the depth I thought they would. Or maybe they do and I'm missing the boat From: Ryan [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: OCP Question (Perf Tuning) Date: Tue, 06 Jan 2004 11:34:26 -0800 thought so, I'm not 100% certain the OCP will say that though. alot of inaccuracies in that test. btw, Ive been playing with first_rows lately. I've noticed that it has a preference for 'INDEX FULL SCAN' over 'INDEX RANGE SCAN'. Ive found that in some test cases where you have two tables approximately 3m and 1.5m rows in size, that INDEX RANGE SCAN actually returns the first 25 or so records faster, than 'INDEX FULL SCAN', there by making FIRST_ROWS, inferior. Surprised me. I've read some docs on this and I think that a range scan is always preferably when you only want a few rows? What am I missing? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, January 06, 2004 1:59 PM Nope. The answer is b). In the FIRST_ROWS mode, optimizer prefers NL to all other methos despite the price. On 2004.01.06 13:44, Jay Wade wrote: Hello: I was looking through some OCP questions posted on the web and came across the one below. I believe the answer is (D), because the join type would be dependent on the number of rows within the table. Is this correct or does the OPTIMIZER_MODE set to FIRST_ROWS alter this behavior? The cost-based optimizer can choose between a nested loops join and a sort merge join operation. All tables are analyzed and the OPTIMIZER_MODE is set to FIRST_ROWS. Which execution plan will be the result? a. The sort-merge join. b. The nested loops join. c. This depends on some sort parameter values. d. This depends on the number of rows in each table. _ Check your PC for viruses with the FREE McAfee online computer scan. http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jay Wade 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 removed from). You may also send the HELP command for other information (like subscribing). _ Working moms: Find helpful tips here on managing kids, home, work and yourself. http://special.msn.com/msnbc/workingmom.armx -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jay Wade INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services
Re: Re[2]: OCP Question (Perf Tuning)
Thanks again for all your help. Does the ALL_ROWS hint force a preference in Join Types as well? If so would it try to force a HASH JOIN? From: Mladen Gogala [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: Re[2]: OCP Question (Perf Tuning) Date: Tue, 06 Jan 2004 13:24:25 -0800 Oracle doesn't but Jonathan Lewis does, in his Tutorials. I found out about that from Scott Gosset in 8i internals class in NYC. Seems still to be true. Gospel of Jonathan should suffice, however. I just discovered that my 10053 trace name errorstack forever, level 12 causes ORA-600 in 9.2. Let me look for a patch and I'll come back later. As for the question being nontrivial and unfair, I agree. On 2004.01.06 14:29, Jonathan Gennick wrote: Tuesday, January 6, 2004, 1:59:26 PM, Mladen Gogala ([EMAIL PROTECTED]) wrote: MG Nope. The answer is b). In the FIRST_ROWS mode, optimizer prefers NL to all other MG methos despite the price. Does Oracle themselves *document* that what you say is the case? I believe you, but I'm not sure that Oracle documents what you just said, so short of looking at the code, I'm not sure how anyone could be expected to really *know* what the answer to the original question was, which makes me wonder if the question is really even a fair question to ask. Do we *know* that B is the case, or have we just always *observed* that it *happens to be* the case? 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. MG On 2004.01.06 13:44, Jay Wade wrote: Hello: I was looking through some OCP questions posted on the web and came across the one below. I believe the answer is (D), because the join type would be dependent on the number of rows within the table. Is this correct or does the OPTIMIZER_MODE set to FIRST_ROWS alter this behavior? The cost-based optimizer can choose between a nested loops join and a sort merge join operation. All tables are analyzed and the OPTIMIZER_MODE is set to FIRST_ROWS. Which execution plan will be the result? a. The sort-merge join. b. The nested loops join. c. This depends on some sort parameter values. d. This depends on the number of rows in each table. _ Check your PC for viruses with the FREE McAfee online computer scan. http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jay Wade 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). MG -- MG Mladen Gogala MG Oracle DBA MG -- MG Please see the official ORACLE-L FAQ: http://www.orafaq.net -- 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). -- 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
Simple SQL Question
Hello: I'm trying to figure out the new 9i outer joins. I can get a single table outer join working without any issues. But seem to keep getting errors when trying to do a two table outer join. I know it is just something with my syntax. Could anyone provide a quick sample, thanks in advance. A:= Base Table B:= Child Table 1 B:= Child Table 2 select a.emp, b.ValueA c.ValueB From base_table A outer join child_Table1 B on A.emp=B.Emp... I know the old way of select a.emp, b.ValueA c.ValueB From base_table A, child_Table1 B, child_Table2 C where A.emp=B.Emp(+) and A.emp=C.Emp(+) _ Grab our best dial-up Internet access offer: 6 months @$9.95/month. http://join.msn.com/?page=dept/dialup -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jay Wade 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).
IOT Tuning Question
Hello: I'm looking at trying to tune a 3rd party app and was wondering if anyone could tell me if my assumptions are on base. The table contains three columns, each is part of the primary key, with about 1 million + rows. I figured that it would be an ideal candidate for using a partitioned IOT, but since records are frequently inserted am I correct in assuming that it would be better to use regular partitioned table using a primary key? Since this is a 3rd party application I can't change much of the layout, if anyone has any ideas it would be greatly appreciated. Regards, Jay _ Groove on the latest from the hot new rock groups! Get downloads, videos, and more here. http://special.msn.com/entertainment/wiredformusic.armx -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jay Wade 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).
10g: SQL Plus
Hello: Was watching Larry Ellison's key note and he mentioned that they still have SQL Plus in 10g. I heard rumor that it was removed. Since it seems as though some from this list have seen it does it still have SQL Plus or has it been removed? Thanks In Advance, Jay _ High-speed Internet access as low as $29.95/month (depending on the local service providers in your area). Click here. https://broadband.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jay Wade 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 Script Documentation
Sounds like a project, I'll see if I can try to get each files brief definiation and then what it's calling scripts are. Should be interesting to see that the dependencies are. From: DENNIS WILLIAMS [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Oracle Script Documentation Date: Fri, 05 Sep 2003 07:24:29 -0800 Jay Here is your chance to join the big league and become an expert in your own area. One thing I've noticed in tracing the scripts is that many of the scripts call each other. Something like catproc must call dozens of the other scripts. Not that much need to understand every low-level script. But then there are probably some overlooked gems that we aren't aware of. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, September 05, 2003 9:45 AM To: Multiple recipients of list ORACLE-L Hi Jay, I know this is obvious but each script generally has a short description at the top of each file. Some of these are pretty short one liners bear in mind but it is a start!. If you do find a complete list let us know it sounds like it could be useful to know where a list for the future. hth 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). -- 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). _ Send and receive larger attachments with Hotmail Extra Storage. http://join.msn.com/?PAGE=features/es -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jay Wade 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: ODP.NET and LONG RAW
I haven't had a chance to work with this senerio much but it seems to look like it would work, have you tried to pass the value to a stored procedure then have the stored procedure insert into the table? I haven't had much experience with ODP but the MS Oracle Provider is really buggy with parameters. From: Kevin Toepke [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: ODP.NET and LONG RAW Date: Fri, 29 Aug 2003 06:31:23 -0800 Help! I am having trouble loading a JPEG image into Oracle via ODP.NET. I am getting the ORA-00932: Inconsistent datatypes error message when attempting to load the image into a LONG RAW column. If this wan't an Oracle Apps table, I would use a BLOB column instead of a LONG RAW, but my hands are tied. I have enclosed the code I am using to attempt to load the image. I know its probably something stupid, but I just can't see it in the pre-long weekend fog. TIA Kevin Private Sub loadOracle(ByVal intPersonID As Integer, _ ByVal img As Image) Dim ms As New System.IO.MemoryStream() img.Save(ms, System.Drawing.Imaging.ImageFormat.Jpeg) Dim b(ms.Length - 1) As Byte ms.Position = 0 ms.Read(b, 0, ms.Length) Dim ob As New OracleBinary(b) Dim sp(2) As OracleParameter sp(0) = New OracleParameter(i_person_id, OracleDbType.Int64, ParameterDirection.Input) sp(0).Value = intPersonID sp(1) = New OracleParameter(i_table_name, OracleDbType.Varchar2, ParameterDirection.Input) sp(1).Value = PER_IMAGES sp(2) = New OracleParameter(i_img, ob) sp(2).DbType = DbType.Binary sp(2).Direction = ParameterDirection.Input sp(2).OracleDbType = OracleDbType.LongRaw sp(2).Size = ob.Length sp(2).Value = ob Dim sql As String sql = INSERT INTO hr.per_images ( _ image_id _ ,image _ ,parent_id _ ,table_name _ ) VALUES ( _ hr.per_images_s.NEXTVAL _ ,:i_img _ ,:i_person_id _ ,:i_table_name _ ) cOracle.runDML(sql, sp, Me.ToString) End Sub _ Get MSN 8 and help protect your children with advanced parental controls. http://join.msn.com/?page=features/parental -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jay Wade 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).
OCP Question
Hello: I was going through some OCP questions and wanted to make sure that my answers where correct. This question comes from a 3rd party testing site, I have been checking each question against my study guides to make sure they are correct. I've done some testing and think that my answers might be correct but would like to double check as well as get anyone elses option on the answers and the reasoning for option E. When the status of the tablespace moves from read-only to read write, which tow events occur? (Choose Two) A) Redo-log switch must take place B) Normal checkpoints on the file now occur C) Oracle automatically marks the file for backup D) All objects in the tablespace are checked for integrity E) The the DBWn process writes to the data files of the tablespace I believe the answers are A, B Reason: A) I tested moving the a tablespace from read-only to read write and have noticed a log switch after moving the tablespace to a writeable state. B) Since it is on longer Read-Only it will be updated during the checkpoint process C) Doesn't happen, at least in my reading or testing D) No verify structure is issued, or any of the other oracle tools for object checking are used E) I'm alittle unsure of this one, it should update the headers how since it is in a Read Write mode, although this should only happen at a checkpoint right? Thanks in Advance, Jay _ MSN 8 with e-mail virus protection service: 2 months FREE* http://join.msn.com/?page=features/virus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jay Wade 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).
More On 10G
Came across this article thought the group might be interested. Any ideas on a release date for 10G, I know they are going to unveil it at OpenWorld, any quess on the release date? http://www.eweek.com/article2/0,3959,1209597,00.asp _ MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*. http://join.msn.com/?page=features/virus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jay Wade 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 display FLOAT in 99999.999 format
Could it be something with the program you are executing it from? When I ran the 1234.1 in SQL*Plus I got the below. I'll see if I can dig up another formatting optoin. [EMAIL PROTECTED]:SQL select TO_CHAR(1234.1,'9.999') FROM DUAL; TO_CHAR(12 -- 1234.100 [EMAIL PROTECTED]:SQL From: Odland, Brad [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: How to display FLOAT in 9.999 format Date: Fri, 01 Aug 2003 10:39:24 -0800 Tried that. 1234.1 won't show the trailing zeros... -Original Message- Sent: Friday, August 01, 2003 1:19 PM To: Multiple recipients of list ORACLE-L Not sure if this is the best way but you could do something like SELECT TO_CHAR(1,'999.999') FROM DUAL; Only drawback that I have been running into is if you don't allot of enough spaces before the decimal it display a value of . Hope this helps. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, August 01, 2003 12:14 PM How do I force display of a FLOAT in a format like Original number Result 1234.34 1234.340 12345.456 12345.456 123.1 123.100 123123.000 The dev on a project wants to preformat the data for a report on the database side. He wants 3 places after the decimal to display even if the number is a whole number (I know most VB report controls do this easilybut...) I thought it was complicated as it would require a to_char with format description then searching for the postion of the decimal and then moving from there to the right counting the characters if the number of characters to the right of the decimal was 3 then pad with zeros... I messed around with RPAD, TRUNC, ROUND and TO_CHAR and found I was not able handle all cases of possible significant digits. Sounded like a complicated function to do something thats automagic in a reporting control. Or am I forgetting a oracle functionor fomat? This is 8.1.7 I told the developer to use the field formatting contols of his reporting control because the additional zeros padded in a number are basically meaningless in a database and mathematical operations. Brad O. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Odland, Brad 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: Odland, Brad 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). _ Protect your PC - get McAfee.com VirusScan Online http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jay Wade 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
Re: ORA-03115 (TOAD question!!)
I would recommend upgrading to 7.6.x you can download it from www.quest.com From: AK [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: ORA-03115 (TOAD question!!) Date: Tue, 29 Jul 2003 07:49:23 -0800 Not sure but this might have something to do with charset (if toad can handle clob??? ) . what is db charset ? is it utf8 . -ak - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, July 29, 2003 8:19 AM Hi, I have Oracle 8i Enterprise Server, Oracle 9i Enterprise Server and Oracle 7.3.4 client on my NT4 machine. When I connect to remote/local databases through TOAD 6.5 (which supports LOBs) and try to fetch a CLOB value I get the 'ORA-03115: Unsupported network datatype or representation'. I think that this error is due to the limitation of CLOBs in SQL*Net 2.3 which comes with 7.3.4 client. However, I have set the default home to ORA_8i_HOME(which has Net8) using the 'Home Selector' utility. Also, TOAD is reading the TNSNames.Ora file from this home, so should be using Net8 rather than SQL*Net. I have Googled and searched Metalink, but got no clearcut reply. Can you please suggest any way to rectify it? Thanks regards, Charu. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Charu Joshi 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). _ Protect your PC - get McAfee.com VirusScan Online http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jay Wade 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: H1-B (was: * Sr. Oracle DBA with 8i and 9i experience needed..)
optimization, use of hints. Optimal setup of dblink, views, and use of Oracle gateway is required. Must understand how to design and tune an Oracle database to optimize performance for potentially thousands of concurrent, browser-based users together with ETL processes. -Excellent written and verbal communications skills with the ability to effectively communicate technical and business problems/issues in a non-technical manner, strong problem resolution, analysis, and customer service skills are required. -Ability to manage multiple tasks with shifting priorities is a necessity. -Ability to work within a team environment and communicate effectively with other team members is required. -Proven mentoring skills to build the strength of the DBA staff. For immediate consideration, please email your resume as an attachment to: OraStaff, Inc. Email: [EMAIL PROTECTED] Please Use Job Code: Minn./DBA/MH Phone: 1-800-549-8502. I pay referral fees. So please contact me if you know of anyone who would be qualified/interested in the position described above- if it is not a match for your skills. Thanks. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net === message truncated === __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael 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: Anjan Thakuria 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). _ The new MSN 8: advanced junk mail protection and 2 months FREE* http://join.msn.com/?page=features/junkmail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jay Wade INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: SQL question - crosstab in oracle
There are several ways to handle this. If you do a search for pivot on AskTom you will get a good sampling of them. From: [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: SQL question - crosstab in oracle Date: Tue, 08 Jul 2003 06:34:24 -0800 Hi I have a table with the following structure. CHECK_DATE DATE PHYRDS NUMBER(20) PHYWRTSNUMBER(20) PHYBLKRD NUMBER(20) PHYBLKWRT NUMBER(20) FILE# NUMBER FILE_NAME VARCHAR2(120) This records the IO on the different datafiles every 3 minutes. I want to run a report on this table but I want the output to display on file# as a heading.Similar to iostat on UNIX. So my output might be: Check DATE FIle1 File2 File3 etc... PHYRDS PHYWRTS PHYRDS PHYWRTS 11:14:341270820218 14 11:18:261303821118 14 11:33:441429024318 14 11:40:451500824518 14 11:45:371545924918 14 11:48:381577625018 14 11:51:371586425118 14 11:54:371602925418 14 11:57:391621025418 14 12:00:401631125418 14 12:03:401643925618 14 I could do this as a bit of plsq but Is it possible to generate this report with one bit of sql. (views,inline views, decodes. etc) thanks stephen ** This email contains information which is confidential. It is for the exclusive use of the addressee. If you are not an addressee please contact us immediately on 01737 275500. Please note that any distribution, copying or use of this communication or its contents is prohibited. This footnote also confirms that this email message and all associated attachments have been swept by Network Associates VirusScan for the presence of computer viruses. ** -- 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). _ The new MSN 8: advanced junk mail protection and 2 months FREE* http://join.msn.com/?page=features/junkmail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jay Wade 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: erwin
hello: The below has info about the product: http://www3.ca.com/Solutions/Product.asp?ID=260 The below has the download link: http://www3.ca.com/Solutions/Collateral.asp?CID=33655ID=260 From: [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: erwin Date: Mon, 07 Jul 2003 04:54:25 -0800 How can I found a trial version of erwin Danke... Arslan. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [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). _ Add photos to your messages with MSN 8. Get 2 months FREE*. http://join.msn.com/?page=features/featuredemail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jay Wade INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Oracle Book Clubs/Lists?
Hello: Is there any Oracle book clubs worth looking into? If so could someone forward me a link? Thanks in Advance, Jay _ MSN 8 with e-mail virus protection service: 2 months FREE* http://join.msn.com/?page=features/virus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jay Wade 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).
8i OCP Question
Hello: I'm taking a 8i Backup Recovery Practice test and believe the answer key might be off. Question Which statement regarding Recovery Manager with a database operating in NOARCHIVELOG mode is true? A) Recovery Manager requires a recovery catelog B) Recovery Manager syooirts multi-level incremental backups C) Recovery Manager is compatible with Enterpise Backup utility D) Recovery Manager only works in conjunction with a tap subsystem Anwser key says that D is the correct answer. I would say that C is the correct answer since only a full offline backup can be performed. Thanks in Advance, Jay _ Protect your PC - get McAfee.com VirusScan Online http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jay Wade 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: 8i OCP Question
This is from an outside vendor, usually they are good but I can't seem to figure this one out. I know that you can allocate a channel to disk on a NoArchiveLog mode database through Rman. Also, only full backups (offline) can be taken if the db is in NoArchiveLog mode. The only thing that I thought might work is that in OEM backup manager only full backups are allowed on NoArchivelog db's at least that is my understanding. From: [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: RE: 8i OCP Question Date: Tue, 17 Jun 2003 12:59:20 -0800 are these the questions you buy from oracle corporation? or from some outside vendor? if so who? I wont get those. If its from oracle, that is troubling... since the test might be wrong also. From: Mercadante, Thomas F [EMAIL PROTECTED] Date: 2003/06/17 Tue PM 04:20:10 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: 8i OCP Question Jay, the answer is B is the funny word there really is supports. C is the the predecessor to Rman - and it only works in Oracle version 7. A and D are just plain false. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, June 17, 2003 3:45 PM To: Multiple recipients of list ORACLE-L Hello: I'm taking a 8i Backup Recovery Practice test and believe the answer key might be off. Question Which statement regarding Recovery Manager with a database operating in NOARCHIVELOG mode is true? A) Recovery Manager requires a recovery catelog B) Recovery Manager syooirts multi-level incremental backups C) Recovery Manager is compatible with Enterpise Backup utility D) Recovery Manager only works in conjunction with a tap subsystem Anwser key says that D is the correct answer. I would say that C is the correct answer since only a full offline backup can be performed. Thanks in Advance, Jay _ Protect your PC - get McAfee.com VirusScan Online http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jay Wade 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: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Add photos to your e-mail with MSN 8. Get 2 months FREE*. http://join.msn.com/?page=features/featuredemail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jay Wade 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: 8i OCP Question
Does that apply to 8i databases as well? From: Freeman Robert - IL [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: 8i OCP Question Date: Tue, 17 Jun 2003 13:24:41 -0800 B is the correct answer. Incremental backups are supported in archivelog and noarchivelog mode. Rman does not require a recovery catalog. RMAN is not compatible with EBU RMAN works just fine to disk. Robert Oracle9i RMAN Backup and Recovery Freeman -Original Message- To: Multiple recipients of list ORACLE-L Sent: 6/17/2003 3:25 PM The answer is D; RMAN does not require a recovery catalog RMAN only supports multi-level incremental backups when DB is in Archivelog mode RMAN is NOT compatible with EBU -Original Message- Jay Wade Sent: Tuesday, June 17, 2003 2:45 PM To: Multiple recipients of list ORACLE-L Hello: I'm taking a 8i Backup Recovery Practice test and believe the answer key might be off. Question Which statement regarding Recovery Manager with a database operating in NOARCHIVELOG mode is true? A) Recovery Manager requires a recovery catelog B) Recovery Manager syooirts multi-level incremental backups C) Recovery Manager is compatible with Enterpise Backup utility D) Recovery Manager only works in conjunction with a tap subsystem Anwser key says that D is the correct answer. I would say that C is the correct answer since only a full offline backup can be performed. Thanks in Advance, Jay _ Protect your PC - get McAfee.com VirusScan Online http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jay Wade 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: Gary W. Parker 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: Freeman Robert - IL 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). _ Help STOP SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jay Wade 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: example to use bind variables with OO4O/VB
I found this link really helpful during my development projects using oo4o. http://technet.oracle.com/doc/oracle8i_816/nt.816/a8/o4o00259.htm From: Regis Biassala [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: example to use bind variables with OO4O/VB Date: Thu, 05 Jun 2003 05:44:47 -0800 go to your: %ORACLE_HOME%\oo4o\VB\SAMPLES it has a lot of example which should help Regis -Original Message- Sent: Thursday, June 05, 2003 1:00 PM To: Multiple recipients of list ORACLE-L Guys, can someone give a simple example ( piece of code ) for: How to use bind variables with OO40/VB6 to connect to a 8.1.6 database ? ..peeped into metalink too. can u give me any other example / URL for the same ???! TIA. Jp. -- 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). * This electronic transmission is strictly confidential and intended solely for the addressee. It may contain information which is covered by legal, professional or other privilege. If you are not the intended addressee, you must not disclose, copy or take any action in reliance of this transmission. If you have received this transmission in error, please notify the sender as soon as possible. This footnote also confirms that this message has been swept for computer viruses. ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Regis Biassala 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). _ The new MSN 8: smart spam protection and 2 months FREE* http://join.msn.com/?page=features/junkmail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jay Wade INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Using bind variables with ADO in VB
Hello: You can bind values using the command object. Set the command type to text then add your parameters similar to how you would call a stored procedure. The SQL would looks something like SELECT NAME FROM EMP WHERE EMPID=:PEMPNO Also, if ADO (and ADO.Net) will bind the values for you, this can be seen in your code when monitoring using Quests SQL Monitor. Although it is always better to do it yourself since the execution will be quicker and the values will be bound the first time. From: [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Using bind variables with ADO in VB Date: Fri, 06 Jun 2003 09:04:00 -0800 Yet another reason not to use VB or anything like it. http://www.amazon.com/exec/obidos/ASIN/020177061X Craig Healey [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 06/06/2003 08:59 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Using bind variables with ADO in VB I don't THINK so. To quote further the parameters are not bound except in the case of stored procedures...In the case of normal SQL, ADO replaces the placeholder with Parameter.Value, so there is no binding on the server side. The way I read that, you can't use bind variables in VB using ADO. Craig Healey -Original Message- From: Stefan Jahnke [mailto:[EMAIL PROTECTED] Sent: 06 June 2003 14:55 To: Multiple recipients of list ORACLE-L Subject: AW: Using bind variables with ADO in VB Hi Question: Are you sure that the binding you're referring to (your book excerpt) doesn't mean early bindig versus late binding in VB using ADO ? Stefan -Original Message- Sent: Friday, June 06, 2003 12:35 PM To: Multiple recipients of list ORACLE-L Having read that bind variables will solve all our problems ;-) I've tried to get the developers to use them. There response being: how? I don't know much VB and they don't know what a bind variable is. So I read with interest J Prem's question. Now knowing what to look for, I read further, and found that ADO also does not bind (compile to p-code) parameterized statements in Oracle (VB Oracle 8 by Dov Trietsch) 8-( Is it true? Are bind variables that big a deal in VB code anyway? We have a lot of badly written code, so are we better off re-writing the code without bothering about bind variables at the moment? Am I worrying about nothing? And no, it doesn't scale particularly well! Regards Craig Healey ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. Statements and opinions expressed in this e-mail may not represent those of the company. If you have received this email in error please notify [EMAIL PROTECTED] This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses (www.mimesweeper.com) *** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Craig Healey 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: 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). _ Help STOP SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jay Wade INET: [EMAIL
OCP Test Order
Hello: I resently finished my 8i Backup and Recovery test and was thinking about taking the 8i Networking testing before performance tuning. I was wondering if those of you that have taken both test feel that would be an ok choice of action or would taking performance tuning first be better? Thanks In Advance, jay _ Protect your PC - get McAfee.com VirusScan Online http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jay Wade 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: Recommendations
I would use web services as the baseline technology. Then the UI would pretty independent (Java, .Net, just about anything). This would also allow you an easily expandable platform. Awhile ago I saw a demo of JDeveloper and it seemed to make the process very functional. I'm currently on a project using Oracle and .Net, which also works but seems to require alittle more patience and understanding. From: Ramon E. Estevez [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Recommendations Date: Mon, 02 Jun 2003 16:14:54 -0800 Hi list, I have to develop an interface to allow another company, with 60 offices, to make some kind of transactions in my system with my clients. I am thinking of using Forms9i. What should I consider ? Any comments would be highly appreciated. TIA, Ramon E. Estevez [EMAIL PROTECTED] 809-535-8994 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ramon E. Estevez 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). _ Protect your PC - get McAfee.com VirusScan Online http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jay Wade 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: AW: From Microsoft Access to Oracle
Santosh: Would this project require any type of reporting which is highly formatted? If not I would Stefan recommended and us VB6 (or VB.Net, if so use the MS Oracel Data Provider). This will give you all the functionality you will need. If basic reports are required you could always use the MS Excel object to create them (Excel must be on the machine though). From: Stefan Jahnke [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: AW: From Microsoft Access to Oracle Date: Tue, 18 Mar 2003 05:23:43 -0800 Hi We extensively used OO4O with Access 2000. It works fine, gives you all the Oracle specific stuff, but ... it's more work, since you have to code more things. I personally think it's worth it, eventhough I wouldn't go with Access in the first place. If it has to be VB, why not use VB 6.0 and Access just to display reports. There are lots of things (e.g. using ocx controls like the MS tree control in Access) that make you want to commit suicide. Nevertheless, the data access itself through OO4O works and we didn't have any problems with it. Regards, Stefan Stefan Jahnke Consultant BOV Aktiengesellschaft Voice: +49 201 - 4513-298 Fax: +49 201 - 4513-149 mailto: [EMAIL PROTECTED] Please remove nospam to contact me via email. visit our website: http://www.bov.de http://www.bov.de/ subscribe to our newsletter: http://www.bov.de/presse/newsletter.asp http://www.bov.de/presse/newsletter.asp Sicherheitsluecken mit IT-Security-Konzepten von BOV effizient schliessen! Weitere Informationen unter +49 201/45 13-240 oder E-Mail an mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] . Wie Sie wissen, koennen ueber das Internet versandte E-Mails leicht unter fremden Namen erstellt oder manipuliert werden. Aus diesem Grunde bitten wir um Verstaendnis dafuer, dass wir zu Ihrem und unserem Schutz die rechtliche Verbindlichkeit der vorstehenden Erklaerungen und Aeusserungen ausschliessen. As you are probably aware, e-mails sent via the Internet can easily be copied or manipulated by third parties. For this reason we would ask for your understanding that, for your own protection and ours, we must decline all legal responsibility for the validity of the statements and comments given above. -Ursprüngliche Nachricht- Von: Jay [mailto:[EMAIL PROTECTED] Gesendet: Dienstag, 18. März 2003 13:19 An: Multiple recipients of list ORACLE-L Betreff: Re: From Microsoft Access to Oracle The easiest way is to ODBC link the tables and develop like it is an MS Access project. This is not the best way due to security and a host of other issues. I have seen using ADO oo4o through VBA to make the connection. This seems to work ok, but does require alittle more coding then the average MS Access database project. OTN has some great sections of using ADO and oo4o. - Original Message - To: Multiple recipients of list ORACLE-L mailto:[EMAIL PROTECTED] Sent: Tuesday, March 18, 2003 1:08 AM Hello list, I want to create a new form in Access where user input will be thereand the data entered i have to store it in Oracle database. Can anyone of you guide me in doing this..How ??? Thanks and Regards, Santosh _ Protect your PC - get McAfee.com VirusScan Online http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jay Wade 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).
Question On High Parse to execute ratio
Hello: I have a third party application which seems to have alot of unbound SQL statements, several of which do not seem to be very effective queries. Unfortunatelly the code is locked. My Parse to execute ratio is around 72% and I was wondering if anyone has any ideas on how I can decrease this? I figure that I might start with using the parameter CURSOR_SHARING. Any ideas would be great. Thanks in advance, Jay _ Help STOP SPAM: Try the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jay Wade 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: Flat file generation integrity ideas...
Just an idea but how about using Java Stored Procedures? They would allow better control over OS files. Also they would be housed within the database. Combine this with some Oracle XML technology your work could be made alittle easier. Although memory intensive. From: Jared Still [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: Flat file generation integrity ideas... Date: Sat, 26 Oct 2002 20:38:30 -0800 And I don't have proof, but I am absolutely positive that using UTL_FILE is faster then Perl...I just know it isit's gotta be... :) I'm currently working on a little project for someone to create a table unloader in PL/SQL. Before you ask, I can't share on this one, it's proprietary. And it has to be done from the database. :( A limitation of UTL_FILE is that the output line length is limited to 32767 characters. 32768 including the LF. Some problems with unloading in PL/SQL are obvious: What if the line is longer than 32767? I'm going to create continuation lines in the file. An external utility will need to be run to 'correct' these lines. What if there is a LONG column. Ugh. These can be dealt with, but it ain't pretty. Think global temporary tables and the TO_LOB SQL function to convert them to a LOB, so that DBMS_LOB may be used to read them. I'm going to allow NCLOBS, CLOBS only. No BLOB or LONG RAW columns. I don't know of any way to load these from sqlldr if the column length exceeds 32767. ( via utl_raw package ) Of course, none of this may be a problem with your data. Jared I will take a look at sqlunldr.pl, thanks. CG -Original Message- From: Jared Still [mailto:jkstill;cybcon.com] Sent: Sat 10/26/2002 10:45 PM To: [EMAIL PROTECTED]; Tim Gorman; Grabowy, Chris Cc: Subject: Re: Flat file generation integrity ideas... I was going to suggest MD5 as well. Though I was thinking of the Perl version. The DBMS_OBFUSCATION version is fine, but I was thinking of the unload method. Chris, how are you creating the flat files? UTL_FILE? SqlPlus? Perl is much faster than sqlplus, dunno about UTL_FILE, as I haven't compared them for speed. (yet) PL/SQL also requires about 10x more code for this kind of thing than Perl. You *could* just modify the sqlunldr.pl script in Perl for Oracle DBA's to add MD5 checksums at the beginning of the line. You could also easily\ MD5 the entire file in one line of code. If you're using C, well, you're just working too hard. ;) Jared On Thursday 24 October 2002 15:24, Tim Gorman wrote: RE: Flat file generation integrity ideas...DBMS_OBFUSCATION_TOOLKIT has an (undocumented) function called MD5 which uses that protocol (MD5) to calculate checksums. Look at $OH/rdbms/admin/dbmsobtk.sql... - Original Message - From: Jamadagni, Rajendra To: Multiple recipients of list ORACLE-L Sent: Thursday, October 24, 2002 12:46 PM Subject: RE: Flat file generation integrity ideas... you could also use dbms_utility.get_hash_value ... to compute hash value for the whole row and store that as an additional column. Be syre to use the same parameters on both sides to compute and test, else it will fail the check. Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! Content-Type: text/html; charset=iso-8859-1; name=Attachment: 1 Content-Transfer-Encoding: quoted-printable Content-Description: -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- 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). _ Internet access plans that fit your lifestyle -- join MSN. http://resourcecenter.msn.com/access/plans/default.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay Wade INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services
RE: PL/SQL Editor
Benthicsoftware has a good series of editors. They are all about US$30 a piece or so. Not as powerfull as TOAD but if you are just doing PL/SQL Development they work great. From: Magaliff, Bill [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: PL/SQL Editor Date: Wed, 28 Aug 2002 06:18:24 -0800 we're currently looking into this, too Our developers like TOAD, but the licensing cost is pretty steep - $700 a pop for the most pared down version. Quest was willing to offer us a one-time half-price offer, but for the 50 users we were considering it still comes out to over $15,000. PL/SQL Developer does basically everything TOAD does (that our developers do, at least) - explain plans, autotrace, stats, etc. - but with a price cap of $3,000 for unlimited user license it's very attractive. Their email support is pretty good, too - never wait more than a few hours for a response, usually by the same guy. All in all pretty good bang for the buck, and we'll probably end up purchasing it this week or next. I've also looked at Embarcadero's Rapid SQL, which I personally prefer over all the others, but the price is in the same league as TOAD. BMC has product that I haven't really looked into, but I think pricewise it's up there. One note about the Freeware version of TOAD - it has some internal thing that limits it to 5 concurrent connections to the same db, which is a problem for us in a dev shop. -bill -Original Message- Sent: Wednesday, August 28, 2002 8:18 AM To: Multiple recipients of list ORACLE-L PL/SQL Developer. http://www.allroundautomations.nl/plsqldev.html very very good. -Mensaje original- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]En nombre de Ofer Harel Enviado el: miércoles, 28 de agosto de 2002 9:13 Para: Multiple recipients of list ORACLE-L Asunto: RE: PL/SQL Editor Try free Toad at http://www.toadsoft.com/downld.html regards Ofer Harel DBA team Barak ITC [EMAIL PROTECTED] -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 28, 2002 8:33 AM To: Multiple recipients of list ORACLE-L Hi All, which is the best PL/SQL editor available as a trial version . the editor should support Oracle sql,PL/SQL and may or may not support debugging. The tool should be support Win 9X OS and provide best performance . -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Juan Miranda INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Magaliff, Bill INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). I no longer need to punish, deceive, or compromise myself, unless I want to stay employed. _ Send and receive Hotmail on your mobile device: http://mobile.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay Wade INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Explain Plan Question
Hello: I have to looking through Metalink but am unable to find the following. Does running Explain Plan take into Account the Cost Generated By using PL/SQL Functions? For example Select * from EMP where EMPID=FUNCTION_GET_ID; I do not believe that it does since the Function SQL does not seem to be included in the Plan Output. Is this correct? Regards, Jay _ Send and receive Hotmail on your mobile device: http://mobile.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay Wade INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: set sql*trace VB/Crystal
What connection are they using? If they are using Oracle Object Of OLE I think there is a parameter that can be set. From: [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: set sql*trace VB/Crystal Date: Mon, 12 Aug 2002 13:08:23 -0800 If you want to see the trace do the following connected to the appropriate database: SQL show parameters dump; NAME TYPEVALUE --- -- background_core_dump string partial background_dump_dest string /opt/oracle/admin/ods/bdump core_dump_dest string /opt/oracle/admin/ods/cdump max_dump_file_size string UNLIMITED shadow_core_dump string partial user_dump_dest string /opt/oracle/admin/ods/udump I believe it is under user_dump_dest - and is constrained by the max_dump_file_size. You will then need to use tkprof commands to format *.trc file. To check it is correct trace file can grep session id or even bit of SQL she used that would be specific to her session. Most of the Oracle references have tkprof examples, so does metalink and cdrom with oracle doc. -Original Message- Sent: Monday, August 12, 2002 4:03 PM To: '[EMAIL PROTECTED]' I don't know vb either. However the trace file is likely generated on the server-side. She would not see the output. She might want to try alter session set autotrace on; instead. That way she should see the results. That is how it works in SQL*PLUS. Otherwise, you will have to send her the trace file from the server - you guys will get quickly tired of that. 'AUTOTRACE ON' does have some limitations/bugs where it doesn't necessarily show you - but I believe that is related to partitioning and parallelism. -Original Message- Sent: Monday, August 12, 2002 4:23 PM To: Multiple recipients of list ORACLE-L List: We have a crystal report performing badly. (No! ,you say. You're shocked!) The report has a visual basic front end. Our developer wants to set sql trace in the VB code. It's not working. When I tkprof her trace file, all that's in there is the ALTER SESSION SET SQL_TRACE TRUE command. Is there some trick here? I don't know VB at all, so I don't know how to advise her. She looked on the Microsoft site, but it was not helpful. Thanks for any help! Barb -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Baker, Barbara INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Send and receive Hotmail on your mobile device: http://mobile.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay Wade INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Portal Question
Could anyone recommend a good news portal which offers RDBMS content which is updated daily? I've been using www.infoworld.com and www.cnet.com and would like more database related material. Thank you in advance, Jay _ Chat with friends online, try MSN Messenger: http://messenger.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay Wade INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Guys: Is this worth $1,749 for 8 year Oracle veteran DBA
: - July 29th, 2002 Class meets Mon, Tues, Wed from 1pm-4pm EST (10am-1pm PST) or August 19th, 2002 Class meets Mon, Tues, Wed from 7pm-10pm EST (4pm-7pm PST) - See www.oraknowledge.com/8idba.asp?source=0725 for more information. So what are you waiting for? To register, simply click on the link below and use the Promotional Code: SAVE50. == http://www.oraknowledge.com/register.asp?source=0725 == Or, give my associate Miranda a call on our toll free line: 1-888-320-4775. 1-609-698-0332 from outside the United States. You'll be glad you did! Edward Haskins, OCP OraKnowledge, Inc. www.oraknowledge.com Message Sent to the Following Email Address: [EMAIL PROTECTED] THIS MESSAGE IS BEING SENT IN COMPLIANCE WITH PENDING EMAIL BILLS LAWS: SECTION 301. PER SECTION, PARAGRAPH (a) (2) (c) of S. 1618. Screening of addresses has been done to the best of our technical ability. We honor all removal requests. Please reply back to this email address with the subject REMOVE. _ Join the worlds largest e-mail service with MSN Hotmail. http://www.hotmail.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay Wade INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Q: How to Find Cursor Size
Hello: Is there anyway to find the size of a cursor in bytes? We are attempting to implement ADO returning Oracle cursors and want to make sure we are not returning more then the 64k limit. Thank you in advance, Jay _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay Wade INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
OT: Job Locations
Hello: I was wondering if some of the people of this list in the US could offer an opinion on this. Would you say there are more employment opportunities on the East Coast or the West Coast. I know that there are alot of other factors to be included but any input would be great. I've done some resource and it seems as though the East Coast has more job postings. Regards, Jay _ Chat with friends online, try MSN Messenger: http://messenger.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay Wade INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: download leads to sales call
I have noticed that they are doing more followup and sales calls lately. Although I haven't downloaded anything recently they have been doing some periodic followup. Just trying to meet sales goals no doubt. From: [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: download leads to sales call Date: Mon, 08 Jul 2002 09:58:30 -0800 Hard to say. Did the caller give any clues? Did it sound like a We're curious how you're using our software? kind of question or a When will you be sending us a check? kind of question? Jared PS. Wow, 3 question marks in one sentence! Jonathan Gennick [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/08/2002 09:48 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:download leads to sales call Last week I downloaded Oracle9i for Linux from Technet. Today I just got a call from an Oracle salesperson wanting to know what I was doing with it. I suppose it's not unreasonable for them to call and ask what I'm doing with their software, but is it normal procedure? I can't remember whether this happened last time I did a Technet download. Jonathan Jonathan Gennick --- Brighten the corner where you are mailto:[EMAIL PROTECTED] * 906.387.1698 http://Gennick.com * http://MichiganWaterfalls.com * http://ValleySpur.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonathan Gennick INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). I no longer need to punish, deceive, or compromise myself, unless I want to stay employed. _ Send and receive Hotmail on your mobile device: http://mobile.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay Wade INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re:RE: Alternative to Crystal Reports
--Chris/FONT /P BR BR BR PFONT SIZE=2Reply Separator/FONT BRFONT SIZE=2Author: quot;Steve McClurequot; lt;[EMAIL PROTECTED]gt;/FONT BRFONT SIZE=2Date:nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; 6/20/2002 10:17 AM/FONT /P PFONT SIZE=2Several times in the past I have seen folks on this list refer people to a/FONT BRFONT SIZE=2reporting product to use as an alternative to Crystal reports.nbsp; Apparently I/FONT BRFONT SIZE=2didn't think I would need it, cause I usually save posts with information I/FONT BRFONT SIZE=2am likely to forget.(So Yeah, I do save a lot of posts)nbsp; Well now Crystal is/FONT BRFONT SIZE=2being touted here as a possible solution for a new client's reporting/FONT BRFONT SIZE=2requirements.nbsp; We have been unable to convince Oracle Reports to perform in/FONT BRFONT SIZE=2the way we would like, so we need an alternative.nbsp; The good thing is that/FONT BRFONT SIZE=2the new client is a large one, so my company will actually be able to invest/FONT BRFONT SIZE=2in a nicer product./FONT /P PFONT SIZE=2-- /FONT BRFONT SIZE=2Please see the official ORACLE-L FAQ: A HREF=http://www.orafaq.com; TARGET=_blankhttp://www.orafaq.com/A/FONT BRFONT SIZE=2-- /FONT BRFONT SIZE=2Author: Steve McClure/FONT BRFONT SIZE=2nbsp; INET: [EMAIL PROTECTED]/FONT /P PFONT SIZE=2Fat City Network Servicesnbsp;nbsp;nbsp; -- (858) 538-5051nbsp; FAX: (858) 538-5051/FONT BRFONT SIZE=2San Diego, Californianbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; -- Public Internet access / Mailing Lists/FONT BRFONT SIZE=2/FON T BRFONT SIZE=2To REMOVE yourself from this mailing list, send an E-Mail message/FONT BRFONT SIZE=2to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in/FONT BRFONT SIZE=2the message BODY, include a line containing: UNSUB ORACLE-L/FONT BRFONT SIZE=2(or the name of mailing list you want to be removed from).nbsp; You may/FONT BRFONT SIZE=2also send the HELP command for other information (like subscribing)./FONT BRFONT SIZE=2-- /FONT BRFONT SIZE=2Please see the official ORACLE-L FAQ: A HREF=http://www.orafaq.com; TARGET=_blankhttp://www.orafaq.com/A/FONT BRFONT SIZE=2-- /FONT BRFONT SIZE=2Author: /FONT BRFONT SIZE=2nbsp; INET: [EMAIL PROTECTED]/FONT /P PFONT SIZE=2Fat City Network Servicesnbsp;nbsp;nbsp; -- (858) 538-5051nbsp; FAX: (858) 538-5051/FONT BRFONT SIZE=2San Diego, Californianbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp; -- Public Internet access / Mailing Lists/FONT BRFONT SIZE=2/FON T BRFONT SIZE=2To REMOVE yourself from this mailing list, send an E-Mail message/FONT BRFONT SIZE=2to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in/FONT BRFONT SIZE=2the message BODY, include a line containing: UNSUB ORACLE-L/FONT BRFONT SIZE=2(or the name of mailing list you want to be removed from).nbsp; You may/FONT BRFONT SIZE=2also send the HELP command for other information (like subscribing)./FONT /P /BODY /HTML -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay Wade INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: So, What is a 'Production DBA'?
). __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Send and receive Hotmail on your mobile device: http://mobile.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay Wade INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Jr.DBA, Mid level DBA, Sr.DBA
Hello: Out of curiosity how would you classify a Jr. DBA, a Mid Level DBA, and a Sr. DBA? I know how our HR department makes the division but would be interested in knowing how other people might classify the differences. Regards, Jay _ Join the worlds largest e-mail service with MSN Hotmail. http://www.hotmail.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay Wade INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: How to find current ORACLE_HOME programmatically
You can loop through the Oracle Homes in the registry. Which home do you want to select? In the registry there is a number of homes. In most of my VB app's I use this as the count that I loop through. Do you need a toggle between the two homes? From: Alex Hillman [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: How to find current ORACLE_HOME programmatically Date: Wed, 22 May 2002 08:53:44 -0800 Looks like no takers, except one whos great advice was to find it somewhere in the registry. Alex Hillman -Original Message- Hillman Sent: Monday, May 20, 2002 7:08 PM To: Multiple recipients of list ORACLE-L Hi, guys. I need to find current value of ORACLE_HOME on the client from VB program, running on that client. I understand that it is in the registry somewhere. I have 2 client installations - one is 8.1.7 and another is 9 on the same client. Apparently EM from 9 installation knows that needed tsnames.ora is in 9 ORACLE_HOME and 8.1.7 EM knows that tsnames.ora in 8.1.7. installation. And my VB program select tsnames.ora from 8.1.7 installation Any ideas? Alex Hillman -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alex Hillman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alex Hillman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Send and receive Hotmail on your mobile device: http://mobile.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay Wade INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
OT: Using Java Blocks Can Anyone Help?
hello:Can you run a Java Store Procedure as an anonymous
block? I'm trying to doas suggested and use Java to delete an
operating system file (Win2k/NT).The only issue is that this must be
executed in script format withoutstoring any objects or references in
the database. Since I am using 8.1.6Ifigured that I might be
able to do it all as a sql file with anonymous Javablocks. Can
this be done? If do does anyone have an example of the
syntaxthat would be needed to delete a file from a passed
parameter? I'vestartedexperimenting with the below but so
far have been unsuccessful, in gettingthe block to execute.
Unfortunately I know very little Java so any help ordirectory would be
greatly
appreciated.Begin
public class Hello
{
/* Pure Java
Code*/
static public String Msg(String tail)
{
return "Hello " +
tail;
} }Thanks in
advance,Jay
Re: Using Java Blocks Can Anyone Help?
Bunyamin thanks for your help. The example is great I just have a few follow
up questions. Please keep in mind that I am very much a newbie to all
things Java. If I wasn't able to store the objects in the database could I
put all of the below into a script which would create the objects then drop
them? If so would I have to compile each time or can I just reference the
path? Also, due to my very limited experience with Java does the below
included code allow me to delete an operating system file? If so what would
the syntax, del C:\temp\filename.txt (same as MS DOS)?
From: Bunyamin K. Karadeniz [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: Using Java Blocks Can Anyone Help?
Date: Mon, 28 Jan 2002 05:00:26 -0800
Jay ,
You need a java class loaded into database Which runs OS Commands (or .bat
file) . For this look at below... ...
Hope this helps . (But I could not manage to run OS commands deleting files
from network altough shared.But locally it works fine.)
Bunyamin K. Karadeniz
Oracle DBA / Developer
Civilian IT Department
Havelsan A.S. Eskisehir yolu
7.km Ankara Turkey
Phone: +90 312 2873565 / 1217
Step1. compile the java code
javac program_name.java
This operation is used to generate related class. Do not need to recompile
java code, if the related class is exists.
Step2. Load generated class into the Database
loadjava -u user_name/password@connection_name program_name.class
- Drop java class from the database :
dropjava -u user_name/password@connection_name program_name.class
- Publish the Java code to PL/SQL by creating the PL/SQL wrapper
CREATE OR REPLACE PROCEDURE executecmd (S1 VARCHAR2)
AS LANGUAGE JAVA
name 'program_name.main(.)'
- Call the procedure
set serveroutput on
call dbms_java.set_output(2000) /*obtional*/
exec program_name
Example : Call an OS command from a Java stored procedure (JSP)
---code begins here
import java.lang.Runtime;
import java.lang.Process;
import java.io.IOException;
import java.lang.InterruptedException;
class ExecuteCmd {
public static void main(String args[]) {
System.out.println(In main);
try {
/* Execute the command using the Runtime object and get the
Process which controls this command */
Process p = Runtime.getRuntime().exec(args[0]);
/* Use the following code to wait for the process to finish
and check the return code from the process */
try {
p.waitFor();
/* Handle exceptions for waitFor() */
} catch (InterruptedException intexc) {
System.out.println(Interrupted Exception on waitFor: +
intexc.getMessage());
}
System.out.println(Return code from process+ p.exitValue());
System.out.println(Done executing);
/* Handle the exceptions for exec() */
} catch (IOException e) {
System.out.println(IO Exception from exec : +
e.getMessage());
e.printStackTrace();
}
}
}
-code ends here--
You can write this code with any editor and save it as executecmd.java .
Then compile this code.
If you do not have any java editor, you can also compile this program using
command prompt as follows :
a.. define the path where the necessary classes and packages are hold
set PATH=%PATH%; path_name
a.. compile the program
javac program_name.java
After compile operation you can load this codes into the database and
execute it as described above.
NOTE : Some permissions are necessary to execute java codes into the
database, this operations can be made as follows :
- connect database with system manager (conn sys/password@connectionname )
- set serveroutput on
- call dbms_java.grand_permission(username,permissionname, filename,
permissions)
call
dbms_java.grand_permission('user','java.io.filePermission','*','read,write,execute')
call
dbms_java.grand_permission('user','java.lang.runtimePermission','*',writeFileDescriptor')
...
- commit
- log of and reconnect as the specified user
You can also give all permissions to the specified user with this command :
grant JAVASYSPRIV to username
if no permissions are given to the user, the procedure are not executed
correctly.
- Original Message -
From: Jay Wade
To: Multiple recipients of list ORACLE-L
Sent: Monday, January 28, 2002 1:55 PM
Subject: OT: Using Java Blocks Can Anyone Help?
hello:
Can you run a Java Store Procedure as an anonymous block? I'm trying
to do
as suggested and use Java to delete an operating system file
(Win2k/NT).
The only issue is that this must be executed in script format without
storing any objects or references in the database. Since I am using
8.1.6
I
figured that I might be able to do it all as a sql file with anonymous
Java
blocks. Can this be done? If do does anyone have an example of the
syntax
that would be needed to delete a file from a passed parameter? I've
Re: TOAD Login Problem
In TOAD to can set the path to you OCI dll if you need to. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Saturday, January 26, 2002 6:45 AM Oracle 9i (9.0.1) on XP Professional on DELL 8200. TOAD VI freeware ver. 6.3.11.1g I keep gettint this error when I try to connect to 9i: Initialization error. Could not locate OCI dll I can connect using SQL*Plus with no problems. Any idea as to what the problem is with TOAD? Thanks much, Ken Janusz, CPIM -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay Wade INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Moving Files Around
Hello: I have read and tried (sorry newbie) the procedures involved with moving control files, database files, etc. But I have never seen any reference to how to move the instance reference to the parameter file. Whenever had to move a db I've always done at least some exp/imp. I was wondering if anyone could share with me how to move the instance refernce to the parameter file. I'd very much be interested in how to do this on a Win2k box running 8.1.6. Regards, Jay
Re: Database Views
If you can't use a DW idea look into Snapshots. If you don't need an up to the second view of the data that is. or schedule the report run time. Most reporting packages have the ability to do so. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, January 17, 2002 7:20 AM This is why data marts were created. You would be much better off to create a reporting database based on the data you need to see. You won't be happy doing this with views from several databases. It won't perform well. As Rachel pointed out it will be inconsistent. At the very least you could create snapshots of these tables so that all of the data would be locally available. Just my $0.02. Jared On Wednesday 16 January 2002 12:04, [EMAIL PROTECTED] wrote: I would like get your opinion on what would be the best way provide access to data across multiple databases on just on Node (database). One way that I have tried is create a view on one database that reads tables across remaining four databases using Dblinks. Let us say there is a table called CUSTOMER that resides on five databases, in order to make it easier to generate reports, a combined view can be created with dblinks on these tables using UNION ALL on one database. Only concern I have is that when using Dblinks, Oracle might copy the entire remote table to the local database and then retrieve the data based on where clause. This might be a significant performance issue especially if the tables are very BIG. If there are better ways to accomplish this or any ideas on this one will be greatly appreciated. Thank you, Srini -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay Wade INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
