Point-In-Time recovery question, Non-RMAN solution
Hi DBAs, Oracle 8i, ArchiveLog, No RMAN Testing Point-In-Time Recovery I am confused on what time to substitute in the RECOVER DATABASE UNTIL TIME 'timestamp'; For example 2 days ago 11/04/2003 approximately 17:00 I drop a table. Today I decide I want that table back. I want to do an incomplete recovery to get the table back. How do I know what timestamp to use? I have an idea the I dropped the table but not exact. 1. SHUTDOWN Normal 2. BACKUP current database 3. Restore datafile that has the table in it. 4. connect internal 5. startup mount 6. recover database until time 'timestamp??'; 7. Alter database open resetlogs; 8. BACKUP current database Step 5 is my confusion. Also I assume all data is now lost since last archive restored to the present. The only way I know to get that data back is to 1. Export the table that was dropped. 2. Restore database from step2 3. Import table from step1 Is there better ways. Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Point-In-Time recovery question, Non-RMAN solution
How was the timestamp derived prior to logminer as Point-In-Time recovery has been around a long time? Thanks Rick Scott Canaan [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED]Subject: RE: Point-In-Time recovery question, Non-RMAN solution .com 11/06/2003 10:09 AM Please respond to ORACLE-L Have you looked into using logminer? Even if it can't restore your table, it can give you the exact time that it was dropped. Scott Canaan ([EMAIL PROTECTED]) (585) 475-7886 Life is like a sewer, what you get out of it depends on what you put into it. - Tom Lehrer. -Original Message- Sent: Thursday, November 06, 2003 8:45 AM To: Multiple recipients of list ORACLE-L Hi DBAs, Oracle 8i, ArchiveLog, No RMAN Testing Point-In-Time Recovery I am confused on what time to substitute in the RECOVER DATABASE UNTIL TIME 'timestamp'; For example 2 days ago 11/04/2003 approximately 17:00 I drop a table. Today I decide I want that table back. I want to do an incomplete recovery to get the table back. How do I know what timestamp to use? I have an idea the I dropped the table but not exact. 1. SHUTDOWN Normal 2. BACKUP current database 3. Restore datafile that has the table in it. 4. connect internal 5. startup mount 6. recover database until time 'timestamp??'; 7. Alter database open resetlogs; 8. BACKUP current database Step 5 is my confusion. Also I assume all data is now lost since last archive restored to the present. The only way I know to get that data back is to 1. Export the table that was dropped. 2. Restore database from step2 3. Import table from step1 Is there better ways. Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Scott Canaan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself
Who is using temp tablespace?
Hi All, How can I determine who is using temp tablespace? I have a 1 gb tablespace and it is almost full. I want to know who and what sql is using most of it. Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Datatype conversions
INSERT INTO new_table(price) SELECT REPLACE(price, ',' ,'.') FROM old_table; Rick Mladen Gogala [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] ng.com cc: Sent by: Subject: Re: Datatype conversions [EMAIL PROTECTED] .com 11/03/2003 08:54 AM Please respond to ORACLE-L Can you re-post this question several more times? We didn't get it yet. Thanks in advance for your understanding. On 11/03/2003 07:29:40 AM, [EMAIL PROTECTED] wrote: Hallo, Maybe this sounds simple for all of you, but I have a table with the field PRICE and that is with datatype varchar2 I want the data in that field to be inserted in another table with field PRICE, but that field has the datatype NUMBER. How can I easiest do this sql statement? In the varchar2(30) field PRICE , table1 it looks like this PRICE 12,50 37,50 The datype in table 2 is for that field NUMBER(7,2) Roland -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author:
Enterprise Manager Console create report utility stops after 3%
Hi DBAs, Oracle 9.2.0.1 Win 2000 In Enterprise Console there is an option to produce a report on either 1 Database Configuration Report or 2. Database Status Report. When I choose either on I always get 3% complete and amount of time thusfar just keeps going. I never get a report and never goes higter than 3% complete. Any ideas why report will not complete. Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
How to trace 3rd party app
Hi DBAs, How can I trace a 3rd party app that produces a ora-3113 error? I am looking into dbms_support package but I am not sure what trace event and level it does. Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: How to trace 3rd party app
Dennis, The dot net app is on a remote server. I will search MetaLink. Thanks Rick DENNIS WILLIAMS [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] uch.com cc: Sent by: Subject: RE: How to trace 3rd party app [EMAIL PROTECTED] .com 10/23/2003 12:24 PM Please respond to ORACLE-L Rick - What is the configuration? Is the app on the same server or remote across SQL*Net? Metalink has a pretty good paper on the basics of debugging an ORA-3113. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, October 23, 2003 10:30 AM To: Multiple recipients of list ORACLE-L Hi DBAs, How can I trace a 3rd party app that produces a ora-3113 error? I am looking into dbms_support package but I am not sure what trace event and level it does. Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Using ' in Update statement
Ahhh!!! there is no elite and the question was trivial. The great and powerful has spoken, perhaps all questions should be filtered your way for classification. I can assure nothing on this forum is worthy of becoming Testy, merely trying to provide a solution for someone who needed help and of course one must stand their ground when necessary. Mladen Gogala [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] ng.com cc: Sent by: Subject: RE: Using ' in Update statement [EMAIL PROTECTED] .com 10/10/2003 10:19 AM Please respond to ORACLE-L There is no elite here, but this was a trivial question which I answered by listing manuals in which the answer could be found. I was asked for clarification of my reply, so I provided the clarification. No need to get testy about it. On Fri, 2003-10-10 at 08:54, Mercadante, Thomas F wrote: Naaa. He's an equal opportunity ball-buster. -Original Message- Sent: Thursday, October 09, 2003 5:54 PM To: Multiple recipients of list ORACLE-L Hamid started his question How can I user comma ' in my update statement? I am merely correcting his mistake and then providing a solution. Wow, what a concept on a Oracle Listserv site design for that very purpose. Just curious, Would you have answered in the same way if it had been asked by one of the elite? Mladen Gogala [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] ng.com cc: Sent by: Subject: Re: Using ' in Update statement [EMAIL PROTECTED] .com 10/09/2003 05:09 PM Please respond to ORACLE-L I didn't mean quote, I meant RTFM. On Thu, 2003-10-09 at 16:34, [EMAIL PROTECTED] wrote: I assume you mean quote update tablea set fielda =' james'ste Camp 'first,'sec' ' update tablea set fielda =' james''ste Camp ''first,''sec'' '; Just use 2 single quotes Mladen Gogala [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] ng.com cc: Sent by: Subject: Re: Using ' in Update statement [EMAIL PROTECTED] .com 10/09/2003 02:29 PM Please respond to ORACLE-L It's in the documentation. Start with the concepts manual, then SQL*Plus manual and SQL reference. I'm sure that you'll run across the answer because that's where I have found the answer to the very same question. On Thu, 2003-10-09 at 13:59, Hamid Alavi wrote: List, How can I user comma ' in my update statement? update tablea set fielda =' james'ste Camp 'first,'sec' ' Thanks, Hamid Alavi Office
Re: Using ' in Update statement
I assume you mean quote update tablea set fielda =' james'ste Camp 'first,'sec' ' update tablea set fielda =' james''ste Camp ''first,''sec'' '; Just use 2 single quotes Mladen Gogala [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] ng.com cc: Sent by: Subject: Re: Using ' in Update statement [EMAIL PROTECTED] .com 10/09/2003 02:29 PM Please respond to ORACLE-L It's in the documentation. Start with the concepts manual, then SQL*Plus manual and SQL reference. I'm sure that you'll run across the answer because that's where I have found the answer to the very same question. On Thu, 2003-10-09 at 13:59, Hamid Alavi wrote: List, How can I user comma ' in my update statement? update tablea set fielda =' james'ste Camp 'first,'sec' ' Thanks, Hamid Alavi Office : 818-737-0526 Cell phone : 818-416-5095 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Using ' in Update statement
Hamid started his question How can I user comma ' in my update statement? I am merely correcting his mistake and then providing a solution. Wow, what a concept on a Oracle Listserv site design for that very purpose. Just curious, Would you have answered in the same way if it had been asked by one of the elite? Mladen Gogala [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] ng.com cc: Sent by: Subject: Re: Using ' in Update statement [EMAIL PROTECTED] .com 10/09/2003 05:09 PM Please respond to ORACLE-L I didn't mean quote, I meant RTFM. On Thu, 2003-10-09 at 16:34, [EMAIL PROTECTED] wrote: I assume you mean quote update tablea set fielda =' james'ste Camp 'first,'sec' ' update tablea set fielda =' james''ste Camp ''first,''sec'' '; Just use 2 single quotes Mladen Gogala [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] ng.com cc: Sent by: Subject: Re: Using ' in Update statement [EMAIL PROTECTED] .com 10/09/2003 02:29 PM Please respond to ORACLE-L It's in the documentation. Start with the concepts manual, then SQL*Plus manual and SQL reference. I'm sure that you'll run across the answer because that's where I have found the answer to the very same question. On Thu, 2003-10-09 at 13:59, Hamid Alavi wrote: List, How can I user comma ' in my update statement? update tablea set fielda =' james'ste Camp 'first,'sec' ' Thanks, Hamid Alavi Office : 818-737-0526 Cell phone : 818-416-5095 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Mladen Gogala Oracle DBA Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail
Any known problems with installing new MS patch on Oracle server
Hi All, Has anyone heard of any known gotchas with installing the latest MS patch on Oracle server? Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Oracle 9iAS form displays gray box
Hi NT 2000 Oracle 9.0.2.0.1 Oracle 9ias 9.0.2.0.1 Installed infrastructure and tested ok Installed middle tier and tested ok When I was testing the forms services from demo tab to test running the demo form it shows form services installed successfully. When I hit ok it is trying to load another form but all I get is a gray box. I also tried this on my local machine where I have 9i dev installed to test with another form and I get a gray box. Jinitiator and OC4J listener are running on local to test 9i development install Any one have any suggestions. Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
OT: Oracle 9iOAS install help needed
Hi All, I am trying to install Oracle 9iAS on Win 2000 I installed Infra structure successfully. While trying to install next component OAS with BI/Forms I get a message Existing Oracle9iOAS Single Sign-On. Enter hostname and port number of existing Single Sign-On. Heck I do not know if it installed. I assume it is since infrastructure is installed. Obviously I am a first timer in OAS. I have about 300 pages of documentation but I can find nothing to troubleshoot. Does anyone have any experience they can share or URL's. Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle 9iOAS install help needed
Thanks for the reply. I already verified the correct port but no go. Thanks Rick Boivin, Patrice J To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] [EMAIL PROTECTED]cc: mpo.gc.ca Subject: RE: Oracle 9iOAS install help needed Sent by: [EMAIL PROTECTED] .com 09/09/2003 10:19 AM Please respond to ORACLE-L There is a ports.ini file somewhere in the infra and middle Oracle homes, they would tell you what port to use. Patrice. -Original Message- Sent: Tuesday, September 09, 2003 10:59 AM To: Multiple recipients of list ORACLE-L Hi All, I am trying to install Oracle 9iAS on Win 2000 I installed Infra structure successfully. While trying to install next component OAS with BI/Forms I get a message Existing Oracle9iOAS Single Sign-On. Enter hostname and port number of existing Single Sign-On. Heck I do not know if it installed. I assume it is since infrastructure is installed. Obviously I am a first timer in OAS. I have about 300 pages of documentation but I can find nothing to troubleshoot. Does anyone have any experience they can share or URL's. Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: C program won't run in 9.0.2.3
Ruth, Just to be clear you are pre-compiling(not compiling) under 9.0.2.3 and compiling with same C compiler then linking with new 9.0.2.3 libraties. OS is the same. Obviously the contents of sqlca.sqlcode memory location is getting stomped on as 1093480496 is garbage. I would not think the sqlca data structure would change. I am assuming the code below is immediately following your EXEC SQL statement. Are you doing any select...into where you may be getting a buffer overflow. I know this is code that is probably unchanged and you just want to precompile/compile/link in new Oracle environment, these are very hard to find. Rick Ruth Gramolini [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] tate.vt.us cc: Sent by: Subject: C program won't run in 9.0.2.3 [EMAIL PROTECTED] .com 08/29/2003 10:31 AM Please respond to ORACLE-L Good morning, We are trying to run a C program that runs on 8.0.6.3 after compiling it under 9.0.2.3 and we cannot get it to run. Does anyone know of any changes to the C interface with Oracle 9i that we should be aware of? The it errors out everytime when it tries to write an error message with the following lines: if ( sqlca.sqlcode != SQL_NO_ERROR ) { if (sqlca.sqlcode == SQL_NOT_FOUND ) return(-1) ; else { LogError_v(SQL ERROR (%d) : [%s]\n , sqlca.sqlcode, sqlca.sqlerrm.sqlerrmc) ; return(-1) ; and the SQL Error is: SQL ERROR (1093480496) : [0: no data but there is data. Any help would be greatly appreciated Thanks in advance, Ruth Gramolini Oracle DBA Vermont Department of Taxes -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
OT: DataType mapping between Oracle and SQL Server
Can someone post a URL or other reference where I can get a 1-1 mapping where applicable of all Oracle datatypes to SQL Server. Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: What is _NEXT_OBJECT
According to MetaLink _NEXT_OBJECT is a hidden entry in obj$ which determines the next object id to be created. It shouldn't be seen in DBA_OBJECTS. The fact that it is seen in ALL/USER_OBJECTS is a bug, 691329 fixed in 8.1.7. It will not harm anything. Rick Rudy Zung [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] com cc: Sent by: Subject: What is _NEXT_OBJECT [EMAIL PROTECTED] .com 08/18/2003 02:49 PM Please respond to ORACLE-L I recently had to install a couple of things to my 817 database so that I could get UTL_SMTP. I ran ORACLE\javavm\install\initjvm.sql and ORACLE\rdbms\admin\initplsj.sql as SYS and then followed up by use ALTER objectType to recompile all invalid objects. The only thing I have left is a object of name _NEXT_OBJECT of the type NEXT OBJECT, which has an N/A status. Googling for this gave me http://www.experts-exchange.com/Databases/Oracle/Q_20082312.html which was someone who was having some problems with his database and his _NEXT_OBJECT. I, however, don't seem to be suffering any visible ill-effects so far. What is this thing, and how do I fix it (and I don't really want to do a re-imprt per the experts-exchange web page.) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rudy Zung INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San
RE: Analytical Functions
I think it is only available in EE not SE Rick Hatzistavrou John [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] .tellas.gr cc: Sent by:Subject: RE: Analytical Functions [EMAIL PROTECTED] 08/12/2003 03:44 AM Please respond to ORACLE-L Part of the standard sql as was in 8i Kind Regards, Hatzistavrou Yannis Database Administrator SchlumbergerSema Phone ext. 478 Email: [EMAIL PROTECTED] -Original Message- Sent: Tuesday, August 12, 2003 9:59 AM To: Multiple recipients of list ORACLE-L Hi Can anyone tell me if the Analytical functions as shown in the extracted piece of SQL using the OVER clause are part of standard 9i SQL or is it part of the OLAP engine. What i want to know is do I need OLAP installed to use these functions SELECT last_name, hire_date, salary, LAG(salary, 1, 0) OVER (ORDER BY hire_date) AS prev_sal FROM employees WHERE job_id = 'PU_CLERK'; Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = If people did not sometimes do silly things, nothing intelligent would ever get done. - Ludwig Wittgenstein = Mincom The People, The Experience, The Vision = This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hatzistavrou John INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services
RE: ora-600 when analyzing IOT
Igor, When you gather statistics on an IOT with the ANALYZE command, it will analyze the primary key and overflow segment so I would think this is all that is required by CBO. Hopefully others have more insight. Rick Igor Neyman [EMAIL PROTECTED]To: [EMAIL PROTECTED] on.com cc: [EMAIL PROTECTED] Subject: RE: ora-600 when analyzing IOT 08/07/2003 12:13 PM Rick, Thanks for prompt reply. I tried it (deleting statistics before analyzing table) and it worked. Any ideas, whether cost-based optimizer need statistics on IOT or having statistics on PK index of IOT would be enough? Igor Neyman, OCP DBA [EMAIL PROTECTED] -Original Message- [EMAIL PROTECTED] Sent: Thursday, August 07, 2003 12:04 PM To: Multiple recipients of list ORACLE-L According to MetaLink you need to delete statistics and re-analyze I do not know your database version but this is supposely fixed in 8.1.6 execute dbms_stats.delete_table_stats('owner','IPN_MEASUREMENT'); analyze table ipn_measurement estimate statistics ; HTH Rick Igor Neyman [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] on.com cc: Sent by: Subject: ora-600 when analyzing IOT [EMAIL PROTECTED] .com 08/07/2003 12:44 PM Please respond to ORACLE-L Ok, since my original message still hasn't arrived (sent couple hours ago), here it goes again (sorry, if you get duplicate). First, sorry for asking this list before searching Metalink, but I don't have access to it right now. So, here it is: I'm getting: ORA-00600: internal error code, arguments: [15163], [333], [17424], [16191], [], [], [], [] when analyzing one of the index-organized tables: ANALYZE TABLE ipn_measurement ESTIMATE STATISTICS. Now, similar statement analyzing other IOTs works fine. Also, on the same table (ipn_measurement) analyze worked fine yesterday, and the table didn't grew too much since yesterday. Any ideas? Another question, do I really have to run analyze table on IOT for cost-based optimizer, or analyzing index would be enough: ANALYZE INDEX pk_ipn_measurement ESTIMATE STATISTICS because analyze index still runs with no errors. Oracle version is 8.1.5. Igor Neyman, OCP DBA [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Igor Neyman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051
Re: ora-600 when analyzing IOT
According to MetaLink you need to delete statistics and re-analyze I do not know your database version but this is supposely fixed in 8.1.6 execute dbms_stats.delete_table_stats('owner','IPN_MEASUREMENT'); analyze table ipn_measurement estimate statistics ; HTH Rick Igor Neyman [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] on.com cc: Sent by: Subject: ora-600 when analyzing IOT [EMAIL PROTECTED] .com 08/07/2003 12:44 PM Please respond to ORACLE-L Ok, since my original message still hasn't arrived (sent couple hours ago), here it goes again (sorry, if you get duplicate). First, sorry for asking this list before searching Metalink, but I don't have access to it right now. So, here it is: I'm getting: ORA-00600: internal error code, arguments: [15163], [333], [17424], [16191], [], [], [], [] when analyzing one of the index-organized tables: ANALYZE TABLE ipn_measurement ESTIMATE STATISTICS. Now, similar statement analyzing other IOTs works fine. Also, on the same table (ipn_measurement) analyze worked fine yesterday, and the table didn't grew too much since yesterday. Any ideas? Another question, do I really have to run analyze table on IOT for cost-based optimizer, or analyzing index would be enough: ANALYZE INDEX pk_ipn_measurement ESTIMATE STATISTICS because analyze index still runs with no errors. Oracle version is 8.1.5. Igor Neyman, OCP DBA [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Igor Neyman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT
Re: Antw: Take an Oracle 8.1 export file back to an Oracle 7.1
You could load the 7.1 exp on the 8.1 server and export then import on 7.1 server Rick |-+ | | Guido Konsolke | | | [EMAIL PROTECTED]| | | nkrupp.com | | | Sent by: [EMAIL PROTECTED] | | || | || | | 08/07/2003 01:34 PM | | | Please respond to ORACLE-L | | || |-+ --| | | | To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] | | cc: | | Subject: Antw: Take an Oracle 8.1 export file back to an Oracle 7.1 | --| Hi David, no, not possible to my knowledge. You have to use the 7.1 exp against the 8.1 server. That's what they all say. If anyone knows better, I would be glad to hear from him. Greetings, Guido [EMAIL PROTECTED] 07.08.2003 19.14 Uhr Hi all Is it possible to take an Oracle Version 8.1 database export file and load it into an Oracle Version 7.1 database? The export file of the 8.1 is on a different machine than the 7.1 database. If I can not is there some other method I can use to get the data from the 8.1 export file to the 7.1 database. Thanks David -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Guido Konsolke INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: License Question
Harvinder, You should call you Oracle sales rep. All pricing is negotiable depending on whether it is end-of-quarter, how close mars is in alignment with earth,etc. Also, always try to negotiate education credits,etc. I have found end-of-quarter is best, they all like that trip to Hawaii...seen it too many times. Rick DENNIS WILLIAMS [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] UCH.COM cc: Sent by: Subject: RE: License Question [EMAIL PROTECTED] .com 08/11/2003 04:04 PM Please respond to ORACLE-L Harvinder - I've never seen a price attached to the client. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, August 11, 2003 11:54 AM To: Multiple recipients of list ORACLE-L Hi, One of our client is using 8.1.7 database server. We have install 9.2 client version on one of application server to connect to database. Do the client have to buy oracle 9i client(or they need to buy complete 9i server edition) and does anyone know how much it cost for 1 license of oracle 9i client? Thanks --Harvinder -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Harvinder Singh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ora-600 when analyzing IOT
I am not sure but based on the definition of an IOT I would think you would have to ANALYZE TABLE since the primary key data is not duplicated in a separate index. Rick Igor Neyman [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] on.com cc: Sent by: Subject: RE: ora-600 when analyzing IOT [EMAIL PROTECTED] .com 08/07/2003 02:14 PM Please respond to ORACLE-L Does it mean, that if I don't have overflow segment in my IOT, I don't have to analyze table, just analyze PK? Igor Neyman, OCP DBA [EMAIL PROTECTED] -Original Message- [EMAIL PROTECTED] Sent: Thursday, August 07, 2003 12:45 PM To: Multiple recipients of list ORACLE-L Igor, When you gather statistics on an IOT with the ANALYZE command, it will analyze the primary key and overflow segment so I would think this is all that is required by CBO. Hopefully others have more insight. Rick Igor Neyman [EMAIL PROTECTED]To: [EMAIL PROTECTED] on.com cc: [EMAIL PROTECTED] Subject: RE: ora-600 when analyzing IOT 08/07/2003 12:13 PM Rick, Thanks for prompt reply. I tried it (deleting statistics before analyzing table) and it worked. Any ideas, whether cost-based optimizer need statistics on IOT or having statistics on PK index of IOT would be enough? Igor Neyman, OCP DBA [EMAIL PROTECTED] -Original Message- [EMAIL PROTECTED] Sent: Thursday, August 07, 2003 12:04 PM To: Multiple recipients of list ORACLE-L According to MetaLink you need to delete statistics and re-analyze I do not know your database version but this is supposely fixed in 8.1.6 execute dbms_stats.delete_table_stats('owner','IPN_MEASUREMENT'); analyze table ipn_measurement estimate statistics ; HTH Rick Igor Neyman [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] on.com cc: Sent by: Subject: ora-600 when analyzing IOT [EMAIL PROTECTED] .com 08/07/2003 12:44 PM Please respond to ORACLE-L Ok, since my original message still hasn't arrived (sent couple hours ago), here it goes again (sorry, if you get duplicate). First, sorry for asking this list before searching Metalink, but I don't have access to it right now. So, here it is: I'm getting: ORA-00600: internal error code, arguments: [15163], [333], [17424], [16191], [], [], [], [] when analyzing one of the index-organized tables: ANALYZE TABLE ipn_measurement ESTIMATE STATISTICS. Now, similar statement analyzing other IOTs works fine. Also, on the same table (ipn_measurement) analyze worked fine yesterday, and the table didn't grew too much since yesterday. Any ideas? Another question, do I really have to run analyze table on IOT for cost-based optimizer, or analyzing index would be enough: ANALYZE INDEX
RE: ** is there PL/SQL for case
Starting with Oracle9i, PL/SQL supports the use of case statements and case expressions. These constructs are often convenient to use in place of complex if-then-else logic and function similarly to counterparts in other languages (e.g. the C switch statement). Case statements are standalone statements that can appear anywhere any other PL/SQL statement can appear. Case expressions are similar to case statements, but return a value and can only appear in places where any other PL/SQL expression can appear. Rick Guang Mei [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED]Subject: RE: ** is there PL/SQL for case .com 08/07/2003 04:34 PM Please respond to ORACLE-L I am not sure in 9i. But in 8i I think you can use case in sql but not in pl/sql. You have to use if elsif in pl/sql. Guang -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of A Joshi Sent: Thursday, August 07, 2003 4:24 PM To: Multiple recipients of list ORACLE-L Subject: ** is there PL/SQL for case Hi, Is there a statement in pl/SQL like case or is if elsif the only way. Meaning if I need to transalate state depending on input number as follows : 1 - CA 2 - OR 3 - WA 4 - AR Can I have one statement like case 'state# : 1:
RE: impersonating another user???
Dennis, Thanks for replying but I think you either read/responded to the wrong question or jumped to the wrong conclusion. Perhaps the subject line was the reason. Tom Kyte has an entire section on n-tier authentication as well as Oracle. However I cannot put all the pieces together as no good examples are presented on entire usage. I was hoping someone has some experience in this. This has NOTHING to do with divulging/changing passwords. Sorry no bad odor on this oneg. Thanks Rick DENNIS WILLIAMS [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] UCH.COM cc: Sent by: Subject: RE: impersonating another user??? [EMAIL PROTECTED] .com 08/01/2003 05:39 PM Please respond to ORACLE-L Rick Since nobody has responded to your question, I'll answer: No, haven't tried that. Most of us work hard to keep a user from impersonating another user. ;-) Seriously, this whole system might get you fired someday. I can just see you trying to explain how this is a legitimate request several years ago, but you can't find the authorizing memo. At most sites, the answer is that if the manager wants the subordinate to act as them, he/she provides the password and changes the password upon return. Yep, this one has a bad odor. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, August 01, 2003 11:24 AM To: Multiple recipients of list ORACLE-L Hi DBAs, Oracle 8.1.7.4 I want to be able to have users log into the database with an OS integrated account and set up only certain users that log in to act on the behalf of another integrated user account. (i.e. A manager is given access to a database where he may delegate his authority to an administrative assistant who logs into the database and when the assistant connects, the database automatically impersonates the assistants account to appear as the managers account. Giving them the same database permission's as the manager. Also I would want to be able to look at the USER keyword to determine who is really logged in, and who they are impersonating if anyone. I hope this makes sense. I have read some on n-tier authentication using the following but really do not understand how it works. ALTER USER app_user1 GRANT CONNECT THROUGH sh WITH ROLE warehouse_user; Has anyone done this? If so any help is appreciated. Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San
Re: what is BAARF?
According to http://www.baarf.com/ Battle Against Any Raid F BAARF was invented by James Morle on Wednesday the 4th of June, 2003, in the Grange hotel outside Birmingham while having a beer or two with Mogens Nrgaard. On the following day - Thursday the 5th of June, which happens to be the Danish national holiday celebrating our constitution - the Battle Agaist Any Raid Five initiative was announced jointly by James and Mogens in front of the UK Oracle User Group UNIX Special Interest Group meeting at the Grange hotel. Both announcers were careful to sport the Enough is Enough look (including arms folded across the chest) while delivering the message to about 80 delegates. Its important to note, that RAID-3, -4, and -5 are all included in the initiative, so the F in BAARF both stands for Five, Four, and err Free. [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED]Subject: what is BAARF? .com 08/04/2003 02:19 PM Please respond to ORACLE-L I see it here all the time. Any articles on it? Im assuming its some kind of storage system right? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
impersonating another user???
Hi DBAs, Oracle 8.1.7.4 I want to be able to have users log into the database with an OS integrated account and set up only certain users that log in to act on the behalf of another integrated user account. (i.e. A manager is given access to a database where he may delegate his authority to an administrative assistant who logs into the database and when the assistant connects, the database automatically impersonates the assistants account to appear as the managers account. Giving them the same database permission's as the manager. Also I would want to be able to look at the USER keyword to determine who is really logged in, and who they are impersonating if anyone. I hope this makes sense. I have read some on n-tier authentication using the following but really do not understand how it works. ALTER USER app_user1 GRANT CONNECT THROUGH sh WITH ROLE warehouse_user; Has anyone done this? If so any help is appreciated. Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Top DW requirements needed
Hi DBAs, I am very new to data warehouse and I am looking for bullet list, URLs, etc. that list what are the essential data warehousing requirements that needs identifying. I know you obviously have to understand the business prior to identifying requirements. I assume some of the requirements are 1. Understand business process 2. Identify what information the Users need to better accomplish their job such as user objectives and challenges 3. Identify data experts, where data resides,etc. If anyone has a formal list of MUST or suggested requirements I would like to see them. Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Windohs - monthly at job
Looks correct but you should use task scheduler. Rick Farnsworth, Dave [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] niture.com cc: Sent by: Subject: RE: Windohs - monthly at job [EMAIL PROTECTED] 07/08/2003 01:04 PM Please respond to ORACLE-L I think it is like this, In a DOS window type; AT 17:00 /every:1,15 C:\PATH TO BAT FILE\BAT_FILE_NAME Not positive, but I think it is like this. Dave -Original Message- From: Cunningham, Gerald [mailto:[EMAIL PROTECTED] Sent: Tuesday, July 08, 2003 11:39 AM To: Multiple recipients of list ORACLE-L Subject: Windohs - monthly at job Hi all, Does anybody know the syntax to schedule a monthly at job on Windows (2000)? I need to schedule a job for the 1st and 15th every month, and would like to avoid the Task Scheduler GUI. A virtual pint o' Guiness (mm...) for anybody who can help! Thanks! - Jerry -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: ORA-01858: a non-numeric character was found
Try it without the quotes surrounding your date field. Rick Martin, Alan (Contractor) To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] (DLIS) cc: Alan.S.Martin Subject: ORA-01858: a non-numeric character was found @dla.mil Sent by: [EMAIL PROTECTED] ity.com 06/23/2003 03:44 PM Please respond to ORACLE-L The following was issued from SQL*Plus (8.1.7) on HP-UX 11.0: SQL declare 2 stat boolean := false; 3 begin 4 DBMS_JOB.BROKEN(1,stat,'TRUNC(SYSDATE)+22/24'); 5 end; 6 / declare * ERROR at line 1: ORA-01858: a non-numeric character was found where a numeric was expected ORA-06512: at line 4 I can replace stat with FALSE in the parameter list with the same results. What am I doing wrong? Thanx, Alan Martin Hart-Dole-Inouye Federal Center Battle Creek, MI -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Need ocfgutil.exe
Hi, I have installed Oracle Administration Assistant 8.1.7.4 on Win 2000. However the utility ocfgutil.exe was not installed. Apparently this is a common problem according to MetaLink. Does anyone have this utility that can be e-mailed offline? If so please rename the extension. Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
How to prevent single point-of_failure with ONAMES
Hi All, Oracle 8.1.7.4 Win 2000 ONAMES with region database I have ONAMES repository on server1 I have 2 additional onames services on server2 and server3(no database/repository). I received a NNO-50 serious errors in configuration data. I do not know how it happened but I had to truncate and reload nmo_master and the 3 onrs_* tables. However this error caused a single point-of-failure. None of the oname services on all 3 servers would start. I was under the impression under these circumstances that Oracle would use CHKP* files. How can I prevent a single point-of-failure other than some type of hot standby? Can I have 2 repositories? If so where can I get doc to set this up? Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: How to prevent single point-of_failure with ONAMES
What had happened was the data in the table onrs_region got corrupted but the region database was still up. Somehow this caused all 3 name services to shutdown on all 3 servers. I do not have a clue how that is possible. There were checkpoint file on all servers but still no one connected. Perhaps the corrupted data got replicated to the other servers. The only error was the nno-50. Thanks Rick Jesse, Rich [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] world.comcc: Sent by: Subject: RE: How to prevent single point-of_failure with ONAMES [EMAIL PROTECTED] m 04/01/2003 10:18 AM Please respond to ORACLE-L Wierd. Our primary ONAMES server is 8.0.5 on OpenVMS, with the Region DB being on the same box. Our secondary ONAMES server is 9.2.0.2 on WinTuke using the same Region DB as the primary (amazing that 9iR2 can still use an 8.0.5 Region DB). Yes, we are working on upgrading this config, despite it being extremely stable due to non-support by Oracle Corp. One upon a time, a controller on the primary ONAMES / region DB server puked, causing the server to crash. While it was down, all Oracle Net connections eventually failed over to the secondary ONAMES server, which was indeed using the local checkpoint files for names resolution. It worked well with the only downside being that the clients had to wait for a TCP/IP timeout on the primary ONAMES server until it failed over to the secondary, but at least connections were able to be made. So when your primary failed the secondary/tertiary failed, too??? You stated that they wouldn't start, as though they hadn't been running. If they hadn't been running, there's probably no local checkpoint files, which I would think would prevent them from starting successfully. Were there any error messages? Rich Rich JesseSystem/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- Sent: Tuesday, April 01, 2003 5:09 AM To: Multiple recipients of list ORACLE-L Hi All, Oracle 8.1.7.4 Win 2000 ONAMES with region database I have ONAMES repository on server1 I have 2 additional onames services on server2 and server3(no database/repository). I received a NNO-50 serious errors in configuration data. I do not know how it happened but I had to truncate and reload nmo_master and the 3 onrs_* tables. However this error caused a single point-of-failure. None of the oname services on all 3 servers would start. I was under the impression under these circumstances that Oracle would use CHKP* files. How can I prevent a single point-of-failure other than some type of hot standby? Can I have 2 repositories? If so where can I get doc to set this up? Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ:
How to delete name service
Hi All, Oracle 8.1.7.4 Win 2000 Does anyone know how to delete a name server. I created thru net8 assistant however it will the service will not start. I want to remove it. When I highlight it the 'X' is not deleted nor thru menu options. How can I safely remove name service. Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
SQL*LOADER question
Hi All, I have two (2) Windows 2000 (w2k) machines, one running Oracle 8i at a remote site (WAN connection) and another on my desk running the Oracle client software(no database). Can I, and if so how, use sqlldr on my desktop PC to load data into the remote database. The data file to be loaded and the control file are on my desktop. I do not want to use netmeeting or PC anywhere type programs which I know I can use. Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Best way to secure underlying tables in a view
Hi All, I have a view made of 4 tables with different owners. I want to grant users select privs on that view but I do not want them to select on underlying tables. What is best approach? Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
AFTER database logon trigger keeps sessions open
Hi All, I have a after database logon trigger on server/instance 1. All it does is insert a record into instance on server2 via a database link. This creates a session on server2. So every user who logs on to server1 a session is created on server2. The session does not go away. Does anyone know why it does not after the user logs on? Below is after logon trigger DECLARE -- str varchar2(200); CURSOR temp_rec IS SELECT user AS user_name, NVL(UPPER(SUBSTR(osuser,1,30)),'SERVER') AS os_user_name, RTRIM(NVL(SUBSTR(machine,instr(machine,'\') +1,12),'SERVER'),CHR(0)) AS machine_name, sid AS session_id, serial# AS serial_no, SYSDATE AS logon_time, SYS_CONTEXT('userenv','ip_address') AS ip_address, NVL(SUBSTR(program,1,64),'INTERNAL') AS program_name, i.instance_name AS instance_name, i.host_name AS host_name, i.version AS version FROM v$session s,v$instance i WHERE s.username = user AND s.logon_time = (SELECT MAX(x.logon_time) FROM v$session x WHERE x.username = user); BEGIN FOR rec IN temp_rec LOOP INSERT INTO [EMAIL PROTECTED] (user_name, os_user_name, machine_name, session_id, serial_no, logon_time, ip_address, program_name, instance_name, host_name, version) VALUES (rec.user_name, rec.os_user_name, rec.machine_name, rec.session_id, rec.serial_no, rec.logon_time, rec.ip_address, rec.program_name, rec.instance_name, rec.host_name, rec.version); END LOOP; EXCEPTION WHEN OTHERS THEN NULL; END; -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: What privs are required to alter a trigger owned by SYS?
Yes but do you have an answer to original question Jamadagni, Rajendra To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Rajendra.Jamadagni cc: @espn.comSubject: RE: What privs are required to alter a trigger owned by Sent by: SYS? [EMAIL PROTECTED] 03/06/2003 04:24 PM Please respond to ORACLE-L I'd rather own that trigger by someone other than *sys* ... Raj - Rajendra dot Jamadagni at espn dot com Any views expressed here are strictly personal. QOTD: Any clod can have facts, having an opinion is an art !! -Original Message- Sent: Thursday, March 06, 2003 2:39 PM To: Multiple recipients of list ORACLE-L Hi all, I have trigger owned by sys. It is actually an after login trigger. I want certain users to be able to enable/disable this trigger. What privs are required? I have tried alter any trigger and I still get insufficient privs when trying to enable trigger. Thanks Rick (See attached file: ESPN_Disclaimer.txt) ESPN_Disclaimer.txt Description: Binary data
Re: show errors doesn't show anything ???
You can try select * from dba_errors where name='PRV_ADMIN'; Rick Janet Linsy [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] hoo.com cc: Sent by: Subject: show errors doesn't show anything ??? [EMAIL PROTECTED] om 03/06/2003 01:23 PM Please respond to ORACLE-L Hi, I have 9i on Linux Red Hat 2.4.9. A package is invalid after compiling. I did a show errors but nothing shows. How do I see where the error is ?? SQL alter package prv_admin compile; Warning: Package altered with compilation errors. SQL show errors; No errors. Thank you in advance! Janet __ Do you Yahoo!? Yahoo! Tax Center - forms, calculators, tips, more http://taxes.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Janet Linsy INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
What privs are required to alter a trigger owned by SYS?
Hi all, I have trigger owned by sys. It is actually an after login trigger. I want certain users to be able to enable/disable this trigger. What privs are required? I have tried alter any trigger and I still get insufficient privs when trying to enable trigger. Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Info on context option
Hi DBAs, Oracle 8.1.6 SE, WinNT We are considering using Oracle Context. Is this a separately sold product and is it available in enterprise edition. I cannot find this info anywhere. Any help is appreciated. Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Name Server questions
Hi DBAs, Oracle 8.1.6 WinNT I am trying to understand how Oracle Names is configured. We have a Oracle Names database on server 1. We also have 2 other oraclenames services on server 2 and 3. I understand how server 1 was created and works. What I do not understand is the services on server 2 and 3. How they got created,etc. Server 2 and 3 are in the sqlnet.ora file. My question is what oracle utility is used to create those services and how they are configured to work with the database on server 1? Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Is there a way to have ops$account privs to shutdown/startup database
Hi All, Oracle 8.1.7.4 WinNT Is there a way to have ops$account privs to shutdown/startup database? Oracle does not allow granting sysoper to external accounts. Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Service startup on Windows 2000 fails
Lisa, Pick your favorite sid on that server ex. lisa delete the password file associated with sid lisa. It will be in your oracle_home\database directory. At the command prompt delete that instance. This will not delete the database oradim -delete -sid lisa Recreate service using oradim -new -sid lisa -intpwd newpwd -maxusers 30 -startmode auto -pfile fullpath\initlisa.ora Alway review the oradim.log in your oracle_home\database directory after running each oradim Try connecting to database Rick Koivu, Lisa Lisa.Koivu@efair To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] field.com cc: Sent by:Subject: Service startup on Windows 2000 fails [EMAIL PROTECTED] 02/19/2003 09:08 AM Please respond to ORACLE-L Good morning everyone, Windows 2000 sp3, ver 8.1.7.2 I have NO IDEA what is going on here. I can't start any of the services associated with Oracle, not with my logon, not with local admin, not with a local account with appropriate permissions, nothing. Here's what I've tried: Followed note on metalink stating to add local security policies: Act as part of operating system, increase quotas, log on as batch job, replace a process level token, and rebooted. All logons are part of the administrator and the ORA_DBA group. I am able to log in as each of these local accounts, the accounts are not locked or messed up. I have double-checked the password in the properties tab. Local system account also fails with same error. Here's the error I receive when I try to manually start the listener service: Could not start the OracleOraHome81TNSListener service on Local Computer. The service did not return an error This could be an internal Windows error or an internal service error. If the problem persists, contact your system administrator. I am clueless and so is the sysadmin. I am just thankful this is a test system instead of production... I know next to nothing about windows. Any suggestions would be helpful. Thanks Lisa Koivu Oracle Database Administrator Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA 33063 Office: 954-935-4117 Fax:954-935-3639 Cell:954-683-4459 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Koivu, Lisa INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
How does the Oracle Home selector get installed
Hi All, I have installed Oracle 8.1.6 and 8.1.7 on WinNT in different Homes. When I had multiple Oracle homes in the past there was always an Oracle home selector installed. It was not this time. How does this get installed? I want to install this portion. Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: When were Locally Managed Tablespaces introduced?
8i Grant Allen grant@towerso To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] ft.co.ukcc: Sent by: Subject: When were Locally Managed Tablespaces introduced? [EMAIL PROTECTED] om 02/17/2003 11:53 AM Please respond to ORACLE-L I'm not having much luck - I thought it was with 9i, but the new features guide doesn't list it. So now I'm trawling through old new features guides ... and thought some bright people out there might remember (faster than I can find it in a bunch of pdfs, web pages, etc.). Ciao Fuzzy :-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: No redo or archived log files
Yes it is my understanding he does not have any online redo or archive logs current or backups. He just has current datafiles where the database will not start because of no online redo so I can assume those have been lost,corrupt,etc. Thanks Rick Nelson, Allan To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] anelson@midf. cc: com Subject: RE: No redo or archived log files Sent by: [EMAIL PROTECTED] om 02/13/2003 04:22 PM Please respond to ORACLE-L His last cold backup of the datafiles is his only option. Without the online redologs, assuming that he lost the physical files, he will have to create a controlfile with the resetlogs option and open the database in the same mode. Is my assumption true? Was he backing up only data files and the database was in archivelog mode? Allan -Original Message- Sent: Thursday, February 13, 2003 2:10 PM To: Multiple recipients of list ORACLE-L Hi All, One of my friends has a database crash. He has no backup of online redo and archived log files. His question is How do you recover the database if all the online redologfiles and all archived files are lost ? Don't ask me why he did not have any backups or mirror online redo. Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ This email is intended solely for the person or entity to which it is addressed and may contain confidential and/or privileged information. Copying, forwarding or distributing this message by persons or entities other than the addressee is prohibited. If you have received this email in error, please contact the sender immediately and delete the material from any computer. This email may have been monitored for policy compliance. [021216] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nelson, Allan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message
No redo or archived log files
Hi All, One of my friends has a database crash. He has no backup of online redo and archived log files. His question is How do you recover the database if all the online redologfiles and all archived files are lost ? Don't ask me why he did not have any backups or mirror online redo. Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
database file sizes....more of smaller size or less of larger size?
Hi DBAs, Oracle 8.1.7 WinNT I would like pros/cons on datafile sizes. It is better to have more of less size or less with larger sizes and why? Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
What is minimum privs to have user do hot backups
Hi All, If I create a backup user, what is the minimum requirements to connect as that user and do hot backups? Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Determine how many used and free blocks in an extent.
Does any have a script that shows actual # of used and free blocks in an extent? I would like to determine the maximum # of contiguous free blocks within an extent Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: 100% CPU utilization, urgent
Lisa, To get info at the thread level and determine what thread within a process is consuming the most CPU you have to use something like performance monitor or Process Viewer. Using Performance monitor you want to choose THREAD from the performance object drop-down and choose ID Thread from the counter list.. In the instance list box you will see a separate line for each oracle thread showing the instance # of the thread. You can choose any/all of the threads and then choose ADD. The value now in the performance monitor will show you the actual thread ID that you can match to the SPID column in V$PROCESS. For ex. SELECT s.* FROM v$session s, v$process p where p.spid='spid_in_perf_mon' and p.addr=s.paddr; Rick Koivu, Lisa Lisa.Koivu@efair To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] field.com cc: Sent by:Subject: RE: 100% CPU utilization, urgent [EMAIL PROTECTED] 01/20/2003 10:36 AM Please respond to ORACLE-L Thomas, thanks for your post. However I don't see where I can match the threads on NT to what I see in Task Manager. Am I missing something? To be more explicit, here's what I've got: SQL select * from dba_nt_threads; ID_THREAD B NAMESIDSERIAL# USERNAME STATUS OSUSER - - - - -- -- 3144 1 PMON 1 1 ACTIVE SYSTEM 2436 1 DBW0 2 1 ACTIVE SYSTEM 2972 1 LGWR 3 1 ACTIVE SYSTEM 3172 1 CKPT 4 1 ACTIVE SYSTEM 2976 1 SMON 5 1 ACTIVE SYSTEM 3380 1 RECO 6 1 ACTIVE SYSTEM 2840 11 1973 LISA ACTIVE lkoivu2 900 12 2 DBSNMP INACTIVE SYSTEM 8 rows selected. I see no processes in task manager that correspond to any of the numbers listed in ID_THREAD. In fact my sessions script used to reference spid, but I took it out because I couldn't make sense of it on Windows. Thanks for any insight. Lisa Koivu Oracle Dogbarf Cleanerupper Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA 33063 -Original Message- Sent: Monday, January 20, 2003 9:00 AM To: Multiple recipients of list ORACLE-L Create the view dba_nt_threads and query it, then run the monitor CPU per session. These are not my scripts --- I'm pretty sure that they were posted here by others --- but I did not capture the information on who originally wrote them. My apologies. HTH --cr_dba_nt_threads.sql -- run as sys create or replace view dba_NT_threads as select p.spid ID_THREAD, p.background BACKGROUND, b.name NAME, s.sid SID, s.serial# SERIAL#, s.username USERNAME, s.status STATUS, s.osuser OSUSER, s.program PROGRAM from v$process p, v$bgprocess b, v$session s where s.paddr = p.addr and b.paddr(+) = p.addr; create public synonym dba_nt_threads for dba_nt_threads; create public synonym threads for dba_nt_threads; -- monitor CPU per session -- requires timed statistics on col sid format SELECT v.SID, SUBSTR(s.NAME,1,30) Statistic, v.VALUE FROM V$STATNAME s, V$SESSTAT v WHERE s.NAME = 'CPU used by this session' AND v.STATISTIC# = s.STATISTIC# Hussain Ahmed Qadri hussain To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] @skm.org.pk cc: Sent by: rooturgent 01/20/2003 12:44 AM
Installer does not run on Win 2k Service Pack 3
Hi DBAs, Has anyone had trouble installing Oracle 8.x on Win 2k Service Pack 3?. When I tried installing 8.1.6 and 8.1.7 the installer does not start. Oracle 9.x installs fine. I do not know if it related to SP3 or not as I was able to install on similar server with SP 2. Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Installer does not run on Win 2k Service Pack 3
Ooops I forgot it is that P4 bug!!! Rick_Cale@team health.com To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: Installer does not run on Win 2k Service Pack 3 om 01/16/2003 09:08 AM Please respond to ORACLE-L Hi DBAs, Has anyone had trouble installing Oracle 8.x on Win 2k Service Pack 3?. When I tried installing 8.1.6 and 8.1.7 the installer does not start. Oracle 9.x installs fine. I do not know if it related to SP3 or not as I was able to install on similar server with SP 2. Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Where to get info on global temp tables
Hi All, I cannot seem to find DD view on global temp tables. I would think Oracle stores it somewhere. Also is there a way to change from delete rows to preserve rows via some alter command. Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Which session is killing performance?
Once you know the thread id (ex. 2496) you can do the following SELECT s.osuser,s.program,s.terminal /* whatever you want to see */ FROM v$session s, v$process p WHERE p.spid = '2496' AND p.addr = s.paddr; Rick Igor Neyman ineyman@perce To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] ptron.com cc: Sent by: Subject: Re: Which session is killing performance? [EMAIL PROTECTED] om 01/09/2003 04:25 PM Please respond to ORACLE-L True, but how you associate thread# in PerformanceMonitore with Oracle's spid? Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, January 09, 2003 3:59 PM I believe you can if you use performance monitor and chart by thread. Rick Igor Neyman ineyman@perce To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] ptron.com cc: Sent by: Subject: Re: Which session is killing performance? [EMAIL PROTECTED] om 01/09/2003 02:54 PM Please respond to ORACLE-L Ference, Oracle on Windows runs as one multithreaded process, so you wouldn't get specific session id sorting list of processes by CPU. Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, January 09, 2003 1:57 PM Since you are on Weenie-doze: go to task manager (3 finger salute [alt+ctrl+delete]), and order by CPU descending, then look at the PID, make a note of it, and run this script, entering the PID: column log_tim format a18 col username format a12 col osuser for a12 set linesize 132 set verify off set pagesize 80 col program for a20 accept id prompt 'Enter shadow process ID : ' select osuser, a.program, sid, a.serial#, sql_address, prev_sql_Addr, taddr, to_char(logon_time,'DD:HH24:MI:SS') log_tim, spid from v$session a, v$process b where b.spid=('id') and a.paddr = b.addr(+) and a.type !='BACKGROUND' order by logon_time desc ; Once you have SQL_ADDRESS, then run THIS script, copying and pasting the SQL_ADDRESS value: set pagesize 200 set verify off accept adr char prompt Enter SQL_ADDRESS for session whose SQL you wish to see : select ltrim(rtrim(sql_text)) from v$sqltext where address = 'adr' order by piece; Or if you have the PID, launch Toad, and get the Trace/Kill view and filter it for the PID, it will show you the SQL in the bottom pane. Much quicker with TOAD. Regards : Ferenc Mantfeld -Original Message- From: Craig Healey [SMTP:[EMAIL PROTECTED]] Sent: Friday, January 10, 2003 1:40 AM To: Multiple recipients of list ORACLE-L Subject: Which session is killing performance? Newbie question time: We have 8.1.7 running on Win 2000 with about 50 users. The system has just slowed down dramatically for about 5 minutes, with lots of user complaints. I suspect one of the developers was loading data or doing some DML. But how do I find who it is? I found a small piece of code on AskTom that returned a user whose SQL has been running longer that x seconds, but this wont necessarily be the user I'm looking for, will it?. Is there something in
Re: Determine max # of concurrent users at schema level
This is at the instance level. As suspected the only way is through auditing. Thanks Rick Charlie_Mengler@Hom eDepot.comTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: Re: Determine max # of concurrent users at schema level 01/09/2003 08:43 PM Please respond to ORACLE-L [EMAIL PROTECTED] desc v$license NameNull?Type --- SESSIONS_MAX NUMBER SESSIONS_WARNING NUMBER SESSIONS_CURRENT NUMBER SESSIONS_HIGHWATER NUMBER USERS_MAXNUMBER Arup Nanda arupnanda@hotmaiTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] l.com cc: Sent by: Subject: Re: Determine max # of concurrent users at schema level [EMAIL PROTECTED] 01/09/2003 02:44 PM Please respond to ORACLE-L Rick, There is no such view, but can be very simply obtained by turning on auditing and placing auditing for connects for user. Later you can aanalyze the connects and disconnects in a given time period to get max concurrent access. HTH. Arup Nanda - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, January 09, 2003 3:24 PM Hi All, V$LICENSE will show max # of concurrent users since instance startup. Is there another view or something to determine max # of concurrent sessions for each schema? Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Arup Nanda INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L
Determine max # of concurrent users at schema level
Hi All, V$LICENSE will show max # of concurrent users since instance startup. Is there another view or something to determine max # of concurrent sessions for each schema? Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Which session is killing performance?
I believe you can if you use performance monitor and chart by thread. Rick Igor Neyman ineyman@perce To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] ptron.com cc: Sent by: Subject: Re: Which session is killing performance? [EMAIL PROTECTED] om 01/09/2003 02:54 PM Please respond to ORACLE-L Ference, Oracle on Windows runs as one multithreaded process, so you wouldn't get specific session id sorting list of processes by CPU. Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, January 09, 2003 1:57 PM Since you are on Weenie-doze: go to task manager (3 finger salute [alt+ctrl+delete]), and order by CPU descending, then look at the PID, make a note of it, and run this script, entering the PID: column log_tim format a18 col username format a12 col osuser for a12 set linesize 132 set verify off set pagesize 80 col program for a20 accept id prompt 'Enter shadow process ID : ' select osuser, a.program, sid, a.serial#, sql_address, prev_sql_Addr, taddr, to_char(logon_time,'DD:HH24:MI:SS') log_tim, spid from v$session a, v$process b where b.spid=('id') and a.paddr = b.addr(+) and a.type !='BACKGROUND' order by logon_time desc ; Once you have SQL_ADDRESS, then run THIS script, copying and pasting the SQL_ADDRESS value: set pagesize 200 set verify off accept adr char prompt Enter SQL_ADDRESS for session whose SQL you wish to see : select ltrim(rtrim(sql_text)) from v$sqltext where address = 'adr' order by piece; Or if you have the PID, launch Toad, and get the Trace/Kill view and filter it for the PID, it will show you the SQL in the bottom pane. Much quicker with TOAD. Regards : Ferenc Mantfeld -Original Message- From: Craig Healey [SMTP:[EMAIL PROTECTED]] Sent: Friday, January 10, 2003 1:40 AM To: Multiple recipients of list ORACLE-L Subject: Which session is killing performance? Newbie question time: We have 8.1.7 running on Win 2000 with about 50 users. The system has just slowed down dramatically for about 5 minutes, with lots of user complaints. I suspect one of the developers was loading data or doing some DML. But how do I find who it is? I found a small piece of code on AskTom that returned a user whose SQL has been running longer that x seconds, but this wont necessarily be the user I'm looking for, will it?. Is there something in v$session I should be looking at? Any help appreciated Craig Healey ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. Statements and opinions expressed in this e-mail may not represent those of the company. If you have received this email in error please notify [EMAIL PROTECTED] This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses (www.mimesweeper.com) *** -- Please see the official ORACLE-L FAQ:
Re: Determine max # of concurrent users at schema level
Yeah that's what I thought. Thanks Stephane Faroult To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] sfaroult@orio cc: le.com Subject: Re: Determine max # of concurrent users at schema level Sent by: [EMAIL PROTECTED] om 01/09/2003 04:15 PM Please respond to ORACLE-L [EMAIL PROTECTED] wrote: Hi All, V$LICENSE will show max # of concurrent users since instance startup. Is there another view or something to determine max # of concurrent sessions for each schema? Thanks Rick AUDIT on connections, and good ol' SQL ... -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Different Oracle clients give different results
Oracle says this is intended behavior for desc function just more rigorously enforced in later versions. I am still skeptical as desc works in 8.1.6 svrmgrl. Perhaps enforced in sqlplus but not svrmgr...too many inconsistencies. Thanks Rick Brian McGraw brian.mcgraw@infinity-insu To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] rance.comcc: Sent by: [EMAIL PROTECTED] Subject: RE: Different Oracle clients give different results 12/31/2002 01:28 PM Please respond to ORACLE-L Rick - Are all of the sqlnet.ora files resolving hostnames in the same order i.e., NAMES.DIRECTORY_PATH= (ONAMES, TNSNAMES, HOSTNAME)? I'd also check for a rogue tnsnames.ora file in the same path as the executable. Brian -- | Brian McGraw /* DBA */ Infinity Insurance | | mailto:[EMAIL PROTECTED] | -- -Original Message- [EMAIL PROTECTED] Sent: Tuesday, December 31, 2002 7:34 AM To: Multiple recipients of list ORACLE-L Hi DBAs, Oracle Server 8.1.6 Win 2000 Oracle Names I have the following Oracle clients installed locally. I connect to the server using the same USER. When I describe a package and procedure with package I get different results depending on the client. Any ideas what is going on here 8.0.5 desc pkg_charts WORKS desc pkg_charts.select_affiliatesWORKS 8.1.6 desc pkg_charts WORKS desc pkg_charts.select_affiliatesORA-04043: object pkg_charts.select_affiliates does not exist 8.1.7 desc pkg_charts WORKS desc pkg_charts.select_affiliatesORA-04043: object pkg_charts.select_affiliates does not exist Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Brian McGraw INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Different Oracle clients give different results
Hi DBAs, Oracle Server 8.1.6 Win 2000 Oracle Names I have the following Oracle clients installed locally. I connect to the server using the same USER. When I describe a package and procedure with package I get different results depending on the client. Any ideas what is going on here 8.0.5 desc pkg_charts WORKS desc pkg_charts.select_affiliatesWORKS 8.1.6 desc pkg_charts WORKS desc pkg_charts.select_affiliatesORA-04043: object pkg_charts.select_affiliates does not exist 8.1.7 desc pkg_charts WORKS desc pkg_charts.select_affiliatesORA-04043: object pkg_charts.select_affiliates does not exist Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Different Oracle clients give different results
Brian, Yes I have checked all of this. Three other co-workers are having same problem except they just have the one Oracle client 8.1.7. It appears to be client related. Thanks Rick Brian McGraw brian.mcgraw@infinity-insu To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] rance.comcc: Sent by: [EMAIL PROTECTED] Subject: RE: Different Oracle clients give different results 12/31/2002 01:28 PM Please respond to ORACLE-L Rick - Are all of the sqlnet.ora files resolving hostnames in the same order i.e., NAMES.DIRECTORY_PATH= (ONAMES, TNSNAMES, HOSTNAME)? I'd also check for a rogue tnsnames.ora file in the same path as the executable. Brian -- | Brian McGraw /* DBA */ Infinity Insurance | | mailto:[EMAIL PROTECTED] | -- -Original Message- [EMAIL PROTECTED] Sent: Tuesday, December 31, 2002 7:34 AM To: Multiple recipients of list ORACLE-L Hi DBAs, Oracle Server 8.1.6 Win 2000 Oracle Names I have the following Oracle clients installed locally. I connect to the server using the same USER. When I describe a package and procedure with package I get different results depending on the client. Any ideas what is going on here 8.0.5 desc pkg_charts WORKS desc pkg_charts.select_affiliatesWORKS 8.1.6 desc pkg_charts WORKS desc pkg_charts.select_affiliatesORA-04043: object pkg_charts.select_affiliates does not exist 8.1.7 desc pkg_charts WORKS desc pkg_charts.select_affiliatesORA-04043: object pkg_charts.select_affiliates does not exist Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Brian McGraw INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Rebuilding Indexes...
If you know you have 3 duplicate records in the table then the PK must have already been disabled so you have to rebuild anyway. I do not see where you had to disable in order to use the exception table. It was already disabled therefore it probably not an app problem but a disable constraint problem unless direct load bypasses constraint checking which I am not sure. Rick Rachel Carmichael To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] wisernet100@y cc: ahoo.comSubject: Re: Rebuilding Indexes... Sent by: [EMAIL PROTECTED] om 12/27/2002 07:43 AM Please respond to ORACLE-L Here's a reason: have you ever tried to find the three duplicate rows in a 12 million row table without using the primary key constraint? I've had to disable or drop the constraint in order to use the exceptions table. Once I do that, even if I've built a separate index that enforces the primary key constraint, Oracle drops the index. So I HAVE to rebuild it. If I allow the index to be rebuilt when I re-enable the primary key constraint, it builds it in the default tablespace of the table owner, not where I want it. if anyone has a better way to fix this problem, I'm more than happy to hear it! It's a data warehouse and the third party app has a bug we can't find and on occasion sqlloads (via direct path) duplicate rows Rachel --- Jared Still [EMAIL PROTECTED] wrote: Though I have published a script for determining indexes that need to be rebuilt, and then rebuilding them, I have to say that this is almost never necessary. Why are you rebuilding indexes? About the only reason for ever doing so is that the BLEVEL = 5. goto asktom.oracle.com, and do a search on 'index rebuild'. Currently, the third article may be of interest. Jared On Thursday 26 December 2002 12:24, Richard Huntley wrote: Anyone have any useful scripts for doing this? TIA, Rich Content-Type: text/html; charset=iso-8859-1; name=Attachment: 1 Content-Transfer-Encoding: 7bit Content-Description: -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include
Oracle.exe , CPU running at near 85%
Hi, Oracle 8.1.6 on NT 4.0 Oracle.exe is running at about 85% CPU utilization. What can I check to see why that is the case? Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
OT: Forms,Reports performance problem
Oracle 8.1.6 Win Nt Has anyone experience/heard of performace problems after migrating from forms 5 to forms 6.0.8.15 and from reports 2.5 to 3.0? Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: best case scenarios for export/import
First of all you have to have an estimate on how long the import should take. Oracle rule-of-thumb formula for that is import elapsed time = export elapsed time X 4 At least you have a targeted time to shoot for then try to improve if necessary. Rick Magaliff, Bill Bill.Magaliff@len To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] dware.com cc: Sent by: Subject: best case scenarios for export/import [EMAIL PROTECTED] 12/20/2002 09:04 AM Please respond to ORACLE-L Good day, all: I'm looking for real-life best-case scenarios for running import/export . . . I've been playing with this for quite some time and would like to know how fast I can really expect this to go, particularly for the import. I'd be interested to hear others' experiences - how fast have you been able to import data? what parameters have you used? etc. . . . it's both for informational purposes and as a sanity check. For example: I'm now trying to import a dump file of appx 6.5 Gb - breaks down into 12G data and 4G indexes. using the following params on the first import, to just get the data (I then rerun with the indexfile param to get the indexes): recordlength=65535 buffer=1500 (15M) commit=y indexes=n constraints=n grants=n This will import in appx 36 hours using a single 3 Gb rollback segment What kind of experiences have you had? Thanks bill -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Magaliff, Bill INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: import and rollback segments
If you cannot take the small ones offline, I do not think you can force to use a particular RBS. You could possible create multiple large RBS then take smaller ones offline then import. After completion put smaller ones online. You can try commit=y to commit after each buffer instead of each object. Use a larger BUFFER size on import to reduce round trips to export file. Perhaps others have some tricks Rick Leonard, George george.leonard@fa To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] rnell.com cc: Sent by: Subject: import and rollback segments [EMAIL PROTECTED] 12/20/2002 08:09 AM Please respond to ORACLE-L Hi all Can a person somehow force a import process to use a specific rollback segment. I got a live system with many smallish segments, the dump file is about 20 GB and take just over 12 hours to process but it requires a big rollback segment. I don't want to offline the small once so that only a big one is online since this causes problems with the day to day operation of the client systems. Ideas. George George Leonard Oracle Database Administrator Dimension Data (Pty) Ltd (Reg. No. 1987/006597/07) Tel: (+27 11) 575 0573 Fax: (+27 11) 576 0573 E-mail:[EMAIL PROTECTED] Web: http://www.didata.co.za You Have The Obligation to Inform One Honestly of the risk, And As a Person You Are Committed to Educate Yourself to the Total Risk In Any Activity! Once Informed Totally Aware of the Risk, Every Fool Has the Right to Kill or Injure Themselves as They See Fit! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Leonard, George INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: 8i OCP DBA Exams
Hi, Voucher expiration dates having NOTHING to do with retiring of a track. Every voucher has an expiration date, no different on any coupon you get out of the newspaper. No announcement has been made on retiring 8i DBA track. Oracle typically retires a track 6 months after announcement. Rick Saira Somani saira_somani@ To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] yahoo.com cc: Sent by: Subject: 8i OCP DBA Exams [EMAIL PROTECTED] om 12/20/2002 08:24 AM Please respond to ORACLE-L Hello Gurus, My company recently paid for the Oracle 8i DBA self-study courses to cover all 5 exams. Oracle sent me vouchers for the exams. The vouchers expire on July 31, 2003. Does that mean that the 8i DBA track is going to expire on that date and I really truly only have 6 months to write these exams? Thanks. Saira Somani IT Support/Analyst Hospital Logistics Inc. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Saira Somani INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Happy Holidays!!
I have never met RUTH and I apologize in advance if I am wrong but I thought I remember a post long ago indicating Ruth G is male? Again a big oops if incorrect. Rachel Carmichael To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] wisernet100@y cc: ahoo.comSubject: RE: Happy Holidays!! Sent by: [EMAIL PROTECTED] om 12/20/2002 02:28 PM Please respond to ORACLE-L from this list: Ruth Gramolini and April Wells are going, they are presenting. I don't know if I am presenting or not, I was accepted as an alternate and today is the cutoff for the speakers to confirm they are going. But I'll be there whether or not I present --- [EMAIL PROTECTED] wrote: No offense guys, but having only small boy children (whom I love dearly), working in a 90% male IT support organization (cause I like men) - can't help feeling like what I really need now is some good woman friends - preferably ones that both work and are raising children. Are any of them going to IOUG? -Original Message- Sent: Friday, December 20, 2002 11:40 AM To: Multiple recipients of list ORACLE-L from what Jared tells me, in the first 50 names on the list (alphabetical?) he found 11 out of 50 names that were obviously female first names. not the best statistic (1/5 of an admittedly small sample). but better than it was a few years ago. What I really like seeing is that more and more women are answering questions here as well --- Lisa Corell Auerbach [EMAIL PROTECTED] wrote: Hi Rachel - you wrote - I'm more interested in the numbers to see if this field is less male-centric than others. I don't post very often, but I'm another in the orawoman category. Lisa (now the DBA at Henrico County Public Schools) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Lisa Corell Auerbach INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up
RE: Happy Holidays!!
Ah Yes, that is exactly who I was thinking of. Sorry Ruth Gramolini Weaver, Walt wweaver@right To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] now.com cc: Sent by: Subject: RE: Happy Holidays!! [EMAIL PROTECTED] om 12/20/02 04:04 PM Please respond to ORACLE-L Perhaps you're thinking of Guy Ruth Hammond. --Walt Weaver Bozeman, Montana -Original Message- Sent: Friday, December 20, 2002 1:38 PM To: Multiple recipients of list ORACLE-L I have never met RUTH and I apologize in advance if I am wrong but I thought I remember a post long ago indicating Ruth G is male? Again a big oops if incorrect. Rachel Carmichael To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] wisernet100@y cc: ahoo.comSubject: RE: Happy Holidays!! Sent by: [EMAIL PROTECTED] om 12/20/2002 02:28 PM Please respond to ORACLE-L from this list: Ruth Gramolini and April Wells are going, they are presenting. I don't know if I am presenting or not, I was accepted as an alternate and today is the cutoff for the speakers to confirm they are going. But I'll be there whether or not I present --- [EMAIL PROTECTED] wrote: No offense guys, but having only small boy children (whom I love dearly), working in a 90% male IT support organization (cause I like men) - can't help feeling like what I really need now is some good woman friends - preferably ones that both work and are raising children. Are any of them going to IOUG? -Original Message- Sent: Friday, December 20, 2002 11:40 AM To: Multiple recipients of list ORACLE-L from what Jared tells me, in the first 50 names on the list (alphabetical?) he found 11 out of 50 names that were obviously female first names. not the best statistic (1/5 of an admittedly small sample). but better than it was a few years ago. What I really like seeing is that more and more women are answering questions here as well --- Lisa Corell Auerbach [EMAIL PROTECTED] wrote: Hi Rachel - you wrote - I'm more interested in the numbers to see if this field is less male-centric than others. I don't post very often, but I'm another in the orawoman category. Lisa (now the DBA at Henrico County Public Schools) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Lisa Corell Auerbach INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City
OT: Guidelines/Standards for supporting non-oracle databases
Hi, We are virtually an Oracle shop with 2-3 sql server databases due to 3rd-party software restrictions. We have been asked about supporting other small databases such as Access,etc within our company. My question is if you were asked to support smaller databases what restrictions/guidelines/standards are worth considering? Be kind-constructive answers only :-) Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: archiving redo logs
You must use the same version, release, and patch of the operating systems on the production and standby hosts. The standby host can, however, use a different disk configuration. Rick Kevin Lange [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] om cc: Sent by: Subject: RE: archiving redo logs [EMAIL PROTECTED] om 12/10/2002 03:42 PM Please respond to ORACLE-L And what is the problem with having a standby DB on a different OS than the primary ??? -Original Message- From: Bala Regupathy [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 10, 2002 2:06 PM To: Multiple recipients of list ORACLE-L Subject: archiving redo logs Hi, How can I archive redo logs automatically to a different machine ?. Standby database is not an option because the target machine's OS is different from the primary. Primary db is 8.1.7.2 resides on SUN E10k with SunOS 5.8. Target server is DEC Alpha 4.0 If UNIX script is the only option, I appreciate if you can share it here. Thanks, Bala. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Indicator variables
Tom is correct indicator variables 0 - NOT NULL and data retrieved successfully -1 - data is NULL 0 - NOT NULL but possible truncation of data. In 3gl programs such as C ALWAYS use indicator variables. Rick Mercadante, Thomas F To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] [EMAIL PROTECTED] cc: ate.ny.us Subject: RE: Indicator variables Sent by: [EMAIL PROTECTED] 12/09/2002 08:03 AM Please respond to ORACLE-L Raj, from what I remember, a NOT NULL constraint has no impact on an indicator variable in 3GL programs. The indicator variable indicates whether the value fetched is null or has a value. hope this helps. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Friday, December 06, 2002 4:29 PM To: Multiple recipients of list ORACLE-L Hi All, What value does an indicator variable in a pro*c program assume when the fetch column value is NOT NULL. Is is 0 or something other that -1. I would appreciate your help. Thanks, Rajesh -Original Message- Sent: Friday, December 06, 2002 12:34 PM To: Multiple recipients of list ORACLE-L Adam - Someone posted a better hidden? parameter awhile back. Jared, was that you? Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, December 06, 2002 11:29 AM To: Multiple recipients of list ORACLE-L I was afraid that'd be the only way. Thanks. Adam -Original Message- Sent: Friday, December 06, 2002 12:05 PM To: Multiple recipients of list ORACLE-L Hi Set global_names = false in init.ora file and try again -Original Message- Sent: vrijdag 6 december 2002 17:41 To: Multiple recipients of list ORACLE-L Don't ask how we got into this situation, but I have two instances with the same global_name and need to be able to create a link between them. Is this doable? Adam -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Donahue, Adam INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack van Zanen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Donahue, Adam INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services
Re: STATSPACK
I have not done it but supposely oracle_home\rdbms\admin\sppurge will do it. Rick Seema Singh oracledbam@ho To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] tmail.com cc: Sent by: Subject: STATSPACK [EMAIL PROTECTED] om 12/09/2002 11:14 AM Please respond to ORACLE-L Hi How to clean all old STATSPACK data? Thx -Seema _ STOP MORE SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
sql tuning help
Hi, Oracle 8.1.6 NT 4.0 I have a rather complex query a developer gave to me to try to improve performance. There are 3 tables used. All relevant columns used are indexed. The tables have been analyzed SQLWKS select count(*) from physicians; COUNT(*) -- 340043 1 row selected. SQLWKS select count(*) from boards; COUNT(*) -- 220 1 row selected. SQLWKS select count(*) from phy_boards; COUNT(*) -- 450674 Below is the sql statement and explain plan. I see one FTS on 440,000+ records but cannot tell exactly what statement it is and how to resolve Any suggestions on how to optimize is appreciated. Thanks Rick select board_other.description strBrdNameOtherTHQuest ,decode(board_aaps.description, null,' ','X') ysnAAPSBoard ,decode(board_aba.description, null,' ','X') ysnABABoard ,decode(board_abem.description, null,' ','X') ysnABEMBoard ,decode(board_abfp.description, null,' ','X') ysnABFPoard ,decode(board_abim.description, null,' ','X') ysnABIMBoard ,decode(board_abp.description, null,' ','X') ysnABPBoard ,decode(board_abr.description, null,' ','X') ysnABRBoard ,decode(board_aobem.description, null,' ','X') ysnAOBEMBoard ,decode(board_aobfp.description, null,' ','X') ysnAOBFPBoard ,decode(board_aobim.description, null,' ','X') ysnAOBIMBAoard ,decode(board_aobr.description, null,' ','X') ysnAOBRBoard ,decode(board_other.description, null,' ','X') ysnOtherBoard from physicians p ,(select distinct pb.phy_id, b.name, b.description from phy_boards pb, boards b where pb.board_id = b.board_id and (pb.expiration_date = sysdate or pb.expiration_date is null) and b.description like 'AMERICAN ASSOCIATION OF PHYSICIAN SPECIALIST%') board_aaps ,(select distinct pb.phy_id, b.name, b.description from phy_boards pb, boards b where pb.board_id = b.board_id and (pb.expiration_date = sysdate or pb.expiration_date is null) and b.description like 'AMERICAN BOARD OF ANESTHESIOLOGY%') board_aba ,(select distinct pb.phy_id, b.name, b.description from phy_boards pb, boards b where pb.board_id = b.board_id and (pb.expiration_date = sysdate or pb.expiration_date is null) and b.description like 'AMERICAN BOARD OF EMERGENCY MEDICINE%') board_abem ,(select distinct pb.phy_id, b.name, b.description from phy_boards pb, boards b where pb.board_id = b.board_id and (pb.expiration_date = sysdate or pb.expiration_date is null) and b.description like 'AMERICAN BOARD OF FAMILY PRACTICE%') board_abfp ,(select distinct pb.phy_id, b.name, b.description from phy_boards pb, boards b where pb.board_id = b.board_id and (pb.expiration_date = sysdate or pb.expiration_date is null) and b.description like 'AMERICAN BOARD OF INTERNAL MEDICINE%') board_abim ,(select distinct pb.phy_id, b.name, b.description from phy_boards pb, boards b where pb.board_id = b.board_id and (pb.expiration_date = sysdate or pb.expiration_date is null) and b.description like 'AMERICAN BOARD OF PEDIATRICS%') board_abp ,(select distinct pb.phy_id, b.name, b.description from phy_boards pb, boards b where pb.board_id = b.board_id and (pb.expiration_date = sysdate or pb.expiration_date is null) and b.description like 'AMERICAN BOARD OF RADIOLOGY%') board_abr ,(select distinct pb.phy_id, b.name, b.description from phy_boards pb, boards b where pb.board_id = b.board_id and (pb.expiration_date = sysdate or pb.expiration_date is null) and b.description like 'AMERICAN OSTEOPATHIC BOARD OF EMERGENCY MEDICINE%') board_aobem ,(select distinct pb.phy_id, b.name, b.description from phy_boards pb, boards b where pb.board_id = b.board_id and (pb.expiration_date = sysdate or pb.expiration_date is null) and b.description like 'AMERICAN OSTEOPATHIC BOARD OF FAMILY PHYSICIANS%') board_aobfp ,(select distinct pb.phy_id, b.name, b.description from phy_boards pb, boards b where pb.board_id = b.board_id and (pb.expiration_date = sysdate or pb.expiration_date is null) and b.description like 'AMERICAN OSTEOPATHIC BOARD OF INTERNAL MEDICINE%') board_aobim ,(select distinct pb.phy_id, b.name, b.description from phy_boards pb, boards b where pb.board_id = b.board_id and (pb.expiration_date = sysdate or pb.expiration_date is null) and
Re: sql tuning help
Thanks for the reply but I only see 1 FTS for the last inline view. Some of the info was truncated from previous post. I am resending output Plan Table | Operation | Name| Rows | Bytes| Cost | Pstart| Pstop | | SELECT STATEMENT | | 2 | 2K| | NESTED LOOPS OUTER | | 2 | 2K| | NESTED LOOPS OUTER | | 1 | 1K| |NESTED LOOPS OUTER| | 1 | 1K| | NESTED LOOPS OUTER | | 1 | 1K| | NESTED LOOPS OUTER | | 1 | 924 | | NESTED LOOPS OUTER | | 1 | 809 | |NESTED LOOPS OUTER| | 1 | 694 | | NESTED LOOPS OUTER | | 1 | 579 | | NESTED LOOPS OUTER | | 1 | 464 | | NESTED LOOPS OUTER | | 1 | 349 | |NESTED LOOPS OUTER| | 1 | 234 | | NESTED LOOPS OUTER | | 1 | 119 | | INDEX UNIQUE SCAN |PHY_PK| 1 | 4 | | VIEW| | 8K| 922K| | SORT UNIQUE| | 8K| 649K| |NESTED LOOPS | | 8K| 649K| | INDEX FAST FULL SCAN |BOARD_NAM | 3 | 207 | | TABLE ACCESS BY INDEX ROWID |PHY_BOARD | 443K| 5M| | INDEX RANGE SCAN|PBRD_BOAR | 443K| | | VIEW | | 8K| 922K| | SORT UNIQUE | | 8K| 649K| | NESTED LOOPS | | 8K| 649K| |INDEX FAST FULL SCAN |BOARD_NAM | 3 | 207 | |TABLE ACCESS BY INDEX ROWID |PHY_BOARD | 443K| 5M| | INDEX RANGE SCAN |PBRD_BOAR | 443K| | |VIEW | | 8K| 922K| | SORT UNIQUE | | 8K| 649K| | NESTED LOOPS| | 8K| 649K| | INDEX FAST FULL SCAN |BOARD_NAM | 3 | 207 | | TABLE ACCESS BY INDEX ROWID|PHY_BOARD | 443K| 5M| |INDEX RANGE SCAN |PBRD_BOAR | 443K| | | VIEW | | 8K| 922K| |SORT UNIQUE | | 8K| 649K| | NESTED LOOPS | | 8K| 649K| | INDEX FAST FULL SCAN|BOARD_NAM | 3 | 207 | | TABLE ACCESS BY INDEX ROWID |PHY_BOARD | 443K| 5M| | INDEX RANGE SCAN |PBRD_BOAR | 443K| | | VIEW| | 8K| 922K| | SORT UNIQUE| | 8K| 649K| |NESTED LOOPS | | 8K| 649K| | INDEX FAST FULL SCAN |BOARD_NAM | 3 | 207 | | TABLE ACCESS BY INDEX ROWID |PHY_BOARD | 443K| 5M| | INDEX RANGE SCAN|PBRD_BOAR | 443K| | | VIEW | | 8K| 922K| | SORT UNIQUE | | 8K| 649K| | NESTED LOOPS | | 8K| 649K| |INDEX FAST FULL SCAN |BOARD_NAM | 3 | 207 | |TABLE ACCESS BY INDEX ROWID |PHY_BOARD | 443K| 5M| | INDEX RANGE SCAN |PBRD_BOAR | 443K| | |VIEW | | 8K| 922K| | SORT UNIQUE | | 8K| 649K| | NESTED LOOPS| | 8K| 649K| | INDEX FAST FULL SCAN |BOARD_NAM | 3 | 207 | | TABLE ACCESS BY INDEX ROWID|PHY_BOARD | 443K| 5M| |INDEX RANGE SCAN |PBRD_BOAR | 443K| | | VIEW | | 8K| 922K| |SORT UNIQUE | | 8K| 649K| | NESTED LOOPS | | 8K| 649K| | INDEX FAST FULL SCAN
RE: sql tuning help
Tom, Actually it returns 1 record. Thanks Rick Mercadante, Thomas F To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] [EMAIL PROTECTED] cc: ate.ny.us Subject: RE: sql tuning help Sent by: [EMAIL PROTECTED] 12/06/2002 11:41 AM Please respond to ORACLE-L Rick, does this return *any* records at all? the only reason that I ask is that in the 'where' clause, it is saying: where p.phy_id = board_aaps.phy_id (+) and p.phy_id = board_aba.phy_id (+) and p.phy_id = board_abem.phy_id (+) and p.phy_id = board_abfp.phy_id (+) and p.phy_id = board_abim.phy_id (+) and p.phy_id = board_abp.phy_id (+) and p.phy_id = board_abr.phy_id (+) and p.phy_id = board_aobem.phy_id (+) and p.phy_id = board_aobfp.phy_id (+) and p.phy_id = board_aobim.phy_id (+) and p.phy_id = board_aobr.phy_id (+) and p.phy_id = board_other.phy_id (+) and p.phy_id = 1870; well, from my way of thinking, a single record from p.phy_id cannot be equal to all of the others at the same time. so no records should be returned at all. I think I would re-wright the entire mess using a set of UNIONS to accomplish the same thing. something like: select board_other.description strBrdNameOtherTHQuest ,decode(board_aaps.description, null,' ','X') ysnAAPSBoard ,decode(board_aba.description, null,' ','X') ysnABABoard ,decode(board_abem.description, null,' ','X') ysnABEMBoard ,decode(board_abfp.description, null,' ','X') ysnABFPoard ,decode(board_abim.description, null,' ','X') ysnABIMBoard ,decode(board_abp.description, null,' ','X') ysnABPBoard ,decode(board_abr.description, null,' ','X') ysnABRBoard ,decode(board_aobem.description, null,' ','X') ysnAOBEMBoard ,decode(board_aobfp.description, null,' ','X') ysnAOBFPBoard ,decode(board_aobim.description, null,' ','X') ysnAOBIMBAoard ,decode(board_aobr.description, null,' ','X') ysnAOBRBoard ,decode(board_other.description, null,' ','X') ysnOtherBoard from phy_boards pb, boards b, physicians p where p.phy_id = pb.phy_id and pb.board_id = b.board_id and (pb.expiration_date = sysdate or pb.expiration_date is null) and b.description like 'AMERICAN ASSOCIATION OF PHYSICIAN SPECIALIST%' union select board_other.description strBrdNameOtherTHQuest ,decode(board_aaps.description, null,' ','X') ysnAAPSBoard ,decode(board_aba.description, null,' ','X') ysnABABoard ,decode(board_abem.description, null,' ','X') ysnABEMBoard ,decode(board_abfp.description, null,' ','X') ysnABFPoard ,decode(board_abim.description, null,' ','X') ysnABIMBoard ,decode(board_abp.description, null,' ','X') ysnABPBoard ,decode(board_abr.description, null,' ','X') ysnABRBoard ,decode(board_aobem.description, null,' ','X') ysnAOBEMBoard ,decode(board_aobfp.description, null,' ','X') ysnAOBFPBoard ,decode(board_aobim.description, null,' ','X') ysnAOBIMBAoard ,decode(board_aobr.description, null,' ','X') ysnAOBRBoard ,decode(board_other.description, null,' ','X') ysnOtherBoard from phy_boards pb, boards b, physicians p where p.phy_id = pb.phy_id and pb.board_id = b.board_id and (pb.expiration_date = sysdate or pb.expiration_date is null) and b.description like 'AMERICAN BOARD OF ANESTHESIOLOGY%' etc. / Does this make sense? Hope this helps. Tom Mercadante Oracle Certified
Experiences with global temp tables
Hi All, Oracle 8.1.6, NT 4.0, Forms/Reports 6i, Has anyone had any trouble using global temp tables in above environment or elsewhere where it cause Oracle to complete lock up. Only way out was to kill oracle.exe...not a good thing. I have found some postings on MetaLink that may be related supposely fixed in 9i. Comments please! Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
ORA-2083 DATABASE name has illegal character '-'
Hi, Oracle 8.1.6.0.0 NT 4.0 I have the following logon trigger. It works fine as long I insert into local table. If I try to insert into a table across a database link the record get inserted but upon exiting the app whether it is sqlplus,forms,etc I get ora-2083. I think it is probably a bug since I have exact same environment and it works Ok. It fails on 3 other identical environments. Anyone heard of any possible bugs using database link in logon trigger? I search metalink and google but no such reported error. DROP PUBLIC DATABASE LINK utilities_a12345_dblink; CREATE PUBLIC DATABASE LINK utilities_a12345_dblink CONNECT TO utilities IDENTIFIED BY 123x456x USING 'a123456'; GRANT SELECT ON v_$session TO PUBLIC; GRANT SELECT ON v_$instance TO PUBLIC; DROP TRIGGER login_capture; CREATE OR REPLACE TRIGGER login_capture AFTER LOGON ON DATABASE DECLARE CURSOR temp_rec IS SELECT user AS user_name, NVL(UPPER(SUBSTR(osuser,1,30)),'SERVER') AS os_user_name, RTRIM(NVL(SUBSTR(machine,instr(machine,'\') +1,12),'SERVER'),CHR(0)) AS machine_name, sid AS session_id, serial# AS serial_no, SYSDATE AS logon_time, SYS_CONTEXT('userenv','ip_address') AS ip_address, NVL(SUBSTR(program,1,64),'INTERNAL') AS program_name, i.instance_name AS instance_name, i.host_name AS host_name, i.version AS version FROM v$session s,v$instance i WHERE s.username = user AND s.logon_time = (SELECT MAX(x.logon_time) FROM v$session x WHERE x.username = user); BEGIN FOR rec IN temp_rec LOOP INSERT INTO login_history@utilities_itport02_dblink (user_name, os_user_name, machine_name, session_id, serial_no, logon_time, ip_address, program_name, instance_name, host_name, version) VALUES (rec.user_name, rec.os_user_name, rec.machine_name, rec.session_id, rec.serial_no, rec.logon_time, rec.ip_address, rec.program_name, rec.instance_name, rec.host_name, rec.version); END LOOP; EXCEPTION WHEN OTHERS THEN NULL; END; / ALTER TRIGGER login_capture ENABLE; -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: which bind variable value causes ora-1722
It looks like that is bind value 4(gl_id) = 0. How did you determine it is 6.55802? I certainly do not how to read this trace but looks like it is define correctly :element_id, bind 0 :fixed_operand,bind 1 :flags,bind 2 :free_quantity,bind 3 :gl_id,bind 4 value 0 :scaled_operand, bind 5 value 6.55802 :rec_id, :obj_id0 Rick tim@sagelogix. com To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: Re: which bind variable value causes ora-1722 om 12/03/2002 02:21 PM Please respond to ORACLE-L Mike, It is the value in the :gl_id string, which is 6.55802. The column GL_ID is defined as an integer of 38 digits (i.e. NUMBER(38) instead of NUMBER), so there is no room for digits to the right of the decimal... Hope this helps... -Tim Hi, all, My developer continually got ora-1722 when he was installing a new billing system. I used 10046 event to get trace file, but i could not figure out which bind variable value causes the error, here is the part of trace: PARSING IN CURSOR #1 len=229 dep=0 uid=62 oct=2 lid=62 tim=807252370 hv=4084410285 ad='9f31e880' insert into fold_bal_impacts_t ( element_id, fixed_operand, flags, free_quantity, gl_id, scaled_operand, rec_id, obj_id0 ) values ( :element_id, :fixed_operand, :flags, :free_quantity, :gl_id, :scaled_operand, :rec_id, :obj_id0 ) END OF STMT PARSE #1:c=0,e=1,p=0,cr=1,cu=0,mis=1,r=0,dep=0,og=0,tim=80725237 0 BINDS #1: bind 0: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=01 oacfl2=0 size=224 offset=0 bfp=018bacd0 bln=22 avl=03 flg=05 value=250 bind 1: dty=1 mxl=32(01) mal=00 scl=00 pre=00 oacflg=01 oacfl2=10 size=0 offset=24 bfp=018bace8 bln=32 avl=01 flg=01 value=0 bind 2: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=01 oacfl2=0 size=0 offset=56 bfp=018bad08 bln=22 avl=01 flg=01 value=0 bind 3: dty=1 mxl=32(01) mal=00 scl=00 pre=00 oacflg=01 oacfl2=10 size=0 offset=80 bfp=018bad20 bln=32 avl=01 flg=01 value=0 bind 4: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=01 oacfl2=0 size=0 offset=112 bfp=018bad40 bln=22 avl=01 flg=01 value=0 bind 5: dty=1 mxl=32(07) mal=00 scl=00 pre=00 oacflg=01 oacfl2=10 size=0 offset=136 bfp=018bad58 bln=32 avl=07 flg=01 value=6.55802 bind 6: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=01 oacfl2=0 size=0 offset=168 bfp=018bad78 bln=22 avl=01 flg=01 value=0 bind 7: dty=1 mxl=32(05) mal=00 scl=00 pre=00 oacflg=01 oacfl2=10 size=0 offset=192 bfp=018bad90 bln=32 avl=05 flg=01 value=10382 EXEC #1:c=0,e=0,p=0,cr=0,cu=2,mis=0,r=0,dep=0,og=3,tim=80725237 0 ERROR #1:err=1722 tim=807252370 And here is the table: SQLdesc fold_bal_impacts_t NameNull?Type --- OBJ_ID0 NUMBER(38) REC_ID NUMBER(38) ELEMENT_ID NUMBER(38) FIXED_OPERANDNUMBER FLAGSNUMBER(38) FREE_QUANTITYNUMBER GL_IDNUMBER(38) SCALED_OPERAND NUMBER And there is no any constraints on this table. Please help, thanks. Mike -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: mike ding INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services
RE: ORA-2083 DATABASE name has illegal character '-'
Yes I have taken the insert statement out of the logon trigger and it works fine. I think there may be a possible bug with logon trigger using database links. DENNIS WILLIAMS DWILLIAMS@life To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] touch.comcc: Sent by: Subject: RE: ORA-2083 DATABASE name has illegal character '-' [EMAIL PROTECTED] m 12/03/2002 03:14 PM Please respond to ORACLE-L Rick - Have you tested the link itself? Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, December 03, 2002 1:10 PM To: Multiple recipients of list ORACLE-L Hi, Oracle 8.1.6.0.0 NT 4.0 I have the following logon trigger. It works fine as long I insert into local table. If I try to insert into a table across a database link the record get inserted but upon exiting the app whether it is sqlplus,forms,etc I get ora-2083. I think it is probably a bug since I have exact same environment and it works Ok. It fails on 3 other identical environments. Anyone heard of any possible bugs using database link in logon trigger? I search metalink and google but no such reported error. DROP PUBLIC DATABASE LINK utilities_a12345_dblink; CREATE PUBLIC DATABASE LINK utilities_a12345_dblink CONNECT TO utilities IDENTIFIED BY 123x456x USING 'a123456'; GRANT SELECT ON v_$session TO PUBLIC; GRANT SELECT ON v_$instance TO PUBLIC; DROP TRIGGER login_capture; CREATE OR REPLACE TRIGGER login_capture AFTER LOGON ON DATABASE DECLARE CURSOR temp_rec IS SELECT user AS user_name, NVL(UPPER(SUBSTR(osuser,1,30)),'SERVER') AS os_user_name, RTRIM(NVL(SUBSTR(machine,instr(machine,'\') +1,12),'SERVER'),CHR(0)) AS machine_name, sid AS session_id, serial# AS serial_no, SYSDATE AS logon_time, SYS_CONTEXT('userenv','ip_address') AS ip_address, NVL(SUBSTR(program,1,64),'INTERNAL') AS program_name, i.instance_name AS instance_name, i.host_name AS host_name, i.version AS version FROM v$session s,v$instance i WHERE s.username = user AND s.logon_time = (SELECT MAX(x.logon_time) FROM v$session x WHERE x.username = user); BEGIN FOR rec IN temp_rec LOOP INSERT INTO login_history@utilities_itport02_dblink (user_name, os_user_name, machine_name, session_id, serial_no, logon_time, ip_address, program_name, instance_name, host_name, version) VALUES (rec.user_name, rec.os_user_name, rec.machine_name, rec.session_id, rec.serial_no, rec.logon_time, rec.ip_address, rec.program_name, rec.instance_name, rec.host_name, rec.version); END LOOP; EXCEPTION WHEN OTHERS THEN NULL; END; / ALTER TRIGGER login_capture ENABLE; -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services
Re:
I would recommend a restore because you are going to backup for applying a patch anyway RIGHT? Logminer would do nothing as far as the OS files getting overwritten by applying the patch. Rick Scott Stefick sstefick@harper To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] .cc.il.us cc: Sent by: Subject: [EMAIL PROTECTED] 12/03/2002 02:21 PM Please respond to ORACLE-L Gurus, I was just given a project to maintain a Computerized Maintenance Management System. When I asked the companies support staff how to roll back patches in the backend Oracle Database (Ver. 8174), they said that there was no way to do this. I'm guessing I could use logminer just incase a patch doesn't work. Would this be a good solution, or are there other (better) ways of safeguarding myself when it comes to patching? Obviously, I will be applying the patches to a test instance first, but I don't want to have to go back to restore from a backup if the patch causes unexpected issues. TIA! ** Scott Stefick UNIX Systems Administrator Oracle Certified Professional DBA Wm. Rainey Harper College 847.925.6130 ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Stefick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
ora-2083,ora-1256 Urgent
Hi All, I have a down production system on Win NT4,Oracle 8.1.6. I just started getting ora-2083 database name has illegal character '-'. When I try to connect via svrmgrl after setting oracle_sid I get tns-12560 tns protocol adapter error. The other 2 instances work fine. Nothing on MetaLink has been helpful thusfar. Any ideas on how to resolve. Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
tns-12500 unable to start dedicated server process.
I have 3 instances on Oracle 8.1.6,Nt 4. They are all started but on one instance I connect via the listener. The only connection is at the server not using service name. I have the usual plenty of memory,swap,etc. It has been working fine until today. I even stopped the other 2 instances just to give more memory but still fails. The listener.ora has not changed. I have rebooted the server multiple times. Oracle gives me the same old answer increase processes parameter,add more memory,add more swap file,etc. Anyone have any fresh ideas on how to resolve. Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: How to make ORACLE Developer 6i understand ORACLE 8i client?
The developer 6i should have the net8 to install so you can connect to 8.0.5 Rick dist cash mccdba@hotmai To: Multiple recipients of list ORACLE-L l.com[EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: How to make ORACLE Developer 6i understand ORACLE 8i omclient? 11/18/2002 03:13 PM Please respond to ORACLE-L We used ORACLE developer 6i on PC. The ORACLE Developer 6i use ORACLE 8.0.5 client. We don't have ORACLE 8.0.5 client. Does their has way to make ORACLE Developer 6i connect through 8i client? Thanks. _ Tired of spam? Get advanced junk mail protection with MSN 8. http://join.msn.com/?page=features/junkmail -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: dist cash INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
opinions on SAN devices for Oracle
Hi All, We are considering the following 3 SAN storage devices. If anyone can share any info on any I would appreciate it. They all have 2gig fibre channel. Hitachi 9200 EMC CX400 HP EVA 2c2d Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Partitioning
Is there a single column/value that you could do LIST partitioning on instead of range or hash? Rick Rishi.Jain@VerizonWi reless.com To: Multiple recipients of list ORACLE-L Sent by:[EMAIL PROTECTED] [EMAIL PROTECTED] cc: Subject: Partitioning 11/19/2002 02:38 PM Please respond to ORACLE-L We have a table with around 80 million rows. The table has been partitioned by hash as there is no clear way of partitioning depending on range etc.. The data is very unevenly distributed in these partitions. Some of them even have 3 times the number of rows as compared to the other partitions. This application is being ported from Informix to Oracle (9i R2). In informix the dba's had partitioned the table based on a function . He was taking the mod of the number ( dividing by 10 ) . The values were then placed in either of the 10 partitions ranging from 0 - 9. This really gave us very good distribution of data .Can we achieve something similar in 9i with list partitioning. TIA Rishi -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: New development in Cobol or PL/SQL - please help
Babette, If they are a Cobol shop then there is nothing wrong with using Pro*Cobol. I disagree with your statement about using PL/SQL for the business logic. I personally think you should put as much of that in the database. Rick Mercadante, Thomas F To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED][EMAIL PROTECTED] ate.ny.us cc: Sent by: Subject: RE: New development in Cobol or PL/SQL - please [EMAIL PROTECTED]help 11/18/2002 08:03 AM Please respond to ORACLE-L Babette, The decision really comes down to the organization. If they see themselves as *never* leaving the Cobol arena, and they have an ample supply of Cobol programmers, then they should stay with it. What you could do is to make friends with the applications people, and show them how PL/SQL works. What you will find is that they will take to PL/SQL like a fish to water. And pretty soon, more and more PL/SQL packages will be written that are simply called by the Cobol programs. Cobol would then be a simple entry point to the database - able to interface nicely with the operating system (reading and writing flat files, producing reports and forms), while the majority of the logic may be written in PL/SQL. Maybe, just maybe, the person making the decision see's no benefit to using PL/SQL. And given your local labor market, maybe he's right! Tom Mercadante Oracle Certified Professional -Original Message- Sent: Sunday, November 17, 2002 1:18 PM To: Multiple recipients of list ORACLE-L Khedr, Waleed wrote: Cobol! Again!:( -Original Message- Sent: Friday, November 15, 2002 5:24 PM To: Multiple recipients of list ORACLE-L I just found out today that we have a major development initiative that is starting and they are planning on using Pro*Cobol to develop the application. (my head is still shaking in disbelief!!!) So we will have a Java front-end, invoking MQ series that will go across to the mainframe for MQ series to invoke Pro*Cobol programs that will then do the processing (accessing data and doing calculations) and then return data. If anyone has been in this or a similar situation, please help. I need some really good arguments as to why we should put the business logic into PL/SQL instead of Pro*Cobol. I understand the reason we are using Oracle is that the director has 15 years experience with it and loves it. Aaargh!!! thanks Babette May I play the devil's advocate? Even if Pro*Cobol seems to be a weird choice, there may be a case for not coding the logic in PL/SQL : database portability. I have heard recently of a very, very, very big company dumping Oracle in favour of DB2. Reason ? Cost. I guess that in such a case, porting a Pro*Cobol program is easier than PL/SQL. -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services--
Re: set arraysize in Pro*C
I have not done it for a while but look in the precompiler options. There is an option to increase. Rick Govind.Arumugam@ alltel.com To: Multiple recipients of list ORACLE-L Sent by:[EMAIL PROTECTED] [EMAIL PROTECTED] cc: Subject: set arraysize in Pro*C 11/18/2002 11:48 AM Please respond to ORACLE-L Dear List-Members, Some of the batch queries can be improved by increasing the arraysize to 1000 ( the default in SQL*Plus is 15); I would like to find out the equivalent of this in Pro*C programs. Thanks, Govind -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: When will Oracle 10i be out?
Actually what I have heard is that nothing has been published externally. Oracle recommends to contact sales rep on info concerning future releases Rick Wong, Bing bing.wong@Ingram To: Multiple recipients of list ORACLE-L Micro.com [EMAIL PROTECTED] Sent by:cc: [EMAIL PROTECTED]Subject: RE: When will Oracle 10i be out? 11/07/2002 01:33 PM Please respond to ORACLE-L I heard that the white paper has not yet been published internally... -Original Message- Sent: Thursday, November 07, 2002 10:09 AM To: Multiple recipients of list ORACLE-L Has anyone heard when Oracle will be releasing version 10i? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Pall, Tom [Contractor] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Wong, Bing INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Differences between Oracle 9.2.0 EE and SE
I have given up on trying to find document detailing differences between Oracle 9i (9.2.0) EE and SE. Can someone provide a link,etc for this? Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OCP Exams - What to study out of?
The Cloverleaf product I know is from Quovadx. One of its usages it provides an interface between Healthcare systems and Oracle(many other DBMS). For ex. we use to interface with hospitals sending data in standard HL7 format and Cloverleaf interprets HL7 format and data is loaded directly into Oracle for further processing. See http://www.quovadx.com/ for more info Rick [EMAIL PROTECTED] tate.fl.usTo: Multiple recipients of list ORACLE-L Sent by: [EMAIL PROTECTED] [EMAIL PROTECTED] cc: Subject: RE: OCP Exams - What to study out of? 11/05/2002 10:23 AM Please respond to ORACLE-L Guys, anyone know about an application called Cloverleaf? Basically, my organization is pursuing using Cloverleaf as the data integration sole application of choice. To me Unix/SQL*Loader and native tools for the various RDBMS usually are more straightforward and provide simplication and less proprietary coding and it is easier for an organization to find others who have those type of skills. Any ideas guys? -Original Message- Sent: Tuesday, November 05, 2002 9:18 AM To: Multiple recipients of list ORACLE-L Denham, I have just passed my 8i upgrade exam and added some notes to a page about getting OCP certification. It can be accessed on http://www.hcresources.co.uk/ocp.htm http://www.hcresources.co.uk/ocp.htm Hope you find it interesting John -Original Message- Sent: 05 November 2002 12:09 To: Multiple recipients of list ORACLE-L Hello Everyone, 1. I have now made the humungous decision to start studying and to write the OCP exams. 2. Do I study out of the Oracle Manuals? 3. I do have the Sybex Study Guides, would studying these be all that is needed? 4. Or do the questions come out of the Course material ( Which I have not attended ). 5. I do have some of the Oreilly Insect Books - would these be any help? Any views, opinions etc appreciated. Regards Denham Eva Oracle DBA UNIX is basically a simple operating system, but you have to be a genius to understand the simplicity. Dennis Ritchie. _ DISCLAIMER This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. TFMC, its holding company, and any of its subsidiaries each reserve the right to monitor and manage all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be views of any such entity. _ _ This e-mail message has been scanned for Viruses and Content and cleared by MailMarshal - For more information please visit http://www.marshalsoftware.com www.marshalsoftware.com _ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City
Data modeling question
I was reading one of the papers on the quest website about data modeling. An example was presented and I did not believe the results so I tried it out. Of course the writer ( Phd) was correct. Does anyone know why does not enforce RI constraint if any of the foreign key colums are NULL. I took it literally that if I insert any record in table_2 that a corresponding record must be in the parent(table_1). Apparently this is not so. Someone please explain. Thanks Rick drop table table_2; drop table table_1; create table table_1 ( a number not null, b number not null, c number, constraint table_1_pk primary key (a,b)); create table table_2 ( a number, b number, d number not null, e number not null, f number, constraint pk_table_2 primary key (d,e), constraint fk_table_2_reference_table_1 foreign key (a,b) references table_1 (a,b)) / insert into table_2 values(1,NULL,3,4,5); 1 row processed. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Data modeling question
Jared, Yeah, It may be just a design issue but not quite sure. I was referencing from a document Data Modeling: It's Really All About the Relationships by Dr. Bert Scalzo of Quest Software. Data modeling is part of the conceptual design phase. When speaking of the E-R methodology, the data model produces 1. E-R diagram which represents the data structures in some type of graphical form. The second component is the data document which details the data objects, relationships, and database rules. Here is where I think it could be argued both a modeling/design issue. I certainly see some merit in your reasoning. I agree the use of surrogate keys would prevent this. I do not know why this was not mentioned by the author. Rick Jared.Still@ra disys.comTo: Multiple recipients of list ORACLE-L Sent by: [EMAIL PROTECTED] [EMAIL PROTECTED] cc: om Subject: Re: Data modeling question 10/30/2002 01:05 PM Please respond to ORACLE-L Rick, This doesn't actually have anything to do with data modeling, but rather, database design. The FK can't be enforced on a multipart key if one of the columns is null, obviously. At least, I *think* it's obvious. What happen when you try to update column b in table 2 with a valid value? with and invalid value? There's a good case here for using surrogate keys, as always. That way, invalid values cannot be put in an FK column, since there is only one column needed to reference the foreign PK. Jared [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/30/2002 08:08 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Data modeling question I was reading one of the papers on the quest website about data modeling. An example was presented and I did not believe the results so I tried it out. Of course the writer ( Phd) was correct. Does anyone know why does not enforce RI constraint if any of the foreign key colums are NULL. I took it literally that if I insert any record in table_2 that a corresponding record must be in the parent(table_1). Apparently this is not so. Someone please explain. Thanks Rick drop table table_2; drop table table_1; create table table_1 ( a number not null, b number not null, c number, constraint table_1_pk primary key (a,b)); create table table_2 ( a number, b number, d number not null, e number not null, f number, constraint pk_table_2 primary key (d,e), constraint fk_table_2_reference_table_1 foreign key (a,b) references table_1 (a,b)) / insert into table_2 values(1,NULL,3,4,5); 1 row processed. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB
Re: [Q] what kind of documents shoud contractor provide to me before
I suspect the contractor will only provide the documents all parties agreed to be delivered at completion. Deliverables are part of the contract and require a considerable amount of effort. If your company did not account for this my guess is to document it in your lessons learned. Mark Richard mrichard@transurb To: Multiple recipients of list ORACLE-L an.com.au[EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: Re: [Q] what kind of documents shoud contractor provide to me before 10/28/2002 06:18 PM Please respond to ORACLE-L I agree with the others... Asking a contractor for a pile of documentation at the end of the project may or may not be well accepted... If he's paid by the hour he may not mind, if it was fixed price then he may develop a hearing problem. Having said that... If you do have the luxury of naming documents then I would suggest a capacity plan that includes both initial sizing and growth estimates broken down to a good level of detail. It amazing how often people don't even consider this when building an application with a tiny amount of test data. hth, Mark paquette stephane stephane_paquette@ To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] yahoo.comcc: Sent by: Subject: Re: [Q] what kind of documents shoud contractor provide to [EMAIL PROTECTED] me before project end? 29/10/2002 09:18 Please respond to ORACLE-L The list of documents should have been established before the contract was signed. A professionnal contractor would have told you that. The contractor must follow your methodology and give you the same documents as your internal IT teams. On the DBA side, you should expect : database architecture, logical data model, physical data model, naming convention, backup and recovery guide, security guide, a benchmarking document (if some benchmarking was done). --- dist cash [EMAIL PROTECTED] a écrit : We have a application use ORACLE 8.1.6 and Forms 6i. This project going to finish soon. Can anyone tell me what kind of documents should contractor provide to us before they leave? Thanks. _ Protect your PC - get McAfee.com VirusScan Online http://clinic.mcafee.com/clinic/ibuy/campaign.asp?cid=3963 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: dist cash INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Stéphane Paquette DBA Oracle et DB2, consultant entrepôt de données Oracle and DB2 DBA, datawarehouse consultant [EMAIL PROTECTED] __ Lèche-vitrine ou lèche-écran ? magasinage.yahoo.ca -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services
Re: Adhoc queries and limiting the amount of records queried...
You could implement FGAC or create views that only contains necessary records. Rick Grabowy, Chris To: Multiple recipients of list ORACLE-L cgrabowy@fcg.[EMAIL PROTECTED] com cc: Sent by: Subject: Adhoc queries and limiting the amount of [EMAIL PROTECTED]records queried... om 10/29/2002 02:29 PM Please respond to ORACLE-L I just wanted to ping the list to see what other people have done to control or constrain adhoc query users??? We have a group that is struggling with the adhoc query piece that's in production. Some of the users end up firing off insane queries. The group is trying to find a way to limit the amount of records queried for, so that a wild query doesn't hose the database. Appending a ROWNUM to the WHERE clause is one idea. Using USER PROFILEs is another. Any other thoughts?? Dare I ask?this custom app also runs on SQL Server, so SQL Server ideas would also be appreciated. Many thanks!!! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: BUG 2632931 on 9.2.0.2
native_threads process associated with 9.2.0 OEM OMS is leaking memory. Process starts out about 8 MB and keeps growing. Up to 28.93 MB after less than 1 hour. Workaround: None Jesse, Rich Rich.Jesse@qti To: Multiple recipients of list ORACLE-L world.com [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: BUG 2632931 on 9.2.0.2 m 10/28/2002 11:58 AM Please respond to ORACLE-L Hey all, Looking at doc 189908.1 on MetaLink (it's been much better lately, so no MetaClink for now), I see that patches for 9.2.0.2 on all platforms have an alert for BUG 2632931. Of course, I don't have access to info on that bug. Anyone? As an alert I would expect something serious. Then again, I would expect to be able to view serious issues. TIA, Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Suggestions solicited - Change Column Datatype from Number to
The user stated they were using 8.1.7.1 :) Rachel Carmichael To: Multiple recipients of list ORACLE-L wisernet100@y[EMAIL PROTECTED] ahoo.comcc: Sent by: Subject: RE: Suggestions solicited - Change Column [EMAIL PROTECTED]Datatype from Number to om 10/24/2002 08:38 PM Please respond to ORACLE-L 9i -- dbms_redefinition should do it for you :) --- DENNIS WILLIAMS [EMAIL PROTECTED] wrote: Yeah, well the developers are always pi$$ed about something anyway. ;-) Seriously, good point, I've been spoiled, because most of my applications have kept the RI in the application as was being discussed earlier. Now they are switching to Java and in future projects will be implementing RI in Oracle, so I'll have to be more careful about that. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, October 24, 2002 4:18 PM To: Multiple recipients of list ORACLE-L to Dennis, That's a good thought, and it works if you don't have grants, constraints or dependencies on the original table. If you drop table1, you lose them all Rachel --- DENNIS WILLIAMS [EMAIL PROTECTED] wrote: Deepak, If there are many columns on these tables, your method may be best. However, this will generate a lot of redo. You can usually accomplish this with a CTAS nologging, which won't generate redo. If you really don't want to change the location, you can: create table temp as select * from table1 nologging drop table table1 create table table1 (column, column . . . ) as select * from temp nologging drop table temp Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, October 24, 2002 3:15 PM To: Multiple recipients of list ORACLE-L We have a need to change the datatype of several columns in a table from number to varchar2. Most of the rows have data in these columns hence a direct 'alter table ...' will not work. We plan to create a temp table, move the data from these colums to that table, modify the column datatype from number to varchar2 and then update the colums with the data that was moved to the temp table. Any suggestions/comments or a better way to do this ? Oh, and we are on 8.1.7.1 thanx deepak -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? Y! Web Hosting - Let the expert host your web site http://webhosting.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message
RE: Suggestions solicited - Change Column Datatype from Number to
Ooops!!! I missed where the thread changed from 8i to 9ig Rachel Carmichael To: Multiple recipients of list ORACLE-L wisernet100@y[EMAIL PROTECTED] ahoo.comcc: Sent by: Subject: RE: Suggestions solicited - Change Column [EMAIL PROTECTED]Datatype from Number to om 10/25/2002 10:28 AM Please respond to ORACLE-L yes I know, which is why I did not suggest it to the original poster. Dennis was talking about *his* future projects, which is why I suggested it for him --- [EMAIL PROTECTED] wrote: The user stated they were using 8.1.7.1 :) Rachel Carmichael To: Multiple recipients of list ORACLE-L wisernet100@y[EMAIL PROTECTED] ahoo.comcc: Sent by: Subject: RE: Suggestions solicited - Change Column [EMAIL PROTECTED]Datatype from Number to om 10/24/2002 08:38 PM Please respond to ORACLE-L 9i -- dbms_redefinition should do it for you :) --- DENNIS WILLIAMS [EMAIL PROTECTED] wrote: Yeah, well the developers are always pi$$ed about something anyway. ;-) Seriously, good point, I've been spoiled, because most of my applications have kept the RI in the application as was being discussed earlier. Now they are switching to Java and in future projects will be implementing RI in Oracle, so I'll have to be more careful about that. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, October 24, 2002 4:18 PM To: Multiple recipients of list ORACLE-L to Dennis, That's a good thought, and it works if you don't have grants, constraints or dependencies on the original table. If you drop table1, you lose them all Rachel --- DENNIS WILLIAMS [EMAIL PROTECTED] wrote: Deepak, If there are many columns on these tables, your method may be best. However, this will generate a lot of redo. You can usually accomplish this with a CTAS nologging, which won't generate redo. If you really don't want to change the location, you can: create table temp as select * from table1 nologging drop table table1 create table table1 (column, column . . . ) as select * from temp nologging drop table temp Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, October 24, 2002 3:15 PM To: Multiple recipients of list ORACLE-L We have a need to change the datatype of several columns in a table from number to varchar2. Most of the rows have data in these columns hence a direct 'alter table ...' will not work. We plan to create a temp table, move the data from these colums to that table, modify the column datatype from number to varchar2 and then update the colums with the data that was moved to the temp table. Any suggestions/comments or a better way to do this ? Oh, and we are on 8.1.7.1 thanx deepak -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services