SQL query without UNION clause
Hi all, How do I forumlate the below query without using the UNION clause? SELECT H1.OID HISTORIEOID,FAHRZEUG.AMTLICHESKENNZEICHEN, FAHRZEUG.OID, H1.PRODUKT,H1.AUFTRAGSPOSITIONSNR,H1.MYTECHOBJEKT FROM FAHRZEUG,HISTORIE H1 WHERE FAHRZEUG.OID = H1.MYTECHOBJEKT(+) AND TO_DATE(H1.DATUMSTR,'-MM-DD') = (select max(TO_DATE(H1.DATUMSTR,'-mm-dd')) from historie ,FAHRZEUG WHERE FAHRZEUG.OID = HISTORIE.MYTECHOBJEKT AND HISTORIE.MYTECHOBJEKT=H1.MYTECHOBJEKT) AND H1.PRODUKT IN('HU', 'AU') UNION SELECT H1.OID HISTORIEOID,FAHRZEUG.AMTLICHESKENNZEICHEN, FAHRZEUG.OID, H1.PRODUKT,H1.AUFTRAGSPOSITIONSNR,H1.MYTECHOBJEKT FROM FAHRZEUG,HISTORIE H1 WHERE FAHRZEUG.OID = H1.MYTECHOBJEKT(+) AND H1.PRODUKT IN('DS', 'NFZ', 'BES', 'DekraSiegel', '70', '700202'); I can't use the union clause because I am using an Object-Relationship tool called Cocobase which doesn't support the UNION clause. Any help in this regard is very much appreciated. Thanks and Regards, Ranganath WARNING: The information in this message is confidential and may be legally privileged. It is intended solely for the addressee. Access to this message by anyone else is unauthorised. If you are not the intended recipient, any disclosure, copying, or distribution of the message, or any action or omission taken by you in reliance on it, is prohibited and may be unlawful. Please immediately contact the sender if you have received this message in error. Thank you. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Krishnaswamy, Ranganath INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: SQL query without UNION clause
You would be surprised to discover what you could do with OR and suitably placed parentheses. - Original Message - From: Krishnaswamy, Ranganath [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wed, 18 Dec 2002 23:53:44 Hi all, How do I forumlate the below query without using the UNION clause? SELECT H1.OID HISTORIEOID,FAHRZEUG.AMTLICHESKENNZEICHEN, FAHRZEUG.OID, H1.PRODUKT,H1.AUFTRAGSPOSITIONSNR,H1.MYTECHOBJEKT FROM FAHRZEUG,HISTORIE H1 WHERE FAHRZEUG.OID = H1.MYTECHOBJEKT(+) AND TO_DATE(H1.DATUMSTR,'-MM-DD') = (select max(TO_DATE(H1.DATUMSTR,'-mm-dd')) from historie ,FAHRZEUG WHERE FAHRZEUG.OID = HISTORIE.MYTECHOBJEKT AND HISTORIE.MYTECHOBJEKT=H1.MYTECHOBJEKT) AND H1.PRODUKT IN('HU', 'AU') UNION SELECT H1.OID HISTORIEOID,FAHRZEUG.AMTLICHESKENNZEICHEN, FAHRZEUG.OID, H1.PRODUKT,H1.AUFTRAGSPOSITIONSNR,H1.MYTECHOBJEKT FROM FAHRZEUG,HISTORIE H1 WHERE FAHRZEUG.OID = H1.MYTECHOBJEKT(+) AND H1.PRODUKT IN('DS', 'NFZ', 'BES', 'DekraSiegel', '70', '700202'); I can't use the union clause because I am using an Object-Relationship tool called Cocobase which doesn't support the UNION clause. Any help in this regard is very much appreciated. Thanks and Regards, Ranganath WARNING: The information in this message is confidential and may be legally privileged. It is intended solely for the addressee. Access to this message by anyone else is unauthorised. If you are not the intended recipient, any disclosure, copying, or distribution of the message, or any action or omission taken by you in reliance on it, is prohibited and may be unlawful. Please immediately contact the sender if you have received this message in error. Thank you. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Krishnaswamy, Ranganath INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). --- -- Regards, Stephane Faroult Oriole -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroul INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: SQL query without UNION clause
Try this, SELECT DISTINCT H1.OID HISTORIEOID,FAHRZEUG.AMTLICHESKENNZEICHEN, FAHRZEUG.OID, H1.PRODUKT,H1.AUFTRAGSPOSITIONSNR,H1.MYTECHOBJEKT FROM FAHRZEUG,HISTORIE H1 WHERE FAHRZEUG.OID = H1.MYTECHOBJEKT(+) AND ((TO_DATE(H1.DATUMSTR,'-MM-DD') = (select max(TO_DATE(H1.DATUMSTR,'-mm-dd')) from historie ,FAHRZEUG WHERE FAHRZEUG.OID = HISTORIE.MYTECHOBJEKT AND HISTORIE.MYTECHOBJEKT=H1.MYTECHOBJEKT) AND H1.PRODUKT IN('HU', 'AU')) OR H1.PRODUKT IN('DS', 'NFZ', 'BES', 'DekraSiegel', '70', '700202')) Regards Naveen -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 19, 2002 1:24 PM To: Multiple recipients of list ORACLE-L Hi all, How do I forumlate the below query without using the UNION clause? SELECT H1.OID HISTORIEOID,FAHRZEUG.AMTLICHESKENNZEICHEN, FAHRZEUG.OID, H1.PRODUKT,H1.AUFTRAGSPOSITIONSNR,H1.MYTECHOBJEKT FROM FAHRZEUG,HISTORIE H1 WHERE FAHRZEUG.OID = H1.MYTECHOBJEKT(+) AND TO_DATE(H1.DATUMSTR,'-MM-DD') = (select max(TO_DATE(H1.DATUMSTR,'-mm-dd')) from historie ,FAHRZEUG WHERE FAHRZEUG.OID = HISTORIE.MYTECHOBJEKT AND HISTORIE.MYTECHOBJEKT=H1.MYTECHOBJEKT) AND H1.PRODUKT IN('HU', 'AU') UNION SELECT H1.OID HISTORIEOID,FAHRZEUG.AMTLICHESKENNZEICHEN, FAHRZEUG.OID, H1.PRODUKT,H1.AUFTRAGSPOSITIONSNR,H1.MYTECHOBJEKT FROM FAHRZEUG,HISTORIE H1 WHERE FAHRZEUG.OID = H1.MYTECHOBJEKT(+) AND H1.PRODUKT IN('DS', 'NFZ', 'BES', 'DekraSiegel', '70', '700202'); I can't use the union clause because I am using an Object-Relationship tool called Cocobase which doesn't support the UNION clause. Any help in this regard is very much appreciated. Thanks and Regards, Ranganath WARNING: The information in this message is confidential and may be legally privileged. It is intended solely for the addressee. Access to this message by anyone else is unauthorised. If you are not the intended recipient, any disclosure, copying, or distribution of the message, or any action or omission taken by you in reliance on it, is prohibited and may be unlawful. Please immediately contact the sender if you have received this message in error. Thank you. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Krishnaswamy, Ranganath INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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).
SQL*PLUS and CygWin
Hi everybody I'm using cywin on my Win2k box to get a reasonable shell. Now there's one problem left: Everytime I issue a host command within SQL*PLUS, I get a Windows console. I would like to get the bash prompt instead. Is there any way to tell sql plus what to do when you do a host ? Like re-route it to start the cygwin bash ? The point is that I want to write and test scripts on win2k using shell syntax (including the unix path'), so I could just mount my windows oracle installation to /opt/oracle etc. and I could run the scripts as if I were on a unix host. Unfortunately, everytime, I use a script containing host and a path within the host-environment it doesn't work, because the cmd.exe started by sqlplus expects windows path syntax like C.\blah instead of /blah. Any ideas ? Regards, Stefan -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stefan Jahnke INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: SQL query without UNION clause
I think you can translate it as OR, but you have to use some DISTINCT on output rows (because you use UNION and not UNION ALL). Without DISTINCT it is like: SELECT H1.OID HISTORIEOID ,FAHRZEUG.AMTLICHESKENNZEICHEN ,FAHRZEUG.OID ,H1.PRODUKT ,H1.AUFTRAGSPOSITIONSNR ,H1.MYTECHOBJEKT FROM FAHRZEUG, HISTORIE H1 WHERE FAHRZEUG.OID = H1.MYTECHOBJEKT(+) AND ( (TO_DATE(H1.DATUMSTR,'-MM-DD') = ( select max(TO_DATE(H1.DATUMSTR,'-mm-dd')) from historie, FAHRZEUG WHERE FAHRZEUG.OID = HISTORIE.MYTECHOBJEKT AND HISTORIE.MYTECHOBJEKT=H1.MYTECHOBJEKT) AND H1.PRODUKT IN ('HU', 'AU') ) OR H1.PRODUKT IN('DS', 'NFZ','BES', 'DekraSiegel', '70', '700202')) ; And I think you can change select max(TO_DATE(H1.DATUMSTR,'-mm-dd')) to select TO_DATE(MAX(H1.DATUMSTR),'-MM-DD') it can now use index on column H1.DATUMSTR (or create function based index) JP On Thursday 19 December 2002 08:53, you wrote: Hi all, How do I forumlate the below query without using the UNION clause? SELECT H1.OID HISTORIEOID,FAHRZEUG.AMTLICHESKENNZEICHEN, FAHRZEUG.OID, H1.PRODUKT,H1.AUFTRAGSPOSITIONSNR,H1.MYTECHOBJEKT FROM FAHRZEUG,HISTORIE H1 WHERE FAHRZEUG.OID = H1.MYTECHOBJEKT(+) AND TO_DATE(H1.DATUMSTR,'-MM-DD') = (select max(TO_DATE(H1.DATUMSTR,'-mm-dd')) from historie ,FAHRZEUG WHERE FAHRZEUG.OID = HISTORIE.MYTECHOBJEKT AND HISTORIE.MYTECHOBJEKT=H1.MYTECHOBJEKT) AND H1.PRODUKT IN('HU', 'AU') UNION SELECT H1.OID HISTORIEOID,FAHRZEUG.AMTLICHESKENNZEICHEN, FAHRZEUG.OID, H1.PRODUKT,H1.AUFTRAGSPOSITIONSNR,H1.MYTECHOBJEKT FROM FAHRZEUG,HISTORIE H1 WHERE FAHRZEUG.OID = H1.MYTECHOBJEKT(+) AND H1.PRODUKT IN('DS', 'NFZ', 'BES', 'DekraSiegel', '70', '700202'); I can't use the union clause because I am using an Object-Relationship tool called Cocobase which doesn't support the UNION clause. Any help in this regard is very much appreciated. Thanks and Regards, Ranganath WARNING: The information in this message is confidential and may be legally privileged. It is intended solely for the addressee. Access to this message by anyone else is unauthorised. If you are not the intended recipient, any disclosure, copying, or distribution of the message, or any action or omission taken by you in reliance on it, is prohibited and may be unlawful. Please immediately contact the sender if you have received this message in error. Thank you. -- Pruner Jan [EMAIL PROTECTED] http://jan.pruner.cz/ - Only Robinson Crusoe had all his work done by Friday -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jan Pruner INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Methods to get DDL
I do have a set of sqlplus scripts that we wrote for 7.3.4 that generate DDL for objects in the database. So, you can write your own. All the neccessary information is in the catalog. It is for the more common stuff but for some objects the information is so deeply buried it is next to impossible to figure out how to regenerate. For example, try figuring out how to rebuild the DDL for a Hash Cluster from the catalog. Kind regards Dale --- DBATool: A freeware DDL re-creation tool for Oracle databases. http://www.DataBee.com/dt_home.htm -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Direct and indirect foreign key relationships in SQL or Pl/Sql
How do I find out the direct and indirect foreign key relationships? Say, for example there are four tables A, B, C and D of which A is the parent table and B, C and D are child tables. Say B and C are related to A directly and D is related to A through C. How do I find out this indirect relationship apart from the direct relationships? Any help in this regard is very much appreciated. The DataBee software has a Chain Finder tool in the Set Designer which displays exactly this. DataBee is designed to create referentially correct subsets of Oracle databases and isn't free. However we do offer a 30 day evaluation which might enable you to get done what you want to do. If you would like to have a go at it drop me a note and I'll arrange to get an eval key over to you. Here's a link to the Chain Finder help page - it has a nice picture of the relationship display. http://www.databee.com/sdchainfinder.htm Regards Dale - Quickly and easily create test and development databases with DataBee. http://www.DataBee.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Methods to get DDL
Well I'm always happy to plug good books... But I did just that a couple of years ago on a different Oracle mailing list, and suddenly no-one else seemed to be seeing my posts - it made me wary of posting anything that could possibly be interpreted as a commercial plug. I've been using 'Annotated Archives' for years, I'll have to take a look at 'Instant PL/SQL Scripts' as well. Simon Anderson To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: The original is SQL PL/SQL Annotated Archives --- Bob Metelsky [EMAIL PROTECTED] wrote: Simon, thanks for the plug, although it helps if you tell them the name of the book :) The suspense has been killing me since I posted I'm about to go to Amazon.com and search for ddl ... ;-) Wait... Rachel, what is the name of the book? bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: iAS 1.0.2.2.2a vs 9iR2 db
Thanks! Last night I managed to make progress, now the OPCA complains that I don't have fine-grained access in my database. Will install this tonight, and I think that'll be enough problems for the week. : ) Pat. -Original Message- Sent: Wednesday, December 18, 2002 5:02 PM To: Multiple recipients of list ORACLE-L Did you apply the 8.1.7.3, I think that's the right one, patch against the iAS home? Not that it helps with your install, but we have iAS 1.0.2.2.2a running with a 9iR2 DB. It was originally installed against 9iR1 and then the DB was upgraded. -- Paul -Original Message- Patrice J Sent: Wednesday, December 18, 2002 3:21 PM To: Multiple recipients of list ORACLE-L already done. Well, more troubleshooting in order? They also told me iAS 10.2.2.2a is not certified for XP, what a mess. Pat. -Original Message- Sent: Wednesday, December 18, 2002 2:19 PM To: Multiple recipients of list ORACLE-L You need to set O7_DICTIONARY_ACCESSIBILITY=TRUE in the database. -- Paul -Original Message- Patrice J Sent: Wednesday, December 18, 2002 11:40 AM To: Multiple recipients of list ORACLE-L I know this is probably hopeless, but has anyone managed to let the Oracle Portal Configuration Assistant bundled with iAS 1.0.2.2.2a for win32 connect to a 9i database? It wants to connect as SYS, and of course 9i only wants sys to connect as sysdba. This if for my home sandbox PC, I don't have enough RAM on it to install ias 9iR2, so I am trying to jam iAS 1.0.2.2.2a in there. If connections to 9i are not possible I suppose I will have to use 8.1.7.4.6. for that machine. Patrice Boivin Systems Analyst (Oracle Certified DBA) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Paul Heely INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Paul Heely INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
HP OmniB. + RMAN 8i
Hello, Listers! I have to do RMAN/Oracle/OmniBackII integration, in order to do backup of archived logs. Database itself is backed up to tapesafter mirror split, and that is not the problem. Now it is time to do integration mentioned above... Any advices and experiences, scripts? Thanks, Vladimir Barac
RMAN archived log
Oracle 8.1.7 RMAN with no catalog db, only controlfile is used... How do I remove entries from V$ARCHIVED_LOG; After "backup archivelog all delete input",files are deleted from disk, and their status "deleted" in v$archived_log is set to "YES". But I want to completely remove entries from V$ARCHIVED_LOG. So, is it possible?
RMAN scripts - archived logs
Good day to everyone Would somenone share their scripts used to backup archived logs using RMAN 8.1.7? The more complex, the better... Thanks, Vladimir Barac
HELP NEEDED IN FORMS6I OR FORMS9I DEVELOPMENT - WEB
Hi people Now it's my turn, i really need some help here. I've got some forms developed in forms 6i (even some in forms 4.5) that are working fine in client/server mode. But ... if i switch to web mode i will lose loads of funtionalities here. The real problem is: How do i put the local devices like printers, scanners, fingerprint capture devices, Bar Code capture devices and like working in a forms web application??? It must be a way. Thanks in advance. Paulo Gomes -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Paulo Gomes INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Fw: Greeting
Greeting.jpg
Re: SQL*PLUS and CygWin
Before you run sqlplus, set the ComSpec env variable, like so: set ComSpec=c:\usr\local\wbin\sh.exe Next time you host out it will run this instead of the default ComSpec='C:\WINNT\system32\cmd.exe' HTH, Warren Lindsey Stefan Jahnke wrote: Hi everybody I'm using cywin on my Win2k box to get a reasonable shell. Now there's one problem left: Everytime I issue a host command within SQL*PLUS, I get a Windows console. I would like to get the bash prompt instead. Is there any Any ideas ? Regards, Stefan -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Warren Lindsey INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 and Peoplesoft
How different is an Oracle Peoplesoft database from a regular database? Or in other words what all extra tasks does an Oracle Peoplesoft DBA do? How easy/difficult is it for a an Oracle DBA to transition into a Peoplesoft environment? Are there any good books/ websites on this subject? I would highly appreciate your comments and suggestions. TIA Sumathy Thankam -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Panicker, Thankam S. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Methods to get DDL
The original is SQL PL/SQL Annotated Archives Ahh yes... but the new version is/ seems to be Oracle9i Instant PL/SQL Scripts Book Description From the authorized Oracle Press comes a complete guide to developing PL/SQL solutions quickly and easily. Inside, you'll find ready-to-run code and expert techniques with in-depth explanations that will help you understand the behaviors created, and even extend usage through customization. I bought mine yesterday used for $15 I think that's a pretty good deal http://www.iewww.com/content/0072132183 bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- 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).
Footprint of 9i
All I'm about to consider rolling out 9i here and I'm wondering what type of footprint most people are seeing. In other words how large of an install is a database administrators (enterprise edition)? I've installed 9i at home on WINNT server, Win XP Pro and Suse Linux 8 all were about 2G. I also noticed that even if I tried to remove some components I did not think I needed that the installation size/footprint was not really affected Also a worthwhile note is that my current (enterprise edition) install of 8 17 on win2k server is about 1G This issue is we all run the same size drives here and really cant afford to loose 2G 1G maybe So is it true that overall installing the Enterprise edition of 9i that one could not expect to be much below 2G?? If not, we may have to add a drive for the dba's which is not going to go over big. thanks Bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- 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: Methods to get DDL
Yes, you wouldn't regret. Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, December 19, 2002 8:38 AM The original is SQL PL/SQL Annotated Archives Ahh yes... but the new version is/ seems to be Oracle9i Instant PL/SQL Scripts Book Description From the authorized Oracle Press comes a complete guide to developing PL/SQL solutions quickly and easily. Inside, you'll find ready-to-run code and expert techniques with in-depth explanations that will help you understand the behaviors created, and even extend usage through customization. I bought mine yesterday used for $15 I think that's a pretty good deal http://www.iewww.com/content/0072132183 bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- 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.net -- Author: Igor Neyman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Sql problem
Hi, The following select does not work, I get ORA-00904 error message that the AgentShare column does not exists. It would be painful to write down every calculation many times because I can't make a reference to a previous calculated colunm. Select t.*,t.RowId , CONTR_ROWS_MG - CONTR_ROWS_GROSS_RECEIVED OutStanding , CONTRACT_SALESAGENT_PERCENTAGE * CONTR_ROWS_GROSS_RECEIVED / 100 AgentShare ,CONTRACT_SHARE_FIXED OtherShareFixed ,CONTRACT_SHARE_PERCENTAGE * CONTR_ROWS_GROSS_RECEIVED /100 OtherSharePercentage ,AgentShare *2 From Contract_Rows T,Contract Where Contract.Contract_Unique = t.contr_rows_contract_unique Thank you in advance Zsolt Csillag, Hungary -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Zsolt Csillag INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Urgent: Trigger problem...
Joshua, do you have permission to execute /usr/local/ActiveTcl/bin/tclsh on S.O? Adriano - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, December 19, 2002 2:33 AM Could someone help me with this. I have a trigger in one table and the trigger should do one unix -command (tclsh). However I am facing following problem... OS return value: the Permission (java.io.FilePermission /usr/local/ActiveTcl/bin/tclsh execute) has not been granted to TEST. The PL/SQL to grant this is dbms_java.grant_permission( 'TEST', 'SYS:java.io.FilePermission', '/usr/local/ActiveTcl/bin/tclsh', 'execute' ) I ran the dbms_java.grant_permission pl/sql and it went through succesfully, however I am facing same problem... Any ideas, I am using 9iRel2... Thanx, Joshua _ Gratis e-mail resten av livet på www.yahoo.se/mail Busenkelt! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?iso-8859-1?q?Joshua=20Becker?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Adriano Freire INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: HP OmniB. + RMAN 8i
I've spent some time trying to make it work between Oracle 804/rman and Omniback2 hp10.20. The MML documentation was quite fuzzy. I hope it's easier with 8i. --- Vladimir Barac [EMAIL PROTECTED] a écrit : Hello, Listers! I have to do RMAN/Oracle/OmniBackII integration, in order to do backup of archived logs. Database itself is backed up to tapes after mirror split, and that is not the problem. Now it is time to do integration mentioned above... Any advices and experiences, scripts? Thanks, Vladimir Barac = Stéphane Paquette DBA Oracle et DB2, consultant entrepôt de données Oracle and DB2 DBA, datawarehouse consultant [EMAIL PROTECTED] __ Lèche-vitrine ou lèche-écran ? magasinage.yahoo.ca -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?iso-8859-1?q?Stephane=20Paquette?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Sql problem
Two possible answers : 42 and inline views. - Original Message - From: Zsolt Csillag [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thu, 19 Dec 2002 05:43:55 Hi, The following select does not work, I get ORA-00904 error message that the AgentShare column does not exists. It would be painful to write down every calculation many times because I can't make a reference to a previous calculated colunm. Select t.*,t.RowId , CONTR_ROWS_MG - CONTR_ROWS_GROSS_RECEIVED OutStanding , CONTRACT_SALESAGENT_PERCENTAGE * CONTR_ROWS_GROSS_RECEIVED / 100 AgentShare ,CONTRACT_SHARE_FIXED OtherShareFixed ,CONTRACT_SHARE_PERCENTAGE * CONTR_ROWS_GROSS_RECEIVED /100 OtherSharePercentage ,AgentShare *2 From Contract_Rows T,Contract Where Contract.Contract_Unique = t.contr_rows_contract_unique Thank you in advance Zsolt Csillag, Hungary -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Zsolt Csillag INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). --- -- Regards, Stephane Faroult Oriole -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroul INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
problems with materialized view
Hi, On Oracle 8.1.7.2 /aix 4.3 Refreshing complete a MV took forever, I canceled them after 10 hours. Dropping and recreating it took 10 minutes. On another MV, refreshing complete uses over 1G temp space, when dropping and recreating no temp tablespace busting. On smaller ones no difference between drop/create and refresh. The ones I've got problems with have query over 3 pages long. Oracle bugs ? = Stéphane Paquette DBA Oracle et DB2, consultant entrepôt de données Oracle and DB2 DBA, datawarehouse consultant [EMAIL PROTECTED] __ Lèche-vitrine ou lèche-écran ? magasinage.yahoo.ca -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?iso-8859-1?q?Stephane=20Paquette?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Bizzare behaviour of set oracle_sid=mysid
Only in my office can this happen Im checking into connecting to the db under the internal account from a cmd prompt I set oracle_sid=mysid C: set oracle_sid=my_sid C: connect internal I see cmd issuing sqlplusw system/password@othersid So, I add a permanent env_variable called ORACLE_SID I set the value to a bogus name eg mysid go to cmd C:set ORACLE_SID=mysid then I set ORACLE_sid=LOCDB set ORACLE_sid=LOCDB then connect internal I see cmd doing sqlplusw system/password@othersid It fails because I dont have a tns entry for othersid Where the heck is cmd getting the values for othersid?? any ideas? thanks bob ## LOCDB SQL select version from v$instance; VERSION - 8.1.6.0.0 ## Below is my output of set C:\set ALLUSERSPROFILE=C:\Documents and Settings\All Users APPDATA=C:\Documents and Settings\bmetelsky\Application Data CI_HOLOS_CLI=C:\Program Files\Seagate Software\Open Olap\ CLASSPATH=D:\Programs\;C:\gnupg;C:\Oracle\Ora81\orb\classes\yoj.jar;C:\O racle\Ora81\orb\classes\share.zi CommonProgramFiles=C:\Program Files\Common Files COMPUTERNAME=CPS109 ComSpec=C:\WINNT\system32\cmd.exe HOMEDRIVE=e: HOMEPATH=\bob LOGONSERVER=\\A_LOGON NUMBER_OF_PROCESSORS=1 oracle_home=C:\Oracle\Ora81 ORACLE_SID=LOCDB OS=Windows_NT Os2LibPath=C:\WINNT\system32\os2\dll; Path=D:\Oracle\Ora81\bin;C:\vim\vim\vim60;D:\Perl\bin\;C:\Oracle\Ora81\b in;C:\Oracle\Ora81\bin\bin80;C:\ am Files\Oracle\jre\1.1.7\bin;C:\WINNT\system32;C:\WINNT;C:\WINNT\System32\ Wbem;C:\Oracle\Ora81\orb\bin; ULTRAE~1 PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH PERLDB_OPTS=RemotePort=127.0.0.1:2000 PROCESSOR_ARCHITECTURE=x86 PROCESSOR_IDENTIFIER=x86 Family 15 Model 0 Stepping 10, GenuineIntel PROCESSOR_LEVEL=15 PROCESSOR_REVISION=000a ProgramFiles=C:\Program Files PROMPT=$P$G SystemDrive=C: SystemRoot=C:\WINNT TEMP=C:\ TMP=C:\ USERDNSDOMAIN=MYDOMAIN USERDOMAIN=MYDOMAIN USERNAME=bmetelsky USERPROFILE=C:\Documents and Settings\bmetelsky windir=C:\WINNT -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- 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).
AW: SQL*PLUS and CygWin
Hi Great, thank you. Stefan -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stefan Jahnke INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Sql problem
Use inline views, create a view or use a cursor in a PL/sql block Regards, Waleed -Original Message- Sent: Thursday, December 19, 2002 8:44 AM To: Multiple recipients of list ORACLE-L Hi, The following select does not work, I get ORA-00904 error message that the AgentShare column does not exists. It would be painful to write down every calculation many times because I can't make a reference to a previous calculated colunm. Select t.*,t.RowId , CONTR_ROWS_MG - CONTR_ROWS_GROSS_RECEIVED OutStanding , CONTRACT_SALESAGENT_PERCENTAGE * CONTR_ROWS_GROSS_RECEIVED / 100 AgentShare ,CONTRACT_SHARE_FIXED OtherShareFixed ,CONTRACT_SHARE_PERCENTAGE * CONTR_ROWS_GROSS_RECEIVED /100 OtherSharePercentage ,AgentShare *2 From Contract_Rows T,Contract Where Contract.Contract_Unique = t.contr_rows_contract_unique Thank you in advance Zsolt Csillag, Hungary -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Zsolt Csillag INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Khedr, Waleed INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 and Peoplesoft
Hi Sumathy, It is not too much different from oracle peoplesoft and regular dba. Except you have to know more about peoplesoft components, peoplesoft application server, process schedular, web server,weblogic.. there are some peoplesoft courses I am highly recommend you to take, Configuration and Administration Data Management Tools and another one peoplesoft server administration on Unix/Oracle. They has a website just like metlink. you need a customer id to access it. I feel like as long as peoplesoft infrastucture setup correctly in the beginning. It save a lot of time to troubleshoot later. As a oracle/peoplesoft dba, you have to constantly deal with upgrade poeplesoft tools, application, oracle. so clone the production database is major thing to do. we are constantly refresh testing databases from production. so automate those scripts are very helpful. Joan Panicker, Thankam S. wrote: How different is an Oracle Peoplesoft database from a regular database? Or in other words what all extra tasks does an Oracle Peoplesoft DBA do? How easy/difficult is it for a an Oracle DBA to transition into a Peoplesoft environment? Are there any good books/ websites on this subject? I would highly appreciate your comments and suggestions. TIA Sumathy Thankam -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Panicker, Thankam S. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joan Hsieh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: read only tablespaces
Ah, once again, we are deeply indebted to Jared for his 'perls' of wisdom... -Original Message- Sent: Wednesday, December 18, 2002 4:29 PM To: Multiple recipients of list ORACLE-L Or the Oxford Encyclopedic (sp?) Dictionary of the English Language should you wish a truly authoritative source. ;) Fink, Dan [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/18/2002 02:14 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: read only tablespaces I would suggest Funk Wagnells or Webster's New College Edition -Original Message- Sent: Wednesday, December 18, 2002 2:34 PM To: Multiple recipients of list ORACLE-L which dictionary should I check to see whether a tablespace is read-only or read-write? thanks for your help. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Fink, Dan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
AW: Sql problem
Try following: Select t.*,t.RowId , CONTR_ROWS_MG - CONTR_ROWS_GROSS_RECEIVED OutStanding , CONTRACT_SALESAGENT_PERCENTAGE * CONTR_ROWS_GROSS_RECEIVED / 100 AgentShare ,CONTRACT_SHARE_FIXED OtherShareFixed ,CONTRACT_SHARE_PERCENTAGE * CONTR_ROWS_GROSS_RECEIVED /100 OtherSharePercentage ,(CONTRACT_SALESAGENT_PERCENTAGE * CONTR_ROWS_GROSS_RECEIVED / 100)*2 AgentShare2 From Contract_Rows T,Contract Where Contract.Contract_Unique = t.contr_rows_contract_unique Volker Schoen E-Mail: mailto:[EMAIL PROTECTED] http://www.inplan.de -Ursprüngliche Nachricht- Von: Zsolt Csillag [mailto:[EMAIL PROTECTED]] Gesendet: Donnerstag, 19. Dezember 2002 14:44 An: Multiple recipients of list ORACLE-L Betreff: Sql problem Hi, The following select does not work, I get ORA-00904 error message that the AgentShare column does not exists. It would be painful to write down every calculation many times because I can't make a reference to a previous calculated colunm. Select t.*,t.RowId , CONTR_ROWS_MG - CONTR_ROWS_GROSS_RECEIVED OutStanding , CONTRACT_SALESAGENT_PERCENTAGE * CONTR_ROWS_GROSS_RECEIVED / 100 AgentShare ,CONTRACT_SHARE_FIXED OtherShareFixed ,CONTRACT_SHARE_PERCENTAGE * CONTR_ROWS_GROSS_RECEIVED /100 OtherSharePercentage ,AgentShare *2 From Contract_Rows T,Contract Where Contract.Contract_Unique = t.contr_rows_contract_unique Thank you in advance Zsolt Csillag, Hungary -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Zsolt Csillag INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Footprint of 9i
When you say footprint of 9i, my mind automatically flashes to the opening credits of Monty Python's Flying Circus, in which the Liberty Bell March is terminated with a large foot squashing down (*splat*)... I'm not sure what type of systems you're running, but I haven't seen drives smaller than 18G much lately. Perhaps its time to upgrade to a SAN anyway? :-) 1G isn't all that much to ask (especially if your production systems are running in ARCHIVELOG mode), but your comments prove that point that disk is cheap, until you try to justify the purchase of more... All I'm about to consider rolling out 9i here and I'm wondering what type of footprint most people are seeing. In other words how large of an install is a database administrators (enterprise edition)? I've installed 9i at home on WINNT server, Win XP Pro and Suse Linux 8 all were about 2G. I also noticed that even if I tried to remove some components I did not think I needed that the installation size/footprint was not really affected Also a worthwhile note is that my current (enterprise edition) install of 8 17 on win2k server is about 1G This issue is we all run the same size drives here and really cant afford to loose 2G 1G maybe So is it true that overall installing the Enterprise edition of 9i that one could not expect to be much below 2G?? If not, we may have to add a drive for the dba's which is not going to go over big. thanks Bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- 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.net -- 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: Backup DB files to the Tape
Stephen, The para. about pax vis-a-vis tar versus cpio was interesting ! I never knew that -- though the names do make sense now ! Hemant At 06:39 AM 18-12-02 -0800, you wrote: I will add a vote for cpio. I have found it to be so reliable that I used cpio, instead of a dump utility, to back up Unix boxes. It never failed. In the past, I found that tar had filename length limitation that was shorter than what the OS permitted (80 characters iirc -- that's filename, not path). This happened when I worked in a development environment that used Rogue Wave tools. During software builds, files would be generated with ridiculously long names, and tar could not handle these. Time has passed since the days I had to backup Unix servers, but iirc cpio could correctly handle all types of special files (devices, etc.), and tar could not (as I said, iirc). If you are just experimenting, there is another utility called pax, which is latin for peace, the idea being that it will bring peace to the Tar Wars where tar2d2 is always fighting c3pio. I get the impression that neither group was willing to abandon its favorite utility and adopt pax, so the fight goes on. -Original Message- Well for this you can use cpio command in Unix for copying files to Tape. Another option is using ufsdump commnand . We have UnixWare 7.1 and I want to take backup of Database files (Physical files) to my tape. I did use tar command: tar c8v1 /home/oradata It's working properly but the problem is: tar can't handle large files(larger than 2GB). The total size of the DB files under /home/oradata more than 2GB. So the result I'll get some of those files not all. Could any body in the list give me the alternative command of tar that can handle backup of large files or any other solution... because I want to schedule this process. Your help will be appreciated. Regards, ashraf salaymeh System Analyst(OCP Certified DBA) __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ashraf Salaymeh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: dilmohan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Hemant K Chitale My web site page is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: RMAN scripts - archived logs
Attached (If the list supports attachments) are one for tape (Legato Networker) and one for disk which later gets backed up by OS. These are generated by a ksh backup script every time the script runs. The disk backup does not use a catalog server; so you have the line at the end that backs up the control file. -Original Message- Would somenone share their scripts used to backup archived logs disk_backup_arch.rcv Description: Binary data tape_backup_arch.rcv Description: Binary data
Re: iAS 1.0.2.2.2a vs 9iR2 db
You'd need to set O7_DICTIONARY_ACCESSIBILITY to TRUE. Hemant At 08:39 AM 18-12-02 -0800, you wrote: I know this is probably hopeless, but has anyone managed to let the Oracle Portal Configuration Assistant bundled with iAS 1.0.2.2.2a for win32 connect to a 9i database? It wants to connect as SYS, and of course 9i only wants sys to connect as sysdba. This if for my home sandbox PC, I don't have enough RAM on it to install ias 9iR2, so I am trying to jam iAS 1.0.2.2.2a in there. If connections to 9i are not possible I suppose I will have to use 8.1.7.4.6. for that machine. Patrice Boivin Systems Analyst (Oracle Certified DBA) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Hemant K Chitale My web site page is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: read only tablespaces
Is this group suppose to be helpful or for some people just to show their ego? I do not know something you think is obvious, but I also know something you might not know, which to me is quite easy. It is a learning process, isn't it? One thing I notice is, for some really learned person, they are really nice and patient. For those people who is mean, are you really that knowledgable? -Original Message- Sent: Thursday, December 19, 2002 9:55 AM To: Multiple recipients of list ORACLE-L Ah, once again, we are deeply indebted to Jared for his 'perls' of wisdom... -Original Message- Sent: Wednesday, December 18, 2002 4:29 PM To: Multiple recipients of list ORACLE-L Or the Oxford Encyclopedic (sp?) Dictionary of the English Language should you wish a truly authoritative source. ;) Fink, Dan [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/18/2002 02:14 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: read only tablespaces I would suggest Funk Wagnells or Webster's New College Edition -Original Message- Sent: Wednesday, December 18, 2002 2:34 PM To: Multiple recipients of list ORACLE-L which dictionary should I check to see whether a tablespace is read-only or read-write? thanks for your help. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Fink, Dan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Shao, Chunning INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 and Peoplesoft
While we're on the subject of Oracle and PeopleSoft, has anyone out there in a PeopleSoft environment turned on password aging? If so, how did PeopleSoft react? Dick Goulet Reply Separator Author: Panicker; Thankam S. [EMAIL PROTECTED] Date: 12/19/2002 5:09 AM How different is an Oracle Peoplesoft database from a regular database? Or in other words what all extra tasks does an Oracle Peoplesoft DBA do? How easy/difficult is it for a an Oracle DBA to transition into a Peoplesoft environment? Are there any good books/ websites on this subject? I would highly appreciate your comments and suggestions. TIA Sumathy Thankam -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Panicker, Thankam S. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Footprint of 9i
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Bob Metelsky Sent: Thursday, December 19, 2002 13:49 To: Multiple recipients of list ORACLE-L Subject: Footprint of 9i All I'm about to consider rolling out 9i here and I'm wondering what type of footprint most people are seeing. In other words how large of an install is a database administrators (enterprise edition)? I've installed 9i at home on WINNT server, Win XP Pro and Suse Linux 8 all were about 2G. I also noticed that even if I tried to remove some components I did not think I needed that the installation size/footprint was not really affected Also a worthwhile note is that my current (enterprise edition) install of 8 17 on win2k server is about 1G This issue is we all run the same size drives here and really cant afford to loose 2G 1G maybe So is it true that overall installing the Enterprise edition of 9i that one could not expect to be much below 2G?? If not, we may have to add a drive for the dba's which is not going to go over big. thanks Bob Bob, No surprises, you're not alone. The easiest 400MB to 500MB to remove are the templates and demo files for the starter instances and schemas. Try deleting %ORACLE_HOME%\assistants\dbca\templates\* to free up 300MB (these are the 'OLTP' and 'Data warehouse' templates used by the dbassist tool - if you don't use them for creating instances, get rid of them), and %ORACLE_HOME%\demo\schema\* to free up 100MB of the scripts used to create the sample schemas - again if you don't use them. There might be more that can be removed ... doco and the like ... but that's a start. Ciao Fuzzy :-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Footprint of 9i
On Tru64 5.1 /oracle/app/oracle/product du -sk 9.2.0 4601900 9.2.0 There are multiple DBA's here that have a hand in this, so I don't know how much fiddling with the Apache stuff has been done (probably not much). At this time, there is only one 9.2 database on the box, and it is experimental, so I don't think there are a bunch of network logs that have piled up. I think this installation everything including the kitchen sink, so I would think this size would be near the upper limit. -Original Message- From: Bob Metelsky [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 19, 2002 7:49 AM To: Multiple recipients of list ORACLE-L Subject: Footprint of 9i All I'm about to consider rolling out 9i here and I'm wondering what type of footprint most people are seeing. In other words how large of an install is a database administrators (enterprise edition)? I've installed 9i at home on WINNT server, Win XP Pro and Suse Linux 8 all were about 2G. I also noticed that even if I tried to remove some components I did not think I needed that the installation size/footprint was not really affected Also a worthwhile note is that my current (enterprise edition) install of 8 17 on win2k server is about 1G This issue is we all run the same size drives here and really cant afford to loose 2G 1G maybe So is it true that overall installing the Enterprise edition of 9i that one could not expect to be much below 2G?? If not, we may have to add a drive for the dba's which is not going to go over big. thanks Bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- 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.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: HP OmniB. + RMAN 8i
RMAN in 8.0.4 was fuzzy in a lot of ways. 8.0.5.1 is better, 8.0.6.3 better still, and 8i is much like 8.0.6.3. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, December 19, 2002 9:29 AM I've spent some time trying to make it work between Oracle 804/rman and Omniback2 hp10.20. The MML documentation was quite fuzzy. I hope it's easier with 8i. --- Vladimir Barac [EMAIL PROTECTED] a écrit : Hello, Listers! I have to do RMAN/Oracle/OmniBackII integration, in order to do backup of archived logs. Database itself is backed up to tapes after mirror split, and that is not the problem. Now it is time to do integration mentioned above... Any advices and experiences, scripts? Thanks, Vladimir Barac = Stéphane Paquette DBA Oracle et DB2, consultant entrepôt de données Oracle and DB2 DBA, datawarehouse consultant [EMAIL PROTECTED] __ Lèche-vitrine ou lèche-écran ? magasinage.yahoo.ca -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?iso-8859-1?q?Stephane=20Paquette?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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: Sql problem
Zsolt, In Oracle9i, you might be able to make use of the new WITH syntax: SQL with xxx as 2 (select 1+2 calc from dual) 3 select calc*2 from xxx; CALC*2 -- 6 It might cut down on typographic errors (if not syntax complexity) from repeatedly retyping the same complex formula... Hope this helps... -Tim Hi, The following select does not work, I get ORA-00904 error message that the AgentShare column does not exists. It would be painful to write down every calculation many times because I can't make a reference to a previous calculated colunm. Select t.*,t.RowId , CONTR_ROWS_MG - CONTR_ROWS_GROSS_RECEIVED OutStanding , CONTRACT_SALESAGENT_PERCENTAGE * CONTR_ROWS_GROSS_RECEIVED / 100 AgentShare ,CONTRACT_SHARE_FIXED OtherShareFixed ,CONTRACT_SHARE_PERCENTAGE * CONTR_ROWS_GROSS_RECEIVED /100 OtherSharePercentage ,AgentShare *2 From Contract_Rows T,Contract Where Contract.Contract_Unique = t.contr_rows_contract_unique Thank you in advance Zsolt Csillag, Hungary -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Zsolt Csillag INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services -- --- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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: Where's that last archive log?
In theory you should always be able to do an Incomplete Recovery [until the latest archive log you have available] provided that no database file was still in backup mode till a point in time after the last archive log. How do you backup your tablespaces ? Which archive logs are included in your D.R. backups ? You must have all the archive logs generated till the last END BACKUP command of that database backup set. Else, you'd have to restore an _OLDER_ backup set and do an incomplete recovery. Hemant At 01:46 PM 18-12-02 -0800, you wrote: We do disaster recovery tests from time to time with a limited set of backups. We make an educated quess as to the time to recover but it doesn't always work. If I give Oracle a point in time to recover and then run out of archive logs how do I tell Oracle that that's all I have and recover with what is available? I have tried recover until cancel but Oracle always seems to need another archive log. It usually says the System file needs to be recovered. If I have all the archive logs it works fine. R.Smith If you are not the intended recipient of this e-mail message, any use, distribution or copying of the message is prohibited. Please let me know immediately by return e-mail if you have received this message by mistake, then delete the e-mail message. Thank you. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- 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). Hemant K Chitale My web site page is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Bizzare behaviour of set oracle_sid=mysid
Are you executing connect internal at the CMD C: prompt ? Shouldn't it be in the sqlplus prompt ? See if you've somehow got a CONNECT.BAT file in your path. If you are executing C: connect internal, you are probably executing CONNECT.BAT [or CONNECT.EXE or CONNECT.COM] Hemant At 06:39 AM 19-12-02 -0800, you wrote: Only in my office can this happen Im checking into connecting to the db under the internal account from a cmd prompt I set oracle_sid=mysid C: set oracle_sid=my_sid C: connect internal I see cmd issuing sqlplusw system/password@othersid So, I add a permanent env_variable called ORACLE_SID I set the value to a bogus name eg mysid go to cmd C:set ORACLE_SID=mysid then I set ORACLE_sid=LOCDB set ORACLE_sid=LOCDB then connect internal I see cmd doing sqlplusw system/password@othersid It fails because I dont have a tns entry for othersid Where the heck is cmd getting the values for othersid?? any ideas? thanks bob ## LOCDB SQL select version from v$instance; VERSION - 8.1.6.0.0 ## Below is my output of set C:\set ALLUSERSPROFILE=C:\Documents and Settings\All Users APPDATA=C:\Documents and Settings\bmetelsky\Application Data CI_HOLOS_CLI=C:\Program Files\Seagate Software\Open Olap\ CLASSPATH=D:\Programs\;C:\gnupg;C:\Oracle\Ora81\orb\classes\yoj.jar;C:\O racle\Ora81\orb\classes\share.zi CommonProgramFiles=C:\Program Files\Common Files COMPUTERNAME=CPS109 ComSpec=C:\WINNT\system32\cmd.exe HOMEDRIVE=e: HOMEPATH=\bob LOGONSERVER=\\A_LOGON NUMBER_OF_PROCESSORS=1 oracle_home=C:\Oracle\Ora81 ORACLE_SID=LOCDB OS=Windows_NT Os2LibPath=C:\WINNT\system32\os2\dll; Path=D:\Oracle\Ora81\bin;C:\vim\vim\vim60;D:\Perl\bin\;C:\Oracle\Ora81\b in;C:\Oracle\Ora81\bin\bin80;C:\ am Files\Oracle\jre\1.1.7\bin;C:\WINNT\system32;C:\WINNT;C:\WINNT\System32\ Wbem;C:\Oracle\Ora81\orb\bin; ULTRAE~1 PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH PERLDB_OPTS=RemotePort=127.0.0.1:2000 PROCESSOR_ARCHITECTURE=x86 PROCESSOR_IDENTIFIER=x86 Family 15 Model 0 Stepping 10, GenuineIntel PROCESSOR_LEVEL=15 PROCESSOR_REVISION=000a ProgramFiles=C:\Program Files PROMPT=$P$G SystemDrive=C: SystemRoot=C:\WINNT TEMP=C:\ TMP=C:\ USERDNSDOMAIN=MYDOMAIN USERDOMAIN=MYDOMAIN USERNAME=bmetelsky USERPROFILE=C:\Documents and Settings\bmetelsky windir=C:\WINNT -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- 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). Hemant K Chitale My web site page is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Spool output issue on solaris
This is what i am doing: 1- login to sqlplus on solaris 2- spool temp.out 3- run an sql file useing: @myfile.sql Sql file contains this: set termout off set head off set echo off set feedback off select * from dual; set termout on set head on set echo on set feedback on 4- spool off Spool file has expected output, which is result of sql statement ONLY! Now when i place following in a shell script and run it #!/bin/ksh $ORACLE_HOME/bin/sqlplus liserv/liserv@webny EOF set feedback off set head off set echo off set termout off spool output.txt select * from dual; spool off set feedback on set head on set echo on set termout on exit; ___ Now question is that in later case where i use shell script along with out put of query , WHY DO I SEE THE ACTUAL SQL STATEMENT IN SPOOL FILE ALSO? Even though i have feedback, echo and termout off . Any way around. I want ONLY output of query in spool file when sql file is run using a SHELL SCRIPT!. Thanks. __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: OraCop INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: 9i / 9iRAC : Segment_Space_Management AUTO, with LOB
Title: RE: 9i / 9iRAC : Segment_Space_Management AUTO, with LOB in our 9202 RAC we have everything except SYSTEM,UNDO in AUTO and have NO problems at all. We have 7 such instances (all RAC, all 9202 except for on which is 9012). 4 Instances use CLOBs and intermedia extensively, one of these uses XML CLOB combination never faced any problems. Vivek, what problem you faced (or still facing), are those bugs? Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message- From: VIVEK_SHARMA [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 19, 2002 10:09 AM To: Multiple recipients of list ORACLE-L Subject: RE: 9i / 9iRAC : Segment_Space_Management AUTO, with LOB As part of a RAC benchmark with 9.2 we had faced severe LOCKING on setting segment space management AUTO had to REMOVE it HTH *This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*1
Spool file behavior on Solaris
hello, This is what i am doing: __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: OraCop INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Direct and indirect foreign key relationships in SQL or Pl/Sql
Here is a script that I got from on of the lists. It should do what you want. Ruth select a.constraint_name, a.r_constraint_name, a.table_name, b.table_name from dba_constraints a, dba_constraints b where a.owner='YOUR_OWNER' and a.R_CONSTRAINT_NAME is not null and a.R_constraint_name=b.constraint_name order by a.table_name; - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, December 19, 2002 2:14 AM Hi all, How do I find out the direct and indirect foreign key relationships? Say, for example there are four tables A, B, C and D of which A is the parent table and B, C and D are child tables. Say B and C are related to A directly and D is related to A through C. How do I find out this indirect relationship apart from the direct relationships? Any help in this regard is very much appreciated. Thanks and Regards, Ranganath WARNING: The information in this message is confidential and may be legally privileged. It is intended solely for the addressee. Access to this message by anyone else is unauthorised. If you are not the intended recipient, any disclosure, copying, or distribution of the message, or any action or omission taken by you in reliance on it, is prohibited and may be unlawful. Please immediately contact the sender if you have received this message in error. Thank you. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Krishnaswamy, Ranganath INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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: Footprint of 9i
Nearly 4Gb on Solaris 2.8. Pretty much a full selection installed John -Original Message- Sent: 19 December 2002 15:00 To: Multiple recipients of list ORACLE-L On Tru64 5.1 /oracle/app/oracle/product du -sk 9.2.0 4601900 9.2.0 There are multiple DBA's here that have a hand in this, so I don't know how much fiddling with the Apache stuff has been done (probably not much). At this time, there is only one 9.2 database on the box, and it is experimental, so I don't think there are a bunch of network logs that have piled up. I think this installation everything including the kitchen sink, so I would think this size would be near the upper limit. -Original Message- From: Bob Metelsky [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 19, 2002 7:49 AM To: Multiple recipients of list ORACLE-L Subject: Footprint of 9i All I'm about to consider rolling out 9i here and I'm wondering what type of footprint most people are seeing. In other words how large of an install is a database administrators (enterprise edition)? I've installed 9i at home on WINNT server, Win XP Pro and Suse Linux 8 all were about 2G. I also noticed that even if I tried to remove some components I did not think I needed that the installation size/footprint was not really affected Also a worthwhile note is that my current (enterprise edition) install of 8 17 on win2k server is about 1G This issue is we all run the same size drives here and really cant afford to loose 2G 1G maybe So is it true that overall installing the Enterprise edition of 9i that one could not expect to be much below 2G?? If not, we may have to add a drive for the dba's which is not going to go over big. thanks Bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- 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.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Restoring DB from specific RMAN backup set.
How can I restore a database from a specific RMAN backup set? We have a database running in no archive log mode that is backed up with RMAN. There is an RMAN catalog DB also. If I look at the backup summary I see: List of Database Incarnations DB Key Inc Key DB Name DB IDCUR Reset SCN Reset Time --- --- --- -- -- 37 38 DB2 1600772452 NO 1 15-NOV-02 37 256 DB2 1600772452 NO 259591 23-NOV-02 37 627 DB2 1600772452 NO 792890 11-DEC-02 37 654 DB2 1600772452 NO 792890 11-DEC-02 37 712 DB2 1600772452 NO 792890 11-DEC-02 37 680 DB2 1600772452 NO 792890 11-DEC-02 37 764 DB2 1600772452 NO 823456 11-DEC-02 37 816 DB2 1600772452 YES 823456 18-DEC-02 37 893 DB2 1600772452 NO 823456 19-DEC-02 The backup summary list looks like: List of Backups === Key TY LV S Device Type Completion Time #Pieces #Copies Tag --- -- -- - --- --- --- --- --- 47 B F A DISK15-NOV-02 1 1 63 B F A DISK15-NOV-02 1 1 WORKFLOW_AND_PORTAL 306 B F A DISK23-NOV-02 1 1 314 B F A DISK23-NOV-02 1 1 404 B F A DISK26-NOV-02 1 1 FULL_BACKUP_9014_PATCH 413 B F A DISK26-NOV-02 1 1 729 B F A DISK11-DEC-02 1 1 FULL_DB_INSTALLED 749 B F A DISK11-DEC-02 1 1 791 B F A DISK18-DEC-02 1 1 WF_TESTING 811 B F A DISK18-DEC-02 1 1 867 B F A DISK19-DEC-02 1 1 SW_MIGRATION 888 B F A DISK19-DEC-02 1 1 I've tried resetting the database to incarnation 816, but when I restore the control file and data files from that it is not what I think it should be. I end up with FULL_DB_INSTALLED. I can restore the control file I want from the auto backup file. How can I then tell RMAN to restore the data files associated with either backup set 791 (tag=WF_TESTING)? Thanks. -- Paul -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Paul Heely INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Spool file output
This is what i am doing: 1- login to sqlplus on solaris 2- spool temp.out 3- run an sql file useing: @myfile.sql Sql file contains this: set termout off set head off set echo off set feedback off set pagesize 0 4- spool off __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: OraCop INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Simple Query for Week number
Hey Folks, Looking for the simplest of queries to find the week number, given a date. For example, 19th December 2002 falls in the 3rd week, whereas 19th November, 2002, falls in the 4th week. Thanks Raj -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: kinda OT: veritas netbackup
How about running a script just before the backup that 1) Reads the current log number. 2) Forces a log switch. 3) Copies the logs to a seperate directory. 4) Backups up that seperate directory Leave the archive directory alone. Do not back it up. -Original Message-From: JOE TESTA [mailto:[EMAIL PROTECTED]]Sent: Thursday, December 19, 2002 9:50 AMTo: Multiple recipients of list ORACLE-LSubject: kinda OT: veritas netbackup RESEND: never saw it get posted: Can we force veritas netbackup (HPUX) to NOT backup open files? Here is the problem: while arch process is writing out archive logs, the netbackup script that backs up the arch directory will write a partially written log to tape, we're trying to avoid that. is our only alternative determine(out of data dictionary) how many log groups we have and assuming 3, that if we take the max log seq# minus the numebr of groups we have, gives us the oldest log that we can be sure is complete? ie: current log is 543, we have 3 log groups, 543-3 = 540, since oracle wouldnt start overwriting # 540 until it was successfully archived, that we can back up, up thru log seq# 540 and can be sure # 540 is complete? thanks, joe
RE: read only tablespaces
Title: RE: read only tablespaces Here's the specific SQL query that needs to be run: select translate('LNOPQSUVWXYZBCDEGHIJKn;8!###)n9/)3l9)jku9)vum1@', '8#)n!9/3lvjkum1;@LNOPQSUVWXYZBCDEGHIJK', 'F. aRMedthmfinulT!') Well... from DICTIONARY where table_name='DICTIONARY' / :-) :-) :-) -Original Message- From: Burke, William F (Bill) [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 18, 2002 4:49 PM To: Multiple recipients of list ORACLE-L Subject: RE: read only tablespaces Personally I would try dba_tablespaces and check the status column... online, offline or read only. If it's online, it's read-write, read only speaks for itself. Good to see sarcasm hasn't left the list. Regards, Bill Burke The Kinder and Gentler DBA www.OracleGuru.com www.KBMotorsports.biz -Original Message- From: Fink, Dan [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 18, 2002 4:15 PM To: Multiple recipients of list ORACLE-L Subject: RE: read only tablespaces I would suggest Funk Wagnells or Webster's New College Edition -Original Message- From: Shao, Chunning [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 18, 2002 2:34 PM To: Multiple recipients of list ORACLE-L Subject: read only tablespaces which dictionary should I check to see whether a tablespace is read-only or read-write? thanks for your help.
strange error on DBMS_STATS
I'm running dbms_stats.gather_schema_stats, the account running it is NOT the schema owner, but DOES have the analyze any privilege and has read/write access to all the tables in the schema. We are not trying to gather stats into our own tables, just want the stats refreshed after the (massive) loads into the DW tables. This has been running fine, then all of a sudden last night we started getting ORA-1031 (insufficient privileges) errors. Now, according to the docs: ORA-01031 insufficient privileges Cause: An attempt was made to change the current username or password without the appropriate privilege. This error also occurs if attempting to install a database without the necessary operating system privileges. We are not changing passwords, so I am presuming that this involves (somehow) a change of username. According to the package header, it will throw an ORA-2 if there are insufficent privileges. We rebuilt an index yesterday but did NOT change or add any table. I had this happen once before, on a different database, never solved it, but substituted dbms_utility.analyze_schema which worked. I can do the same thing this time but I'd prefer to solve it. Anyone ever see anything like this before? oh yeah 9.2.0.1 on Solaris 8 Rachel __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Bizzare behaviour of set oracle_sid=mysid
Humm obivioiously Im missing a few brain cells here Yes, I should know there isnt an exe called connect that would be native to the envioriment outside of oracle. Yes, there was a connect.bat in the path Duh... Ok, so lets see how many more vacant brain cells I have now if I log on to sql+ with a dba account (has all privilidges) ### LOCDB SQL connect / as sysdba Or LOCDB SQL connect / internal ERROR: ORA-12560: TNS:protocol adapter error Warning: You are no longer connected to ORACLE. LOCDB SQL select * from global_name; Not connected ### Why does this happen? The bottom line is Im trying to connect as internal w/o the password ### C:\set oracle_sid=LOCDB C:\svrmgrl Oracle Server Manager Release 3.1.6.0.0 - Production Copyright (c) 1997, 1999, Oracle Corporation. All Rights Reserved. Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production With the Partitioning option JServer Release 8.1.6.0.0 - Production SVRMGR connect internal Password: I can however connect internal/password Thanks for being paitent bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- 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: Spool file output
and your problem is? I run spool files on solaris all the time. What exactly is going wrong? --- OraCop [EMAIL PROTECTED] wrote: This is what i am doing: 1- login to sqlplus on solaris 2- spool temp.out 3- run an sql file useing: @myfile.sql Sql file contains this: set termout off set head off set echo off set feedback off set pagesize 0 4- spool off __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: OraCop INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
What Bonnie's benchmark should we expect for RAID 0+1
Hello, We have a Compaq AlphaServer 8400 with 8 GB RAM, 8 dual 625mhz CPUs and two HSZ70 Array Controllers. Each Controller is connected to 24 36GB 10K rpm Ultr SCSI disk divers. In the system, some volums are configured as RAID 1, and the others are configured as RAID 0+1 with 3 striping. However, we can't see significant performance improvement in RAID 0+1 volums except random seek. The following are the Bonnie's benchmarks for two kinds of volums: For RAID 1: ---Sequential Output ---Sequential Input-- --Random-- -Per Char- --Block--- -Rewrite-- -Per Char- --Block--- --Seeks--- MachineMB K/sec %CPU K/sec %CPU K/sec %CPU K/sec %CPU K/sec %CPU /sec %CPU RAID11024 9029 55.1 9108 14.3 8956 15.6 15700 89.4 115531 99.9 2535.2 65.9 For RAID 0+1: ---Sequential Output ---Sequential Input-- --Random-- -Per Char- --Block--- -Rewrite-- -Per Char- --Block--- --Seeks--- MachineMB K/sec %CPU K/sec %CPU K/sec %CPU K/sec %CPU K/sec %CPU /sec %CPU RAID01 1024 9780 58.8 9872 17.1 14067 25.7 15990 89.7 56037 59.5 5374.3 169.9 Is there something wrong? What Bonnie's benchmark should we expect for RAID 0+1? Thanks, Tom -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Xie, Tom INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Backup DB files to the Tape
It's one of those Unix things. It goes with the beard and the bad-fitting trousers held up by suspenders. -Original Message- From: Hemant K Chitale [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 19, 2002 9:21 AM To: Multiple recipients of list ORACLE-L Subject: RE: Backup DB files to the Tape Stephen, The para. about pax vis-a-vis tar versus cpio was interesting ! I never knew that -- though the names do make sense now ! Hemant At 06:39 AM 18-12-02 -0800, you wrote: I will add a vote for cpio. I have found it to be so reliable that I used cpio, instead of a dump utility, to back up Unix boxes. It never failed. In the past, I found that tar had filename length limitation that was shorter than what the OS permitted (80 characters iirc -- that's filename, not path). This happened when I worked in a development environment that used Rogue Wave tools. During software builds, files would be generated with ridiculously long names, and tar could not handle these. Time has passed since the days I had to backup Unix servers, but iirc cpio could correctly handle all types of special files (devices, etc.), and tar could not (as I said, iirc). If you are just experimenting, there is another utility called pax, which is latin for peace, the idea being that it will bring peace to the Tar Wars where tar2d2 is always fighting c3pio. I get the impression that neither group was willing to abandon its favorite utility and adopt pax, so the fight goes on. -Original Message- Well for this you can use cpio command in Unix for copying files to Tape. Another option is using ufsdump commnand . We have UnixWare 7.1 and I want to take backup of Database files (Physical files) to my tape. I did use tar command: tar c8v1 /home/oradata It's working properly but the problem is: tar can't handle large files(larger than 2GB). The total size of the DB files under /home/oradata more than 2GB. So the result I'll get some of those files not all. Could any body in the list give me the alternative command of tar that can handle backup of large files or any other solution... because I want to schedule this process. Your help will be appreciated. Regards, ashraf salaymeh System Analyst(OCP Certified DBA) __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ashraf Salaymeh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: dilmohan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Hemant K Chitale My web site page is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing
Re: Oracle and Peoplesoft
I would agree with Joan - we spend lots of time refreshing databases here. We were responsible for all of the application servers, web servers, process schedulers, etc. until a technical architecture team was formed. That has helped tremendously since my team can concentrate on the Oracle side. We have a very large Peoplesoft Financials environment here (along with HR and budgets) so we have lots to keep busy with and opportunities to use additional Oracle functionality (we have a large replicated environment, use lots of partitioning, etc) . I would also recommend you at least take a PeopleTools course or one of the administration courses mentioned by Joan so you understand how Peoplesoft stores and uses metadata.As far as book recommendations the only decent book that I have is the Peoplesoft Administrator's Guide by Darrell Bilbrey which is good for someone new to Peoplesoft. We really do most of the normal functions that any DBA would do regardless of Peoplesoft. Database still has to be backed up, tuned, and maintained like any other Oracle database - I consider myself to be an Oracle/Peoplesoft DBA, not a Peoplesoft/Oracle DBA if that helps you any. You will also learn to hate PS Query if your users have ad-hoc query access.:-) John Dailey Oracle DBA ING Americas - Application Services Atlanta, GA Joan Hsieh joan.hsieh@tuftsTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] .educc: (bcc: John Dailey/NAC/ING-FSI-NA) Sent by: Subject: Re: Oracle and Peoplesoft [EMAIL PROTECTED] 12/19/2002 09:45 AM Please respond to ORACLE-L Hi Sumathy, It is not too much different from oracle peoplesoft and regular dba. Except you have to know more about peoplesoft components, peoplesoft application server, process schedular, web server,weblogic.. there are some peoplesoft courses I am highly recommend you to take, Configuration and Administration Data Management Tools and another one peoplesoft server administration on Unix/Oracle. They has a website just like metlink. you need a customer id to access it. I feel like as long as peoplesoft infrastucture setup correctly in the beginning. It save a lot of time to troubleshoot later. As a oracle/peoplesoft dba, you have to constantly deal with upgrade poeplesoft tools, application, oracle. so clone the production database is major thing to do. we are constantly refresh testing databases from production. so automate those scripts are very helpful. Joan Panicker, Thankam S. wrote: How different is an Oracle Peoplesoft database from a regular database? Or in other words what all extra tasks does an Oracle Peoplesoft DBA do? How easy/difficult is it for a an Oracle DBA to transition into a Peoplesoft environment? Are there any good books/ websites on this subject? I would highly appreciate your comments and suggestions. TIA Sumathy Thankam -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Panicker, Thankam S. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT
Re: Footprint of 9i
Oracle 9.2.0.1 on NT: Demo files 80MB. Starter databases - 300MB Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, December 19, 2002 5:09 PM -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Bob Metelsky Sent: Thursday, December 19, 2002 13:49 To: Multiple recipients of list ORACLE-L Subject: Footprint of 9i All I'm about to consider rolling out 9i here and I'm wondering what type of footprint most people are seeing. In other words how large of an install is a database administrators (enterprise edition)? I've installed 9i at home on WINNT server, Win XP Pro and Suse Linux 8 all were about 2G. I also noticed that even if I tried to remove some components I did not think I needed that the installation size/footprint was not really affected Also a worthwhile note is that my current (enterprise edition) install of 8 17 on win2k server is about 1G This issue is we all run the same size drives here and really cant afford to loose 2G 1G maybe So is it true that overall installing the Enterprise edition of 9i that one could not expect to be much below 2G?? If not, we may have to add a drive for the dba's which is not going to go over big. thanks Bob Bob, No surprises, you're not alone. The easiest 400MB to 500MB to remove are the templates and demo files for the starter instances and schemas. Try deleting %ORACLE_HOME%\assistants\dbca\templates\* to free up 300MB (these are the 'OLTP' and 'Data warehouse' templates used by the dbassist tool - if you don't use them for creating instances, get rid of them), and %ORACLE_HOME%\demo\schema\* to free up 100MB of the scripts used to create the sample schemas - again if you don't use them. There might be more that can be removed ... doco and the like ... but that's a start. Ciao Fuzzy :-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: 9i / 9iRAC : Segment_Space_Management AUTO, with LOB
We were the other way around in our testing lately:-) We turned on auto space management to remove the contention. Afterwards-we removed quite a bit of header block/free list contention.. anyway, more tests to follow -Original Message-From: VIVEK_SHARMA [mailto:[EMAIL PROTECTED]]Sent: Thursday, December 19, 2002 10:09 AMTo: Multiple recipients of list ORACLE-LSubject: RE: 9i / 9iRAC : Segment_Space_Management AUTO, with LOB As part of a RAC benchmark with 9.2 we had faced severe LOCKING on setting segment space management AUTO had to REMOVE it HTH -Original Message-From: Hemant K Chitale [mailto:[EMAIL PROTECTED]]Sent: Sunday, December 15, 2002 8:09 AMTo: Multiple recipients of list ORACLE-LSubject: RE: 9i / 9iRAC : Segment_Space_Management AUTO, with LOBIn the 9i SQL Reference Guide Release 2 9.2,under "CREATE TABLESPACE", "segment_management_clause"Restrictions on the AUTO clause:·You can specify this clause only for permanent, locally managed tablespace. ·You cannot specify this clause for the SYSTEM tablespace. In the 9i Application Developer's Guide - Large Objects (LOBs) Release 2 9.2,the chapter "What's New with Large Objects (LOBs) ?", under"LOB Features Introduced with Oracle 9i, Release 2 (9.2)" ,under "Removed Restrictions" :Locally managed tablespaces restriction removed You can now create LOB columns in locally managed tablespaces.Also, in the 9iRelease2 9.2.0 Administrator's Guide,Chapter 11 "Managing Tablespaces", there is no restriction on LOBsfor Segment_Space_Management AUTO. [here, too, there's a lineindicating Segment_Space_Management AUTO is preferred for RACenvironments]Specifying Segment Space Management in Locally Managed TablespacesWhen you create a locally managed tablespace using the CREATE TABLESPACE statement, the SEGMENT SPACE MANAGEMENT clause allows you to specify how free and used space within a segment is to be managed. Your choices are:·MANUAL Specifying MANUAL tells Oracle that you want to use free lists for managing free space within segments. Free lists are lists of data blocks that have space available for inserting rows. This form of managing space within segments is called manual segment-space management because of the need to specify and tune the PCTUSED, FREELISTS, and FREELISTS GROUPS storage parameters for schema objects created in the tablespace. MANUAL is the default. ·AUTO This keyword tells Oracle that you want to use bitmaps to manage the free space within segments. A bitmap, in this case, is a map that describes the status of each data block within a segment with respect to the amount of space in the block available for inserting rows. As more or less space becomes available in a data block, its new state is reflected in the bitmap. Bitmaps allow Oracle to manage free space more automatically, and thus, this form of space management is called automatic segment-space management.Automatic segment-space management is a simpler and more efficient way of managing space within a segment. It completely eliminates any need to specify and tune the PCTUSED, FREELISTS, and FREELISTS GROUPS storage parameters for schema objects created in the tablespace. If such attributes should be specified, they are ignored.Automatic segment-space management delivers better space utilization than manual segment-space management, and it is self tuning in that it scales with increasing the number of users, as well as instances. For a Real Application Clusters environment, automatic segment-space management allows for a dynamic affinity of space to instances, thus avoiding the hard partitioning of space inherent with using free list groups.For many standard workloads, application performance when using automatic segment space management is better than the performance of a well tuned application using manual segment-space management.Bottomline : Either it was a bug or a restriction, it was not possible in 9.0.1 and supposed to be possible in 9.2.0 --- definitelyworks in 9.2.0.2Why do you say "In a single instance environment unless you are doing something out of the ordinary, use of the clause will probably be detrimental. " ?HemantAt 03:03 PM 14-12-02 -0800, you wrote: Was the prohibitition on placing LOB's into tablespaces with automatic segment space management only a bug. I ask because the description of "auto" segment space management includes the following restrictionsRestrictions on AUTO: * You can specify this clause only for permanent, locally managed tablespace. * You cannot specify this clause for the SYSTEM tablespace.* You cannot
Re: Restoring DB from specific RMAN backup set.
As long as you haven't opened the database with resetlogs between the time of the backup you want and the present you can just restore it and recover, using backup controlfile, until cancel. If you have opened it with resetlogs, you will have to change the incarnation of the database, Consult the documentation and if that doesn't help, open a TAR,' HTH, Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, December 19, 2002 10:39 AM How can I restore a database from a specific RMAN backup set? We have a database running in no archive log mode that is backed up with RMAN. There is an RMAN catalog DB also. If I look at the backup summary I see: List of Database Incarnations DB Key Inc Key DB Name DB IDCUR Reset SCN Reset Time --- --- --- -- -- 37 38 DB2 1600772452 NO 1 15-NOV-02 37 256 DB2 1600772452 NO 259591 23-NOV-02 37 627 DB2 1600772452 NO 792890 11-DEC-02 37 654 DB2 1600772452 NO 792890 11-DEC-02 37 712 DB2 1600772452 NO 792890 11-DEC-02 37 680 DB2 1600772452 NO 792890 11-DEC-02 37 764 DB2 1600772452 NO 823456 11-DEC-02 37 816 DB2 1600772452 YES 823456 18-DEC-02 37 893 DB2 1600772452 NO 823456 19-DEC-02 The backup summary list looks like: List of Backups === Key TY LV S Device Type Completion Time #Pieces #Copies Tag --- -- -- - --- --- --- --- --- 47 B F A DISK15-NOV-02 1 1 63 B F A DISK15-NOV-02 1 1 WORKFLOW_AND_PORTAL 306 B F A DISK23-NOV-02 1 1 314 B F A DISK23-NOV-02 1 1 404 B F A DISK26-NOV-02 1 1 FULL_BACKUP_9014_PATCH 413 B F A DISK26-NOV-02 1 1 729 B F A DISK11-DEC-02 1 1 FULL_DB_INSTALLED 749 B F A DISK11-DEC-02 1 1 791 B F A DISK18-DEC-02 1 1 WF_TESTING 811 B F A DISK18-DEC-02 1 1 867 B F A DISK19-DEC-02 1 1 SW_MIGRATION 888 B F A DISK19-DEC-02 1 1 I've tried resetting the database to incarnation 816, but when I restore the control file and data files from that it is not what I think it should be. I end up with FULL_DB_INSTALLED. I can restore the control file I want from the auto backup file. How can I then tell RMAN to restore the data files associated with either backup set 791 (tag=WF_TESTING)? Thanks. -- Paul -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Paul Heely INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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).
kinda OT: veritas netbackup
RESEND: never saw it get posted: Can we force veritas netbackup (HPUX) to NOT backup open files? Here is the problem: while arch process is writing out archive logs, the netbackup script that backs up the arch directory will write a partially written log to tape, we're trying to avoid that. is our only alternative determine(out of data dictionary) how many log groups we have and assuming 3, that if we take the max log seq# minus the numebr of groups we have, gives us the oldest log that we can be sure is complete? ie: current log is 543, we have 3 log groups, 543-3 = 540, since oracle wouldnt start overwriting # 540 until it was successfully archived, that we can back up, up thru log seq# 540 and can be sure # 540 is complete? thanks, joe
RE: Methods to get DDL
I did not work on the new version, so I have no comments on what is or is not in there -- I don't know how much was removed, added or changed. --- Bob Metelsky [EMAIL PROTECTED] wrote: The original is SQL PL/SQL Annotated Archives Ahh yes... but the new version is/ seems to be Oracle9i Instant PL/SQL Scripts Book Description From the authorized Oracle Press comes a complete guide to developing PL/SQL solutions quickly and easily. Inside, you'll find ready-to-run code and expert techniques with in-depth explanations that will help you understand the behaviors created, and even extend usage through customization. I bought mine yesterday used for $15 I think that's a pretty good deal http://www.iewww.com/content/0072132183 bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- 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). __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Spool file output
OK. Is there a question or comment here someplace? -Original Message- Sent: Thursday, December 19, 2002 10:40 AM To: Multiple recipients of list ORACLE-L This is what i am doing: 1- login to sqlplus on solaris 2- spool temp.out 3- run an sql file useing: @myfile.sql Sql file contains this: set termout off set head off set echo off set feedback off set pagesize 0 4- spool off __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: OraCop INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Spool file behavior on Solaris
The solution is: -Original Message- Sent: Thursday, December 19, 2002 8:34 AM To: Multiple recipients of list ORACLE-L hello, This is what i am doing: __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: OraCop INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Fink, Dan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
FW: HELP NEEDED IN FORMS6I OR FORMS9I DEVELOPMENT - WEB
-Original Message- From: Paulo Gomes Sent: quinta-feira, 19 de Dezembro de 2002 12:50 To: '[EMAIL PROTECTED]'; '[EMAIL PROTECTED]' Subject: HELP NEEDED IN FORMS6I OR FORMS9I DEVELOPMENT - WEB Hi people Now it's my turn, i really need some help here. I've got some forms developed in forms 6i (even some in forms 4.5) that are working fine in client/server mode. But ... if i switch to web mode i will lose loads of funtionalities here. The real problem is: How do i put the local devices like printers, scanners, fingerprint capture devices, Bar Code capture devices and like working in a forms web application??? It must be a way. Thanks in advance. Paulo Gomes -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Paulo Gomes INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: read only tablespaces
What is obvious here, is that you don't do your homework (RTFMing) before asking questions. That's why you get, what you asked for :-) Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, December 19, 2002 10:29 AM Is this group suppose to be helpful or for some people just to show their ego? I do not know something you think is obvious, but I also know something you might not know, which to me is quite easy. It is a learning process, isn't it? One thing I notice is, for some really learned person, they are really nice and patient. For those people who is mean, are you really that knowledgable? -Original Message- Sent: Thursday, December 19, 2002 9:55 AM To: Multiple recipients of list ORACLE-L Ah, once again, we are deeply indebted to Jared for his 'perls' of wisdom... -Original Message- Sent: Wednesday, December 18, 2002 4:29 PM To: Multiple recipients of list ORACLE-L Or the Oxford Encyclopedic (sp?) Dictionary of the English Language should you wish a truly authoritative source. ;) Fink, Dan [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/18/2002 02:14 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: read only tablespaces I would suggest Funk Wagnells or Webster's New College Edition -Original Message- Sent: Wednesday, December 18, 2002 2:34 PM To: Multiple recipients of list ORACLE-L which dictionary should I check to see whether a tablespace is read-only or read-write? thanks for your help. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Fink, Dan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Shao, Chunning INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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: Spool file behavior on Solaris
and the result is...? reply of course only if it pertains to oracle :-) Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, December 19, 2002 10:34 AM hello, This is what i am doing: __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: OraCop INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: 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: Footprint of 9i
My issue is with memory requirements... try running iAS 9i R2 on 700M of RAM, with a local db. Ugh! Pat. -Original Message- Sent: Thursday, December 19, 2002 12:25 PM To: Multiple recipients of list ORACLE-L Oracle 9.2.0.1 on NT: Demo files 80MB. Starter databases - 300MB Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, December 19, 2002 5:09 PM -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Bob Metelsky Sent: Thursday, December 19, 2002 13:49 To: Multiple recipients of list ORACLE-L Subject: Footprint of 9i All I'm about to consider rolling out 9i here and I'm wondering what type of footprint most people are seeing. In other words how large of an install is a database administrators (enterprise edition)? I've installed 9i at home on WINNT server, Win XP Pro and Suse Linux 8 all were about 2G. I also noticed that even if I tried to remove some components I did not think I needed that the installation size/footprint was not really affected Also a worthwhile note is that my current (enterprise edition) install of 8 17 on win2k server is about 1G This issue is we all run the same size drives here and really cant afford to loose 2G 1G maybe So is it true that overall installing the Enterprise edition of 9i that one could not expect to be much below 2G?? If not, we may have to add a drive for the dba's which is not going to go over big. thanks Bob Bob, No surprises, you're not alone. The easiest 400MB to 500MB to remove are the templates and demo files for the starter instances and schemas. Try deleting %ORACLE_HOME%\assistants\dbca\templates\* to free up 300MB (these are the 'OLTP' and 'Data warehouse' templates used by the dbassist tool - if you don't use them for creating instances, get rid of them), and %ORACLE_HOME%\demo\schema\* to free up 100MB of the scripts used to create the sample schemas - again if you don't use them. There might be more that can be removed ... doco and the like ... but that's a start. Ciao Fuzzy :-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Footprint of 9i
I'm not sure what type of systems you're running, but I haven't seen drives smaller than 18G much lately. Perhaps its time to upgrade to a SAN anyway? :-) 1G isn't all that much to ask (especially if your production systems are running in ARCHIVELOG mode), but your comments prove that point that disk is cheap, until you try to justify the purchase of more... Yes, that's rite its probaly viewed as frivolous ;-). Although basically any change in software that mandates a hardware upgrade and propogated to a half a dozen users is a red flag for magement, afterall they are trying to think ahead ;-) Our drives are about 20G and of course most of us have filled that over time... Im probably looking for file lists that can be removed as has been recommended. Or how other people have handled a similar situation. Many thanks bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- 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: Restoring DB from specific RMAN backup set.
Paul - Can you specify what you mean by no archive log mode and backed up with RMAN? Was the database open? Which Oracle version? Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, December 19, 2002 9:40 AM To: Multiple recipients of list ORACLE-L How can I restore a database from a specific RMAN backup set? We have a database running in no archive log mode that is backed up with RMAN. There is an RMAN catalog DB also. If I look at the backup summary I see: List of Database Incarnations DB Key Inc Key DB Name DB IDCUR Reset SCN Reset Time --- --- --- -- -- 37 38 DB2 1600772452 NO 1 15-NOV-02 37 256 DB2 1600772452 NO 259591 23-NOV-02 37 627 DB2 1600772452 NO 792890 11-DEC-02 37 654 DB2 1600772452 NO 792890 11-DEC-02 37 712 DB2 1600772452 NO 792890 11-DEC-02 37 680 DB2 1600772452 NO 792890 11-DEC-02 37 764 DB2 1600772452 NO 823456 11-DEC-02 37 816 DB2 1600772452 YES 823456 18-DEC-02 37 893 DB2 1600772452 NO 823456 19-DEC-02 The backup summary list looks like: List of Backups === Key TY LV S Device Type Completion Time #Pieces #Copies Tag --- -- -- - --- --- --- --- --- 47 B F A DISK15-NOV-02 1 1 63 B F A DISK15-NOV-02 1 1 WORKFLOW_AND_PORTAL 306 B F A DISK23-NOV-02 1 1 314 B F A DISK23-NOV-02 1 1 404 B F A DISK26-NOV-02 1 1 FULL_BACKUP_9014_PATCH 413 B F A DISK26-NOV-02 1 1 729 B F A DISK11-DEC-02 1 1 FULL_DB_INSTALLED 749 B F A DISK11-DEC-02 1 1 791 B F A DISK18-DEC-02 1 1 WF_TESTING 811 B F A DISK18-DEC-02 1 1 867 B F A DISK19-DEC-02 1 1 SW_MIGRATION 888 B F A DISK19-DEC-02 1 1 I've tried resetting the database to incarnation 816, but when I restore the control file and data files from that it is not what I think it should be. I end up with FULL_DB_INSTALLED. I can restore the control file I want from the auto backup file. How can I then tell RMAN to restore the data files associated with either backup set 791 (tag=WF_TESTING)? Thanks. -- Paul -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Paul Heely INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: kinda OT: veritas netbackup
Hello Joe Just schedule another backup of the archive logs 1 hour (or 5 minutes) after the regular backup. NetBackup will take a second (complete) backup of the archive file and when you want to restore , restore the last copy of the files. Yechiel AdarMehish - Original Message - From: JOE TESTA To: Multiple recipients of list ORACLE-L Sent: Thursday, December 19, 2002 5:50 PM Subject: kinda OT: veritas netbackup RESEND: never saw it get posted: Can we force veritas netbackup (HPUX) to NOT backup open files? Here is the problem: while arch process is writing out archive logs, the netbackup script that backs up the arch directory will write a partially written log to tape, we're trying to avoid that. is our only alternative determine(out of data dictionary) how many log groups we have and assuming 3, that if we take the max log seq# minus the numebr of groups we have, gives us the oldest log that we can be sure is complete? ie: current log is 543, we have 3 log groups, 543-3 = 540, since oracle wouldnt start overwriting # 540 until it was successfully archived, that we can back up, up thru log seq# 540 and can be sure # 540 is complete? thanks, joe
RE: strange error on DBMS_STATS
this is being run in sqlplus as execute dbms_stats.gather_schema_stats If I didn't run it (on another schema) within the same sql script, I'd think it was that I didn't have privs on dbms_stats. I'll keep looking --- Jesse, Rich [EMAIL PROTECTED] wrote: Yes, but it turned out to be privs (or lack thereof) to run the stats or associated queries in a procedure, rather than privs to do the analyze itself. Do you have auditing turned on? That's usually the first place I check to see what objects changed since the last time it worked. GL! Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- From: Rachel Carmichael [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 19, 2002 10:39 AM To: Multiple recipients of list ORACLE-L Subject: strange error on DBMS_STATS I'm running dbms_stats.gather_schema_stats, the account running it is NOT the schema owner, but DOES have the analyze any privilege and has read/write access to all the tables in the schema. We are not trying to gather stats into our own tables, just want the stats refreshed after the (massive) loads into the DW tables. This has been running fine, then all of a sudden last night we started getting ORA-1031 (insufficient privileges) errors. Now, according to the docs: ORA-01031 insufficient privileges Cause: An attempt was made to change the current username or password without the appropriate privilege. This error also occurs if attempting to install a database without the necessary operating system privileges. We are not changing passwords, so I am presuming that this involves (somehow) a change of username. According to the package header, it will throw an ORA-2 if there are insufficent privileges. We rebuilt an index yesterday but did NOT change or add any table. I had this happen once before, on a different database, never solved it, but substituted dbms_utility.analyze_schema which worked. I can do the same thing this time but I'd prefer to solve it. Anyone ever see anything like this before? oh yeah 9.2.0.1 on Solaris 8 Rachel __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Simple Query for Week number
Dan, Thanks. The W works just fine. What I was looking for. Phew!!! I almost wrote a PL/SQL for this ; Fink, Dan Dan.Fink@mdxTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] .comcc: Sent by: Subject: RE: Simple Query for Week number root@fatcity. com December 19, 2002 12:05 PM Please respond to ORACLE-L Raj, How do you define week number? If a month starts in the middle of the week, is that week #1 or must it be the first full week? If the format mask 'W' is adequate, use 1 select sysdate, to_char(sysdate, 'W'), 2 '01-DEC-02', to_char(to_date('01-DEC-02'), 'W'), 3 '30-NOV-02', to_char(to_date('30-NOV-02'), 'W') 4* from dual SQL / SYSDATE T '01-DEC-0 T '30-NOV-0 T - - - - - - 19-DEC-02 3 01-DEC-02 1 30-NOV-02 5 -Original Message- Sent: Thursday, December 19, 2002 8:54 AM To: Multiple recipients of list ORACLE-L Hey Folks, Looking for the simplest of queries to find the week number, given a date. For example, 19th December 2002 falls in the 3rd week, whereas 19th November, 2002, falls in the 4th week. Thanks Raj -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Fink, Dan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: strange error on DBMS_STATS
Title: RE: strange error on DBMS_STATS Probably wrong question ... but was rebuilt index still owned by schema owner? Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! *This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*1
RE: Simple Query for Week number
Raj, How do you define week number? If a month starts in the middle of the week, is that week #1 or must it be the first full week? If the format mask 'W' is adequate, use 1 select sysdate, to_char(sysdate, 'W'), 2 '01-DEC-02', to_char(to_date('01-DEC-02'), 'W'), 3 '30-NOV-02', to_char(to_date('30-NOV-02'), 'W') 4* from dual SQL / SYSDATE T '01-DEC-0 T '30-NOV-0 T - - - - - - 19-DEC-02 3 01-DEC-02 1 30-NOV-02 5 -Original Message- Sent: Thursday, December 19, 2002 8:54 AM To: Multiple recipients of list ORACLE-L Hey Folks, Looking for the simplest of queries to find the week number, given a date. For example, 19th December 2002 falls in the 3rd week, whereas 19th November, 2002, falls in the 4th week. Thanks Raj -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Fink, Dan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: kinda OT: veritas netbackup
Here's an idea. First of all, I assume you are using plain vanilla netbackup, no RMAN. That's what it sounds like. Add the arch directory to the list of directories to exclude. Create a SQL script to create a list of files in the arch directory to backup. I won't supply details, cuz I know you're perfectly capable of doing it yourself. :) Modify or create the bpend_notify script for the correct backup policy, then use the bpbackup command with the generated list of files to backup the archive logs. Use bparchive if you want the files deleted following a successful backup. HTH Jared JOE TESTA [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/19/2002 07:50 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:kinda OT: veritas netbackup RESEND: never saw it get posted: Can we force veritas netbackup (HPUX) to NOT backup open files? Here is the problem: while arch process is writing out archive logs, the netbackup script that backs up the arch directory will write a partially written log to tape, we're trying to avoid that. is our only alternative determine(out of data dictionary) how many log groups we have and assuming 3, that if we take the max log seq# minus the numebr of groups we have, gives us the oldest log that we can be sure is complete? ie: current log is 543, we have 3 log groups, 543-3 = 540, since oracle wouldnt start overwriting # 540 until it was successfully archived, that we can back up, up thru log seq# 540 and can be sure # 540 is complete? thanks, joe -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: strange error on DBMS_STATS
...I've got this hammer called SQL Trace and just about every problem looks like a nail... Good thing is, this'll probably resolve it for you. Can you run this in the same session prior to running the GATHER_SCHEMA_STATS? alter session set max_dump_file_size = unlimited; alter session set events '10046 trace name context forever, level 12'; If you're pressed for space in USER_DUMP_DEST, you might want to run the trace at level 4 instead of level 12, to dump the bind variable values only... This will generate a trace file which, embedded within it, should contain some indication of exactly where the ORA-01031 error is being thrown. Look within the raw .trc (near the bottom of the file) for the phrase err= (it should say err=1031 or err=-1031, I forget which). Note the cursor# for that line and then search upwards for the phrase PARSING IN CURSOR #nnn to see the SQL text. Then, from the site of the error message, search again upwards for the phrase BIND #nnn to find the dump of bind-variable values for the most recent call. Seeing as how the trace will dump all recursive SQL called in GATHER_SCHEMA_STATS as well as their bind-variable values, we might be able to pin-point exactly which item it is failing upon... I'm running dbms_stats.gather_schema_stats, the account running it is NOT the schema owner, but DOES have the analyze any privilege and has read/write access to all the tables in the schema. We are not trying to gather stats into our own tables, just want the stats refreshed after the (massive) loads into the DW tables. This has been running fine, then all of a sudden last night we started getting ORA-1031 (insufficient privileges) errors. Now, according to the docs: ORA-01031 insufficient privileges Cause: An attempt was made to change the current username or password without the appropriate privilege. This error also occurs if attempting to install a database without the necessary operating system privileges. We are not changing passwords, so I am presuming that this involves (somehow) a change of username. According to the package header, it will throw an ORA-2 if there are insufficent privileges. We rebuilt an index yesterday but did NOT change or add any table. I had this happen once before, on a different database, never solved it, but substituted dbms_utility.analyze_schema which worked. I can do the same thing this time but I'd prefer to solve it. Anyone ever see anything like this before? oh yeah 9.2.0.1 on Solaris 8 Rachel __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services -- --- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- 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).
FW: kinda OT: veritas netbackup
Hi, I am the other guy involved in this issue of Not backing up OPEN files on Unix with Netbackup. We are keeping 2 days of logs on disk up to 60gig of logs.. The tape backup people are not happy about us backing this up often to provide extra redundancy especially as we implement this for every oracle system we have. Yes, we have considered running other backups but we really wanted to see if Veritas could close this logic hole for us because we have a directive to keep our solution simple and secure. I know on windows its no problem and veritas squawks when the files are in use... Anyone know if the "only BACKUP close files" feature exists in Unix. Brian SpearsSr. Oracle Database Administrator OCP -Original Message-From: Yechiel Adar [mailto:[EMAIL PROTECTED]]Sent: Thursday, December 19, 2002 11:50 AMTo: Multiple recipients of list ORACLE-LSubject: Re: kinda OT: veritas netbackup Hello Joe Just schedule another backup of the archive logs 1 hour (or 5 minutes) after the regular backup. NetBackup will take a second (complete) backup of the archive file and when you want to restore , restore the last copy of the files. Yechiel AdarMehish - Original Message - From: JOE TESTA To: Multiple recipients of list ORACLE-L Sent: Thursday, December 19, 2002 5:50 PM Subject: kinda OT: veritas netbackup RESEND: never saw it get posted: Can we force veritas netbackup (HPUX) to NOT backup open files? Here is the problem: while arch process is writing out archive logs, the netbackup script that backs up the arch directory will write a partially written log to tape, we're trying to avoid that. is our only alternative determine(out of data dictionary) how many log groups we have and assuming 3, that if we take the max log seq# minus the numebr of groups we have, gives us the oldest log that we can be sure is complete? ie: current log is 543, we have 3 log groups, 543-3 = 540, since oracle wouldnt start overwriting # 540 until it was successfully archived, that we can back up, up thru log seq# 540 and can be sure # 540 is complete? thanks, joe
RE: Backup DB files to the Tape
Here's a nickel, kid. Go buy yourself a better computer. -Original Message- Sent: Thursday, December 19, 2002 10:15 AM To: Multiple recipients of list ORACLE-L It's one of those Unix things. It goes with the beard and the bad-fitting trousers held up by suspenders. -Original Message- From: Hemant K Chitale [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 19, 2002 9:21 AM To: Multiple recipients of list ORACLE-L Subject: RE: Backup DB files to the Tape Stephen, The para. about pax vis-a-vis tar versus cpio was interesting ! I never knew that -- though the names do make sense now ! Hemant At 06:39 AM 18-12-02 -0800, you wrote: I will add a vote for cpio. I have found it to be so reliable that I used cpio, instead of a dump utility, to back up Unix boxes. It never failed. In the past, I found that tar had filename length limitation that was shorter than what the OS permitted (80 characters iirc -- that's filename, not path). This happened when I worked in a development environment that used Rogue Wave tools. During software builds, files would be generated with ridiculously long names, and tar could not handle these. Time has passed since the days I had to backup Unix servers, but iirc cpio could correctly handle all types of special files (devices, etc.), and tar could not (as I said, iirc). If you are just experimenting, there is another utility called pax, which is latin for peace, the idea being that it will bring peace to the Tar Wars where tar2d2 is always fighting c3pio. I get the impression that neither group was willing to abandon its favorite utility and adopt pax, so the fight goes on. -Original Message- Well for this you can use cpio command in Unix for copying files to Tape. Another option is using ufsdump commnand . We have UnixWare 7.1 and I want to take backup of Database files (Physical files) to my tape. I did use tar command: tar c8v1 /home/oradata It's working properly but the problem is: tar can't handle large files(larger than 2GB). The total size of the DB files under /home/oradata more than 2GB. So the result I'll get some of those files not all. Could any body in the list give me the alternative command of tar that can handle backup of large files or any other solution... because I want to schedule this process. Your help will be appreciated. Regards, ashraf salaymeh System Analyst(OCP Certified DBA) __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ashraf Salaymeh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: dilmohan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Hemant K Chitale My web site page is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net
RE: Simple Query for Week number
select to_char(sysdate, 'W') from dual; Paul -Original Message- Sent: Thursday, December 19, 2002 10:54 AM To: Multiple recipients of list ORACLE-L Hey Folks, Looking for the simplest of queries to find the week number, given a date. For example, 19th December 2002 falls in the 3rd week, whereas 19th November, 2002, falls in the 4th week. Thanks Raj -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Spool file behavior on Solaris
Geez, Not only people come to list expect an answer and can't take jokes, now they expect us to read their minds too. Sigh -Original Message- Sent: Thursday, December 19, 2002 10:34 AM To: Multiple recipients of list ORACLE-L hello, This is what i am doing: __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: OraCop INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Richard Ji INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: strange error on DBMS_STATS
Yes, but it turned out to be privs (or lack thereof) to run the stats or associated queries in a procedure, rather than privs to do the analyze itself. Do you have auditing turned on? That's usually the first place I check to see what objects changed since the last time it worked. GL! Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- From: Rachel Carmichael [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 19, 2002 10:39 AM To: Multiple recipients of list ORACLE-L Subject: strange error on DBMS_STATS I'm running dbms_stats.gather_schema_stats, the account running it is NOT the schema owner, but DOES have the analyze any privilege and has read/write access to all the tables in the schema. We are not trying to gather stats into our own tables, just want the stats refreshed after the (massive) loads into the DW tables. This has been running fine, then all of a sudden last night we started getting ORA-1031 (insufficient privileges) errors. Now, according to the docs: ORA-01031 insufficient privileges Cause: An attempt was made to change the current username or password without the appropriate privilege. This error also occurs if attempting to install a database without the necessary operating system privileges. We are not changing passwords, so I am presuming that this involves (somehow) a change of username. According to the package header, it will throw an ORA-2 if there are insufficent privileges. We rebuilt an index yesterday but did NOT change or add any table. I had this happen once before, on a different database, never solved it, but substituted dbms_utility.analyze_schema which worked. I can do the same thing this time but I'd prefer to solve it. Anyone ever see anything like this before? oh yeah 9.2.0.1 on Solaris 8 Rachel -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: HELP NEEDED IN FORMS6I OR FORMS9I DEVELOPMENT - WEB
Title: RE: HELP NEEDED IN FORMS6I OR FORMS9I DEVELOPMENT - WEB if you have activex controls that you want to replace, there is 'Java Importer' and in Forms 9i you can use PJCs also. Read through Forms information at http://technet.oracle.com Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message- From: Paulo Gomes [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 19, 2002 12:01 PM To: Multiple recipients of list ORACLE-L Subject: FW: HELP NEEDED IN FORMS6I OR FORMS9I DEVELOPMENT - WEB -Original Message- From: Paulo Gomes Sent: quinta-feira, 19 de Dezembro de 2002 12:50 To: '[EMAIL PROTECTED]'; '[EMAIL PROTECTED]' Subject: HELP NEEDED IN FORMS6I OR FORMS9I DEVELOPMENT - WEB Hi people Now it's my turn, i really need some help here. I've got some forms developed in forms 6i (even some in forms 4.5) that are working fine in client/server mode. But ... if i switch to web mode i will lose loads of funtionalities here. The real problem is: How do i put the local devices like printers, scanners, fingerprint capture devices, Bar Code capture devices and like working in a forms web application??? It must be a way. Thanks in advance. Paulo Gomes -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Paulo Gomes INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*1
Giving back Perl
Title: Giving back Perl Hello everyone - I've been trying to write more Perl lately and after showing my Perl mentor some of the stuff I had written over the last couple of weeks the first thing he said was why don't you give back to the community. So I figure if I offer up my latest creation I could 1. give back and maybe help a person or two and 2. receive comments on my coding. My coding style is rather simplistic and I would appreciate any comments about what I'm doing wrong/how something could be done differently (TMTOWTDI), etc. My environment is W2K sp2/8.1.7.2. I slapped together a script that fires backup controlfile to trace (including the stored proc) and ftp's it off to another server. If anyone is interested in seeing it please email me directly. Lisa Koivu Oracle Diaper Administrator Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA 33063
RE: read only tablespaces
Come on now, these guys are just joking. I don't see any egos or mean replies. You asked which dictionary instead of which data dictionary view. It is a learning process and we should all have a little fun. :) -Original Message- Sent: Thursday, December 19, 2002 10:30 AM To: Multiple recipients of list ORACLE-L Is this group suppose to be helpful or for some people just to show their ego? I do not know something you think is obvious, but I also know something you might not know, which to me is quite easy. It is a learning process, isn't it? One thing I notice is, for some really learned person, they are really nice and patient. For those people who is mean, are you really that knowledgable? -Original Message- Sent: Thursday, December 19, 2002 9:55 AM To: Multiple recipients of list ORACLE-L Ah, once again, we are deeply indebted to Jared for his 'perls' of wisdom... -Original Message- Sent: Wednesday, December 18, 2002 4:29 PM To: Multiple recipients of list ORACLE-L Or the Oxford Encyclopedic (sp?) Dictionary of the English Language should you wish a truly authoritative source. ;) Fink, Dan [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/18/2002 02:14 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: read only tablespaces I would suggest Funk Wagnells or Webster's New College Edition -Original Message- Sent: Wednesday, December 18, 2002 2:34 PM To: Multiple recipients of list ORACLE-L which dictionary should I check to see whether a tablespace is read-only or read-write? thanks for your help. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Fink, Dan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Shao, Chunning INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Richard Ji INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
FW: kinda OT: veritas netbackup
Yes, we have coded it to do thisand it works but for many reasons.. including simplicitywe want to avoid thissolution for theentire12B enterprise solution... when it confuses others, and is much more vulnerable for screwups with Mount point management and recovery. Brian Spears -Original Message-From: Kevin Lange [mailto:[EMAIL PROTECTED]]Sent: Thursday, December 19, 2002 11:15 AMTo: Multiple recipients of list ORACLE-LSubject: RE: kinda OT: veritas netbackup How about running a script just before the backup that 1) Reads the current log number. 2) Forces a log switch. 3) Copies the logs to a seperate directory. 4) Backups up that seperate directory Leave the archive directory alone. Do not back it up. -Original Message-From: JOE TESTA [mailto:[EMAIL PROTECTED]]Sent: Thursday, December 19, 2002 9:50 AMTo: Multiple recipients of list ORACLE-LSubject: kinda OT: veritas netbackup RESEND: never saw it get posted: Can we force veritas netbackup (HPUX) to NOT backup open files? Here is the problem: while arch process is writing out archive logs, the netbackup script that backs up the arch directory will write a partially written log to tape, we're trying to avoid that. is our only alternative determine(out of data dictionary) how many log groups we have and assuming 3, that if we take the max log seq# minus the numebr of groups we have, gives us the oldest log that we can be sure is complete? ie: current log is 543, we have 3 log groups, 543-3 = 540, since oracle wouldnt start overwriting # 540 until it was successfully archived, that we can back up, up thru log seq# 540 and can be sure # 540 is complete? thanks, joe
RE: Restoring DB from specific RMAN backup set.
Database is 9.0.1.4 running on Win2K. The database called DB2 is not running in archivelog mode. The database is being backed up using RMAN: I.e. set ORACLE_SID=DB2 rman target / catalog rman@otherdb shutdown immediate; startup mount; backup database format=f:\oracle_backup\%d\%d_%U tag full_backup; alter database open; I figured out what the problem was. After I restored the controlfile from the autobackup file I was not mounting the database before doing a database restore. Thanks. -- Paul -Original Message- WILLIAMS Sent: Thursday, December 19, 2002 11:45 AM To: Multiple recipients of list ORACLE-L Paul - Can you specify what you mean by no archive log mode and backed up with RMAN? Was the database open? Which Oracle version? Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, December 19, 2002 9:40 AM To: Multiple recipients of list ORACLE-L How can I restore a database from a specific RMAN backup set? We have a database running in no archive log mode that is backed up with RMAN. There is an RMAN catalog DB also. If I look at the backup summary I see: List of Database Incarnations DB Key Inc Key DB Name DB IDCUR Reset SCN Reset Time --- --- --- -- -- 37 38 DB2 1600772452 NO 1 15-NOV-02 37 256 DB2 1600772452 NO 259591 23-NOV-02 37 627 DB2 1600772452 NO 792890 11-DEC-02 37 654 DB2 1600772452 NO 792890 11-DEC-02 37 712 DB2 1600772452 NO 792890 11-DEC-02 37 680 DB2 1600772452 NO 792890 11-DEC-02 37 764 DB2 1600772452 NO 823456 11-DEC-02 37 816 DB2 1600772452 YES 823456 18-DEC-02 37 893 DB2 1600772452 NO 823456 19-DEC-02 The backup summary list looks like: List of Backups === Key TY LV S Device Type Completion Time #Pieces #Copies Tag --- -- -- - --- --- --- --- --- 47 B F A DISK15-NOV-02 1 1 63 B F A DISK15-NOV-02 1 1 WORKFLOW_AND_PORTAL 306 B F A DISK23-NOV-02 1 1 314 B F A DISK23-NOV-02 1 1 404 B F A DISK26-NOV-02 1 1 FULL_BACKUP_9014_PATCH 413 B F A DISK26-NOV-02 1 1 729 B F A DISK11-DEC-02 1 1 FULL_DB_INSTALLED 749 B F A DISK11-DEC-02 1 1 791 B F A DISK18-DEC-02 1 1 WF_TESTING 811 B F A DISK18-DEC-02 1 1 867 B F A DISK19-DEC-02 1 1 SW_MIGRATION 888 B F A DISK19-DEC-02 1 1 I've tried resetting the database to incarnation 816, but when I restore the control file and data files from that it is not what I think it should be. I end up with FULL_DB_INSTALLED. I can restore the control file I want from the auto backup file. How can I then tell RMAN to restore the data files associated with either backup set 791 (tag=WF_TESTING)? Thanks. -- Paul -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Paul Heely INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Paul Heely INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru')
Re: Spool file behavior on Solaris
42 Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, December 19, 2002 6:45 PM and the result is...? reply of course only if it pertains to oracle :-) Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, December 19, 2002 10:34 AM hello, This is what i am doing: __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: OraCop INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Igor Neyman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: read only tablespaces
Shao We operate of the principle of GIGO - Garbage In, Garbage Out. The people on this list expect you to write clear questions if you want clear answers. Sometimes a questions like yours allow us to horse around a little. All in good will and between friends. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, December 19, 2002 5:29 PM Is this group suppose to be helpful or for some people just to show their ego? I do not know something you think is obvious, but I also know something you might not know, which to me is quite easy. It is a learning process, isn't it? One thing I notice is, for some really learned person, they are really nice and patient. For those people who is mean, are you really that knowledgable? -Original Message- Sent: Thursday, December 19, 2002 9:55 AM To: Multiple recipients of list ORACLE-L Ah, once again, we are deeply indebted to Jared for his 'perls' of wisdom... -Original Message- Sent: Wednesday, December 18, 2002 4:29 PM To: Multiple recipients of list ORACLE-L Or the Oxford Encyclopedic (sp?) Dictionary of the English Language should you wish a truly authoritative source. ;) Fink, Dan [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/18/2002 02:14 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: read only tablespaces I would suggest Funk Wagnells or Webster's New College Edition -Original Message- Sent: Wednesday, December 18, 2002 2:34 PM To: Multiple recipients of list ORACLE-L which dictionary should I check to see whether a tablespace is read-only or read-write? thanks for your help. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Fink, Dan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Shao, Chunning INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Giving back Perl
I'm interested, send at your convenience. And . Oracle Diaper Administrator ... Diaper ??? As in what my 3 year old has stopped needing at night? ~brian -Original Message- Sent: Thursday, December 19, 2002 11:30 AM To: Multiple recipients of list ORACLE-L Hello everyone - I've been trying to write more Perl lately and after showing my Perl mentor some of the stuff I had written over the last couple of weeks the first thing he said was why don't you give back to the community. So I figure if I offer up my latest creation I could 1. give back and maybe help a person or two and 2. receive comments on my coding. My coding style is rather simplistic and I would appreciate any comments about what I'm doing wrong/how something could be done differently (TMTOWTDI), etc. My environment is W2K sp2/8.1.7.2. I slapped together a script that fires backup controlfile to trace (including the stored proc) and ftp's it off to another server. If anyone is interested in seeing it please email me directly. Lisa Koivu Oracle Diaper Administrator Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA 33063 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Brian Dunbar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Backup DB files to the Tape
Long live Dilbert! The scary thing around here is that the guy that most fits the description is an NT admin. He even has empty Mountain Dew cans all over his cubicle. The only thing missing are the Hostess Twinkie wrappers. -Original Message- From: Brian Dunbar [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 19, 2002 11:45 AM To: Multiple recipients of list ORACLE-L Subject: RE: Backup DB files to the Tape Here's a nickel, kid. Go buy yourself a better computer. -Original Message- Sent: Thursday, December 19, 2002 10:15 AM To: Multiple recipients of list ORACLE-L It's one of those Unix things. It goes with the beard and the bad-fitting trousers held up by suspenders. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Giving back Perl
Title: Giving back Perl Pl. send me a copy of the code. -Original Message-From: Koivu, Lisa [mailto:[EMAIL PROTECTED]]Sent: Thursday, December 19, 2002 12:30 PMTo: Multiple recipients of list ORACLE-LSubject: Giving back Perl Hello everyone - I've been trying to write more Perl lately and after showing my Perl mentor some of the stuff I had written over the last couple of weeks the first thing he said was "why don't you give back to the community". So I figure if I offer up my latest creation I could 1. give back and maybe help a person or two and 2. receive comments on my coding. My coding style is rather simplistic and I would appreciate any comments about what I'm doing wrong/how something could be done differently (TMTOWTDI), etc. My environment is W2K sp2/8.1.7.2. I slapped together a script that fires backup controlfile to trace (including the stored proc) and ftp's it off to another server. If anyone is interested in seeing it please email me directly. Lisa Koivu Oracle Diaper Administrator Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA 33063
Re: Simple Query for Week number
Check out the date 19/11/2002. format 'W' return 3 instead of 4. I wrote something to do this. It select the week day number of the current date, the week day number of the first of the month and the current week. If week day of the first of the month is higher then the current week day Then add 1 to the current week. SELECT CASE WHEN CUR_DAY FIRST_DAY THEN CUR_WEEK + 1 ELSECUR_WEEK + 0 END CASE FROM (SELECT TO_CHAR(TO_DATE('07/12/2002','DD/MM/'),'D') CUR_DAY FROM DUAL), (SELECT TO_CHAR( TO_DATE('01/' || to_char(last_day(TO_DATE ('07/12/2002','DD/MM/')),'MM/'),'DD/MM/'),'D') FIRST_DAY from dual) , (SELECT TO_CHAR(TO_DATE('07/12/2002','DD/MM/'),'W') CUR_WEEK FROM DUAL) ; Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, December 19, 2002 7:59 PM Dan, Thanks. The W works just fine. What I was looking for. Phew!!! I almost wrote a PL/SQL for this ; Fink, Dan Dan.Fink@mdxTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] .comcc: Sent by: Subject: RE: Simple Query for Week number root@fatcity. com December 19, 2002 12:05 PM Please respond to ORACLE-L Raj, How do you define week number? If a month starts in the middle of the week, is that week #1 or must it be the first full week? If the format mask 'W' is adequate, use 1 select sysdate, to_char(sysdate, 'W'), 2 '01-DEC-02', to_char(to_date('01-DEC-02'), 'W'), 3 '30-NOV-02', to_char(to_date('30-NOV-02'), 'W') 4* from dual SQL / SYSDATE T '01-DEC-0 T '30-NOV-0 T - - - - - - 19-DEC-02 3 01-DEC-02 1 30-NOV-02 5 -Original Message- Sent: Thursday, December 19, 2002 8:54 AM To: Multiple recipients of list ORACLE-L Hey Folks, Looking for the simplest of queries to find the week number, given a date. For example, 19th December 2002 falls in the 3rd week, whereas 19th November, 2002, falls in the 4th week. Thanks Raj -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Fink, Dan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Backup DB files to the Tape
Condescending Unix user! -Original Message- Sent: Thursday, December 19, 2002 12:45 PM To: Multiple recipients of list ORACLE-L Here's a nickel, kid. Go buy yourself a better computer. -Original Message- Sent: Thursday, December 19, 2002 10:15 AM To: Multiple recipients of list ORACLE-L It's one of those Unix things. It goes with the beard and the bad-fitting trousers held up by suspenders. -Original Message- From: Hemant K Chitale [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 19, 2002 9:21 AM To: Multiple recipients of list ORACLE-L Subject: RE: Backup DB files to the Tape Stephen, The para. about pax vis-a-vis tar versus cpio was interesting ! I never knew that -- though the names do make sense now ! Hemant At 06:39 AM 18-12-02 -0800, you wrote: I will add a vote for cpio. I have found it to be so reliable that I used cpio, instead of a dump utility, to back up Unix boxes. It never failed. In the past, I found that tar had filename length limitation that was shorter than what the OS permitted (80 characters iirc -- that's filename, not path). This happened when I worked in a development environment that used Rogue Wave tools. During software builds, files would be generated with ridiculously long names, and tar could not handle these. Time has passed since the days I had to backup Unix servers, but iirc cpio could correctly handle all types of special files (devices, etc.), and tar could not (as I said, iirc). If you are just experimenting, there is another utility called pax, which is latin for peace, the idea being that it will bring peace to the Tar Wars where tar2d2 is always fighting c3pio. I get the impression that neither group was willing to abandon its favorite utility and adopt pax, so the fight goes on. -Original Message- Well for this you can use cpio command in Unix for copying files to Tape. Another option is using ufsdump commnand . We have UnixWare 7.1 and I want to take backup of Database files (Physical files) to my tape. I did use tar command: tar c8v1 /home/oradata It's working properly but the problem is: tar can't handle large files(larger than 2GB). The total size of the DB files under /home/oradata more than 2GB. So the result I'll get some of those files not all. Could any body in the list give me the alternative command of tar that can handle backup of large files or any other solution... because I want to schedule this process. Your help will be appreciated. Regards, ashraf salaymeh System Analyst(OCP Certified DBA) __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ashraf Salaymeh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: dilmohan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: 9i / 9iRAC : Segment_Space_Management AUTO, with LOB
Depending on your circumstances, ASS Management can eliminate severe contention on the freelists / freelist groups area. However, because Oracle is overgenerous with its allocation of bitmap blocks (which may turn out to be in excess of 1% of your database), you may end up thrashing your system because most of your buffer space is flooded with hot BMBs and the data has to keep thrashing on and off disk. Regards Jonathan Lewis http://www.jlcomp.demon.co.uk Coming soon a new one-day tutorial: Cost Based Optimisation (see http://www.jlcomp.demon.co.uk/tutorial.html ) Next Seminar dates: (see http://www.jlcomp.demon.co.uk/seminar.html ) England__January 21/23 The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html -Original Message- To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: 19 December 2002 17:51 We were the other way around in our testing lately:-) We turned on auto space management to remove the contention. Afterwards-we removed quite a bit of header block/free list contention.. anyway, more tests to follow -Original Message- Sent: Thursday, December 19, 2002 10:09 AM To: Multiple recipients of list ORACLE-L As part of a RAC benchmark with 9.2 we had faced severe LOCKING on setting segment space management AUTO had to REMOVE it HTH -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: read only tablespaces
That's a keeper! Orr, Steve [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/19/2002 07:21 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: read only tablespaces Here's the specific SQL query that needs to be run: select translate('LNOPQSUVWXYZBCDEGHIJKn;8!###)n9/)3l9)jku9)vum1@', '8#)n!9/3lvjkum1;@LNOPQSUVWXYZBCDEGHIJK', 'F. aRMedthmfinulT!') Well... from DICTIONARY where table_name='DICTIONARY' / :-):-):-) -Original Message- Sent: Wednesday, December 18, 2002 4:49 PM To: Multiple recipients of list ORACLE-L Personally I would try dba_tablespaces and check the status column... online, offline or read only. If it's online, it's read-write, read only speaks for itself. Good to see sarcasm hasn't left the list. Regards, Bill Burke The Kinder and Gentler DBA www.OracleGuru.com www.KBMotorsports.biz -Original Message- Sent: Wednesday, December 18, 2002 4:15 PM To: Multiple recipients of list ORACLE-L I would suggest Funk Wagnells or Webster's New College Edition -Original Message- Sent: Wednesday, December 18, 2002 2:34 PM To: Multiple recipients of list ORACLE-L which dictionary should I check to see whether a tablespace is read-only or read-write? thanks for your help. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: kinda OT: veritas netbackup
In that case Brian ... sorry, not going to be any help. Good luck. -Original Message-From: Spears, Brian [mailto:[EMAIL PROTECTED]]Sent: Thursday, December 19, 2002 12:05 PMTo: Multiple recipients of list ORACLE-LSubject: FW: kinda OT: veritas netbackup Yes, we have coded it to do thisand it works but for many reasons.. including simplicitywe want to avoid thissolution for theentire12B enterprise solution... when it confuses others, and is much more vulnerable for screwups with Mount point management and recovery. Brian Spears -Original Message-From: Kevin Lange [mailto:[EMAIL PROTECTED]]Sent: Thursday, December 19, 2002 11:15 AMTo: Multiple recipients of list ORACLE-LSubject: RE: kinda OT: veritas netbackup How about running a script just before the backup that 1) Reads the current log number. 2) Forces a log switch. 3) Copies the logs to a seperate directory. 4) Backups up that seperate directory Leave the archive directory alone. Do not back it up. -Original Message-From: JOE TESTA [mailto:[EMAIL PROTECTED]]Sent: Thursday, December 19, 2002 9:50 AMTo: Multiple recipients of list ORACLE-LSubject: kinda OT: veritas netbackup RESEND: never saw it get posted: Can we force veritas netbackup (HPUX) to NOT backup open files? Here is the problem: while arch process is writing out archive logs, the netbackup script that backs up the arch directory will write a partially written log to tape, we're trying to avoid that. is our only alternative determine(out of data dictionary) how many log groups we have and assuming 3, that if we take the max log seq# minus the numebr of groups we have, gives us the oldest log that we can be sure is complete? ie: current log is 543, we have 3 log groups, 543-3 = 540, since oracle wouldnt start overwriting # 540 until it was successfully archived, that we can back up, up thru log seq# 540 and can be sure # 540 is complete? thanks, joe
RE: Backup DB files to the Tape
That's MR. Condescending Unix user thankyouverymuch. -Original Message- Sent: Thursday, December 19, 2002 1:03 PM To: Multiple recipients of list ORACLE-L Condescending Unix user! -Original Message- Sent: Thursday, December 19, 2002 12:45 PM To: Multiple recipients of list ORACLE-L Here's a nickel, kid. Go buy yourself a better computer. -Original Message- Sent: Thursday, December 19, 2002 10:15 AM To: Multiple recipients of list ORACLE-L It's one of those Unix things. It goes with the beard and the bad-fitting trousers held up by suspenders. -Original Message- From: Hemant K Chitale [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 19, 2002 9:21 AM To: Multiple recipients of list ORACLE-L Subject: RE: Backup DB files to the Tape Stephen, The para. about pax vis-a-vis tar versus cpio was interesting ! I never knew that -- though the names do make sense now ! Hemant At 06:39 AM 18-12-02 -0800, you wrote: I will add a vote for cpio. I have found it to be so reliable that I used cpio, instead of a dump utility, to back up Unix boxes. It never failed. In the past, I found that tar had filename length limitation that was shorter than what the OS permitted (80 characters iirc -- that's filename, not path). This happened when I worked in a development environment that used Rogue Wave tools. During software builds, files would be generated with ridiculously long names, and tar could not handle these. Time has passed since the days I had to backup Unix servers, but iirc cpio could correctly handle all types of special files (devices, etc.), and tar could not (as I said, iirc). If you are just experimenting, there is another utility called pax, which is latin for peace, the idea being that it will bring peace to the Tar Wars where tar2d2 is always fighting c3pio. I get the impression that neither group was willing to abandon its favorite utility and adopt pax, so the fight goes on. -Original Message- Well for this you can use cpio command in Unix for copying files to Tape. Another option is using ufsdump commnand . We have UnixWare 7.1 and I want to take backup of Database files (Physical files) to my tape. I did use tar command: tar c8v1 /home/oradata It's working properly but the problem is: tar can't handle large files(larger than 2GB). The total size of the DB files under /home/oradata more than 2GB. So the result I'll get some of those files not all. Could any body in the list give me the alternative command of tar that can handle backup of large files or any other solution... because I want to schedule this process. Your help will be appreciated. Regards, ashraf salaymeh System Analyst(OCP Certified DBA) __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ashraf Salaymeh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: dilmohan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line
RE: 9i / 9iRAC : Segment_Space_Management AUTO, with LOB
Title: RE: 9i / 9iRAC : Segment_Space_Management AUTO, with LOB ASS Management? I'm snickering, I know it's juvenile humor, but... LOL! Let me tell you, my ASS is not on the Free List. And thrashing? I'll leave that one alone! Sorry everyone. Couldn't resist. Is it Friday yet... -Original Message- From: Jonathan Lewis [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 19, 2002 1:56 PM To: Multiple recipients of list ORACLE-L Subject: Re: 9i / 9iRAC : Segment_Space_Management AUTO, with LOB Depending on your circumstances, ASS Management can eliminate severe contention on the freelists / freelist groups area. However, because Oracle is overgenerous with its allocation of bitmap blocks (which may turn out to be in excess of 1% of your database), you may end up thrashing your system because most of your buffer space is flooded with hot BMBs and the data has to keep thrashing on and off disk. Regards Jonathan Lewis http://www.jlcomp.demon.co.uk Coming soon a new one-day tutorial: Cost Based Optimisation (see http://www.jlcomp.demon.co.uk/tutorial.html ) Next Seminar dates: (see http://www.jlcomp.demon.co.uk/seminar.html ) England__January 21/23 The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html -Original Message- To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: 19 December 2002 17:51 We were the other way around in our testing lately:-) We turned on auto space management to remove the contention. Afterwards-we removed quite a bit of header block/free list contention.. anyway, more tests to follow -Original Message- Sent: Thursday, December 19, 2002 10:09 AM To: Multiple recipients of list ORACLE-L As part of a RAC benchmark with 9.2 we had faced severe LOCKING on setting segment space management AUTO had to REMOVE it HTH -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Lewis INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).