Re: Replicating data from SYBASE to ORACLE
You really should check into Sybase Replication. Very powerful ( and complex ) replication product. It can replicate Sybase to Oracle. Jared On Wednesday 30 May 2001 18:25, Vikas Kawatra wrote: Anyone have any ideas about replicating data from SYBASE tables to ORACLE in real-time - We have two systems running in parallel - an old SYBASE system - along side a new (pilot) sytem in oracle .We 're trying to figure out the best way to replicate transactions that get recorded in the sybase database -to the oracle database- to keep them in synch. I've heard of a dbQueue messaging system in SYBASE - which may be a way to do this - I have limited SYBASE exp - so I was wondering if there are any ideas out there thanks -- 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).
Re: OT: Archiving not possible with SQL Server?
Are you an idiot? Jared On Wednesday 30 May 2001 14:55, Gary Weber wrote: Guess what happens when a long running transaction marks the log near the end, and not too long afterward the log needs truncated? If memory serves, ( hasn't worked too well lately :) the database will hang. It may just truncate back to the mark, and start from there, but you always have the possibility of another long transaction starting. HELP Gary Weber Senior DBA Charles Jones, LLC 609-530-1144, ext 5529 -- 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).
RE: How to create 2 unique indexes (Field1, Field2) and (Field1,
Hi, I would like to thank those who replied. Yes, my problem has been resolved after removing duplicate values in the table. Thanks. Regds, New Bee -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: CHAN Chor Ling Catherine (CSC) 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).
need site address for Form and Reports discussion
Hi Here we can discuss about Dba related things, like wise any site to discuss about Forms and Reports -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Senthil Ganapathi 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: Replicating data from SYBASE to ORACLE
Thanks I have been reading up on the sybase replication I am not very hopeful though ! Concerns include the maturity of the product for replicating to 8.1.6 ,performance ,complexity etc vikas -Original Message- Sent: Thursday, May 31, 2001 12:01 AM To: Multiple recipients of list ORACLE-L You really should check into Sybase Replication. Very powerful ( and complex ) replication product. It can replicate Sybase to Oracle. Jared On Wednesday 30 May 2001 18:25, Vikas Kawatra wrote: Anyone have any ideas about replicating data from SYBASE tables to ORACLE in real-time - We have two systems running in parallel - an old SYBASE system - along side a new (pilot) sytem in oracle .We 're trying to figure out the best way to replicate transactions that get recorded in the sybase database -to the oracle database- to keep them in synch. I've heard of a dbQueue messaging system in SYBASE - which may be a way to do this - I have limited SYBASE exp - so I was wondering if there are any ideas out there thanks -- 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: Vikas Kawatra 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).
How to encrypt Password in Export script file ?
Hi Unix Gurus, My daily export file (daily_exp.sh) contains : exp userid='system/password' file=file_name.dmp grants=y rows=y constraints=y compress=y full=y inctype=complete log=file_name.log The system password is stated clearly in the export script file. Has anyone encrypt/decrypt the system password before passing it as a variable to the export script ? If yes, could I have a copy of your script ? Thanks. Regds, New Bee in Unix -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: CHAN Chor Ling Catherine (CSC) 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).
Pls how to install SQL LOADER
Hi, i'm having forms4.5 and repots2.5, i need to install SQL loader, pls give some idea for this -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Senthil Ganapathi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
what's hash-join
Hi Rukmini could tell me what's that hash-join GSK Rukmini DeviTo: Multiple recipients of list ORACLE-L rukmini@indb[EMAIL PROTECTED] rain.comcc: Sent by: Subject: Re: 4 join methods? root@fatcity. com 31-05-01 09:55 AM Please respond to ORACLE-L 1. Equi-join 2. Self-join 3. Outer-join 4. Hash-join rukmini - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, May 31, 2001 11:20 AM i feel the fourth one is self join. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, May 31, 2001 8:10 AM Hi, I just read there are four join methods. I know three: Nested loops Sort merge Hash join What's the fourth? - Greg -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Moore 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: Saurabh Sharma 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: Rukmini Devi 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: Senthil Ganapathi 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 send email from pl/sql in 806?
hi Jared, my execution cmd goes like.. EXECUTE SEND_MAIL('[EMAIL PROTECTED]','[EMAIL PROTECTED]','urgent','hello') it's giving the following error msgs.. ORA-04068: existing state of packages has been discarded ORA-04067: not executed, package body SYS.UTL_TCP does not exist ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at SYS.SEND_MAIL, line 10 ORA-06512: at line 2 the package is shown as valid in dba_objects for sys. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, May 31, 2001 12:05 PM Your procedure is masking the error in the exception block. Comment out the exception block to see the real error. Jared On Wednesday 30 May 2001 22:18, you wrote: it gives other error msg which are defined in the exception body inside the procedure. here it goes.. EXCEPTION when others then raise_application_error(-2,'Unable to send e-mail message from pl/sql'); this msg is returned with ora 06512 any suggestions.. - Original Message - From: Jared Still [EMAIL PROTECTED] To: [EMAIL PROTECTED]; Saurabh Sharma [EMAIL PROTECTED] Sent: Wednesday, May 30, 2001 9:43 PM Subject: Re: How to send email from pl/sql in 806? On Wednesday 30 May 2001 03:10, Saurabh Sharma wrote: should i give it all four arguments. but it still not executing saying ora-06512 There are always other error messages accompanying an ORA-6512. What are they? Jared -- 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: Saurabh Sharma 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: Missing DDL?
Anita, Followed your suggestion BUT... does not seem to be working. The export log is showing that it exports tablespace definitions but using INDEXFILE parameter with Import utility does not seem to show the DDL for creating the tablespaces. Perhaps this is the way it is meant to be, I'd just like to verify one way or the other. Anyone out there know??? Is there some other way to view the DDL for tablespace creation?. Expanding on where I'm coming form here is that if for example one had an export dump of a DB and needed to move it to another machine which had a different disk configuration, how does one direct the data files to different disks. I suspect its using a dump of control file and modifying same. What if you don't have the control file dump what do you do then? - Sean -Original Message- Sent: Thursday, May 31, 2001 08:10 To: 'A. Bardeen' Anita, Thanx for replying to below. Much appreciated! - Sean -Original Message- Sent: Wednesday, May 30, 2001 17:02 To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sean, The indexfile parameter shows only the create table statements (REM'd out) and the additional indexes (i.e not indexes used to enforce PK constraints). To see all the DDL, use the SHOW=Y parameter along with LOG=filename. HTH, -- Anita --- O'Neill, Sean [EMAIL PROTECTED] wrote: Created a sandbox database using Database Administration utiltity, (8i Rel 3, PE, NT4). I ran full export of a database. I then used the imp utility with indexfile parameter to create the DDL for the database. I expected to be able to find the DDL for the tablespaces TOOLS, USERS and some others but can't. OK, so there are no tables created in them but I'm puzzled now as to how these tablespaces are created during import?. Probably missing something obvious, but anyones sane input would be appreciated!. Sean :) Rookie Data Base Administrator [0%] OCP Oracle8i DBA [0%] OCP Oracle9i DBA Organon (Ireland) Ltd. E-mail: [EMAIL PROTECTED] [subscribed: Digest Mode] Visit: http://groups.yahoo.com/group/Oracle-OCP-DBA Nobody loves me but my mother... and she could be jivin' too. - BB King -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean 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: 4 join methods?
There's an article by Tim Gorman, The Search for Intelligent Life in the Cost-Based Optimizer http://www.evdbt.com/library.htm where he talks about the CBO having knowledge about how the four methods of joining tables operate. I asked the question because I've only heard of nested loops, sort merge and hash join. Wondering what the fourth is. - Greg -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Moore 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 many times has an index been used?
Hi, Thanks for the replies to this question. Looks like I need = 8i or trawl through the v$sqlarea either by spending money or writing a simple bit of pl/sql. Thanks, Steve Wilkes npower [EMAIL PROTECTED] -Original Message- Sent: 29 May 2001 14:03 To: Multiple recipients of list ORACLE-L Cc: [EMAIL PROTECTED] Hi All, A cheaper solution to this is to use an AFTER LOGON trigger to set CREATE_STORED_OUTLINES to true. If the users have the CREATE ANY OUTLINE system privilege, you'll be able to see which indexes are being used in the DBA_OUTLINE_HINTS view. @ Regards, @ Steve Adams @ http://www.ixora.com.au/ @ http://www.christianity.net.au/ -Original Message- Sent: Tuesday, 29 May 2001 19:55 To: Multiple recipients of list ORACLE-L There is also one called The Big Picture - from Bit by Bit www.bitbybit.co.uk - that scans all source, and SQL, and stores all execution plans in a BDE database. It then scans through all the exectution plans to determine whether an index is used or not. It doesn't however tell you how many times the index has *actually* been used.. Mark -Original Message- Sent: Friday, May 25, 2001 09:18 To: Multiple recipients of list ORACLE-L There is commercial software for determining this. www.teleran.com www.pinecone.com Both rather spendy. Jared On Thursday 24 May 2001 06:10, Wilkes, Steve wrote: Hi, Does anyone know how to determine how many times an index has been used or if it has been used at all? I have seen previous attempts by taking snapshots of v$sqlarea and then automating an explain plan and extracting the information that way. I would have thought that there must be an x$ table that records this information somewhere? Any ideas? Thanks in advance. Steve Wilkes ___ Oracle DBA npower email:[EMAIL PROTECTED] This incoming e-mail (and any attachments) has been checked at npower, and has been found to be clean from any virus infection (using Sophos Sweep 3.45 + patches). npower Service Desk (internal telephone 187, external 01384 275454, or e-mail npower Postmasters [internally] or [EMAIL PROTECTED] [externally]) = 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. If you have received this email in error please notify gpupower.co.uk or [EMAIL PROTECTED] This outgoing e-mail (and any attachments) has been checked (using Sophos Sweep 3.45 + patches) before leaving us (UK 08457 353637), and has been found to be clean from any virus infection. = -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Wilkes, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Database Links
Can I give a suggestion , how about create a unique user which will have all the link db , so much so that we will know where is the link come from , and it seen easily to manage ? Will it be a solution to this ? -Original Message- Sent: Thursday, May 31, 2001 2:46 PM To: Multiple recipients of list ORACLE-L Tracy, Allowing developers to muck around in your production system is not generally a good idea. If you create db links for them, that's what they will be doing. In addition, have you ever managed an environment like that? I have and it's not pretty. How will you administer the privileges? Will it be a public database link ( dangerous ) or lots of private database links (messy )? Will the connection be to their own account on the production system ( that you must create ) or an account that has all the needed privs? Managing this is something of a headache. And when your developers do a cartesian join on your production database, you will be scrambling to determine which session is causing it, and determining if you can safely kill it. etc, etc, etc. :) Jared On Wednesday 30 May 2001 16:09, Tracy Rahmlow wrote: We have several large look-up tables that we use in development as well as in production environments. The data is the same in both environments. I am looking for some comments regarding whether or not we store duplicate data in each environment or should we allow the development users to access the table in production through a database link. Below, I have listed some issues with both of these processes and am looking for further input. Thanks Duplicate table in production and development (either through export/import or snapshots): Cons additional storage is need process needed to keep tables in sync Pros reduced network traffic Access table in production through a database link in development: Cons additional network traffic possibility of poorly tuned adhoc sql executing in a production environment Pros only one copy of table do not need an ongoing process to keep the tables in sync -- 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: Raymond Lee Meng Hong INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Working with a BLOB
just a guess but try select dbms_lob.instr(blob_col, '.com') from atable where dbms_lob.instr(blob_col, '.com') between 0 an 75 -Original Message- Sent: 30 May 2001 23:30 To: Multiple recipients of list ORACLE-L I've been through the documentation on LOBs but am still stuck trying to figure out how to interrogate the contents of a BLOB. We have a table with a BLOB column in it. All it contains in text data (i.e. memo notes). Why it was created as a BLOB and not a CLOB is unknown to me and done before I was hired. All I need to do is determine if a particular string ('.com') pattern exists in the column, within the first 75 bytes, and return its starting position. Would someone help me out? Thanks! -w __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Walter K INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ This message has been checked for all known viruses by Star Internet delivered through the MessageLabs Virus Scanning Service. For further information visit http://www.star.net.uk/stats.asp or alternatively call 01285 884400. This message is intended only for the use of the person(s) (the intended recipient (s)) to whom it is addressed. It may contain information which is privileged and confidential. If you are not the intended recipient, please contact the sender as soon as possible. The views expressed in this communication may not necessarily be the views of InterX plc. Any copyright in this message shall remain vested in InterX plc © and the intended recipient may only copy the same for internal business purposes or as otherwise stated in this message. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vipul Lakhani 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: 4 join methods?
At 22:55 -0800 30/5/01, Rukmini Devi wrote: 1. Equi-join 2. Self-join 3. Outer-join 4. Hash-join Outer join is a logical type not an access method. the four types of join that Oracle can use: Nested Loops join Sort Merge join (equi-join only) Cluster join (equi-join on cluster key only) Hash join (equijoin, cost-based only) Regards Paul Miller -- - Carib Data Limited mailto:[EMAIL PROTECTED] http://www.caribdata.co.uk -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: PD Miller 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).
ORACLE NAMES /LDAP
Anyone using this product as an alternative to Local Naming ? How about LDAP ? Any info /suggestions/comments are welcome vikas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vikas Kawatra 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: what's hash-join
A method of joining two tables. You scan each and use a hashing algorithm to isolate/match keys. hth connor --- Senthil Ganapathi [EMAIL PROTECTED] wrote: Hi Rukmini could tell me what's that hash-join GSK Rukmini DeviTo: Multiple recipients of list ORACLE-L rukmini@indb [EMAIL PROTECTED] rain.comcc: Sent by: Subject: Re: 4 join methods? root@fatcity. com 31-05-01 09:55 AM Please respond to ORACLE-L 1. Equi-join 2. Self-join 3. Outer-join 4. Hash-join rukmini - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, May 31, 2001 11:20 AM i feel the fourth one is self join. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, May 31, 2001 8:10 AM Hi, I just read there are four join methods. I know three: Nested loops Sort merge Hash join What's the fourth? - Greg -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Moore 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: Saurabh Sharma 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: Rukmini Devi 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: Senthil Ganapathi 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
No Subject
SET ORACLE-L DIGEST ** The above information is confidential to the addressee and may be privileged. Unauthorised access and use is prohibited. Internet communications are not secure and therefore this Company does not accept legal responsibility for the contents of this message. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. Hogg Robinson PLC Registered Office: Abbey House, 282 Farnborough Road, Farnborough, Hampshire GU14 7NJ Registered in England and Wales No 3249700 ** -- 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).
SQL TRACE
i have take trace file with SYS.DBMS_SYSTEM.SET_SQL_TRACE_IN_SESSION(sid,serial,TRUE). and trace file size is the 5MB but outpu of tkproff 31KB . is it normal.? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Arslan Bahar 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: Script examples for NT. (yuk!)
Hi Greg, I came to NT world from VMS and was used to DCL. I find the following book a useful reference: Windows NT Shell Scripting 1-57870-047-7 HTH, Sean :) Rookie Data Base Administrator [0%] OCP Oracle8i DBA [0%] OCP Oracle9i DBA Organon (Ireland) Ltd. E-mail: [EMAIL PROTECTED] [subscribed: Digest Mode] Visit: http://groups.yahoo.com/group/Oracle-OCP-DBA Nobody loves me but my mother... and she could be jivin' too. - BB King -- From: Loughmiller, Greg [EMAIL PROTECTED] Date: Wed, 30 May 2001 08:26:45 -0400 Subject: Script examples for NT. (yuk!) Quick question.. ALL of my experience has been on UNIX platforms... Recently, I have been asked to work on an Oracle DB that runs on NT.. My scripting capability in the NT world is weak at best. So I am trying to compare ksh type activities with the NT world. SO I was wondering if any of you would mind sharing a couple of NT type scripts with me.. For example-setting variables to the return of a SQL statement to be used in the shell,etc... Any help would be appreciated.. TIA Greg Loughmiller mailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean 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: Pls how to install SQL LOADER
when you installed forms and reports you have the option to install oracle client database utilities ... they are installed with that option -Original Message- Sent: 31 May 2001 09:10 To: Multiple recipients of list ORACLE-L Hi, i'm having forms4.5 and repots2.5, i need to install SQL loader, pls give some idea for this -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Senthil Ganapathi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ This message has been checked for all known viruses by Star Internet delivered through the MessageLabs Virus Scanning Service. For further information visit http://www.star.net.uk/stats.asp or alternatively call 01285 884400. This message is intended only for the use of the person(s) (the intended recipient (s)) to whom it is addressed. It may contain information which is privileged and confidential. If you are not the intended recipient, please contact the sender as soon as possible. The views expressed in this communication may not necessarily be the views of InterX plc. Any copyright in this message shall remain vested in InterX plc © and the intended recipient may only copy the same for internal business purposes or as otherwise stated in this message. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vipul Lakhani 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: Analyze table and locking
Thought of trying this out... I analyzed a huge table in our system and simultaneously checked for locks... Oracle did not lock the concerned table being analysed, but aquired locks on sys tables for sometime, both in estimate and compute options. On oracle 8.1.7. rgds amar -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 31, 2001 6:35 AM To: Multiple recipients of list ORACLE-L Christopher, Is this document perhaps a TAR as I cannot find it on Metalink (but maybe the search engine doesn't like me today). Do you have the exact URL for this note 213220.999? Thanks, Bruce -Original Message- Sent: Thursday, 31 May 2001 6:59 To: Multiple recipients of list ORACLE-L Oracle actually claims this statement. There are numerous docs stating this, for example DOC ID: 213220.999. But I agree 100% with Jeremiah's claims, in fact it can be verified very easily looking at v$lock while analyzing a large table. (I have actually done this in the past and present) and there are no locks under my current sid or any additional locks under any sid during analyze. Take any table that takes more than 3-4 seconds to analyze and in another window query V$LOCKS and you can see this first hand. Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Wednesday, May 30, 2001 2:21 PM To: Multiple recipients of list ORACLE-L I have used compute statistics since version 7.3.2 up through 8.1.6, and never had it hold a table lock for the duration of the analyze. I don't know where people are getting the idea that compute statistics holds a lock and estimate doesn't. That just doesn't make sense. Why would compute need a lock? Are you saying I can estimate sample 99 percent, and get what amounts to a compute and avoid the supposed lock? Does that make any sense? No. Validate structure cascade holds a lock. The most the others do is grab some resource [very] briefly at the end to update the dictionary. People claiming that compute holds a lock, please post documentation to support that statement. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Wed, 30 May 2001, Raghu Kota wrote: Yeah If you use compute statistics your table get locked and will take long time, But If you use estimate statistics it will be fast But not as accurate as before. Better to analyze at nights by setting time. From: Robertson Lee - lerobe [EMAIL PROTECTED] Anyone know if there are any locking issues while analyzing statistics for objects ?? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton 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: Christopher Spence 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: Reardon, Bruce (CALBBAY) 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: Amar Kumar Padhi 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:
RE: Missing DDL?
Sean, You need to export with the full=y option to do this. Try it out with rows=n to test. Then do as Anita says and import with show=y. Cheers Lee -Original Message- Sent: 31 May 2001 10:25 To: Multiple recipients of list ORACLE-L Anita, Followed your suggestion BUT... does not seem to be working. The export log is showing that it exports tablespace definitions but using INDEXFILE parameter with Import utility does not seem to show the DDL for creating the tablespaces. Perhaps this is the way it is meant to be, I'd just like to verify one way or the other. Anyone out there know??? Is there some other way to view the DDL for tablespace creation?. Expanding on where I'm coming form here is that if for example one had an export dump of a DB and needed to move it to another machine which had a different disk configuration, how does one direct the data files to different disks. I suspect its using a dump of control file and modifying same. What if you don't have the control file dump what do you do then? - Sean -Original Message- Sent: Thursday, May 31, 2001 08:10 To: 'A. Bardeen' Anita, Thanx for replying to below. Much appreciated! - Sean -Original Message- Sent: Wednesday, May 30, 2001 17:02 To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sean, The indexfile parameter shows only the create table statements (REM'd out) and the additional indexes (i.e not indexes used to enforce PK constraints). To see all the DDL, use the SHOW=Y parameter along with LOG=filename. HTH, -- Anita --- O'Neill, Sean [EMAIL PROTECTED] wrote: Created a sandbox database using Database Administration utiltity, (8i Rel 3, PE, NT4). I ran full export of a database. I then used the imp utility with indexfile parameter to create the DDL for the database. I expected to be able to find the DDL for the tablespaces TOOLS, USERS and some others but can't. OK, so there are no tables created in them but I'm puzzled now as to how these tablespaces are created during import?. Probably missing something obvious, but anyones sane input would be appreciated!. Sean :) Rookie Data Base Administrator [0%] OCP Oracle8i DBA [0%] OCP Oracle9i DBA Organon (Ireland) Ltd. E-mail: [EMAIL PROTECTED] [subscribed: Digest Mode] Visit: http://groups.yahoo.com/group/Oracle-OCP-DBA Nobody loves me but my mother... and she could be jivin' too. - BB King -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe 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
RE: OT: Archiving not possible with SQL Server?
Jared is having a bad day. : ) Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- From: Jared Still [SMTP:[EMAIL PROTECTED]] Sent: Thursday, May 31, 2001 3:51 AM To: Multiple recipients of list ORACLE-L Subject:Re: OT: Archiving not possible with SQL Server? Are you an idiot? Jared On Wednesday 30 May 2001 14:55, Gary Weber wrote: Guess what happens when a long running transaction marks the log near the end, and not too long afterward the log needs truncated? If memory serves, ( hasn't worked too well lately :) the database will hang. It may just truncate back to the mark, and start from there, but you always have the possibility of another long transaction starting. HELP Gary Weber Senior DBA Charles Jones, LLC 609-530-1144, ext 5529 -- 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: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: 4 join methods?
Where can I get the documentation for join methods ? rukmini - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, May 31, 2001 3:45 PM At 22:55 -0800 30/5/01, Rukmini Devi wrote: 1. Equi-join 2. Self-join 3. Outer-join 4. Hash-join Outer join is a logical type not an access method. the four types of join that Oracle can use: Nested Loops join Sort Merge join (equi-join only) Cluster join (equi-join on cluster key only) Hash join (equijoin, cost-based only) Regards Paul Miller -- - Carib Data Limited mailto:[EMAIL PROTECTED] http://www.caribdata.co.uk -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: PD Miller 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: Rukmini Devi 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: Performance tuning
Database parameters were slightly changed for the second run and SGA was made only 140 MB. Loading was done without indexes and SQL loader parameters were changed to Readsize=10m, Bindsize=10m and Rows=5000. It took almost same time for about 21 hours but again it committed 8-10 times ( first 5) very quickly. Real bottleneck is RAM (as pointed out by all) since commit charge in NT task manager was almost double than the physical memory. But since the data is loaded , we are through. Thanks to every one who responded Azhar Boivin, Patrice J To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] [EMAIL PROTECTED]cc: mpo.gc.ca Subject: RE: Performance tuning Sent by: [EMAIL PROTECTED] 05/31/2001 12:56 AM Please respond to ORACLE-L I don't know what is causing this, but I would keep an eye on physical memory available vs. commit charge in Task Manager, I strongly recommend your commit charge never exceed your physical memory. I found that Oracle sometimes refuses to even start services when it runs out of physical memory, it doesn't like virtual memory very much. Shrinking the size of your SGA is preferable to exceeding the available physical memory, in my opinion. Keep in mind session memory space in your calculations, and the other programs you may be running on your machine. I recommend you stop all the services (in Services applet) that you dare stop, to lighten the load. In the virtual memory settings, allocate the amount you want, but try to avoid a range of values - when initial and max size values are different NT keeps polling the pagefile and memory statistics to figure out if the pagefile should grow or shrink. Better to do that manually up front, allocate at set amount. NT then stops doing extra work regarding memory allocation. Every little bit helps. I haven't used SQL*Loader, so I can't say much about that, except... when you start loading those first few rows, what does Commit Charge look like in Task Manager? Is it growing? If it is, notice how slowly NT does this. It can't be helped. If commit charge approaches physical memory available, you will hit a ceiling I think. Then things may well slow down to a crawl. Is there a buffer size you can set for SQL*Loader? I always set my exp buffer size to 100 to speed it up. Maybe you can do the same for SQL*Loader. That must use more memory though. Can you commit every few records? Could it be every 10 rows? Would it be better not to commit too often? As mentioned before, RAID 5 will prove slower than simple disk or RAID 01 or RAID 10. Do you have many indexes on the tables you are filling up? You may want to drop them and re-create them once the load is finished. This may sound silly but... do you have a virus checking program running
Re: 4 join methods?
the four types of join that Oracle can use: Ah ha. Thank you! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Moore 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).
How does Oracle use the parameter GLOBAL_DBNAME in listener.ora ?
How does Oracle use the parameter GLOBAL_DBNAME in listener.ora ? I faced this problem: Note: The SERVICE_NAMES parameter was set to SFA in the init.ora file File listener.ora is SID_LIST_JLISTENER = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = SFA) (ORACLE_HOME = /home6/sfa/app/oracle/product/8.1.5) (SID_NAME = SFAPP) ) ) File tnsnames.ora on client is SFTEST.IN.TATAINFOTECH.COM = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 163.122.32.59)(PORT = 2521)) ) (CONNECT_DATA = (SERVICE_NAME = SFAPP) ) ) When I tried to connect from client I got a error : Unable to resolve service name. When I commented out GLOBAL_DBNAME = SFA - the connection worked !!! I am trying to understand what was going worng - since the tnsnames and listener was generated by Oracle utilities. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: TAG DBA 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).
Test
_ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: SRIVIDYA ARUN 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: Snapshot Logs Explanation Needed
Tracy, You may know that there were no modifications to the master table made from the time the snapshot log was dropped until it was recreated, but Oracle can't take that chance, otherwise data could get out of sync. That's why you have to either recreate your snapshot or do a complete refresh if the snapshot log is recreated. To avoid recreating the snapshots I would ask why you need to reorg your master tables (i.e. what do you hope to accomplish by this)? If you're doing it for defragmentation reasons, I suggest you check out the excellent white paper How to stop defragmenting and start living... to see if this is really necessary. http://www.vampired.net/articles/files/stopfrag.zip HTH, -- Anita --- Tracy Rahmlow [EMAIL PROTECTED] wrote: I would like to reorg many tables which have snapshots associated with them. I understand that if the master table is dropped the snapshot log is also dropped. When a log is dropped, oracle states that you need to do a complete refresh of the affected snapshot. My question is why? If you do not allow users to access the database with the master table, then you should not have any transactions that would be lost. Why can't you create a new log and continue to do a fast refresh? I am trying to avoid having to recreate all the snapshots due to the size and number that we have. Any thoughts? Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tracy Rahmlow INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: A. Bardeen 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: querry..
select col1, col2 from table1 where (col1 = 'A' and col2 between 'A' and 'E') or (col1 = 'B' and col2 between 'A' and 'X') Diana Duncan TITAN Technology Partners One Copley Parkway, Ste 540 Morrisville, NC 27560 VM: 919.466.7337 x 316 F: 919.466.7427 E: [EMAIL PROTECTED] Saurabh Sharma To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] saurabhs@fcscc: ltd.com Fax to: Sent by: Subject: querry.. root@fatcity. com 05/31/2001 04:50 AM Please respond to ORACLE-L hi list, how can i select two columns from a table based on condition that they are selected in specified combinations. let me.. table 1 has 2 columns col1, col2. both cols have values , say, alphabets. a,b,c,d,e,f,... i'want to select like FOR VALUE OF COL1 IN A, col2 must fetch only between A-E for value of col1 in B, col2 must be between A-X -- and so on.. i want to define this combination, so i should get only these pair of values. any suggestions. thanks. saurabh -- 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).
Re: How to create 2 unique indexes (Field1, Field2) and (Field1, Fiel
Advice? Yes -- find out which records in your table have the duplicate combination of ACCTNO,PAYGRP and either delete the duplicate row, correct the problem row or don't create a unique index From: CHAN Chor Ling Catherine (CSC) [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: How to create 2 unique indexes (Field1, Field2) and (Field1, Fiel Date: Wed, 30 May 2001 17:55:21 -0800 Hi Gurus, How do I create 2 unique indexes (STDID,PAYGRP) and (ACCTNO,PAYGRP) on the same table ? I created the first index successfully but encountered the error ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found when I tried to create the 2nd index. SELECT INDEX_NAME,TABLE_NAME,UNIQUENESS FROM USER_INDEXES WHERE TABLE_NAME='SPY_ADHOC_PAYMENT' INDEX_NAME TABLE_NAME UNIQUENES -- -- - U_SPYADH_1 SPY_ADHOC_PAYMENT UNIQUE SQL SELECT * FROM USER_IND_COLUMNS WHERE TABLE_NAME='SPY_ADHOC_PAYMENT'; INDEX_NAME TABLE_NAME COLUMN_NAME -- -- -- U_SPYADH_1 SPY_ADHOC_PAYMENT STDID U_SPYADH_1 SPY_ADHOC_PAYMENT PAYGRP SQL CREATE UNIQUE INDEX U_SPYADH_2 ON SPY_ADHOC_PAYMENT (ACCTNO,PAYGRP); CREATE UNIQUE INDEX U_SPYADH_2 ON SPY_ADHOC_PAYMENT (ACCTNO,PAYGRP) * ERROR at line 1: ORA-01452: cannot CREATE UNIQUE INDEX; duplicate keys found Any advice ? Thanks. Regds, New Bee -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: CHAN Chor Ling Catherine (CSC) 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 -- 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).
Re: 4 join methods?
And with all the hoopla that Oracle are spouting, I'm sure they'll be trying to convince us that (8i) partition wise join is a new type as well.. :-) Connor --- PD Miller [EMAIL PROTECTED] wrote: At 22:55 -0800 30/5/01, Rukmini Devi wrote: 1. Equi-join 2. Self-join 3. Outer-join 4. Hash-join Outer join is a logical type not an access method. the four types of join that Oracle can use: Nested Loops join Sort Merge join (equi-join only) Cluster join (equi-join on cluster key only) Hash join (equijoin, cost-based only) Regards Paul Miller -- - Carib Data Limited mailto:[EMAIL PROTECTED] http://www.caribdata.co.uk -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: PD Miller 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). = Connor McDonald http://www.oracledba.co.uk (mirrored at http://www.oradba.freeserve.co.uk) Some days you're the pigeon, some days you're the statue Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= 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: alter session set events 'immediate trace name redohdr level 10'
Linda, This information is covered in the Backup and Recovery Internals course offered by Oracle. In addition to the info provided by Riyaj, here are some more details: flg values: 0x01 log has been archived 0x02 no more space available in log 0x04 the next log to be used 0x08 the current log 0x10 log is being cleared hws: header write sequence I'm not sure what this is used for, but I imagine it's another cross check mechanism to ensure that the correct version of the block is being accessed. Lest you get the idea to manually hack the file headers, a checksum is stored in the file header. HTH, -- Anita --- [EMAIL PROTECTED] wrote: Hi Linda Welcome to Oracle! I am aware that db2 has wealth of documentation and manuals, but you would n't find these information any where in the Oracle documentation.. Anyway , here is the info that you are looking for: Again, this is from my memory so use caution.. siz: Indicates the size of the log file in log block size. So your log file size would be 20480 * 512 =10M seq: Log sequence # in hex hws: heck, I don't remember this:-( Been a while looking at this.. bsz:log block size. same as 'select lebsz from x$kccle' nab:next available block. flg:Status of the log, like current etc. If I remember correctly, this is a bitmap to indicate various statuses. dup: # of members in the group. Thanks Riyaj Re-yas Shamsudeen Certified Oracle DBA i2 technologies www.i2.com Hagedorn, Linda [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 05/30/01 03:38 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:alter session set events 'immediate trace name redohdr level 10' Hello, I'm looking for documentation to name and label the output from the dump of redo headers and logs. For example, siz: 0x5000 seq: 0x1087 hws: 0x2 bsz: 512 nab: 0x5001 flg: 0x0 dup: 2 The size parameter is what, the header size in hex? x5000 = decimal 20480? In the DB2 world, this kind of information is readily available and provided to licensed customers in the DB2 Diagnosis Manual. I would think the Oracle diagnosis info should be as available as IBM's. Yes? A search in MetaLink for this list returned zero hits: siz seq hws bsz nab flg dup Any information or referral to documentation is appreciated. Thanks, Linda. Oracle DBA, former IBM DB2 L2. __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: A. Bardeen 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 encrypt Password in Export script file ?
a) Changet the script to print system/password | exp full=y ... so no-one can see it with a 'ps' b) chmod 700 daily_exp.sh so no-one except the (presumably) oracle account can see the script hth connor --- CHAN Chor Ling Catherine (CSC) [EMAIL PROTECTED] wrote: Hi Unix Gurus, My daily export file (daily_exp.sh) contains : exp userid='system/password' file=file_name.dmp grants=y rows=y constraints=y compress=y full=y inctype=complete log=file_name.log The system password is stated clearly in the export script file. Has anyone encrypt/decrypt the system password before passing it as a variable to the export script ? If yes, could I have a copy of your script ? Thanks. Regds, New Bee in Unix -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: CHAN Chor Ling Catherine (CSC) 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). = Connor McDonald http://www.oracledba.co.uk (mirrored at http://www.oradba.freeserve.co.uk) Some days you're the pigeon, some days you're the statue Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= 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[2]: 4 join methods?
I wonder if their thinking of the star join?? Dick Goulet Reply Separator Author: =?iso-8859-1?q?Connor=20McDonald?= [EMAIL PROTECTED] Date: 5/31/2001 5:00 AM And with all the hoopla that Oracle are spouting, I'm sure they'll be trying to convince us that (8i) partition wise join is a new type as well.. :-) Connor --- PD Miller [EMAIL PROTECTED] wrote: At 22:55 -0800 30/5/01, Rukmini Devi wrote: 1. Equi-join 2. Self-join 3. Outer-join 4. Hash-join Outer join is a logical type not an access method. the four types of join that Oracle can use: Nested Loops join Sort Merge join (equi-join only) Cluster join (equi-join on cluster key only) Hash join (equijoin, cost-based only) Regards Paul Miller -- - Carib Data Limited mailto:[EMAIL PROTECTED] http://www.caribdata.co.uk -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: PD Miller 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). = Connor McDonald http://www.oracledba.co.uk (mirrored at http://www.oradba.freeserve.co.uk) Some days you're the pigeon, some days you're the statue Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= 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).
Re: How to encrypt Password in Export script file ?
instead of that, I create an account in the database that is identified externally (can only run from that server, and does not have a login password). You will need a matching Unix account for it, if the unix account is exportacct then create the database account as ops$exportacct grant this account create session and exp_full_database then change your shell script to read userid=/ and run the script from the exportacct account this way you don't need to hardcode a password ANYWHERE Rachel From: CHAN Chor Ling Catherine (CSC) [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: How to encrypt Password in Export script file ? Date: Thu, 31 May 2001 00:50:22 -0800 Hi Unix Gurus, My daily export file (daily_exp.sh) contains : exp userid='system/password' file=file_name.dmp grants=y rows=y constraints=y compress=y full=y inctype=complete log=file_name.log The system password is stated clearly in the export script file. Has anyone encrypt/decrypt the system password before passing it as a variable to the export script ? If yes, could I have a copy of your script ? Thanks. Regds, New Bee in Unix -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: CHAN Chor Ling Catherine (CSC) 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 -- 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).
RE: what's hash-join
Huh? Is this jeporady? Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Thursday, May 31, 2001 6:00 AM To: Multiple recipients of list ORACLE-L Probably a cartesian product Roland S -- 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: Christopher Spence 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:ORACLE NAMES /LDAP
Vikas, LDAP, NO. Oracle Names, YES. It's been just peachy. Dick Goulet Reply Separator Author: Vikas Kawatra [EMAIL PROTECTED] Date: 5/31/2001 1:05 AM Anyone using this product as an alternative to Local Naming ? How about LDAP ? Any info /suggestions/comments are welcome vikas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vikas Kawatra 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).
RE: Analyze table and locking
It is a forum post I believe, I think I did a search on analyze lock. I have seen numerous articles were Oracle claims locking during analyze, that is the only one I found with quick parusal. Like many other things, Oracle is to blame on this old wives tale. Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence Oracle DBA Fuelspot -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 30, 2001 10:35 PM To: Multiple recipients of list ORACLE-L Christopher, Is this document perhaps a TAR as I cannot find it on Metalink (but maybe the search engine doesn't like me today). Do you have the exact URL for this note 213220.999? Thanks, Bruce -Original Message- Sent: Thursday, 31 May 2001 6:59 To: Multiple recipients of list ORACLE-L Oracle actually claims this statement. There are numerous docs stating this, for example DOC ID: 213220.999. But I agree 100% with Jeremiah's claims, in fact it can be verified very easily looking at v$lock while analyzing a large table. (I have actually done this in the past and present) and there are no locks under my current sid or any additional locks under any sid during analyze. Take any table that takes more than 3-4 seconds to analyze and in another window query V$LOCKS and you can see this first hand. Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Wednesday, May 30, 2001 2:21 PM To: Multiple recipients of list ORACLE-L I have used compute statistics since version 7.3.2 up through 8.1.6, and never had it hold a table lock for the duration of the analyze. I don't know where people are getting the idea that compute statistics holds a lock and estimate doesn't. That just doesn't make sense. Why would compute need a lock? Are you saying I can estimate sample 99 percent, and get what amounts to a compute and avoid the supposed lock? Does that make any sense? No. Validate structure cascade holds a lock. The most the others do is grab some resource [very] briefly at the end to update the dictionary. People claiming that compute holds a lock, please post documentation to support that statement. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Wed, 30 May 2001, Raghu Kota wrote: Yeah If you use compute statistics your table get locked and will take long time, But If you use estimate statistics it will be fast But not as accurate as before. Better to analyze at nights by setting time. From: Robertson Lee - lerobe [EMAIL PROTECTED] Anyone know if there are any locking issues while analyzing statistics for objects ?? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton 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: Christopher Spence 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: Reardon, Bruce (CALBBAY) 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: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists
RE: Missing DDL?
Sean, Importing with INDEXFILE will show TABLE create statements as well as INDEX create statements but will not show TABLESPACE create statements. To get the tablespace create statements (this will not be a pretty output file!): imp userid=userid/password file=file log=show.log show=y rows=n full=y this will generate a file called show.log that will contain ALL DDL statements for that database. At the beginning of the file, you should see the create tablespace commands. You will need to edit these commands to make them runnable, Oracle chops the line off at (I think) 80 characters and then wraps to the next line. Everything will be enclosed in double quotes as well. Rachel From: O'Neill, Sean [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Missing DDL? Date: Thu, 31 May 2001 01:25:25 -0800 Anita, Followed your suggestion BUT... does not seem to be working. The export log is showing that it exports tablespace definitions but using INDEXFILE parameter with Import utility does not seem to show the DDL for creating the tablespaces. Perhaps this is the way it is meant to be, I'd just like to verify one way or the other. Anyone out there know??? Is there some other way to view the DDL for tablespace creation?. Expanding on where I'm coming form here is that if for example one had an export dump of a DB and needed to move it to another machine which had a different disk configuration, how does one direct the data files to different disks. I suspect its using a dump of control file and modifying same. What if you don't have the control file dump what do you do then? - Sean -Original Message- Sent: Thursday, May 31, 2001 08:10 To: 'A. Bardeen' Anita, Thanx for replying to below. Much appreciated! - Sean -Original Message- Sent: Wednesday, May 30, 2001 17:02 To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sean, The indexfile parameter shows only the create table statements (REM'd out) and the additional indexes (i.e not indexes used to enforce PK constraints). To see all the DDL, use the SHOW=Y parameter along with LOG=filename. HTH, -- Anita --- O'Neill, Sean [EMAIL PROTECTED] wrote: Created a sandbox database using Database Administration utiltity, (8i Rel 3, PE, NT4). I ran full export of a database. I then used the imp utility with indexfile parameter to create the DDL for the database. I expected to be able to find the DDL for the tablespaces TOOLS, USERS and some others but can't. OK, so there are no tables created in them but I'm puzzled now as to how these tablespaces are created during import?. Probably missing something obvious, but anyones sane input would be appreciated!. Sean :) Rookie Data Base Administrator [0%] OCP Oracle8i DBA [0%] OCP Oracle9i DBA Organon (Ireland) Ltd. E-mail: [EMAIL PROTECTED] [subscribed: Digest Mode] Visit: http://groups.yahoo.com/group/Oracle-OCP-DBA Nobody loves me but my mother... and she could be jivin' too. - BB King -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean 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 -- 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,
RE: Analyze table and locking
Yes, the library cache object is locked so it is not dropped during an analyze. Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Thursday, May 31, 2001 5:25 AM To: Multiple recipients of list ORACLE-L Thought of trying this out... I analyzed a huge table in our system and simultaneously checked for locks... Oracle did not lock the concerned table being analysed, but aquired locks on sys tables for sometime, both in estimate and compute options. On oracle 8.1.7. rgds amar -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Thursday, May 31, 2001 6:35 AM To: Multiple recipients of list ORACLE-L Christopher, Is this document perhaps a TAR as I cannot find it on Metalink (but maybe the search engine doesn't like me today). Do you have the exact URL for this note 213220.999? Thanks, Bruce -Original Message- Sent: Thursday, 31 May 2001 6:59 To: Multiple recipients of list ORACLE-L Oracle actually claims this statement. There are numerous docs stating this, for example DOC ID: 213220.999. But I agree 100% with Jeremiah's claims, in fact it can be verified very easily looking at v$lock while analyzing a large table. (I have actually done this in the past and present) and there are no locks under my current sid or any additional locks under any sid during analyze. Take any table that takes more than 3-4 seconds to analyze and in another window query V$LOCKS and you can see this first hand. Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Wednesday, May 30, 2001 2:21 PM To: Multiple recipients of list ORACLE-L I have used compute statistics since version 7.3.2 up through 8.1.6, and never had it hold a table lock for the duration of the analyze. I don't know where people are getting the idea that compute statistics holds a lock and estimate doesn't. That just doesn't make sense. Why would compute need a lock? Are you saying I can estimate sample 99 percent, and get what amounts to a compute and avoid the supposed lock? Does that make any sense? No. Validate structure cascade holds a lock. The most the others do is grab some resource [very] briefly at the end to update the dictionary. People claiming that compute holds a lock, please post documentation to support that statement. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Wed, 30 May 2001, Raghu Kota wrote: Yeah If you use compute statistics your table get locked and will take long time, But If you use estimate statistics it will be fast But not as accurate as before. Better to analyze at nights by setting time. From: Robertson Lee - lerobe [EMAIL PROTECTED] Anyone know if there are any locking issues while analyzing statistics for objects ?? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton 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: Christopher Spence 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: Reardon, Bruce (CALBBAY) 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 --
RE: Working with a BLOB
Sometimes the obvious isn't obvious... I had the bulk of the query but was just getting hung up on the 1st 75 bytes requirement. It never clicked with me that the instr( ) function in the dbms_log package already gave me a position and all I needed to do was simply constrain it with a between clause. The query below won't work with a blob because the data is stored as binary so the '.com' needs to be wrapped in the UTL_RAW.CAST_TO_RAW( ) function first so the datatypes are compatible. Thanks again!! :-) -w --- Vipul Lakhani [EMAIL PROTECTED] wrote: just a guess but try select dbms_lob.instr(blob_col, '.com') from atable where dbms_lob.instr(blob_col, '.com') between 0 an 75 -Original Message- Sent: 30 May 2001 23:30 To: Multiple recipients of list ORACLE-L I've been through the documentation on LOBs but am still stuck trying to figure out how to interrogate the contents of a BLOB. We have a table with a BLOB column in it. All it contains in text data (i.e. memo notes). Why it was created as a BLOB and not a CLOB is unknown to me and done before I was hired. All I need to do is determine if a particular string ('.com') pattern exists in the column, within the first 75 bytes, and return its starting position. Would someone help me out? Thanks! -w __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Walter K INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ This message has been checked for all known viruses by Star Internet delivered through the MessageLabs Virus Scanning Service. For further information visit http://www.star.net.uk/stats.asp or alternatively call 01285 884400. This message is intended only for the use of the person(s) (the intended recipient (s)) to whom it is addressed. It may contain information which is privileged and confidential. If you are not the intended recipient, please contact the sender as soon as possible. The views expressed in this communication may not necessarily be the views of InterX plc. Any copyright in this message shall remain vested in InterX plc © and the intended recipient may only copy the same for internal business purposes or as otherwise stated in this message. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vipul Lakhani INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Walter K 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).
Auto Extend
I have taken over an Oracle database that is setup with autoextend on the tablespaces. Can anyone tell me what happens when the datafiles extend beyond 2G on Unix? . -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: querry..
hi well, one way to do it is to create a stored function create or replace package pkg_select is function cmb(p1 varchar2, p2 varchar2) return varchar2; end; create or replace package body pkg_select is function cmb(p1 varchar2, p2 varchar2) return varchar2 is begin if p1 = 'A' and instr(p2, 'A|B|C|D|E') 0 then return 'TRUE'; elsif p1 = 'B' and instr(p2, 'A|B|C|D|E|F|G|H|etc...') 0 then return 'TRUE'; else return 'FALSE'; end if; exception when others then return SQLERRM; end cmb; end pkg_select; then do select col1, col2 from table1 where pkg_select.cmb(col1, col2) = 'TRUE'; This keeps your select nice and simple, also you can create a function-based index to give fast performance. Rgds Greg -Original Message-From: Saurabh Sharma [mailto:[EMAIL PROTECTED]]Sent: Thursday, 31 May 2001 09:50To: Multiple recipients of list ORACLE-LSubject: querry.. hi list, how can i select two columns from a table based on condition that they are selected in specified combinations. let me.. table 1 has 2 columns col1, col2. both cols have values , say, alphabets. a,b,c,d,e,f,... i'want to select like FOR VALUE OF COL1 IN A, col2 must fetch only between A-E for value of col1 in B, col2 must be between A-X -- and so on.. i want to define this combination, so i should get only these pair of values. any suggestions. thanks. saurabh
Rebuilding indexes
For those of you that have implemented a standby database, what method do you use to rebuild your indexes tablespace. My plan was to create a new tablespace and rebuild the indexes into the new tablespace and then reverse the process to move back to the original tablespace after I drop and recreate it in order to get rid of fragmentation in the originally indexes tablespace. However, creating the new datafile associated with the new tablespace, cancels media recovery associated with the standby database...just wondered if anyone has a better method of defragging an index tablespace when there is a standby database catching the redo it generates. TIA, Richard Huntley -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Richard Huntley 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: Your views on Quest - Shareplex
Marc, You didn't mention the Oracle version, but I wouldn't be surprised if it was O7 as the serial push using the two-phase commit process doesn't scale well at all. The completely new architecture (AQ, parallel propagation, min communication, etc...) in O8 makes replication quite scalable even at very high transaction rates. -- Anita --- Marc Perkowitz [EMAIL PROTECTED] wrote: Rao, I worked at MCI Teleconferencing for a few years and they were using SharePlex for a reporting database. Oracle replication was not fast enough to support their transaction rate and they also could not afford the overhead on the source database that occurs with Oracle replication. After a few startup issues, it worked well for them, and AFAIK, they are still using it. During their research, they also found that Amazon.com was using it for, I think, data warehousing -- not their transactional system. Interesting enough, I understand that Oracle has built an equivalent feature that was planned to be part of 9i. I haven't read enough on 9i to see if it made it in there or not. Perhaps someone else knows about this. Marc Perkowitz Senior Consultant TWJ Consulting, LLP 847-256-8866 x15 www.twjconsulting.com - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, May 29, 2001 12:16 PM List, My company is considering Quest - Shareplex. We are considering to use this in our dataware house. Basically, this will pull all the transactions from OLTP database and populate staging area in the dataware house. Could you please give your experiences and the pros and cons of this Shareplex product. Thanks, Rao -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rao, Maheswara 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: Marc Perkowitz INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: A. Bardeen 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: what's hash-join
What's the performance (gain/loss) on such a join, when would you want to use one? Kev -Original Message- McDonald Sent: Thursday, May 31, 2001 6:00 AM To: Multiple recipients of list ORACLE-L A method of joining two tables. You scan each and use a hashing algorithm to isolate/match keys. hth connor --- Senthil Ganapathi [EMAIL PROTECTED] wrote: Hi Rukmini could tell me what's that hash-join GSK Rukmini DeviTo: Multiple recipients of list ORACLE-L rukmini@indb [EMAIL PROTECTED] rain.comcc: Sent by: Subject: Re: 4 join methods? root@fatcity. com 31-05-01 09:55 AM Please respond to ORACLE-L 1. Equi-join 2. Self-join 3. Outer-join 4. Hash-join rukmini - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, May 31, 2001 11:20 AM i feel the fourth one is self join. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, May 31, 2001 8:10 AM Hi, I just read there are four join methods. I know three: Nested loops Sort merge Hash join What's the fourth? - Greg -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Moore 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: Saurabh Sharma 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: Rukmini Devi 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: Senthil Ganapathi 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). = Connor McDonald http://www.oracledba.co.uk (mirrored at http://www.oradba.freeserve.co.uk) Some days you're the pigeon, some days you're the statue Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= 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]
DB2 vs Oracle
Hi people, A few weeks back somebody posted a message regarding an eval they are doing comparing Oracle/DB2/SQLServer. I came across a great document today for an Oracle/DB2 comparison, so if that person - sorry I can't remember who it was - is interested, contact me back channel, and I'll send it over to you. Regards Mark -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith 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: querry..
Hey Saurabh, try using dynamic query as per your requirement. pp. hi list, how can i select two columns from a table based on condition that they are selected in specified combinations. let me.. table 1 has 2 columns col1, col2. both cols have values , say, alphabets. a,b,c,d,e,f,... i'want to select like FOR VALUE OF COL1 IN A, col2 must fetch only between A-E for value of col1 in B, col2 must be between A-X -- and so on.. i want to define this combination, so i should get only these pair of values. any suggestions. thanks. saurabh -- 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: Pritam INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Re[2]: About parallel server
Dick, Just curious, I can see putting the control file on a file system but I failed to see how can you put online redo logs on file system in OPS. Unless you are using distributed file system? How does one node do instance recovery for the failed node? Richard Ji [EMAIL PROTECTED] 05/31/01 01:10AM Brian, I was looking at parallel server for an application we were developing last year. In 8.1.6 at least the control and on-line redo (not rollback segment) files no longer had to be on raw devices. And I stand corrected, there is one and only one standard unix command that does work, dd. It's just such a pile of alphabet soup. That's why we hired a couple of top notch Unix admins. They handle it. Dick Goulet -- Reply Separator -- Author: Brian MacLean [EMAIL PROTECTED] Date: 5/30/01 3:50 PM Your point 1: Unless things have changed redo and controlfiles must be raw. When I took the OPS course several years ago and worked with OPS we needed the redo/controlfiles to be on raw so that one instance could recover when another instance failed. Your point 5: The Unix command dd will do raw. -Original Message- Sent: Wednesday, May 30, 2001 3:48 PM To: Multiple recipients of list ORACLE-L Fernando, Replies included in your original mail, but in addition: Parallel server is a separately priced option from Oracle and it is pricey. Second you may need specific software from you OS vendor to coordinate the file sharing between the servers, again an additional expense. Dick Goulet Reply Separator Author: Fernando Papa [EMAIL PROTECTED] Date: 5/30/2001 2:07 PM Hi everybody! I have some questions about parallel server. Now we have only one instance stand-alone (no parallel), but we are thinking to switch to parallel server because we have a couple of sparc 3500 and nobody are using it, and we think it's good for increase our processing power. The problem is I didn't work with parallel server and I have a lot of questions about it: 1) Is mandatory to use raw devices for control files, redo logs data files? -- Data files yes, redo and control files can be on cooked file system. 2) How we transfer our cooked data files to raw devices data files? import/export? or exist another better (fast) method? -- To the best of my knowledge your going to have to rebuild the database from scratch so imp/exp is your only option. 3) If I start with only one node, performance will be the same of one single instance (no parallel)? -- Yes and NO, raw devices run a little faster than cooked files since the OS's buffer cache is not in the middle. 4) Somebody know how to work with raw devices under solaris? any link? I try to found someting in metalink but there's no samples... -- Working with raw devices is very different from cooked file systems. If you don't have an experienced Unix admin you could be in serious trouble. 5) What about backup? I can't put tablespaces in backup mode and copy with cp... maybe it's time to use rman? -- Rman can handle the backups, but a file system level backup is different. CP does not work anymore, nor does fbackup, or tar. You'll need specialized software for the purpose. Thanks in advance! -- Fernando O. Papa DBA El Sitio - Infraestructura (54-11) 4339-3854 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Fernando Papa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Richard Ji INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists
RE: what's hash-join
Kev: How well a HASH join works depends on the data you are working with. In my experience it works best when you are joining a large table against a very small table. I've seen up to 50% improvement when I forced the optimizer to use HASH joins instead of Nested Loops or Merge Joins Kevin -Original Message- Sent: Thursday, May 31, 2001 9:34 AM To: Multiple recipients of list ORACLE-L What's the performance (gain/loss) on such a join, when would you want to use one? Kev -Original Message- McDonald Sent: Thursday, May 31, 2001 6:00 AM To: Multiple recipients of list ORACLE-L A method of joining two tables. You scan each and use a hashing algorithm to isolate/match keys. hth connor --- Senthil Ganapathi [EMAIL PROTECTED] wrote: Hi Rukmini could tell me what's that hash-join GSK Rukmini DeviTo: Multiple recipients of list ORACLE-L rukmini@indb [EMAIL PROTECTED] rain.comcc: Sent by: Subject: Re: 4 join methods? root@fatcity. com 31-05-01 09:55 AM Please respond to ORACLE-L 1. Equi-join 2. Self-join 3. Outer-join 4. Hash-join rukmini - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, May 31, 2001 11:20 AM i feel the fourth one is self join. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, May 31, 2001 8:10 AM Hi, I just read there are four join methods. I know three: Nested loops Sort merge Hash join What's the fourth? - Greg -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Moore 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: Saurabh Sharma 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: Rukmini Devi 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: Senthil Ganapathi 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). = Connor McDonald http://www.oracledba.co.uk (mirrored at http://www.oradba.freeserve.co.uk) Some days you're the pigeon, some days you're the statue Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie -- Please see the official
Re: cannot drop snapshot with partition.
Sandesh, This is a known bug (1335477) that allows you to rename a snapshot/materialized view, which you shouldn't be allowed to do. What you've got now is data dictionary corruption because not all of the data dictionary entries were changed when the snapshot was renamed. You can try renaming the snapshot back to its original name, but I suspect you'll get an error that the object already exists. Your only option, other than a PITR prior to when the snapshot was renamed, is probably to log a tar with support so they can walk you through correcting the data dictionary corruption. This is not something I'd advise trying on your own unless you can afford to lose this db. HTH, -- Anita --- Naik, Sandesh S [EMAIL PROTECTED] wrote: Hi All, I have a 8.1.6.2 database on hp9000. (11.0). I have created one snapshot , with partition. Now I not able to drop snapshot or nor I cam drop last partition. It does not show that snapshot in dba_snapshot. I renamed the snapshot to old. But drop snapshot is not working SQL drop snapshot old; drop snapshot old * ERROR at line 1: ORA-12003: snapshot SYS.OLD does not exist If I try to drop the table then it gives this error SQL drop table old; drop table old * ERROR at line 1: ORA-12083: must use DROP MATERIALIZED VIEW to drop SYS.OLD Does somebody has encountered this error or has solution to this problem. Sandesh -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Naik, Sandesh S INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: A. Bardeen 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: backspace in Oracle.
No doubt Novell at the time was more stable than NT at the time. But some of these stories, which can start off as My Novell box seems more stable than that NT 3.51 SP 1 box mutate into internet apocrypha faster than you can spell telephone. Before you know it, it's a heartlung machine, coded in assembler, running on a Novell beta release cross compiled to the Kaypro, which has been up, even through tornadoes, for 22 years. Meanwhile, the NT box crashed on boot up, then corrupted the disk, sold the house, and slept with my wife. I always ask for details. Two reasons. The first is to take a litmus test for veracity. The other is (assuming veracity) to learn something about how to make systems stable. shrug || -Original Message- || From: Eric D. Pierce [mailto:[EMAIL PROTECTED]] || Sent: Wednesday, May 30, 2001 5:48 PM || To: Multiple recipients of list ORACLE-L || Subject: RE: backspace in Oracle. || || || that would be if the stupid (HELP) data janitor remembers to do || VREPAIR once every other month or so. sometime the stupid data || janitor forgets and only does it once a year (with no other || downtime). || || in other words, except for occasional/normal piddly maintenance || (which is not otherwise required to keep the system up), netware3x || will not typically experience the same thing as the (supposedly) || infamous NT reboots. || || ??? || || ep || || On 30 May 2001, at 13:10, Mohan, Ross wrote: || || Date sent: Wed, 30 May 2001 13:10:37 -0800 || To: Multiple recipients of list ORACLE-L || [EMAIL PROTECTED] || || I am all for NLMs, DLMs, and MM. || || But, if you let me bounce most any NT box || once a month for, say, a DEFRAG, I'll be || able to keep it up for one helluva long || time too. || || Ross NMN Mohan || || || -Original Message- || || From: Eric D. Pierce [mailto:[EMAIL PROTECTED]] || || Sent: Wednesday, May 30, 2001 4:03 PM || || To: Multiple recipients of list ORACLE-L || || Subject: RE: backspace in Oracle. || || ... || || || Only reason for downtime is running VREPAIR (rough || equivalent of || || scandisk) about once every other month, and also when || the startup || || files need maintenance (usually related to changed || parameters on || || .nlms loaded, versoin upgrades, etc) and a bounce is || required. also || || we recently had to put in a new UPS battery, which || required a down. || || ... || || || -- || Please see the official ORACLE-L FAQ: http://www.orafaq.com || -- || Author: Eric D. Pierce || INET: [EMAIL PROTECTED] || || Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 || San Diego, California-- Public Internet access / || Mailing Lists || || To REMOVE yourself from this mailing list, send an E-Mail message || to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in || the message BODY, include a line containing: UNSUB ORACLE-L || (or the name of mailing list you want to be removed from). You may || also send the HELP command for other information (like subscribing). || -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross 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: 4 join methods?
Search this page for the word hash, you will find a good article on hash joins. http://www.itsystems.lv/gints/files/oracle/oracle.htm - Ethan Post -Original Message- Sent: Thursday, May 31, 2001 4:57 AM To: Multiple recipients of list ORACLE-L Where can I get the documentation for join methods ? rukmini - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, May 31, 2001 3:45 PM At 22:55 -0800 30/5/01, Rukmini Devi wrote: 1. Equi-join 2. Self-join 3. Outer-join 4. Hash-join Outer join is a logical type not an access method. the four types of join that Oracle can use: Nested Loops join Sort Merge join (equi-join only) Cluster join (equi-join on cluster key only) Hash join (equijoin, cost-based only) Regards Paul Miller -- - Carib Data Limited mailto:[EMAIL PROTECTED] http://www.caribdata.co.uk -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: PD Miller 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: Rukmini Devi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- This e-mail is intended for the use of the addressee(s) only and may contain privileged, confidential, or proprietary information that is exempt from disclosure under law. If you have received this message in error, please inform us promptly by reply e-mail, then delete the e-mail and destroy any printed copy. Thank you. == -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan 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: what's hash-join
It will perform better than sort and merge and nested loops in most cases. They tend to be fast. But will not out perform index nested loops in most cases. Although in some cases a sort and merge can out perform a hash join. Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Thursday, May 31, 2001 9:34 AM To: Multiple recipients of list ORACLE-L What's the performance (gain/loss) on such a join, when would you want to use one? Kev -Original Message- McDonald Sent: Thursday, May 31, 2001 6:00 AM To: Multiple recipients of list ORACLE-L A method of joining two tables. You scan each and use a hashing algorithm to isolate/match keys. hth connor --- Senthil Ganapathi [EMAIL PROTECTED] wrote: Hi Rukmini could tell me what's that hash-join GSK Rukmini DeviTo: Multiple recipients of list ORACLE-L rukmini@indb [EMAIL PROTECTED] rain.comcc: Sent by: Subject: Re: 4 join methods? root@fatcity. com 31-05-01 09:55 AM Please respond to ORACLE-L 1. Equi-join 2. Self-join 3. Outer-join 4. Hash-join rukmini - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, May 31, 2001 11:20 AM i feel the fourth one is self join. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, May 31, 2001 8:10 AM Hi, I just read there are four join methods. I know three: Nested loops Sort merge Hash join What's the fourth? - Greg -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Moore 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: Saurabh Sharma 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: Rukmini Devi 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: Senthil Ganapathi 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). = Connor McDonald http://www.oracledba.co.uk (mirrored at http://www.oradba.freeserve.co.uk) Some days you're the pigeon, some days you're the statue Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free
RE: OT: Archiving not possible with SQL Server?
Yeah? But you know what? After few hours with SQL manual I'm starting to feel like an idiot. Supreme Council says: All Aboard MS SQL! Me says: Abandon Ship! Gary Weber Senior DBA Charles Jones, LLC 609-530-1144, ext 5529 -Original Message- Patrice J Sent: Thursday, May 31, 2001 7:35 AM To: Multiple recipients of list ORACLE-L Jared is having a bad day. : ) Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- From: Jared Still [SMTP:[EMAIL PROTECTED]] Sent: Thursday, May 31, 2001 3:51 AM To: Multiple recipients of list ORACLE-L Subject:Re: OT: Archiving not possible with SQL Server? Are you an idiot? Jared On Wednesday 30 May 2001 14:55, Gary Weber wrote: Guess what happens when a long running transaction marks the log near the end, and not too long afterward the log needs truncated? If memory serves, ( hasn't worked too well lately :) the database will hang. It may just truncate back to the mark, and start from there, but you always have the possibility of another long transaction starting. HELP -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gary Weber 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: Rebuilding indexes
FOR YOUR INFORMATION ESIS and EPFAL are now part of Logica. The Internet email addresses of the staff has changed to the following - [EMAIL PROTECTED] eg [EMAIL PROTECTED] Emails using the old format will continue to be delivered until 30th June 2001. Richard, You could always use the rebuild index nologging option. Or even the alter index index_name coalesce These may negate the requirements to move them from one tablespace to another HTH John John Hallas *+44 (0) 115 945 6643 * +44 (0) 115 945 6774 -Original Message- From: Richard Huntley [mailto:[EMAIL PROTECTED]] Sent: 31 May 2001 15:01 To: Multiple recipients of list ORACLE-L Subject:Rebuilding indexes For those of you that have implemented a standby database, what method do you use to rebuild your indexes tablespace. My plan was to create a new tablespace and rebuild the indexes into the new tablespace and then reverse the process to move back to the original tablespace after I drop and recreate it in order to get rid of fragmentation in the originally indexes tablespace. However, creating the new datafile associated with the new tablespace, cancels media recovery associated with the standby database...just wondered if anyone has a better method of defragging an index tablespace when there is a standby database catching the redo it generates. TIA, Richard Huntley -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Richard Huntley INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). This e-mail and any files transmitted with it, are confidential to Logica and are intended solely for the use of the individual or entity to whom they are addressed. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hallas, John 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: Unix File Open Port Open
you could also look into using the /proc filesystem. that's what it's there forsorry, but this'll be another RTFM drill, I don't have my unix web site available for easy clicking. || -Original Message- || From: Kevin Lange [mailto:[EMAIL PROTECTED]] || Sent: Thursday, May 31, 2001 10:42 AM || To: Multiple recipients of list ORACLE-L || Subject: RE: Unix File Open Port Open || || || You might try the netstat and the fuser commands. || || I believe netstat -a will give you all the ports in use and || fuser will tell || you what processes have the files open in the current directory. || || -Original Message- || Sent: Wednesday, May 30, 2001 8:40 PM || To: Multiple recipients of list ORACLE-L || || || Hello, || || This is an off topic, UNIX question. || || Can any one please tell me how to get the Unix File Open and || Port Open in || SCO or AIX, or SUN? I am not sure whether they are part of || sar output, so || please help. I am not sure whether I can get this kind of || information. || || thanks every one in advance. || || rgds, || || raja || || || Get 250 color business cards for FREE! || http://businesscards.lycos.com/vp/fastpath/ || -- || Please see the official ORACLE-L FAQ: http://www.orafaq.com || -- || Author: Viraj Luthra || 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: Kevin Lange || 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: Mohan, Ross 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: URGENT ODBC HELP REQUIRED
Title: URGENT ODBC HELP REQUIRED be something like this (check for errors): open database data1LOCAL lcCursorName, lnreturnlcCursorName = "SQLRESULT"gcODBCDataSource = 'odbcname'gcSQLUserID = 'oracleuser'gcSQLPassword = 'oraclepass' gnConnHandle = SQLCONNECT(gcODBCDataSource, gcSQLUserID, gcSQLPassword)IF gnConnHandle = 0= mbox('Cannot make connection', 16, 'SQL Connect Error')RETURNENDIFSET DATABASE TO data1CREATE CONNECTIONmytest DATASOURCE gcODBCDataSource USERID gcSQLUserID PASSWORD gcSQLPasswordcreate sql view tmp remote connectionodbcname as select * from tmp DBSETPROP('TMP', "VIEW", "MAXRECORDS", -1) DBSETPROP('TMP', "VIEW", "FETCHMEMO", .T.)DBSETPROP('TMP', "VIEW", "FETCHSIZE", 50)USE 'tmp'CURSORSETPROP("KeyFieldList", 'prime_id) CURSORSETPROP("Tables", 'tmp') CURSORSETPROP("SendUpdates", .T.) IF !USED("real")USEreal IN 0 ALIAS realENDIFIF !USED("tmp")USEtmp IN 0 ALIAS tmpENDIFSELECT tmpSCANSELECTrealreplace all real.col with tmp.col ; for real.key = tmp.keyENDSCAN -Original Message-From: Arslan Dar [mailto:[EMAIL PROTECTED]]Sent: Wednesday, May 30, 2001 8:55 PMTo: Multiple recipients of list ORACLE-LSubject: URGENT ODBC HELP REQUIRED Hi dba's, I want to communicate between Oracle 8 and Clipper.I want to get data from Clipper/Foxpro Dbf file into oracle through ODBC. can anybody guide me how to do that. Any links, ? TIA Arslan
Oracle Applications
Still no response from Oracle Canada, I left a message again - they didn't know what to do when people order CD Packs... Meanwhile I saw on the 'net a job posting that had as one of the competency requirements: 4 years experience with Oracle Applications. I guess this is supposed to be funny. : ) Patrice Boivin Systems Analyst (Oracle Certified DBA) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: multiple versions of SQLPlus.exe [now evolved to: multiple versions of tnsnames.ora in NT/W2K]
Yup it is a string and not a key - thanks for pointing that out :) -Original Message- Sent: Wednesday, May 30, 2001 05:36 To: Multiple recipients of list ORACLE-L versions of tnsnames.ora in NT/W2K] If under HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE you have one or multiple folders, like: HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE/HOME0 HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE/HOME1 then you have to create TNS_ADMIN string value (not key) in each of those folders pointing to your master tnsnames.ora file. Works for me. Igor Neyman, OCP DBA Perceptron, Inc. (734)414-4627 [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, May 30, 2001 10:56 AM versions of tnsnames.ora in NT/W2K] On NT 4 with Developer 6i and Oracle 816/817 I have never been able to get Oracle db to work off of the tns_admin key. Only forms would work off of the tns_admin, and without that key forms would not connect to the dbs. Just thought I would mention that. Kev -Original Message- Sent: Wednesday, May 30, 2001 7:16 AM To: Multiple recipients of list ORACLE-L versions of tnsnames.ora in NT/W2K] You CAN actually set the TNS_ADMIN variable in the registry under HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE/ - It may not be there at first, all you need to do is create a new key called TNS_ADMIN with a value of the path to your master tnsnames.ora file. HTH Mark -Original Message- Granaman Sent: Tuesday, May 29, 2001 09:45 To: Multiple recipients of list ORACLE-L versions of tnsnames.ora in NT/W2K] In Unix, one can create links to a master by $ ls -s some master tnsnames.ora some other location/file. (I know, I could, and probably should, use the TNS_ADMIN environmental variable instead.) There seems to be no equivalent of this in NT though. Creating a shortcut doesn't seem to work. Copying files around seems primitive at best. Am I missing something? [OK, OK! I'll reform and use the environmental variable!] -Don Granaman [certifiable OraSaurus] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, May 29, 2001 2:01 PM Dave, It seems to me that you are having a problem reading the proper TNSNAMES.ORA for the different DBs. What I would do in your situation is to search for all TNSNAMES.ORA files in your PC, since you have products installed in more than one home and more than one version you should have multiple. Edit them and see which ones contain the entries that you need, in one or more of them some entries will be missing, what you can do is copy/paste the missing entries, once you have the file you want then copy it to all the different Homes and you should be able to connect to the different DB's. [... snip ...] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Don Granaman 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: Mark Leith 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: Kevin Kostyszyn 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: Igor Neyman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051
Re:About parallel server
Dick As far as I know, at least in Sun, sequent, hp and linux, you need to have control files and redo log files in raw disk. Every instance needs access to other thread's redo log files to do instance recovery for the failed instances. Only if the data is in the raw disk, multiple nodes can share the same disks. Control file is updated by all the instances. Out of curiosity, what OS were you using ? I just read Scott Heisey's email too and realized that you don't need to use raw disks for few platforms such as True64. May be you were one of those platforms? Rachel is absolutely correct and we have learnt this lesson hard way. But Oracle 9i Real Application cluster ( aka OPS) is supposedly remove these barriers. Cache fusion is a new feature introduced in 8i, by which disk writes due to true ping is avoided by transferring the data directly from one instance to another instance cache,( only for consistent reads in 8i). Oracle 9i apparently introduces cache fusion for read/read, read/write,write/write scenarios also. In this case, there is a probability that the required block to be transferred between the instances just from the buffer cache itself avoiding the disk access. Also Oracle claims that Real application cluster does not need any change in the application design. I am not sure how all this going to play in the real field, but interesting to know. Thanks Riyaj Re-yas Shamsudeen Certified Oracle DBA i2 technologies www.i2.com Rachel Carmichael [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 05/30/01 09:50 PM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re:About parallel server Even more importantly, if you are planning on implementing parallel server just to increase your processing power then you are going to be in trouble! If you haven't specifically designed your application for parallel server, you can end up DECREASING performance by increasing locking and pings. This is not something you do lightly once an app has been installed into production. Rachel From: [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re:About parallel server Date: Wed, 30 May 2001 14:48:03 -0800 Fernando, Replies included in your original mail, but in addition: Parallel server is a separately priced option from Oracle and it is pricey. Second you may need specific software from you OS vendor to coordinate the file sharing between the servers, again an additional expense. Dick Goulet Reply Separator Author: Fernando Papa [EMAIL PROTECTED] Date:5/30/2001 2:07 PM Hi everybody! I have some questions about parallel server. Now we have only one instance stand-alone (no parallel), but we are thinking to switch to parallel server because we have a couple of sparc 3500 and nobody are using it, and we think it's good for increase our processing power. The problem is I didn't work with parallel server and I have a lot of questions about it: 1) Is mandatory to use raw devices for control files, redo logs data files? -- Data files yes, redo and control files can be on cooked file system. 2) How we transfer our cooked data files to raw devices data files? import/export? or exist another better (fast) method? -- To the best of my knowledge your going to have to rebuild the database from scratch so imp/exp is your only option. 3) If I start with only one node, performance will be the same of one single instance (no parallel)? -- Yes and NO, raw devices run a little faster than cooked files since the OS's buffer cache is not in the middle. 4) Somebody know how to work with raw devices under solaris? any link? I try to found someting in metalink but there's no samples... -- Working with raw devices is very different from cooked file systems. If you don't have an experienced Unix admin you could be in serious trouble. 5) What about backup? I can't put tablespaces in backup mode and copy with cp... maybe it's time to use rman? -- Rman can handle the backups, but a file system level backup is different. CP does not work anymore, nor does fbackup, or tar. You'll need specialized software for the purpose. Thanks in advance! -- Fernando O. Papa DBA El Sitio - Infraestructura (54-11) 4339-3854 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Fernando Papa 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
RE: Database Links
Tracy, I have a similar deal going on here. If you are on version 8.1.x and the lookup tables are large, you can use Materialized Views, and since they are lookup tables that shouldn't change much, you should only have to refresh them every once in a while. If they are really small tables, however, you can just use database links. What I do is create a view across a database link on top of the lookup tables. I then create a synonym on the view that is the same as the lookup tables' name. The users, then, have no idea the tables don't exist locally. Jim Jim Hawkins Lead SAPR/3 Oracle DBA MEMC Electronic Materials, Inc. St. Louis, MO (636) 474-7832 [EMAIL PROTECTED] (work) [EMAIL PROTECTED] (personal) -Original Message- Rahmlow Sent: Wednesday, May 30, 2001 6:10 PM To: Multiple recipients of list ORACLE-L We have several large look-up tables that we use in development as well as in production environments. The data is the same in both environments. I am looking for some comments regarding whether or not we store duplicate data in each environment or should we allow the development users to access the table in production through a database link. Below, I have listed some issues with both of these processes and am looking for further input. Thanks Duplicate table in production and development (either through export/import or snapshots): Cons additional storage is need process needed to keep tables in sync Pros reduced network traffic Access table in production through a database link in development: Cons additional network traffic possibility of poorly tuned adhoc sql executing in a production environment Pros only one copy of table do not need an ongoing process to keep the tables in sync -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tracy Rahmlow 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: Hawkins Family 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: need site address for Form and Reports discussion
[EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') You may also send the HELP command for other information (like subscribing). list name: ODTUG-DEV2K-L rgds amar -Original Message- Sent: Thursday, May 31, 2001 11:31 AM To: Multiple recipients of list ORACLE-L Hi Here we can discuss about Dba related things, like wise any site to discuss about Forms and Reports -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Senthil Ganapathi 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: Amar Kumar Padhi 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: About parallel server
Title: RE: About parallel server Dick, What are you using for your source for this information? This does not jibe with other things I have read. If your not going to use a shared raw device for the online redo logs, how can one instance to instance recovery for another instance that fails? R. Matt Adams - GE Appliances - [EMAIL PROTECTED] Meddle not in the affairs of troff, for it is subtle and quick to anger. -- Data files yes, redo and control files can be on cooked file system.
RE: ORACLE NAMES /LDAP
Vikas, I just implemented Oracle Names (8.1.6) for Verizon Wireless...corporate-wide. I've setup three ONAMES servers: 1. At Corporate Headquarters in NJ. This server contains the region database for ONAMES. It also serves as the Secondary ONAMES server corporate-wide. 2. In data center in NY. This server provides Primary ONAMES services to the corporate regions in both the North East and South areas. 3. In data center in CA. This server provides Primary ONAMES services to the corporate regions in both the West and Midwest areas. This infrastructure supports 26,000 users accessing 250+ databases corporate-wide. Oracle Names is making its' terminal release in 9i. Oracle is recommending that companies migrate to their LDAP (Oracle Internet Directory) solution. This solution is not cheap...so we have decided to wait probably another year or so before going this route. OiD is also a bit more complicated to setup and administer. Ed Haskins Oracle DBA Verizon Wireless -Original Message- Sent: Thursday, May 31, 2001 5:06 AM To: Multiple recipients of list ORACLE-L Anyone using this product as an alternative to Local Naming ? How about LDAP ? Any info /suggestions/comments are welcome vikas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vikas Kawatra 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: Haskins, Ed 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: problem with trunc()
Title: RE: problem with trunc() Steve, we need to see you explain plan! Can you at least post an autotrace? it's possible you have wide range scans going on, even with an index. Send us your autotrace, the query does not have to execute in order for that to be done SET AUTOTRACE TRACEONLY EXPLAIN and execute the query. It will just give you the plan. Lisa Koivu Oracle Database Administrator 954-935-4117 The information in the electronic mail message is Cendant confidential and may be legally privileged, it is intended solely for the addressee(s) access to this internet electronic mail message by anyone else is unauthorized. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it is prohibited and may be unlawful. The sender believes that this E-mail and any attachments were free of any virus, worm, Trojan horse, and/or malicious code when sent. This message and its attachments could have been infected during transmission. By reading the message and opening any attachments, the recipient accepts full responsibility for taking protective and remedial action about viruses and other defects. Cendant Corporation or Affiliates are not liable for any loss or damage arising in any way from this message or its attachments. -Original Message- From: Steve Sapovits [SMTP:[EMAIL PROTECTED]] Sent: Thursday, May 31, 2001 12:01 PM To: Multiple recipients of list ORACLE-L Subject: problem with trunc() I have a query that contains these lines as part of the WHERE clause: WHERE trunc(it.transaction_date) = to_date('May-19-2001', 'Mon-dd-') This works fine -- the query returns in about a minute, which is what I'd expect for the table sizes, the rest of the joins, etc. Changing to the following causes the time to go to about 7 hours! WHERE trunc(it.transaction_date) BETWEEN to_date('May-19-2001', 'Mon-dd-') AND to_date('May-28-2001', 'Mon-dd-') Changing the BETWEEN to = AND = gives the same long results. What makes it go back to normal is dropping the trunc(), or otherwise rewriting it so there is no trunc(). So I have a workaround. But I'm curious why there'd be such a huge difference. Running just the BETWEEN piece by itself works fine. This is Oracle 8.1.6 on Solaris. I've tried indexing the transaction_date column both as transaction_date and trunc(transaction_date) but there's no difference. I've used both individual column indexes and combined with other WHERE clause columns used. One web site I found said there's an 8i bug creating functional indexes using trunc() but I have not verified that. I've started to analyze but SQL*Plus autotrace takes almost as long to return (7 hours) so it's not too useful at this point. Steve Sapovits Global Sports Interactive Work Email: [EMAIL PROTECTED] Home Email: [EMAIL PROTECTED] Work Phone: 610-491-7087 Cell: 610-574-7706 Pager: 877-239-4003 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steve Sapovits INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Re[2]:Your views on Quest - Shareplex
Bear in mind, Oralce is not always 100% accurate, specially when something competes with their product. Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Tuesday, May 29, 2001 5:06 PM To: Multiple recipients of list ORACLE-L Jim, Thanks, just assures me that it is NOT a product that I want around. Dick Goulet Reply Separator Author: Jim Hawkins [EMAIL PROTECTED] Date: 5/29/2001 11:01 AM All, We are currently as customer of Quest Software using LiveReorg and Spotlight. For those who don't know, LiveReorg is a combination of two existing Quest products, Space Manager and SharePlex. I asked the exact same question regarding the mining of redo logs of our Quest sales rep. I thought all would be interested in the reply. It is a in-line reply to an Oracle MetaLink document. Jim Hawkins Lead SAPR/3 Oracle Database Administrator MEMC Electronic Materials, Inc. 600 Pearl Drive St. Louis, MO 633376 9636) 474-7832 [EMAIL PROTECTED] (work) [EMAIL PROTECTED] (home) Doc ID: Note:97080.1 Subject: Extracting Data from Redo Logs Is Not A Supported Interface Type: BULLETIN Status: PUBLISHED Content Type: TEXT/PLAIN Creation Date: 22-JAN-2000 Last Revision Date: 17-FEB-2000 Language: USAENG PURPOSE --- To explain why any extraction of data from redo logs is not supported. SCOPE APPLICATION --- Customers who are considering using Quest SharePlex for disaster recovery. Extracting Data from Redo Logs Is Not A Supported Interface -- Quest SharePlex for Oracle replicates data to one or more other Oracle instances. It attempts to use the information in the redo log to replicate transactions remotely. 1) There is not sufficient information in the logs to logically replicate transactions, so the data applied to the destination system may be different from the primary, and therefore inaccurate. Eyal: That is correct. A part of the SharePlex product goes back to the source database and completes the missing information. This is done only for certain types of Update statements but is not nessasery for Inserts and Deletes. 2) Reading the redo log is not a supported interface. From the very beginning, Oracle has changed redo log formats to support functional enhancements. We must therefore reserve the right to continue to make needed log format changes. For this reason, certification of any third party product using this interface is not possible. Since this is an unsupported interface, the accuracy or completeness of the data in the destination database can not be assured. Eyal: The power of the product is the direct result from reading the raw log data. It is our core competency in Quest to understand and support the changing nature of the Oracle log. The reality is that between version 7.0 until 8.1.6 there where only minor changes to the log. Since we are a close partner with Oracle we get early releases of the software and we have the chance to update the product as needed. So far this has never been an issue since most large production sites are running Oracle versions that are atleast 6 months to a year old. Regarding assurance to the completeness of the data, we do not expect Oracle to provide any assurance. Quest is the one that assures the content of the destination. Quest support has some of the best support experts in the business. Any problem with the database content should be directed to our support organization and not Oracle World Wide Support. Likelihood of Occurrence ~ Unknown. However, even a low likelihood is a concern for disaster recovery (DR). In disaster failovers, the remote server's database may be the only viable copy. Eyal: Since Oracle uses the data in the log to perform database recovery, all the information necessary to create a point in time image of the database exists in the log. However, we believe that SharePlex has a better chance to survive a disaster than even a database recovery. This is because SharePlex only needs the data to recover a transaction while Oracle needs all changes present in the log, including index and rollback changes, to successfully recover a database. An index block corruption may render the recovered database useless. History indicates that SharePlex can withstand most log corruptions and data block corruptions, while maintaining a viable live standby site. If the client is not a 100% sure, SharePlex provides a variety of mechanisms to periodically resync the standby database, including the ability to use a hot backup and 3rd party disk mirroring
lsnrctl question
If I want to know the status of the external procedure listener for the current SID, but do not know what the external procedure listener's name is, how can I use lsnrctl to find out it's status. John -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Dunn 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).
Partition Elimination
Hi All, Can anyone help me with this. I have range partitioned a table (no indexes) and then computed statistics. I have now queried the table using the partition key as the only criteria in the where clause. Why does Oracle still do a full table scan, why is it not clever enough to only scan the partition(s) effected by the where condition?. The Oracle documentation gives a good insight into partitioning but does not go into detail about when partition elimination will be performed and what the explain plan would look like when this occurs. If anyone can point me to a section of the documentation that covers this I would be grateful. Many Thanks, Dave Leach ** The above information is confidential to the addressee and may be privileged. Unauthorised access and use is prohibited. Internet communications are not secure and therefore this Company does not accept legal responsibility for the contents of this message. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited and may be unlawful. Hogg Robinson PLC Registered Office: Abbey House, 282 Farnborough Road, Farnborough, Hampshire GU14 7NJ Registered in England and Wales No 3249700 ** -- 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).
RE: problem with trunc()
Doing that now. The last time I tried it hung out there for over 5 hours and I had to kill it for other reasons. Isn't there a faster analysis tool? It seems to be an Oracle Catch-22 that analyzing queries that take too long takes too long ... Steve Sapovits Global Sports Interactive Work Email: [EMAIL PROTECTED] Home Email: [EMAIL PROTECTED] Work Phone: 610-491-7087 Cell: 610-574-7706 Pager: 877-239-4003 -Original Message- From: Lisa Koivu [SMTP:[EMAIL PROTECTED]] Sent: Thursday, May 31, 2001 11:43 AM To: '[EMAIL PROTECTED]'; '[EMAIL PROTECTED]' Subject: RE: problem with trunc() Steve, we need to see you explain plan! Can you at least post an autotrace? it's possible you have wide range scans going on, even with an index. Send us your autotrace, the query does not have to execute in order for that to be done SET AUTOTRACE TRACEONLY EXPLAIN and execute the query. It will just give you the plan. Lisa Koivu Oracle Database Administrator 954-935-4117 The information in the electronic mail message is Cendant confidential and may be legally privileged, it is intended solely for the addressee(s) access to this internet electronic mail message by anyone else is unauthorized. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it is prohibited and may be unlawful. The sender believes that this E-mail and any attachments were free of any virus, worm, Trojan horse, and/or malicious code when sent. This message and its attachments could have been infected during transmission. By reading the message and opening any attachments, the recipient accepts full responsibility for taking protective and remedial action about viruses and other defects. Cendant Corporation or Affiliates are not liable for any loss or damage arising in any way from this message or its attachments. -Original Message- From: Steve Sapovits [SMTP:[EMAIL PROTECTED]] Sent: Thursday, May 31, 2001 12:01 PM To: Multiple recipients of list ORACLE-L Subject:problem with trunc() I have a query that contains these lines as part of the WHERE clause: WHERE trunc(it.transaction_date) = to_date('May-19-2001', 'Mon-dd-') This works fine -- the query returns in about a minute, which is what I'd expect for the table sizes, the rest of the joins, etc. Changing to the following causes the time to go to about 7 hours! WHERE trunc(it.transaction_date) BETWEEN to_date('May-19-2001', 'Mon-dd-') AND to_date('May-28-2001', 'Mon-dd-') Changing the BETWEEN to = AND = gives the same long results. What makes it go back to normal is dropping the trunc(), or otherwise rewriting it so there is no trunc(). So I have a workaround. But I'm curious why there'd be such a huge difference. Running just the BETWEEN piece by itself works fine. This is Oracle 8.1.6 on Solaris. I've tried indexing the transaction_date column both as transaction_date and trunc(transaction_date) but there's no difference. I've used both individual column indexes and combined with other WHERE clause columns used. One web site I found said there's an 8i bug creating functional indexes using trunc() but I have not verified that. I've started to analyze but SQL*Plus autotrace takes almost as long to return (7 hours) so it's not too useful at this point. Steve Sapovits Global Sports Interactive Work Email: [EMAIL PROTECTED] Home Email: [EMAIL PROTECTED] Work Phone: 610-491-7087 Cell: 610-574-7706 Pager: 877-239-4003 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steve Sapovits 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: Steve Sapovits 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:
RE: OT: Archiving not possible with SQL Server?
Bet you aren't an idiot: bet you're suffering from Microsoft-induced aphasia. I hate MS's habit of taking perfectly good industry vocabulary and making the words mean too-specific proprietary things. Works in MS's favor: helps the MSCEs makes the rest of the world feel like idiots! As far as the archiving, I curse both houses Oracle and Microsoft. On my old RDB (when it was Digital) database, I could take a reliable fast full backup any old time, and throw away any old backups that I'd created before. Not like Oracle where I have to quilt together old redo logs/datafiles or SQL Server where I have to keep all of the silly transaction logs to make any kind of reliable copy. Before you flame: yes I could quilt together RDB with the After-Image Journals, and I could take am Oracle backup with export/import or use a fancy Sql Server utility and have a semi-reliable backup. I'm only arguing that the scale of work associated with the task at hand seemed much more appropriate in RDB. 'Course RDB ran on proprietary operating system OOPS! start a new flame! -Original Message- Sent: Thursday, May 31, 2001 9:41 AM To: Multiple recipients of list ORACLE-L Yeah? But you know what? After few hours with SQL manual I'm starting to feel like an idiot. Supreme Council says: All Aboard MS SQL! Me says: Abandon Ship! Gary Weber Senior DBA Charles Jones, LLC 609-530-1144, ext 5529 -Original Message- Patrice J Sent: Thursday, May 31, 2001 7:35 AM To: Multiple recipients of list ORACLE-L Jared is having a bad day. : ) Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- From: Jared Still [SMTP:[EMAIL PROTECTED]] Sent: Thursday, May 31, 2001 3:51 AM To: Multiple recipients of list ORACLE-L Subject:Re: OT: Archiving not possible with SQL Server? Are you an idiot? Jared On Wednesday 30 May 2001 14:55, Gary Weber wrote: Guess what happens when a long running transaction marks the log near the end, and not too long afterward the log needs truncated? If memory serves, ( hasn't worked too well lately :) the database will hang. It may just truncate back to the mark, and start from there, but you always have the possibility of another long transaction starting. HELP -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gary Weber 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: Shreter, Hilary 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: what's hash-join
Title: RE: what's hash-join Hi Kevin, It's quick if you have the temp space to support it. however with larger tables my experience has been that it blows temp, isn't that much faster even if you do have the temp space, and in most cases you are better off with index-driven nested loops join. It works well with small to medium-sized tables. Just my .02 List, if I'm wrong, please correct me. Lisa Koivu Oracle Database Administrator 954-935-4117 The information in the electronic mail message is Cendant confidential and may be legally privileged, it is intended solely for the addressee(s) access to this internet electronic mail message by anyone else is unauthorized. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it is prohibited and may be unlawful. The sender believes that this E-mail and any attachments were free of any virus, worm, Trojan horse, and/or malicious code when sent. This message and its attachments could have been infected during transmission. By reading the message and opening any attachments, the recipient accepts full responsibility for taking protective and remedial action about viruses and other defects. Cendant Corporation or Affiliates are not liable for any loss or damage arising in any way from this message or its attachments. -Original Message- From: Kevin Kostyszyn [SMTP:[EMAIL PROTECTED]] Sent: Thursday, May 31, 2001 9:34 AM To: Multiple recipients of list ORACLE-L Subject: RE: what's hash-join What's the performance (gain/loss) on such a join, when would you want to use one? Kev -Original Message- McDonald Sent: Thursday, May 31, 2001 6:00 AM To: Multiple recipients of list ORACLE-L A method of joining two tables. You scan each and use a hashing algorithm to isolate/match keys. hth connor --- Senthil Ganapathi [EMAIL PROTECTED] wrote: Hi Rukmini could tell me what's that hash-join GSK Rukmini Devi To: Multiple recipients of list ORACLE-L rukmini@indb [EMAIL PROTECTED] rain.com cc: Sent by: Subject: Re: 4 join methods? root@fatcity. com 31-05-01 09:55 AM Please respond to ORACLE-L 1. Equi-join 2. Self-join 3. Outer-join 4. Hash-join rukmini - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, May 31, 2001 11:20 AM i feel the fourth one is self join. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, May 31, 2001 8:10 AM Hi, I just read there are four join methods. I know three: Nested loops Sort merge Hash join What's the fourth? - Greg -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Moore 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: Saurabh Sharma 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: Rukmini Devi 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: Senthil Ganapathi INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public
Re: SQL*LOADER problem
Thanks Diana for letting me know about the replace function. A little more research and my problem was solved. Satish IyerDBACCSS Team 684-3016 [EMAIL PROTECTED] 05/30/01 07:50PM Satish,You can do a couple of things...in the query you could to areplace(column1, chr(10), '~') (or some other unlikely character orstring), then do a replace again in the SQL*Loader script to get thecarriage returns back in there. Or you could use the query to put acharacter in the front of each true record, something likeselect '#' || col1, col2, col3, and then use the SQL*Loader commands for concatenating records. Can'tremember offhand how that one works, though...HTH,Diana DuncanTITAN Technology PartnersOne Copley Parkway, Ste 540Morrisville, NC 27560VM: 919.466.7337 x 316F: 919.466.7427E: [EMAIL PROTECTED] "Satish Iyer" [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] tle.wa.us cc: Sent by: Fax to: [EMAIL PROTECTED] Subject: SQL*LOADER problem 05/30/2001 08:05 PM Please respond to ORACLE-L Hi everyone.Having this typical problem with sql*loader. I am extracting data out froma table and this table has a field in which users have put in a new linefeed character. Now when I extract the data out using SQL*PLUS itobviously has a problemeg.1 First line of stt 2333232 Second line2 Full line 23232323 Again a partial 2323232 line.Now if such a table was extracted to a txt file, the sqlldr runs into aproblem of getting the second half of the line as expected. Any ideas howthis could be avoided ?Hope I explained that okay.Satish IyerDBACCSS Team 684-3016-- 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-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
RE: How to encrypt Password in Export script file ?
I also did this on all my databases - works very slick. Julie Fisher Sandia National Laboratories Oracle 8i DBA - OCP8i Solaris 2.6,7/HP-UX 11.0 System Administrator Web Server Administrator -Original Message- Sent: May 31, 2001 7:20 AM To: Multiple recipients of list ORACLE-L instead of that, I create an account in the database that is identified externally (can only run from that server, and does not have a login password). You will need a matching Unix account for it, if the unix account is exportacct then create the database account as ops$exportacct grant this account create session and exp_full_database then change your shell script to read userid=/ and run the script from the exportacct account this way you don't need to hardcode a password ANYWHERE Rachel From: CHAN Chor Ling Catherine (CSC) [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: How to encrypt Password in Export script file ? Date: Thu, 31 May 2001 00:50:22 -0800 Hi Unix Gurus, My daily export file (daily_exp.sh) contains : exp userid='system/password' file=file_name.dmp grants=y rows=y constraints=y compress=y full=y inctype=complete log=file_name.log The system password is stated clearly in the export script file. Has anyone encrypt/decrypt the system password before passing it as a variable to the export script ? If yes, could I have a copy of your script ? Thanks. Regds, New Bee in Unix -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: CHAN Chor Ling Catherine (CSC) 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 -- 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: Fisher, Julie 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: Rebuilding indexes
You might be mistaken, since Oracle Manual (Oracle 8.1.5 Backup and Recovery) , chapter 16 -- Managing a standby database --- Adding Datafiles states the following: Adding a datafile to your primary database generates redo data that, when applied at your standby, automatically adds the datafile name to the standby control file. There is also a detailed example on how to do it -Original Message- From: Richard Huntley [SMTP:[EMAIL PROTECTED]] Sent: Thursday, May 31, 2001 16:01 To: Multiple recipients of list ORACLE-L Subject: Rebuilding indexes For those of you that have implemented a standby database, what method do you use to rebuild your indexes tablespace. My plan was to create a new tablespace and rebuild the indexes into the new tablespace and then reverse the process to move back to the original tablespace after I drop and recreate it in order to get rid of fragmentation in the originally indexes tablespace. However, creating the new datafile associated with the new tablespace, cancels media recovery associated with the standby database...just wondered if anyone has a better method of defragging an index tablespace when there is a standby database catching the redo it generates. TIA, Richard Huntley -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Richard Huntley 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: Hatzistavrou Giannis 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: querry..
Saurabh, If you know your exact conditions and they don't change, you can write a select statement representing each combination and finally have a 'union' of all your sqls. HTH Prakash -Original Message- Sent: Thursday, May 31, 2001 4:50 AM To: Multiple recipients of list ORACLE-L hi list, how can i select two columns from a table based on condition that they are selected in specified combinations. let me.. table 1 has 2 columns col1, col2. both cols have values , say, alphabets. a,b,c,d,e,f,... i'want to select like FOR VALUE OF COL1 IN A, col2 must fetch only between A-E for value of col1 in B, col2 must be between A-X -- and so on.. i want to define this combination, so i should get only these pair of values. any suggestions. thanks. saurabh -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bala, Prakash 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).
Listener problems
Has anybody come across the following error message in the listener.log, and know what the resolution is. TNS-12500: TNS:listener failed to start a dedicated server process TNS-12540: TNS:internal limit restriction exceeded TNS-12560: TNS:protocol adapter error TNS-00510: Internal limit restriction exceeded Solaris Error: 12: Not enough space What is this Solaris Error 12? I have nothing set in the listener.ora or sqlnet.ora (in fact this dosn't even exist) files. 8.1.7 on Solaris 5.6 regards Zabair _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: zabair ahmed 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).
Suggestions on SCSI
Hi all, Just thought I would throw this one out there and see what all of you hot shots think. I am going to rebuild a server into a DB Server. Currently it has IDE drives in there and obviously I am not going to be using those. So I need to invest in some new SCSI drives. Here's what I had in mind: Either 4 X 9.2 Gig 10K RPM with 2mb Cache OR 4 X 18.4 GIG 10K with 4MB cache I was initially leaning towards the 9 gigs to save on cost, however someone pointed out that 18 would be a better idea for growth down the line. Also I want to keep them all of the same size in case one goes down then I may have room on another. What are your thoughts on this? Does anyone know what ultra fibre scsi means? Does anyone recommend brands to stear clear of? I know that Seagate is a pretty good name, but I can't find any in Ultra 2? Anyone know if Hitachi is a good name? Thanks in advance. Sincerely, Kevin Kostyszyn DBA Dulcian, Inc www.dulcian.com [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Kostyszyn 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).
LOGON TRIGGER
Hi, all we are using Oracle 8.1.7 and WebSphere on Solaris. We use a connection pool that allows 20 sessions from the app server to the database. In order to prevent anyone to connect to the datebase other than the app server, we would like to implement a security feature based on a LOGON TRIGGER that checks (client IP, application, etc.) and counts the active sessions. After 20 sessions have logged in, we want to issue an 'ALTER SYSTEM ENABLE RESTRICTED SESSION' to lock out any additional connection requests . Any comments on this? TIA, Dieter -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Buecherl Dieter (BUE) 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).
problem with trunc()
I have a query that contains these lines as part of the WHERE clause: WHERE trunc(it.transaction_date) = to_date('May-19-2001', 'Mon-dd-') This works fine -- the query returns in about a minute, which is what I'd expect for the table sizes, the rest of the joins, etc. Changing to the following causes the time to go to about 7 hours! WHERE trunc(it.transaction_date) BETWEEN to_date('May-19-2001', 'Mon-dd-') AND to_date('May-28-2001', 'Mon-dd-') Changing the BETWEEN to = AND = gives the same long results. What makes it go back to normal is dropping the trunc(), or otherwise rewriting it so there is no trunc(). So I have a workaround. But I'm curious why there'd be such a huge difference. Running just the BETWEEN piece by itself works fine. This is Oracle 8.1.6 on Solaris. I've tried indexing the transaction_date column both as transaction_date and trunc(transaction_date) but there's no difference. I've used both individual column indexes and combined with other WHERE clause columns used. One web site I found said there's an 8i bug creating functional indexes using trunc() but I have not verified that. I've started to analyze but SQL*Plus autotrace takes almost as long to return (7 hours) so it's not too useful at this point. Steve Sapovits Global Sports Interactive Work Email: [EMAIL PROTECTED] Home Email: [EMAIL PROTECTED] Work Phone: 610-491-7087 Cell: 610-574-7706 Pager: 877-239-4003 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steve Sapovits 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: Oracle Applications
Finding Oracle DBAs with 4 years experience is tough enough...forget about 4 years experience with Apps!! Ed Haskins Oracle DBA Verizon Wireless -Original Message- Sent: Thursday, May 31, 2001 10:51 AM To: Multiple recipients of list ORACLE-L Still no response from Oracle Canada, I left a message again - they didn't know what to do when people order CD Packs... Meanwhile I saw on the 'net a job posting that had as one of the competency requirements: 4 years experience with Oracle Applications. I guess this is supposed to be funny. : ) Patrice Boivin Systems Analyst (Oracle Certified DBA) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Haskins, Ed 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: Auto Extend
If the system is not setup to allow files bigger than 2 GB then the datafiles WILL NOT EXTEND and you will get an oracle error. -Original Message- Sent: Thursday, May 31, 2001 9:31 AM To: Multiple recipients of list ORACLE-L I have taken over an Oracle database that is setup with autoextend on the tablespaces. Can anyone tell me what happens when the datafiles extend beyond 2G on Unix? . -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Lange 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: Rebuilding indexes
there IS no way to do that with a standby database. Once you open it for anything other than read-only (8i) you invalidate the standby status. From: Richard Huntley [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Rebuilding indexes Date: Thu, 31 May 2001 06:00:56 -0800 For those of you that have implemented a standby database, what method do you use to rebuild your indexes tablespace. My plan was to create a new tablespace and rebuild the indexes into the new tablespace and then reverse the process to move back to the original tablespace after I drop and recreate it in order to get rid of fragmentation in the originally indexes tablespace. However, creating the new datafile associated with the new tablespace, cancels media recovery associated with the standby database...just wondered if anyone has a better method of defragging an index tablespace when there is a standby database catching the redo it generates. TIA, Richard Huntley -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Richard Huntley 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 -- 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).
Urgent: PL/SQL lock timer event
Hi, I need urgent assistance is resolving issues with PL/SQL lock timer. My query is waiting on this event more than an hour. waited duration is incrementing when I query v$session_wait. Do you know what this PL/SQL lock timer event is? why my query is waiting on this event for so long? How do resolve this? We are on v7.3.4.5.0 on HP-UX 11.0 Your help is appreciated. 132672 PL/SQL lock timer duration300 012C 0 00 0 00 301 2555 WAITED KNOWN TIME Thanks Sandesh -Original Message- Sent: Thursday, May 31, 2001 10:31 AM To: Multiple recipients of list ORACLE-L No doubt Novell at the time was more stable than NT at the time. But some of these stories, which can start off as My Novell box seems more stable than that NT 3.51 SP 1 box mutate into internet apocrypha faster than you can spell telephone. Before you know it, it's a heartlung machine, coded in assembler, running on a Novell beta release cross compiled to the Kaypro, which has been up, even through tornadoes, for 22 years. Meanwhile, the NT box crashed on boot up, then corrupted the disk, sold the house, and slept with my wife. I always ask for details. Two reasons. The first is to take a litmus test for veracity. The other is (assuming veracity) to learn something about how to make systems stable. shrug || -Original Message- || From: Eric D. Pierce [mailto:[EMAIL PROTECTED]] || Sent: Wednesday, May 30, 2001 5:48 PM || To: Multiple recipients of list ORACLE-L || Subject: RE: backspace in Oracle. || || || that would be if the stupid (HELP) data janitor remembers to do || VREPAIR once every other month or so. sometime the stupid data || janitor forgets and only does it once a year (with no other || downtime). || || in other words, except for occasional/normal piddly maintenance || (which is not otherwise required to keep the system up), netware3x || will not typically experience the same thing as the (supposedly) || infamous NT reboots. || || ??? || || ep || || On 30 May 2001, at 13:10, Mohan, Ross wrote: || || Date sent: Wed, 30 May 2001 13:10:37 -0800 || To: Multiple recipients of list ORACLE-L || [EMAIL PROTECTED] || || I am all for NLMs, DLMs, and MM. || || But, if you let me bounce most any NT box || once a month for, say, a DEFRAG, I'll be || able to keep it up for one helluva long || time too. || || Ross NMN Mohan || || || -Original Message- || || From: Eric D. Pierce [mailto:[EMAIL PROTECTED]] || || Sent: Wednesday, May 30, 2001 4:03 PM || || To: Multiple recipients of list ORACLE-L || || Subject: RE: backspace in Oracle. || || ... || || || Only reason for downtime is running VREPAIR (rough || equivalent of || || scandisk) about once every other month, and also when || the startup || || files need maintenance (usually related to changed || parameters on || || .nlms loaded, versoin upgrades, etc) and a bounce is || required. also || || we recently had to put in a new UPS battery, which || required a down. || || ... || || || -- || Please see the official ORACLE-L FAQ: http://www.orafaq.com || -- || Author: Eric D. Pierce || INET: [EMAIL PROTECTED] || || Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 || San Diego, California-- Public Internet access / || Mailing Lists || || To REMOVE yourself from this mailing list, send an E-Mail message || to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in || the message BODY, include a line containing: UNSUB ORACLE-L || (or the name of mailing list you want to be removed from). You may || also send the HELP command for other information (like subscribing). || -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross 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: Naik, Sandesh S 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
starting seperate external procedure listener
If I have a seperate external procedure listener does it get automatically started when the database is started?. If not how can I ensure it is started when the database is started. John -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Dunn 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: Update Query
Hi, I'm on DIGEST, so I don't know if that's been answered already, or not. But anyhow, what about: update ( select t.field1 f, t.field2 v, d.field1 g, d.field2 w from testtable1 t, testtable2 d where t.id = d.id) set f = g, v = w HTH Dieter Buecherl From: Eric D. Pierce [EMAIL PROTECTED] Date: Wed, 30 May 2001 13:02:14 -0700 Subject: Re: Update Query ha, ha. you got bit by the null update thing too, I remember it well! :) except for maybe some newfangled oracle8 features, the ugly one is the traditional way the manual says to do it (iirc). I have many many scripts with that kind of code in them since we load mainframe datafiles into the local oracle apps, and do a lot of cross-table updates (non-normalized, but that is mostly ok since it is archive data). you *can* pretty it up a bit by using better formatting, e.g., update tablea a set ( a.firstname, a.lastname ) = ( select b.firstname, b.lastname from tableb b where b.id = a.id ) where a.id in ( select b2.id from tableb b2 ) / On 30 May 2001, at 11:56, CC Harvest wrote: Date sent: Wed, 30 May 2001 11:56:14 -0800 To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Seems like Oracle Doesn't have to the query like this: update tablea set firstname=tableb.firstname, lastname=tableb.lastname where tableb.id = tablea.id; I can have one, it works if it has a match for the two tables, otherwise the two columns updated to null: update tablea set (firstname,lastname) =(select firstname,lastname from tableb where tableb.id=tablea.id); Then the following one works, but very ugly: update tablea set (firstname,lastname) =(select firstname,lastname from tableb where tableb.id=tablea.id) where exists( select 'x' from tableb where tableb.id=tablea.id) ... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Buecherl Dieter (BUE) 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: 4 join methods?
There is certainly something new called an index join around in 8i. [EMAIL PROTECTED] wrote: I wonder if their thinking of the star join?? Dick Goulet Reply Separator Author: =?iso-8859-1?q?Connor=20McDonald?= [EMAIL PROTECTED] Date: 5/31/2001 5:00 AM And with all the hoopla that Oracle are spouting, I'm sure they'll be trying to convince us that (8i) partition wise join is a new type as well.. :-) Connor --- PD Miller [EMAIL PROTECTED] wrote: At 22:55 -0800 30/5/01, Rukmini Devi wrote: 1. Equi-join 2. Self-join 3. Outer-join 4. Hash-join Outer join is a logical type not an access method. the four types of join that Oracle can use: Nested Loops join Sort Merge join (equi-join only) Cluster join (equi-join on cluster key only) Hash join (equijoin, cost-based only) Regards Paul Miller -- - Carib Data Limited mailto:[EMAIL PROTECTED] http://www.caribdata.co.uk -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: PD Miller 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). = Connor McDonald http://www.oracledba.co.uk (mirrored at http://www.oradba.freeserve.co.uk) Some days you're the pigeon, some days you're the statue Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= 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). -- Venlig hilsen Mogens Nørgaard Technical Director Miracle A/S, Denmark Web: http://MiracleAS.dk Mobile: +45 2527 7100 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mogens =?iso-8859-1?Q?N=F8rgaard?= 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 send email from pl/sql in 806?
Saurabh; Have you looked at ALL of the packages involved ?? Does the SYS.UTL_TCP exist and does the ID using SEND_MAIL have the correct access to it ?? (I know these are basic questions, but its usually the basic ones that get us first !) Kevin -Original Message- Sent: Thursday, May 31, 2001 3:21 AM To: Multiple recipients of list ORACLE-L hi Jared, my execution cmd goes like.. EXECUTE SEND_MAIL('[EMAIL PROTECTED]','[EMAIL PROTECTED]','urgent','hello') it's giving the following error msgs.. ORA-04068: existing state of packages has been discarded ORA-04067: not executed, package body SYS.UTL_TCP does not exist ORA-06508: PL/SQL: could not find program unit being called ORA-06512: at SYS.SEND_MAIL, line 10 ORA-06512: at line 2 the package is shown as valid in dba_objects for sys. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, May 31, 2001 12:05 PM Your procedure is masking the error in the exception block. Comment out the exception block to see the real error. Jared On Wednesday 30 May 2001 22:18, you wrote: it gives other error msg which are defined in the exception body inside the procedure. here it goes.. EXCEPTION when others then raise_application_error(-2,'Unable to send e-mail message from pl/sql'); this msg is returned with ora 06512 any suggestions.. - Original Message - From: Jared Still [EMAIL PROTECTED] To: [EMAIL PROTECTED]; Saurabh Sharma [EMAIL PROTECTED] Sent: Wednesday, May 30, 2001 9:43 PM Subject: Re: How to send email from pl/sql in 806? On Wednesday 30 May 2001 03:10, Saurabh Sharma wrote: should i give it all four arguments. but it still not executing saying ora-06512 There are always other error messages accompanying an ORA-6512. What are they? Jared -- 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: Saurabh Sharma 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: Kevin Lange 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: problem with trunc()
I have always been told that using functions on fields would stop the efficient use of indexes so . what if you said WHERE it.transaction_date BETWEEN to_date('May-19-2001.00.00.00', 'Mon-dd-.hh24.mi.ss') AND to_date('May-28-2001.23.59.59', 'Mon-dd-') This would at least eliminate the Trunc and give you another possibility. Kevin -Original Message- Sent: Thursday, May 31, 2001 11:01 AM To: Multiple recipients of list ORACLE-L I have a query that contains these lines as part of the WHERE clause: WHERE trunc(it.transaction_date) = to_date('May-19-2001', 'Mon-dd-') This works fine -- the query returns in about a minute, which is what I'd expect for the table sizes, the rest of the joins, etc. Changing to the following causes the time to go to about 7 hours! WHERE trunc(it.transaction_date) BETWEEN to_date('May-19-2001', 'Mon-dd-') AND to_date('May-28-2001', 'Mon-dd-') Changing the BETWEEN to = AND = gives the same long results. What makes it go back to normal is dropping the trunc(), or otherwise rewriting it so there is no trunc(). So I have a workaround. But I'm curious why there'd be such a huge difference. Running just the BETWEEN piece by itself works fine. This is Oracle 8.1.6 on Solaris. I've tried indexing the transaction_date column both as transaction_date and trunc(transaction_date) but there's no difference. I've used both individual column indexes and combined with other WHERE clause columns used. One web site I found said there's an 8i bug creating functional indexes using trunc() but I have not verified that. I've started to analyze but SQL*Plus autotrace takes almost as long to return (7 hours) so it's not too useful at this point. Steve Sapovits Global Sports Interactive Work Email: [EMAIL PROTECTED] Home Email: [EMAIL PROTECTED] Work Phone: 610-491-7087 Cell: 610-574-7706 Pager: 877-239-4003 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steve Sapovits 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: Kevin Lange 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: Rebuilding indexes
Adding a datafile does not cancel recovery - you just need to 'pause' it, transport the appropriate files to the standby and resume standby operations. hth connor --- Richard Huntley [EMAIL PROTECTED] wrote: For those of you that have implemented a standby database, what method do you use to rebuild your indexes tablespace. My plan was to create a new tablespace and rebuild the indexes into the new tablespace and then reverse the process to move back to the original tablespace after I drop and recreate it in order to get rid of fragmentation in the originally indexes tablespace. However, creating the new datafile associated with the new tablespace, cancels media recovery associated with the standby database...just wondered if anyone has a better method of defragging an index tablespace when there is a standby database catching the redo it generates. TIA, Richard Huntley -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Richard Huntley 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). = Connor McDonald http://www.oracledba.co.uk (mirrored at http://www.oradba.freeserve.co.uk) Some days you're the pigeon, some days you're the statue Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= 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: problem with trunc()
You seem to have lost your sig. Are you no longer a 'Wanton Kickboxing Goddess'? ;-) Todd Carlson Oracle 8i Certified DBA Bunge North America -- 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).
Re: Auto Extend
Depends is the standard answer. Oracle can handle files over 2g, some unixes can, some unixes cannot, some say they can but cannot etc etc... To compound things, in some versions, Oracle will let the file go beyond 2g, only then to complain because the unix won't let Oracle get to the bits after 2G - thus corrupt db. Unless you're on raw, I'd recommend a ceiling of 2g on any datafile - just to be safe hth connor --- Smith, Ron L. [EMAIL PROTECTED] wrote: I have taken over an Oracle database that is setup with autoextend on the tablespaces. Can anyone tell me what happens when the datafiles extend beyond 2G on Unix? . -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Connor McDonald http://www.oracledba.co.uk (mirrored at http://www.oradba.freeserve.co.uk) Some days you're the pigeon, some days you're the statue Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: DB2 vs Oracle
I wouldn't mind a copy of that doc Mark? -Original Message- Sent: 31 May 2001 13:34 To: Multiple recipients of list ORACLE-L Hi people, A few weeks back somebody posted a message regarding an eval they are doing comparing Oracle/DB2/SQLServer. I came across a great document today for an Oracle/DB2 comparison, so if that person - sorry I can't remember who it was - is interested, contact me back channel, and I'll send it over to you. Regards Mark -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith 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). E mail Disclaimer You agree that you have read and understood this disclaimer and you agree to be bound by its terms. The information contained in this e-mail and any files transmitted with it (if any) are confidential and intended for the addressee only. If you have received this e-mail in error please notify the originator or telephone 0191 210 2060 or e-mail [EMAIL PROTECTED] This e-mail and any attachments have been scanned for certain viruses prior to sending but neither Northern Electric plc nor any of the companies in the Northern Electric group of companies from whom this e-mail originates shall be liable for any losses as a result of any viruses being passed on. No warranty of any kind is given in respect of any information contained in this e-mail and you should be aware that that it might be incomplete, out of date or incorrect. It is therefore essential that you verify all such information with us before placing any reliance upon it. Northern Electric plc Carliol House Market Street Newcastle-upon-Tyne NE1 6NE Registered in England and Wales: Number 2366942 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Garner, John (NESL-IT) 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: Unix File Open Port Open
The only I know of way to see which process has a port open in Solaris is to use lsof (there's a package on sunfreeware.com -- including source). netstat and /proc aren't enough as far as I can see... It's not clear what exactly you need to know, but hope this helps... Steve -Original Message- Sent: Wednesday, May 30, 2001 8:40 PM To: Multiple recipients of list ORACLE-L Hello, This is an off topic, UNIX question. Can any one please tell me how to get the Unix File Open and Port Open in SCO or AIX, or SUN? I am not sure whether they are part of sar output, so please help. I am not sure whether I can get this kind of information. thanks every one in advance. rgds, raja Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Viraj Luthra 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: Austin, Steve S 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: Listener problems
Out of space on the file system I believe. -Original Message- Sent: Thursday, May 31, 2001 11:16 AM To: Multiple recipients of list ORACLE-L Has anybody come across the following error message in the listener.log, and know what the resolution is. TNS-12500: TNS:listener failed to start a dedicated server process TNS-12540: TNS:internal limit restriction exceeded TNS-12560: TNS:protocol adapter error TNS-00510: Internal limit restriction exceeded Solaris Error: 12: Not enough space What is this Solaris Error 12? I have nothing set in the listener.ora or sqlnet.ora (in fact this dosn't even exist) files. 8.1.7 on Solaris 5.6 regards Zabair _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: zabair ahmed 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: Kevin Lange 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: Auto Extend
Hi, When using autoextend always set max size and monitor. Turn off auto extend if a small possibility exists to do so. Check if your OS has large file size enabled and there won't be any problems. jack Smith, Ron L. To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] [EMAIL PROTECTED] cc: (bcc: Jack van Zanen/nlzanen1/External/MEY/NL) om Subject: Auto Extend Sent by: [EMAIL PROTECTED] om 31-05-2001 16:31 Please respond to ORACLE-L I have taken over an Oracle database that is setup with autoextend on the tablespaces. Can anyone tell me what happens when the datafiles extend beyond 2G on Unix? . -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = De informatie verzonden in dit e-mailbericht is vertrouwelijk en is uitsluitend bestemd voor de geadresseerde. Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan derden is, behoudens voorafgaande schriftelijke toestemming van Ernst Young, niet toegestaan. Ernst Young staat niet in voor de juiste en volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch voor tijdige ontvangst daarvan. Ernst Young kan niet garanderen dat een verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden. Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u vriendelijk doch dringend het e-mailbericht te retourneren aan de verzender en het origineel en eventuele kopieën te verwijderen en te vernietigen. Ernst Young hanteert bij de uitoefening van haar werkzaamheden algemene voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De algemene voorwaarden worden u op verzoek kosteloos toegezonden. = The information contained in this communication is confidential and is intended solely for the use of the individual or entity to whom it is addressed. You should not copy, disclose or distribute this communication without the authority of Ernst Young. Ernst Young is neither liable for the proper and complete transmission of the information contained in this communication nor for any delay in its receipt. Ernst Young does not guarantee that the integrity of this communication has been maintained nor that the communication is free of viruses, interceptions or interference. If you are not the intended recipient of this communication please return the communication to the sender and delete and destroy all copies. In carrying out its engagements, Ernst Young applies general terms and conditions, which contain a clause that limits its liability. A copy of these terms and conditions is available on
RE: lsnrctl question
On unix you can look for the process running the listener. In our shop this is done by : $ ps -ef | grep tnslsnr oracle 413 1 0 May 18 ?2:36 /u03/home/oracle/product/8.0.5/bin/tnslsnr listener.1526 -inherit oracle 447 1 0 May 18 ?0:08 /u03/home/oracle/product/8.0.5/bin/tnslsnr listener.1514 -inherit oracle 455 1 0 May 18 ?0:00 /u03/home/oracle/product/8.0.5/bin/tnslsnr external_procedure_listener -inherit oracle 13084 12853 0 11:45:32 pts/14 0:00 grep tnslsnr $ Note that each process has the listener name as a parameter. In this case the external procedure listener is simply external_procedure_listener You can then use this in the lsnrctl status external_procedure_listener command. Or, you can always look in your listener.ora file for the name of it. Kevin -Original Message- Sent: Thursday, May 31, 2001 10:46 AM To: Multiple recipients of list ORACLE-L If I want to know the status of the external procedure listener for the current SID, but do not know what the external procedure listener's name is, how can I use lsnrctl to find out it's status. John -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Dunn 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: Kevin Lange 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: what's hash-join
And it will skip partitions that it can see will not match any other corresponding partition. PD Miller wrote: At 0:16 -0800 31/5/01, Senthil Ganapathi wrote: could tell me what's that hash-join Straight from the concepts manual: To perform a hash join, Oracle follows these steps: 1. Oracle performs a full table scan on each of the tables and splits each into as many partitions as possible based on the available memory. 2. Oracle builds a hash table from one of the partitions (if possible, Oracle will select a partition that fits into available memory). Oracle then uses the corresponding partition in the other table to probe the hash table. All partition pairs that do not fit into memory are placed onto disk. 3. For each pair of partitions (one from each table), Oracle uses the smaller one to build a hash table and the larger one to probe the hash table. Or to paraphrase: load each table into a set of hash partitions based on the equi-join predicate. Use the smaller hash partition hash values to find the matches in the larger.RegardsPaul Miller -- - Carib Data Limited mailto:[EMAIL PROTECTED]> http://www.caribdata.co.uk> -- Venlig hilsen Mogens Nrgaard Technical Director Miracle A/S, Denmark Web: http://MiracleAS.dk Mobile: +45 2527 7100