Help need
Title: Help need HI DBA Guru's I wanted to know all the Index names under respective table spaces For example Tablespace is Production Table name : customer, item, supplier index Names idx_customer_custid idx_customer_name idx_item_itemid idx_item_name idx_supplier_itemid idx_supplier_name Tablespace is Quality Table name : customer, item, supplier index Names idx_customer_custid idx_customer_name idx_item_itemid idx_item_name idx_supplier_itemid idx_supplier_name Tablespace is Development Table name : customer, item, supplier index Names idx_customer_custid idx_customer_name idx_item_itemid idx_item_name idx_supplier_itemid idx_supplier_name with warm regards, Deewaker G. V. Baazee.com India Pvt. Ltd. (: 4611323 Extn: 216 Fax : 4611324 Deewaker G.V..vcf Deewaker G.V..vcf
2 queries
Dear Fellow DBA's, I have 2 queries. Query 1 I have a development database Oracle 816 under winNT. I tried to connect as sysdba. But it is giving insuffient privileges. When I queried the v$pwfile_users table, there are no rows selected. how can I add users to it. I tried recreating passwordfile. But the same problem. Query 2 I had a test database 8.1.7 under WinNT. Due to some reasons I had to reload NT and also Oracle. But I loaded Oracle 8.1.6. I had my database intact. I shutdown the database before reloading NT. To my surprise I created the service and started the db and found working. Can anyone tell me how this can happen. TIA Venkat Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: C.S.Venkata Subramanian INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Imp problem
hi, I have an export with WE8DEC, and i want do a full import on a database With WE8ISO8859P1 character set. But avery time i do it a have a problem when he want to create indexes with: ORA-01115: erreur E/S en lecture de blocs a partir du fic. 9 (bloc # 13) ORA-01110: fichier de donnJes 9: 'file' ORA-07372: sfrfb: erreur de lecture, lecture impossible du bloc demandJ du fich de BDD. HP-UX Error: 14: Bad address is this a bug of oracle ??? Oracle 7.3.4.0.0 HP-UX 10.20 thanks in advance -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Djaroud Salim INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Help need
Deewaker, information you find with this select-stmt, perhaps you need to format the output. Depending on what you're looking for you should select either from the view: user_indexes all_indexes dba_indexes select table_name, index_name, tablespace_name from user_indexes group by table_name, index_name, tablespace_name; TGIF Stephan -Original Message- Sent: Friday, July 27, 2001 10:50 AM To: Multiple recipients of list ORACLE-L HI DBA Guru's I wanted to know all the Index names under respective table spaces For example Tablespace is Production Table name : customer, item, supplier index Names idx_customer_custid idx_customer_name idx_item_itemid idx_item_name idx_supplier_itemid idx_supplier_name Tablespace is Quality Table name : customer, item, supplier index Names idx_customer_custid idx_customer_name idx_item_itemid idx_item_name idx_supplier_itemid idx_supplier_name Tablespace is Development Table name : customer, item, supplier index Names idx_customer_custid idx_customer_name idx_item_itemid idx_item_name idx_supplier_itemid idx_supplier_name with warm regards, Deewaker G. V. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?Q?J=E4ck_Stephan?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Help need
Title: Help need Hi deewakar, hope this will help.. SELECT TABLESPACE_NAME,TABLE_NAME,INDEX_NAME FROM DBA_INDEXESORDER BY 1,2,3/ Saurabh Sharma Oracle DBA [EMAIL PROTECTED]http://www.geocities.com/saurabh00pc/stride.html - Original Message - From: Deewaker G.V. To: Multiple recipients of list ORACLE-L Sent: Friday, July 27, 2001 2:20 PM Subject: Help need HI DBA Guru's I wanted to know all the Index names under respective table spaces For example Tablespace is Production Table name : customer, item, supplier index Names idx_customer_custid idx_customer_name idx_item_itemid idx_item_name idx_supplier_itemid idx_supplier_name Tablespace is Quality Table name : customer, item, supplier index Names idx_customer_custid idx_customer_name idx_item_itemid idx_item_name idx_supplier_itemid idx_supplier_name Tablespace is Development Table name : customer, item, supplier index Names idx_customer_custid idx_customer_name idx_item_itemid idx_item_name idx_supplier_itemid idx_supplier_name with warm regards, Deewaker G. V. Baazee.com India Pvt. Ltd. (: 4611323 Extn: 216 Fax : 4611324 Deewaker G.V..vcf
ORACLE8i cc compiler on SOLARIS
hello GURU DBAs i would like to know if cc compiler is required for installing ORACLE 8i on Solaris 2.6 or is the gcc compiler required? regards '_-_'_-_'_-_'_-_'_-_'_-_'_-_'_-_'_-_' Omar Khalid Software Engineer LMK Resources Voice: 111-101-101*780 Mobile: 0333-510-4465 Web: www.lmkr.com '_-_'_-_'_-_'_-_'_-_'_-_'_-_'_-_'_-_' -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: ORACLE8i cc compiler on SOLARIS
Hi, If u are compiling any Pro*C programs then u need 'cc' compiler. For normal installation 'gcc' compiler is good enough. HTH Venkat -- On Fri, 27 Jul 2001 03:00:27 okhalid wrote: hello GURU DBAs i would like to know if cc compiler is required for installing ORACLE 8i on Solaris 2.6 or is the gcc compiler required? regards '_-_'_-_'_-_'_-_'_-_'_-_'_-_'_-_'_-_' Omar Khalid Software Engineer LMK Resources Voice: 111-101-101*780 Mobile: 0333-510-4465 Web: www.lmkr.com '_-_'_-_'_-_'_-_'_-_'_-_'_-_'_-_'_-_' -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: C.S.Venkata Subramanian INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle pricing
Someone mentioned a site licence in their post. I did not know Oracle do site licences, a sales rep told me they didn't. Is this still the case?. My experience of local area sales folk is that they don't seem to be too concerned about business. They are so slllooo at responding to RFIs etc. Is there an independent source for checking out licence options?. If there are any Oracle certified partners out there in Ireland lurking about contact me back channel to make yourself known to me, though I'm not promising any business. I don't know who you are yet 'cos I'm still waiting for a list of you from Oracle!!! As for the audit gig, what annoys me is that when we buy a licence we get demands to pay invoice for same pronto but we don't get any confirmation of the licence any other way. It seems to be on a database somewhere or other but I don't know if I should have a piece of paper for same with a specific licence number, start date and expiriation date of licence, licence type, support terms etc. I can hear echos of team music to SHAFT... =:-0 Sean :) Rookie Data Base Administrator Oracle 7.3.3, 8.0.5, 8.1.7 - NT, W2K [0%] OCP Oracle8i DBA [0%] OCP Oracle9i DBA Organon (Ireland) Ltd. E-mail: [EMAIL PROTECTED] [subscribed: Digest Mode] Visit: http://groups.yahoo.com/group/Oracle-OCP-DBA Nobody loves me but my mother... and she could be jivin' too. - BB King -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Solaris Release Vs. Version
hi dba's can any body tell me the difference between the release and version of Sun solaris. i am working on solaris platform. when i login to the server, i get prompt Sun 5.7 where the version is 2.6 what is the difference between these 2? prasad. __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: prasad maganti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Year of Unix file
Hi dba's when i list the unix file (solaris), with ls -lt command , i am able to see the time, month, date that is created. is there any way to see the year that is created. any commands prasad. __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: prasad maganti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Rollback seg for big job
Hi dba's can anybody clarify my doubt reg. RBS. i need to run a very big job in night times. so , i have to create a very bigh rollback segment purely intended for that job. so i will set at sql set trnx use rollback seg.. my doubt is whether this rollback segment stores the rollback of my job or will it allow any other rollback of the database (that is not part of my job) prasad. __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: prasad maganti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
ORA-21560 when trying to use the dbms_lob.loadfromfile function
Hello list,
I get this error, working with the dbms_lob package.
(NT4, oracle 8.1.7)
This is the sequence of steps I have followed:
CREATE OR REPLACE DIRECTORY DIRECT_IMAGEN AS 'E:\DIRECT_IMAGEN';
CREATE OR REPLACE PROCEDURE insert_image
AS
file BFILE;
lob BLOB;
BEGIN
insert into t_image (id, image_lob) VALUES (5, EMPTY_BLOB())
return image_lob into lob;
file:=bfilename('DIRECT_IMAGEN','foto1.gif');
dbms_lob.fileopen(file, dbms_lob.file_readonly);
dbms_output.put_line(dbms_lob.getlength(lob));
dbms_lob.loadfromfile(lob, file, dbms_lob.getlength(lob));
dbms_lob.fileclose(file);
commit;
exec insert_image;
ORA-21560: argument 3 null, not valid or out of range.
The third argument is the length of the image, which is equal
to 0.
The directory is in the local machine, as well as the image,
and this machine is the database server.
The user has read privileges on this directory,
What am I doing wrong? A lot of thanks.
begin:vcard
n:Jimenez;Beatriz Martinez
x-mozilla-html:FALSE
org:Fundación CIDAUT;Departamento de Informática
adr:;;Parque Tecnológico de Boecillo p.209;Boecillo;Valladolid;47151;Spain
version:2.1
email;internet:[EMAIL PROTECTED]
title:Ingeniera Informática
fn:Beatriz Martínez Jiménez
end:vcard
Re: severe lib cache contention - how did i solve it
u did not have to do that the timed_statistics and sql_trace if set to false will do the job From: Rahul [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: severe lib cache contention - how did i solve it Date: Thu, 26 Jul 2001 22:35:34 -0800 list, i increased the kgl latches to 11 (from 3) and switched OFF the timed statistics and all the waits for lib cache and shared pool latch are gone !! thanks for pointing me to the timed statistic bug.. (i dont know how much the kgl parameter helped though) regards Rahul -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ARUN K C INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ORACLE8i cc compiler on SOLARIS
encoded content removed -- binaries not allowed by ListGuru The previous attachment was filtered out by the ListGuru mailing software at fatcity.com because binary attachments are not appropriate for mailing lists. If you want a copy of the attachment which was removed, contact the sender directly and ask for it to be sent to you by private E-mail. This warning is inserted into all messages containing binary attachments which have been removed by ListGuru. If you have questions about this message, contact [EMAIL PROTECTED] for clarification. winmail.dat
Re: Year of Unix file
when i list the unix file (solaris), with ls -lt command , i am able to see the time, month, date that is created. is there any way to see the year that is created. The 8th field of ls -lt indicates the hour if the file was created in the current year, otherwise it indicates the year. ciao carlo -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Carlo Vaccari INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Rollback seg for big job
Prasad: As far as I know (and listers please correct me if I'm wrong) you can't single out the rollback segment you are using for that big transaction EXCLUSIVELY. In other words, since the rbs is still online and available, there is still the potential that another transaction could use that rbs as well. However, if you're running it at night, wouldn't your activity level be lower and thus the odds of getting another transaction in the same rbs be much lower as well? Just my 2 cents. Jon Walthour --- Original Message --- From: prasad maganti [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: 7/27/01 7:16:11 AM Hi dba's can anybody clarify my doubt reg. RBS. i need to run a very big job in night times. so , i have to create a very bigh rollback segment purely intended for that job. so i will set at sql set trnx use rollback seg.. my doubt is whether this rollback segment stores the rollback of my job or will it allow any other rollback of the database (that is not part of my job) prasad. __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: prasad maganti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jon Walthour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Solaris Release Vs. Version
There is probably something wrong or it is truly 2.7. 2.6 is Version 6 of Solaris 2.7 is Version 7 of Solaris They are completely different versions. Nothing about them is similar in terms of release. Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Friday, July 27, 2001 7:11 AM To: Multiple recipients of list ORACLE-L hi dba's can any body tell me the difference between the release and version of Sun solaris. i am working on solaris platform. when i login to the server, i get prompt Sun 5.7 where the version is 2.6 what is the difference between these 2? prasad. __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: prasad maganti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OT: Oracle pricing
That was exactly what happened to us. They said they wanted to schedule a time to come in and do an audit. My boss was nervous because we had learned recently that we were out of compliance with our licensing. So he did negotiate with them at that point. He was happy because they cut him a good deal - although we realized later that the contract only covered 8i. It is going to cost us extra to upgrade to 9i. Has anyone had that happen to them? Where it was extra cost to license the move from 8i to 9i on the Enterprise Edition of the server? Cherie Machler Oracle DBA Mercadante, Thomas F To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] [EMAIL PROTECTED]cc: ate.ny.us Subject: RE: OT: Oracle pricing Sent by: [EMAIL PROTECTED] 07/26/01 02:41 PM Please respond to ORACLE-L Dick, they suggested that they might be coming around to perform an audit! Are you serious? They actually said they wanted to do this? Sounds like they've been watching the Soprano's! If this isn't extortion, I don't know what is! I hope you kicked their rooty-tooty asses out of your office and told them not to come back! Next thing you know, you'll get a wrapped package delivered containing burnt-out disk-drives. Old Oracle Message - your support person had a head crash Tom Mercadante Oracle Certified Professional -Original Message- Sent: Thursday, July 26, 2001 2:02 PM To: Multiple recipients of list ORACLE-L Lisa, I've not experienced that particular behavior from the Oracle sales droids. But, we did have ours in yesterday (new droids wanting to put faces to names) and since Oracle's revenues are down they suggested that they might be coming around to perform an audit! Now that I think is a heavy handed way of pumping up the revenue stream. Guess I'd better learn DB2!! Dick Goulet Reply Separator Author: Koivu; Lisa [EMAIL PROTECTED] Date: 7/26/2001 7:47 AM Has anyone experienced Oracle sales people gouging each other? Seems like they are getting pretty cut throat. I got one quote for $400,000, and a second quote for less than 25% of that, from two different people. WOW. They are beginning to sound like the company I work for - different story from different people. Lisa Koivu Oracle Database Administrator 954-935-4117 The information in the electronic mail message is Cendant confidential and may be legally privileged, it is intended solely for the addressee(s) access to this internet electronic mail message by anyone else is unauthorized. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it is prohibited and may be unlawful. The sender believes that this E-mail and any attachments were free of any virus, worm, Trojan horse, and/or malicious code when sent. This message and its attachments could have been infected during transmission. By reading the message and opening any attachments, the recipient accepts full responsibility for taking protective and remedial action about viruses and other defects. Cendant Corporation or Affiliates are not liable for any loss or damage arising in any way from this message or its attachments. !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 3.2//EN HTML HEAD META HTTP-EQUIV=Content-Type CONTENT=text/html; charset=US-ASCII META NAME=Generator CONTENT=MS Exchange Server version 5.5.2653.12 TITLEOracle pricing/TITLE /HEAD BODY PFONT
Re: Rollback seg for big job
prasad. In order to insure that your job is the only one using it or as closely as possible, keep the RBS in the offline mode until you need it. Then make the RBS online, issue your job, and make the RBS offline. The job will continue to use the RBS and other jobs will see that it is offline and not be allowed to use it. ROR mª¿ªm [EMAIL PROTECTED] 07/27/01 07:16AM Hi dba's can anybody clarify my doubt reg. RBS. i need to run a very big job in night times. so , i have to create a very bigh rollback segment purely intended for that job. so i will set at sql set trnx use rollback seg.. my doubt is whether this rollback segment stores the rollback of my job or will it allow any other rollback of the database (that is not part of my job) prasad. __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: prasad maganti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: severe lib cache contention - how did i solve it
now i have another question the app is using literals all the time...shouldn;t the DB be showing lib cache latch contention ?? -- From: ARUN K C[SMTP:[EMAIL PROTECTED]] Reply To: [EMAIL PROTECTED] Sent: Friday, July 27, 2001 6:45 PM To: Multiple recipients of list ORACLE-L Subject: Re: severe lib cache contention - how did i solve it u did not have to do that the timed_statistics and sql_trace if set to false will do the job From: Rahul [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: severe lib cache contention - how did i solve it Date: Thu, 26 Jul 2001 22:35:34 -0800 list, i increased the kgl latches to 11 (from 3) and switched OFF the timed statistics and all the waits for lib cache and shared pool latch are gone !! thanks for pointing me to the timed statistic bug.. (i dont know how much the kgl parameter helped though) regards Rahul -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ARUN K C INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: RAC/OPS changes
[EMAIL PROTECTED] wrote: Well you asked for this. Don't read this if you are faint of heart and weak of mind. ORA-99 : Brain Overload.;-) this one i'll save and keep rereading until it makes sense. thanks. -- Bill Shrek Thater Certifiable ORACLE DBA Telergy, Inc.[EMAIL PROTECTED] ~~ You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. ~~ If a program is useful, it must be changed. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thater, William INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Securing passwords in scripts
me too. NT and unix , thank you paquette stephane wrote: Me too. On unix and NT --- Stephane Faroult [EMAIL PROTECTED] a écrit : O'Neill, Sean wrote: I have some scripts, O.S. command and SQL, which I use to perform COLD backups of DBs and other tasks. I'm not particularily happy about having username/password information in the scripts. Has anyone come up with a way to avoid same allowing for the fact the scripts should require no user input to execute. Sean :) I swear by externally identified accounts. -- Regards, Stephane Faroult Oriole Corporation -- http://www.oriolecorp.com, designed by Oracle DBAs for Oracle DBAs -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Vos albums photos en ligne, Yahoo! Photos : http://fr.photos.yahoo.com -- 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 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). begin:vcard n:Açýkgöz;Bülent tel;fax:+903122101120 tel;work:+903122103382 x-mozilla-html:FALSE org:Middle East Technical University;Computer Center adr:;;Balgat;ANKARA;;06531;TURKIYE version:2.1 email;internet:[EMAIL PROTECTED] fn:Bülent Açýkgöz end:vcard
OT RE: Dangerous AIX Bug!
:-))) -Original Message- Sent: Thursday, July 26, 2001 11:10 PM To: Multiple recipients of list ORACLE-L I am working on my husband to put one in the freezer now. I am sure he will. As soon as we do I will send you a pricelist. I am looking for a cheap supply of styrofoam coolers. I can get the dry ice nearby so were all set except for the beef. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, July 26, 2001 4:37 PM :) My biggest concern is porting db's from other unix flavors...i wish there were a cross platfrom shell porting guide. Sure, ls is ls, but every mfgr changes the order/formatting of the flags and/or output. I am compiling responses and will post a summary. I have some good stuff so far hth Ross p.s. I wish i could get some (mostly) grass fed beef! ;-) -Original Message- Sent: Thursday, July 26, 2001 3:56 PM To: Multiple recipients of list ORACLE-L Hey Guys, I want in on this discussion too. We are running 8.0.6.3 but we are getting 2 new AIX boxes and will have the option of using 64-bit. Please include me in any of this discussion. Thanks! Ruth B. Gramolini ORACLE DB2 DBA VT Dept. of Taxes ph# 802.828.5708 fax# 802.828..3754 [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, July 26, 2001 2:16 PM Ross, we are also running AIX 4.3.3 with a mix of 8.0.5.2.1 and 8.1.7 databases, headed to all 8.1.7. We are mostly running S80s here. Just shoot me a note and we'll talk. John D. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
9i for AIX available now
Hi, 9i for AIX (64 Bit) is now available on technet. Could (successfully :-) ) download it in about 4 hours (~ 2,5 GB) Greetings, Harald -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
OT Rosetta Stone
Yea, I wrote to the webmeister, telling him he was a god. He chuckled and said no, just your humble editor. But he said it in twenty-three languages! :-D -Original Message- Sent: Thursday, July 26, 2001 8:46 PM To: Multiple recipients of list ORACLE-L this is amazingly wonderful. heartfelt thanks! From: Mohan, Ross [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Dangerous AIX Bug! Date: Thu, 26 Jul 2001 14:16:17 -0800 OH MY GOD. that is s useful! A blessing on your family, your family's family, and your family's family's family. Oh hell, throw in a beer for yourself. thanks, Ross -Original Message- Sent: Thursday, July 26, 2001 4:52 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Ross, Check this link. You may find it useful. http://home.earthlink.net/~bhami/rosetta.html Regards, Denny Mohan, Ross wrote: :) My biggest concern is porting db's from other unix flavors...i wish there were a cross platfrom shell porting guide. Sure, ls is ls, but every mfgr changes the order/formatting of the flags and/or output. I am compiling responses and will post a summary. I have some good stuff so far hth Ross p.s. I wish i could get some (mostly) grass fed beef! ;-) _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: [Q] exp from 8.1.7 and import to 8.1.6?
I just did this myself on Solaris. You don't need to change the views, just use the exp utility from 8.1.6. on the 8.1.7 database. I had to do a 8.1.6 install on another machine to get the utility. There is a good matrix on Metalink that shows the version compatibilities. Sincerely, Woody -Original Message- Sent: Thursday, July 26, 2001 5:51 PM To: Multiple recipients of list ORACLE-L Thank you for your answer. Can you tell me how to make it work? Thanks. From: Tirumala, Surendra [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: [Q] exp from 8.1.7 and import to 8.1.6? Date: Thu, 26 Jul 2001 10:16:15 -0800 NO. -Original Message- Sent: Thursday, July 26, 2001 10:56 AM To: Multiple recipients of list ORACLE-L I just upgrade ORACLE from 8.1.6 to 8.1.7 (SUn Solaris). My question is can I export from 8.1.7 and bring the dump file import into 8.1.6 ORACLE server? Thanks. _ Get your FREE download of MSN Explorer at http://explorer.msn.com http://go.msn.com/bql/hmtag_itl_EN.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ef 8454 INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tirumala, Surendra INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ef 8454 INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Woody McKay INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Rollback seg for big job
well.. you could sort of help to guarantee that no one else uses it. First, bring it online, do a set transaction to use that rollback segment, then (in another session), take that rollback segment offline. since you are already using it, it doesn't REALLY go offline (until your transaction ends) but no one else will be assigned to it either. Sneaky. Rachel From: Jon Walthour [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Rollback seg for big job Date: Fri, 27 Jul 2001 04:51:09 -0800 Prasad: As far as I know (and listers please correct me if I'm wrong) you can't single out the rollback segment you are using for that big transaction EXCLUSIVELY. In other words, since the rbs is still online and available, there is still the potential that another transaction could use that rbs as well. However, if you're running it at night, wouldn't your activity level be lower and thus the odds of getting another transaction in the same rbs be much lower as well? Just my 2 cents. Jon Walthour --- Original Message --- From: prasad maganti [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: 7/27/01 7:16:11 AM Hi dba's can anybody clarify my doubt reg. RBS. i need to run a very big job in night times. so , i have to create a very bigh rollback segment purely intended for that job. so i will set at sql set trnx use rollback seg.. my doubt is whether this rollback segment stores the rollback of my job or will it allow any other rollback of the database (that is not part of my job) prasad. __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: prasad maganti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jon Walthour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RAC/OPS changes
Scott, Thanks for the info, but aside from the somewhat fleshy last paragraph, there's not much meat here. It sounds rather like an Oracle marketing piece. For instance, do you have any pointers or further information on the 27 patents you mentioned? Don't get me wrong: thanks for the effort behind the post, but.there's not much to chew on there -Original Message- Sent: Thursday, July 26, 2001 7:46 PM To: Multiple recipients of list ORACLE-L Well you asked for this. Don't read this if you are faint of heart and weak of mind. Oracle9i Real Application Clusters is the next evolutionary step up from Oracle Parallel Server, and is the result of more than 6 years of development, 9 patents, and 18 additional patents pending. Oracle9i Real Application Clusters are unique in that they provide: Out-of-the-box, near-linear scaling transparency Compatibility with all applications, with no redesign required Fast growth clusters, the ability to rapidly add nodes and disk Based on Oracle's Cache Fusion architecture, Oracle9i Real Application Clusters provide transparent application scalability by quickly and efficiently sharing frequently accessed data across all the servers in a cluster, resolving all manners of contention between servers in the process. In the Cache Fusion architecture, read requests may be served by any of the memory caches in the cluster database. In cases where data is being updated, coordination between the caches of each server becomes necessary so that both the data being read and the data being updated are consistent and correct. If the query request is served by a remote cache, then the block is transferred across the high speed cluster interconnect from one node's cache to another. This fusing of the caches happens automatically and is transparent to the application. This transparency is the key technology that provides the fast, efficient scaling of Oracle9i Real Application Clusters. I warned ya, Scott [via Oracle-L digest] From: Don Granaman [EMAIL PROTECTED] Date: Wed, 25 Jul 2001 22:29:47 -0500 Subject: Re: (Fwd) Re: Oracle 8i and clustering I don't know exactly the context in which you heard this (NT cluster specific?), Don, Probably just my bad paraphrase of a dim recollection of a fast/careless read of previous comments on the list. Can you give a brief explanation of what will be new/changed in RAC, and what it means? thanks, ep ...but rest assured that OPS is not going to be replaced, except in name. The current party line is that real application clusters is a radical departure from OPS. It simply isn't true. RAC is a very major upgrade/rewrite and renaming of OPS, not a different technology. There seems to be a *LOT* of misinformation floating around on this issue and much of it seems be coming from Oracle's marketing machine. -Don Granaman [certifiable OPS OraSaurus] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eric D. Pierce INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: formatting DBMS_OUTPUT
Try DBMS_OUTPUT.PUT_LINE(TO_CHAR(amount_x), '999,999')) Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
ORA-03127 during Export
We are getting an ORA-03127 during the Export of a 20G database. Noone else is one the system. The error we are getting is: ORA-03127 no new operations allowed until the active operation ends Cause: An attempt was made to execute a new operation before the active non-blocking operation completed or a new operation was attempted before all the pieces of a column were inserted or fetched. Action: Execute the new operation after the non-blocking operation completes. If piecewise binds/defines were done, execute the new operation after all the pieces have been inserted or fetched. Any idea why this would happen and how to fix it? Ron Smith Database Administrator [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: [Q] exp from 8.1.7 and import to 8.1.6?
That is the way I did it as well, as long as I used the lower version import/export utility all was fine. KK -Original Message- Sent: Friday, July 27, 2001 9:57 AM To: Multiple recipients of list ORACLE-L I just did this myself on Solaris. You don't need to change the views, just use the exp utility from 8.1.6. on the 8.1.7 database. I had to do a 8.1.6 install on another machine to get the utility. There is a good matrix on Metalink that shows the version compatibilities. Sincerely, Woody -Original Message- Sent: Thursday, July 26, 2001 5:51 PM To: Multiple recipients of list ORACLE-L Thank you for your answer. Can you tell me how to make it work? Thanks. From: Tirumala, Surendra [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: [Q] exp from 8.1.7 and import to 8.1.6? Date: Thu, 26 Jul 2001 10:16:15 -0800 NO. -Original Message- Sent: Thursday, July 26, 2001 10:56 AM To: Multiple recipients of list ORACLE-L I just upgrade ORACLE from 8.1.6 to 8.1.7 (SUn Solaris). My question is can I export from 8.1.7 and bring the dump file import into 8.1.6 ORACLE server? Thanks. _ Get your FREE download of MSN Explorer at http://explorer.msn.com http://go.msn.com/bql/hmtag_itl_EN.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ef 8454 INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tirumala, Surendra INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ef 8454 INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Woody McKay INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Kostyszyn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Dangerous AIX Bug!
Ross, We're running 8160 ops on aix 4.3.3. Joan Durinda.Jones wrote: Ross, We're running 8162 OPS on AIX 4.3. Chat away... Durinda -Original Message- Sent: Wednesday, July 25, 2001 9:36 AM To: Multiple recipients of list ORACLE-L ...just kidding, thought that would get your attention. But seriously: does anyone out there use Oracle 8i on AIX 4.3 or 5L? I'd like to chat w/you if so. Thanks! - Ross p.s. hmmm...maybe there *is* a bug in AIX and that's one of the things I'll learn:-) -Original Message- Sent: Tuesday, July 10, 2001 11:56 AM To: Multiple recipients of list ORACLE-L Ron, I've attached one that I also got from the list some time ago, you may need to use something like bablefish to translate the comments :) HTH Mark -Original Message- L. Sent: Tuesday, July 10, 2001 02:32 To: Multiple recipients of list ORACLE-L Last week I was bit by a corrupt block on an index. I run Analyze every week which I found has been blowing up for some time due to the block corruption. Since Analyze does not create a log I did not know the Analyze was blowing up. Now I know that there are messages in the alert log that would have told me I had problems with the Analyze and the index. To make a long story short I need a good log scan script. Hopefully one that will work on Unix and NT. Mainly Unix. If anyone can help I would appreciate it. Thanks! Ron -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Durinda.Jones INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joan Hsieh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Collection
Hi Friends : does anyone use the resource collection in 8i. wich advantages we have using it ? Are there problems using it ? Are there performance problemns ? Spaces ? Regards Eriovaldo [EMAIL PROTECTED] Limeira / Brazil _ Seja avisado de novas mensagens do Hotmail e use o comunique-se com seus amigos com o MSN Messenger em http://messenger.msn.com.br -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eca Eca INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: [Q] exp from 8.1.7 and import to 8.1.6?
Yes you are right. Just now I had gone through that note(Note:132904.1). We will have to chnge the views if you want to export/import across the major versions, i.e between 8.1 and 8.0 between 8.1 and 7.3 ... And last time I had to do this was from 8.1.6 to 8.0.5 Sorry for confusing Suren -Original Message- Sent: Friday, July 27, 2001 9:57 AM To: Multiple recipients of list ORACLE-L I just did this myself on Solaris. You don't need to change the views, just use the exp utility from 8.1.6. on the 8.1.7 database. I had to do a 8.1.6 install on another machine to get the utility. There is a good matrix on Metalink that shows the version compatibilities. Sincerely, Woody -Original Message- Sent: Thursday, July 26, 2001 5:51 PM To: Multiple recipients of list ORACLE-L Thank you for your answer. Can you tell me how to make it work? Thanks. From: Tirumala, Surendra [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: [Q] exp from 8.1.7 and import to 8.1.6? Date: Thu, 26 Jul 2001 10:16:15 -0800 NO. -Original Message- Sent: Thursday, July 26, 2001 10:56 AM To: Multiple recipients of list ORACLE-L I just upgrade ORACLE from 8.1.6 to 8.1.7 (SUn Solaris). My question is can I export from 8.1.7 and bring the dump file import into 8.1.6 ORACLE server? Thanks. _ Get your FREE download of MSN Explorer at http://explorer.msn.com http://go.msn.com/bql/hmtag_itl_EN.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ef 8454 INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tirumala, Surendra INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ef 8454 INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Woody McKay INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tirumala, Surendra INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Dangerous AIX Bug!
Denny, Thank very much for the link. We MAY have to port our shell scripts from HP-UX to AIX, soon. Suren -Original Message- Sent: Thursday, July 26, 2001 5:51 PM To: Multiple recipients of list ORACLE-L Ross, Check this link. You may find it useful. http://home.earthlink.net/~bhami/rosetta.html Regards, Denny Mohan, Ross wrote: :) My biggest concern is porting db's from other unix flavors...i wish there were a cross platfrom shell porting guide. Sure, ls is ls, but every mfgr changes the order/formatting of the flags and/or output. I am compiling responses and will post a summary. I have some good stuff so far hth Ross p.s. I wish i could get some (mostly) grass fed beef! ;-) _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Denny Koovakattu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tirumala, Surendra INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: formatting DBMS_OUTPUT
Close, but you have an extra parenthesis: DBMS_OUTPUT.PUT_LINE(TO_CHAR(amount_x), '999,999')) should be DBMS_OUTPUT.PUT_LINE(TO_CHAR(amount_x, '999,999')) -Original Message- Sent: Friday, July 27, 2001 8:52 AM To: Multiple recipients of list ORACLE-L Try DBMS_OUTPUT.PUT_LINE(TO_CHAR(amount_x), '999,999')) Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Medtronic
Is there anyone using this list from Medtronic in Minnesota? Thanks, Ken Janusz, CPIM -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Year of Unix file
Correct, as far as the 8th field reporting the year. But the year replaces the time in the 8th field only when the last modification time for the file is more than 6 month (even if it is in the current year :) For example, take a look at line 1,2 (less than 6 month old as of today) 3,4,5 (over 6 months old as of today).. -rw-rw-r-- 1 oracle dba 2880 Feb 5 08:05 junk.lst -rwxrwx--- 1 oracle dba410 Jan 30 11:08 show_all.ksh -rwx-- 1 oracle dba 77 Jan 25 2001 t1 -rw-rw-r-- 1 oracle dba 3971 Jan 10 2001 my.lst -rw-rw-r-- 1 oracle dba720 Jan 7 2001 bdf.out HTH... Regards, - Kirti Deshpande Verizon Information Services http://www.superpages.com -Original Message- From: Carlo Vaccari [SMTP:[EMAIL PROTECTED]] Sent: Friday, July 27, 2001 7:40 AM To: Multiple recipients of list ORACLE-L Subject: Re: Year of Unix file when i list the unix file (solaris), with ls -lt command , i am able to see the time, month, date that is created. is there any way to see the year that is created. The 8th field of ls -lt indicates the hour if the file was created in the current year, otherwise it indicates the year. ciao carlo -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Solaris Release Vs. Version
Hi thanq for responding . but still i am not clear about it. can you clarify. because in oracle we call version 8.1.7 ... but here what is the release and version. can you go more deep? 2.6 is version 6 of oracle is it any hardware release. prasad --- Christopher Spence [EMAIL PROTECTED] wrote: There is probably something wrong or it is truly 2.7. 2.6 is Version 6 of Solaris 2.7 is Version 7 of Solaris They are completely different versions. Nothing about them is similar in terms of release. Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Friday, July 27, 2001 7:11 AM To: Multiple recipients of list ORACLE-L hi dba's can any body tell me the difference between the release and version of Sun solaris. i am working on solaris platform. when i login to the server, i get prompt Sun 5.7 where the version is 2.6 what is the difference between these 2? prasad. __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: prasad maganti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: prasad maganti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
OT RE: Dangerous AIX Bug!
Yeah, I had to drop off the informix list for the AIX list. Good choice I think. Actually this post might be a good one for the AIX'ers. Seems like a lot of ppl are switching to AIX, h, maybe buy some IBM stock :). I just wish I had an EMC sym rather than this shark stuck in Raid-5. I need BCV's to back up a 1TB db. Not sure if the shark flashcopy will do the trick. Anyone on this list use flashcopy? Gene [EMAIL PROTECTED] 07/26/01 06:51PM Gene, you're a busy man. Just saw you on the AIX list. I'll lurk there for a while before creating havoc. ;-) thanks -Original Message- Sent: Thursday, July 26, 2001 6:39 PM To: Multiple recipients of list ORACLE-L Nice link. Thanks! [EMAIL PROTECTED] 07/26/01 05:51PM Ross, Check this link. You may find it useful. http://home.earthlink.net/~bhami/rosetta.html Regards, Denny Mohan, Ross wrote: :) My biggest concern is porting db's from other unix flavors...i wish there were a cross platfrom shell porting guide. Sure, ls is ls, but every mfgr changes the order/formatting of the flags and/or output. I am compiling responses and will post a summary. I have some good stuff so far hth Ross p.s. I wish i could get some (mostly) grass fed beef! ;-) _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Denny Koovakattu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gene Sais INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gene Sais INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: formatting DBMS_OUTPUT
Thank you -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Redo for Rollback segs
When we enter data or delete date(modifying data blocks) , that will generate some redo. and my doubt is: when we delete some data in the database, that will further insert information into Rollback segment transaction tables (means furtherly it is modifying some block of oracle). Will this generate Redo? prasad __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: prasad maganti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Year of Unix file
If you look in the man pages on thels command it says something about the LC_TIME environment variable being used to control the date string. You might investigate that . -Original Message- Sent: Friday, July 27, 2001 7:40 AM To: Multiple recipients of list ORACLE-L when i list the unix file (solaris), with ls -lt command , i am able to see the time, month, date that is created. is there any way to see the year that is created. The 8th field of ls -lt indicates the hour if the file was created in the current year, otherwise it indicates the year. ciao carlo -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Carlo Vaccari INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Redo for Rollback segs
Yes, __ALL__ changes to any of the database blocks are recorded in the Redo. Regards, - Kirti Deshpande Verizon Information Services http://www.superpages.com -Original Message- From: prasad maganti [SMTP:[EMAIL PROTECTED]] Sent: Friday, July 27, 2001 10:22 AM To: Multiple recipients of list ORACLE-L Subject: Redo for Rollback segs When we enter data or delete date(modifying data blocks) , that will generate some redo. and my doubt is: when we delete some data in the database, that will further insert information into Rollback segment transaction tables (means furtherly it is modifying some block of oracle). Will this generate Redo? prasad __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: prasad maganti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Best way to upgrade database/move data
Rick, I see you've already had some good advice on exp/imp 'ing the data, so I'll leave that as is. One question - Why are you moving to NT again? If this is an all new server, why don't you slap Win2K on there? Much better platform.. Cheers Mark -Original Message- T (Richard) Sent: Wednesday, July 25, 2001 05:02 To: Multiple recipients of list ORACLE-L Hi DBAs, Currently I have NT server 4.0/Oracle 8.0.5 with about 400 million records/450 tables,indices,etc. We will be getting a new NT server with Oracle 8.1.7. We will increase block size from 2k to 8k What would be the best way to move data/users/sequences,etc from existing server to new server? Essentially replicate everything from old server to new server. Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cale, Rick T (Richard) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: moving tables to a different tablespace
Have you looked at ALTER TABLE...MOVE... ? Ade -Original Message- Sent: 26 July 2001 18:51 To: [EMAIL PROTECTED] Hi Group, Please explain what I am doing wrong. 1) exp outln/outln@webprod mailto:outln/outln@webprod file=exp_file tables = 'OL$' 'OL$HINTS' 2) Dropped the tables: 'OL$' and 'OL$HINTS' on webprod 3) Created tablespace outln_ts on webprod 4) Altered user outln default tablespace outln_ts 5) imp outln/outln@webprod mailto:outln/outln@webprod file=exp_file tables = 'OL$' 'OL$HINTS' 6) SQL select table_name, tablespace_name from dba_tables where owner = 'OUTLN'; TABLE_NAME TABLESPACE_NAME -- -- OL$SYSTEM OL$HINTS SYSTEM XX OUTLN_TS WHY are the tables being re-imported back into SYSTEM tablespace Oracle 8.1.7 on Sun Solaris 5.7 TIA Al Rusnak 804-734-8453 [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rusnak, George A. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Live Life in Broadband www.telewest.co.uk The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Statements and opinions expressed in this e-mail may not represent those of the company. 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. If you received this in error, please contact the sender immediately and delete the material from any computer. == -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Adrian Roe INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: CURSOR_SHARING = FORCE
Mark, Thanks for running the test. I would be interested if anyone could test on the latest version of 8.1.7 on Win2000. I called a friend and had them test on the latest release on HP-UX and they couldn't duplicate the bug. My inability to duplicate on *my* machine was due to a brain cramp -- I didn't force a hard parse of the statement like I had at the client. Cursor sharing is set to exact on my machine. I tried the statement with the trailing space, it worked. I then set to force and re-executed with no problem. But, the statement wasn't hard parsed since it was found in the shared pool. I can now duplicate without any problem by simply forcing my statement to be hard parsed (just like I was doing on the client's machine -- duh!): SQL select 'x ' from dual; This Works (trailing space which didn't fail for you) 'X -- x SQL alter session set cursor_sharing = force; Change to force Session altered. SQL select 'x ' from dual; still works but it wasn't hard parsed. 'X -- x SQL Select 'x ' from dual; force a hard parse by changing lower case s to upper case Select 'x ' from dual * ERROR at line 1: ORA-00600: internal error code, arguments: [17182], [366030328], [], [], [], [], [], [] So, it looks like the problem is with just cursor sharing itself (though it could still be a mix of parameters -- and I'm not going to try every combination!!!). Thanks for the help. I don't know anything else you can do. I wrapped up the contract with the client yesterday after taking care of the major issues I was brought in to resolve. They can handle this issue and some other minor ones. Since I *am* curious, I will probably give their DBA a call in a week or two to see if they and/or Oracle solved this with the latest version and patches for 8.1.7. And maybe someone on the list will be able to test against and up to date 8.1.7 on Win2k Regards, Larry G. Elkins [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Mark Leith Sent: Friday, July 27, 2001 10:02 AM To: Multiple recipients of list ORACLE-L Subject: RE: CURSOR_SHARING = FORCE Larry, Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production With the Partitioning option JServer Release 8.1.7.0.0 - Production select 'x ' from dual; 'X' x select 'x' from dual; 'X' x select ' x' from dual; select ' x' from dual * ERROR at line 1: ORA-00600: internal error code, arguments: [17182], [167886636], [], [], [], [], [], [] alter system set cursor_sharing = exact; System altered. select ' x' from dual; 'X -- x What can I share with you to help you out? This is on a test database only, so just let me know. Also note that the error was only thrown on mine with a leading space. This is Win2K Professional SP2. Cheers Mark -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Larry Elkins INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Solaris Release Vs. Version
The module that is responding to uname -a is SunOS. This is different from Solaris, but it's confusing why. I guess historically the primary interface was command-line, and not CDE? (i.e. maybe solaris:sunos :: gui:command-line) Here's a table I found on the web that may help... SunOS 5.3 = Solaris 2.3 SunOS 5.4 = Solaris 2.4 SunOS 5.5 = Solaris 2.5 SunOS 5.5.1 = Solaris 2.5.1 SunOS 5.6 = Solaris 2.6 SunOS 5.7 = Solaris 7 (aka Solaris 2.7) SunOS 5.8 = Solaris 8 (aka Solaris 2.8) .. .and before you get too riled up, ask yourself why Oracle 8.1.6 is also known as 8iv2 :) happy weekend everyone! Steve -Original Message- Sent: Friday, July 27, 2001 10:11 AM To: Multiple recipients of list ORACLE-L Hi thanq for responding . but still i am not clear about it. can you clarify. because in oracle we call version 8.1.7 ... but here what is the release and version. can you go more deep? 2.6 is version 6 of oracle is it any hardware release. prasad --- Christopher Spence [EMAIL PROTECTED] wrote: There is probably something wrong or it is truly 2.7. 2.6 is Version 6 of Solaris 2.7 is Version 7 of Solaris They are completely different versions. Nothing about them is similar in terms of release. Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Friday, July 27, 2001 7:11 AM To: Multiple recipients of list ORACLE-L hi dba's can any body tell me the difference between the release and version of Sun solaris. i am working on solaris platform. when i login to the server, i get prompt Sun 5.7 where the version is 2.6 what is the difference between these 2? prasad. __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: prasad maganti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: prasad maganti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Austin, Steve S INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Another Braindead Friday...
I have RTFM'd re: the following problem in HPUX11, Oracle 7.3.3: --I have user1 who has select privileges on another schema's table (user2.tab) through Select Any Table privilege. --user1 creates a view on user2.tab and grants select on the view to other users (user3..n) through a shared role. --When user3, et al tries to select from the view they get the infamous ORA-1720 - Grant option does not exist for xxx.xxx error. --I know you I can grant select on user2.tab with grant option to user1 and solve this, but I would rather not do that if at all possible. --Also, I could create the view as user2 and not have the problem. The issue here is user1 needs to create the above type of views on the fly (please! I didn't design it!!!), and with 30 sites to support, there is no way to keep up if I have to create the views one by one. Is there any way around the situation besides the select with grant option clause to user1 (view owner)? Am I an idiot? Are sheep considered dates in TX? HELP Thanks, Scott Shafer San Antonio, TX _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Shafer INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Redo for Rollback segs
to expand on this: changes to the rollback segments will generate entries in the redo logs. They ARE database blocks. In fact, rolling back something will generate change vectors as well. Rachel From: Deshpande, Kirti [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Redo for Rollback segs Date: Fri, 27 Jul 2001 07:36:50 -0800 Yes, __ALL__ changes to any of the database blocks are recorded in the Redo. Regards, - Kirti Deshpande Verizon Information Services http://www.superpages.com -Original Message- From: prasad maganti [SMTP:[EMAIL PROTECTED]] Sent: Friday, July 27, 2001 10:22 AM To: Multiple recipients of list ORACLE-L Subject:Redo for Rollback segs When we enter data or delete date(modifying data blocks) , that will generate some redo. and my doubt is: when we delete some data in the database, that will further insert information into Rollback segment transaction tables (means furtherly it is modifying some block of oracle). Will this generate Redo? prasad __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: prasad maganti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
PL/SQL Question after migrating from 7.3.4 to 8.1.7
Hi, I just migrated from 734 to 817, I used migration utility. Migration went fine. Some of my package specification have become invalid. When I tried to recompile, I got the following error 30/41PLS-00206: %TYPE must be applied to a variable, column, field or attribute, not to UC9_CLAIM_AMOUNT The source is listed below. uc9_correspondence is table in my schema. I do not know why this is throwing up an error where as 734 was happy with it. TYPE tb_uc9_corres_type IS TABLE OF uc9_correspondence%TYPE INDEX BY BINARY_INTEGER; Any help is appreciated Thanks in ADvance deen -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deen Dayal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Redo for Rollback segs
Rachel Carmichael wrote: to expand on this: changes to the rollback segments will generate entries in the redo logs. They ARE database blocks. In fact, rolling back something will generate change vectors as well. Rachel kinda dumb question, do changes to rollback segmants use rollback segments? and could you get the changes to rollback segments out of the logs with logminer? OK so it's 2 kind of dumb questions, i've been quiet lately.;-) and no i'm not sure why you'd want to get the changes out, but it would be interesting if you could. -- Bill Shrek Thater Certifiable ORACLE DBA Telergy, Inc[EMAIL PROTECTED] You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thater, William INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Medtronic
My husband works at Medtronic in Minnesota. What are you interested in? Cherie Machler Gelco Information Network [EMAIL PROTECTED] et To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent by: cc: root@fatcity.Subject: Medtronic com 07/27/01 09:57 AM Please respond to ORACLE-L Is there anyone using this list from Medtronic in Minnesota? Thanks, Ken Janusz, CPIM -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Rollback Segment needs recovery
Hi DBAs, Oracle 8.0.5/Windows NT4 I shutdown database normal and restarted ok. I tried to drop a rollback segment and getora-1545 rollback segment not available. When I select from dba_rollback_segs I get needs recovery. I want to drop rollback tablespace and all rollback segment then rebuild because I got datafile corruption error. I am in noarchive mode. Any ideas how to proceed? Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cale, Rick T (Richard) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Rollback Segment needs recovery
I was able to do everything I needed by using undocumented/unsupported _offline_rollback_segments parameter. Rick -Original Message- Sent: Friday, July 27, 2001 1:37 PM To: Multiple recipients of list ORACLE-L Hi DBAs, Oracle 8.0.5/Windows NT4 I shutdown database normal and restarted ok. I tried to drop a rollback segment and getora-1545 rollback segment not available. When I select from dba_rollback_segs I get needs recovery. I want to drop rollback tablespace and all rollback segment then rebuild because I got datafile corruption error. I am in noarchive mode. Any ideas how to proceed? Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cale, Rick T (Richard) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cale, Rick T (Richard) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Rollback seg for big job
Rachel, we are 8.16. We tried on line a bigrolbk, set tran on this rollback and took it offline. Guess what? the job was killed also. Oracle support said this is a bug, should be fixed 8.17. Joan Rachel Carmichael wrote: well.. you could sort of help to guarantee that no one else uses it. First, bring it online, do a set transaction to use that rollback segment, then (in another session), take that rollback segment offline. since you are already using it, it doesn't REALLY go offline (until your transaction ends) but no one else will be assigned to it either. Sneaky. Rachel From: Jon Walthour [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Rollback seg for big job Date: Fri, 27 Jul 2001 04:51:09 -0800 Prasad: As far as I know (and listers please correct me if I'm wrong) you can't single out the rollback segment you are using for that big transaction EXCLUSIVELY. In other words, since the rbs is still online and available, there is still the potential that another transaction could use that rbs as well. However, if you're running it at night, wouldn't your activity level be lower and thus the odds of getting another transaction in the same rbs be much lower as well? Just my 2 cents. Jon Walthour --- Original Message --- From: prasad maganti [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: 7/27/01 7:16:11 AM Hi dba's can anybody clarify my doubt reg. RBS. i need to run a very big job in night times. so , i have to create a very bigh rollback segment purely intended for that job. so i will set at sql set trnx use rollback seg.. my doubt is whether this rollback segment stores the rollback of my job or will it allow any other rollback of the database (that is not part of my job) prasad. __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: prasad maganti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jon Walthour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joan Hsieh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RE: CURSOR_SHARING = FORCE
Larry, et. al., I'm running 8.1.7.1.1 on Win 2K Pro SP2. I did the following: alter session set cursor_sharing=force; select 'x' from dual; select 'X' from dual; select ' x' from dual; select ' X' from dual; select 'x ' from dual; select ' x ' from dual; select ' X ' from dual; No problems with any of 'em. Jon Walthour --- Original Message --- From: Larry Elkins [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: 7/27/01 12:41:20 PM Mark, Thanks for running the test. I would be interested if anyone could test on the latest version of 8.1.7 on Win2000. I called a friend and had them test on the latest release on HP-UX and they couldn't duplicate the bug. My inability to duplicate on *my* machine was due to a brain cramp -- I didn't force a hard parse of the statement like I had at the client. Cursor sharing is set to exact on my machine. I tried the statement with the trailing space, it worked. I then set to force and re-executed with no problem. But, the statement wasn't hard parsed since it was found in the shared pool. I can now duplicate without any problem by simply forcing my statement to be hard parsed (just like I was doing on the client's machine -- duh!): SQL select 'x ' from dual; this works (trailing space which didn't fail for you) 'x -- x sql alter session set cursor_sharing = force; change to force session altered. sql select 'x ' from dual; still works but it wasn't hard parsed. 'x -- x sql Select 'x ' from dual; force a hard parse by changing lower case s to upper case select 'x ' from dual * error at line 1: ora-00600: internal error code, arguments: [17182], [366030328], [], [], [], [], [], [] so, it looks like the problem is with just cursor sharing itself (though it could still be a mix of parameters -- and i'm not going to try every combination!!!). thanks for the help. i don't know anything else you can do. i wrapped up the contract with the client yesterday after taking care of the major issues i was brought in to resolve. they can handle this issue and some other minor ones. since i *am* curious, i will probably give their dba a call in a week or two to see if they and/or oracle solved this with the latest version and patches for 8.1.7. and maybe someone on the list will be able to test against and up to date 8.1.7 on win2k regards, larry g. elkins [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Mark Leith Sent: Friday, July 27, 2001 10:02 AM To: Multiple recipients of list ORACLE-L Subject: RE: CURSOR_SHARING = FORCE Larry, Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production With the Partitioning option JServer Release 8.1.7.0.0 - Production select 'x ' from dual; 'X' x select 'x' from dual; 'X' x select ' x' from dual; select ' x' from dual * ERROR at line 1: ORA-00600: internal error code, arguments: [17182], [167886636], [], [], [], [], [], [] alter system set cursor_sharing = exact; System altered. select ' x' from dual; 'X -- x What can I share with you to help you out? This is on a test database only, so just let me know. Also note that the error was only thrown on mine with a leading space. This is Win2K Professional SP2. Cheers Mark -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Larry Elkins INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jon Walthour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
SUN cluster error
Hi When I shutdown and start sun cluster.I got following error Jul 27 12:49:54 ID[SUNWcluster.ha.haoracle_fmon.2050]: :samp: RDBMS error, but HA-RDBMS Oracle will take no action for this error code where samp=DB name Let me know what could be reason?Any suggestion. Thanks -Seema _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: PL/SQL Question after migrating from 7.3.4 to 8.1.7
Deen, shouldn't the statement be: TYPE tb_uc9_corres_type IS TABLE OF uc9_correspondence.COLUMN_NAME%TYPE INDEX BY BINARY_INTEGER; ?? The %TYPE in your PL/SQL is being applied to the table which, I think, is not valid. A PL/SQL table is a one-column data type, indexed via the BINARY_INTEGER index. You could easily fix this by finding an assignment statement elsewhere in your code to see what you are trying to store. hope this helps Tom Mercadante Oracle Certified Professional -Original Message- Sent: Friday, July 27, 2001 1:45 PM To: Multiple recipients of list ORACLE-L Hi, I just migrated from 734 to 817, I used migration utility. Migration went fine. Some of my package specification have become invalid. When I tried to recompile, I got the following error 30/41PLS-00206: %TYPE must be applied to a variable, column, field or attribute, not to UC9_CLAIM_AMOUNT The source is listed below. uc9_correspondence is table in my schema. I do not know why this is throwing up an error where as 734 was happy with it. TYPE tb_uc9_corres_type IS TABLE OF uc9_correspondence%TYPE INDEX BY BINARY_INTEGER; Any help is appreciated Thanks in ADvance deen -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deen Dayal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Another Braindead Friday...
another user should have select privileges for underlying table directly, not thru the role. Alex Hillman -Original Message- Sent: Friday, July 27, 2001 1:31 PM To: Multiple recipients of list ORACLE-L I have RTFM'd re: the following problem in HPUX11, Oracle 7.3.3: --I have user1 who has select privileges on another schema's table (user2.tab) through Select Any Table privilege. --user1 creates a view on user2.tab and grants select on the view to other users (user3..n) through a shared role. --When user3, et al tries to select from the view they get the infamous ORA-1720 - Grant option does not exist for xxx.xxx error. --I know you I can grant select on user2.tab with grant option to user1 and solve this, but I would rather not do that if at all possible. --Also, I could create the view as user2 and not have the problem. The issue here is user1 needs to create the above type of views on the fly (please! I didn't design it!!!), and with 30 sites to support, there is no way to keep up if I have to create the views one by one. Is there any way around the situation besides the select with grant option clause to user1 (view owner)? Am I an idiot? Are sheep considered dates in TX? HELP Thanks, Scott Shafer San Antonio, TX _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Shafer INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Encrypting a password
How can I encrypt a password in Oracle that I could use to compare with an encrypted password in /etc/passwd on a Sun Unix box? I am on Solaris 2.8 running Oracle 8.1.7. I have read about encrypting and decrypting using the dbms_obfuscation package, but this does not seem to get me what I am looking for. Any information would be greatly appreciated. Thanks, Rick Stephenson -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Medtronic
On Medtronic's career web site they are looking to fill the following positions: Sr. DBA Project Mgr Sr. DBA (2 positions) Prin. DBA I would like to find out who the hiring manager is, their mailing address and direct phone #. I already sent my resume to HR. Your help getting me this information will be greatly appreciated. Thanks, Ken Janusz, CPIM My husband works at Medtronic in Minnesota. What are you interested in? Cherie Machler Gelco Information Network [EMAIL PROTECTED] et To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent by: cc: root@fatcity.Subject: Medtronic com 07/27/01 09:57 AM Please respond to ORACLE-L Is there anyone using this list from Medtronic in Minnesota? Thanks, Ken Janusz, CPIM -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Solaris Release Vs. Version
2.6 = Version 6 2.7 = Version 7 The 2 can safely be ignored, it is in fact replaced with a 5 now after version 4. So it is really 5.7 and 5.8. The major version is the right hand number, not the left. Very weird naming convention. Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Friday, July 27, 2001 11:11 AM To: Multiple recipients of list ORACLE-L Hi thanq for responding . but still i am not clear about it. can you clarify. because in oracle we call version 8.1.7 ... but here what is the release and version. can you go more deep? 2.6 is version 6 of oracle is it any hardware release. prasad --- Christopher Spence [EMAIL PROTECTED] wrote: There is probably something wrong or it is truly 2.7. 2.6 is Version 6 of Solaris 2.7 is Version 7 of Solaris They are completely different versions. Nothing about them is similar in terms of release. Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Friday, July 27, 2001 7:11 AM To: Multiple recipients of list ORACLE-L hi dba's can any body tell me the difference between the release and version of Sun solaris. i am working on solaris platform. when i login to the server, i get prompt Sun 5.7 where the version is 2.6 what is the difference between these 2? prasad. __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: prasad maganti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: prasad maganti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Redo for Rollback segs
Yes, it will. The concepts manual is your friend. Jared prasad maganti prasadm_g@yah To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] oo.com cc: Sent by: Subject: Redo for Rollback segs [EMAIL PROTECTED] om 07/27/01 08:22 AM Please respond to ORACLE-L When we enter data or delete date(modifying data blocks) , that will generate some redo. and my doubt is: when we delete some data in the database, that will further insert information into Rollback segment transaction tables (means furtherly it is modifying some block of oracle). Will this generate Redo? prasad __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: prasad maganti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Supert market desgn
Wiley (www.wiley.com) has a series on data models for different businesses businesses that begin with the title The Data Model Resource Book: A Library of Universal Data Models for All Enterprises... -Original Message-From: Saravana Kumar [mailto:[EMAIL PROTECTED]]Sent: Monday, July 23, 2001 3:55 AMTo: Multiple recipients of list ORACLE-LSubject: Supert market desgn Hi friends, I would like to know thename of site where i could find any document related to designing of database for a supermarket chain speard across the country. Please help me regarding the document. Thank's in advance. Regards Saravana.
RE: Another Braindead Friday...
Scott, I don't see another way to do this, but you could generate the grant statements rather quickly using sql - like set head off set pages 2000 spool grant.sql select 'grant select on ' || table_name || ' with grant option;' from user_tables / spool off @grant and your question about sheep, well, it depends. are you involved with any other livestock? Tom Mercadante Oracle Certified Professional -Original Message- Sent: Friday, July 27, 2001 1:31 PM To: Multiple recipients of list ORACLE-L I have RTFM'd re: the following problem in HPUX11, Oracle 7.3.3: --I have user1 who has select privileges on another schema's table (user2.tab) through Select Any Table privilege. --user1 creates a view on user2.tab and grants select on the view to other users (user3..n) through a shared role. --When user3, et al tries to select from the view they get the infamous ORA-1720 - Grant option does not exist for xxx.xxx error. --I know you I can grant select on user2.tab with grant option to user1 and solve this, but I would rather not do that if at all possible. --Also, I could create the view as user2 and not have the problem. The issue here is user1 needs to create the above type of views on the fly (please! I didn't design it!!!), and with 30 sites to support, there is no way to keep up if I have to create the views one by one. Is there any way around the situation besides the select with grant option clause to user1 (view owner)? Am I an idiot? Are sheep considered dates in TX? HELP Thanks, Scott Shafer San Antonio, TX _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Shafer INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Redo for Rollback segs
that I know of, yes they do use rollback segments. I could be wrong as for logminer, they aren't sql statements, but change vectors. so I don't know From: Thater, William [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: Redo for Rollback segs Date: Fri, 27 Jul 2001 09:51:30 -0800 Rachel Carmichael wrote: to expand on this: changes to the rollback segments will generate entries in the redo logs. They ARE database blocks. In fact, rolling back something will generate change vectors as well. Rachel kinda dumb question, do changes to rollback segmants use rollback segments? and could you get the changes to rollback segments out of the logs with logminer? OK so it's 2 kind of dumb questions, i've been quiet lately.;-) and no i'm not sure why you'd want to get the changes out, but it would be interesting if you could. -- Bill Shrek Thater Certifiable ORACLE DBA Telergy, Inc[EMAIL PROTECTED] You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thater, William INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Another Braindead Friday...
I thought about that. Unfortunately the business rules developed by non-Oracle-literate individuals specifically prohibit this. Each site has an unknown number of 3rd party tools which their users can use to connect with. Most regular lusers have access only to a secure view which constrains the data that they can see. I have invariably found several cartesian products when direct select permissions have been granted. Damagement wants anyone to be able to use any tools that make them happy (for the uninitiated - this is a bad idea for sensitive data). Why you ask are they now wanting a select through another view (which may violate this prohibition anyway)? You got me. The minds of beaurocrats are not for mere mortals to play in... That and my creativity is at an all time low due to lack of sleep. Thanks, Scott Hillman, Alex wrote: another user should have select privileges for underlying table directly, not thru the role. Alex Hillman -Original Message- Sent: Friday, July 27, 2001 1:31 PM To: Multiple recipients of list ORACLE-L I have RTFM'd re: the following problem in HPUX11, Oracle 7.3.3: --I have user1 who has select privileges on another schema's table (user2.tab) through Select Any Table privilege. --user1 creates a view on user2.tab and grants select on the view to other users (user3..n) through a shared role. --When user3, et al tries to select from the view they get the infamous ORA-1720 - Grant option does not exist for xxx.xxx error. --I know you I can grant select on user2.tab with grant option to user1 and solve this, but I would rather not do that if at all possible. --Also, I could create the view as user2 and not have the problem. The issue here is user1 needs to create the above type of views on the fly (please! I didn't design it!!!), and with 30 sites to support, there is no way to keep up if I have to create the views one by one. Is there any way around the situation besides the select with grant option clause to user1 (view owner)? Am I an idiot? Are sheep considered dates in TX? HELP Thanks, Scott Shafer San Antonio, TX _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Shafer INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
any way to stop rollback for dml?/8.1.7.1/Solaris 8
Does anyone know of a way to inhibit rollback from being generated for DML? We've got a data warehouse load process that we're trying to speed up (involving sqlldr and then some DML afterwards.) The staging tables it uses are entirely for this process -- there's no need to rollback if it fails; we'd truncate them and start again with that set of data. Aside from sqlldr direct mode and import direct mode, can anyone think of ways to do this? Thanks, Steve -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Austin, Steve S INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Rollback Segment needs recovery
On Fri, 27 Jul 2001, Cale, Rick T (Richard) wrote: Hi DBAs, Oracle 8.0.5/Windows NT4 I shutdown database normal and restarted ok. I tried to drop a rollback segment and getora-1545 rollback segment not available. When I select from dba_rollback_segs I get needs recovery. I want to drop rollback tablespace and all rollback segment then rebuild because I got datafile corruption error. I am in noarchive mode. Any ideas how to proceed? It can only be done using undocumented init.ora parameters. Should be _corrupted_rollback_segs=(...,...) or something. Export and recreate your database as soon as you bring it on-line! But better still call Oracle Support. Thanks Rick Nick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nicholas Tufar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RE: CURSOR_SHARING = FORCE
On 8.1.7.1.3 on W2K: SQL alter session set cursor_sharing=force; Session altered. SQL SQL select 'x' from dual; 'X' x SQL select 'X' from dual; 'X' X SQL select ' x' from dual; select ' x' from dual * ERROR at line 1: ORA-00600: internal error code, arguments: [17182], [550858904], [], [], [], [], [], [] SQL select ' X' from dual; select ' X' from dual * ERROR at line 1: ORA-00600: internal error code, arguments: [17182], [550858904], [], [], [], [], [], [] SQL select 'x ' from dual; select 'x ' from dual * ERROR at line 1: ORA-00600: internal error code, arguments: [17182], [550858904], [], [], [], [], [], [] SQL select ' x ' from dual; 'X' x SQL select ' X ' from dual; 'X' X Gary Kirsh Next Extent, Inc -Original Message- Sent: Friday, July 27, 2001 2:16 PM To: Multiple recipients of list ORACLE-L Larry, et. al., I'm running 8.1.7.1.1 on Win 2K Pro SP2. I did the following: alter session set cursor_sharing=force; select 'x' from dual; select 'X' from dual; select ' x' from dual; select ' X' from dual; select 'x ' from dual; select ' x ' from dual; select ' X ' from dual; No problems with any of 'em. Jon Walthour --- Original Message --- From: Larry Elkins [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: 7/27/01 12:41:20 PM Mark, Thanks for running the test. I would be interested if anyone could test on the latest version of 8.1.7 on Win2000. I called a friend and had them test on the latest release on HP-UX and they couldn't duplicate the bug. My inability to duplicate on *my* machine was due to a brain cramp -- I didn't force a hard parse of the statement like I had at the client. Cursor sharing is set to exact on my machine. I tried the statement with the trailing space, it worked. I then set to force and re-executed with no problem. But, the statement wasn't hard parsed since it was found in the shared pool. I can now duplicate without any problem by simply forcing my statement to be hard parsed (just like I was doing on the client's machine -- duh!): SQL select 'x ' from dual; this works (trailing space which didn't fail for you) 'x -- x sql alter session set cursor_sharing = force; change to force session altered. sql select 'x ' from dual; still works but it wasn't hard parsed. 'x -- x sql Select 'x ' from dual; force a hard parse by changing lower case s to upper case select 'x ' from dual * error at line 1: ora-00600: internal error code, arguments: [17182], [366030328], [], [], [], [], [], [] so, it looks like the problem is with just cursor sharing itself (though it could still be a mix of parameters -- and i'm not going to try every combination!!!). thanks for the help. i don't know anything else you can do. i wrapped up the contract with the client yesterday after taking care of the major issues i was brought in to resolve. they can handle this issue and some other minor ones. since i *am* curious, i will probably give their dba a call in a week or two to see if they and/or oracle solved this with the latest version and patches for 8.1.7. and maybe someone on the list will be able to test against and up to date 8.1.7 on win2k regards, larry g. elkins [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Mark Leith Sent: Friday, July 27, 2001 10:02 AM To: Multiple recipients of list ORACLE-L Subject: RE: CURSOR_SHARING = FORCE Larry, Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production With the Partitioning option JServer Release 8.1.7.0.0 - Production select 'x ' from dual; 'X' x select 'x' from dual; 'X' x select ' x' from dual; select ' x' from dual * ERROR at line 1: ORA-00600: internal error code, arguments: [17182], [167886636], [], [], [], [], [], [] alter system set cursor_sharing = exact; System altered. select ' x' from dual; 'X -- x What can I share with you to help you out? This is on a test database only, so just let me know. Also note that the error was only thrown on mine with a leading space. This is Win2K Professional SP2. Cheers Mark -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Larry Elkins INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing:
RE: Table fragmentation
Title: RE: Table fragmentation See All About Oracle Database Fragmentation by Craig A. Shallahamer at www.orapub.com. Click on RESEARCH/PAPERS and enjoy the bounty. -Original Message- From: Viraj Luthra [mailto:[EMAIL PROTECTED]] Sent: Tuesday, July 24, 2001 9:51 PM To: Multiple recipients of list ORACLE-L Subject: Table fragmentation Hello all, How do I come to know about table fragmentation, I know the info. on tablespace but I need TABLE fragmentation. Please advise as to what kinds of info. and corresponding script would be advantageous to know. rgds, raja Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Viraj Luthra INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RE: CURSOR_SHARING = FORCE
I'm on NT on Oracle8i Enterprise Edition Release 8.1.7.1.1 and do receive: ORA-00600: internal error code, arguments: [17182] Chaim Jon Walthour [EMAIL PROTECTED] on 07/27/2001 02:16:03 PM Please respond to [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc:(bcc: Chaim Katz/Completions/Bombardier) Larry, et. al., I'm running 8.1.7.1.1 on Win 2K Pro SP2. I did the following: alter session set cursor_sharing=force; select 'x' from dual; select 'X' from dual; select ' x' from dual; select ' X' from dual; select 'x ' from dual; select ' x ' from dual; select ' X ' from dual; No problems with any of 'em. Jon Walthour --- Original Message --- From: Larry Elkins [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: 7/27/01 12:41:20 PM Mark, Thanks for running the test. I would be interested if anyone could test on the latest version of 8.1.7 on Win2000. I called a friend and had them test on the latest release on HP-UX and they couldn't duplicate the bug. My inability to duplicate on *my* machine was due to a brain cramp -- I didn't force a hard parse of the statement like I had at the client. Cursor sharing is set to exact on my machine. I tried the statement with the trailing space, it worked. I then set to force and re-executed with no problem. But, the statement wasn't hard parsed since it was found in the shared pool. I can now duplicate without any problem by simply forcing my statement to be hard parsed (just like I was doing on the client's machine -- duh!): SQL select 'x ' from dual; this works (trailing space which didn't fail for you) 'x -- x sql alter session set cursor_sharing = force; change to force session altered. sql select 'x ' from dual; still works but it wasn't hard parsed. 'x -- x sql Select 'x ' from dual; force a hard parse by changing lower case s to upper case select 'x ' from dual * error at line 1: ora-00600: internal error code, arguments: [17182], [366030328], [], [], [], [], [], [] so, it looks like the problem is with just cursor sharing itself (though it could still be a mix of parameters -- and i'm not going to try every combination!!!). thanks for the help. i don't know anything else you can do. i wrapped up the contract with the client yesterday after taking care of the major issues i was brought in to resolve. they can handle this issue and some other minor ones. since i *am* curious, i will probably give their dba a call in a week or two to see if they and/or oracle solved this with the latest version and patches for 8.1.7. and maybe someone on the list will be able to test against and up to date 8.1.7 on win2k regards, larry g. elkins [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Mark Leith Sent: Friday, July 27, 2001 10:02 AM To: Multiple recipients of list ORACLE-L Subject: RE: CURSOR_SHARING = FORCE Larry, Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production With the Partitioning option JServer Release 8.1.7.0.0 - Production select 'x ' from dual; 'X' x select 'x' from dual; 'X' x select ' x' from dual; select ' x' from dual * ERROR at line 1: ORA-00600: internal error code, arguments: [17182], [167886636], [], [], [], [], [], [] alter system set cursor_sharing = exact; System altered. select ' x' from dual; 'X -- x What can I share with you to help you out? This is on a test database only, so just let me know. Also note that the error was only thrown on mine with a leading space. This is Win2K Professional SP2. Cheers Mark -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Larry Elkins INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jon Walthour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP
Re: NULL Foreign Key Value
Because the relation is optional. Jared George Hofilena To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] GHofilena@cnv cc: .orgSubject: NULL Foreign Key Value Sent by: [EMAIL PROTECTED] om 07/26/01 10:56 AM Please respond to ORACLE-L Can somebody explain why Oracle would allow a foreign key to be null and still enforce the referential integrity constraint. Thanks, George Hofilena DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: George Hofilena INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: PL/SQL Question after migrating from 7.3.4 to 8.1.7
Deen, If you want a table with the structure of a row in your uc9_correspondence, use THE '%ROWTYPE'as follows: TYPE tb_uc9_corres_type IS TABLE OF uc9_correspondence%ROWTYPE INDEX BY BINARY_INTEGER; Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re:Another Braindead Friday...
Scott, Outside of the solution you've stated you could also 'grant select any table to usera with admin'. Dick Goulet Reply Separator Author: Scott Shafer [EMAIL PROTECTED] Date: 7/27/2001 9:31 AM I have RTFM'd re: the following problem in HPUX11, Oracle 7.3.3: --I have user1 who has select privileges on another schema's table (user2.tab) through Select Any Table privilege. --user1 creates a view on user2.tab and grants select on the view to other users (user3..n) through a shared role. --When user3, et al tries to select from the view they get the infamous ORA-1720 - Grant option does not exist for xxx.xxx error. --I know you I can grant select on user2.tab with grant option to user1 and solve this, but I would rather not do that if at all possible. --Also, I could create the view as user2 and not have the problem. The issue here is user1 needs to create the above type of views on the fly (please! I didn't design it!!!), and with 30 sites to support, there is no way to keep up if I have to create the views one by one. Is there any way around the situation besides the select with grant option clause to user1 (view owner)? Am I an idiot? Are sheep considered dates in TX? HELP Thanks, Scott Shafer San Antonio, TX _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Shafer INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RE: CURSOR_SHARING = FORCE
John, Thanks for performing the test case and satisfying my curiosity. Regards, Larry G. Elkins [EMAIL PROTECTED] 214.954.1781 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Jon Walthour Sent: Friday, July 27, 2001 1:16 PM To: Multiple recipients of list ORACLE-L Subject: RE: RE: CURSOR_SHARING = FORCE Larry, et. al., I'm running 8.1.7.1.1 on Win 2K Pro SP2. I did the following: alter session set cursor_sharing=force; select 'x' from dual; select 'X' from dual; select ' x' from dual; select ' X' from dual; select 'x ' from dual; select ' x ' from dual; select ' X ' from dual; No problems with any of 'em. Jon Walthour -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Larry Elkins INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Rollback Segment needs recovery
have you backed up the database? done a full database export? just to be careful From: Cale, Rick T (Richard) [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Rollback Segment needs recovery Date: Fri, 27 Jul 2001 10:06:38 -0800 I was able to do everything I needed by using undocumented/unsupported _offline_rollback_segments parameter. Rick -Original Message- Sent: Friday, July 27, 2001 1:37 PM To: Multiple recipients of list ORACLE-L Hi DBAs, Oracle 8.0.5/Windows NT4 I shutdown database normal and restarted ok. I tried to drop a rollback segment and getora-1545 rollback segment not available. When I select from dba_rollback_segs I get needs recovery. I want to drop rollback tablespace and all rollback segment then rebuild because I got datafile corruption error. I am in noarchive mode. Any ideas how to proceed? Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cale, Rick T (Richard) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cale, Rick T (Richard) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re:RE: Supert market desgn
Tony, That's interesting! The books look pretty good, I'll have to order a set, but that CD-ROM is kindof pricey ($300.00), isn't it? Dick Goulet Reply Separator Author: Aponte; Tony [EMAIL PROTECTED] Date: 7/27/2001 10:57 AM Wiley ( www.wiley.com) has a series on data models for different businesses businesses that begin with the title The Data Model Resource Book: A Library of Universal Data Models for All Enterprises... -Original Message- Sent: Monday, July 23, 2001 3:55 AM To: Multiple recipients of list ORACLE-L Hi friends, I would like to know the name of site where i could find any document related to designing of database for a supermarket chain speard across the country. Please help me regarding the document. Thank's in advance. Regards Saravana. !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN HTMLHEAD META HTTP-EQUIV=Content-Type CONTENT=text/html; charset=iso-8859-1 META content=MSHTML 5.00.2919.6307 name=GENERATOR STYLE/STYLE /HEAD BODY bgColor=#ff DIVFONT color=#ff face=Arial size=2SPAN class=556384917-27072001Wiley (A href=http://www.wiley.com;www.wiley.com/A) has a series on data models for different businesses businesses that begin with the title SPAN class=breadcrumblocationThe Data Model Resource Book: A Library of Universal Data Models for All Enterprises...nbsp;nbsp; /SPAN/SPAN/FONT/DIV BLOCKQUOTE style=MARGIN-RIGHT: 0px DIV class=OutlookMessageHeaderFONT face=Times New Roman size=2-Original Message-BRBFrom:/B Saravana Kumar [mailto:[EMAIL PROTECTED]]BRBSent:/B Monday, July 23, 2001 3:55 AMBRBTo:/B Multiple recipients of list ORACLE-LBRBSubject:/B Supert market desgnBRBR/DIV/FONT DIVFONT face=Arial size=2Hi friends,/FONT/DIV DIVFONT face=Arial size=2nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp ;nbsp;nbsp;nbsp;nbsp;nbsp;nbsp;I would like to know thenbsp;name of site where i could find any document related to designing of database for a/FONT/DIV DIVFONT face=Arial size=2supermarket chain speard across the country./FONT/DIV DIVFONT face=Arial size=2/FONTnbsp;/DIV DIVFONT face=Arial size=2Please help me regarding the document./FONT/DIV DIVFONT face=Arial size=2/FONTnbsp;/DIV DIVFONT face=Arial size=2Thank's in advance./FONT/DIV DIVFONT face=Arial size=2/FONTnbsp;/DIV DIVFONT face=Arial size=2Regards/FONT/DIV DIVFONT face=Arial size=2/FONTnbsp;/DIV DIVFONT face=Arial size=2Saravana./FONT/DIV DIVFONT face=Arial size=2/FONTnbsp;/DIV/BLOCKQUOTE/BODY/HTML -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Rollback seg for big job
Joan, yikes! I think I'm glad I don't do this. Rachel From: Joan Hsieh [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: Rollback seg for big job Date: Fri, 27 Jul 2001 10:21:04 -0800 Rachel, we are 8.16. We tried on line a bigrolbk, set tran on this rollback and took it offline. Guess what? the job was killed also. Oracle support said this is a bug, should be fixed 8.17. Joan Rachel Carmichael wrote: well.. you could sort of help to guarantee that no one else uses it. First, bring it online, do a set transaction to use that rollback segment, then (in another session), take that rollback segment offline. since you are already using it, it doesn't REALLY go offline (until your transaction ends) but no one else will be assigned to it either. Sneaky. Rachel From: Jon Walthour [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Rollback seg for big job Date: Fri, 27 Jul 2001 04:51:09 -0800 Prasad: As far as I know (and listers please correct me if I'm wrong) you can't single out the rollback segment you are using for that big transaction EXCLUSIVELY. In other words, since the rbs is still online and available, there is still the potential that another transaction could use that rbs as well. However, if you're running it at night, wouldn't your activity level be lower and thus the odds of getting another transaction in the same rbs be much lower as well? Just my 2 cents. Jon Walthour --- Original Message --- From: prasad maganti [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: 7/27/01 7:16:11 AM Hi dba's can anybody clarify my doubt reg. RBS. i need to run a very big job in night times. so , i have to create a very bigh rollback segment purely intended for that job. so i will set at sql set trnx use rollback seg.. my doubt is whether this rollback segment stores the rollback of my job or will it allow any other rollback of the database (that is not part of my job) prasad. __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: prasad maganti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jon Walthour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joan Hsieh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this
RE: Rollback Segment needs recovery
A long time ago Oracle support had me put this into my Init.ora file when I had a bad Rollback segment that would not let go of a transaction. _corrupted_rollback_segments=(RBS01) # Marks a rollback segment corrupted so it can be dropped. When I brought up the database I was able to drop that rollback segment. Now, this being one of those illusive undocumented conditions, use at your own risk . or contact Oracle Support first. -Original Message- Sent: Friday, July 27, 2001 12:37 PM To: Multiple recipients of list ORACLE-L Hi DBAs, Oracle 8.0.5/Windows NT4 I shutdown database normal and restarted ok. I tried to drop a rollback segment and getora-1545 rollback segment not available. When I select from dba_rollback_segs I get needs recovery. I want to drop rollback tablespace and all rollback segment then rebuild because I got datafile corruption error. I am in noarchive mode. Any ideas how to proceed? Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cale, Rick T (Richard) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Another Braindead Friday...
Good idea, Tom, but you omitted the 'to ' clause in the grant statement; it should be select 'grant select on ' || table_name || ' to username with grant option;' from user_tables Paul Baumgartel MortgageSight Holdings, LLC [EMAIL PROTECTED] -Original Message- Sent: Friday, July 27, 2001 2:27 PM To: Multiple recipients of list ORACLE-L Scott, I don't see another way to do this, but you could generate the grant statements rather quickly using sql - like set head off set pages 2000 spool grant.sql select 'grant select on ' || table_name || ' with grant option;' from user_tables / spool off @grant and your question about sheep, well, it depends. are you involved with any other livestock? Tom Mercadante Oracle Certified Professional -Original Message- Sent: Friday, July 27, 2001 1:31 PM To: Multiple recipients of list ORACLE-L I have RTFM'd re: the following problem in HPUX11, Oracle 7.3.3: --I have user1 who has select privileges on another schema's table (user2.tab) through Select Any Table privilege. --user1 creates a view on user2.tab and grants select on the view to other users (user3..n) through a shared role. --When user3, et al tries to select from the view they get the infamous ORA-1720 - Grant option does not exist for xxx.xxx error. --I know you I can grant select on user2.tab with grant option to user1 and solve this, but I would rather not do that if at all possible. --Also, I could create the view as user2 and not have the problem. The issue here is user1 needs to create the above type of views on the fly (please! I didn't design it!!!), and with 30 sites to support, there is no way to keep up if I have to create the views one by one. Is there any way around the situation besides the select with grant option clause to user1 (view owner)? Am I an idiot? Are sheep considered dates in TX? HELP Thanks, Scott Shafer San Antonio, TX _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Shafer INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: what do I tune?
-Original Message- Sent: Tuesday, July 24, 2001 1:22 PM To: Multiple recipients of list ORACLE-L Gene: It all depends on a couple of factors: (1) what are the average wait times for each of the wait events, (2) which one(s) have the highest wait times. I would ignore any waits less than 1 centisecond for the most part. Buffer Busy Waits occur when a session is waiting for a buffer to become available. This is because a buffer is either being read into the buffer cache by another session (and the session is waiting for that read to complete) or the buffer is in the buffer cache, but in an incompatible mode(that is, some other session is changing the buffer). There are several courses of action here, depending on what type of block it is: -- If it is a data block, change the pctfree and pctused or, in the case of an index, check for right-hand indexing or increase initrans. The key is to reduce the number of rows/leaves per block to reduce contention. -- If it is a segment header, increase the number of freelists or use freelist groups. -- If it is a freelist block, increase the number of freelists. -- If it is an undo header block, add more rollback segments when in exclusive mode and consider setting transactions per rbs = 1. -- If it is an undo block, add more rollback segments when in exclusive mode or make the segments you have larger. DB file sequential read waits indicate that either (a) an index lookup is being performed or (b) a controlfile is being rebuilt or (c) datafile headers are being dumped or retrieved. In your case, it's probably the first one. Enqueue waits are waits for locks to be released. Taking care of those can be quite complex depending on the types of locks being held and those being requested and on what structures, etc. Latch free waits are waits for another to release a latch on a given resource. The presence of latch free waits of any significant magnitude may indicate a bottleneck within the SGA. It seems obvious that when you turned up the degree of parallelism on the query, the database as you currently have it set up could not handle the load. All these wait events would be consistent with that. Hope this helps. Jon Walthour --- Original Message --- From: Gene Gurevich [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: 7/24/01 11:56:29 AM Hi all: I am trying to tune some queries. I ran them all in one stream (in sequence) and then ran them in several (up to 64) parallel streams. I got a snapshot of the system for each run. I see some of the waits went up significantly when I switched from 2 parallel streams to 64: buffer busy wait, db file seq read, enqueue waits, latch free waits and many more. Now some of this increases may be OK, some may be not. My question is how do I decide which of these waits are a problem and should be looked into and which are normal and can be safely ignored. Are there any quantative rules that I could use? thank you for any insight Gene = __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gene Gurevich INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jon Walthour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Horne, Joe INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line
Re: any way to stop rollback for dml?/8.1.7.1/Solaris 8
Steve, Even we do have the same kind of requirement. AFAIK, there is no way except INSERT with APPEND hint (Direct Load Insert). See Direct-load Insert chapter in concepts manual. Unfortunately Direct load insert works with Insert .. select, not Insert .. values syntax. hth, prasad Austin, Steve S To: Multiple recipients of list ORACLE-L steve.s.aust[EMAIL PROTECTED] [EMAIL PROTECTED] cc: Sent by: Subject: any way to stop rollback for root@fatcity.dml?/8.1.7.1/Solaris 8 com 07/27/2001 03:02 PM Please respond to ORACLE-L Does anyone know of a way to inhibit rollback from being generated for DML? We've got a data warehouse load process that we're trying to speed up (involving sqlldr and then some DML afterwards.) The staging tables it uses are entirely for this process -- there's no need to rollback if it fails; we'd truncate them and start again with that set of data. Aside from sqlldr direct mode and import direct mode, can anyone think of ways to do this? Thanks, Steve -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Austin, Steve S INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Rollback Segment needs recovery
Hello, It's bad problem. I think _offline_rollback_segments or _corrupted_rollback_segments should be last method. I'll recommend a tip for this error: If you can identify which objects need recovery and then drop them, Oracle doesn't try to recover them, so needs recovery goes away. Let's identify which object need recovery in corrupted rbs: - add following parameters to init.ora: event=10013 trace name context forever, level 10 event=10015 trace name context forever, level 10 Note that if there are more than 1 event in init.ora, they have to be consecutive. otherwise just last one will be active. Now, re-start db abd try to get same error. Oracle will dump recovery operation in alert.log. And you will be able to see object id. drop this object. That's all. You can paste recovery dumps in alert.log to identify your object, as well. regards... 27/7/01 08:37:06, Cale, Rick T (Richard) [EMAIL PROTECTED] wrote: Hi DBAs, Oracle 8.0.5/Windows NT4 I shutdown database normal and restarted ok. I tried to drop a rollback segment and getora-1545 rollback segment not available. When I select from dba_rollback_segs I get needs recovery. I want to drop rollback tablespace and all rollback segment then rebuild because I got datafile corruption error. I am in noarchive mode. Any ideas how to proceed? Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cale, Rick T (Richard) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Strange behavior: Update with select
Strange behavior : Update with select stt. select stt in update 1 is NOT working correct and select stt in update 2 is working correct though the select statements are logically same. Explanation: select stt in update 1 doesn't return any data even though it suppose to return one record. To confirm that the select stt returns one record, I prepared select stt by joining the table(claim) that is updated with the tables used in select stt(pls see select 1). It is returning one record. Then, I modified the select stt (pls see update 2) in update stt and it is working fine. The difference between these two select statements is, In update 1 select stt, table r is joining with p and r joining with p615. In update 2 select stt, table r is joing with p and p is joining with p615. The way the data is: join with r and p yields 1 record and join with r and p615 yields no record. explain plan on update 1: sort join and then merge join cartesian. explain plan on update 2: nested loops outer join. explain plan on select 1: nested loops outer join. I belive, update 1 is not working correct because the second join (r and p615) resulting no data hence the merge join cartesian resulting with no data. Even though optimizer generates different plans for update 1 and 2, final result should be the same. FYI, In the select statement, same table is being used with different aliases (p and p615). Your thoughts are appreciated. It is very interesting, at least for me. Thanks prasad Update 1: UPDATE claim r SET disability_definition = (SELECT p.option_description || ' ' || RTRIM(p.description) || DECODE(p.duration_code, 'Y',' YEAR(S)', 'M',' MONTH(S)', 'D',' DAY(S)', 'C',' CAL.YEAR', 'L',' LIFE TIME', 'A',' YEARS OF AGE', 'W',' WEEK(S)',NULL) || ' ' || p615.option_description || ' ' || RTRIM(p615.description) || DECODE(p615.duration_code, 'Y',' YEAR(S)', 'M',' MONTH(S)', 'D',' DAY(S)', 'C',' CAL.YEAR', 'L',' LIFE TIME', 'A',' YEARS OF AGE', 'W',' WEEK(S)',NULL) FROM coverage_provision p, coverage_provision p615 WHERE p.provision_id = '614' AND r.case_id = p.case_id AND r.coverage_category_code = p.coverage_category_code AND r.coverage_type_code = p.coverage_type_code AND r.coverage_plan_number = p.coverage_plan_number AND r.class_code = p.class_code AND r.disability_date = p.eff_date AND r.disability_date NVL(p.term_date, r.disability_date+1) AND r.case_id = p615.case_id(+) AND r.coverage_category_code = p615.coverage_category_code(+) AND r.coverage_type_code = p615.coverage_type_code(+) AND r.coverage_plan_number = p615.coverage_plan_number(+) AND r.class_code = p615.class_code(+) AND r.disability_date = p615.eff_date(+) AND r.disability_date NVL(p615.term_date(+), r.disability_date+1) AND p615.provision_id(+) = '615' ) WHERE r.coverage_category_code = 'LTD' AND r.coverage_type_code = 'ABIL' AND NVL(r.coverage_plan_number,'UNK') 'UNK' AND NVL(r.class_code,'UNK') 'UNK' AND r.claim_event_id='999' ; Select 1: SELECT p.option_description || ' ' || RTRIM(p.description) || DECODE(p.duration_code, 'Y',' YEAR(S)', 'M',' MONTH(S)', 'D',' DAY(S)', 'C',' CAL.YEAR', 'L',' LIFE TIME', 'A',' YEARS OF AGE', 'W',' WEEK(S)',NULL) || ' ' || p615.option_description || ' ' || RTRIM(p615.description) || DECODE(p615.duration_code, 'Y',' YEAR(S)', 'M',' MONTH(S)', 'D',' DAY(S)', 'C',' CAL.YEAR', 'L',' LIFE TIME', 'A',' YEARS OF AGE', 'W',' WEEK(S)',NULL) FROM claim r, coverage_provision p, coverage_provision p615 WHERE p.provision_id = '614' AND p615.provision_id(+) = '615' AND r.case_id = p.case_id AND
RE: Dangerous AIX Bug!
IBM is definitely keeping NUMA-Qwhich is the marketing name for that part of Dynix. the nubby core of Dynix/ptx is already duplicated ( as it would be for any *nix ) by AIX. -Original Message- Sent: Friday, July 27, 2001 10:46 AM To: Multiple recipients of list ORACLE-L Fantastic - BUT where is the Dynix. ?? Lee -Original Message- Sent: 26 July 2001 23:16 To: Multiple recipients of list ORACLE-L OH MY GOD. that is s useful! A blessing on your family, your family's family, and your family's family's family. Oh hell, throw in a beer for yourself. thanks, Ross -Original Message- Sent: Thursday, July 26, 2001 4:52 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Ross, Check this link. You may find it useful. http://home.earthlink.net/~bhami/rosetta.html Regards, Denny Mohan, Ross wrote: :) My biggest concern is porting db's from other unix flavors...i wish there were a cross platfrom shell porting guide. Sure, ls is ls, but every mfgr changes the order/formatting of the flags and/or output. I am compiling responses and will post a summary. I have some good stuff so far hth Ross p.s. I wish i could get some (mostly) grass fed beef! ;-) _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: PL/SQL Question after migrating from 7.3.4 to 8.1.7
Use %ROWTYPE. TYPE tb_uc9_corres_type IS TABLE OF uc9_correspondence%ROWTYPE INDEX BY BINARY_INTEGER; hth, prasad Deen Dayal [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L ate.nj.us[EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED]Subject: PL/SQL Question after migrating from om7.3.4 to 8.1.7 07/27/2001 01:45 PM Please respond to ORACLE-L Hi, I just migrated from 734 to 817, I used migration utility. Migration went fine. Some of my package specification have become invalid. When I tried to recompile, I got the following error 30/41PLS-00206: %TYPE must be applied to a variable, column, field or attribute, not to UC9_CLAIM_AMOUNT The source is listed below. uc9_correspondence is table in my schema. I do not know why this is throwing up an error where as 734 was happy with it. TYPE tb_uc9_corres_type IS TABLE OF uc9_correspondence%TYPE INDEX BY BINARY_INTEGER; Any help is appreciated Thanks in ADvance deen -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deen Dayal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Redo for Rollback segs
It is? Ah, but will it bring me tea and toast when I am sick in bed? Rachel. it's a silly sort of day today, too many meetings with too many sales reps From: [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: Redo for Rollback segs Date: Fri, 27 Jul 2001 10:57:40 -0800 Yes, it will. The concepts manual is your friend. Jared prasad maganti prasadm_g@yah To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] oo.com cc: Sent by: Subject: Redo for Rollback segs [EMAIL PROTECTED] om 07/27/01 08:22 AM Please respond to ORACLE-L When we enter data or delete date(modifying data blocks) , that will generate some redo. and my doubt is: when we delete some data in the database, that will further insert information into Rollback segment transaction tables (means furtherly it is modifying some block of oracle). Will this generate Redo? prasad __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: prasad maganti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Rollback Segment needs recovery
Danisment; When we had a problem that we needed the _corrupted_rollback_segments option added to the init.ora file. The Rollback Segment itself was corrupted. Not the objects using the Rollback Segment. If this is the case, dropping the objects will not do the trick because it will happen again when the Rollback Segment is accessed for another activity. -Original Message- Sent: Friday, July 27, 2001 2:17 PM To: Multiple recipients of list ORACLE-L Hello, It's bad problem. I think _offline_rollback_segments or _corrupted_rollback_segments should be last method. I'll recommend a tip for this error: If you can identify which objects need recovery and then drop them, Oracle doesn't try to recover them, so needs recovery goes away. Let's identify which object need recovery in corrupted rbs: - add following parameters to init.ora: event=10013 trace name context forever, level 10 event=10015 trace name context forever, level 10 Note that if there are more than 1 event in init.ora, they have to be consecutive. otherwise just last one will be active. Now, re-start db abd try to get same error. Oracle will dump recovery operation in alert.log. And you will be able to see object id. drop this object. That's all. You can paste recovery dumps in alert.log to identify your object, as well. regards... 27/7/01 08:37:06, Cale, Rick T (Richard) [EMAIL PROTECTED] wrote: Hi DBAs, Oracle 8.0.5/Windows NT4 I shutdown database normal and restarted ok. I tried to drop a rollback segment and getora-1545 rollback segment not available. When I select from dba_rollback_segs I get needs recovery. I want to drop rollback tablespace and all rollback segment then rebuild because I got datafile corruption error. I am in noarchive mode. Any ideas how to proceed? Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cale, Rick T (Richard) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: any way to stop rollback for dml?/8.1.7.1/Solaris 8
nologging isnt any good except for a few things, and normal DML is not it. all normal DML is logged regardless of nologging/unrecoverable options. joe [EMAIL PROTECTED] 07/27/01 04:11PM alter table schema.table_name nologging; Jenny Jacobson www.oracle-dba-consulting.com On Fri, 27 Jul 2001, Austin, Steve S wrote: Does anyone know of a way to inhibit rollback from being generated for DML? We've got a data warehouse load process that we're trying to speed up (involving sqlldr and then some DML afterwards.) The staging tables it uses are entirely for this process -- there's no need to rollback if it fails; we'd truncate them and start again with that set of data. Aside from sqlldr direct mode and import direct mode, can anyone think of ways to do this? Thanks, Steve -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Austin, Steve S INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jenny Jacobson INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: JOE TESTA INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: any way to stop rollback for dml?/8.1.7.1/Solaris 8
Steve, As far as speeding up the sqlldr process, you could take a look at an article on O'Reilly's web site. It's at http://oracle.oreilly.com/news/oraclesqlload_0401.htmland documents the fairly painless process I used to speed up data loads we are doing here. HTH Stephen Andert [EMAIL PROTECTED] 07/27/01 12:02PM Does anyone know of a way to inhibit rollback from being generated for DML?We've got a data warehouse load process that we're trying to speed up(involving sqlldr and then some DML afterwards.) The staging tables it usesare entirely for this process -- there's no need to rollback if it fails;we'd truncate them and start again with that set of data.Aside from sqlldr direct mode and import direct mode, can anyone think ofways to do this? Thanks,Steve-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Austin, Steve S INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
RE: Solaris Release Vs. Version
Solaris includes SunOS plus the Openwin environment. Solaris 2.5.1 = SunOS 5.5.1 plus Openwin 3.5.1 (I could get the openwin version wrong as I don't have access to a Sun box right now). [EMAIL PROTECTED] 07/27/01 12:31PM The module that is responding to uname -a is SunOS. This is different from Solaris, but it's confusing why. I guess historically the primary interface was command-line, and not CDE? (i.e. maybe solaris:sunos :: gui:command-line) Here's a table I found on the web that may help... SunOS 5.3 = Solaris 2.3 SunOS 5.4 = Solaris 2.4 SunOS 5.5 = Solaris 2.5 SunOS 5.5.1 = Solaris 2.5.1 SunOS 5.6 = Solaris 2.6 SunOS 5.7 = Solaris 7 (aka Solaris 2.7) SunOS 5.8 = Solaris 8 (aka Solaris 2.8) .. .and before you get too riled up, ask yourself why Oracle 8.1.6 is also known as 8iv2 :) happy weekend everyone! Steve -Original Message- Sent: Friday, July 27, 2001 10:11 AM To: Multiple recipients of list ORACLE-L Hi thanq for responding . but still i am not clear about it. can you clarify. because in oracle we call version 8.1.7 ... but here what is the release and version. can you go more deep? 2.6 is version 6 of oracle is it any hardware release. prasad --- Christopher Spence [EMAIL PROTECTED] wrote: There is probably something wrong or it is truly 2.7. 2.6 is Version 6 of Solaris 2.7 is Version 7 of Solaris They are completely different versions. Nothing about them is similar in terms of release. Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Friday, July 27, 2001 7:11 AM To: Multiple recipients of list ORACLE-L hi dba's can any body tell me the difference between the release and version of Sun solaris. i am working on solaris platform. when i login to the server, i get prompt Sun 5.7 where the version is 2.6 what is the difference between these 2? prasad. __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: prasad maganti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: prasad maganti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Austin, Steve S INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other
RE: Strange behavior: Update with select
not sure, but: AND r.disability_date = p615.eff_date(+) AND r.disability_date NVL(p615.term_date(+),r.disability_date+1) Looks fishy. The (+) operation acts funny in situations other than one or the other sides of an =. Try: AND r.disability_date = NVL(p615.term_date,r.disability_date) AND r.disability_date NVL(p615.term_date,r.disability_date+1) Brian Norrell Manager, MPI Development QuadraMed 511 E John Carpenter Frwy, Su 500 Irving, TX 75062 (972) 831-6600 -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Friday, July 27, 2001 2:31 PM To: Multiple recipients of list ORACLE-L Strange behavior : Update with select stt. select stt in update 1 is NOT working correct and select stt in update 2 is working correct though the select statements are logically same. Explanation: select stt in update 1 doesn't return any data even though it suppose to return one record. To confirm that the select stt returns one record, I prepared select stt by joining the table(claim) that is updated with the tables used in select stt(pls see select 1). It is returning one record. Then, I modified the select stt (pls see update 2) in update stt and it is working fine. The difference between these two select statements is, In update 1 select stt, table r is joining with p and r joining with p615. In update 2 select stt, table r is joing with p and p is joining with p615. The way the data is: join with r and p yields 1 record and join with r and p615 yields no record. explain plan on update 1: sort join and then merge join cartesian. explain plan on update 2: nested loops outer join. explain plan on select 1: nested loops outer join. I belive, update 1 is not working correct because the second join (r and p615) resulting no data hence the merge join cartesian resulting with no data. Even though optimizer generates different plans for update 1 and 2, final result should be the same. FYI, In the select statement, same table is being used with different aliases (p and p615). Your thoughts are appreciated. It is very interesting, at least for me. Thanks prasad Update 1: UPDATE claim r SET disability_definition = (SELECT p.option_description || ' ' || RTRIM(p.description) || DECODE(p.duration_code, 'Y',' YEAR(S)', 'M',' MONTH(S)', 'D',' DAY(S)', 'C',' CAL.YEAR', 'L',' LIFE TIME', 'A',' YEARS OF AGE', 'W',' WEEK(S)',NULL) || ' ' || p615.option_description || ' ' || RTRIM(p615.description) || DECODE(p615.duration_code, 'Y',' YEAR(S)', 'M',' MONTH(S)', 'D',' DAY(S)', 'C',' CAL.YEAR', 'L',' LIFE TIME', 'A',' YEARS OF AGE', 'W',' WEEK(S)',NULL) FROM coverage_provision p, coverage_provision p615 WHERE p.provision_id = '614' AND r.case_id = p.case_id AND r.coverage_category_code = p.coverage_category_code AND r.coverage_type_code = p.coverage_type_code AND r.coverage_plan_number = p.coverage_plan_number AND r.class_code = p.class_code AND r.disability_date = p.eff_date AND r.disability_date NVL(p.term_date, r.disability_date+1) AND r.case_id = p615.case_id(+) AND r.coverage_category_code = p615.coverage_category_code(+) AND r.coverage_type_code = p615.coverage_type_code(+) AND r.coverage_plan_number = p615.coverage_plan_number(+) AND r.class_code = p615.class_code(+) AND r.disability_date = p615.eff_date(+) AND r.disability_date NVL(p615.term_date(+), r.disability_date+1) AND p615.provision_id(+) = '615' ) WHERE r.coverage_category_code = 'LTD' AND r.coverage_type_code = 'ABIL' AND NVL(r.coverage_plan_number,'UNK') 'UNK' AND NVL(r.class_code,'UNK') 'UNK' AND r.claim_event_id='999' ; Select 1: SELECT p.option_description || ' ' || RTRIM(p.description) || DECODE(p.duration_code, 'Y',' YEAR(S)', 'M',' MONTH(S)', 'D',' DAY(S)', 'C',' CAL.YEAR', 'L',' LIFE TIME', 'A',' YEARS OF AGE', 'W',' WEEK(S)',NULL) || ' ' || p615.option_description || ' ' || RTRIM(p615.description) || DECODE(p615.duration_code,
Re: any way to stop rollback for dml?/8.1.7.1/Solaris 8
alter table schema.table_name nologging; Jenny Jacobson www.oracle-dba-consulting.com On Fri, 27 Jul 2001, Austin, Steve S wrote: Does anyone know of a way to inhibit rollback from being generated for DML? We've got a data warehouse load process that we're trying to speed up (involving sqlldr and then some DML afterwards.) The staging tables it uses are entirely for this process -- there's no need to rollback if it fails; we'd truncate them and start again with that set of data. Aside from sqlldr direct mode and import direct mode, can anyone think of ways to do this? Thanks, Steve -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Austin, Steve S INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jenny Jacobson INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Rollback Segment needs recovery
please do offline then drop -Seema From: Cale, Rick T (Richard) [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Rollback Segment needs recovery Date: Fri, 27 Jul 2001 10:06:38 -0800 I was able to do everything I needed by using undocumented/unsupported _offline_rollback_segments parameter. Rick -Original Message- Sent: Friday, July 27, 2001 1:37 PM To: Multiple recipients of list ORACLE-L Hi DBAs, Oracle 8.0.5/Windows NT4 I shutdown database normal and restarted ok. I tried to drop a rollback segment and getora-1545 rollback segment not available. When I select from dba_rollback_segs I get needs recovery. I want to drop rollback tablespace and all rollback segment then rebuild because I got datafile corruption error. I am in noarchive mode. Any ideas how to proceed? Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cale, Rick T (Richard) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cale, Rick T (Richard) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re[2]: Another Braindead Friday...
Scott, You between the same rock and hard place I am. Welcome to the club. Dick Goulet Reply Separator Author: Scott Shafer [EMAIL PROTECTED] Date: 7/27/2001 11:02 AM I thought about that. Unfortunately the business rules developed by non-Oracle-literate individuals specifically prohibit this. Each site has an unknown number of 3rd party tools which their users can use to connect with. Most regular lusers have access only to a secure view which constrains the data that they can see. I have invariably found several cartesian products when direct select permissions have been granted. Damagement wants anyone to be able to use any tools that make them happy (for the uninitiated - this is a bad idea for sensitive data). Why you ask are they now wanting a select through another view (which may violate this prohibition anyway)? You got me. The minds of beaurocrats are not for mere mortals to play in... That and my creativity is at an all time low due to lack of sleep. Thanks, Scott Hillman, Alex wrote: another user should have select privileges for underlying table directly, not thru the role. Alex Hillman -Original Message- Sent: Friday, July 27, 2001 1:31 PM To: Multiple recipients of list ORACLE-L I have RTFM'd re: the following problem in HPUX11, Oracle 7.3.3: --I have user1 who has select privileges on another schema's table (user2.tab) through Select Any Table privilege. --user1 creates a view on user2.tab and grants select on the view to other users (user3..n) through a shared role. --When user3, et al tries to select from the view they get the infamous ORA-1720 - Grant option does not exist for xxx.xxx error. --I know you I can grant select on user2.tab with grant option to user1 and solve this, but I would rather not do that if at all possible. --Also, I could create the view as user2 and not have the problem. The issue here is user1 needs to create the above type of views on the fly (please! I didn't design it!!!), and with 30 sites to support, there is no way to keep up if I have to create the views one by one. Is there any way around the situation besides the select with grant option clause to user1 (view owner)? Am I an idiot? Are sheep considered dates in TX? HELP Thanks, Scott Shafer San Antonio, TX _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Shafer INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Running out of extents on temporary tablespace
Oracle 8.0.5.1.1 I am getting the ORA-01630 max number of extents (505) for a temp segment in my temporary tablespace message when I do a select count(*) I have two tables, 1. has 300,000+ rows 2. has 1,200,000 rows I retrieved the numbers by performing a select count(*) from xx. I have a view that unions the two tables together for reporting purposes. If I try to do a select count(*) on the view, I run out of extents. Also on occasion when we rebuild table 2, I also run out of extents. (ORA-01630) I am assuming that it is the sort_area_size parameter that may be causing the problem, but I am not sure. The temp tablespace and parameter values are as follows : initial extent = 524288 next extent = 524288 sort_area_size = 524288. Checking the sysstat table I receive the following, which according to some of the books I have read indicate whether or not there is an issue with the sort_area_size parameter. NAMEVALUE -- -- sorts (memory) 35,128 sorts (disk) 155 Another tips, comments or looking in a different area to resolve this would be greatly appreciated Thanks Darren - Darren Browett P.EngThis message was transmitted Systems Admin/DBA using 100% recycled electrons Information and Communications Technology. City of Coquitlam P:(604) 927 - 3614 E:[EMAIL PROTECTED] - -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Browett, Darren INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Year of Unix file
Is this anything like the year of the cat? Jared prasad maganti prasadm_g@yah To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] oo.com cc: Sent by: Subject: Year of Unix file [EMAIL PROTECTED] om 07/27/01 04:10 AM Please respond to ORACLE-L Hi dba's when i list the unix file (solaris), with ls -lt command , i am able to see the time, month, date that is created. is there any way to see the year that is created. any commands prasad. __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: prasad maganti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Redo for Rollback segs
On Fri, 27 Jul 2001,Rachel Carmichael scribbled on the wall in glitter crayon: -It is? Ah, but will it bring me tea and toast when I am sick in bed? no, but it will put you to sleep.;-) - -Rachel. it's a silly sort of day today, too many meetings with too many -sales reps i'm not allowed to talk to sales reps, i might find something that makes my job easier to do.;-) -- Bill Shrek Thater Certifiable ORACLE DBA Telergy, Inc.[EMAIL PROTECTED] ~~ You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. ~~ If a program is useful, it must be changed. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thater, William INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
