RE: Way of extracting record
Cool Tools have a tool that can assist with this The Extraction and load tool from Databee http://www.cool-tools.co.uk/ Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = A great pleasure in life is doing what people say you cannot do. - Walter Bagehot (1826-1877 British Economist) = Mincom The People, The Experience, The Vision = This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. Deshpande, Kirti [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01-10-2002 02:13 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Way of extracting record 1. You can use SQL*Plus COPY command to copy data from Production into development database. 2. You can create a link from Development database to Production database, and then use insert into Development database table by selecting data from table@Production database. 3. You can use export with QUERY option to export just the rows you need from each table in Production and import those into Development database. However, it will depend on how easy it is to get to the required data by the QUERY option (available with Oracle 8i). I would go with #1 first. Check SQL*Plus Reference Guide for (1) and (2) Check Utilities Guide for (3). HTH.. - Kirti -Original Message- Sent: Monday, September 30, 2002 9:18 PM To: Multiple recipients of list ORACLE-L Hi guru , I need your advise , currently our customer have a production and development system , if there is a problem log being raise , then we need to port the data from development to production but not the whole database sometime is only certain record. Is there any method to use instead of generate insert statement for necessary table(PROD) and run the statement (DEV) ? I do think of using XML but I don't know how to do it -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raymond INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). STG20975 Description: Binary data
[no subject]
RE: Index question
Thanks you all for your response Ofer -Original Message- Sent: Thursday, September 19, 2002 3:23 PM To: Multiple recipients of list ORACLE-L Testing against 8.1.7.4, the drop index was successful and an error was reported by my long running query: ERROR: ORA-08103: object no longer exists Is this because the index is locked by query only when it's used? From one side looks reasonable, but from another - no good someone can drop an index user by running query. Is there any index locking at all?? Regards, Alexandre Regards, Larry G. Elkins [EMAIL PROTECTED] 214.954.1781 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Ofer Harel Sent: Thursday, September 19, 2002 6:09 AM To: Multiple recipients of list ORACLE-L Subject: Index question Good morning, Suppose there is a long running query (which already parsed) using an index. Now I dropped the index. What should happened to the running query? Ofer Harel DBA team Barak ITC [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Larry Elkins INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Alexandre Gorbatchev INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Ofer Harel INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Way of extracting record
IF you can identify the problem rows automatically, and flag them as such in your production environment, then you can have those rows automatically copied (or moved - your choice) to your development machine (presumably using database links). For what its worth, we have been doing just this for years, fully automated. Its replication, but not as Oracle recognises the term! peter edinburgh Deshpande, Kirti [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01-10-2002 02:13 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Way of extracting record 1. You can use SQL*Plus COPY command to copy data from Production into development database. 2. You can create a link from Development database to Production database, and then use insert into Development database table by selecting data from table@Production database. 3. You can use export with QUERY option to export just the rows you need from each table in Production and import those into Development database. However, it will depend on how easy it is to get to the required data by the QUERY option (available with Oracle 8i). I would go with #1 first. Check SQL*Plus Reference Guide for (1) and (2) Check Utilities Guide for (3). HTH.. - Kirti -Original Message- Sent: Monday, September 30, 2002 9:18 PM To: Multiple recipients of list ORACLE-L Hi guru , I need your advise , currently our customer have a production and development system , if there is a problem log being raise , then we need to port the data from development to production but not the whole database sometime is only certain record. Is there any method to use instead of generate insert statement for necessary table(PROD) and run the statement (DEV) ? I do think of using XML but I don't know how to do it -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raymond INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). * This e-mail message, and any files transmitted with it, are confidential and intended solely for the use of the addressee. If this message was not addressed to you, you have received it in error and any copying, distribution or other use of any part of it is strictly prohibited. Any views or opinions presented are solely those of the sender and do not necessarily represent those of the British Geological Survey. The security of e-mail communication cannot be guaranteed and the BGS accepts no liability for claims arising as a result of the use of this medium to transmit messages from or to the BGS. The BGS cannot accept any responsibility for viruses, so please scan all attachments.http://www.bgs.ac.uk * -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robson, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: DBA work load - BDBAFH #1
Title: RE: DBA work load - BDBAFH #1 H. How come I always seem to be the DBA who can't say no - you don't seem to have that problem at all. -Original Message- From: Conboy, Jim [mailto:[EMAIL PROTECTED]] Sent: Monday, September 30, 2002 3:58 PM To: Multiple recipients of list ORACLE-L Subject: RE: DBA work load - BDBAFH #1 The phone rings. Another user. Still pissed off, I pick it up... Database Administration, can I help you? I answer professionally. Troubled silence on the phone. Politeness is a very bad signal from me and they know it. He was rattled. Uh, hi, this is Joe, technical lead on that super-critical project for Benefits? Is this a good time? I have some stuff I need moved to production? The last was a statement, but it came out like a question. With a slight quaver in the voice, too. Excellent. Technical lead my arse. Could you be more specific so I can schedule you appropriately? He hesitated. Gosh, I sounded for real. I almost convinced myself. The victim approached warily. I've got a bunch of PL/SQL packages and some outlines to speed up the queries with special hints. The scripts are all ready for your review, they include the create statements, the grants, everything. I'm forwarding the email package to you with signoffs from IT, the user department, and your own from reviewing our design and test results. This last was delivered with almost pathetic eagerness. Good boy. Good, simple, foolish boy. If he could see me he'd be terrified by my grin. Joe, I need you to help me out. You've just given me 10 minutes of work, but I'm due for lunch in 5 minutes. What do you suggest I do? Joe knew better, he really did. But his team had been up all night finishing and the prize was so close... Look, I really hate to impose. But we've missed several major deadlines, and department head has made it clear if we screw up again he'll outsource the whole project and have us laid off. I need it now so we can make sure everything's perfect for the big production run at COB today. Consider it done, I promised cheerfully and hung up. I surprised him, and maybe myself, with my good spirits. Especially since I was more than 5 minutes late, closer to fifteen, and my buddies were already into their second beer when I joined them for lunch. But the extra 10 minutes had been well worth it considering what I managed to do to those hints with the outline editor. Just the same, though, I turned off my cell phone in case the twit called to find out why his 5-second queries took almost an hour. Can't have him taking me for granted, can I? Later that evening, after quaffing several (all right, numerous) more ales with the boys, I dialed in from home to check how things were going. Mr. Tech Lead was still logged in, no doubt desperately trying to determine why things were taking forever. Poor Mr. Tech Lead, another sleepless night. I logged off, turned out the light, and slept like a baby. Next morning, hangover. The phone rings. I snatch it up angrily... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Conboy, Jim INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: DBA work load - BDBAFH #1
Title: RE: DBA work load - BDBAFH #1 I wish I could chuck my catholicism just a little to do something just a little like that - man! -Original Message- From: Bob Metelsky [mailto:[EMAIL PROTECTED]] Sent: Monday, September 30, 2002 5:53 PM To: Multiple recipients of list ORACLE-L Subject: RE: DBA work load - BDBAFH #1 I don't know how he can live with himself LMAO -Original Message- Sent: Monday, September 30, 2002 2:58 PM To: Multiple recipients of list ORACLE-L The phone rings. Another user. Still pissed off, I pick it up... Database Administration, can I help you? I answer professionally. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
UNSUSCRIBE
Title: RE: DBA work load - BDBAFH #1 [EMAIL PROTECTED]
RE: UNSUSCRIBE
Title: RE: DBA work load - BDBAFH #1 [EMAIL PROTECTED] -Original Message-From: Pablo Campos Durante [mailto:[EMAIL PROTECTED]]Sent: Tuesday, October 01, 2002 5:58 AMTo: Multiple recipients of list ORACLE-LSubject: UNSUSCRIBE [EMAIL PROTECTED]
Re: Way of extracting record
If the schema has any complexity then manually identifying and extracting the required dependent records can be quite troublesome. There is a white paper on the DataBee web site entitled Test Database Generation and Management that discusses the issues in some detail. http://www.databee.com/TestDBGenWhitePaper.pdf We also provide an automated tool designed for the purpose of creating referentially correct subsets of data. It may be useful in your case. Kind regards Dale Edgar Net 2000 Ltd. [EMAIL PROTECTED] http://www.DataBee.com I need your advise , currently our customer have a production and development system , if there is a problem log being raise , then we need to port the data from development to production but not the whole database sometime is only certain record. Is there any method to use instead of generate insert statement for necessary table(PROD) and run the statement (DEV) ? I do think of using XML but I don't know how to do it -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: UNSUSCRIBE
GRIN Hallo, What is UNSUSCRIBE...I have function in Access but cannot find in Oracle? Please help. -Original Message- Sent: 01 October 2002 12:13 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] -Original Message- Sent: Tuesday, October 01, 2002 5:58 AM To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thomas, Kevin INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: ok so i'm bored working on rman scripts
Just go for it! That's what I did, out of necessity, I just implemented it and waited until it got better. 8) Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, September 30, 2002 8:48 PM Ruth, just some experiments, going to implement it for ERP at longaberger, so i need to do proof of concept. not stuck(yet) just experimenting. joe Ruth Gramolini wrote: Joe, What are you trying to do with rman? Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, September 26, 2002 2:17 PM so i took the first 2 stories and put them on http://www.oracle-dba.com/bdbafh nothing pretty, maybe i'll mess with it later today, text only so far. feel free to submit your part of the on-going saga to [EMAIL PROTECTED] joe -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: DBA work load - BDBAFH #1
Paula, It just takes practice. You can learn to say no. I did. You just have to work up to it :) You start with: If I do that for you now, I will fall behind x days on the critical project I am working on for you move on to: I'm sorry. I have too much to do then to: not gonna happen and finally, either of the following: what part of the word NO don't you understand? or (my personal favorite) failure to plan on your part does not constitute an emergency on mine Try it, you'll like it --- [EMAIL PROTECTED] wrote: H. How come I always seem to be the DBA who can't say no - you don't seem to have that problem at all. -Original Message- Sent: Monday, September 30, 2002 3:58 PM To: Multiple recipients of list ORACLE-L The phone rings. Another user. Still pissed off, I pick it up... Database Administration, can I help you? I answer professionally. Troubled silence on the phone. Politeness is a very bad signal from me and they know it. He was rattled. Uh, hi, this is Joe, technical lead on that super-critical project for Benefits? Is this a good time? I have some stuff I need moved to production? The last was a statement, but it came out like a question. With a slight quaver in the voice, too. Excellent. Technical lead my arse. Could you be more specific so I can schedule you appropriately? He hesitated. Gosh, I sounded for real. I almost convinced myself. The victim approached warily. I've got a bunch of PL/SQL packages and some outlines to speed up the queries with special hints. The scripts are all ready for your review, they include the create statements, the grants, everything. I'm forwarding the email package to you with signoffs from IT, the user department, and your own from reviewing our design and test results. This last was delivered with almost pathetic eagerness. Good boy. Good, simple, foolish boy. If he could see me he'd be terrified by my grin. Joe, I need you to help me out. You've just given me 10 minutes of work, but I'm due for lunch in 5 minutes. What do you suggest I do? Joe knew better, he really did. But his team had been up all night finishing and the prize was so close... Look, I really hate to impose. But we've missed several major deadlines, and department head has made it clear if we screw up again he'll outsource the whole project and have us laid off. I need it now so we can make sure everything's perfect for the big production run at COB today. Consider it done, I promised cheerfully and hung up. I surprised him, and maybe myself, with my good spirits. Especially since I was more than 5 minutes late, closer to fifteen, and my buddies were already into their second beer when I joined them for lunch. But the extra 10 minutes had been well worth it considering what I managed to do to those hints with the outline editor. Just the same, though, I turned off my cell phone in case the twit called to find out why his 5-second queries took almost an hour. Can't have him taking me for granted, can I? Later that evening, after quaffing several (all right, numerous) more ales with the boys, I dialed in from home to check how things were going. Mr. Tech Lead was still logged in, no doubt desperately trying to determine why things were taking forever. Poor Mr. Tech Lead, another sleepless night. I logged off, turned out the light, and slept like a baby. Next morning, hangover. The phone rings. I snatch it up angrily... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Conboy, Jim INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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!? New DSL Internet Access from SBC Yahoo! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information
Re: Oracle 8i R3, and 9i R2 on Same NT Box
Yes I am here running 8.1.7 and 9i Release 1 ( not release 2) on the same Windows 2000 Server Box. So far so good, this is my test machine. Rajesh - Original Message - Date: Mon, 30 Sep 2002 09:13:30 -0800 To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] This is interesting. I have installed and run multiple Oracle versions on the same Unix box but not NT. Sam Bootsma wrote: Hello, Does anybody out there run Oracle 8.1.7 and Oracle 9.2 on the same NT (or Windows 2000) box? Is it running smoothly. Any difficulties installing or running both versions on the same box? I ask because one of my colleagues has encountered difficulties installing and running Oracle 8.1.7 and Oracle 9.2 on the same NT box. Thanks for any input. Sam Bootsma, OCP Technical Support Analyst CPAS Systems Inc. 416-422-0563 x237 [EMAIL PROTECTED] http://www.cpas.com -- ltiu 3/4 OCP 9i Eh? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- __ Sign-up for your own FREE Personalized E-mail at Mail.com http://www.mail.com/?sr=signup -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rajesh Dayal INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: ok so i'm bored working on rman scripts
And it already is much better. There are some holes, such as the REPORT NEED BACKUP command lacking any awareness of archivelog backups (i.e. only reporting the state of datafile backups alone), but it's easy enough to write custom queries to deal with that. But calling it a hole might be too strong, because with custom-written backup scripts, you don't have *anything* to query and have to parse/examine log output to determine if what's backed up and what's not... As far as more basic backup/restore functionality holes, it's mostly gotchas and diligent catalog maintenance at this point (9i), although better support for object point-in-time recovery would sure be nice so we can put the final nails into the coffin of people using exports for backup purposes. Still, even that can be crafted by reverse-engineering the actual RMAN commands hiding behind macros like DUPLICATE TARGET DATABASE, and 9i at least offers the ability to perform this down to the tablespace level (if not the object-level)... Go for it, indeed! Nowadays, *not* going for it is the real risk... - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, October 01, 2002 6:38 AM Just go for it! That's what I did, out of necessity, I just implemented it and waited until it got better. 8) Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, September 30, 2002 8:48 PM Ruth, just some experiments, going to implement it for ERP at longaberger, so i need to do proof of concept. not stuck(yet) just experimenting. joe Ruth Gramolini wrote: Joe, What are you trying to do with rman? Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, September 26, 2002 2:17 PM so i took the first 2 stories and put them on http://www.oracle-dba.com/bdbafh nothing pretty, maybe i'll mess with it later today, text only so far. feel free to submit your part of the on-going saga to [EMAIL PROTECTED] joe -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: DBA work load - BDBAFH #1
My favourite when they come to your desk... Ah, I see the f..k up fairy has come to visit (Apologies for profanity) :-) --- Rachel Carmichael [EMAIL PROTECTED] wrote: Paula, It just takes practice. You can learn to say no. I did. You just have to work up to it :) You start with: If I do that for you now, I will fall behind x days on the critical project I am working on for you move on to: I'm sorry. I have too much to do then to: not gonna happen and finally, either of the following: what part of the word NO don't you understand? or (my personal favorite) failure to plan on your part does not constitute an emergency on mine Try it, you'll like it --- [EMAIL PROTECTED] wrote: H. How come I always seem to be the DBA who can't say no - you don't seem to have that problem at all. -Original Message- Sent: Monday, September 30, 2002 3:58 PM To: Multiple recipients of list ORACLE-L The phone rings. Another user. Still pissed off, I pick it up... Database Administration, can I help you? I answer professionally. Troubled silence on the phone. Politeness is a very bad signal from me and they know it. He was rattled. Uh, hi, this is Joe, technical lead on that super-critical project for Benefits? Is this a good time? I have some stuff I need moved to production? The last was a statement, but it came out like a question. With a slight quaver in the voice, too. Excellent. Technical lead my arse. Could you be more specific so I can schedule you appropriately? He hesitated. Gosh, I sounded for real. I almost convinced myself. The victim approached warily. I've got a bunch of PL/SQL packages and some outlines to speed up the queries with special hints. The scripts are all ready for your review, they include the create statements, the grants, everything. I'm forwarding the email package to you with signoffs from IT, the user department, and your own from reviewing our design and test results. This last was delivered with almost pathetic eagerness. Good boy. Good, simple, foolish boy. If he could see me he'd be terrified by my grin. Joe, I need you to help me out. You've just given me 10 minutes of work, but I'm due for lunch in 5 minutes. What do you suggest I do? Joe knew better, he really did. But his team had been up all night finishing and the prize was so close... Look, I really hate to impose. But we've missed several major deadlines, and department head has made it clear if we screw up again he'll outsource the whole project and have us laid off. I need it now so we can make sure everything's perfect for the big production run at COB today. Consider it done, I promised cheerfully and hung up. I surprised him, and maybe myself, with my good spirits. Especially since I was more than 5 minutes late, closer to fifteen, and my buddies were already into their second beer when I joined them for lunch. But the extra 10 minutes had been well worth it considering what I managed to do to those hints with the outline editor. Just the same, though, I turned off my cell phone in case the twit called to find out why his 5-second queries took almost an hour. Can't have him taking me for granted, can I? Later that evening, after quaffing several (all right, numerous) more ales with the boys, I dialed in from home to check how things were going. Mr. Tech Lead was still logged in, no doubt desperately trying to determine why things were taking forever. Poor Mr. Tech Lead, another sleepless night. I logged off, turned out the light, and slept like a baby. Next morning, hangover. The phone rings. I snatch it up angrily... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Conboy, Jim INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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!? New DSL Internet Access from SBC Yahoo! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services
DBA opening in San Diego
http://careers.peopleclick.com/jobposts/Client40_HomeDepot2/BU1/External/259-277.htm -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Utl_file and OPENVMS
the vms user oracle needs rights to the directory. [EMAIL PROTECTED] 09/30/02 10:53AM List, I have a package that creates files on the server. The directory location and file name are obtained from tables in oracle. The procedure works as designed on Novell 7.3.4 and no changes were needed when the database way loaded on Linux Oracle 8.1.7. I am trying to move the database from the Novell to an OPENVMS Oracle 8.1.7 server and I can't get the package to write the files to the OS directory. The package is created by the Oracle user DTSUSER and executed by DTSUSER. There is no OPENVMS user DTSUSER. The sysadmin assures me that the permissions are correct to write to the directory. I have place a Dbms_output in the package to display the directory information and it looks correct. Is there anything different that has to be done to an OPENVMS server that will allow a package to write to a directory using the Utl_File package? Listing from the Oracle tables: DTS_PARAMETER_NAME DTS_PARAMETER_VALUE -- -- LOAD_USERIDLOADITUP LOAD_PASSWORD ILOADIT LOAD_SERVICE_NAME GLC_ALPHADEV-TCP LOAD_PAR_FILE_DIR ORADSK:[ORACLE8.DATA.PAR] LOAD_DATA_FILE_DIR Disk1:[Pro_ics.Iqfiles] LOAD_CONTROL_FILE_DIR ORADSK:[ORACLE8.DATA.CONTROL] LOAD_LOG_FILE_DIR ORADSK:[ORACLE8.DATA.LOG] LOAD_BAD_FILE_DIR ORADSK:[ORACLE8.DATA.BAD] LOAD_DISCARD_FILE_DIR ORADSK:[ORACLE8.DATA.DISCARD] Listing from the package that writes the parameter file: Procedure Create_New_Par_File ( P_Current_Table_Name In Varchar2 , P_Run_Date In Date , P_Load_UseridIn Varchar2 , P_Load_Password In Varchar2 , P_Load_Service_Name In Varchar2 , P_Load_Par_File_Dir In Varchar2 , P_Load_Data_File_Dir In Varchar2 , P_Load_Control_File_Dir In Varchar2 , P_Load_Log_File_Dir In Varchar2 , P_Load_Bad_File_Dir In Varchar2 , P_Load_Discard_File_Dir In Varchar2 ) as Begin Declare L_Par_File_Hand Utl_FIle.File_Type; -- Local variable to hold the File Pointer for the parameter file. Begin I PLACED A DBMS_OUTPUT STATEMENT HERE AND IT DISPLAYED THE PROPER DIRECTORY LOCATION FOR THE FILE TO BE WRITT EN TO. -- Open a new parameter file L_Par_File_Hand := Utl_File.Fopen(P_Load_Par_File_Dir,P_Current_Table_Name||'.PAR','w'); -- Print the following lines into the parameter file. Utl_File.Put (L_Par_File_Hand,'UserId='||P_Load_UserId||'/'||P_Load_Password||'@'||P_Load_Service_Name); Utl_File.New_Line(L_Par_File_Hand); If Not P_Current_Table_Name = 'GLCRET'
RE: Perl::DBI problems after charset change
No, but it shouldn't matter, should it? Isn't Oracle supposed to convert between different NLS_LANGs on server and client? I would think that would be shown by the fact that SQL*Plus works just fine from the same client. Thx, Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- From: Mark J. Bobak [mailto:[EMAIL PROTECTED]] Sent: Monday, September 30, 2002 10:08 PM To: Multiple recipients of list ORACLE-L Subject: Re: Perl::DBI problems after charset change Rich, Do you have export NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1 in the client environment where perl is running? -Mark -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
7.3.2 -7.3.4.4
Hi Friends, I had one of the oracle production database with 7.3.2 on AIX, I want to go 7.3.4 base first and apply patchset 7.3.4.4. Could any body have document that takes me step by step process!! The documentation is there in CDs, But not step by step process!! Thanks in advance peter. _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter R INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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-dba.com domain auction
With the economy in the tank and most of the successful web businesses being the old bricks and mortar stores with another means to penetrate the market, did you expect otherwise? A web presence is so passive that it is not much of an investment without the ability to do collateral advertising. Especially, something as marginal as a specialized oracle web site. I did the research a couple of months ago for a site like this and concluded I could not make it pay off. There are some major league players who are no longer in the phone book (or on the web). I had to ask myself, with compelling data in hand, What made me think I was smarter than they were?. Lacking a good answer I set the whole idea aside for another day. Keep your domain name for another day. It may have value in the future but right now it is likely just another casualty in the dot bomb train wreck. --- JOE TESTA [EMAIL PROTECTED] wrote: With as much interest as i'd seen, i'd thought it would have been above $102.50, oh well unless you all run up the price in the last few days, guess i'll just be holding onto it for a while. joe = Pete Barnett Lead Database Administrator The Regence Group [EMAIL PROTECTED] __ Do you Yahoo!? New DSL Internet Access from SBC Yahoo! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter Barnett INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Indexing SYS tables
Hey, Anyone have any advice on indexing SYS tables? Specifically, I've been experimenting with putting a reverse index on the TIMESTAMP# column of AUD$, since almost all of my queries against the AUD$ views end with ORDER BY TIMESTAMP DESC. In 8.1.7.4.0 test DBs on HP/UX, the index -- created under a non-SYS DBA schema -- works great. I'm looking for pitfalls, but can't come up with any of my own... TIA! Rich -- Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: DBA work load - BDBAFH #1
Title: RE: DBA work load - BDBAFH #1 An ENRON executive in training. -Original Message- From: Bob Metelsky [mailto:[EMAIL PROTECTED]] Sent: Monday, September 30, 2002 5:53 PM To: Multiple recipients of list ORACLE-L Subject: RE: DBA work load - BDBAFH #1 I don't know how he can live with himself LMAO -Original Message- Sent: Monday, September 30, 2002 2:58 PM To: Multiple recipients of list ORACLE-L The phone rings. Another user. Still pissed off, I pick it up... Database Administration, can I help you? I answer professionally. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: DBA work load - BDBAFH #1
Nah - I go for the subtle approach - 'YES?' - very, VERY loudly! And looking them dead straight in the eye... (You should see 'em jump!) peter edinbugh -Original Message- From: Connor McDonald [mailto:[EMAIL PROTECTED]] Sent: 01 October 2002 15:38 To: Multiple recipients of list ORACLE-L Subject: RE: DBA work load - BDBAFH #1 My favourite when they come to your desk... Ah, I see the f..k up fairy has come to visit (Apologies for profanity) :-) --- Rachel Carmichael [EMAIL PROTECTED] wrote: Paula, It just takes practice. You can learn to say no. I did. You just have to work up to it :) You start with: If I do that for you now, I will fall behind x days on the critical project I am working on for you move on to: I'm sorry. I have too much to do then to: not gonna happen and finally, either of the following: what part of the word NO don't you understand? or (my personal favorite) failure to plan on your part does not constitute an emergency on mine Try it, you'll like it --- [EMAIL PROTECTED] wrote: H. How come I always seem to be the DBA who can't say no - you don't seem to have that problem at all. -Original Message- Sent: Monday, September 30, 2002 3:58 PM To: Multiple recipients of list ORACLE-L The phone rings. Another user. Still pissed off, I pick it up... Database Administration, can I help you? I answer professionally. Troubled silence on the phone. Politeness is a very bad signal from me and they know it. He was rattled. Uh, hi, this is Joe, technical lead on that super-critical project for Benefits? Is this a good time? I have some stuff I need moved to production? The last was a statement, but it came out like a question. With a slight quaver in the voice, too. Excellent. Technical lead my arse. Could you be more specific so I can schedule you appropriately? He hesitated. Gosh, I sounded for real. I almost convinced myself. The victim approached warily. I've got a bunch of PL/SQL packages and some outlines to speed up the queries with special hints. The scripts are all ready for your review, they include the create statements, the grants, everything. I'm forwarding the email package to you with signoffs from IT, the user department, and your own from reviewing our design and test results. This last was delivered with almost pathetic eagerness. Good boy. Good, simple, foolish boy. If he could see me he'd be terrified by my grin. Joe, I need you to help me out. You've just given me 10 minutes of work, but I'm due for lunch in 5 minutes. What do you suggest I do? Joe knew better, he really did. But his team had been up all night finishing and the prize was so close... Look, I really hate to impose. But we've missed several major deadlines, and department head has made it clear if we screw up again he'll outsource the whole project and have us laid off. I need it now so we can make sure everything's perfect for the big production run at COB today. Consider it done, I promised cheerfully and hung up. I surprised him, and maybe myself, with my good spirits. Especially since I was more than 5 minutes late, closer to fifteen, and my buddies were already into their second beer when I joined them for lunch. But the extra 10 minutes had been well worth it considering what I managed to do to those hints with the outline editor. Just the same, though, I turned off my cell phone in case the twit called to find out why his 5-second queries took almost an hour. Can't have him taking me for granted, can I? Later that evening, after quaffing several (all right, numerous) more ales with the boys, I dialed in from home to check how things were going. Mr. Tech Lead was still logged in, no doubt desperately trying to determine why things were taking forever. Poor Mr. Tech Lead, another sleepless night. I logged off, turned out the light, and slept like a baby. Next morning, hangover. The phone rings. I snatch it up angrily... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Conboy, Jim INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name
RE: Way of extracting record
3. You can use export with QUERY option to export just the rows you need from each table in Production and import those into Development database. However, it will depend on how easy it is to get to the required data by the QUERY option (available with Oracle 8i). Can you elaborate how the querry option is done? The only individualized method of exporting (using exp) I'm familiar with is with Tables= thanks bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Indexing SYS tables
Reverse key index won't help you in ORDER BY DESC, will it? AFAIK Reverse-key index will store 'Naveen' as 'neevaN' and 'Rich' as 'hciR' and so won't be helpful in ORDER BY DESC Regards Naveen -Original Message- Sent: Tuesday, October 01, 2002 8:58 PM To: Multiple recipients of list ORACLE-L Hey, Anyone have any advice on indexing SYS tables? Specifically, I've been experimenting with putting a reverse index on the TIMESTAMP# column of AUD$, since almost all of my queries against the AUD$ views end with ORDER BY TIMESTAMP DESC. In 8.1.7.4.0 test DBs on HP/UX, the index -- created under a non-SYS DBA schema -- works great. I'm looking for pitfalls, but can't come up with any of my own... TIA! Rich -- Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Naveen Nahata INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
8.1.6 to 8.1.7 upgrade
Gurus! Any docs / URLs / do's don'ts / tips for 8.1.6 to 8.1.7 upgrade? I have gone throught the metalink docs and Oracle Documentation. Thanks, -Rachna -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachna Vaidya INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Indexing SYS tables
You don't need reverse index to do: ORDER BY TIMSTAMP DESC. Regular index should do it, even if you want it DESC. Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, October 01, 2002 11:28 AM Hey, Anyone have any advice on indexing SYS tables? Specifically, I've been experimenting with putting a reverse index on the TIMESTAMP# column of AUD$, since almost all of my queries against the AUD$ views end with ORDER BY TIMESTAMP DESC. In 8.1.7.4.0 test DBs on HP/UX, the index -- created under a non-SYS DBA schema -- works great. I'm looking for pitfalls, but can't come up with any of my own... TIA! Rich -- Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Igor Neyman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Utl_file and OPENVMS
Make sure you have the directory name entry covered in INIT.ORA e.g. utl_file_dir = D:\directory name1 utl_file_dir = D:\directory name2 utl_file_dir = D:\directory name3 You need one entry per directory that you want to write to using UTL_FILE Package Hope this helps Regards Shiva -Original Message- Sent: Tuesday, October 01, 2002 9:48 AM To: Multiple recipients of list ORACLE-L the vms user oracle needs rights to the directory. [EMAIL PROTECTED] 09/30/02 10:53AM List, I have a package that creates files on the server. The directory location and file name are obtained from tables in oracle. The procedure works as designed on Novell 7.3.4 and no changes were needed when the database way loaded on Linux Oracle 8.1.7. I am trying to move the database from the Novell to an OPENVMS Oracle 8.1.7 server and I can't get the package to write the files to the OS directory. The package is created by the Oracle user DTSUSER and executed by DTSUSER. There is no OPENVMS user DTSUSER. The sysadmin assures me that the permissions are correct to write to the directory. I have place a Dbms_output in the package to display the directory information and it looks correct. Is there anything different that has to be done to an OPENVMS server that will allow a package to write to a directory using the Utl_File package? Listing from the Oracle tables: DTS_PARAMETER_NAME DTS_PARAMETER_VALUE -- -- LOAD_USERIDLOADITUP LOAD_PASSWORD ILOADIT LOAD_SERVICE_NAME GLC_ALPHADEV-TCP LOAD_PAR_FILE_DIR ORADSK:[ORACLE8.DATA.PAR] LOAD_DATA_FILE_DIR Disk1:[Pro_ics.Iqfiles] LOAD_CONTROL_FILE_DIR ORADSK:[ORACLE8.DATA.CONTROL] LOAD_LOG_FILE_DIR ORADSK:[ORACLE8.DATA.LOG] LOAD_BAD_FILE_DIR ORADSK:[ORACLE8.DATA.BAD] LOAD_DISCARD_FILE_DIR ORADSK:[ORACLE8.DATA.DISCARD] Listing from the package that writes the parameter file: Procedure Create_New_Par_File ( P_Current_Table_Name In Varchar2 , P_Run_Date In Date , P_Load_UseridIn Varchar2 , P_Load_Password In Varchar2 , P_Load_Service_Name In Varchar2 , P_Load_Par_File_Dir In Varchar2 , P_Load_Data_File_Dir In Varchar2 , P_Load_Control_File_Dir In Varchar2 , P_Load_Log_File_Dir In Varchar2 , P_Load_Bad_File_Dir In Varchar2 , P_Load_Discard_File_Dir In Varchar2 ) as Begin Declare L_Par_File_Hand Utl_FIle.File_Type; -- Local variable to hold the File Pointer for the parameter file. Begin I PLACED A DBMS_OUTPUT STATEMENT HERE AND IT DISPLAYED THE PROPER DIRECTORY LOCATION FOR THE FILE TO BE WRITT EN TO. -- Open a new parameter file L_Par_File_Hand := Utl_File.Fopen(P_Load_Par_File_Dir,P_Current_Table_Name||'.PAR','w'); -- Print the following lines into the parameter file. Utl_File.Put
RE: Indexing SYS tables
Yes, you are obviously correct. I really need to RTFM. sigh Too many pots on the stove! Just a regular index, then. Any other input? Thx! Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- From: Naveen Nahata [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 01, 2002 10:49 AM To: Multiple recipients of list ORACLE-L Subject: RE: Indexing SYS tables Reverse key index won't help you in ORDER BY DESC, will it? AFAIK Reverse-key index will store 'Naveen' as 'neevaN' and 'Rich' as 'hciR' and so won't be helpful in ORDER BY DESC Regards Naveen -Original Message- Sent: Tuesday, October 01, 2002 8:58 PM To: Multiple recipients of list ORACLE-L Hey, Anyone have any advice on indexing SYS tables? Specifically, I've been experimenting with putting a reverse index on the TIMESTAMP# column of AUD$, since almost all of my queries against the AUD$ views end with ORDER BY TIMESTAMP DESC. In 8.1.7.4.0 test DBs on HP/UX, the index -- created under a non-SYS DBA schema -- works great. I'm looking for pitfalls, but can't come up with any of my own... TIA! Rich -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Perl::DBI problems after charset change
Rich, Though I've never had this problem with Perl, I have had it with SAP. If NLS_LANG is set incorrectly at the client, it won't work. In your Perl: $ENV{NLS_LANG} = 'whatever'; Try it, you might like it. :) Jared Jesse, Rich [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 10/01/2002 08:18 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Perl::DBI problems after charset change No, but it shouldn't matter, should it? Isn't Oracle supposed to convert between different NLS_LANGs on server and client? I would think that would be shown by the fact that SQL*Plus works just fine from the same client. Thx, Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- From: Mark J. Bobak [mailto:[EMAIL PROTECTED]] Sent: Monday, September 30, 2002 10:08 PM To: Multiple recipients of list ORACLE-L Subject: Re: Perl::DBI problems after charset change Rich, Do you have export NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1 in the client environment where perl is running? -Mark -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Oracle 8.1.6.2/HP-UX 11i/Reorg IOT
Hi Gang! Is there any trick, or any gotchas, for re-orging IOT-style tables? I have one that's growing, and the initial builder put PCTINCREASE at 100 and I cannot change it with an ALTER TABLE. Any suggestions? Docos? Magic potions? Thanks, Mike --- === Michael P. Vergara Oracle DBA Guidant Corporation -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vergara, Michael (TEM) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Setting Cursor Sharing = Force in 8.1.7.3
We are in 8.1.7.0 and the bug 2225065 is not there. From: Jesse, Rich [EMAIL PROTECTED] Date: Sat, 28 Sep 2002 08:27:34 -0500 Subject: RE: Setting Cursor Sharing = Force in 8.1.7.3 Nat, We are currently using CS=F on 8.1.7.2 and we'll be patching to 8.1.7.4 soon. You need to be made aware of some severe problems with this in 8i. We've run across BUG 2225065 listed on MetaLink. It says that you can actually get incorrect results in certain queries when using CS=F. Luckily one of our developers noticed the very subtle problem and we were able to use ALTER SESSION SET CURSOR_SHARING=EXACT for his particular program. The catch is finding all the affected queries! Also, we get sporadic ORA-600s that can be attributed to CS=F, but it hasn't been a showstopper yet. For more CS=F issues, you will want to check Metalink doc 120607.1. It has pointers to the docs that have all the fixes for all the 8.1.7.x releases. There are a few important fixes in .3 and .4. Offhand, I don't remember if the BUG I mentioned is fixed in either release. . HTH! GL! :) Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- From: Nat [mailto:[EMAIL PROTECTED]] Sent: Friday, September 27, 2002 3:13 PM To: Multiple recipients of list ORACLE-L Subject: Setting Cursor Sharing = Force in 8.1.7.3 We are looking into setting up cursor_sharing parameter to FORCE. Has anyone seen any bad effects of setting Cursor_sharing=FORCE. Are there any real bad effects of setting it..? I was thinking of going back to my developers and make them use bind variables in their code. If I set the above parameter, they may continue to develop their code the way it is now. Let me know what you all think about it.. Thanks in advance, Ricardo Maurino Oracle Dba. Tornado Development, Inc. Phone: 310.760.9239 Email: [EMAIL PROTECTED] Fax: 310.760.5914 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: 8.1.6 to 8.1.7 upgrade
On Tue, Oct 01, 2002 at 07:48:33AM -0800, Rachna Vaidya wrote: Gurus! Any docs / URLs / do's don'ts / tips for 8.1.6 to 8.1.7 upgrade? -- 1. Don't be tempted to run below 8.1.7.4. 2. Do patch the listener vulnerability. === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Indexing SYS tables
Again since the indexes store the row in ordered fashion, I guess a normal index should be able to do ORDER BY DESC by reading backwards Not sure though Regards Naveen -Original Message- Sent: Tuesday, October 01, 2002 10:33 PM To: Multiple recipients of list ORACLE-L Yes, you are obviously correct. I really need to RTFM. sigh Too many pots on the stove! Just a regular index, then. Any other input? Thx! Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- From: Naveen Nahata [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 01, 2002 10:49 AM To: Multiple recipients of list ORACLE-L Subject: RE: Indexing SYS tables Reverse key index won't help you in ORDER BY DESC, will it? AFAIK Reverse-key index will store 'Naveen' as 'neevaN' and 'Rich' as 'hciR' and so won't be helpful in ORDER BY DESC Regards Naveen -Original Message- Sent: Tuesday, October 01, 2002 8:58 PM To: Multiple recipients of list ORACLE-L Hey, Anyone have any advice on indexing SYS tables? Specifically, I've been experimenting with putting a reverse index on the TIMESTAMP# column of AUD$, since almost all of my queries against the AUD$ views end with ORDER BY TIMESTAMP DESC. In 8.1.7.4.0 test DBs on HP/UX, the index -- created under a non-SYS DBA schema -- works great. I'm looking for pitfalls, but can't come up with any of my own... TIA! Rich -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Naveen Nahata INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Indexing SYS tables
Rich, I think you're crazy adding indexes SYS tables. I would *never* add anything to sys objects. What are you going to do the first time something goes wrong and you call Oracle support and you mention you added an index and they say - hey, you're on your own! Not to mention that when you perform an upgrade, that this index may either get lost or be in the way. No, a totally bad idea. If anything, I would copy the audit records to a local table in your schema, and then index that baby anyway I'd like. That way, the system objects are the way that Oracle inteneded them to be. Just my 2 cents. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, October 01, 2002 11:28 AM To: Multiple recipients of list ORACLE-L Hey, Anyone have any advice on indexing SYS tables? Specifically, I've been experimenting with putting a reverse index on the TIMESTAMP# column of AUD$, since almost all of my queries against the AUD$ views end with ORDER BY TIMESTAMP DESC. In 8.1.7.4.0 test DBs on HP/UX, the index -- created under a non-SYS DBA schema -- works great. I'm looking for pitfalls, but can't come up with any of my own... TIA! Rich -- Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: disable validate on a partitioned table?
Title: RE: disable validate on a partitioned table? -Original Message- From: Khedr, Waleed [mailto:[EMAIL PROTECTED]] This is probably b/c the unique key does not include the partitioning key. The unique key did include the partitioning key. Here is my example (Oracle 8.1.7.2.1 on Windows 2000) SQL create table country (country_founded date, country_name varchar2 (30)) 2 partition by range (country_founded) 3 (partition country_p1 values less than (to_date ('+15000101', 'SMMDD')), 4 partition country_p2 values less than (maxvalue) 5 ) ; Table créée. SQL insert into country (country_founded, country_name) 2 values (to_date ('12910801', 'MMDD'), 'Switzerland') ; 1 ligne créée. SQL insert into country (country_founded, country_name) 2 values (to_date ('17760704', 'MMDD'), 'United States of America') ; 1 ligne créée. SQL commit ; Validation effectuée. SQL alter table country add (constraint country_uq1 unique (country_founded) disable validate) ; Table modifiée. SQL create table country_temp (country_founded date, country_name varchar2 (30)) ; Table créée. SQL insert into country_temp (country_founded, country_name) 2 values (to_date ('19600820', 'MMDD'), 'Senegal') ; 1 ligne créée. SQL commit ; Validation effectuée. SQL alter table country exchange partition country_p2 with table country_temp ; alter table country exchange partition country_p2 with table country_temp * ERREUR à la ligne 1 : ORA-25132: contrainte UNIQUE (JRK.COUNTRY_UQ1) désactivée et validée dans ALTER TABLE EXCHANGE PARTITION SQL alter table country exchange partition country_p2 with table country_temp 2 without validation ; alter table country exchange partition country_p2 with table country_temp * ERREUR à la ligne 1 : ORA-25132: contrainte UNIQUE (JRK.COUNTRY_UQ1) désactivée et validée dans ALTER TABLE EXCHANGE PARTITION
RE: extremely long parse time
Matt, Have you done a 10053 trace on this query? Jared Adams, Matthew (GEA, MABG, 088130) [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 09/30/2002 11:43 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: extremely long parse time OK, I think we're on to something here. The DBA_TAB_COL_STATISTICS shows no rows for tables owned by sys (although strangely, owner is not a column of this table). However, the DBA_ANALYZE_OBJECTS view IS listing objects owned by SYS, which implies that they have been analyzed in the past. Since I don't see any of the statisics filled in on the DBA_TABLES entries for tables owned by SYS, what would you recommend doing at this point? analyze table sys.X delete statistics? Matt Adams - GE Appliances - [EMAIL PROTECTED] Their fundamental design flaws are completely hidden by their superficial design flaws. - Douglas Adams -Original Message- Sent: Monday, September 30, 2002 1:27 PM To: '[EMAIL PROTECTED]' Cc: Adams, Matthew (GEA, MABG, 088130) Hmmm...anything SYS in DBA_TAB_COL_STATISTICS or DBA_ANALYZE_OBJECTS? Is the COST column in your PLAN_TABLE null??? Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- Sent: Monday, September 30, 2002 12:38 PM To: Multiple recipients of list ORACLE-L We are using First_rows for the optimizer mode, but the last_analyzed column in DBA_TABLES and DBA_INDEXES is NULL for all objects owned by SYS. The really wierd part is: Changing the query to use rule based optimization (via the /*+ RULE */ hint caused it to execute sub-second. Why would optimization mode affect parsing? Is query optimization considered part of the parsing routine? Matt -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: 8.1.6 to 8.1.7 upgrade
If you have java installed be aware that there are a lot of changes with 8.1.7. If you have problems with the upgrade you *cannot* simply run rmjvm.sql and initjvm.sql There are two documents on removing and installing java which are must reads (I don't have the numbers handy, sorry). Allow a lot of time for the java upgrade. In the end I found it easier to remove java and do a fresh install (it helped that we weren't actually using it outside of development at the time). Good luck! Jay Miller -Original Message- Sent: Tuesday, October 01, 2002 11:49 AM To: Multiple recipients of list ORACLE-L Gurus! Any docs / URLs / do's don'ts / tips for 8.1.6 to 8.1.7 upgrade? I have gone throught the metalink docs and Oracle Documentation. Thanks, -Rachna -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachna Vaidya INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: extremely long parse time
Title: RE: extremely long parse time I know what a 10046 trace does. What's a 10053 trace? Matt Adams - GE Appliances - [EMAIL PROTECTED] Their fundamental design flaws are completely hidden by their superficial design flaws. - Douglas Adams -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 01, 2002 12:42 PM To: [EMAIL PROTECTED] Cc: Adams, Matthew (GEA, MABG, 088130) Subject: RE: extremely long parse time Importance: High Matt, Have you done a 10053 trace on this query? Jared Adams, Matthew (GEA, MABG, 088130) [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 09/30/2002 11:43 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject: RE: extremely long parse time OK, I think we're on to something here. The DBA_TAB_COL_STATISTICS shows no rows for tables owned by sys (although strangely, owner is not a column of this table). However, the DBA_ANALYZE_OBJECTS view IS listing objects owned by SYS, which implies that they have been analyzed in the past. Since I don't see any of the statisics filled in on the DBA_TABLES entries for tables owned by SYS, what would you recommend doing at this point? analyze table sys.X delete statistics? Matt Adams - GE Appliances - [EMAIL PROTECTED] Their fundamental design flaws are completely hidden by their superficial design flaws. - Douglas Adams -Original Message- From: Jesse, Rich [mailto:[EMAIL PROTECTED]] Sent: Monday, September 30, 2002 1:27 PM To: '[EMAIL PROTECTED]' Cc: Adams, Matthew (GEA, MABG, 088130) Subject: RE: extremely long parse time Hmmm...anything SYS in DBA_TAB_COL_STATISTICS or DBA_ANALYZE_OBJECTS? Is the COST column in your PLAN_TABLE null??? Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- From: Adams, Matthew (GEA, MABG, 088130) [mailto:[EMAIL PROTECTED]] Sent: Monday, September 30, 2002 12:38 PM To: Multiple recipients of list ORACLE-L Subject: RE: extremely long parse time We are using First_rows for the optimizer mode, but the last_analyzed column in DBA_TABLES and DBA_INDEXES is NULL for all objects owned by SYS. The really wierd part is: Changing the query to use rule based optimization (via the /*+ RULE */ hint caused it to execute sub-second. Why would optimization mode affect parsing? Is query optimization considered part of the parsing routine? Matt
RE: DBA work load
Actually I called the group that handles 24 hour monitoring and emailed anyone else who might potentially be interested (hence getting in early the next day). The next day I was called on the carpet because I didn't get the name of the person I spoke with the previous night and they had to wait for the night shift to come in to find out who I spoke with to put it in their report. My boss' boss reads Dilbert as a management guide... Jay Miller -Original Message- Sent: Friday, September 27, 2002 9:03 AM To: Multiple recipients of list ORACLE-L Must say I liked Inka's notion of calling all interested parties with details, though it could be income threatening =:-0 Maybe a compromise would be to agree some type of SOP for such situations and have the interested callers list put in there. I mean if they are so keen to know first thing next morning... OTOH, why not send a summary e-mail to interested parties and tell them you'll fill in any gaps when you have caught up on lost time. If the problem has been resolved, details of how are of a mainly historical nature anyhow - right? Tim: Can you give me the ISBN's to some of your novels. What!!! You haven't written any yet! - A waste of talent ;) Thanks for the homour in any case. PS: The BDBAFH has gone right over my head. My psyche is suggesting it's profane. What does it stand for? - Seán O' Neill Organon (Ireland) Ltd. [subscribed: digest mode] This message, including attached files, may contain confidential information and is intended only for the use by the individual and/or the entity to which it is addressed. Any unauthorized use, dissemination of, or copying of the information contained herein is not allowed and may lead to irreparable harm and damage for which you may be held liable. If you receive this message in error or if it is intended for someone else please notify the sender by returning this e-mail immediately and delete the message. -- 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 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: extremely long parse time
Title: RE: extremely long parse time It reports all the parameter settings and the base statisticsthat Oracle takes into account when choosing a plan. -Original Message-From: Adams, Matthew (GEA, MABG, 088130) [mailto:[EMAIL PROTECTED]]Sent: Tuesday, October 01, 2002 12:56 PMTo: Multiple recipients of list ORACLE-LSubject: RE: extremely long parse time I know what a 10046 trace does. What's a 10053 trace? Matt Adams - GE Appliances - [EMAIL PROTECTED] Their fundamental design flaws are completely hidden by their superficial design flaws. - Douglas Adams -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 01, 2002 12:42 PM To: [EMAIL PROTECTED] Cc: Adams, Matthew (GEA, MABG, 088130) Subject: RE: extremely long parse time Importance: High Matt, Have you done a 10053 trace on this query? Jared "Adams, Matthew (GEA, MABG, 088130)" [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 09/30/2002 11:43 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject: RE: extremely long parse time OK, I think we're on to something here. The DBA_TAB_COL_STATISTICS shows no rows for tables owned by sys (although strangely, owner is not a column of this table). However, the DBA_ANALYZE_OBJECTS view IS listing objects owned by SYS, which implies that they have been analyzed in the past. Since I don't see any of the statisics filled in on the DBA_TABLES entries for tables owned by SYS, what would you recommend doing at this point? "analyze table sys.X delete statistics"? Matt Adams - GE Appliances - [EMAIL PROTECTED] Their fundamental design flaws are completely hidden by their superficial design flaws. - Douglas Adams -Original Message- From: Jesse, Rich [mailto:[EMAIL PROTECTED]] Sent: Monday, September 30, 2002 1:27 PM To: '[EMAIL PROTECTED]' Cc: Adams, Matthew (GEA, MABG, 088130) Subject: RE: extremely long parse time Hmmm...anything SYS in DBA_TAB_COL_STATISTICS or DBA_ANALYZE_OBJECTS? Is the COST column in your PLAN_TABLE null??? Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- From: Adams, Matthew (GEA, MABG, 088130) [mailto:[EMAIL PROTECTED]] Sent: Monday, September 30, 2002 12:38 PM To: Multiple recipients of list ORACLE-L Subject: RE: extremely long parse time We are using First_rows for the optimizer mode, but the last_analyzed column in DBA_TABLES and DBA_INDEXES is NULL for all objects owned by SYS. The really wierd part is: Changing the query to use rule based optimization (via the /*+ RULE */ hint caused it to execute sub-second. Why would optimization mode affect parsing? Is query optimization considered part of the parsing routine? Matt
RE: Indexing SYS tables
Oracle Corporation has a peculiar habit of providing scripts and solutions which it does not support officially. One of them is moving sys.aud$ out of SYSTEM tablespace. See note 1019377.6 on MetaLink. inka -Original Message- Sent: Tuesday, October 01, 2002 1:18 PM To: Multiple recipients of list ORACLE-L Rich, I think you're crazy adding indexes SYS tables. I would *never* add anything to sys objects. What are you going to do the first time something goes wrong and you call Oracle support and you mention you added an index and they say - hey, you're on your own! Not to mention that when you perform an upgrade, that this index may either get lost or be in the way. No, a totally bad idea. If anything, I would copy the audit records to a local table in your schema, and then index that baby anyway I'd like. That way, the system objects are the way that Oracle inteneded them to be. Just my 2 cents. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, October 01, 2002 11:28 AM To: Multiple recipients of list ORACLE-L Hey, Anyone have any advice on indexing SYS tables? Specifically, I've been experimenting with putting a reverse index on the TIMESTAMP# column of AUD$, since almost all of my queries against the AUD$ views end with ORDER BY TIMESTAMP DESC. In 8.1.7.4.0 test DBs on HP/UX, the index -- created under a non-SYS DBA schema -- works great. I'm looking for pitfalls, but can't come up with any of my own... TIA! Rich -- Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Inka Bezdziecka INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: extremely long parse time
Thats a CBO trace. Have fun trying to read it :) Actually, there was an excellent presentation from a Wolfgang Breitling on this very topic at IOUG. And I believe Cary's site carries it (hotsos.com). John Kanagaraj Oracle Applications DBA DB Soft Inc Work : (408) 970 7002 Listen to great, commercial-free christian music 24x7x365 at http://www.klove.com http://www.klove.com/ ** The opinions and facts contained in this message are entirely mine and do not reflect those of my employer or customers ** -Original Message- Sent: Tuesday, October 01, 2002 10:56 AM To: Multiple recipients of list ORACLE-L I know what a 10046 trace does. What's a 10053 trace? Matt Adams - GE Appliances - [EMAIL PROTECTED] Their fundamental design flaws are completely hidden by their superficial design flaws. - Douglas Adams -Original Message- mailto:[EMAIL PROTECTED] ] Sent: Tuesday, October 01, 2002 12:42 PM To: [EMAIL PROTECTED] Cc: Adams, Matthew (GEA, MABG, 088130) Importance: High Matt, Have you done a 10053 trace on this query? Jared Adams, Matthew (GEA, MABG, 088130) [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 09/30/2002 11:43 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: extremely long parse time OK, I think we're on to something here. The DBA_TAB_COL_STATISTICS shows no rows for tables owned by sys (although strangely, owner is not a column of this table). However, the DBA_ANALYZE_OBJECTS view IS listing objects owned by SYS, which implies that they have been analyzed in the past. Since I don't see any of the statisics filled in on the DBA_TABLES entries for tables owned by SYS, what would you recommend doing at this point? analyze table sys.X delete statistics? Matt Adams - GE Appliances - [EMAIL PROTECTED] Their fundamental design flaws are completely hidden by their superficial design flaws. - Douglas Adams -Original Message- mailto:[EMAIL PROTECTED] ] Sent: Monday, September 30, 2002 1:27 PM To: '[EMAIL PROTECTED]' Cc: Adams, Matthew (GEA, MABG, 088130) Hmmm...anything SYS in DBA_TAB_COL_STATISTICS or DBA_ANALYZE_OBJECTS? Is the COST column in your PLAN_TABLE null??? Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- mailto:[EMAIL PROTECTED] ] Sent: Monday, September 30, 2002 12:38 PM To: Multiple recipients of list ORACLE-L We are using First_rows for the optimizer mode, but the last_analyzed column in DBA_TABLES and DBA_INDEXES is NULL for all objects owned by SYS. The really wierd part is: Changing the query to use rule based optimization (via the /*+ RULE */ hint caused it to execute sub-second. Why would optimization mode affect parsing? Is query optimization considered part of the parsing routine? Matt -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Kanagaraj INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Utl_file and OPENVMS
i believe its utl_file_dir=dir1,dir2,dir3,... in your example, dir 3 would be the only valid dir. hth, gene [EMAIL PROTECTED] 10/01/02 12:53PM Make sure you have the directory name entry covered in INIT.ORA e.g. utl_file_dir = D:\directory name1 utl_file_dir = D:\directory name2 utl_file_dir = D:\directory name3 You need one entry per directory that you want to write to using UTL_FILE Package Hope this helps Regards Shiva -Original Message- Sent: Tuesday, October 01, 2002 9:48 AM To: Multiple recipients of list ORACLE-L the vms user oracle needs rights to the directory. [EMAIL PROTECTED] 09/30/02 10:53AM List, I have a package that creates files on the server. The directory location and file name are obtained from tables in oracle. The procedure works as designed on Novell 7.3.4 and no changes were needed when the database way loaded on Linux Oracle 8.1.7. I am trying to move the database from the Novell to an OPENVMS Oracle 8.1.7 server and I can't get the package to write the files to the OS directory. The package is created by the Oracle user DTSUSER and executed by DTSUSER. There is no OPENVMS user DTSUSER. The sysadmin assures me that the permissions are correct to write to the directory. I have place a Dbms_output in the package to display the directory information and it looks correct. Is there anything different that has to be done to an OPENVMS server that will allow a package to write to a directory using the Utl_File package? Listing from the Oracle tables: DTS_PARAMETER_NAME DTS_PARAMETER_VALUE -- -- LOAD_USERIDLOADITUP LOAD_PASSWORD ILOADIT LOAD_SERVICE_NAME GLC_ALPHADEV-TCP LOAD_PAR_FILE_DIR ORADSK:[ORACLE8.DATA.PAR] LOAD_DATA_FILE_DIR Disk1:[Pro_ics.Iqfiles] LOAD_CONTROL_FILE_DIR ORADSK:[ORACLE8.DATA.CONTROL] LOAD_LOG_FILE_DIR ORADSK:[ORACLE8.DATA.LOG] LOAD_BAD_FILE_DIR ORADSK:[ORACLE8.DATA.BAD] LOAD_DISCARD_FILE_DIR ORADSK:[ORACLE8.DATA.DISCARD] Listing from the package that writes the parameter file: Procedure Create_New_Par_File ( P_Current_Table_Name In Varchar2 , P_Run_Date In Date , P_Load_UseridIn Varchar2 , P_Load_Password In Varchar2 , P_Load_Service_Name In Varchar2 , P_Load_Par_File_Dir In Varchar2 , P_Load_Data_File_Dir In Varchar2 , P_Load_Control_File_Dir In Varchar2 , P_Load_Log_File_Dir In Varchar2 , P_Load_Bad_File_Dir In Varchar2 , P_Load_Discard_File_Dir In Varchar2 ) as Begin Declare L_Par_File_Hand Utl_FIle.File_Type; -- Local variable to hold the File Pointer for the parameter file. Begin I PLACED A DBMS_OUTPUT STATEMENT HERE AND IT DISPLAYED THE PROPER DIRECTORY LOCATION FOR THE FILE TO BE WRITT EN TO. -- Open a new parameter file L_Par_File_Hand := Utl_File.Fopen(P_Load_Par_File_Dir,P_Current_Table_Name||'.PAR','w'); -- Print
RE: extremely long parse time
Title: RE: extremely long parse time It is useddiagnosing optimiser problems. The trace showsthe optimiser access path.One of those "should NOT be used unless explicitly requested by support"and not documented features. inka -Original Message-From: Adams, Matthew (GEA, MABG, 088130) [mailto:[EMAIL PROTECTED]]Sent: Tuesday, October 01, 2002 1:56 PMTo: Multiple recipients of list ORACLE-LSubject: RE: extremely long parse time I know what a 10046 trace does. What's a 10053 trace? Matt Adams - GE Appliances - [EMAIL PROTECTED] Their fundamental design flaws are completely hidden by their superficial design flaws. - Douglas Adams -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 01, 2002 12:42 PM To: [EMAIL PROTECTED] Cc: Adams, Matthew (GEA, MABG, 088130) Subject: RE: extremely long parse time Importance: High Matt, Have you done a 10053 trace on this query? Jared "Adams, Matthew (GEA, MABG, 088130)" [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 09/30/2002 11:43 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject: RE: extremely long parse time OK, I think we're on to something here. The DBA_TAB_COL_STATISTICS shows no rows for tables owned by sys (although strangely, owner is not a column of this table). However, the DBA_ANALYZE_OBJECTS view IS listing objects owned by SYS, which implies that they have been analyzed in the past. Since I don't see any of the statisics filled in on the DBA_TABLES entries for tables owned by SYS, what would you recommend doing at this point? "analyze table sys.X delete statistics"? Matt Adams - GE Appliances - [EMAIL PROTECTED] Their fundamental design flaws are completely hidden by their superficial design flaws. - Douglas Adams -Original Message- From: Jesse, Rich [mailto:[EMAIL PROTECTED]] Sent: Monday, September 30, 2002 1:27 PM To: '[EMAIL PROTECTED]' Cc: Adams, Matthew (GEA, MABG, 088130) Subject: RE: extremely long parse time Hmmm...anything SYS in DBA_TAB_COL_STATISTICS or DBA_ANALYZE_OBJECTS? Is the COST column in your PLAN_TABLE null??? Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- From: Adams, Matthew (GEA, MABG, 088130) [mailto:[EMAIL PROTECTED]] Sent: Monday, September 30, 2002 12:38 PM To: Multiple recipients of list ORACLE-L Subject: RE: extremely long parse time We are using First_rows for the optimizer mode, but the last_analyzed column in DBA_TABLES and DBA_INDEXES is NULL for all objects owned by SYS. The really wierd part is: Changing the query to use rule based optimization (via the /*+ RULE */ hint caused it to execute sub-second. Why would optimization mode affect parsing? Is query optimization considered part of the parsing routine? Matt
Test message: Please delete
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: extremely long parse time
Yes, the site is http://www.hotsos.com/dnloads/1/10053/Breitling2002.pdf. Requires free membership John Kanagaraj john.kanagara To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED][EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: RE: extremely long parse time om 10/01/2002 02:30 PM Please respond to ORACLE-L Thats a CBO trace. Have fun trying to read it :) Actually, there was an excellent presentation from a Wolfgang Breitling on this very topic at IOUG. And I believe Cary's site carries it (hotsos.com). John Kanagaraj Oracle Applications DBA DB Soft Inc Work : (408) 970 7002 Listen to great, commercial-free christian music 24x7x365 at http://www.klove.com http://www.klove.com/ ** The opinions and facts contained in this message are entirely mine and do not reflect those of my employer or customers ** -Original Message- Sent: Tuesday, October 01, 2002 10:56 AM To: Multiple recipients of list ORACLE-L I know what a 10046 trace does. What's a 10053 trace? Matt Adams - GE Appliances - [EMAIL PROTECTED] Their fundamental design flaws are completely hidden by their superficial design flaws. - Douglas Adams -Original Message- mailto:[EMAIL PROTECTED] ] Sent: Tuesday, October 01, 2002 12:42 PM To: [EMAIL PROTECTED] Cc: Adams, Matthew (GEA, MABG, 088130) Importance: High Matt, Have you done a 10053 trace on this query? Jared Adams, Matthew (GEA, MABG, 088130) [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 09/30/2002 11:43 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: extremely long parse time OK, I think we're on to something here. The DBA_TAB_COL_STATISTICS shows no rows for tables owned by sys (although strangely, owner is not a column of this table). However, the DBA_ANALYZE_OBJECTS view IS listing objects owned by SYS, which implies that they have been analyzed in the past. Since I don't see any of the statisics filled in on the DBA_TABLES entries for tables owned by SYS, what would you recommend doing at this point? analyze table sys.X delete statistics? Matt Adams - GE Appliances - [EMAIL PROTECTED] Their fundamental design flaws are completely hidden by their superficial design flaws. - Douglas Adams -Original Message- mailto:[EMAIL PROTECTED] ] Sent: Monday, September 30, 2002 1:27 PM To: '[EMAIL PROTECTED]' Cc: Adams, Matthew (GEA, MABG, 088130) Hmmm...anything SYS in DBA_TAB_COL_STATISTICS or DBA_ANALYZE_OBJECTS? Is the COST column in your PLAN_TABLE null??? Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- mailto:[EMAIL PROTECTED] ] Sent: Monday, September 30, 2002 12:38 PM To: Multiple recipients of list ORACLE-L We are using First_rows for the optimizer mode, but the last_analyzed column in DBA_TABLES and DBA_INDEXES is NULL for all objects owned by SYS. The really wierd part is: Changing the query to use rule based optimization (via the /*+ RULE */ hint caused it to execute sub-second. Why would optimization mode affect parsing? Is query optimization considered part of the parsing routine? Matt -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Kanagaraj INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to:
RE: Indexing SYS tables
and the latest I have heard is that they no longer will support moving AUD$. Even though it's listed on MetaLink --- Inka Bezdziecka [EMAIL PROTECTED] wrote: Oracle Corporation has a peculiar habit of providing scripts and solutions which it does not support officially. One of them is moving sys.aud$ out of SYSTEM tablespace. See note 1019377.6 on MetaLink. inka -Original Message- Sent: Tuesday, October 01, 2002 1:18 PM To: Multiple recipients of list ORACLE-L Rich, I think you're crazy adding indexes SYS tables. I would *never* add anything to sys objects. What are you going to do the first time something goes wrong and you call Oracle support and you mention you added an index and they say - hey, you're on your own! Not to mention that when you perform an upgrade, that this index may either get lost or be in the way. No, a totally bad idea. If anything, I would copy the audit records to a local table in your schema, and then index that baby anyway I'd like. That way, the system objects are the way that Oracle inteneded them to be. Just my 2 cents. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, October 01, 2002 11:28 AM To: Multiple recipients of list ORACLE-L Hey, Anyone have any advice on indexing SYS tables? Specifically, I've been experimenting with putting a reverse index on the TIMESTAMP# column of AUD$, since almost all of my queries against the AUD$ views end with ORDER BY TIMESTAMP DESC. In 8.1.7.4.0 test DBs on HP/UX, the index -- created under a non-SYS DBA schema -- works great. I'm looking for pitfalls, but can't come up with any of my own... TIA! Rich -- Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Inka Bezdziecka INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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!? New DSL Internet Access from SBC Yahoo! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Indexing SYS tables
Thanks, Tom. That's the kind of feedback I'm looking for. Anyone else? Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- From: Mercadante, Thomas F [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 01, 2002 12:18 PM To: Multiple recipients of list ORACLE-L Subject: RE: Indexing SYS tables Rich, I think you're crazy adding indexes SYS tables. I would *never* add anything to sys objects. What are you going to do the first time something goes wrong and you call Oracle support and you mention you added an index and they say - hey, you're on your own! Not to mention that when you perform an upgrade, that this index may either get lost or be in the way. No, a totally bad idea. If anything, I would copy the audit records to a local table in your schema, and then index that baby anyway I'd like. That way, the system objects are the way that Oracle inteneded them to be. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: 8.1.6 to 8.1.7 upgrade
I also found that I had to use SVRMGRL instead of SQLPLUS when doing the Java install. Dunno why. HP-UX 11.0 and 11i. I think it takes so long because it is reloading and revalidating the whole entire Java library. I guessing. My 2¢ worth... Mike -Original Message- Sent: Tuesday, October 01, 2002 10:56 AM To: Multiple recipients of list ORACLE-L If you have java installed be aware that there are a lot of changes with 8.1.7. If you have problems with the upgrade you *cannot* simply run rmjvm.sql and initjvm.sql There are two documents on removing and installing java which are must reads (I don't have the numbers handy, sorry). Allow a lot of time for the java upgrade. In the end I found it easier to remove java and do a fresh install (it helped that we weren't actually using it outside of development at the time). Good luck! Jay Miller -Original Message- Sent: Tuesday, October 01, 2002 11:49 AM To: Multiple recipients of list ORACLE-L Gurus! Any docs / URLs / do's don'ts / tips for 8.1.6 to 8.1.7 upgrade? I have gone throught the metalink docs and Oracle Documentation. Thanks, -Rachna -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachna Vaidya INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vergara, Michael (TEM) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: DBA work load - BDBAFH #1
LOL. Any Cicely Mary Barker JPEG of the fairy to put on my desk ? Connor McDonald wrote: My favourite when they come to your desk... Ah, I see the f..k up fairy has come to visit (Apologies for profanity) :-) --- Rachel Carmichael [EMAIL PROTECTED] wrote: Paula, It just takes practice. You can learn to say no. I did. You just have to work up to it :) You start with: If I do that for you now, I will fall behind x days on the critical project I am working on for you move on to: I'm sorry. I have too much to do then to: not gonna happen and finally, either of the following: what part of the word NO don't you understand? or (my personal favorite) failure to plan on your part does not constitute an emergency on mine Try it, you'll like it --- [EMAIL PROTECTED] wrote: H. How come I always seem to be the DBA who can't say no - you don't seem to have that problem at all. -Original Message- Sent: Monday, September 30, 2002 3:58 PM To: Multiple recipients of list ORACLE-L The phone rings. Another user. Still pissed off, I pick it up... Database Administration, can I help you? I answer professionally. Troubled silence on the phone. Politeness is a very bad signal from me and they know it. He was rattled. Uh, hi, this is Joe, technical lead on that super-critical project for Benefits? Is this a good time? I have some stuff I need moved to production? The last was a statement, but it came out like a question. With a slight quaver in the voice, too. Excellent. Technical lead my arse. Could you be more specific so I can schedule you appropriately? He hesitated. Gosh, I sounded for real. I almost convinced myself. The victim approached warily. I've got a bunch of PL/SQL packages and some outlines to speed up the queries with special hints. The scripts are all ready for your review, they include the create statements, the grants, everything. I'm forwarding the email package to you with signoffs from IT, the user department, and your own from reviewing our design and test results. This last was delivered with almost pathetic eagerness. Good boy. Good, simple, foolish boy. If he could see me he'd be terrified by my grin. Joe, I need you to help me out. You've just given me 10 minutes of work, but I'm due for lunch in 5 minutes. What do you suggest I do? Joe knew better, he really did. But his team had been up all night finishing and the prize was so close... Look, I really hate to impose. But we've missed several major deadlines, and department head has made it clear if we screw up again he'll outsource the whole project and have us laid off. I need it now so we can make sure everything's perfect for the big production run at COB today. Consider it done, I promised cheerfully and hung up. I surprised him, and maybe myself, with my good spirits. Especially since I was more than 5 minutes late, closer to fifteen, and my buddies were already into their second beer when I joined them for lunch. But the extra 10 minutes had been well worth it considering what I managed to do to those hints with the outline editor. Just the same, though, I turned off my cell phone in case the twit called to find out why his 5-second queries took almost an hour. Can't have him taking me for granted, can I? Later that evening, after quaffing several (all right, numerous) more ales with the boys, I dialed in from home to check how things were going. Mr. Tech Lead was still logged in, no doubt desperately trying to determine why things were taking forever. Poor Mr. Tech Lead, another sleepless night. I logged off, turned out the light, and slept like a baby. Next morning, hangover. The phone rings. I snatch it up angrily... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Conboy, Jim INET: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: disable validate on a partitioned table?
Title: RE: disable validate on a partitioned table? Try this before exchanging segments: alter table country_temp add (constraint country_uq2 unique (country_founded) disable validate) ; Waleed -Original Message-From: Jacques Kilchoer [mailto:[EMAIL PROTECTED]]Sent: Tuesday, October 01, 2002 1:28 PMTo: Multiple recipients of list ORACLE-LSubject: RE: disable validate on a partitioned table? -Original Message- From: Khedr, Waleed [mailto:[EMAIL PROTECTED]] This is probably b/c the unique key does not include the partitioning key. The unique key did include the partitioning key. Here is my example (Oracle 8.1.7.2.1 on Windows 2000) SQL create table country (country_founded date, country_name varchar2 (30)) 2 partition by range (country_founded) 3 (partition country_p1 values less than (to_date ('+15000101', 'SMMDD')), 4 partition country_p2 values less than (maxvalue) 5 ) ; Table créée. SQL insert into country (country_founded, country_name) 2 values (to_date ('12910801', 'MMDD'), 'Switzerland') ; 1 ligne créée. SQL insert into country (country_founded, country_name) 2 values (to_date ('17760704', 'MMDD'), 'United States of America') ; 1 ligne créée. SQL commit ; Validation effectuée. SQL alter table country add (constraint country_uq1 unique (country_founded) disable validate) ; Table modifiée. SQL create table country_temp (country_founded date, country_name varchar2 (30)) ; Table créée. SQL insert into country_temp (country_founded, country_name) 2 values (to_date ('19600820', 'MMDD'), 'Senegal') ; 1 ligne créée. SQL commit ; Validation effectuée. SQL alter table country exchange partition country_p2 with table country_temp ; alter table country exchange partition country_p2 with table country_temp * ERREUR à la ligne 1 : ORA-25132: contrainte UNIQUE (JRK.COUNTRY_UQ1) désactivée et validée dans ALTER TABLE EXCHANGE PARTITION SQL alter table country exchange partition country_p2 with table country_temp 2 without validation ; alter table country exchange partition country_p2 with table country_temp * ERREUR à la ligne 1 : ORA-25132: contrainte UNIQUE (JRK.COUNTRY_UQ1) désactivée et validée dans ALTER TABLE EXCHANGE PARTITION
RE: Perl::DBI problems after charset change
Interesting. Depressing, but interesting. In Korn: export NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1 ...and all's well with SQL*Plus. But with Perl/DBI: DBI-connect failed: ORA-12705: invalid or unknown NLS parameter value specified (DBD: login failed) at ./cursor_sharing_yes.pl line 17 Can't call method prepare on an undefined value at ./cursor_sharing_yes.pl line 32. I can't win. Rich -- Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 01, 2002 11:00 AM To: [EMAIL PROTECTED] Cc: Jesse, Rich Subject: RE: Perl::DBI problems after charset change Rich, Though I've never had this problem with Perl, I have had it with SAP. If NLS_LANG is set incorrectly at the client, it won't work. In your Perl: $ENV{NLS_LANG} = 'whatever'; Try it, you might like it. :) Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Utl_file and OPENVMS
Thanks to all of you for the assistance. I have the package working by coding the directory into the utl_file.fopen command and the files are being created okay. I got the batch procedure to work with the SQLLDR command( I did not know you had to set noon and each line starts with a $). It works okay as a database. It takes 5 min 48 sec to load 20 different tables with a total of 178000 rows. When I get the database up to date the developers will test their applications and I will start making the production server. Thanks, Ron [EMAIL PROTECTED] 10/01/02 02:25PM i believe its utl_file_dir=dir1,dir2,dir3,... in your example, dir 3 would be the only valid dir. hth, gene [EMAIL PROTECTED] 10/01/02 12:53PM Make sure you have the directory name entry covered in INIT.ORA e.g. utl_file_dir = D:\directory name1 utl_file_dir = D:\directory name2 utl_file_dir = D:\directory name3 You need one entry per directory that you want to write to using UTL_FILE Package Hope this helps Regards Shiva -Original Message- Sent: Tuesday, October 01, 2002 9:48 AM To: Multiple recipients of list ORACLE-L the vms user oracle needs rights to the directory. [EMAIL PROTECTED] 09/30/02 10:53AM List, I have a package that creates files on the server. The directory location and file name are obtained from tables in oracle. The procedure works as designed on Novell 7.3.4 and no changes were needed when the database way loaded on Linux Oracle 8.1.7. I am trying to move the database from the Novell to an OPENVMS Oracle 8.1.7 server and I can't get the package to write the files to the OS directory. The package is created by the Oracle user DTSUSER and executed by DTSUSER. There is no OPENVMS user DTSUSER. The sysadmin assures me that the permissions are correct to write to the directory. I have place a Dbms_output in the package to display the directory information and it looks correct. Is there anything different that has to be done to an OPENVMS server that will allow a package to write to a directory using the Utl_File package? Listing from the Oracle tables: DTS_PARAMETER_NAME DTS_PARAMETER_VALUE -- -- LOAD_USERIDLOADITUP LOAD_PASSWORD ILOADIT LOAD_SERVICE_NAME GLC_ALPHADEV-TCP LOAD_PAR_FILE_DIR ORADSK:[ORACLE8.DATA.PAR] LOAD_DATA_FILE_DIR Disk1:[Pro_ics.Iqfiles] LOAD_CONTROL_FILE_DIR ORADSK:[ORACLE8.DATA.CONTROL] LOAD_LOG_FILE_DIR ORADSK:[ORACLE8.DATA.LOG] LOAD_BAD_FILE_DIR ORADSK:[ORACLE8.DATA.BAD] LOAD_DISCARD_FILE_DIR ORADSK:[ORACLE8.DATA.DISCARD] Listing from the package that writes the parameter file: Procedure Create_New_Par_File ( P_Current_Table_Name In Varchar2 , P_Run_Date In Date , P_Load_UseridIn Varchar2 , P_Load_Password In Varchar2 , P_Load_Service_Name In Varchar2 , P_Load_Par_File_Dir In Varchar2 , P_Load_Data_File_Dir I n Varchar2 , P_Load_Control_File_Dir In Varchar2 , P_Load_Log_File_Dir In Varchar2 , P_Load_Bad_File_Dir In Varchar2 , P_Load_Discard_File_Dir In Varchar2 ) as Begin Declare L_Par_File_Hand Utl_FIle.File_Type; -- Local variable to hold the File
RE: DBA work load - BDBAFH #1
Title: Message hehehe... yea or a euthaniser the Humane Society ;- An ENRON executive in training. -Original Message- From: Bob Metelsky [mailto:[EMAIL PROTECTED]] Sent: Monday, September 30, 2002 5:53 PM To: Multiple recipients of list ORACLE-L Subject: RE: DBA work load - BDBAFH #1 I don't know how he can live with himself LMAO -Original Message- Sent: Monday, September 30, 2002 2:58 PM To: Multiple recipients of list ORACLE-L The phone rings. Another user. Still pissed off, I pick it up... "Database Administration, can I help you?" I answer professionally. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Way of extracting record
Here is how: exp scott/tiger tables=emp query=\where job=\'SALESMAN\' and sal\1600\ When executing this command, Export builds a SQL SELECT statement similar to this: SELECT * FROM EMP where job='SALESMAN' and sal 1600; (From Utilities Guide) - Kirti -Original Message- Sent: Tuesday, October 01, 2002 10:59 AM To: Multiple recipients of list ORACLE-L 3. You can use export with QUERY option to export just the rows you need from each table in Production and import those into Development database. However, it will depend on how easy it is to get to the required data by the QUERY option (available with Oracle 8i). Can you elaborate how the querry option is done? The only individualized method of exporting (using exp) I'm familiar with is with Tables= thanks bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Way of extracting record
This is in 8.1.x and higher, not 8.0.x, right? Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, October 01, 2002 3:39 PM Here is how: exp scott/tiger tables=emp query=\where job=\'SALESMAN\' and sal\1600\ When executing this command, Export builds a SQL SELECT statement similar to this: SELECT * FROM EMP where job='SALESMAN' and sal 1600; (From Utilities Guide) - Kirti -Original Message- Sent: Tuesday, October 01, 2002 10:59 AM To: Multiple recipients of list ORACLE-L 3. You can use export with QUERY option to export just the rows you need from each table in Production and import those into Development database. However, it will depend on how easy it is to get to the required data by the QUERY option (available with Oracle 8i). Can you elaborate how the querry option is done? The only individualized method of exporting (using exp) I'm familiar with is with Tables= thanks bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: 7.3.2 -7.3.4.4
Hope this helps.. look for Upgrading Oracle7 databases... http://www.bijoos.com/oratom/ot_200101.htm Google -Original Message- Sent: Tuesday, October 01, 2002 10:28 AM To: Multiple recipients of list ORACLE-L Hi Friends, I had one of the oracle production database with 7.3.2 on AIX, I want to go 7.3.4 base first and apply patchset 7.3.4.4. Could any body have document that takes me step by step process!! The documentation is there in CDs, But not step by step process!! Thanks in advance peter. _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter R INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
SQL Backtrack Reports
If anyone out there is using SQL Backtrack to backup Oracle I am looking for a home grown reporting script that will give me start and stop times for all the backups on the log file. Thanks! R. Smith -- 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 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Way of extracting record
Right, you are! - Kirti -Original Message- Sent: Tuesday, October 01, 2002 2:49 PM To: Multiple recipients of list ORACLE-L This is in 8.1.x and higher, not 8.0.x, right? Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, October 01, 2002 3:39 PM Here is how: exp scott/tiger tables=emp query=\where job=\'SALESMAN\' and sal\1600\ When executing this command, Export builds a SQL SELECT statement similar to this: SELECT * FROM EMP where job='SALESMAN' and sal 1600; (From Utilities Guide) - Kirti -Original Message- Sent: Tuesday, October 01, 2002 10:59 AM To: Multiple recipients of list ORACLE-L 3. You can use export with QUERY option to export just the rows you need from each table in Production and import those into Development database. However, it will depend on how easy it is to get to the required data by the QUERY option (available with Oracle 8i). Can you elaborate how the querry option is done? The only individualized method of exporting (using exp) I'm familiar with is with Tables= thanks bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Way of extracting record
Kirti, You are always helpful. Just to add further... It is more easier to use export.par file where you can put query clause very easily ie without back slashes like query= where invdate between '29-DEC-97' and '03-JAN-99' HTH, Regards Rafiq Note: Bob, this is for 8i and up Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Tue, 01 Oct 2002 11:39:11 -0800 Here is how: exp scott/tiger tables=emp query=\where job=\'SALESMAN\' and sal\1600\ When executing this command, Export builds a SQL SELECT statement similar to this: SELECT * FROM EMP where job='SALESMAN' and sal 1600; (From Utilities Guide) - Kirti -Original Message- Sent: Tuesday, October 01, 2002 10:59 AM To: Multiple recipients of list ORACLE-L 3. You can use export with QUERY option to export just the rows you need from each table in Production and import those into Development database. However, it will depend on how easy it is to get to the required data by the QUERY option (available with Oracle 8i). Can you elaborate how the querry option is done? The only individualized method of exporting (using exp) I'm familiar with is with Tables= thanks bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammad Rafiq INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Way of extracting record
Here is how: exp scott/tiger tables=emp query=\where job=\'SALESMAN\' and sal\1600\ Wow! Very cool, thank you... bob When executing this command, Export builds a SQL SELECT statement similar to this: SELECT * FROM EMP where job='SALESMAN' and sal 1600; (From Utilities Guide) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Indexing SYS tables
Yes it does, at least on my test instance. Thanks! Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- From: Naveen Nahata [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 01, 2002 12:28 PM To: Multiple recipients of list ORACLE-L Subject: RE: Indexing SYS tables Again since the indexes store the row in ordered fashion, I guess a normal index should be able to do ORDER BY DESC by reading backwards Not sure though Regards Naveen -Original Message- Sent: Tuesday, October 01, 2002 10:33 PM To: Multiple recipients of list ORACLE-L Yes, you are obviously correct. I really need to RTFM. sigh Too many pots on the stove! Just a regular index, then. Any other input? Thx! Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Perl::DBI problems after charset change (MORE INFO -- longish
[first post bounced from fatcity.com with /var/spool/mail/autoresp: Permission denied. among other errors] I think I'm getting somewhere, but the research has given me the security heebie-jeebies. As I'm tracing at SUPPORT level on the server side of a test DB (can't trace on the client because it's production), two major differences pop out at me. First, the connect packets have the text in a different order: Perl/DBI: (CONNECT_DATA=(SID=testsid)(SRVR=DEDICATED)(CID=(PROGRAM=)(HOST=myclient)(US ER=rjesse)))(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=myserver)(PORT=1521)) )) SQL*Plus: (ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=myserver)(PORT=1521)))(CONNECT_DA TA=(SID=testsid)(SRVR=DEDICATED)(CID=(PROGRAM=)(HOST=myclient)(USER=rjesse)) )(FADRL=(FC=)(FG=))) Second, all other packets to and from Perl/DBI have every byte zero-terminated, whereas SQL*Plus doesn't. (Not knowing exactly where the password is, I've *d out and xxd out some bytes where I believe the encoded password and some other sensitive data to be) Perl/DBI: nsprecv: 267 bytes from transport nsprecv: tlen=267, plen=267, type=6 nsprecv: packet dump nsprecv: 01 0B 00 00 06 00 00 00 || nsprecv: 00 00 03 51 03 00 17 B9 |...Q| nsprecv: 10 00 00 00 06 00 17 DB || nsprecv: F2 00 00 00 11 00 00 00 || nsprecv: 00 00 00 00 00 00 00 00 || nsprecv: 00 00 00 00 00 00 17 DD || nsprecv: 6E 00 00 00 05 00 17 DF |n...| nsprecv: 6C 00 00 00 04 00 17 DE |l...| nsprecv: 6D 00 00 00 06 00 00 08 |m...| nsprecv: 00 00 17 E0 6B 00 00 00 |k...| nsprecv: 05 00 17 E1 6A 00 00 00 |j...| nsprecv: 20 00 00 00 00 00 00 00 | ...| nsprecv: 00 00 00 00 00 00 00 00 || nsprecv: 00 00 00 00 00 00 00 00 || nsprecv: 00 00 00 00 00 00 xx 00 |..U.| nsprecv: xx 00 xx 00 xx 00 xx 00 |N.A.M.E.| nsprecv: xx 00 xx 00 xx 00 xx 00 |1.*.*.*.| nsprecv: xx 00 xx 00 xx 00 xx 00 |*.*.*.*.| nsprecv: 42 00 xx 00 44 00 45 00 |B.*.D.E.| nsprecv: 34 00 41 00 xx 00 38 00 |4.A.8.8.| nsprecv: 45 00 32 00 70 00 74 00 |E.2.p.t.| nsprecv: 73 00 2F 00 35 00 xx 00 |s./.5.*.| nsprecv: xx 00 xx 00 xx 00 72 00 |*.*.*.r.| nsprecv: 6A 00 65 00 73 00 73 00 |j.e.s.s.| nsprecv: 65 00 31 00 37 00 30 00 |e.1.7.0.| nsprecv: 30 00 39 00 63 00 75 00 |0.9.c.u.| nsprecv: 72 00 73 00 6F 00 72 00 |r.s.o.r.| nsprecv: 5F 00 73 00 68 00 61 00 |_.s.h.a.| nsprecv: 72 00 69 00 6E 00 67 00 |r.i.n.g.| nsprecv: 5F 00 40 00 xx 00 xx 00 |_.@.*.*.| nsprecv: xx 00 xx 00 20 00 28 00 |*.*. .(.| nsprecv: 54 00 4E 00 53 00 20 00 |T.N.S. .| nsprecv: 56 00 31 00 2D 00 56 00 |V.1.-.V.| nsprecv: 32 00 29 00 00 00 00 00 |2.).| nsprecv: normal exit SQL*Plus: nsprecv: 193 bytes from transport nsprecv: tlen=193, plen=193, type=6 nsprecv: packet dump nsprecv: 00 C1 00 00 06 00 00 00 || nsprecv: 00 00 03 76 02 00 1B 51 |...v...Q| nsprecv: 20 00 00 00 06 00 00 00 | ...| nsprecv: 01 FF BE DC 48 00 00 00 |H...| nsprecv: 04 FF BE DA B8 FF BE DA || nsprecv: B2 xx xx xx xx xx xx 00 |.UNAME1.| nsprecv: 00 00 0D 0D 41 55 54 48 |AUTH| nsprecv: 5F 54 45 52 4D 49 4E 41 |_TERMINA| nsprecv: 4C 00 00 00 05 05 70 74 |L.pt| nsprecv: 73 2F 35 00 00 00 00 00 |s/5.| nsprecv: 00 00 13 13 41 55 54 48 |AUTH| nsprecv: 5F 50 52 4F 47 52 41 4D |_PROGRAM| nsprecv: 5F 4E 4D 00 41 55 54 00 |_NM.AUT.| nsprecv: 00 00 18 18 73 71 6C 70 |sqlp| nsprecv: 6C 75 73 40 xx xx xx xx |lus@| nsprecv: 20 28 54 4E 53 20 56 31 | (TNS V1| nsprecv: 2D 56 33 29 00 00 00 00 |-V3)| nsprecv: 00 00 00 0C 0C 41 55 54 |.AUT| nsprecv: 48 5F 4D 41 43 48 49 4E |H_MACHIN| nsprecv: 45 00 00 00 04 04 xx xx |E.**| nsprecv: xx xx 00 00 00 00 00 00 |**..| nsprecv: 00 08 08 41 55 54 48 5F |...AUTH_| nsprecv: 50 49 44 00 00 00 05 05 |PID.| nsprecv: 31 39 32 37 38 00 00 00 |19278...| nsprecv: 00 00 00 00 00 00 00 00 || nsprecv: normal exit From the Perl/DBI session trace, the next packet is the ORA-1017 sent to the client: nspsend: 162 bytes to transport nspsend: packet dump nspsend: 00 A2 00 00 06 00 00 00 || nspsend: 00 00 04 00 00 00 00 03 || nspsend: F9 00 00 00 00 00 00 00 || nspsend: 00 00 00 40 00 00 00 00 |...@| nspsend: 00 00 00 00 00 00 00 00 || nspsend: 00 00 00 00 00 00 00 00 || nspsend: 00 03 00 00 00 00 00 00 || nspsend: FE 40 00 4F 00 52 00 41 |.@.O.R.A| nspsend: 00 2D 00 30 00 31 00 30 |.-.0.1.0| nspsend: 00 31 00 37 00 3A 00 20 |.1.7.:. | nspsend: 00 69 00 6E 00 76 00 61 |.i.n.v.a| nspsend: 00 6C 00 69 00 64 00 20 |.l.i.d. | nspsend: 00 75 00 73 00 65 00 72 |.u.s.e.r| nspsend: 00 6E 00 61 00 6D 00 65 |.n.a.m.e| nspsend: 00 2F 00 70 00 61 00 73 |./.p.a.s| nspsend: 00 73 26 00 77 00 6F 00 |.s.w.o.| nspsend: 72 00 64 00 3B 00 20 00 |r.d.;. .| nspsend: 6C 00 6F 00 67 00 6F 00 |l.o.g.o.| nspsend: 6E 00 20 00 64 00 65 00 |n. .d.e.| nspsend: 6E 00 69 00 65 00 64 00 |n.i.e.d.| nspsend: 0A 00 00 00 00
Help find pk dependencies 7.3.4 db
I am trying to find out for a given table the column names for the parent table to which the referential integrity is built upon. for example, table B has primary keys=id, date_exam that are a foreign keys to table a, which has variable name pt_id, date_start. This is the query to deliver the pieces of information, but as soon as I remove the comment line (as I only want one line per return), it becomes a run-away and chews up the temp space. I have looked at this for so long that I am probably missing the obvious. Any thoughts? select o.constraint_name ownerconstraint, o.table_name ownertable,r1.position, r1.column_name, r.constraint_name, r2.position, r2.column_name from all_constraints o, (select constraint_name, column_name, position from all_cons_columns ) r1, all_constraints r, (select constraint_name, column_name, position from all_cons_columns) r2 where o.constraint_name=r1.constraint_name and o.constraint_type='R' and o.r_constraint_name = r.constraint_name and r.constraint_name = r2.constraint_name and --- r1.position= r2.position and o.table_name='NEURO_ASSESSMENT' order by o.constraint_name, o.table_name; lc -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lisa R. Clary INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Way of extracting record
Rafiq, Thanks. Absolutely, using par file has many such advantages (hiding username/password being one important other ;) - Kirti -Original Message- Sent: Tuesday, October 01, 2002 3:03 PM To: Multiple recipients of list ORACLE-L Kirti, You are always helpful. Just to add further... It is more easier to use export.par file where you can put query clause very easily ie without back slashes like query= where invdate between '29-DEC-97' and '03-JAN-99' HTH, Regards Rafiq Note: Bob, this is for 8i and up Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Tue, 01 Oct 2002 11:39:11 -0800 Here is how: exp scott/tiger tables=emp query=\where job=\'SALESMAN\' and sal\1600\ When executing this command, Export builds a SQL SELECT statement similar to this: SELECT * FROM EMP where job='SALESMAN' and sal 1600; (From Utilities Guide) - Kirti -Original Message- Sent: Tuesday, October 01, 2002 10:59 AM To: Multiple recipients of list ORACLE-L 3. You can use export with QUERY option to export just the rows you need from each table in Production and import those into Development database. However, it will depend on how easy it is to get to the required data by the QUERY option (available with Oracle 8i). Can you elaborate how the querry option is done? The only individualized method of exporting (using exp) I'm familiar with is with Tables= thanks bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammad Rafiq INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Way of extracting record
Thanks... Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Tue, 01 Oct 2002 13:13:32 -0800 Rafiq, Thanks. Absolutely, using par file has many such advantages (hiding username/password being one important other ;) - Kirti -Original Message- Sent: Tuesday, October 01, 2002 3:03 PM To: Multiple recipients of list ORACLE-L Kirti, You are always helpful. Just to add further... It is more easier to use export.par file where you can put query clause very easily ie without back slashes like query= where invdate between '29-DEC-97' and '03-JAN-99' HTH, Regards Rafiq Note: Bob, this is for 8i and up Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Tue, 01 Oct 2002 11:39:11 -0800 Here is how: exp scott/tiger tables=emp query=\where job=\'SALESMAN\' and sal\1600\ When executing this command, Export builds a SQL SELECT statement similar to this: SELECT * FROM EMP where job='SALESMAN' and sal 1600; (From Utilities Guide) - Kirti -Original Message- Sent: Tuesday, October 01, 2002 10:59 AM To: Multiple recipients of list ORACLE-L 3. You can use export with QUERY option to export just the rows you need from each table in Production and import those into Development database. However, it will depend on how easy it is to get to the required data by the QUERY option (available with Oracle 8i). Can you elaborate how the querry option is done? The only individualized method of exporting (using exp) I'm familiar with is with Tables= thanks bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammad Rafiq INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Join the worlds largest e-mail service with MSN Hotmail. http://www.hotmail.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammad Rafiq INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of
RE: Way of extracting record
I see this now at the docs... Bob Metelsky Client Services Development Phone 203-245-5089 ext 113 Fax 203-245-5001 Office 203-245-5000 Continuum Performance Systems Inc. http://continuumperformance.com/ PGP Public Key http://continuumperformance.com/cps.gpg -Original Message- From: Deshpande, Kirti [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 01, 2002 5:14 PM To: Multiple recipients of list ORACLE-L Subject: RE: Way of extracting record Rafiq, Thanks. Absolutely, using par file has many such advantages (hiding username/password being one important other ;) - Kirti -Original Message- Sent: Tuesday, October 01, 2002 3:03 PM To: Multiple recipients of list ORACLE-L Kirti, You are always helpful. Just to add further... It is more easier to use export.par file where you can put query clause very easily ie without back slashes like query= where invdate between '29-DEC-97' and '03-JAN-99' HTH, Regards Rafiq Note: Bob, this is for 8i and up Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Tue, 01 Oct 2002 11:39:11 -0800 Here is how: exp scott/tiger tables=emp query=\where job=\'SALESMAN\' and sal\1600\ When executing this command, Export builds a SQL SELECT statement similar to this: SELECT * FROM EMP where job='SALESMAN' and sal 1600; (From Utilities Guide) - Kirti -Original Message- Sent: Tuesday, October 01, 2002 10:59 AM To: Multiple recipients of list ORACLE-L 3. You can use export with QUERY option to export just the rows you need from each table in Production and import those into Development database. However, it will depend on how easy it is to get to the required data by the QUERY option (available with Oracle 8i). Can you elaborate how the querry option is done? The only individualized method of exporting (using exp) I'm familiar with is with Tables= thanks bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammad Rafiq INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Bob Metelsky INET: [EMAIL
Generic Connectivity using ODBC MyODBC to connect to MySQL database
I'd appreciate it if anyone who has been down this road before can summarize what they've learnt (DSN option values, MySQL config options etc). We're using Solaris 8, Oracle 8.1.7, MyODBC 3.51 and have got as far as getting a basic connection working so we can do simple selects. Before I dive into more detailed investigations I thought I'd ask for any words of experience here. I'll happily summarise to the list if people send info to me directly. Thanks. Tim. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tim Bunce INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: TSPITR Question
Also only available on Enterprise Edition. - Babette -Original Message- WILLIAMS Sent: Monday, September 30, 2002 10:03 PM To: Multiple recipients of list ORACLE-L Brian - Since nobody seems to have responded to your question, yes, there are plenty of opportunities for gotchas with TSPITR. To recover deleted data, you may want to take a look at LogMiner. Less risk. Normally, to recover deleted data, you will be performing the TSPITR on a test (or recovery) database so you avoid losing the data changes that were made to your production system after the deletion. Otherwise, you are performing a full database point in time recovery. The concept behind TSPITR is to perform recovery on a small subset of your database somewhere separate from your production database, then once you've recovered the data you need, export and import it back to the production system. Without more details on your situation and your experience level, about the most help I can be is to say take a full backup first. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, September 30, 2002 4:03 PM To: Multiple recipients of list ORACLE-L List - I have the opportunity to learn first-hand about TSPITR today. I need to recover a good bit of data that was recently deleted, and do not have a recent enough export to work from. My question is this - I'm reading the documentation now, and one of the big, bold Notes is that you should *NOT* try TSPITR for the first time on a production database, or if you have a time constraint. From looking at the instructions, I believe that I understand what to do, and while I would love to test this on another instance, I may not be able to. So I ask you - do you know of any gotchas that I need to be aware of?? Thanks In Advance, Brian -- | Brian McGraw /* DBA */ Infinity Insurance | | mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] | -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Babette Turner-Underwood INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 8.1.6.2/HP-UX 11i/Reorg IOT
alter table move storage (pctincrease 0) should do the trick. For speed, you might want to add parallel and nologging, perhaps. If you're feeling frisky, you can add the online keyword as well... - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, October 01, 2002 11:03 AM Hi Gang! Is there any trick, or any gotchas, for re-orging IOT-style tables? I have one that's growing, and the initial builder put PCTINCREASE at 100 and I cannot change it with an ALTER TABLE. Any suggestions? Docos? Magic potions? Thanks, Mike --- === Michael P. Vergara Oracle DBA Guidant Corporation -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vergara, Michael (TEM) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: 8.1.6 to 8.1.7 upgrade
Rachna - Decide carefully on which 8.1.7 version to upgrade to. Which platform are you on? That may help someone give you advice specific to your platform. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, October 01, 2002 10:49 AM To: Multiple recipients of list ORACLE-L Gurus! Any docs / URLs / do's don'ts / tips for 8.1.6 to 8.1.7 upgrade? I have gone throught the metalink docs and Oracle Documentation. Thanks, -Rachna -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachna Vaidya INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Dark side of the force
Hi all, I'll be seeing the dark side of the force as I'll be the DBA on a DB2 UDB project. Is there a list like this one for DB2 ? Any links to DB2 stuff ? I'd be interested in documents showing the differences/similarities between Oracle and DB2 UDB. Let's see our bargaining power with our Oracle rep once DB2 is in our Oracle shop (over 100 instances) = Stéphane Paquette DBA Oracle, consultant entrepôt de données Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] ___ Do You Yahoo!? -- Une adresse @yahoo.fr gratuite et en français ! Yahoo! Mail : http://fr.mail.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 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
how to find out the patch applied on different env.
Dear all, I have a situation where I need to find out the patches applied on different Oracle Application 11i (11.5.5) env. We have two environment PROD and TEST. It seems that there are some patches applied to TEST in the past few months. I would like to know what patches are applied on TEST env: Database stack Application stack $APPL_TOP Technology stack (Forms, reports, Jinitiator). There is neither manual logging system where I can find the patch details nor locating the files applpatch.txt or applptch.txt on the server. Is there any other way I can easily find out the difference between those two instances in respect to patches? Thanks in advance. Michael Sesuraj OCP. _ Join the worlds largest e-mail service with MSN Hotmail. http://www.hotmail.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: sesuraj m INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Performance monitoring
Ave ! I like to hear Your opinion about the most importat issues, what should be monitored from the database (8.1.7, SUN) during perfomance testing. The purpose in this case, is limit the monitoring to concern only about 10 most important ones. I have difficulties to make my mind to pick up the right ones, so if You had to have made similar kind of decisions or have opinions, please let me know. TIA Jorma - Name: Jorma Vuorio Phone: +358-9-7180 67759 Company: Nokia Business Infrastucture Fax:+358-9-7180 67465 Address: P.O.Box 321, FIN-00045 NOKIA GROUP, FINLAND Internet: [EMAIL PROTECTED]Mobile: +358-50-486 8043 - -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: 7.3.2 -7.3.4.4
1 October 2002 19:28, you wrote: Hi Friends, I had one of the oracle production database with 7.3.2 on AIX, I want to go 7.3.4 base first and apply patchset 7.3.4.4. Could any body have document that takes me step by step process!! The documentation is there in CDs, But not step by step process!! 1. su - oracle 2. Shutdown all instances using this $ORACLE_HOME. 3. You need 7.3.4 distributive and run orainst/orainst from their stage area (or direct from CD). Select Install or Upgarade action. You must have 7.3.4 after that. 4. Then go to 7.3.4.4 patch software stage area and make described patch procedure (see README* ). 5.Startup all instances using this $ORACLE_HOME. Michael Ivanov W±ëzØ^¡÷âr¥9,BÅm¶ÿÃ(§Ú©Êëa¢³¢ÚÈ4Dæö§¢û]z¶«¸V +r5ëp¢¹z»âqëçÎwó9Öm§ÿðÃÚµÈÉÊI©Ãè( +©b~ç£X§X¬µ©ÝÁæá¢Ëb®øzÄèDCTL¨º»÷ë¢kaÉX§X¬¶Ç§u©Ä1¨¥ë,j ¸¬´k«¹ör+rr§¢×\ ²¥)à¡òâ²Ñ®®æ§v)í é²Æ xb)Üç^jX§yÊ'µ¨§x5%9,Bè®Ø^©¡ùX§X¬·*.Á©í¶Þ騽ç_®¢éÉ©l¢Ç§vØ^BÏr¦jw_¢º- êâú+«b¢ybë.nÇ+¸§