RE: TEST
Title: TEST What are you testing? -Original Message-From: RAJESH DAYAL [mailto:[EMAIL PROTECTED]]Sent: Monday, May 20, 2002 11:18 AMTo: Multiple recipients of list ORACLE-LSubject: TEST TESTING ...
Re: Oracle web application
On Sat, 18 May 2002, Keith Carney wrote: I am a beginner in Oracle and I need help. I need to implement a interactive connection of oracle with web. I need to save data from web to database, make a kind of processing and send a response to the web. I have no idea even how to make the implementation. Can somebody help me ? Keith: I would consider PHP (http://www.php.net). It is very powerful, and very fast. It is low overhead as compared to Java, and stored PL/SQL, as well as many other web development solutions. Basically you have PHP scripts embedded in HTML pages or templates which get executed by Apache in a similar way that CGI's used to. Actually PHP is compiled into the Apache server, or as a dynamically loaded module. My biz site runs on it: http://www.iheavy.com. HTH, Sean -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Platinum Fastunloader
Thanks for all the replies chaps. Its a legacy product here and we needed to see if it was licenced correctly. It looks like we are going to dump it anyway. Regards Lee -Original Message-From: Robertson Lee - lerobe [mailto:[EMAIL PROTECTED]]Sent: 17 May 2002 17:38To: Multiple recipients of list ORACLE-LSubject: Platinum Fastunloader Weird question chaps BUT Anyone out there using this product and if so, is there a way of finding out if the product is licenced on your system. FYI we are on Tru64. TIA Lee The information contained in this communication isconfidential, is intended only for the use of the recipientnamed above, and may be legally privileged. If the reader of this message is not the intended recipient, you arehereby notified that any dissemination, distribution orcopying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computersystem.
What makes Export slow ?
Hi guys, I moved my database from Solaris 7 to Solaris 8 box (Sun Fire 4800, faster processors and more memory space) I create the database with the same script that I used to for my database in the older machine, When I export my database from the older machine it was very fast and when I import to newer machine it was fast too, and when I export from new machine it is really slow (very slow), (I am using same export parameters in both servers) Can someone help with tuning tips or anything you have... : ( - The no of records are the same for both machines - v$session_wait.seconds_in_wait is more than 1 Thank you -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy Xing INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
tns-12541 no listener while using connection manager
Hi friends. I am having a problem when trying to connect through connection manger i have in my tnsnames.ora and cman.ora as given below then use_cman = TRUE in sqlnet.ora and my server is configured for MTS . It's on oracle 8.1.7 in win 2k . - TNSNAMES.ORA - ABC = (DESCRIPTION = (load_balance=on) (failover=on) (ADDRESS_LIST = ( SOURCE_ROUTE = YES ) ( ADDRESS = ( PROTOCOL = TCP )( HOST = oracle )(SERVICE = CMAN)( PORT = 1610 )) ( ADDRESS = (PROTOCOL = TCP)(HOST = oracle)(SERVICE = CMAN )( PORT = 1521)) ) ( CONNECT_DATA = ( SERVICE_NAME = oracledb ) ) ) --- CMAN.ORA --- cman = (ADDRESS_LIST= ( ADDRESS=( PROTOCOL=tcp ) ( HOST= oracle ) ( PORT=1630 ) ( QUEUESIZE=32 ) ) )cman_profile = ( parameter_list= ( MAXIMUM_RELAYS=1024 ) ( LOG_LEVEL=1 ) ( TRACING=yes ) ( RELAY_STATISTICS=yes ) ( SHOW_TNS_INFO=yes ) ( USE_ASYNC_CALL=yes ) ( AUTHENTICATION_LEVEL=0 ) ( REMOTE_ADMIN=FALSE ) )CMAN_ADMIN = (ADDRESS=(PROTOCOL=tcp)(HOST=oracle)(PORT=1650))CMANAGER_NAME = cman But i am getting the error 12541 no listener .Please help me in solving this This is urgent shibu
Errors on Alert file
Hi All, Is it normal that after a shutdown immediate of a database (Oracle 8.1.7), Errors (Ora-602) are still generated on the Instance Alert file ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: GL2Z/ INF DBA BENLATRECHE INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
rman
Title: RE: [Q] what difference between count(0), count(1) and Hi Please can you help/advise with an rman problem we are having. We are getting the following error when trying to backup a database: RMAN-20011: target database incarnation is not current in recovery catalog If I look in the rman logs I see that our last valid backup was 16th May. The rman database shows that the rc_backup_file has an entry for that date- anything after that is blank. Metalink has provided a solution to zero the dbid- what are the implications of this- it gives no information on that. The additional aspect is that I need to restore the 16th's backup onto our ref box so if zeroing the dbid will hose that backup..I'd rather avoid that??!!! : ) Any help would be REALLY appreciated!!! Rgds Fawzia ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. **
SQL Server to Oracle DB
Title: SQL Server to Oracle DB Anyone know of an easy way to grab data from tables in an SQL Server DB and insert into tables in an Oracle DB? Thanks.
RE: Errors on Alert file
Title: RE: Errors on Alert file ORA-00602 ORA-00602internal programming exception Cause:An internal programming exception has occurred. Action:Report this error as a program bug to Worldwide Customer Support. nirmal. -Original Message- From: GL2Z/ INF DBA BENLATRECHE [SMTP:[EMAIL PROTECTED]] Sent: 09 ÑÈíÚ ÇáÇæá, 1423 02:33 PM To: Multiple recipients of list ORACLE-L Subject: Errors on Alert file Hi All, Is it normal that after a shutdown immediate of a database (Oracle 8.1.7), Errors (Ora-602) are still generated on the Instance Alert file ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: GL2Z/ INF DBA BENLATRECHE INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Connecting to DB from behind a firewall - solved !
thanks a lot to all who responded !!! DBAndrey * 03-9254520 * 058-548133 * mailto:[EMAIL PROTECTED] -Original Message- Sent: Mon, May 20, 2002 3:27 PM To: [EMAIL PROTECTED] Oracle has a registry setting that will force all traffic for a session through the same port that the listener connection was made on (e.g. 1521). Place the USE_SHARED_SOCKET parameter in the registry under HKEY_LOCAL_MACHINE:Software:Oracle with a value of TRUE, and restart Oracle and the listener for it to take effect. It also doesn't hurt to set this parameter as a system environment variable as well. --- Jason Heinrich, OCP Oracle Database Administrator Pensacola Christian College (850) 478-8496 x2509 [EMAIL PROTECTED] From: Andrey Bronfin [EMAIL PROTECTED] Date: Sunday, May 19, 2002 10:36 AM Subject: Connecting to DB from behind a firewall. Dear list ! It's an Oracle 8.0.5 on Win NT question: We want to put our database server behind a firewall. The problem is the clients that need to connect to our DB from the outer world. Now , i know that the Oracle listener can choose any port when passing the connection to the Oracle server. That means , that theoretically all the ports should be open on the firewall in order to allow client connections. Sounds illogical. So, is there a way to limit the ports range used by the listener when passing the connections to the Oracle server ? I do not want to use connection manager etc.. thanks a lot ! DBAndrey * 03-9254520 * 058-548133 * mailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrey Bronfin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Finally....DBNEWID
Just a FYI... Anyone using RMAN will know the joy of Rman getting very upset if you pretty much do anything with a database that has been cloned from another. (According to the doco) in 9i.2, the rumoured DBNEWID is now available so you can change the database id or database name. Cheers Connor = Connor McDonald http://www.oracledba.co.uk http://www.oaktable.net Some days you're the pigeon, some days you're the statue __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Errors on Alert file
No. Which patch level is your 8.1.7? Are any trace files generated? Have you checked Metalink? Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, May 20, 2002 6:33 AM To: Multiple recipients of list ORACLE-L Hi All, Is it normal that after a shutdown immediate of a database (Oracle 8.1.7), Errors (Ora-602) are still generated on the Instance Alert file ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: GL2Z/ INF DBA BENLATRECHE INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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
You won't hose the backup you need. You can use rman nocatalog if there is a problem with the incarnation. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, May 20, 2002 9:58 AM Hi Please can you help/advise with an rman problem we are having. We are getting the following error when trying to backup a database: RMAN-20011: target database incarnation is not current in recovery catalog If I look in the rman logs I see that our last valid backup was 16th May. The rman database shows that the rc_backup_file has an entry for that date- anything after that is blank. Metalink has provided a solution to zero the dbid- what are the implications of this- it gives no information on that. The additional aspect is that I need to restore the 16th's backup onto our ref box so if zeroing the dbid will hose that backup..I'd rather avoid that??!!! : ) Any help would be REALLY appreciated!!! Rgds Fawzia ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Upgrade and it says it doesn't need it
Unfortunately - this is what I'm having a problem with. I did install with OUI. The log files from that installation are in the oraInventory directory. Subsequently, I installed some client software (precompilers) on the machine. The oraInventory only shows the client installation, not the real server. And...I have confirmed - the oraInst.loc file does correctly point to the oraInventory directory. It just looks as though the installer process didn't update the oraInventory correctly. Now I'm afraid I'm Screwed on the upgrade! -Original Message- Sent: Saturday, May 18, 2002 9:58 AM To: Multiple recipients of list ORACLE-L I'm guessing that the 9.0.1.0 server software was not installed using the Oracle installer? Did you tar it over from somewhere else? For a server installed using the installer, you'll find a file in /var/opt/oracle named oraInst.loc, which contains the name of the directory containing the Oracle Universal Installer's oraInventory directory. Your installer running the 9.0.1.2 patch is checking for that file in /var/opt/oracle and probably not finding it. Or, it is finding it and the oraInventory directory, but the inventory says that only the client has been installed... - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, May 17, 2002 3:38 PM HI - I'm trying to upgrade my database from 9.0.1.0 to 9.0.1.2 (Sun Solaris). The installer tells me there are no files that need to be applied. When I click on installed products, under 9i it only show the client install, not the enterprise edition server. Does anyone know what I can do to get the installer to realize that I do have the server installed? Thank you - Lisa -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: YTTRI Lisa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: YTTRI Lisa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: TEST
Your shift key is not working correctly -Original Message- Sent: Monday, May 20, 2002 1:18 AM To: Multiple recipients of list ORACLE-L TESTING ... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Schilling, Ben INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Numeric comparison in DECODE statement
I was wondering if anyone might have tried this before, because I can't seem to get it
to work. I'd like to be able to determine which unit of measure to concatenate to a
value by using a decode statement in the query. I have a column in the database that
stores time in minutes, and I'd like to be able to show the output in minutes if the
value is less than 60, but in hours (such as 3.27 hours) if the value is greater than
60. So far I've tried the following statement, but it seems to be blowing up on the
first comparison operator:
SELECT decode(in_value, to_char(to_number(in_value) = to_number('60')),
to_char(in_value)||' minutes', to_char(to_number(in_value) to_number('60')),
to_char(in_value/60, '9.99')||' hours')
FROM dual
/
I'm selecting from dual just until I can get the query working at all. Is what I'm
trying to do even possible? Any help or ideas would be greatly appreciated. Thanks
in advance.
_YEX_
/*
|| Robert D. Yexley
|| Oracle Programmer/Analyst
|| Easylink Services Corporation
|| Professional Services
|| Contractor - Wright Research Site MIS
|| Det-1 AFRL/WSI Bldg. 45 Rm. 062
|| (937) 255-1984
|| [EMAIL PROTECTED]
|| )))
*/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Yexley Robert D Contr Det 1 AFRL/WSI
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or 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 Server to Oracle DB
Title: SQL Server to Oracle DB Use BCP to export data from SQL Server and SQL Load import data into Oracle DB. Brian Chen -Original Message-From: Richard Huntley [mailto:[EMAIL PROTECTED]]Sent: Monday, May 20, 2002 10:03 AMTo: Multiple recipients of list ORACLE-LSubject: SQL Server to Oracle DB Anyone know of an easy way to grab data from tables in an SQL Server DB and insert into tables in an Oracle DB? Thanks.
Re: Do you ever have days where you dont want to think ?
as one of the women in this profession, do I want to know who you consider honorary men? :) What I do want to know is how you determine what the criteria are for being an honorary man. Inquiring minds want to know :) Rachel |+--- || | || | || sfaroult@orio| || le.com | || | || 05/18/2002 | || 11:13 AM | || Please | || respond to | || ORACLE-L | || | |+--- | || | To: [EMAIL PROTECTED] | | cc: (bcc: Rachel Carmichael) | | Subject: Re: Do you ever have days where | | you dont want to think ? | | Larry Elkins wrote: The beach part sounds great, though I don't care to see naked men running around ;-) That's the problem in this job. Too many men. And among women, too many are like honorary men. Still preaching the gospel, as you can see :-). In fact, I would be curious to compare the join on the inline-view with a MINUS to the hash anti-join. Assuming all correct indexes, it is comparing two index fast full scans plus sort plus index search to two table full scans (more or less). I am almost certain that many costs could be put into equations. The problem is if you have too many values (number of rows, number of rows returned, storage, selectivity, etc...) to feed into your equations or have trouble deriving these it is not of much use. Wanted to do some tests on reverse indexes, following your posts, but I have not had time. Not much progress on the book PL/SQL chapter either. Currently working on real-time, home-made replication (which works on the standard edition, BTW). Still revolving around the same topics because one of my concerns is to minimize overhead when logging (trigger-happy replication, I am suspicious of the Shareplex approach and anyway as I want to be able to replicate between France, Japan and the US, I cannot afford to transfer full redo logs and transactions I shall have to rollback). I log into several tables (enough info to rebuild statements, and values separately - with additional problems when we reach the 4,000 characters mark), IOTs are the obvious choice but I am not sure it is available with all licenses. Degradation of my logs over timeis also something I have to watch. This is for the days. Evenings are spent improving an intelligent loader able to take into account complex FK relationships. I have prepared two 5,000,000 row tables, one in my 8.1.7 database and one in my 9.0.1 database, but I have not tested anything yet. I had a flash of idiocy and subscribed to the OT list (out of the blues). I doubt I will stay long here. Some people seems to be paid doing nothing but e-mailing. Is this where you got the details about Pierce? Pretty active there. Cheers, Stephane Faroult -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: rman
Fawzia - I have not experienced your error, so these are just some thoughts. Have you checked the dbid in RMAN and in the database (v$database)? Have you performed an O.S. clone of the database? Metalink has quite a few entries on 20011 that may provide some ideas. If you need to reset the catalog and also be able to use the 5/16 backup, one idea might be to export/recreate the RMAN catalog under another schema first. Never tried that, but just a thought. Hopefully someone that has experienced this error will respond. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, May 20, 2002 8:58 AM To: Multiple recipients of list ORACLE-L Hi Please can you help/advise with an rman problem we are having. We are getting the following error when trying to backup a database: RMAN-20011: target database incarnation is not current in recovery catalog If I look in the rman logs I see that our last valid backup was 16th May. The rman database shows that the rc_backup_file has an entry for that date- anything after that is blank. Metalink has provided a solution to zero the dbid- what are the implications of this- it gives no information on that. The additional aspect is that I need to restore the 16th's backup onto our ref box so if zeroing the dbid will hose that backup..I'd rather avoid that??!!! : ) Any help would be REALLY appreciated!!! Rgds Fawzia ** Information in this email is confidential and may be privileged. It is intended for the addressee only. If you have received it in error, please notify the sender immediately and delete it from your system. You should not otherwise copy it, retransmit it or use or disclose its contents to anyone. Thank you for your co-operation. ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 server to oracle db
Rich, since you have SQL SERVER, do you have DTS?, thats the easiest way to move he data around. joe
Re:Numeric comparison in DECODE statement
Robert,
That won't work. Decode works like a switch statement. If condition 1 then
value 1. You can't imbed logic operators therein.
DickG.
Reply Separator
Author: Yexley Robert D Contr Det 1 AFRL/WSI [EMAIL PROTECTED]
Date: 5/20/2002 7:08 AM
I was wondering if anyone might have tried this before, because I can't seem to
get it to work. I'd like to be able to determine which unit of measure to
concatenate to a value by using a decode statement in the query. I have a
column in the database that stores time in minutes, and I'd like to be able to
show the output in minutes if the value is less than 60, but in hours (such as
3.27 hours) if the value is greater than 60. So far I've tried the following
statement, but it seems to be blowing up on the first comparison operator:
SELECT decode(in_value, to_char(to_number(in_value) = to_number('60')),
to_char(in_value)||' minutes', to_char(to_number(in_value) to_number('60')),
to_char(in_value/60, '9.99')||' hours')
FROM dual
/
I'm selecting from dual just until I can get the query working at all. Is what
I'm trying to do even possible? Any help or ideas would be greatly appreciated.
Thanks in advance.
_YEX_
/*
|| Robert D. Yexley
|| Oracle Programmer/Analyst
|| Easylink Services Corporation
|| Professional Services
|| Contractor - Wright Research Site MIS
|| Det-1 AFRL/WSI Bldg. 45 Rm. 062
|| (937) 255-1984
|| [EMAIL PROTECTED]
|| )))
*/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Yexley Robert D Contr Det 1 AFRL/WSI
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
RE: Numeric comparison in DECODE statement
How about
select to_char(floor(my_col_in_minutes/60), '990') || ':' ||
to_char(mod(my_col_in_minutes, 60)) HH:MI from dual
/
__
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-
[mailto:[EMAIL PROTECTED]]
Sent: Monday, May 20, 2002 11:08 AM
To: Multiple recipients of list ORACLE-L
I was wondering if anyone might have tried this before, because I can't seem
to get it to work. I'd like to be able to determine which unit of measure
to concatenate to a value by using a decode statement in the query. I have
a column in the database that stores time in minutes, and I'd like to be
able to show the output in minutes if the value is less than 60, but in
hours (such as 3.27 hours) if the value is greater than 60. So far I've
tried the following statement, but it seems to be blowing up on the first
comparison operator:
SELECT decode(in_value, to_char(to_number(in_value) = to_number('60')),
to_char(in_value)||' minutes', to_char(to_number(in_value)
to_number('60')), to_char(in_value/60, '9.99')||' hours')
FROM dual
/
I'm selecting from dual just until I can get the query working at all. Is
what I'm trying to do even possible? Any help or ideas would be greatly
appreciated. Thanks in advance.
_YEX_
*2
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.
*2
Re: Do you ever have days where you dont want to think ?
Stephane, I *did* warn you about the OT list before I approved your registration on it.. btw, this sounds like it should have gone private, not to the list Rachel |+--- || | || | || sfaroult@orio| || le.com | || | || 05/18/2002 | || 11:13 AM | || Please | || respond to | || ORACLE-L | || | |+--- | || | To: [EMAIL PROTECTED] | | cc: (bcc: Rachel Carmichael) | | Subject: Re: Do you ever have days where | | you dont want to think ? | | Larry Elkins wrote: The beach part sounds great, though I don't care to see naked men running around ;-) That's the problem in this job. Too many men. And among women, too many are like honorary men. Still preaching the gospel, as you can see :-). In fact, I would be curious to compare the join on the inline-view with a MINUS to the hash anti-join. Assuming all correct indexes, it is comparing two index fast full scans plus sort plus index search to two table full scans (more or less). I am almost certain that many costs could be put into equations. The problem is if you have too many values (number of rows, number of rows returned, storage, selectivity, etc...) to feed into your equations or have trouble deriving these it is not of much use. Wanted to do some tests on reverse indexes, following your posts, but I have not had time. Not much progress on the book PL/SQL chapter either. Currently working on real-time, home-made replication (which works on the standard edition, BTW). Still revolving around the same topics because one of my concerns is to minimize overhead when logging (trigger-happy replication, I am suspicious of the Shareplex approach and anyway as I want to be able to replicate between France, Japan and the US, I cannot afford to transfer full redo logs and transactions I shall have to rollback). I log into several tables (enough info to rebuild statements, and values separately - with additional problems when we reach the 4,000 characters mark), IOTs are the obvious choice but I am not sure it is available with all licenses. Degradation of my logs over timeis also something I have to watch. This is for the days. Evenings are spent improving an intelligent loader able to take into account complex FK relationships. I have prepared two 5,000,000 row tables, one in my 8.1.7 database and one in my 9.0.1 database, but I have not tested anything yet. I had a flash of idiocy and subscribed to the OT list (out of the blues). I doubt I will stay long here. Some people seems to be paid doing nothing but e-mailing. Is this where you got the details about Pierce? Pretty active there. Cheers, Stephane Faroult -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Compressing Export Dumps
Simon - I'll repeat (for the third time, I believe) that this sounds like an ideal use for database cloning. Much faster, and as a bonus you get to test your backups, which is always an excellent idea. More information can be found at http://asktom.oracle.com/pls/ask/f?p=4950:8:843675::NO::F4950_P8_DISPLAYID,F 4950_P8_CRITERIA:575623107841,%7Bclone%7D Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Saturday, May 18, 2002 6:28 AM To: Multiple recipients of list ORACLE-L Hi Jared, Sorry about the delayed response. Trying to import into Training DB/Stadby DB/Development DB. A kind of backup plan also -Anyhting wrong with this? Thanks -Original Message- Sent: Thursday, May 16, 2002 8:29 PM To: Multiple recipients of list ORACLE-L Simon, I'm curious as to why you're creating exports that large. Are you doing this as a backup method? Have you ever restored an export that large? The largest export I've ever restored is about 10 gig, and it took far too long. Jared Simon Waibale [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 05/16/2002 02:38 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Compressing Export Dumps Hi all, My export dumps are too big (80 GB) for my filesystem and I'm looking for a way to compress them on the fly -ie without taking *.dmp to disk first but straight *.dmp.gz Anybody with an idea on how to archive this ? Thanking you, --- CSW -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Simon Waibale INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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 web application
Hi Dennis, my name is Aida, (my fault about this) Keith is my husband (I love to bother him). Thank you for answering to me, I really appreciate it. Let me explain more clear the situation. I am a graduate student at Stephen F. Austin State University in computer science department. I will graduate next summer. As part of my graduation the department has assigned me the project of Computer Science Programming Contest that is done every year. The way the contest is organized is this: There is a web site in which the student can register in teams of 3 or 4, they need to give their info (first name, last name, phone, class, address, for each member, the name of the team) and a user name and password is assigned to each team so they can come back and change it at any time. At the contest day, to each time is given their account on TITANS and password and directions how they can send their answers back by mail form their account to the jury. Every team-member can program in C, C++ or COBOL (languages that are taught at our university). After the e-mail is sent, the judge sends back the result of the answer. The way that is done until last time is this. A faculty member used the PHP to make the registration and humans do all the other part. (this is what they want to avoid mainly and this time I think they are going to use also UNIX accounts for students) I took an oracle class (is the first time that is offered) this spring and they assigned me to do this project using oracle. I have learned SQL and PL/SQL and some of the basics of Oracle. I have designed some web sites before with forms, but never any one in interaction with the user and a database. That's why I need help for basically everything. (even for the general concept). Should I still use PHP or is there any better choice? This is my first big question right now but to tell you the truth I have everything under question mark. But one thing at a time and I am hunting around to get more comfortable with this problem. Thank you very much for your time AIDA - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Sunday, May 19, 2002 9:03 PM Keith - Usually you need to create some sort of application that will respond to user requests, extract data from Oracle, and format an HTML page to send back to the user. That is basically what you described in your email. How that program interfaces to Oracle will depend on what programming language you choose. Usually your program is executed by a software called a web server or an application server. Before you need to worry about Oracle, you need to learn a lot more about Web programming. If by web you mean the Internet, then you also need to learn about Web security. If your application is within your company intranet, then this concern isn't so significant. Suggestions: Find someone in your company that is an experienced Web programmer, and discuss your situation with them. That will teach you a lot quicker. Go to http://www.google.com, and type terms like HTML Tutorial. A good site I found was http://www.mcli.dist.maricopa.edu/tut/. This won't teach you about connecting to a database, but you've got learn the basics before you progress on to advanced topics. http://www.computerworld.com/departments/technology/quickstudies offers explanations of some of the important concepts so simple even a manager can understand. If you encounter more specific questions, write back Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Saturday, May 18, 2002 11:43 AM To: Multiple recipients of list ORACLE-L hi, I am a beginner in Oracle and I need help. I need to implement a interactive connection of oracle with web. I need to save data from web to database, make a kind of processing and send a response to the web. I have no idea even how to make the implementation. Can somebody help me ? Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Keith Carney INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE
RE: Errors on Alert file
Hello DENNIS, Our patch level is 8.1.7.2.2 running under Netware 5.1. I think it's the latest patch that we found on Metalink. Best Regards Kamel Benlatreche -Message d'origine- De : DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]] Envoyé : lundi 20 mai 2002 14:23 À : Multiple recipients of list ORACLE-L Objet : RE: Errors on Alert file No. Which patch level is your 8.1.7? Are any trace files generated? Have you checked Metalink? Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, May 20, 2002 6:33 AM To: Multiple recipients of list ORACLE-L Hi All, Is it normal that after a shutdown immediate of a database (Oracle 8.1.7), Errors (Ora-602) are still generated on the Instance Alert file ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: GL2Z/ INF DBA BENLATRECHE INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: GL2Z/ INF DBA BENLATRECHE INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Do you ever have days where you dont want to think ?
Hehe... I was thinking the same thing and decided not to pursue! Thanks for stepping up to make that request. I don't look like a man, I don't feel like a man, have never been called one of the guys Just curious too... This is interesting! Melanie Burns -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Monday, May 20, 2002 9:23 AM To: Multiple recipients of list ORACLE-L as one of the women in this profession, do I want to know who you consider honorary men? :) What I do want to know is how you determine what the criteria are for being an honorary man. Inquiring minds want to know :) Rachel |+--- || | || | || sfaroult@orio| || le.com | || | || 05/18/2002 | || 11:13 AM | || Please | || respond to | || ORACLE-L | || | |+--- | || | To: [EMAIL PROTECTED] | | cc: (bcc: Rachel Carmichael) | | Subject: Re: Do you ever have days where | | you dont want to think ? | | Larry Elkins wrote: The beach part sounds great, though I don't care to see naked men running around ;-) That's the problem in this job. Too many men. And among women, too many are like honorary men. Still preaching the gospel, as you can see :-). In fact, I would be curious to compare the join on the inline-view with a MINUS to the hash anti-join. Assuming all correct indexes, it is comparing two index fast full scans plus sort plus index search to two table full scans (more or less). I am almost certain that many costs could be put into equations. The problem is if you have too many values (number of rows, number of rows returned, storage, selectivity, etc...) to feed into your equations or have trouble deriving these it is not of much use. Wanted to do some tests on reverse indexes, following your posts, but I have not had time. Not much progress on the book PL/SQL chapter either. Currently working on real-time, home-made replication (which works on the standard edition, BTW). Still revolving around the same topics because one of my concerns is to minimize overhead when logging (trigger-happy replication, I am suspicious of the Shareplex approach and anyway as I want to be able to replicate between France, Japan and the US, I cannot afford to transfer full redo logs and transactions I shall have to rollback). I log into several tables (enough info to rebuild statements, and values separately - with additional problems when we reach the 4,000 characters mark), IOTs are the obvious choice but I am not sure it is available with all licenses. Degradation of my logs over timeis also something I have to watch. This is for the days. Evenings are spent improving an intelligent loader able to take into account complex FK relationships. I have prepared two 5,000,000 row tables, one in my 8.1.7 database and one in my 9.0.1 database, but I have not tested anything yet. I had a flash of idiocy and subscribed to the OT list (out of the blues). I doubt I will stay long here. Some people seems to be paid doing nothing but e-mailing. Is this where you got the details about Pierce? Pretty active there. Cheers, Stephane Faroult -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ:
RE: SQL Server to Oracle DB
Title: SQL Server to Oracle DB I would use SQL Servers DTS tool. It is relatively easy depending on how much data you have to move. I use it fasirly often to move data between Oracle, SQL Server, DB2 and other data sources. Dave -Original Message-From: Richard Huntley [mailto:[EMAIL PROTECTED]]Sent: Monday, May 20, 2002 9:03 AMTo: Multiple recipients of list ORACLE-LSubject: SQL Server to Oracle DB Anyone know of an easy way to grab data from tables in an SQL Server DB and insert into tables in an Oracle DB? Thanks.
Re: Do you ever have days where you dont want to think ?
This inquiring mind want's to know, what is honorary about being thought of as a man instead of the women you are? Ruth. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, May 20, 2002 10:23 AM as one of the women in this profession, do I want to know who you consider honorary men? :) What I do want to know is how you determine what the criteria are for being an honorary man. Inquiring minds want to know :) Rachel |+--- || | || | || sfaroult@orio| || le.com | || | || 05/18/2002 | || 11:13 AM | || Please | || respond to | || ORACLE-L | || | |+--- | || | To: [EMAIL PROTECTED] | | cc: (bcc: Rachel Carmichael) | | Subject: Re: Do you ever have days where | | you dont want to think ? | | Larry Elkins wrote: The beach part sounds great, though I don't care to see naked men running around ;-) That's the problem in this job. Too many men. And among women, too many are like honorary men. Still preaching the gospel, as you can see :-). In fact, I would be curious to compare the join on the inline-view with a MINUS to the hash anti-join. Assuming all correct indexes, it is comparing two index fast full scans plus sort plus index search to two table full scans (more or less). I am almost certain that many costs could be put into equations. The problem is if you have too many values (number of rows, number of rows returned, storage, selectivity, etc...) to feed into your equations or have trouble deriving these it is not of much use. Wanted to do some tests on reverse indexes, following your posts, but I have not had time. Not much progress on the book PL/SQL chapter either. Currently working on real-time, home-made replication (which works on the standard edition, BTW). Still revolving around the same topics because one of my concerns is to minimize overhead when logging (trigger-happy replication, I am suspicious of the Shareplex approach and anyway as I want to be able to replicate between France, Japan and the US, I cannot afford to transfer full redo logs and transactions I shall have to rollback). I log into several tables (enough info to rebuild statements, and values separately - with additional problems when we reach the 4,000 characters mark), IOTs are the obvious choice but I am not sure it is available with all licenses. Degradation of my logs over timeis also something I have to watch. This is for the days. Evenings are spent improving an intelligent loader able to take into account complex FK relationships. I have prepared two 5,000,000 row tables, one in my 8.1.7 database and one in my 9.0.1 database, but I have not tested anything yet. I had a flash of idiocy and subscribed to the OT list (out of the blues). I doubt I will stay long here. Some people seems to be paid doing nothing but e-mailing. Is this where you got the details about Pierce? Pretty active there. Cheers, Stephane Faroult -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat
RE: Numeric comparison in DECODE statement
I think in this case you're suppose to use sign as decode was only meant to
deal with specific values
e.g.
SELECT DECODE(SIGN(:in_value - 60),1,TO_CHAR(:in_value/60, '9.99')||'
hours',
-1,TO_CHAR(TO_CHAR(:in_value))||' minutes',
TO_CHAR(TO_CHAR(:in_value))||' minutes')
FROM dual
-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Monday, May 20, 2002 4:08 PM
To: Multiple recipients of list ORACLE-L
I was wondering if anyone might have tried this before, because I can't seem
to get it to work. I'd like to be able to determine which unit of measure
to concatenate to a value by using a decode statement in the query. I have
a column in the database that stores time in minutes, and I'd like to be
able to show the output in minutes if the value is less than 60, but in
hours (such as 3.27 hours) if the value is greater than 60. So far I've
tried the following statement, but it seems to be blowing up on the first
comparison operator:
SELECT decode(in_value, to_char(to_number(in_value) = to_number('60')),
to_char(in_value)||' minutes', to_char(to_number(in_value)
to_number('60')), to_char(in_value/60, '9.99')||' hours')
FROM dual
/
I'm selecting from dual just until I can get the query working at all. Is
what I'm trying to do even possible? Any help or ideas would be greatly
appreciated. Thanks in advance.
_YEX_
/*
|| Robert D. Yexley
|| Oracle Programmer/Analyst
|| Easylink Services Corporation
|| Professional Services
|| Contractor - Wright Research Site MIS
|| Det-1 AFRL/WSI Bldg. 45 Rm. 062
|| (937) 255-1984
|| [EMAIL PROTECTED]
|| )))
*/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Yexley Robert D Contr Det 1 AFRL/WSI
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be 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: Nicoll, Iain (Calanais)
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or 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 Server to Oracle DB
Title: SQL Server to Oracle DB Richard: Yes. The way I've done it in the past is to generate tilde (~) delimited flat files and then load the data into Oracle via SQL*Loader. You have to do a mapping first before using SQL*Loader. Then you have to write scripts for each table you are loading. I recommend the O'Reilly book Oracle SQL*Loader, The Definitive Guide. This is a process that can take time especially if the Oracle application needs data that the old legacy DB doesn't provide. My $0.02 worth, Ken Janusz, CPIM - Original Message - From: Richard Huntley To: Multiple recipients of list ORACLE-L Sent: Monday, May 20, 2002 9:03 AM Subject: SQL Server to Oracle DB Anyone know of an easy way to grab data from tables in an SQL Server DB and insert into tables in an Oracle DB? Thanks.
Re:Numeric comparison in DECODE statement
Don't use DECODE, but CASE
SELECT TO_CHAR(
CASE WHEN in_value 60 THEN in_value ELSE in_value/60 END
, '9.99'
) FROM DUAL;
JP
Reply Separator
Author: Yexley Robert D Contr Det 1 AFRL/WSI [EMAIL PROTECTED]
Date: 5/20/2002 7:08 AM
I was wondering if anyone might have tried this before, because I can't
seem to get it to work. I'd like to be able to determine which unit of
measure to concatenate to a value by using a decode statement in the query.
I have a column in the database that stores time in minutes, and I'd like
to be able to show the output in minutes if the value is less than 60, but
in hours (such as 3.27 hours) if the value is greater than 60. So far I've
tried the following statement, but it seems to be blowing up on the first
comparison operator:
SELECT decode(in_value, to_char(to_number(in_value) = to_number('60')),
to_char(in_value)||' minutes', to_char(to_number(in_value)
to_number('60')), to_char(in_value/60, '9.99')||' hours')
FROM dual
/
I'm selecting from dual just until I can get the query working at all. Is
what I'm trying to do even possible? Any help or ideas would be greatly
appreciated. Thanks in advance.
_YEX_
/*
|| Robert D. Yexley
|| Oracle Programmer/Analyst
|| Easylink Services Corporation
|| Professional Services
|| Contractor - Wright Research Site MIS
|| Det-1 AFRL/WSI Bldg. 45 Rm. 062
|| (937) 255-1984
|| [EMAIL PROTECTED]
|| )))
*/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jan Pruner
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
RE: Do you ever have days where you dont want to think ?
How does one get on the OT list??? -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Monday, May 20, 2002 10:23 AM To: Multiple recipients of list ORACLE-L as one of the women in this profession, do I want to know who you consider honorary men? :) What I do want to know is how you determine what the criteria are for being an honorary man. Inquiring minds want to know :) Rachel |+--- || | || | || sfaroult@orio| || le.com | || | || 05/18/2002 | || 11:13 AM | || Please | || respond to | || ORACLE-L | || | |+--- | || | To: [EMAIL PROTECTED] | | cc: (bcc: Rachel Carmichael) | | Subject: Re: Do you ever have days where | | you dont want to think ? | | Larry Elkins wrote: The beach part sounds great, though I don't care to see naked men running around ;-) That's the problem in this job. Too many men. And among women, too many are like honorary men. Still preaching the gospel, as you can see :-). In fact, I would be curious to compare the join on the inline-view with a MINUS to the hash anti-join. Assuming all correct indexes, it is comparing two index fast full scans plus sort plus index search to two table full scans (more or less). I am almost certain that many costs could be put into equations. The problem is if you have too many values (number of rows, number of rows returned, storage, selectivity, etc...) to feed into your equations or have trouble deriving these it is not of much use. Wanted to do some tests on reverse indexes, following your posts, but I have not had time. Not much progress on the book PL/SQL chapter either. Currently working on real-time, home-made replication (which works on the standard edition, BTW). Still revolving around the same topics because one of my concerns is to minimize overhead when logging (trigger-happy replication, I am suspicious of the Shareplex approach and anyway as I want to be able to replicate between France, Japan and the US, I cannot afford to transfer full redo logs and transactions I shall have to rollback). I log into several tables (enough info to rebuild statements, and values separately - with additional problems when we reach the 4,000 characters mark), IOTs are the obvious choice but I am not sure it is available with all licenses. Degradation of my logs over timeis also something I have to watch. This is for the days. Evenings are spent improving an intelligent loader able to take into account complex FK relationships. I have prepared two 5,000,000 row tables, one in my 8.1.7 database and one in my 9.0.1 database, but I have not tested anything yet. I had a flash of idiocy and subscribed to the OT list (out of the blues). I doubt I will stay long here. Some people seems to be paid doing nothing but e-mailing. Is this where you got the details about Pierce? Pretty active there. Cheers, Stephane Faroult -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists
RE: SQL Server to Oracle DB
Title: SQL Server to Oracle DB You can use BCP Utility (SQL Server side), to download SQL SERVER data into a flat file (text file) and then you can use SQLLOADER (Oracle Side). I hope it may helps you Best Regards Kamel Benlatreche -Message d'origine-De: Richard Huntley [mailto:[EMAIL PROTECTED]]Envoyé: lundi 20 mai 2002 14:03À: Multiple recipients of list ORACLE-LObjet: SQL Server to Oracle DB Anyone know of an easy way to grab data from tables in an SQL Server DB and insert into tables in an Oracle DB? Thanks.
Re: Numeric comparison in DECODE statement
Yexley Robert D Contr Det 1 AFRL/WSI wrote:
I was wondering if anyone might have tried this before, because I can't seem to get
it to work. I'd like to be able to determine which unit of measure to concatenate to
a value by using a decode statement in the query. I have a column in the database
that stores time in minutes, and I'd like to be able to show the output in minutes if
the value is less than 60, but in hours (such as 3.27 hours) if the value is greater
than 60. So far I've tried the following statement, but it seems to be blowing up on
the first comparison operator:
SELECT decode(in_value, to_char(to_number(in_value) = to_number('60')),
to_char(in_value)||' minutes', to_char(to_number(in_value) to_number('60')),
to_char(in_value/60, '9.99')||' hours')
FROM dual
/
I'm selecting from dual just until I can get the query working at all. Is what I'm
trying to do even possible? Any help or ideas would be greatly appreciated. Thanks
in advance.
_YEX_
Robert,
check function SIGN() in the SQL Reference manual.
--
Regards,
Stephane Faroult
Oriole Software
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Stephane Faroult
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
9i r2
2 of the files downloaded, will be loading it up today,. woohoo, can anyone say crash and burn, bwahahahahahaha joe
Re: Do you ever have days where you dont want to think ?
[EMAIL PROTECTED] wrote: as one of the women in this profession, do I want to know who you consider honorary men? :) What I do want to know is how you determine what the criteria are for being an honorary man. Inquiring minds want to know :) Rachel Well, coming from me 'honorary man' is almost a compliment (also perhaps not totally in the context of nude sunbathing - I would not be totally opposed to chador in some cases on French beaches). What summarizes my thought best, and in a better way than I am able to put it, is probably this : http://www.geocities.com/Broadway/Stage/4575/mflaudrey7.html#A Now I think I'd better run for cover, even if the trouble-and-strife is not on the list ... You asked for it ;-). -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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 Server to Oracle DB
Title: Message If your Oracle platform is Windows, take a look at Heterogeneous Services. I just tried it Friday for the first time to load data from an Excel spreadsheet and it seems to work pretty well. Should work for SQL Server. HTH, Beth -Original Message-From: Richard Huntley [mailto:[EMAIL PROTECTED]] Sent: Monday, May 20, 2002 10:03 AMTo: Multiple recipients of list ORACLE-LSubject: SQL Server to Oracle DB Anyone know of an easy way to grab data from tables in an SQL Server DB and insert into tables in an Oracle DB? Thanks.
RE: SQL Server to Oracle DB
Title: SQL Server to Oracle DB Use the SQLServer DTS package. Under the SQLServer program menu, choose the import/export option, and it will start a Data Transformation Service wizard type thing for you. You can also do SQL transformations and alike as well, by opening the SQL Server Enterprise Manager console, expanding the server that you would like to export the data from, and under the Data Transformations folder, right click on Local Packages and create a new one.. All sorts of options in there, and probably best to hit F1 whilst on the screen.. HTHMark -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Richard HuntleySent: 20 May 2002 15:03To: Multiple recipients of list ORACLE-LSubject: SQL Server to Oracle DB Anyone know of an easy way to grab data from tables in an SQL Server DB and insert into tables in an Oracle DB? Thanks.
Complementary ODTUG 2002 Registrations
as customers, we just received this. Should be open to all: https://www.odtug.com/ssl/2002_reg_iraje.asp Keith __ Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience http://launch.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Keith Peterson INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Do you ever have days where you dont want to think ?
If we told you, we would have to kill you ;P You will need to be a registered user of Yahoo (have a Yahoo logon/password). Go to: http://groups.yahoo.com/group/oracle-l-ot And click join this group. You will then be prompted for info such as how you want to receive the messages etc.. HTH Mark a.k.a Dorothy a.k.a Mutant Metabolism Boy -Original Message- Robert Sent: 20 May 2002 17:34 To: Multiple recipients of list ORACLE-L How does one get on the OT list??? -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Monday, May 20, 2002 10:23 AM To: Multiple recipients of list ORACLE-L as one of the women in this profession, do I want to know who you consider honorary men? :) What I do want to know is how you determine what the criteria are for being an honorary man. Inquiring minds want to know :) Rachel |+--- || | || | || sfaroult@orio| || le.com | || | || 05/18/2002 | || 11:13 AM | || Please | || respond to | || ORACLE-L | || | |+--- | || | To: [EMAIL PROTECTED] | | cc: (bcc: Rachel Carmichael) | | Subject: Re: Do you ever have days where | | you dont want to think ? | | Larry Elkins wrote: The beach part sounds great, though I don't care to see naked men running around ;-) That's the problem in this job. Too many men. And among women, too many are like honorary men. Still preaching the gospel, as you can see :-). In fact, I would be curious to compare the join on the inline-view with a MINUS to the hash anti-join. Assuming all correct indexes, it is comparing two index fast full scans plus sort plus index search to two table full scans (more or less). I am almost certain that many costs could be put into equations. The problem is if you have too many values (number of rows, number of rows returned, storage, selectivity, etc...) to feed into your equations or have trouble deriving these it is not of much use. Wanted to do some tests on reverse indexes, following your posts, but I have not had time. Not much progress on the book PL/SQL chapter either. Currently working on real-time, home-made replication (which works on the standard edition, BTW). Still revolving around the same topics because one of my concerns is to minimize overhead when logging (trigger-happy replication, I am suspicious of the Shareplex approach and anyway as I want to be able to replicate between France, Japan and the US, I cannot afford to transfer full redo logs and transactions I shall have to rollback). I log into several tables (enough info to rebuild statements, and values separately - with additional problems when we reach the 4,000 characters mark), IOTs are the obvious choice but I am not sure it is available with all licenses. Degradation of my logs over timeis also something I have to watch. This is for the days. Evenings are spent improving an intelligent loader able to take into account complex FK relationships. I have prepared two 5,000,000 row tables, one in my 8.1.7 database and one in my 9.0.1 database, but I have not tested anything yet. I had a flash of idiocy and subscribed to the OT list (out of the blues). I doubt I will stay long here. Some people seems to be paid doing nothing but e-mailing. Is this where you got the details about Pierce? Pretty active there. Cheers, Stephane Faroult -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line
Anyone using 8.1.7.4
I have an upgrade of Oracle 7.3.4 on NT. I hear 8.1.7.3 had a lot of bugs. Should I go with 8.1.7.4? Any experience with 8.1.7.4? Ron Smith [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Numeric comparison in DECODE statement
You can also implement your logic as SELECT DECODE(SIGN(in_value-60), -1, TO_CHAR(in_value)||' minutes', TO_CHAR(in_value/60, '9.99')||' hours') FROM dual / HTH 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- Sent: Monday, May 20, 2002 11:38 AM To: Multiple recipients of list ORACLE-L Robert, That won't work. Decode works like a switch statement. If condition 1 then value 1. You can't imbed logic operators therein. DickG. *2 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. *2
RE: Do you ever have days where you dont want to think ?
One makes a large cash offering to the Oracle Goddess... -Original Message- Sent: Monday, May 20, 2002 12:34 PM To: Multiple recipients of list ORACLE-L How does one get on the OT list??? -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Monday, May 20, 2002 10:23 AM To: Multiple recipients of list ORACLE-L as one of the women in this profession, do I want to know who you consider honorary men? :) What I do want to know is how you determine what the criteria are for being an honorary man. Inquiring minds want to know :) Rachel |+--- || | || | || sfaroult@orio| || le.com | || | || 05/18/2002 | || 11:13 AM | || Please | || respond to | || ORACLE-L | || | |+--- | || | To: [EMAIL PROTECTED] | | cc: (bcc: Rachel Carmichael) | | Subject: Re: Do you ever have days where | | you dont want to think ? | | Larry Elkins wrote: The beach part sounds great, though I don't care to see naked men running around ;-) That's the problem in this job. Too many men. And among women, too many are like honorary men. Still preaching the gospel, as you can see :-). In fact, I would be curious to compare the join on the inline-view with a MINUS to the hash anti-join. Assuming all correct indexes, it is comparing two index fast full scans plus sort plus index search to two table full scans (more or less). I am almost certain that many costs could be put into equations. The problem is if you have too many values (number of rows, number of rows returned, storage, selectivity, etc...) to feed into your equations or have trouble deriving these it is not of much use. Wanted to do some tests on reverse indexes, following your posts, but I have not had time. Not much progress on the book PL/SQL chapter either. Currently working on real-time, home-made replication (which works on the standard edition, BTW). Still revolving around the same topics because one of my concerns is to minimize overhead when logging (trigger-happy replication, I am suspicious of the Shareplex approach and anyway as I want to be able to replicate between France, Japan and the US, I cannot afford to transfer full redo logs and transactions I shall have to rollback). I log into several tables (enough info to rebuild statements, and values separately - with additional problems when we reach the 4,000 characters mark), IOTs are the obvious choice but I am not sure it is available with all licenses. Degradation of my logs over timeis also something I have to watch. This is for the days. Evenings are spent improving an intelligent loader able to take into account complex FK relationships. I have prepared two 5,000,000 row tables, one in my 8.1.7 database and one in my 9.0.1 database, but I have not tested anything yet. I had a flash of idiocy and subscribed to the OT list (out of the blues). I doubt I will stay long here. Some people seems to be paid doing nothing but e-mailing. Is this where you got the details about Pierce? Pretty active there. Cheers, Stephane Faroult -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert INET: [EMAIL PROTECTED] Fat
Re:Numeric comparison in DECODE statement
You can do numeric logic by using the SIGN() function. Here is the
solution I think he was looking for:
SQL@sandbox:test:8.1.7:OPS$ORACLE:12,34570r
1 select ltrim(decode(sign(minutes - 59), 1, to_char(minutes/60, '9.99')
||' hours',
2 to_char(minutes)||'
minutes'
3 )
4 ) TIME
5from bart
6* order by minutes
TIME
13 minutes
55 minutes
1.08 hours
3.50 hours
SQL@sandbox:test:8.1.7:OPS$ORACLE:12,34570select * from bart order by 1;
MINUTES
-
13
55
65
210
Brian P. MacLean
Oracle DBA, OCP8i
[EMAIL PROTECTED]
Sent by: To: Multiple recipients of list
ORACLE-L [EMAIL PROTECTED]
[EMAIL PROTECTED] cc:
Subject: Re:Numeric comparison in
DECODE statement
05/20/02 08:38 AM
Please respond to
ORACLE-L
Robert,
That won't work. Decode works like a switch statement. If condition 1
then
value 1. You can't imbed logic operators therein.
DickG.
Reply Separator
Author: Yexley Robert D Contr Det 1 AFRL/WSI [EMAIL PROTECTED]
Date: 5/20/2002 7:08 AM
I was wondering if anyone might have tried this before, because I can't
seem to
get it to work. I'd like to be able to determine which unit of measure to
concatenate to a value by using a decode statement in the query. I have a
column in the database that stores time in minutes, and I'd like to be able
to
show the output in minutes if the value is less than 60, but in hours (such
as
3.27 hours) if the value is greater than 60. So far I've tried the
following
statement, but it seems to be blowing up on the first comparison operator:
SELECT decode(in_value, to_char(to_number(in_value) = to_number('60')),
to_char(in_value)||' minutes', to_char(to_number(in_value) to_number
('60')),
to_char(in_value/60, '9.99')||' hours')
FROM dual
/
I'm selecting from dual just until I can get the query working at all. Is
what
I'm trying to do even possible? Any help or ideas would be greatly
appreciated.
Thanks in advance.
_YEX_
/*
|| Robert D. Yexley
|| Oracle Programmer/Analyst
|| Easylink Services Corporation
|| Professional Services
|| Contractor - Wright Research Site MIS
|| Det-1 AFRL/WSI Bldg. 45 Rm. 062
|| (937) 255-1984
|| [EMAIL PROTECTED]
|| )))
*/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Yexley Robert D Contr Det 1 AFRL/WSI
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the
Re: Upgrade and it says it doesn't need it
log a tar... sorry... - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, May 20, 2002 8:58 AM Unfortunately - this is what I'm having a problem with. I did install with OUI. The log files from that installation are in the oraInventory directory. Subsequently, I installed some client software (precompilers) on the machine. The oraInventory only shows the client installation, not the real server. And...I have confirmed - the oraInst.loc file does correctly point to the oraInventory directory. It just looks as though the installer process didn't update the oraInventory correctly. Now I'm afraid I'm Screwed on the upgrade! -Original Message- Sent: Saturday, May 18, 2002 9:58 AM To: Multiple recipients of list ORACLE-L I'm guessing that the 9.0.1.0 server software was not installed using the Oracle installer? Did you tar it over from somewhere else? For a server installed using the installer, you'll find a file in /var/opt/oracle named oraInst.loc, which contains the name of the directory containing the Oracle Universal Installer's oraInventory directory. Your installer running the 9.0.1.2 patch is checking for that file in /var/opt/oracle and probably not finding it. Or, it is finding it and the oraInventory directory, but the inventory says that only the client has been installed... - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, May 17, 2002 3:38 PM HI - I'm trying to upgrade my database from 9.0.1.0 to 9.0.1.2 (Sun Solaris). The installer tells me there are no files that need to be applied. When I click on installed products, under 9i it only show the client install, not the enterprise edition server. Does anyone know what I can do to get the installer to realize that I do have the server installed? Thank you - Lisa -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: YTTRI Lisa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: YTTRI Lisa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: What makes Export slow ?
Would you post the parameter file ?? Huge Buffer, commit=y, direct=y, assigning the big rollback segment should help you to have faster export , and also you can have a look at the DISK I/O stats ( verify the OFA is same on both the boxes ). Thanks, Madhu -Original Message- Sent: Monday, May 20, 2002 3:43 AM To: Multiple recipients of list ORACLE-L Hi guys, I moved my database from Solaris 7 to Solaris 8 box (Sun Fire 4800, faster processors and more memory space) I create the database with the same script that I used to for my database in the older machine, When I export my database from the older machine it was very fast and when I import to newer machine it was fast too, and when I export from new machine it is really slow (very slow), (I am using same export parameters in both servers) Can someone help with tuning tips or anything you have... : ( - The no of records are the same for both machines - v$session_wait.seconds_in_wait is more than 1 Thank you -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy Xing INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Reddy, Madhusudana INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Do you ever have days where you dont want to think ?
oh I never said it was an honor to be considered a man. --- Ruth Gramolini [EMAIL PROTECTED] wrote: This inquiring mind want's to know, what is honorary about being thought of as a man instead of the women you are? Ruth. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, May 20, 2002 10:23 AM as one of the women in this profession, do I want to know who you consider honorary men? :) What I do want to know is how you determine what the criteria are for being an honorary man. Inquiring minds want to know :) Rachel |+--- || | || | || sfaroult@orio| || le.com | || | || 05/18/2002 | || 11:13 AM | || Please | || respond to | || ORACLE-L | || | |+--- | || | To: [EMAIL PROTECTED] | | cc: (bcc: Rachel Carmichael) | | Subject: Re: Do you ever have days where | | you dont want to think ? | | Larry Elkins wrote: The beach part sounds great, though I don't care to see naked men running around ;-) That's the problem in this job. Too many men. And among women, too many are like honorary men. Still preaching the gospel, as you can see :-). In fact, I would be curious to compare the join on the inline-view with a MINUS to the hash anti-join. Assuming all correct indexes, it is comparing two index fast full scans plus sort plus index search to two table full scans (more or less). I am almost certain that many costs could be put into equations. The problem is if you have too many values (number of rows, number of rows returned, storage, selectivity, etc...) to feed into your equations or have trouble deriving these it is not of much use. Wanted to do some tests on reverse indexes, following your posts, but I have not had time. Not much progress on the book PL/SQL chapter either. Currently working on real-time, home-made replication (which works on the standard edition, BTW). Still revolving around the same topics because one of my concerns is to minimize overhead when logging (trigger-happy replication, I am suspicious of the Shareplex approach and anyway as I want to be able to replicate between France, Japan and the US, I cannot afford to transfer full redo logs and transactions I shall have to rollback). I log into several tables (enough info to rebuild statements, and values separately - with additional problems when we reach the 4,000 characters mark), IOTs are the obvious choice but I am not sure it is available with all licenses. Degradation of my logs over timeis also something I have to watch. This is for the days. Evenings are spent improving an intelligent loader able to take into account complex FK relationships. I have prepared two 5,000,000 row tables, one in my 8.1.7 database and one in my 9.0.1 database, but I have not tested anything yet. I had a flash of idiocy and subscribed to the OT list (out of the blues). I doubt I will stay long here. Some people seems to be paid doing nothing but e-mailing. Is this where you got the details about Pierce? Pretty active there. Cheers, Stephane Faroult -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or
wait event trace file formatter?
I'm looking for a way to format a trace file produced by event 10046 trace name context forever,level 8 (this dumps all wait events to a file). Has anyone written such a formatter, or have information on one? Thanks. = Paul Baumgartel, Adept Computer Associates, Inc. [EMAIL PROTECTED] __ Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience http://launch.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Do you ever have days where you dont want to think ?
it's joe's list --- Grabowy, Chris [EMAIL PROTECTED] wrote: One makes a large cash offering to the Oracle Goddess... -Original Message- Sent: Monday, May 20, 2002 12:34 PM To: Multiple recipients of list ORACLE-L How does one get on the OT list??? -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Monday, May 20, 2002 10:23 AM To: Multiple recipients of list ORACLE-L as one of the women in this profession, do I want to know who you consider honorary men? :) What I do want to know is how you determine what the criteria are for being an honorary man. Inquiring minds want to know :) Rachel |+--- || | || | || sfaroult@orio| || le.com | || | || 05/18/2002 | || 11:13 AM | || Please | || respond to | || ORACLE-L | || | |+--- | || | To: [EMAIL PROTECTED] | | cc: (bcc: Rachel Carmichael) | | Subject: Re: Do you ever have days where | | you dont want to think ? | | Larry Elkins wrote: The beach part sounds great, though I don't care to see naked men running around ;-) That's the problem in this job. Too many men. And among women, too many are like honorary men. Still preaching the gospel, as you can see :-). In fact, I would be curious to compare the join on the inline-view with a MINUS to the hash anti-join. Assuming all correct indexes, it is comparing two index fast full scans plus sort plus index search to two table full scans (more or less). I am almost certain that many costs could be put into equations. The problem is if you have too many values (number of rows, number of rows returned, storage, selectivity, etc...) to feed into your equations or have trouble deriving these it is not of much use. Wanted to do some tests on reverse indexes, following your posts, but I have not had time. Not much progress on the book PL/SQL chapter either. Currently working on real-time, home-made replication (which works on the standard edition, BTW). Still revolving around the same topics because one of my concerns is to minimize overhead when logging (trigger-happy replication, I am suspicious of the Shareplex approach and anyway as I want to be able to replicate between France, Japan and the US, I cannot afford to transfer full redo logs and transactions I shall have to rollback). I log into several tables (enough info to rebuild statements, and values separately - with additional problems when we reach the 4,000 characters mark), IOTs are the obvious choice but I am not sure it is available with all licenses. Degradation of my logs over timeis also something I have to watch. This is for the days. Evenings are spent improving an intelligent loader able to take into account complex FK relationships. I have prepared two 5,000,000 row tables, one in my 8.1.7 database and one in my 9.0.1 database, but I have not tested anything yet. I had a flash of idiocy and subscribed to the OT list (out of the blues). I doubt I will stay long here. Some people seems to be paid doing nothing but e-mailing. Is this where you got the details about Pierce? Pretty active there. Cheers, Stephane Faroult -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed
Re: SQL Server to Oracle DB
Title: SQL Server to Oracle DB ...speaking of $0.02, make sure that the utilityfrom SQL Server that produces the "flat" file does not perform unsolicited rounding of numerics. I was recently burned on a Sybase-Oracle conversion when the BCP (a.k.a. "bulk copy") and ISQL (a.k.a. SQL*Plus in Sybase) utilities each implicitly round numeric data to the 2nd digit to the right of the decimal. Since SQL Server comes from Sybase, beware... In ISQL, I could just divide everything by 1. to get the true precision, but BCP doesn't provide that option. Instead,Iwrote a shell script to query the Sybase data dictionary to generate the "C" program sources for each table. The Sybase APIs were perfectly capable of handling numeric precision, but the %^#* Sybase developers who wrote ISQL and BCP were too lazy to use them correctly. Since the ODBC driver from MS-Access seemed to use the API correctly (i.e. no implicit rounding seen), then maybe the MS folks are more diligent... Just FYI... - Original Message - From: KENNETH JANUSZ To: Multiple recipients of list ORACLE-L Sent: Monday, May 20, 2002 9:08 AM Subject: Re: SQL Server to Oracle DB Richard: Yes. The way I've done it in the past is to generate tilde (~) delimited flat files and then load the data into Oracle via SQL*Loader. You have to do a mapping first before using SQL*Loader. Then you have to write scripts for each table you are loading. I recommend the O'Reilly book Oracle SQL*Loader, The Definitive Guide. This is a process that can take time especially if the Oracle application needs data that the old legacy DB doesn't provide. My $0.02 worth, Ken Janusz, CPIM - Original Message - From: Richard Huntley To: Multiple recipients of list ORACLE-L Sent: Monday, May 20, 2002 9:03 AM Subject: SQL Server to Oracle DB Anyone know of an easy way to grab data from tables in an SQL Server DB and insert into tables in an Oracle DB? Thanks.
RE: Oracle web application
Aida - Now that you have described your situation more clearly, I would second the advice you received from Sean - use PHP if you can. While this task can be accomplished with just about any language, with some choices you will spend a lot of time getting everything set up. And you probably would have to use more than one language to accomplish some aspects. PHP was pretty much designed for quick Web pages and database interactivity. Some people here have been very successful with it. As a bonus, it sounds like you are already pretty accomplished in PHP. May the force be with you! (guess which movie I saw this weekend). Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, May 20, 2002 10:29 AM To: Multiple recipients of list ORACLE-L Hi Dennis, my name is Aida, (my fault about this) Keith is my husband (I love to bother him). Thank you for answering to me, I really appreciate it. Let me explain more clear the situation. I am a graduate student at Stephen F. Austin State University in computer science department. I will graduate next summer. As part of my graduation the department has assigned me the project of Computer Science Programming Contest that is done every year. The way the contest is organized is this: There is a web site in which the student can register in teams of 3 or 4, they need to give their info (first name, last name, phone, class, address, for each member, the name of the team) and a user name and password is assigned to each team so they can come back and change it at any time. At the contest day, to each time is given their account on TITANS and password and directions how they can send their answers back by mail form their account to the jury. Every team-member can program in C, C++ or COBOL (languages that are taught at our university). After the e-mail is sent, the judge sends back the result of the answer. The way that is done until last time is this. A faculty member used the PHP to make the registration and humans do all the other part. (this is what they want to avoid mainly and this time I think they are going to use also UNIX accounts for students) I took an oracle class (is the first time that is offered) this spring and they assigned me to do this project using oracle. I have learned SQL and PL/SQL and some of the basics of Oracle. I have designed some web sites before with forms, but never any one in interaction with the user and a database. That's why I need help for basically everything. (even for the general concept). Should I still use PHP or is there any better choice? This is my first big question right now but to tell you the truth I have everything under question mark. But one thing at a time and I am hunting around to get more comfortable with this problem. Thank you very much for your time AIDA - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Sunday, May 19, 2002 9:03 PM Keith - Usually you need to create some sort of application that will respond to user requests, extract data from Oracle, and format an HTML page to send back to the user. That is basically what you described in your email. How that program interfaces to Oracle will depend on what programming language you choose. Usually your program is executed by a software called a web server or an application server. Before you need to worry about Oracle, you need to learn a lot more about Web programming. If by web you mean the Internet, then you also need to learn about Web security. If your application is within your company intranet, then this concern isn't so significant. Suggestions: Find someone in your company that is an experienced Web programmer, and discuss your situation with them. That will teach you a lot quicker. Go to http://www.google.com, and type terms like HTML Tutorial. A good site I found was http://www.mcli.dist.maricopa.edu/tut/. This won't teach you about connecting to a database, but you've got learn the basics before you progress on to advanced topics. http://www.computerworld.com/departments/technology/quickstudies offers explanations of some of the important concepts so simple even a manager can understand. If you encounter more specific questions, write back Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Saturday, May 18, 2002 11:43 AM To: Multiple recipients of list ORACLE-L hi, I am a beginner in Oracle and I need help. I need to implement a interactive connection of oracle with web. I need to save data from web to database, make a kind of processing and send a response to the web. I have no idea even how to make the implementation. Can somebody help me ? Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Keith Carney INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California
RE: Do you ever have days where you dont want to think ?
All you men on this list really need to get out more!! ;-) -Original Message- Sent: Monday, May 20, 2002 12:39 PM To: Multiple recipients of list ORACLE-L we want jpegs !!! :-) -Original Message- Sent: 20 May 2002 17:03 To: Multiple recipients of list ORACLE-L Hehe... I was thinking the same thing and decided not to pursue! Thanks for stepping up to make that request. I don't look like a man, I don't feel like a man, have never been called one of the guys Just curious too... This is interesting! Melanie Burns -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Monday, May 20, 2002 9:23 AM To: Multiple recipients of list ORACLE-L as one of the women in this profession, do I want to know who you consider honorary men? :) What I do want to know is how you determine what the criteria are for being an honorary man. Inquiring minds want to know :) Rachel |+--- || | || | || sfaroult@orio| || le.com | || | || 05/18/2002 | || 11:13 AM | || Please | || respond to | || ORACLE-L | || | |+--- | || | To: [EMAIL PROTECTED] | | cc: (bcc: Rachel Carmichael) | | Subject: Re: Do you ever have days where | | you dont want to think ? | | Larry Elkins wrote: The beach part sounds great, though I don't care to see naked men running around ;-) That's the problem in this job. Too many men. And among women, too many are like honorary men. Still preaching the gospel, as you can see :-). In fact, I would be curious to compare the join on the inline-view with a MINUS to the hash anti-join. Assuming all correct indexes, it is comparing two index fast full scans plus sort plus index search to two table full scans (more or less). I am almost certain that many costs could be put into equations. The problem is if you have too many values (number of rows, number of rows returned, storage, selectivity, etc...) to feed into your equations or have trouble deriving these it is not of much use. Wanted to do some tests on reverse indexes, following your posts, but I have not had time. Not much progress on the book PL/SQL chapter either. Currently working on real-time, home-made replication (which works on the standard edition, BTW). Still revolving around the same topics because one of my concerns is to minimize overhead when logging (trigger-happy replication, I am suspicious of the Shareplex approach and anyway as I want to be able to replicate between France, Japan and the US, I cannot afford to transfer full redo logs and transactions I shall have to rollback). I log into several tables (enough info to rebuild statements, and values separately - with additional problems when we reach the 4,000 characters mark), IOTs are the obvious choice but I am not sure it is available with all licenses. Degradation of my logs over timeis also something I have to watch. This is for the days. Evenings are spent improving an intelligent loader able to take into account complex FK relationships. I have prepared two 5,000,000 row tables, one in my 8.1.7 database and one in my 9.0.1 database, but I have not tested anything yet. I had a flash of idiocy and subscribed to the OT list (out of the blues). I doubt I will stay long here. Some people seems to be paid doing nothing but e-mailing. Is this where you got the details about Pierce? Pretty active there. Cheers, Stephane Faroult -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT
Re: wait event trace file formatter?
Hi: Check 'itprof' at http://www.ubtools.com or 'Sparky' at http://www.hotsos.com I have used the first one found very good. --- Paul Baumgartel [EMAIL PROTECTED] wrote: I'm looking for a way to format a trace file produced by event 10046 trace name context forever,level 8 (this dumps all wait events to a file). Has anyone written such a formatter, or have information on one? Thanks. = Have a nice day !! Best Regards, K Gopalakrishnan, Bangalore, INDIA. __ Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience http://launch.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: K Gopalakrishnan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ORA-01722 Error after DBA changes
Hi,
Not sure about exact reason. But I am also having similar condition like
yours. One of my customers was running 8.1.5 with Forms5. I upgraded his DB
to 8.1.7. And I started facing problem with some reports. I got answer from
Oracle saying - this combination is not certified. Oracle has done lots of
changes in Timestamp in 8.1.7 DB.
Not very sure, but just check whether Forms 6i is certified on 8.1.6 and
7.3.4 or not.
Recompilation of all forms and reports can be done by using project builder.
But I'll prefer some DOS BATCH script.
Create a file with .bat extension and put following line run it
FOR %%I IN (*.FMB) DO {YOUR ORACLE HOME}\BIN\ifcmp60 %%I username/password
End of script*
Same logic you can apply for recompiling reports.
HTH,
Sandeep.
-Original Message-
Sent: Monday, May 20, 2002 7:14 PM
To: Multiple recipients of list ORACLE-L
Subject:ORA-01722 Error after DBA changes
I have been getting a FRM-40735 WHEN-BUTTON-PRESSED trigger raised
unhandled exception ORA-01722 error. The button calls a procedure in
the form. Whenever this happens, I open up the form in Developer,
recompile it, generate a new .fmx file and everything works fine. In
other words, no changes, just recompilling. Do you have any idea why
this might be happening?
It seems to have started happening after I made some changes to the
database. I was dropping and recreating some tables in order to change
size parameters and also change privileges. Could this have had
anything do with the ORA-1722 error?
Right now, I know the fix but I am curious why I have to recompile
everything. This is with Developer 6i (6.0.8.10.3) and Oracle 7.3.4.
but it also happens against my Oracle 8.1.6 test database.
When I asked this question to Oracle support, they replied that it was
because by changing the database objects, the timestamp gets changed.
But this does not make sense to me since these forms are not being
stored in the database. It also seems to me that of the forms that are
dependant of the tables that I changed, some have problems and others
do not. Also, I suppose if this is true, I will have to recomplile
all of my reports also. Anyone have hints or scripts that I might run
to help me narrow down so that I do not have to recompile ALL forms
and reports?
TIA, Wayne
[EMAIL PROTECTED]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: McGill, Wayne L
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Sandeep Kurliye
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
RE: What makes Export slow ?
On Mon, 20 May 2002, Reddy, Madhusudana wrote: Huge Buffer, commit=y, direct=y, assigning the big rollback segment should help you to have faster export , What do you mean assigning the big rollback segment? How do you do that to an export and what does it accomplish? What does COMMIT=Y do in an export? If I were the original poster, I'd just look at v$session_event for the export session after several minutes of slowness. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton -Original Message- Sent: Monday, May 20, 2002 3:43 AM To: Multiple recipients of list ORACLE-L I moved my database from Solaris 7 to Solaris 8 box (Sun Fire 4800, faster processors and more memory space) I create the database with the same script that I used to for my database in the older machine, When I export my database from the older machine it was very fast and when I import to newer machine it was fast too, and when I export from new machine it is really slow (very slow), (I am using same export parameters in both servers) Can someone help with tuning tips or anything you have... : ( - The no of records are the same for both machines - v$session_wait.seconds_in_wait is more than 1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
TEMP TABLESPACE
Hi List, I have two data files for my TEMP tablespace, i just find out one of the data file AUTO EXTEND is set to on is it right?? I beleive for TEMP tablespace autoextend shoudn't be ON, AM I RIGHT or NOT? Now my data file almost full for TEMP tablespace how can I Clean it up, I run ALTER TABLESPACE TEMP COALESCE BUT STILL DATA FILE IS FULL ORACLE 8.1.7.0 ON SUN SOLARIS \THANKS ALLOT Hamid Alavi Office 818 737-0526 Cell818 402-1987 === Confidentiality Statement === The information contained in this message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from disclosure under applicable law. If you have received this message in error, you are prohibited from copying, distributing, or using the information. Please contact the sender immediately by return e-mail and delete the original message from your system. = End Confidentiality Statement = -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hamid Alavi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Do you ever have days where you dont want to think ?
But the original poster and some of the others seem to think that this would be an honor...RBG - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, May 20, 2002 1:33 PM oh I never said it was an honor to be considered a man. --- Ruth Gramolini [EMAIL PROTECTED] wrote: This inquiring mind want's to know, what is honorary about being thought of as a man instead of the women you are? Ruth. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, May 20, 2002 10:23 AM as one of the women in this profession, do I want to know who you consider honorary men? :) What I do want to know is how you determine what the criteria are for being an honorary man. Inquiring minds want to know :) Rachel |+--- || | || | || sfaroult@orio| || le.com | || | || 05/18/2002 | || 11:13 AM | || Please | || respond to | || ORACLE-L | || | |+--- | || | To: [EMAIL PROTECTED] | | cc: (bcc: Rachel Carmichael) | | Subject: Re: Do you ever have days where | | you dont want to think ? | | Larry Elkins wrote: The beach part sounds great, though I don't care to see naked men running around ;-) That's the problem in this job. Too many men. And among women, too many are like honorary men. Still preaching the gospel, as you can see :-). In fact, I would be curious to compare the join on the inline-view with a MINUS to the hash anti-join. Assuming all correct indexes, it is comparing two index fast full scans plus sort plus index search to two table full scans (more or less). I am almost certain that many costs could be put into equations. The problem is if you have too many values (number of rows, number of rows returned, storage, selectivity, etc...) to feed into your equations or have trouble deriving these it is not of much use. Wanted to do some tests on reverse indexes, following your posts, but I have not had time. Not much progress on the book PL/SQL chapter either. Currently working on real-time, home-made replication (which works on the standard edition, BTW). Still revolving around the same topics because one of my concerns is to minimize overhead when logging (trigger-happy replication, I am suspicious of the Shareplex approach and anyway as I want to be able to replicate between France, Japan and the US, I cannot afford to transfer full redo logs and transactions I shall have to rollback). I log into several tables (enough info to rebuild statements, and values separately - with additional problems when we reach the 4,000 characters mark), IOTs are the obvious choice but I am not sure it is available with all licenses. Degradation of my logs over timeis also something I have to watch. This is for the days. Evenings are spent improving an intelligent loader able to take into account complex FK relationships. I have prepared two 5,000,000 row tables, one in my 8.1.7 database and one in my 9.0.1 database, but I have not tested anything yet. I had a flash of idiocy and subscribed to the OT list (out of the blues). I doubt I will stay long here. Some people seems to be paid doing nothing but e-mailing. Is this where you got the details about Pierce? Pretty active there. Cheers, Stephane Faroult -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858)
RE: Do you ever have days where you dont want to think ?
What is 'get out more'? -Original Message- Sent: Monday, May 20, 2002 12:39 PM To: Multiple recipients of list ORACLE-L All you men on this list really need to get out more!! ;-) -Original Message- Sent: Monday, May 20, 2002 12:39 PM To: Multiple recipients of list ORACLE-L we want jpegs !!! :-) -Original Message- Sent: 20 May 2002 17:03 To: Multiple recipients of list ORACLE-L Hehe... I was thinking the same thing and decided not to pursue! Thanks for stepping up to make that request. I don't look like a man, I don't feel like a man, have never been called one of the guys Just curious too... This is interesting! Melanie Burns -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Monday, May 20, 2002 9:23 AM To: Multiple recipients of list ORACLE-L as one of the women in this profession, do I want to know who you consider honorary men? :) What I do want to know is how you determine what the criteria are for being an honorary man. Inquiring minds want to know :) Rachel |+--- || | || | || sfaroult@orio| || le.com | || | || 05/18/2002 | || 11:13 AM | || Please | || respond to | || ORACLE-L | || | |+--- | || | To: [EMAIL PROTECTED] | | cc: (bcc: Rachel Carmichael) | | Subject: Re: Do you ever have days where | | you dont want to think ? | | Larry Elkins wrote: The beach part sounds great, though I don't care to see naked men running around ;-) That's the problem in this job. Too many men. And among women, too many are like honorary men. Still preaching the gospel, as you can see :-). In fact, I would be curious to compare the join on the inline-view with a MINUS to the hash anti-join. Assuming all correct indexes, it is comparing two index fast full scans plus sort plus index search to two table full scans (more or less). I am almost certain that many costs could be put into equations. The problem is if you have too many values (number of rows, number of rows returned, storage, selectivity, etc...) to feed into your equations or have trouble deriving these it is not of much use. Wanted to do some tests on reverse indexes, following your posts, but I have not had time. Not much progress on the book PL/SQL chapter either. Currently working on real-time, home-made replication (which works on the standard edition, BTW). Still revolving around the same topics because one of my concerns is to minimize overhead when logging (trigger-happy replication, I am suspicious of the Shareplex approach and anyway as I want to be able to replicate between France, Japan and the US, I cannot afford to transfer full redo logs and transactions I shall have to rollback). I log into several tables (enough info to rebuild statements, and values separately - with additional problems when we reach the 4,000 characters mark), IOTs are the obvious choice but I am not sure it is available with all licenses. Degradation of my logs over timeis also something I have to watch. This is for the days. Evenings are spent improving an intelligent loader able to take into account complex FK relationships. I have prepared two 5,000,000 row tables, one in my 8.1.7 database and one in my 9.0.1 database, but I have not tested anything yet. I had a flash of idiocy and subscribed to the OT list (out of the blues). I doubt I will stay long here. Some people seems to be paid doing nothing but e-mailing. Is this where you got the details about Pierce? Pretty active there. Cheers, Stephane Faroult -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists
OT: Ray Lane sighting
Check out http://www.dominionpost.com Denise Gwinn [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
off topic list
send an email to [EMAIL PROTECTED] be prepared for a LOT of chatter it's being used more like a chat room than a bulletin board/email list. We started it on Sept 13 last year and are over 20,000 messages already. on the other hand, the chatter tends to be either funny, informative or thought-provoking. And in general, a short break from the insanity of work. the only rules on the list are: 1) no spewing hatred, unless it is hate mail directed towards a large purple dinosaur named Barney. 2) no Oracle discussions, that's what this list is for. Joe owns it, I moderate it, and we tend to let people say what they want. Discussions have shown that people have very diverse opinions on a number of subjects, but the discussion remains polite. Rachel --- Grabowy, Chris [EMAIL PROTECTED] wrote: One makes a large cash offering to the Oracle Goddess... -Original Message- Sent: Monday, May 20, 2002 12:34 PM To: Multiple recipients of list ORACLE-L How does one get on the OT list??? -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Monday, May 20, 2002 10:23 AM To: Multiple recipients of list ORACLE-L as one of the women in this profession, do I want to know who you consider honorary men? :) What I do want to know is how you determine what the criteria are for being an honorary man. Inquiring minds want to know :) Rachel |+--- || | || | || sfaroult@orio| || le.com | || | || 05/18/2002 | || 11:13 AM | || Please | || respond to | || ORACLE-L | || | |+--- | || | To: [EMAIL PROTECTED] | | cc: (bcc: Rachel Carmichael) | | Subject: Re: Do you ever have days where | | you dont want to think ? | | Larry Elkins wrote: The beach part sounds great, though I don't care to see naked men running around ;-) That's the problem in this job. Too many men. And among women, too many are like honorary men. Still preaching the gospel, as you can see :-). In fact, I would be curious to compare the join on the inline-view with a MINUS to the hash anti-join. Assuming all correct indexes, it is comparing two index fast full scans plus sort plus index search to two table full scans (more or less). I am almost certain that many costs could be put into equations. The problem is if you have too many values (number of rows, number of rows returned, storage, selectivity, etc...) to feed into your equations or have trouble deriving these it is not of much use. Wanted to do some tests on reverse indexes, following your posts, but I have not had time. Not much progress on the book PL/SQL chapter either. Currently working on real-time, home-made replication (which works on the standard edition, BTW). Still revolving around the same topics because one of my concerns is to minimize overhead when logging (trigger-happy replication, I am suspicious of the Shareplex approach and anyway as I want to be able to replicate between France, Japan and the US, I cannot afford to transfer full redo logs and transactions I shall have to rollback). I log into several tables (enough info to rebuild statements, and values separately - with additional problems when we reach the 4,000 characters mark), IOTs are the obvious choice but I am not sure it is available with all licenses. Degradation of my logs over timeis also something I have to watch. This is for the days. Evenings are spent improving an intelligent loader able to take into account complex FK relationships. I have prepared two 5,000,000 row tables, one in my 8.1.7 database and one in my 9.0.1 database, but I have not tested anything yet. I had a flash of idiocy and subscribed to the OT list (out of the blues). I doubt I will stay long here. Some people seems to be paid doing nothing but e-mailing. Is this where you got the details about Pierce? Pretty active there. Cheers, Stephane Faroult -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line
Re: Errors on Alert file
It was Abby something. Abby who? Abby...Abby Normal that's it. On Mon, May 20, 2002 at 06:38:25AM -0800, Nirmal Kumar Muthu Kumaran wrote: ORA-00602 ORA-00602internal programming exception Cause:An internal programming exception has occurred. Action:Report this error as a program bug to Worldwide Customer Support. nirmal. -Original Message- From: GL2Z/ INF DBA BENLATRECHE [SMTP:[EMAIL PROTECTED]] Sent: 09 ÑÈíÚ ÇáÇæá, 1423 02:33 PM To: Multiple recipients of list ORACLE-L Subject:Errors on Alert file Hi All, Is it normal that after a shutdown immediate of a database (Oracle 8.1.7), Errors (Ora-602) are still generated on the Instance Alert file ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: GL2Z/ INF DBA BENLATRECHE INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: wait event trace file formatter?
Tkprof ?? I was just reading 9iR2 notes and it seems there is a new parameter for tkprof 'wait events' that will list waits (if available) in the file per cursor, very useful feature. 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- Sent: Monday, May 20, 2002 1:03 PM To: Multiple recipients of list ORACLE-L I'm looking for a way to format a trace file produced by event 10046 trace name context forever,level 8 (this dumps all wait events to a file). Has anyone written such a formatter, or have information on one? Thanks. = Paul Baumgartel, Adept Computer Associates, Inc. [EMAIL PROTECTED] __ Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience http://launch.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). ***1 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 ESPN at (860) 766-2000 and delete this e-mail message from your computer, Thank you. ***1
RE: wait event trace file formatter?
If you are on 9i, tkprof now includes that functionality. Otherwise hotsos.com is one of the source for such a tool. Mohammed Ahsanuddin Oracle DBA -Original Message- Sent: Monday, May 20, 2002 1:04 PM To: Multiple recipients of list ORACLE-L I'm looking for a way to format a trace file produced by event 10046 trace name context forever,level 8 (this dumps all wait events to a file). Has anyone written such a formatter, or have information on one? Thanks. = Paul Baumgartel, Adept Computer Associates, Inc. [EMAIL PROTECTED] __ Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience http://launch.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Do you ever have days where you dont want to think ?
Sigh no more, ladies, sigh nor more; Men were deceivers ever; One foot in sea and one on shore, To one thing constant never; Then sigh not so, But let them go, And be you blithe and bonny; Converting all your sounds of woe Into. Hey nonny, nonny. Sing no more ditties, sing no mo, Or dumps so dull and heavy; The fraud of men was ever so, Since summer first was leavy. Then sigh not so, But let them go, And be you blithe and bonny, Converting all your sounds of woe Into. Hey, nonny, nonny. Thank you, Paul Sherman DBAElcom, Inc. email - [EMAIL PROTECTED] -Original Message- Sent: Monday, May 20, 2002 1:34 PM To: Multiple recipients of list ORACLE-L oh I never said it was an honor to be considered a man. --- Ruth Gramolini [EMAIL PROTECTED] wrote: This inquiring mind want's to know, what is honorary about being thought of as a man instead of the women you are? Ruth. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, May 20, 2002 10:23 AM as one of the women in this profession, do I want to know who you consider honorary men? :) What I do want to know is how you determine what the criteria are for being an honorary man. Inquiring minds want to know :) Rachel |+--- || | || | || sfaroult@orio| || le.com | || | || 05/18/2002 | || 11:13 AM | || Please | || respond to | || ORACLE-L | || | |+--- | || | To: [EMAIL PROTECTED] | | cc: (bcc: Rachel Carmichael) | | Subject: Re: Do you ever have days where | | you dont want to think ? | | Larry Elkins wrote: The beach part sounds great, though I don't care to see naked men running around ;-) That's the problem in this job. Too many men. And among women, too many are like honorary men. Still preaching the gospel, as you can see :-). In fact, I would be curious to compare the join on the inline-view with a MINUS to the hash anti-join. Assuming all correct indexes, it is comparing two index fast full scans plus sort plus index search to two table full scans (more or less). I am almost certain that many costs could be put into equations. The problem is if you have too many values (number of rows, number of rows returned, storage, selectivity, etc...) to feed into your equations or have trouble deriving these it is not of much use. Wanted to do some tests on reverse indexes, following your posts, but I have not had time. Not much progress on the book PL/SQL chapter either. Currently working on real-time, home-made replication (which works on the standard edition, BTW). Still revolving around the same topics because one of my concerns is to minimize overhead when logging (trigger-happy replication, I am suspicious of the Shareplex approach and anyway as I want to be able to replicate between France, Japan and the US, I cannot afford to transfer full redo logs and transactions I shall have to rollback). I log into several tables (enough info to rebuild statements, and values separately - with additional problems when we reach the 4,000 characters mark), IOTs are the obvious choice but I am not sure it is available with all licenses. Degradation of my logs over timeis also something I have to watch. This is for the days. Evenings are spent improving an intelligent loader able to take into account complex FK relationships. I have prepared two 5,000,000 row tables, one in my 8.1.7 database and one in my 9.0.1 database, but I have not tested anything yet. I had a flash of idiocy and subscribed to the OT list (out of the blues). I doubt I will stay long here. Some people seems to be paid doing nothing but e-mailing. Is this where you got the details about Pierce? Pretty active there. Cheers, Stephane Faroult -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the
Re: wait event trace file formatter?
ITRPROF from http://www.ubtools.com/products/itrprof/itrprof.html and I believe that www.hotsos.com has a new 10046 trace analyzer as well... - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, May 20, 2002 11:03 AM I'm looking for a way to format a trace file produced by event 10046 trace name context forever,level 8 (this dumps all wait events to a file). Has anyone written such a formatter, or have information on one? Thanks. = Paul Baumgartel, Adept Computer Associates, Inc. [EMAIL PROTECTED] __ Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience http://launch.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Do you ever have days where you dont want to think ?
Yeah, so. I would think for the right amount of money, he would put on a wig and dress... -Original Message- Sent: Monday, May 20, 2002 1:54 PM To: Multiple recipients of list ORACLE-L it's joe's list --- Grabowy, Chris [EMAIL PROTECTED] wrote: One makes a large cash offering to the Oracle Goddess... -Original Message- Sent: Monday, May 20, 2002 12:34 PM To: Multiple recipients of list ORACLE-L How does one get on the OT list??? -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Monday, May 20, 2002 10:23 AM To: Multiple recipients of list ORACLE-L as one of the women in this profession, do I want to know who you consider honorary men? :) What I do want to know is how you determine what the criteria are for being an honorary man. Inquiring minds want to know :) Rachel |+--- || | || | || sfaroult@orio| || le.com | || | || 05/18/2002 | || 11:13 AM | || Please | || respond to | || ORACLE-L | || | |+--- | || | To: [EMAIL PROTECTED] | | cc: (bcc: Rachel Carmichael) | | Subject: Re: Do you ever have days where | | you dont want to think ? | | Larry Elkins wrote: The beach part sounds great, though I don't care to see naked men running around ;-) That's the problem in this job. Too many men. And among women, too many are like honorary men. Still preaching the gospel, as you can see :-). In fact, I would be curious to compare the join on the inline-view with a MINUS to the hash anti-join. Assuming all correct indexes, it is comparing two index fast full scans plus sort plus index search to two table full scans (more or less). I am almost certain that many costs could be put into equations. The problem is if you have too many values (number of rows, number of rows returned, storage, selectivity, etc...) to feed into your equations or have trouble deriving these it is not of much use. Wanted to do some tests on reverse indexes, following your posts, but I have not had time. Not much progress on the book PL/SQL chapter either. Currently working on real-time, home-made replication (which works on the standard edition, BTW). Still revolving around the same topics because one of my concerns is to minimize overhead when logging (trigger-happy replication, I am suspicious of the Shareplex approach and anyway as I want to be able to replicate between France, Japan and the US, I cannot afford to transfer full redo logs and transactions I shall have to rollback). I log into several tables (enough info to rebuild statements, and values separately - with additional problems when we reach the 4,000 characters mark), IOTs are the obvious choice but I am not sure it is available with all licenses. Degradation of my logs over timeis also something I have to watch. This is for the days. Evenings are spent improving an intelligent loader able to take into account complex FK relationships. I have prepared two 5,000,000 row tables, one in my 8.1.7 database and one in my 9.0.1 database, but I have not tested anything yet. I had a flash of idiocy and subscribed to the OT list (out of the blues). I doubt I will stay long here. Some people seems to be paid doing nothing but e-mailing. Is this where you got the details about Pierce? Pretty active there. Cheers, Stephane Faroult -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an
Re: Do you ever have days where you dont want to think ?
ah but who says Henry Higgins was right? --- Stephane Faroult [EMAIL PROTECTED] wrote: [EMAIL PROTECTED] wrote: as one of the women in this profession, do I want to know who you consider honorary men? :) What I do want to know is how you determine what the criteria are for being an honorary man. Inquiring minds want to know :) Rachel Well, coming from me 'honorary man' is almost a compliment (also perhaps not totally in the context of nude sunbathing - I would not be totally opposed to chador in some cases on French beaches). What summarizes my thought best, and in a better way than I am able to put it, is probably this : http://www.geocities.com/Broadway/Stage/4575/mflaudrey7.html#A Now I think I'd better run for cover, even if the trouble-and-strife is not on the list ... You asked for it ;-). -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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!? LAUNCH - Your Yahoo! Music Experience http://launch.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
SHARED POOL SIZE
HI, IS THERE ANY WAY TO INCREASE THE SHARED_POOL_SIZE WITHOUT SHUT DOWN THE DATABASE(8.1.6.2 ON SUN SOLARIS) Hamid Alavi Office 818 737-0526 Cell818 402-1987 === Confidentiality Statement === The information contained in this message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from disclosure under applicable law. If you have received this message in error, you are prohibited from copying, distributing, or using the information. Please contact the sender immediately by return e-mail and delete the original message from your system. = End Confidentiality Statement = -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hamid Alavi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: TEMP TABLESPACE
Hamid, 1) Do not let TEMP tablespace have autoextend set to on - my .02 is to never have this set to on for any tablespace, but to monitor and expand as necessary. Other DBAs like autoextend, so you may want that for other tablespaces, but not for TEMP. 2) A nice trick to get TEMP cleared of allocated-but-no-longer-used space is to set the next extent to, say 512MB (from say, 1024MB). This will cause all space but what is being currently used to be wiped out. The set next extent back to 1024 (or whatever it was before). Thank you, Paul Sherman DBAElcom, Inc. email - [EMAIL PROTECTED] -Original Message- Sent: Monday, May 20, 2002 1:59 PM To: Multiple recipients of list ORACLE-L Hi List, I have two data files for my TEMP tablespace, i just find out one of the data file AUTO EXTEND is set to on is it right?? I beleive for TEMP tablespace autoextend shoudn't be ON, AM I RIGHT or NOT? Now my data file almost full for TEMP tablespace how can I Clean it up, I run ALTER TABLESPACE TEMP COALESCE BUT STILL DATA FILE IS FULL ORACLE 8.1.7.0 ON SUN SOLARIS \THANKS ALLOT Hamid Alavi Office 818 737-0526 Cell818 402-1987 === Confidentiality Statement === The information contained in this message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from disclosure under applicable law. If you have received this message in error, you are prohibited from copying, distributing, or using the information. Please contact the sender immediately by return e-mail and delete the original message from your system. = End Confidentiality Statement = -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hamid Alavi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Sherman, Paul R. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Do you ever have days where you dont want to think ?
ROFL -- this whole thread has kept me cracking up all morning !!! -- (Mrs.) JoJo :D -Original Message- Paul R. Sent: Monday, May 20, 2002 11:35 AM To: Multiple recipients of list ORACLE-L Sigh no more, ladies, sigh nor more; Men were deceivers ever; One foot in sea and one on shore, To one thing constant never; Then sigh not so, But let them go, And be you blithe and bonny; Converting all your sounds of woe Into. Hey nonny, nonny. Sing no more ditties, sing no mo, Or dumps so dull and heavy; The fraud of men was ever so, Since summer first was leavy. Then sigh not so, But let them go, And be you blithe and bonny, Converting all your sounds of woe Into. Hey, nonny, nonny. Thank you, Paul Sherman DBAElcom, Inc. email - [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: JoJo Al-Zawawi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: SHARED POOL SIZE
Yes, upgrade to 9.0.1. Oops, you'll also have to shut down to do that. Well, I guess the answer comes down to . . . . no. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, May 20, 2002 2:06 PM To: Multiple recipients of list ORACLE-L HI, IS THERE ANY WAY TO INCREASE THE SHARED_POOL_SIZE WITHOUT SHUT DOWN THE DATABASE(8.1.6.2 ON SUN SOLARIS) Hamid Alavi Office 818 737-0526 Cell818 402-1987 === Confidentiality Statement === The information contained in this message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from disclosure under applicable law. If you have received this message in error, you are prohibited from copying, distributing, or using the information. Please contact the sender immediately by return e-mail and delete the original message from your system. = End Confidentiality Statement = -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hamid Alavi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: SHARED POOL SIZE
Hamid, Check v$parameter table and it will tell you if a given parameter that is used and/or defaulted, is system or session modifiable. Whether or not to modify, if a given parameter is session or system modifiable, is left up to the discretion and experience of the DBA. By the way, the example I sent to you on TEMP tblspace - it should have been in K, not MB; thus, change to 512K then back to 1024K, not MB. Sorry about that! Thank you, Paul Sherman DBAElcom, Inc. email - [EMAIL PROTECTED] -Original Message- Sent: Monday, May 20, 2002 3:06 PM To: Multiple recipients of list ORACLE-L HI, IS THERE ANY WAY TO INCREASE THE SHARED_POOL_SIZE WITHOUT SHUT DOWN THE DATABASE(8.1.6.2 ON SUN SOLARIS) Hamid Alavi Office 818 737-0526 Cell818 402-1987 === Confidentiality Statement === The information contained in this message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from disclosure under applicable law. If you have received this message in error, you are prohibited from copying, distributing, or using the information. Please contact the sender immediately by return e-mail and delete the original message from your system. = End Confidentiality Statement = -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hamid Alavi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Sherman, Paul R. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: SHARED POOL SIZE
No. This is not one of the parameters that can be set on the fly... Regards, Melanie Burns -Original Message- Sent: Monday, May 20, 2002 2:06 PM To: Multiple recipients of list ORACLE-L HI, IS THERE ANY WAY TO INCREASE THE SHARED_POOL_SIZE WITHOUT SHUT DOWN THE DATABASE(8.1.6.2 ON SUN SOLARIS) Hamid Alavi Office 818 737-0526 Cell818 402-1987 === Confidentiality Statement === The information contained in this message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from disclosure under applicable law. If you have received this message in error, you are prohibited from copying, distributing, or using the information. Please contact the sender immediately by return e-mail and delete the original message from your system. = End Confidentiality Statement = -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hamid Alavi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Root, Melanie INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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 Server to Oracle DB
The code to do this in Perl is trivial, and you get the bonus of complete control, as well as the ability to generate sqlloader control and paramters files on the fly. Jared Still Oracle DBA and Part Time Perl Evangelist ( feels like full time lately ) Tim Gorman [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 05/20/2002 10:43 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: SQL Server to Oracle DB ...speaking of $0.02, make sure that the utility from SQL Server that produces the flat file does not perform unsolicited rounding of numerics. I was recently burned on a Sybase-Oracle conversion when the BCP (a.k.a. bulk copy) and ISQL (a.k.a. SQL*Plus in Sybase) utilities each implicitly round numeric data to the 2nd digit to the right of the decimal. Since SQL Server comes from Sybase, beware... In ISQL, I could just divide everything by 1. to get the true precision, but BCP doesn't provide that option. Instead, I wrote a shell script to query the Sybase data dictionary to generate the C program sources for each table. The Sybase APIs were perfectly capable of handling numeric precision, but the %^#* Sybase developers who wrote ISQL and BCP were too lazy to use them correctly. Since the ODBC driver from MS-Access seemed to use the API correctly (i.e. no implicit rounding seen), then maybe the MS folks are more diligent... Just FYI... - Original Message - To: Multiple recipients of list ORACLE-L Sent: Monday, May 20, 2002 9:08 AM Richard: Yes. The way I've done it in the past is to generate tilde (~) delimited flat files and then load the data into Oracle via SQL*Loader. You have to do a mapping first before using SQL*Loader. Then you have to write scripts for each table you are loading. I recommend the O'Reilly book Oracle SQL*Loader, The Definitive Guide. This is a process that can take time especially if the Oracle application needs data that the old legacy DB doesn't provide. My $0.02 worth, Ken Janusz, CPIM - Original Message - To: Multiple recipients of list ORACLE-L Sent: Monday, May 20, 2002 9:03 AM Anyone know of an easy way to grab data from tables in an SQL Server DB and insert into tables in an Oracle DB? Thanks. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: AQ using a trigger?
My limited knowledge of AQ would lead me to believe that you're trying to reinvent the wheel. Maybe you should spend more time on the AQ docs? Jared YTTRI Lisa [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 05/17/2002 02:38 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:AQ using a trigger? Does anyone have experience with AQ tables? I would like to put a trigger on my AQ table so that when a message comes in, it will automatically fire off a job to dequeue the message. I opened a TAR and was told that I can put a trigger on the table, but it's not recommended. When I asked why, they said 'it just wasn't recommended'. I'm curious if anyone actually knows why I shouldn't or if I really can. It really seems to be a slick way to handle the messages, but if it will cause problems, I'd like to know that upfront. Thank you - Lisa -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: YTTRI Lisa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: SHARED POOL SIZE
No. Jared Hamid Alavi [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 05/20/2002 12:05 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:SHARED POOL SIZE HI, IS THERE ANY WAY TO INCREASE THE SHARED_POOL_SIZE WITHOUT SHUT DOWN THE DATABASE(8.1.6.2 ON SUN SOLARIS) Hamid Alavi Office 818 737-0526 Cell818 402-1987 === Confidentiality Statement === The information contained in this message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from disclosure under applicable law. If you have received this message in error, you are prohibited from copying, distributing, or using the information. Please contact the sender immediately by return e-mail and delete the original message from your system. = End Confidentiality Statement = -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hamid Alavi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Patch: 1951929
Has anyone applied this? The last sentence from support, copied below, gives me the creeps: Please go to the Oracle MetaLink ( http://metalink.oracle.com/ ) site to download the patch referenced below. Patch: 1951929 - RECIEVING MANY ORA-07445 [KQRGCU()+244]ERRORS Customers are reminded that one-off Oracle Server patches are not subject to the same rigorous level of testing as done for Oracle Server patch sets. Customers are encouraged to install and test this patch in a test environment prior to full production implementation. === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Do you ever have days where you dont want to think ?
Sherman, Paul R. wrote: Sigh no more, ladies, sigh nor more; Men were deceivers ever; One foot in sea and one on shore, To one thing constant never; Then sigh not so, But let them go, And be you blithe and bonny; Converting all your sounds of woe Into. Hey nonny, nonny. Sing no more ditties, sing no mo, Or dumps so dull and heavy; The fraud of men was ever so, Since summer first was leavy. Then sigh not so, But let them go, And be you blithe and bonny, Converting all your sounds of woe Into. Hey, nonny, nonny. Thank you, Paul Sherman DBAElcom, Inc. email - [EMAIL PROTECTED] One woman is fair, yet I am well; another is wise, yet I am well; another virtuous, yet I am well; but till all graces be in one woman, one woman shall not come in my grace. Rich she shall be, that's certain; wise, or I'll none; virtuous, or I'll never cheapen her; fair, or I'll never look on her; mild, or come not near me; noble, or not I for an angel; of good discourse, an excellent musician, and her hair shall be of what colour it please God. Time to move to the OT list, perhaps. -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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 Server to Oracle DB
All this coding stuff is fine if there is a one-to-one correlation between the SQL Server tables and the Oracle tables. If not, then the first thing that needs to be accomplished is mapping the SQL Server tables to Oracle. This can be a fun job especially if data is required in Oracle that doesn't exist in the old tables. Ken Janusz, CPIM - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, May 20, 2002 2:13 PM The code to do this in Perl is trivial, and you get the bonus of complete control, as well as the ability to generate sqlloader control and paramters files on the fly. Jared Still Oracle DBA and Part Time Perl Evangelist ( feels like full time lately ) Tim Gorman [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 05/20/2002 10:43 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: SQL Server to Oracle DB ...speaking of $0.02, make sure that the utility from SQL Server that produces the flat file does not perform unsolicited rounding of numerics. I was recently burned on a Sybase-Oracle conversion when the BCP (a.k.a. bulk copy) and ISQL (a.k.a. SQL*Plus in Sybase) utilities each implicitly round numeric data to the 2nd digit to the right of the decimal. Since SQL Server comes from Sybase, beware... In ISQL, I could just divide everything by 1. to get the true precision, but BCP doesn't provide that option. Instead, I wrote a shell script to query the Sybase data dictionary to generate the C program sources for each table. The Sybase APIs were perfectly capable of handling numeric precision, but the %^#* Sybase developers who wrote ISQL and BCP were too lazy to use them correctly. Since the ODBC driver from MS-Access seemed to use the API correctly (i.e. no implicit rounding seen), then maybe the MS folks are more diligent... Just FYI... - Original Message - To: Multiple recipients of list ORACLE-L Sent: Monday, May 20, 2002 9:08 AM Richard: Yes. The way I've done it in the past is to generate tilde (~) delimited flat files and then load the data into Oracle via SQL*Loader. You have to do a mapping first before using SQL*Loader. Then you have to write scripts for each table you are loading. I recommend the O'Reilly book Oracle SQL*Loader, The Definitive Guide. This is a process that can take time especially if the Oracle application needs data that the old legacy DB doesn't provide. My $0.02 worth, Ken Janusz, CPIM - Original Message - To: Multiple recipients of list ORACLE-L Sent: Monday, May 20, 2002 9:03 AM Anyone know of an easy way to grab data from tables in an SQL Server DB and insert into tables in an Oracle DB? Thanks. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: KENNETH JANUSZ INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: wait event trace file formatter?
Unfortunately this is 8.1.7 (sorry I didn't specify). A note on Metalink makes reference to a formatting utility but, of course, neither includes nor specifies where to find said utility. --- Jamadagni, Rajendra [EMAIL PROTECTED] wrote: Tkprof ?? I was just reading 9iR2 notes and it seems there is a new parameter for tkprof 'wait events' that will list waits (if available) in the file per cursor, very useful feature. Raj __ Rajendra JamadagniMIS, 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- Sent: Monday, May 20, 2002 1:03 PM To: Multiple recipients of list ORACLE-L I'm looking for a way to format a trace file produced by event 10046 trace name context forever,level 8 (this dumps all wait events to a file). Has anyone written such a formatter, or have information on one? Thanks. = Paul Baumgartel, Adept Computer Associates, Inc. [EMAIL PROTECTED] __ Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience http://launch.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). ***1 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 ESPN at (860) 766-2000 and delete this e-mail message from your computer, Thank you. ***1 __ Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience http://launch.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
DB Clone from RMAN backups
Hi all, I am trying to speed up refreshes of QA databases and am familiar with cloning databases using user managed backups (hot and cold). The problem is the organization I am currently with uses RMAN to manage the backups. The perform a level 0 once a month, level 1 once a week, level 2 daily. How/could I use these backups to clone the database to another environment? One of the db's that needs to be refreshed is approx. 40gb and takes about 5 hours to import. The other db is 200+ gb and takes about 24 hours to import. Any suggestions / strategies. Also, its a 24 x 7 environment. TIA, Michele -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: What makes Export slow ?
--- Jeremiah Wilton [EMAIL PROTECTED] wrote: On Mon, 20 May 2002, Reddy, Madhusudana wrote: Huge Buffer, commit=y, direct=y, assigning the big rollback segment should help you to have faster export , What does COMMIT=Y do in an export? it causes an error message! __ Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience http://launch.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: What makes Export slow ?
The idea of huge rollback segment is just to eliminate the contention the rollback segment. Well its not always applicable ( possible make sure all the other applications are not used), but we can create a big rollback segment and bring it on line and make other rollback segments offline, and run the export . So definitely the big rollback segment will be used. COMMIT=Y is not a parameter for export , instead good for import , its my mistake. Somewhere I have read that NFS Mounted file system will make the export slower . Thanks for your correction, Madhu -Original Message- Sent: Monday, May 20, 2002 1:04 PM To: Multiple recipients of list ORACLE-L On Mon, 20 May 2002, Reddy, Madhusudana wrote: Huge Buffer, commit=y, direct=y, assigning the big rollback segment should help you to have faster export , What do you mean assigning the big rollback segment? How do you do that to an export and what does it accomplish? What does COMMIT=Y do in an export? If I were the original poster, I'd just look at v$session_event for the export session after several minutes of slowness. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton -Original Message- Sent: Monday, May 20, 2002 3:43 AM To: Multiple recipients of list ORACLE-L I moved my database from Solaris 7 to Solaris 8 box (Sun Fire 4800, faster processors and more memory space) I create the database with the same script that I used to for my database in the older machine, When I export my database from the older machine it was very fast and when I import to newer machine it was fast too, and when I export from new machine it is really slow (very slow), (I am using same export parameters in both servers) Can someone help with tuning tips or anything you have... : ( - The no of records are the same for both machines - v$session_wait.seconds_in_wait is more than 1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Reddy, Madhusudana INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: SHARED POOL SIZE
Only on 9.0.1 and above -Original Message- [EMAIL PROTECTED] Sent: Monday, May 20, 2002 9:24 PM To: Multiple recipients of list ORACLE-L No. Jared Hamid Alavi [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 05/20/2002 12:05 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:SHARED POOL SIZE HI, IS THERE ANY WAY TO INCREASE THE SHARED_POOL_SIZE WITHOUT SHUT DOWN THE DATABASE(8.1.6.2 ON SUN SOLARIS) Hamid Alavi Office 818 737-0526 Cell818 402-1987 === Confidentiality Statement === The information contained in this message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from disclosure under applicable law. If you have received this message in error, you are prohibited from copying, distributing, or using the information. Please contact the sender immediately by return e-mail and delete the original message from your system. = End Confidentiality Statement = -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hamid Alavi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: raja INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Do you ever have days where you dont want to think ?
My favorite Shakespearean (sp?) play and yes, I think we should move this to the OT list :) --- Stephane Faroult [EMAIL PROTECTED] wrote: Sherman, Paul R. wrote: Sigh no more, ladies, sigh nor more; Men were deceivers ever; One foot in sea and one on shore, To one thing constant never; Then sigh not so, But let them go, And be you blithe and bonny; Converting all your sounds of woe Into. Hey nonny, nonny. Sing no more ditties, sing no mo, Or dumps so dull and heavy; The fraud of men was ever so, Since summer first was leavy. Then sigh not so, But let them go, And be you blithe and bonny, Converting all your sounds of woe Into. Hey, nonny, nonny. Thank you, Paul Sherman DBAElcom, Inc. email - [EMAIL PROTECTED] One woman is fair, yet I am well; another is wise, yet I am well; another virtuous, yet I am well; but till all graces be in one woman, one woman shall not come in my grace. Rich she shall be, that's certain; wise, or I'll none; virtuous, or I'll never cheapen her; fair, or I'll never look on her; mild, or come not near me; noble, or not I for an angel; of good discourse, an excellent musician, and her hair shall be of what colour it please God. Time to move to the OT list, perhaps. -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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!? LAUNCH - Your Yahoo! Music Experience http://launch.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Patch: 1951929
Title: RE: Patch: 1951929 This pretty much boilerplate text I've seen on LOTS of patches from Oracle. Matt Adams - GE Appliances - [EMAIL PROTECTED] Chaos! Panic! Disaster! (My work here is done) -Original Message- From: Ray Stell [mailto:[EMAIL PROTECTED]] Sent: Monday, May 20, 2002 3:44 PM To: Multiple recipients of list ORACLE-L Subject: Patch: 1951929 Has anyone applied this? The last sentence from support, copied below, gives me the creeps: Please go to the Oracle MetaLink ( http://metalink.oracle.com/ ) site to download the patch referenced below. Patch: 1951929 - RECIEVING MANY ORA-07445 [KQRGCU()+244]ERRORS Customers are reminded that one-off Oracle Server patches are not subject to the same rigorous level of testing as done for Oracle Server patch sets. Customers are encouraged to install and test this patch in a test environment prior to full production implementation. === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC 28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: SHARED POOL SIZE
No, it is NOT. Connected to: Oracle9i Enterprise Edition Release 9.0.1.1.1 - Production With the Partitioning option JServer Release 9.0.1.1.1 - Production 1 select name, ISSES_MODIFIABLE, ISSYS_MODIFIABLE from v$parameter 2* where name like'shared_pool_size%' SQL / NAME ISSES ISSYS_MOD - - shared_pool_size FALSE IMMEDIATE Sunil Nookala Dell Corp. -Original Message- Sent: Monday, May 20, 2002 2:55 PM To: Multiple recipients of list ORACLE-L Only on 9.0.1 and above -Original Message- [EMAIL PROTECTED] Sent: Monday, May 20, 2002 9:24 PM To: Multiple recipients of list ORACLE-L No. Jared Hamid Alavi [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 05/20/2002 12:05 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:SHARED POOL SIZE HI, IS THERE ANY WAY TO INCREASE THE SHARED_POOL_SIZE WITHOUT SHUT DOWN THE DATABASE(8.1.6.2 ON SUN SOLARIS) Hamid Alavi Office 818 737-0526 Cell818 402-1987 === Confidentiality Statement === The information contained in this message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from disclosure under applicable law. If you have received this message in error, you are prohibited from copying, distributing, or using the information. Please contact the sender immediately by return e-mail and delete the original message from your system. = End Confidentiality Statement = -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hamid Alavi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: raja INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Korn Shell Sqlplus
Michael - I have noticed the same issue you describe - ie. after the sqlplus process terminates, the shadow process continues to completion (assuming there is a COMMIT in the script). We are also on Compaq Tru64, but Oracle 8.1.6. I have only noticed it, not had a reason to dig in and investigate. I suspect that the shadow process is getting reparented to root. You might consider changing your kill to a kill -9. Or locate the shadow process and kill it, maybe first. Just some ideas, hopefully someone has more direct experience. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, May 20, 2002 2:55 PM To: Multiple recipients of list ORACLE-L Maybe one of you has some inspiration. Environment: Compaq Tru64 5.1; Oracle 8.1.7.3 The concept is for a parent Korn shell to spawn a sqlplus child in background (which will validate table structure via a PL/SQL Block) then wait for a fixed time period before stopping/killing the sqlplus child. After the sqlplus child is stopped some follow-up processing is needed to bookmark where the sqlplus processing has stopped. My quick test script so far look like: #!/bin/ksh echo Starting val_asc, spawning at $(date) val_asc.out sqlplus x/ @val_asc3.pls val_asc3.log valpid=$! sleep 240 kill -KILL %1 echo Leaving val_asc at $(date) val_asc.out exit When the sqlplus line runs it starts 2 processes: oragdv 169035 167185 0.0 10:00:20 pts/10:00.18 sqlplus oragdv 169652 169035 0.0 10:00:22 ?? 0:00.13 oracleGDV (DESCRIPTION=(LOCAL=YES). . . The problem is when the kill command executes, only the first of these 2 processes is killed immediately. The 2nd (with the PPID at 1) continues processing until the PL/SQL Block completes (including database updates) before it terminates. Here's the question. Is there a straightforward way to terminate that 2nd process before starting post processing? Any suggestions would be appreciated as I have been bashing my head against the proverbial wall for several days now ;) I have used the $! parameter to id the sqlplus PID and have been fiddling with ps awk to try and obtain the 2nd process's PID but have yet to be successful Michael Hand Polaroid Corp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: DB Clone from RMAN backups
Michele - Have you looked at the RMAN DUPLICATE command? Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, May 20, 2002 2:55 PM To: Multiple recipients of list ORACLE-L Hi all, I am trying to speed up refreshes of QA databases and am familiar with cloning databases using user managed backups (hot and cold). The problem is the organization I am currently with uses RMAN to manage the backups. The perform a level 0 once a month, level 1 once a week, level 2 daily. How/could I use these backups to clone the database to another environment? One of the db's that needs to be refreshed is approx. 40gb and takes about 5 hours to import. The other db is 200+ gb and takes about 24 hours to import. Any suggestions / strategies. Also, its a 24 x 7 environment. TIA, Michele -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Korn Shell Sqlplus
Hand, Michael T wrote: Maybe one of you has some inspiration. Environment: Compaq Tru64 5.1; Oracle 8.1.7.3 The concept is for a parent Korn shell to spawn a sqlplus child in background (which will validate table structure via a PL/SQL Block) then wait for a fixed time period before stopping/killing the sqlplus child. After the sqlplus child is stopped some follow-up processing is needed to bookmark where the sqlplus processing has stopped. My quick test script so far look like: #!/bin/ksh echo Starting val_asc, spawning at $(date) val_asc.out sqlplus x/ @val_asc3.pls val_asc3.log valpid=$! sleep 240 kill -KILL %1 echo Leaving val_asc at $(date) val_asc.out exit When the sqlplus line runs it starts 2 processes: oragdv 169035 167185 0.0 10:00:20 pts/10:00.18 sqlplus oragdv 169652 169035 0.0 10:00:22 ?? 0:00.13 oracleGDV (DESCRIPTION=(LOCAL=YES). . . The problem is when the kill command executes, only the first of these 2 processes is killed immediately. The 2nd (with the PPID at 1) continues processing until the PL/SQL Block completes (including database updates) before it terminates. Here's the question. Is there a straightforward way to terminate that 2nd process before starting post processing? Any suggestions would be appreciated as I have been bashing my head against the proverbial wall for several days now ;) I have used the $! parameter to id the sqlplus PID and have been fiddling with ps awk to try and obtain the 2nd process's PID but have yet to be successful Michael Hand Polaroid Corp Michael, Killing Oracle server processes is definitely bad manners. Especially if you are using MTS. Even if you are not, the proper way to kill an Oracle process is to use ALTER SYSTEM KILL SESSION. I think that you should use the DBMS_APPLICATION_INFO package to set something like 'Hey! Shoot me!' in your CLIENT_INFO column in V$PROCESS - it would make it easier to another process to log as DBA, spot the process and bang. Another thing that you might want to explore are profiles - you can define and set a profile with limits to suit your needs, and let Oracle do the dirty work. -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: wait event trace file formatter?
Paul: I think you are talking about the support tool TRCSUMMARY. IT is a perl script from oracle Support. You can get it externally if you have some friends in Oracle Support ;) --- Paul Baumgartel [EMAIL PROTECTED] wrote: Unfortunately this is 8.1.7 (sorry I didn't specify). A note on Metalink makes reference to a formatting utility but, of course, neither includes nor specifies where to find said utility. = Have a nice day !! Best Regards, K Gopalakrishnan, Bangalore, INDIA. __ Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience http://launch.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: K Gopalakrishnan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: SHARED POOL SIZE
Title: RE: SHARED POOL SIZE The value of IMMEDIATE in the ISSYS_MODIFIABLE column means that it IS modifiable and takes effect immediately. Matt Adams - GE Appliances - [EMAIL PROTECTED] Chaos! Panic! Disaster! (My work here is done) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, May 20, 2002 4:14 PM To: Multiple recipients of list ORACLE-L Subject: RE: SHARED POOL SIZE No, it is NOT. Connected to: Oracle9i Enterprise Edition Release 9.0.1.1.1 - Production With the Partitioning option JServer Release 9.0.1.1.1 - Production 1 select name, ISSES_MODIFIABLE, ISSYS_MODIFIABLE from v$parameter 2* where name like'shared_pool_size%' SQL / NAME ISSES ISSYS_MOD - - shared_pool_size FALSE IMMEDIATE Sunil Nookala Dell Corp. -Original Message- Sent: Monday, May 20, 2002 2:55 PM To: Multiple recipients of list ORACLE-L Only on 9.0.1 and above -Original Message- [EMAIL PROTECTED] Sent: Monday, May 20, 2002 9:24 PM To: Multiple recipients of list ORACLE-L No. Jared Hamid Alavi [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 05/20/2002 12:05 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject: SHARED POOL SIZE HI, IS THERE ANY WAY TO INCREASE THE SHARED_POOL_SIZE WITHOUT SHUT DOWN THE DATABASE(8.1.6.2 ON SUN SOLARIS) Hamid Alavi Office 818 737-0526 Cell 818 402-1987 === Confidentiality Statement === The information contained in this message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from disclosure under applicable law. If you have received this message in error, you are prohibited from copying, distributing, or using the information. Please contact the sender immediately by return e-mail and delete the original message from your system. = End Confidentiality Statement = -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hamid Alavi INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: raja INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Do you ever have days where you dont want to think ?
Try sending message to: [EMAIL PROTECTED] On Mon, 2002-05-20 at 11:33, Freeman, Robert wrote: How does one get on the OT list??? -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Monday, May 20, 2002 10:23 AM To: Multiple recipients of list ORACLE-L as one of the women in this profession, do I want to know who you consider honorary men? :) What I do want to know is how you determine what the criteria are for being an honorary man. Inquiring minds want to know :) Rachel |+--- || | || | || sfaroult@orio| || le.com | || | || 05/18/2002 | || 11:13 AM | || Please | || respond to | || ORACLE-L | || | |+--- | || | To: [EMAIL PROTECTED] | | cc: (bcc: Rachel Carmichael) | | Subject: Re: Do you ever have days where | | you dont want to think ? | | Larry Elkins wrote: The beach part sounds great, though I don't care to see naked men running around ;-) That's the problem in this job. Too many men. And among women, too many are like honorary men. Still preaching the gospel, as you can see :-). In fact, I would be curious to compare the join on the inline-view with a MINUS to the hash anti-join. Assuming all correct indexes, it is comparing two index fast full scans plus sort plus index search to two table full scans (more or less). I am almost certain that many costs could be put into equations. The problem is if you have too many values (number of rows, number of rows returned, storage, selectivity, etc...) to feed into your equations or have trouble deriving these it is not of much use. Wanted to do some tests on reverse indexes, following your posts, but I have not had time. Not much progress on the book PL/SQL chapter either. Currently working on real-time, home-made replication (which works on the standard edition, BTW). Still revolving around the same topics because one of my concerns is to minimize overhead when logging (trigger-happy replication, I am suspicious of the Shareplex approach and anyway as I want to be able to replicate between France, Japan and the US, I cannot afford to transfer full redo logs and transactions I shall have to rollback). I log into several tables (enough info to rebuild statements, and values separately - with additional problems when we reach the 4,000 characters mark), IOTs are the obvious choice but I am not sure it is available with all licenses. Degradation of my logs over timeis also something I have to watch. This is for the days. Evenings are spent improving an intelligent loader able to take into account complex FK relationships. I have prepared two 5,000,000 row tables, one in my 8.1.7 database and one in my 9.0.1 database, but I have not tested anything yet. I had a flash of idiocy and subscribed to the OT list (out of the blues). I doubt I will stay long here. Some people seems to be paid doing nothing but e-mailing. Is this where you got the details about Pierce? Pretty active there. Cheers, Stephane Faroult -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858)
DECODE HELP
Hello all, This has probably been discussed here before and I'm sorry if I'm repeating this. But I'd very much appreciate if someone could show me how to use DECODE to select a MAX date where records are like this: PRIM. KEY FIRST_DATE SEC_DATE THIRD_DATE JO001599O 12/14/2000 03/23/2001 05/21/2001 JO001620L12/27/2000 05/16/2001 The first_date, sec_date and third_date may or may not exist; either one of the dates will be there. I need to come up with another column LATEST_DATE which will show the latest date of the 3. Thanks very much in advance! __ Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience http://launch.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Viktor INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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 r2
Someone at Oracle has modified the login procedures for download.oracle.com, as wget no longer works with -http-user and -http-password from this site. So, you get to do it from a browser. What fun. Jared JOE TESTA [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 05/20/2002 08:23 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:9i r2 2 of the files downloaded, will be loading it up today,. woohoo, can anyone say crash and burn, bwahahahahahaha joe -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: oracle job question
What if I have jobs scheduled at 2:15 , 2:30 , 3:00 . Will oracle run them all at once if database is up at 4:00 . -Ajay - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, May 16, 2002 1:17 PM BigP wrote: Hi List , I have a question regarding oracle database job . I have a database job which runs everyday at 3pm . Due to some reason database was shutdown between 2-4 pm . What will happen to that job . Will oracle run this job after restaring database ? Thanks in advace for your answers Bp Yes. Can be a big problem if you have a dozen jobs which were carefully scheduled restarting all at once. -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: BigP INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: What makes Export slow ?
On Mon, 20 May 2002, Reddy, Madhusudana wrote: The idea of huge rollback segment is just to eliminate the contention the rollback segment. Well its not always applicable ( possible make sure all the other applications are not used), but we can create a big rollback segment and bring it on line and make other rollback segments offline, and run the export . So definitely the big rollback segment will be used. Used for what? Are you talking about constructing consistent reads? If so, then that shouldn't be necessary on any significant scale if we, as you suggest, make sure all the other applications are not used. Even if concurrent access is allowed (as it should be) during export, why would constructing consistent reads from a variety of rollback segments cause contention conpared to constructing the same consistent reads from one big rollback segment? What are you trying to accomplish with the big rollback segment? What do you think the rollback segments are being used for by an export? -- Jeremiah Wilton http://www.speakeasy.net/~jwilton -Original Message- Sent: Monday, May 20, 2002 1:04 PM To: Multiple recipients of list ORACLE-L On Mon, 20 May 2002, Reddy, Madhusudana wrote: Huge Buffer, commit=y, direct=y, assigning the big rollback segment should help you to have faster export , What do you mean assigning the big rollback segment? How do you do that to an export and what does it accomplish? What does COMMIT=Y do in an export? If I were the original poster, I'd just look at v$session_event for the export session after several minutes of slowness. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton -Original Message- Sent: Monday, May 20, 2002 3:43 AM To: Multiple recipients of list ORACLE-L I moved my database from Solaris 7 to Solaris 8 box (Sun Fire 4800, faster processors and more memory space) I create the database with the same script that I used to for my database in the older machine, When I export my database from the older machine it was very fast and when I import to newer machine it was fast too, and when I export from new machine it is really slow (very slow), (I am using same export parameters in both servers) Can someone help with tuning tips or anything you have... : ( - The no of records are the same for both machines - v$session_wait.seconds_in_wait is more than 1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: wait event trace file formatter?
Resend -Original Message- Sent: Monday, May 20, 2002 2:57 PM To: '[EMAIL PROTECTED]' Paul - We had this discussion last week, so you can probably search the archives and get answers. What I received from the discussion is that it is probably simple to create a simple trace file formatter, but that won't account for all the nuances in the trace files. The people that have developed the trace file formatters have devoted an enormous amount of time learning the subtleties and understanding the inconsistencies in the files. Obviously, they deserve to be compensated for their effort, and I don't think they are asking for large amounts of money by any means. But I expect that you can do some experimenting on your own, learning the basics, and it will probably give you a better appreciation for what Cary has gone through. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, May 20, 2002 3:35 PM To: Multiple recipients of list ORACLE-L Thanks for all the replies. I was hoping to find a simple user-written script that didn't require signing up for a fee-based service, though. I guess there aren't any available. --- K Gopalakrishnan [EMAIL PROTECTED] wrote: Hi: Check 'itprof' at http://www.ubtools.com or 'Sparky' at http://www.hotsos.com I have used the first one found very good. __ Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience http://launch.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: DECODE HELP
Why use decode. Look up the greatest sql function. select prim_key, greatest(first_date,sec_date,third_date) from your_table. Ron Thomas Hypercom, Inc [EMAIL PROTECTED] The problem with some people is that when they aren't drunk, they're sober. --William Butler Yeats. [EMAIL PROTECTED] mTo: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: DECODE HELP 05/20/02 01:48 PM Please respond to ORACLE-L Hello all, This has probably been discussed here before and I'm sorry if I'm repeating this. But I'd very much appreciate if someone could show me how to use DECODE to select a MAX date where records are like this: PRIM. KEY FIRST_DATE SEC_DATE THIRD_DATE JO001599O 12/14/2000 03/23/2001 05/21/2001 JO001620L12/27/2000 05/16/2001 The first_date, sec_date and third_date may or may not exist; either one of the dates will be there. I need to come up with another column LATEST_DATE which will show the latest date of the 3. Thanks very much in advance! __ Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience http://launch.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Viktor INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Thomas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
