RE: OEM Repos install error.
Thanks for the input Clint, and Vadim, I think it will probably be worth getting 2.2 as it is also the current version to test against. A note: The file that was not found in the error below (vdkcr210.sql) was actually called just vdkcr.sql, without the version info.. You know I'm suprised that anybody likes this s*$t with all the hassle that it causes you..:0) Thanks for your help.. Mark (Off for ANOTHER 300mb download) -Original Message- Gorbounov Sent: Monday, April 02, 2001 06:46 To: Multiple recipients of list ORACLE-L Hi Mark, I installed 2.1 several times, nothing like this (never on the same box with 8.1.7). I'm pretty sure, you need either separate ORACLE_HOMEs for 8.1.7 and OEM 2.1, or go with OEM 2.2, as Clint told. Vadim Gorbounov Oracle DBA -Original Message- Sent: Monday, April 02, 2001 12:26 PM To: Multiple recipients of list ORACLE-L Hi Everyone, Just a quick one, I am installing OEM 2.1 on to a Win2K box, with Oracle 8.1.7 already installed on it. When running through the Configuration Assistant, to create a new repository, I am getting the following error: --- java.io.FileNotFoundException: C:\oracle\ora81\sysman\admin\vdkcr210.sql at java.io.FileInputStream.init(FileInputStream.java:56) at java.io.FileReader.init(FileReader.java:35) at oracle.sysman.vxx.VxxNestedInputReader.init(VxxNestedInputReader.java:75) at oracle.sysman.vxx.VxxSQLScriptReader.init(VxxSQLScriptReader.java:99) at oracle.sysman.vdb.VdbSQLScriptExecutor.init(VdbSQLScriptExecutor.java:326) at oracle.sysman.vbo.vboe.repmgr.RepositorySQLAction.executeScript(RepositorySQ LAction.java:124) at oracle.sysman.vbo.vboe.repmgr.RepositorySQLCreateAction.create(RepositorySQL CreateAction.java:100) at oracle.sysman.vbo.vboe.repmgr.RepositorySQLCreateAction.execute(RepositorySQ LCreateAction.java:88) at oracle.sysman.vbo.vboe.repmgr.RepositorySQLAction.execute(RepositorySQLActio n.java:83) at oracle.sysman.vbo.vboe.repmgr.RepositoryProduct.execute(RepositoryProduct.ja va:344) at oracle.sysman.vbo.vboe.repmgr.RepositoryManagerImpl.executeProductOperation( RepositoryManagerImpl.java:1291)at oracle.sysman.vbo.vboe.repmgr.RepositoryManagerImpl.createProductSet(Reposit oryManagerImpl.java:731)at oracle.sysman.vbo.vboe.repmgr.RepositoryManagerImpl.createAllProducts(Reposi toryManagerImpl.java:538) at oracle.sysman.vbo.vboe.repmgr.RepositoryCreate.populateRepository(Repository Create.java:359)at oracle.sysman.vbo.vboe.repmgr.RepositoryCreate.connectAndPopulate(Repository Create.java:307)at oracle.sysman.vbo.vboe.repmgr.RepositoryCreate.execute(RepositoryCreate.java :144) at oracle.sysman.vbo.vboe.repmgr.RepositoryManagerImpl.performOperation(Reposit oryManagerImpl.java:471)at oracle.sysman.vto.vtoe.repmgr.RepositoryMgrObject.execute(RepositoryMgrObjec t.java:645) at oracle.sysman.vtx.VtxProgressDialog.run(VtxProgressDialog.java:419) at java.lang.Thread.run(Thread.java:466) --- Nice isn't it? It fails at 67% with "Stopped processing".. Has anybody else seen this? Thanks for any insight Mark -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vadim Gorbounov INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle start/stop scripts on AIX
Should work do it all the time as well Good luck Jack "Ruth Gramolini" [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] ate.vt.us cc: Sent by: Subject: Re: Oracle start/stop scripts on AIX [EMAIL PROTECTED] 02-04-2001 21:15 Please respond to ORACLE-L I think I may try that. I haven't been too adventurous with UNIX. Ruth - Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Monday, April 02, 2001 2:55 PM Ruth Gramolini wrote: The shutdown script is a bit of a problem because it does a shutdown normal and may hang forever so I just shut them down individually. i always edit the scripts to do a shutdown immediate. seems to work most of the time. -- Bill Thater Certifiable ORACLE DBA Telergy, Inc [EMAIL PROTECTED] You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thater, William INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- 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). = De informatie verzonden in dit e-mailbericht is vertrouwelijk en is uitsluitend bestemd voor de geadresseerde. Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan derden is, behoudens voorafgaande schriftelijke toestemming van Ernst Young, niet toegestaan. Ernst Young staat niet in voor de juiste en volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch voor tijdige ontvangst daarvan. Ernst Young kan niet garanderen dat een verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden. Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u vriendelijk doch dringend het e-mailbericht te retourneren aan de verzender en het origineel en eventuele kopien te verwijderen en te vernietigen. Ernst Young hanteert bij de uitoefening van haar werkzaamheden algemene voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De algemene voorwaarden worden u op verzoek kosteloos toegezonden.
Ver Urgent
Hello All, I want to create one more database in a UNIX machine. Previously one instance is already there. Please tell what are the factors will be keep while creating one more instance in same server. Both the instance `s ORACLE_HOME is same. But different ORACLE_SID. I tried to create New instnace ,but My prevoious instance is down ,I tried to up the previous database ,while startup he is asking for my new databae `s file. Please suggest me what i will do. Regards, Saroj. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dash, Saroj (CAP,CEF) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OEM Repos install error.
Hi Mark. Yea, 2.2 is worth the wait, but if you are an Oracle client already and have maintenance on the database, you should get the software free (if you have enterprise edition). Good luck, if you need any info on OEM, I am going to be setting up a bit of info on it on my web as I have had quite a few requests for it. The url is : http://members.spree.com/business/cnaude/welcome_page.htm It is still under construction in regards to OEM, but will be up in a while. Thanks Clint * Clinton S. Naud * Head systems administration * Tel: 011 685 4304 * Fax: 011 685 4303 * Cell: 082 377 1726 * E-mail: [EMAIL PROTECTED] -Original Message- Sent: Tuesday, April 03, 2001 10:56 AM To: Multiple recipients of list ORACLE-L Thanks for the input Clint, and Vadim, I think it will probably be worth getting 2.2 as it is also the current version to test against. A note: The file that was not found in the error below (vdkcr210.sql) was actually called just vdkcr.sql, without the version info.. You know I'm suprised that anybody likes this s*$t with all the hassle that it causes you..:0) Thanks for your help.. Mark (Off for ANOTHER 300mb download) -Original Message- Gorbounov Sent: Monday, April 02, 2001 06:46 To: Multiple recipients of list ORACLE-L Hi Mark, I installed 2.1 several times, nothing like this (never on the same box with 8.1.7). I'm pretty sure, you need either separate ORACLE_HOMEs for 8.1.7 and OEM 2.1, or go with OEM 2.2, as Clint told. Vadim Gorbounov Oracle DBA -Original Message- Sent: Monday, April 02, 2001 12:26 PM To: Multiple recipients of list ORACLE-L Hi Everyone, Just a quick one, I am installing OEM 2.1 on to a Win2K box, with Oracle 8.1.7 already installed on it. When running through the Configuration Assistant, to create a new repository, I am getting the following error: --- java.io.FileNotFoundException: C:\oracle\ora81\sysman\admin\vdkcr210.sql at java.io.FileInputStream.init(FileInputStream.java:56) at java.io.FileReader.init(FileReader.java:35) at oracle.sysman.vxx.VxxNestedInputReader.init(VxxNestedInputReader.java:75) at oracle.sysman.vxx.VxxSQLScriptReader.init(VxxSQLScriptReader.java:99) at oracle.sysman.vdb.VdbSQLScriptExecutor.init(VdbSQLScriptExecutor.java:326) at oracle.sysman.vbo.vboe.repmgr.RepositorySQLAction.executeScript(RepositorySQ LAction.java:124) at oracle.sysman.vbo.vboe.repmgr.RepositorySQLCreateAction.create(RepositorySQL CreateAction.java:100) at oracle.sysman.vbo.vboe.repmgr.RepositorySQLCreateAction.execute(RepositorySQ LCreateAction.java:88) at oracle.sysman.vbo.vboe.repmgr.RepositorySQLAction.execute(RepositorySQLActio n.java:83) at oracle.sysman.vbo.vboe.repmgr.RepositoryProduct.execute(RepositoryProduct.ja va:344) at oracle.sysman.vbo.vboe.repmgr.RepositoryManagerImpl.executeProductOperation( RepositoryManagerImpl.java:1291)at oracle.sysman.vbo.vboe.repmgr.RepositoryManagerImpl.createProductSet(Reposit oryManagerImpl.java:731)at oracle.sysman.vbo.vboe.repmgr.RepositoryManagerImpl.createAllProducts(Reposi toryManagerImpl.java:538) at oracle.sysman.vbo.vboe.repmgr.RepositoryCreate.populateRepository(Repository Create.java:359)at oracle.sysman.vbo.vboe.repmgr.RepositoryCreate.connectAndPopulate(Repository Create.java:307)at oracle.sysman.vbo.vboe.repmgr.RepositoryCreate.execute(RepositoryCreate.java :144) at oracle.sysman.vbo.vboe.repmgr.RepositoryManagerImpl.performOperation(Reposit oryManagerImpl.java:471)at oracle.sysman.vto.vtoe.repmgr.RepositoryMgrObject.execute(RepositoryMgrObjec t.java:645) at oracle.sysman.vtx.VtxProgressDialog.run(VtxProgressDialog.java:419) at java.lang.Thread.run(Thread.java:466) --- Nice isn't it? It fails at 67% with "Stopped processing".. Has anybody else seen this? Thanks for any insight Mark -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vadim Gorbounov INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to:
Re: sql query
sysdate - 1 is sysdate minus one day sysdate - 1/24 is sysdate minus 1 hour sysdate - 1/24/60 is sysdate minus 1 minute = sysdate -1/(24*60) sysdate - 1/24/60/60 is sysdate minus 1 second = sysdate - 1/(24*60*60) = sysdate - 1/(24*3600) "Ravindra Basavaraja" To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] ravindra@sent cc: ica.com Subject: sql query Sent by: [EMAIL PROTECTED] om 03-04-2001 06:00 Please respond to ORACLE-L I found a query to get the time 5 seconds less than the current time as select to_char(sysdate-5/(24*3600),'dd-mon- hh24:mi:ss') from dual; I am really not sure as to why 24*3600 is used for. Can anyone tell me why it is used. Thanks Ravindra -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ravindra Basavaraja INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = De informatie verzonden in dit e-mailbericht is vertrouwelijk en is uitsluitend bestemd voor de geadresseerde. Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan derden is, behoudens voorafgaande schriftelijke toestemming van Ernst Young, niet toegestaan. Ernst Young staat niet in voor de juiste en volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch voor tijdige ontvangst daarvan. Ernst Young kan niet garanderen dat een verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden. Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u vriendelijk doch dringend het e-mailbericht te retourneren aan de verzender en het origineel en eventuele kopien te verwijderen en te vernietigen. Ernst Young hanteert bij de uitoefening van haar werkzaamheden algemene voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De algemene voorwaarden worden u op verzoek kosteloos toegezonden. = The information contained in this communication is confidential and is intended solely for the use of the individual or entity to whom it is addressed. You should not copy, disclose or distribute this communication without the authority of Ernst Young. Ernst Young is neither liable for the proper and complete transmission of the information contained in this communication nor for any delay in its receipt. Ernst Young does not guarantee that the integrity of this communication has been maintained nor that the communication is free of viruses, interceptions or interference. If you are not the intended recipient of this communication please return the communication to the sender and delete and destroy all copies. In carrying out its engagements, Ernst Young applies general terms and
RE: sql query
Hi , 3600 is for 60min x 60 sec. Cheers :) Rama Raju -Original Message- Basavaraja Sent: Tuesday, April 03, 2001 9:30 AM To: Multiple recipients of list ORACLE-L I found a query to get the time 5 seconds less than the current time as select to_char(sysdate-5/(24*3600),'dd-mon- hh24:mi:ss') from dual; I am really not sure as to why 24*3600 is used for. Can anyone tell me why it is used. Thanks Ravindra -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ravindra Basavaraja INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Ram INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
WAIT info in event10046 raw traces
Hello, When is WAIT information written to event10046 raw trace file, after each WAIT or another mechanism such as cummulative writes after a specified count ? If it's after each WAIT,for example, we will be able to say, each IO related wait event in trace file is counterpart of one IO system call. and some P3 values will always be 1. thanks in advance... = --- Danisment Gazi Unal Web: http://www.geocities.com/danisment --- __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Qualifying columns to improve performance?
Why not try the two (one with qualifiers and one without) and trace each - on a freshly started database... See how much additional recursive sql occurs (if any) hth connor --- Arn Klammer [EMAIL PROTECTED] wrote: At a course some years ago, we were told that in join statements, we should qualify ALL our column names with the appropriate table name, not just those that may be ambiguous. The reason was that the parser would not need to spend time checking multiple tables to determine the table to which each column belongs. Is this still a valid rule? Does this apply to statements in PL/SQL procedures/packages? Or are they different, because they are checked at compile time? -a ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. www.mimesweeper.com ** = Connor McDonald http://www.oracledba.co.uk (mirrored at http://www.oradba.freeserve.co.uk) "Some days you're the pigeon, some days you're the statue" Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie -- 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).
Manage of 9IAS
Title: Manage of 9IAS Hi gurus, I installed 9IAS on a Unix server. I installed all Oracle products with the Unix user ORACLE and its primary group OINSTALL. My installation is done, but I want to manage my IAS with another user called IAS and primary group DBA. My problem is : Everything (logs, httpd.pid) belong to Unix user ORACLE (OINSTALL). I can't manage 9IAS with another user. For those of you working with IAS, do you manage it using Oracle user ? Or have you changed the file permissions ? Or reinstall with ORACLE user and group DBA. ? TIA - Luc Demanche CETELEM Tél.: 01-46-39-14-49 Fax : 01-46-39-59-88
RE: Legato Networker Module
We are thinking to use legato Networker module for 24x7 availability. Any body had any experience (good/bad) or can give any tips Thanks Sam -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sam P. Roberts (ZADCO ITIS) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Constraints with Synonyms?
Hi, I have a need to create a synonym in a schema (A) for a table that is another schema (B). This is no problem. However, the table in question is a "parent" table and I cannot create the "references" constraint from the "child" to the "parent" when the "parent" is a synonym. When I attempt to do so I get an ORA-1031 error (Insufficient Privileges). Is this a known limitation of synonyms or am I missing something here? I find the 1031 error a strange one to receive if this a limitation of synonyms--schema A has DBA role granted to it so the problem shouldn't be one of permissions. Any suggestions/feedback would be appreciated. Thanks!! -w PS: Recreating the table from schema B in schema A is not an option, unfortunately.
Re: Ver Urgent
What You HAVE to do is: Create new initNEW_SID.ora file with all the proper new locations set (Be VERY CAREFUL WHEN YOU COPY AND RENAME EXISTING ONE) create a symlink in the $ORACLE_HOME/dbs directory pointing to this file (Or put the initfile there) set your environment variables to point to new SID (export ORACLE_SID=NEW_SID) start servermanager connect internal (or connect / as sysdba) startup nomount give the create database command (make sure database name is same as in initNEW_SID.ora file) run catalog, catproc and catexp as sys (internal) run pupbld.sql as system edit your tnsnames.ora and listener.ora to include the new database Now you can create your tablespaces, rollback segments and database objects. (this order) I hope I didn't miss anything here. As far as your other instance is concerned what are the error messages you are getting when trying to start it??? Met vriendelijke groet, Jacob van Zanen (Oracle DBA) Informatie Systemen Ernst Young Informatie Communicatie Technologie Kantoor Gouda Tel.: 0182 575316 (intern: 923 316) Fax: 0182 536311 E-mail: [EMAIL PROTECTED] "Dash, Saroj (CAP,CEF)" To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Saroj.Dash@geca cc: pital.com Subject: Ver Urgent Sent by: [EMAIL PROTECTED] 03-04-2001 12:35 Please respond to ORACLE-L Hello All, I want to create one more database in a UNIX machine. Previously one instance is already there. Please tell what are the factors will be keep while creating one more instance in same server. Both the instance `s ORACLE_HOME is same. But different ORACLE_SID. I tried to create New instnace ,but My prevoious instance is down ,I tried to up the previous database ,while startup he is asking for my new databae `s file. Please suggest me what i will do. Regards, Saroj. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dash, Saroj (CAP,CEF) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = De informatie verzonden in dit e-mailbericht is vertrouwelijk en is uitsluitend bestemd voor de geadresseerde. Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan derden is, behoudens voorafgaande schriftelijke toestemming van Ernst Young, niet toegestaan. Ernst Young staat niet in voor de juiste en volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch voor tijdige ontvangst daarvan. Ernst Young kan niet garanderen dat een verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden. Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u vriendelijk doch dringend het e-mailbericht te retourneren aan de verzender en het origineel en eventuele kopien te verwijderen en te vernietigen. Ernst Young hanteert bij de uitoefening van haar werkzaamheden algemene voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De algemene voorwaarden worden
Re: Manage of 9IAS
I've used a different user:group (oraweb:oraweb) for OAS/iAS software. [EMAIL PROTECTED] 04/03/01 07:10AM Hi gurus, I installed 9IAS on a Unix server. I installed all Oracle products with the Unix user ORACLE and its primary group OINSTALL. My installation is done, but I want to manage my IAS with another user called IAS and primary group DBA. My problem is : Everything (logs, httpd.pid) belong to Unix user ORACLE (OINSTALL). I can't manage 9IAS with another user. For those of you working with IAS, do you manage it using Oracle user ? Or have you changed the file permissions ? Or reinstall with ORACLE user and group DBA. ? TIA - Luc Demanche CETELEM Tl.: 01-46-39-14-49 Fax : 01-46-39-59-88 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gene Sais INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Redo log size MAX = ?
Hi, My database = noarchive mode (compulsory for our application) In case of instance failure can oracle perform recovery from redo log ? if can what will be tne maximum size of the redo log recommended. Because I need set that size for whole day transaction currently 512K (3 redo logs) switched every 15 - 30 minutes. Can oracle perform recovery from inactive or "other status" redo log ? 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).
RE: WAIT info in event10046 raw traces
Hi Danisment, It is after each wait. Whether each wait corresponds to a single system call depends on whether the file is multiplexed, and whether Oracle passes large multiblock reads to the operating system in a single call on that platform. @ Regards, @ Steve Adams @ http://www.ixora.com.au/ @ http://www.christianity.net.au/ -Original Message- Sent: Tuesday, 3 April 2001 21:10 To: Multiple recipients of list ORACLE-L Hello, When is WAIT information written to event10046 raw trace file, after each WAIT or another mechanism such as cummulative writes after a specified count ? If it's after each WAIT,for example, we will be able to say, each IO related wait event in trace file is counterpart of one IO system call. and some P3 values will always be 1. thanks in advance... = --- Danisment Gazi Unal Web: http://www.geocities.com/danisment --- __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Steve Adams INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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 question
Surjit, You could set up your PL/SQL procedure to order your query on a unique column such as PK, then return just 20 rows of data plus the last PK value to the application. The application could then supply this PK value in its next request such that your procedure now returns 20 more rows PK. Ron Morton Database Architect / Administrator Union Switch Signal Inc [EMAIL PROTECTED] -Original Message- From: Surjit Sharma [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, April 03, 2001 8:46 AM To: Multiple recipients of list ORACLE-L Subject: Sql question All I am sure this question has come up here before. I need to get the limited number of rows from a table at a time (say 20 rows ) using sql . I know this can be achieved using PL/SQL. This is typically required in web based applications where you can only show a few records at a time. Your comments are highly appreciated. Regards. Surjit -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Surjit Sharma INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Morton, Ronald D INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: FOREIGN KEY to a remote table. Is it possible?
Nope, if you want to enforce RI thru a link, you'll need to implement it via triggers, email me offline, i'll give you the concept, i had to do it about 5 years ago. Joe From: "Andor Gyula" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: FOREIGN KEY to a remote table. Is it possible? Date: Tue, 03 Apr 2001 05:40:45 -0800 MIME-Version: 1.0 Received: from localhost (localhost [127.0.0.1])by parents.the-testas.net (8.9.3/8.8.7) with ESMTP id JAA13960for jtestamail@localhost; Tue, 3 Apr 2001 09:33:47 -0400 Received: from mail.the-testas.netby localhost with POP3 (fetchmail-5.3.1)for jtestamail@localhost (multi-drop); Tue, 03 Apr 2001 09:33:47 -0400 (EDT) Received: from newsfeed.cts.com (newsfeed.cts.com [209.68.192.199])by mail.acfi.net (8.11.0/8.11.0) with ESMTP id f33Ed3527925for [EMAIL PROTECTED]; Tue, 3 Apr 2001 09:39:03 -0500 Received: from fatcity.UUCP (uucp@localhost)by newsfeed.cts.com (8.9.3/8.9.3) with UUCP id GAA25699;Tue, 3 Apr 2001 06:30:56 -0700 (PDT) Received: by fatcity.com (26-Feb-2001/v1.0g-b70/bab) via UUCP id 002DF715; Tue, 03 Apr 2001 05:40:45 -0800 Return-Path: [EMAIL PROTECTED] Message-ID: [EMAIL PROTECTED] X-Comment: Oracle RDBMS Community Forum X-Sender: "Andor Gyula" [EMAIL PROTECTED] Sender: [EMAIL PROTECTED] Errors-To: [EMAIL PROTECTED] Organization: Fat City Network Services, San Diego, California X-ListServer: v1.0g, build 70; ListGuru (c) 1996-2001 Bruce A. Bergman Precedence: bulk X-Fetchmail-Warning: recipient address [EMAIL PROTECTED] didn't match any local name X-SpamBouncer: 1.2 (10/20/00) X-SBPass: NoBounce X-SBClass: OK Status: HI, Is is possible to create a FOREIGN KEY constraint that references to a remote table through DATABASE LINK? Thanks in advance Gyula -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andor Gyula INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
OCI
All, Using Oracle 8.0.5.0.0 Compaq Tru64 v4.f One of the duhvelopers here wants to use OCI. I am sure it is installed as part of the server installation but where do all the relevant files live for him to use. I can only find oci files in $ORACLE_HOME/rdbms/demo. Is this normal. ?? Regards Lee Robertson Acxiom Tel: 0191 525 7344 Fax: 0191 525 7007 Email: [EMAIL PROTECTED] The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system.
Rollback seg for an entire session, not just per transaction? Implicit commits in PL/SQL?
A colleague wants to do a large load using multiple PL/SQL programs; she typically (has the DBA) turns off all rollback segments except for SYSTEM and one large rollback segment. Some questions: Will the rollback segment called SYSTEM in the SYSTEM tablespace never be used for user session transactions? Is there any way to specify which rollback segment to use for an entire session versus per transaction? I'm not sure if her PL/SQL code performs implicit commits so I'm not sure doing one commit + set transaction before executing the procedure(s) will have the desired effect. Will Oracle ever do an implicit commit inside a PL/SQL procedure or is a commit performed only with the commit command or when exiting a procedure? Thanks very much. - Dana __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: dana INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OCI
Yes it is. In 8.1.7 it's moved to the more appropriate $ORACLE_HOME/rdbms/public. You work for AXCIOM? The same AXCIOM that has a huge database of personal data for sale? -Original Message- Sent: Tuesday, April 03, 2001 10:45 AM To: Multiple recipients of list ORACLE-L All, Using Oracle 8.0.5.0.0 Compaq Tru64 v4.f One of the duhvelopers here wants to use OCI. I am sure it is installed as part of the server installation but where do all the relevant files live for him to use. I can only find oci files in $ORACLE_HOME/rdbms/demo. Is this normal. ?? Regards Lee Robertson Acxiom Tel:0191 525 7344 Fax:0191 525 7007 Email: [EMAIL PROTECTED] The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Recovery Manager vs. SQL Back Track
Title: Recovery Manager vs. SQL Back Track Hi everyone - Currently we are doing backups manually, periodic cold backups, and hot backups in between - we are running in archivelog mode. We are running 8.1.5 and 8.1.6 (soon to be 8.1.7) on Sun Solaris. Today there are only a few small production servers (2 - 5 GB), but we are anticipating a couple large ones (~200GB), and a data warehouse (anticipated to be around 500GB). We have started playing around with Recovery Manager. Our Sybase DBAs are telling us we should look at SQL BackTrack instead. For those of you who are using either one, I'd appreciate your comments on how well you like / don't like it and any gotcha's that you have run into. Other than the cost factor, what would you recommend? Thanks very much - Lisa
RE: Linux ver and Oracle
At 01:52 PM 4/2/01 -0800, you wrote: I've found RH6.2 and Oracle 8.1.7.0.1 to be pretty compatible. Don't know about the other Linux distributions. That's interesting. I have an 8.1.6 and 8.1.7 installation cd, and RH6.2 . Tried installing 8.1.7, and it died with the "800%cpu" thing. 8.1.6 installed in a snap. Of course, the Oracle installation is sensitive to latitude and longitude, the phase of the moon, proper use of cursing, the color of your tie, etc. Maybe I need to sacrifice a chicken first Dennis Taylor No one's life, liberty, or property is safe when the legislature is in session. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dennis Taylor INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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*loader default value
Thanx to Witold and Prakash for suggesting NULLIF and DEFAULTIF. Unfortunately, it looks like both of those do basically the opposite of what I'm trying to accomplish. Essentially, I want to prevent sql*loader from ever inserting NULL in a column (which may not be numeric), substituting whatever value is appropriate for the given application instead. Something like using "nvl(:field,'unknown')" in the field specification of the control file for conventional path loads. As far as I can see, there's no way to do this within sql*loader itself. So the choices would be to run a cleanup just after the load (which may or may not negate the speed benefits of using direct path), or to somehow pre-process the data file to fill in the missing values (perhaps an awk or perl script). Of course, if I'm missing something obvious please let me know... the sql*loader documentation seems designed to confuse. (-: Cheers!
RE: Sql question
Surjit, The syntax is: Select * From MyTable Where RowNum 21 Andmore of your predicates ; Jack Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com [EMAIL PROTECTED] -Original Message- Surjit Sharma Sent: Tuesday, April 03, 2001 7:46 AM To: Multiple recipients of list ORACLE-L All I am sure this question has come up here before. I need to get the limited number of rows from a table at a time (say 20 rows ) using sql . I know this can be achieved using PL/SQL. This is typically required in web based applications where you can only show a few records at a time. Your comments are highly appreciated. Regards. Surjit -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack C. Applewhite INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: SQLServer vs. Oracle Papers Needed
here's some information i found; any of you helpful gurus, please correct my misconceptions or mistakes as necessary... === snipped from various other e-mails === -Original Message- one highly regarded training organization is learningtree.com, they offer both sql and oracle training; Oracle corporation also offers training. i was looking for a tale-of-the-tape on ms-sql vs. oracle, as expected, dependant upon where you look the opinion varies. one interesting site is http://www.tpc.org which is one of those independent, industry standard, benchmarking organization relating to transaction processing. they've got a measurement scale for RDBMS' and their processing performance. the tpm and/or tpmC which is transactions per minute and/or transactions per minute Cost. they have some interesting information that we might want to review and consider in the design of this solution, some of the configurations cost several million dollars or more but the concepts, components, peripherals, and results are of more interest. for example they list a 10 million dollar compaq, MS-SQL 2K, windows 2000 datacenter, clustered solution, with over 40TB of storage. now i doubt we'd be able to implement that or if we want the high number of transactions per minute produced by this; but it might help us in envisioning a scaled down solution for ourselves as well as getting an idea of what we should look at as metrics for determining if the re-design is done correctly. === Lerone Streeter System Analyst Abbott LBG [EMAIL PROTECTED] === -Original Message- Sent: Monday, April 02, 2001 5:06 PM To: Multiple recipients of list ORACLE-L I need pointers to papers/studies that compare and contrast SQLServer vs. Oracle. I'm specifically looking for studies which appear impartial and conclude that Oracle is the better choice. Thanks in advance. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tom Pall (E-mail) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Streeter, Lerone A LBX INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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 on Linux questions
I have had good luck with Red Hat Linux 6.2 and Oracle 8.1.6.1 for Linux. You don't need to do any upgrades to Linux before installing Oracle, you don't have to download your own Java virtual machine, and you don't have to install any Oracle patches to make it work (as I had to with Oracle 8.1.5). On Metalink under Product Lifecycle there is a list of Linux distributions and versions that are certified with the different versions of Oracle server for Linux. I have heard good things about SuSe Linux also, including the fact that they have created a package (RPM) that does much of the Oracle setup for you including providing scripts for database startup and shutdown. As far as Linux books, there are several. I have the O'Reilly book, "Running Linux". The lastest versions of most Unix books now cover Linux as well. HTH, Dean Jefferson Database Administrator State of Wisconsin Office of Commissioner of Insurance [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jefferson, Dean INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Linux ver and Oracle
I used the Oracle 8.1.7 with OPS linux version. Were your version just 8.1.7 or 8.1.7 with OPS? Richard -Original Message- Taylor Sent: Tuesday, April 03, 2001 11:26 AM To: Multiple recipients of list ORACLE-L At 01:52 PM 4/2/01 -0800, you wrote: I've found RH6.2 and Oracle 8.1.7.0.1 to be pretty compatible. Don't know about the other Linux distributions. That's interesting. I have an 8.1.6 and 8.1.7 installation cd, and RH6.2 . Tried installing 8.1.7, and it died with the "800%cpu" thing. 8.1.6 installed in a snap. Of course, the Oracle installation is sensitive to latitude and longitude, the phase of the moon, proper use of cursing, the color of your tie, etc. Maybe I need to sacrifice a chicken first Dennis Taylor No one's life, liberty, or property is safe when the legislature is in session. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dennis Taylor INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Richard Ji INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OCI
Actually, it probably isn't part of the server installation, but if you have the oci.h in $ORACLE_HOME/rdbms/demo then you probably have everything you need. Now, if he wants to use it from a Win32 desktop, then in the client install the files would be in $ORACLE_HOME/OCI8 or something like that. There you will find the library files and the header files as well as several demos. Dan -Original Message-From: lerobe - Lee Robertson [mailto:[EMAIL PROTECTED]]Sent: Tuesday, April 03, 2001 10:45 AMTo: Multiple recipients of list ORACLE-LSubject: OCI All, Using Oracle 8.0.5.0.0 Compaq Tru64 v4.f One of the duhvelopers here wants to use OCI. I am sure it is installed as part of the server installation but where do all the relevant files live for him to use. I can only find oci files in $ORACLE_HOME/rdbms/demo. Is this normal. ?? Regards Lee Robertson Acxiom Tel: 0191 525 7344 Fax: 0191 525 7007 Email: [EMAIL PROTECTED] 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._This e-mail message has been scanned for the presence of all known computer viruses by the MessageLabs Virus Control Center. However, it is still recommended that you use local virus scanning software to monitor for the presence of viruses.
RE: Qualifying columns to improve performance?
Hi Arn, There may be good reasons for explicitly qualifying all column references, but performance is not one of them, at least under Oracle 8i. I've just done some tests and there is absolutely no difference in the number of dictionary cache gets required during the parse, and no measurable difference in CPU usage. I too remember being taught this back in version 6 days, and it is in the Gurry and Corrigan "Oracle Performance Tuning" book (2nd edition, page 138) so there may have been some validity to it in the past. @ Regards, @ Steve Adams @ http://www.ixora.com.au/ @ http://www.christianity.net.au/ -Original Message- Sent: Tuesday, 3 April 2001 12:30 To: Multiple recipients of list ORACLE-L At a course some years ago, we were told that in join statements, we should qualify ALL our column names with the appropriate table name, not just those that may be ambiguous. The reason was that the parser would not need to spend time checking multiple tables to determine the table to which each column belongs. Is this still a valid rule? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steve Adams INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: FOREIGN KEY to a remote table. Is it possible?
At 05:40 AM 4/3/01 -0800, you wrote: Is is possible to create a FOREIGN KEY constraint that references to a remote table through DATABASE LINK? From the Oracle 8i SQL Reference, Volume 2 (PN A76988-01), page 7-240, about halfway down the page: "The child and parent tables must be on the same database. To enable referential integrity constraints across nodes of a distributed database, you must use database triggers". Sorry about the tone. Fairly cranky today. Dennis Taylor No one's life, liberty, or property is safe when the legislature is in session. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dennis Taylor INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
function to get GMT time
Hi ! Is there a way to get GMT time within PL/SQL independent from the local time(zone), I'm looking for a function similar to SYSDATE, but it should return GMT instead of the local time. TIA Andreas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Haunschmidt Andreas VASL/FAS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: sql query
That's converting hours to seconds. 60x60. Shakeel --- Ravindra Basavaraja [EMAIL PROTECTED] wrote: I found a query to get the time 5 seconds less than the current time as select to_char(sysdate-5/(24*3600),'dd-mon- hh24:mi:ss') from dual; I am really not sure as to why 24*3600 is used for. Can anyone tell me why it is used. Thanks Ravindra -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ravindra Basavaraja INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shakeel Qureshi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Metalink Response ....FYI
Hi All, I'd say that there must be something badly wrong with the application if it cannot cope with 1,500 concurrent users. I know of sites supporting more than 20 times that number of active users on a single server with consistent sub-second response times. @ Regards, @ Steve Adams @ http://www.ixora.com.au/ @ http://www.christianity.net.au/ -Original Message- Sent: Wednesday, 4 April 2001 0:35 To: Multiple recipients of list ORACLE-L Hi Folks , I know lot of Metastink info floating around...so I thought I would post this for fun/info . I got this response from Metastink .. "Thank you for your comments on Metalink, the more feedback we get the better we here at Oracle Corporation will be able to service your needs. We have seen tremendous increase in customer usage of Metalink over the past 6 months. There are now about 240,000 registered users and at times we have over 1,500 active users. We know that the service does not meet our or customers expectations. With this in mind we have added capacity to our database servers and have also increased the number of middle tier application servers. Our experience is that the demand for online services has become so strong that as soon as we bring in more capacity, it is quickly consumed. We have also experience intermittent network and architecture problems that have caused several failovers from one server to the other resulting in slower performance than we expect. When these events occur, we strive to understand root cause and take corrective and preventive action. Sometime before summer, we exp!!ect to migrate the online services to Oracle's Customer Relationship Management (CRM) suite enabling us to deliver more to our customers.This is a global issue for us and it has great attention within Oracle management. We recognize how valuable our customers are to us and understand the immense value that Metalink can bring to them. We are working to meet your needs as fast as we can. Thank you for your patience as we continue to work to bring you the best in online support services." Interesting.won't you say..: ) RS __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raj Sakthi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Steve Adams INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
AT scheduler
Can anyone tell me how to schedule a batch job to run every 5 minutes using the "AT" scheduler? Thanks! -- 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: Sql question
On subsequent select select * from mytable where rownum 40 minus select * from mytable where rownum 20. This will bring rows between 20 and 40. On the next select, replace 40 with 60 and 20 with 40 -Original Message- Sent: 03 April 2001 15:26 To: Multiple recipients of list ORACLE-L Surjit, The syntax is: Select * From MyTable Where RowNum 21 Andmore of your predicates ; Jack Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com [EMAIL PROTECTED] -Original Message- Surjit Sharma Sent: Tuesday, April 03, 2001 7:46 AM To: Multiple recipients of list ORACLE-L All I am sure this question has come up here before. I need to get the limited number of rows from a table at a time (say 20 rows ) using sql . I know this can be achieved using PL/SQL. This is typically required in web based applications where you can only show a few records at a time. Your comments are highly appreciated. Regards. Surjit -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack C. Applewhite INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Raj Gopalan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Exp/Imp Fromuser/Touser Security
Using an "OPS$" user would be much preferred to that. If that user is given DBA privilege, it can export/import the full database. Sys password in a file? Did you schedule a public execution? -Original Message- Sent: Tuesday, April 03, 2001 10:00 AM To: Multiple recipients of list ORACLE-L Hi, I have a group of developers that need to perform their own imports of another schema's tables. The previous DBA created some refresh scripts to do this but to get around the fromuser/touser issue he created a dot-file with the password to SYS and reads that password in within the script. Yikes!! My question is, is there another "solution" that doesn't compromise database security? I'm hesitant to grant the IMP_FULL_DATABASE role to these users. Any suggestions/feedback would be GREATLY appreciated. Thanks again!! -w __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Walter K INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Rollback seg for an entire session, not just per transaction?
Dana 1. System rollback segment will be used for user session transactions. 2. The only way I think of assinging a rollback segment is by using SET TRANSACTION COMMAND. 3. There wont be any implict commits in a PL/SQL procedure and on exit of the PL/SQL will also not commit the data. You need to explicitly specify the commit. -Original Message- Sent: 03 April 2001 15:55 To: Multiple recipients of list ORACLE-L Implicit commits in PL/SQL? A colleague wants to do a large load using multiple PL/SQL programs; she typically (has the DBA) turns off all rollback segments except for SYSTEM and one large rollback segment. Some questions: Will the rollback segment called SYSTEM in the SYSTEM tablespace never be used for user session transactions? Is there any way to specify which rollback segment to use for an entire session versus per transaction? I'm not sure if her PL/SQL code performs implicit commits so I'm not sure doing one commit + set transaction before executing the procedure(s) will have the desired effect. Will Oracle ever do an implicit commit inside a PL/SQL procedure or is a commit performed only with the commit command or when exiting a procedure? Thanks very much. - Dana __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: dana INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Raj Gopalan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Redo log size MAX = ?
That would be one of those RTFM questions, don't you think? -Original Message- Sent: Tuesday, April 03, 2001 10:00 AM To: Multiple recipients of list ORACLE-L Why can't you use archiving? It doesn't effect the applications running on the database in anyway (except space to store the archives) [EMAIL PROTECTED] 04/03/01 09:00AM Hi, My database = noarchive mode (compulsory for our application) In case of instance failure can oracle perform recovery from redo log ? if can what will be tne maximum size of the redo log recommended. Because I need set that size for whole day transaction currently 512K (3 redo logs) switched every 15 - 30 minutes. Can oracle perform recovery from inactive or "other status" redo log ? 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: William Beilstein INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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*loader default value
Gregory, On doing some research, found that a number column can be populated with a 0 using the direct load path, if the input value is null by having the following line in the control file: field1 integer external defaultif (field1 = 'NULL') But the same thing doesn't work for char columns. So you are right! Prakash -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 03, 2001 11:20 AM To: Multiple recipients of list ORACLE-L Thanx to Witold and Prakash for suggesting NULLIF and DEFAULTIF. Unfortunately, it looks like both of those do basically the opposite of what I'm trying to accomplish. Essentially, I want to prevent sql*loader from ever inserting NULL in a column (which may not be numeric), substituting whatever value is appropriate for the given application instead. Something like using "nvl(:field,'unknown')" in the field specification of the control file for conventional path loads. As far as I can see, there's no way to do this within sql*loader itself. So the choices would be to run a cleanup just after the load (which may or may not negate the speed benefits of using direct path), or to somehow pre-process the data file to fill in the missing values (perhaps an awk or perl script). Of course, if I'm missing something obvious please let me know... the sql*loader documentation seems designed to confuse. (-: Cheers! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bala, Prakash INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: sql query
60 seconds * 60 minutes =3600 secnods per hour. 3600 * 24 hours = 86400 seconds per day. Scott Shafer San Antonio, TX 210-581-6217 -Original Message- From: Ravindra Basavaraja [SMTP:[EMAIL PROTECTED]] Sent: Monday, April 02, 2001 11:00 PM To: Multiple recipients of list ORACLE-L Subject: sql query I found a query to get the time 5 seconds less than the current time as select to_char(sysdate-5/(24*3600),'dd-mon- hh24:mi:ss') from dual; I am really not sure as to why 24*3600 is used for. Can anyone tell me why it is used. Thanks Ravindra -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ravindra Basavaraja INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Qualifying columns to improve performance?
Hi, you should better reuse your parsed statements oli [EMAIL PROTECTED] wrote At a course some years ago, we were told that in join statements, we should qualify ALL our column names with the appropriate table name, not just those that may be ambiguous. The reason was that the parser would not need to spend time checking multiple tables to determine the table to which each column belongs. Is this still a valid rule? Does this apply to statements in PL/SQL procedures/packages? Or are they different, because they are checked at compile time? -a ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. This footnote also confirms that this email message has been swept by MIMEsweeper for the presence of computer viruses. www.mimesweeper.com ** To: [EMAIL PROTECTED] Content-Type: application/octet-stream; charset="iso-8859-1"; name="TEXT.htm" Content-Transfer-Encoding: base64 Content-Description: -- Oliver Artelt Oracle Certified DBA cubeoffice GmbH Co.KG # jordanstrasse 7 # 39112 magdeburg telefon: +49 (0)391 6 11 28 10 # telefax: +49 (0)391 6 11 28 19 email: [EMAIL PROTECTED] # web: http://www.cubeoffice.de -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Oliver Artelt INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Multi Threaded Server
Hi All, We have about 400-500 connections to our database and are now considering going to MTS. Can anybody share their experience? pitfalls? things to take care of? performance issues? Any help appreciated. Our main objective is to lower the amount of RAM consumed by the Oracle sessions. Jack (Oracle DBA) Informatie Systemen Ernst Young Informatie Communicatie Technologie Kantoor Gouda Tel.: 0182 575316 (intern: 923 316) Fax: 0182 536311 E-mail: [EMAIL PROTECTED] = De informatie verzonden in dit e-mailbericht is vertrouwelijk en is uitsluitend bestemd voor de geadresseerde. Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan derden is, behoudens voorafgaande schriftelijke toestemming van Ernst Young, niet toegestaan. Ernst Young staat niet in voor de juiste en volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch voor tijdige ontvangst daarvan. Ernst Young kan niet garanderen dat een verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden. Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u vriendelijk doch dringend het e-mailbericht te retourneren aan de verzender en het origineel en eventuele kopien te verwijderen en te vernietigen. Ernst Young hanteert bij de uitoefening van haar werkzaamheden algemene voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De algemene voorwaarden worden u op verzoek kosteloos toegezonden. = The information contained in this communication is confidential and is intended solely for the use of the individual or entity to whom it is addressed. You should not copy, disclose or distribute this communication without the authority of Ernst Young. Ernst Young is neither liable for the proper and complete transmission of the information contained in this communication nor for any delay in its receipt. Ernst Young does not guarantee that the integrity of this communication has been maintained nor that the communication is free of viruses, interceptions or interference. If you are not the intended recipient of this communication please return the communication to the sender and delete and destroy all copies. In carrying out its engagements, Ernst Young applies general terms and conditions, which contain a clause that limits its liability. A copy of these terms and conditions is available on request free of charge. = -- 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: function to get GMT time
Hi Andreas, You can do this with the NEW_TIME date funntion: SQL alter session set NLS_DATE_FORMAT = 'DD-MM-YYY HH24:MI:SS'; Session altered. SQL select sysdate "GMT" from dual; GMT -- 03-04-001 17:05:25 SQL select new_time(sysdate, 'GMT', 'AST') "AST" from dual; AST -- 03-04-001 13:08:41 This shows Atlantic Standard Time, there are a list of the time zones available, and description of the funciton in the SQL Reference Manaual - page 185 HTH Mark -Original Message- Andreas VASL/FAS Sent: Tuesday, April 03, 2001 04:45 To: Multiple recipients of list ORACLE-L Hi ! Is there a way to get GMT time within PL/SQL independent from the local time(zone), I'm looking for a function similar to SYSDATE, but it should return GMT instead of the local time. TIA Andreas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Haunschmidt Andreas VASL/FAS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
OID installation
From the Oracle 8.1.7 Solaris installation guide: "If Oracle Universal Installer detects an existing Oracle8i database in this location, it does not install another one. However, for optimal results, Oracle Corporation recommends that you install Oracle Internet Directory on a system that does not currently have an Oracle8i database." Is the purpose of this recommendation to ensure best performance, or is there some other issue? Thanks. Paul Baumgartel InstiPro, Inc. [EMAIL PROTECTED] 212 813-0829 x103 (office) 917 549-4717 (mobile) -- 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: Redo log size MAX = ?
Is this true? I thought that if the transactions needed for recovery are in the online redo logs, and the online logs are available, then the RECOVER DATABASE statement will read from the online logs. Just did it this morning on a noarchivelog database, Oracle 7.3.3. If however, the data needed for recovery in the online logs has been overwritten, then the database will be unrecoverable. Scott Shafer San Antonio, TX 210-581-6217 -Original Message- From: Zhou, Tapiwanashe [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, April 03, 2001 10:05 AM To: Multiple recipients of list ORACLE-L Subject: RE: Redo log size MAX = ? hi forget about recovery from online redo logs It doesn't exist in Oracle Regards Tapiwa -Original Message- Sent: Tuesday, April 03, 2001 3:01 PM To: Multiple recipients of list ORACLE-L Hi, My database = noarchive mode (compulsory for our application) In case of instance failure can oracle perform recovery from redo log ? if can what will be tne maximum size of the redo log recommended. Because I need set that size for whole day transaction currently 512K (3 redo logs) switched every 15 - 30 minutes. Can oracle perform recovery from inactive or "other status" redo log ? 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: Zhou, Tapiwanashe INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Metalink Response ....FYI
Title: RE: Metalink Response FYI rant 1500 users? And ORACLE FREAKING CORPORATION is having trouble meeting the demand? Geez Louise, this is *exactly* the type of thing companies get roasted alive for. I am supposed to believe these guys when they say We'll scale all the way to Andromeda!. Sheesh, we run multiple databases around here with 1500+ active users from a base of 40,000 with nowhere near the response problems. We have had two unsked outages a year, on average. Oracle really needs to hire some system engineers and DBAs. What a freaking joke. rant/ Thanks for the news, Raj. Now I feel better about Metalink. ||-Original Message- ||From: Raj Sakthi [mailto:[EMAIL PROTECTED]] ||Sent: Tuesday, April 03, 2001 10:35 AM ||To: Multiple recipients of list ORACLE-L ||Subject: Metalink Response FYI || || ||Hi Folks , ||I know lot of Metastink info floating around...so I ||thought I would post this for fun/info . ||I got this response from Metastink .. || ||Thank you for your comments on Metalink, the more ||feedback we get the better we ||here at Oracle Corporation will be able to service ||your needs. We have seen ||tremendous increase in customer usage of Metalink over ||the past 6 months. ||There are now about 240,000 registered users and at ||times we have over 1,500 active users. ||We know that the service does not meet our or ||customers expectations. With this in mind we ||have added capacity to our database servers and have ||also increased the number of middle ||tier application servers. Our experience is that the ||demand for online services has become ||so strong that as soon as we bring in more capacity, ||it is quickly consumed. We have also ||experience intermittent network and architecture ||problems that have caused several failovers ||from one server to the other resulting in slower ||performance than we expect. When these events ||occur, we strive to understand root cause and take ||corrective and preventive action. ||Sometime before summer, we exp!!ect to migrate the ||online services to Oracle's Customer ||Relationship Management (CRM) suite enabling us to ||deliver more to our customers.This is ||a global issue for us and it has great attention ||within Oracle management. We recognize ||how valuable our customers are to us and understand ||the immense value that Metalink can ||bring to them. We are working to meet your needs as ||fast as we can. Thank you for your ||patience as we continue to work to bring you the best ||in online support services. || ||Interesting.won't you say..: ) ||RS || ||__ ||Do You Yahoo!? ||Get email at your own domain with Yahoo! Mail. ||http://personal.mail.yahoo.com/ ||-- ||Please see the official ORACLE-L FAQ: http://www.orafaq.com ||-- ||Author: Raj Sakthi || INET: [EMAIL PROTECTED] || ||Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 ||San Diego, California -- Public Internet access / Mailing Lists || ||To REMOVE yourself from this mailing list, send an E-Mail message ||to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in ||the message BODY, include a line containing: UNSUB ORACLE-L ||(or the name of mailing list you want to be removed from). You may ||also send the HELP command for other information (like subscribing). ||
Re: Recovery Manager vs. SQL Back Track
I have used rman exclusively since I became an Oracle DBA because it was there and I needed a backup strategy. It has gotten better with later releases. We are now on 8.0.6. It used Oracle internals so that is an advantage. It comes free with Oracle so that is another advantage. I can send you a paper on why to love rman written by Francis Sanchez of Oracle Corp. if you need it. I can't send an attachment through the list. Regards, Ruth - Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Tuesday, April 03, 2001 10:45 AM Hi everyone - Currently we are doing backups manually, periodic cold backups, and hot backups in between - we are running in archivelog mode. We are running 8.1.5 and 8.1.6 (soon to be 8.1.7) on Sun Solaris. Today there are only a few small production servers (2 - 5 GB), but we are anticipating a couple large ones (~200GB), and a data warehouse (anticipated to be around 500GB). We have started playing around with Recovery Manager. Our Sybase DBAs are telling us we should look at SQL BackTrack instead. For those of you who are using either one, I'd appreciate your comments on how well you like / don't like it and any "gotcha's" that you have run into. Other than the cost factor, what would you recommend? Thanks very much - Lisa -- 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: Metalink Response ....FYI
Ranting on... They say there is unexpected demand. They created it by refusing to talk to anyone without their opening an iTar so how can they say it was unexpected. Maybe they are counting on everyone giving up on Metalink thereby reducing demand .. End of ranting... Ruth - Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Tuesday, April 03, 2001 11:50 AM rant 1500 users? And ORACLE FREAKING CORPORATION is having trouble meeting the demand? Geez Louise, this is *exactly* the type of thing companies get roasted alive for. I am supposed to believe these guys when they say "We'll scale all the way to Andromeda!". Sheesh, we run multiple databases around here with 1500+ active users from a base of 40,000 with nowhere near the response problems. We have had two unsked outages a year, on average. Oracle really needs to hire some system engineers and DBAs. What a freaking joke. rant/ Thanks for the news, Raj. Now I feel better about Metalink. ||-Original Message- ||From: Raj Sakthi [mailto:[EMAIL PROTECTED]] ||Sent: Tuesday, April 03, 2001 10:35 AM ||To: Multiple recipients of list ORACLE-L ||Subject: Metalink Response FYI || || ||Hi Folks , ||I know lot of Metastink info floating around...so I ||thought I would post this for fun/info . ||I got this response from Metastink .. || ||"Thank you for your comments on Metalink, the more ||feedback we get the better we ||here at Oracle Corporation will be able to service ||your needs. We have seen ||tremendous increase in customer usage of Metalink over ||the past 6 months. ||There are now about 240,000 registered users and at ||times we have over 1,500 active users. ||We know that the service does not meet our or ||customers expectations. With this in mind we ||have added capacity to our database servers and have ||also increased the number of middle ||tier application servers. Our experience is that the ||demand for online services has become ||so strong that as soon as we bring in more capacity, ||it is quickly consumed. We have also ||experience intermittent network and architecture ||problems that have caused several failovers ||from one server to the other resulting in slower ||performance than we expect. When these events ||occur, we strive to understand root cause and take ||corrective and preventive action. ||Sometime before summer, we exp!!ect to migrate the ||online services to Oracle's Customer ||Relationship Management (CRM) suite enabling us to ||deliver more to our customers.This is ||a global issue for us and it has great attention ||within Oracle management. We recognize ||how valuable our customers are to us and understand ||the immense value that Metalink can ||bring to them. We are working to meet your needs as ||fast as we can. Thank you for your ||patience as we continue to work to bring you the best ||in online support services." || ||Interesting.won't you say..: ) ||RS || ||__ ||Do You Yahoo!? ||Get email at your own domain with Yahoo! Mail. ||http://personal.mail.yahoo.com/ ||-- ||Please see the official ORACLE-L FAQ: http://www.orafaq.com ||-- ||Author: Raj Sakthi || INET: [EMAIL PROTECTED] || ||Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 ||San Diego, California-- Public Internet access / Mailing Lists || ||To REMOVE yourself from this mailing list, send an E-Mail message ||to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in ||the message BODY, include a line containing: UNSUB ORACLE-L ||(or the name of mailing list you want to be removed from). You may ||also send the HELP command for other information (like subscribing). || -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: OCI
Yes, the doku of OCI should be in the platform-specific part. oli [EMAIL PROTECTED] wrote All, Using Oracle 8.0.5.0.0 Compaq Tru64 v4.f One of the duhvelopers here wants to use OCI. I am sure it is installed as part of the server installation but where do all the relevant files live for him to use. I can only find oci files in $ORACLE_HOME/rdbms/demo. Is this normal. ?? Regards Lee Robertson Acxiom Tel:0191 525 7344 Fax:0191 525 7007 Email: [EMAIL PROTECTED] The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. To: [EMAIL PROTECTED] Content-Type: text/html; charset="iso-8859-1"; name="Anhang: 1" Content-Transfer-Encoding: quoted-printable Content-Description: -- Oliver Artelt Oracle Certified DBA cubeoffice GmbH Co.KG # jordanstrasse 7 # 39112 magdeburg telefon: +49 (0)391 6 11 28 10 # telefax: +49 (0)391 6 11 28 19 email: [EMAIL PROTECTED] # web: http://www.cubeoffice.de -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Oliver Artelt INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: OID installation
the skript builds for everything an extra tsp. Be warned. oli TABLESPACE_NAME |INITIAL_EXTENT|NEXT_EXTENT|MIN_EXTENTS|MAX_EXTENTS|PCT_INCREASE|MIN_EXTLEN|STATUS |CONTENTS |LOGGING |EXTENT_MAN|ALLOCATIO|PLU --|--|---|---|---||--|-|-|-|--|-|--- SYSTEM| 16384| 16384| 1| 505| 50| 0|ONLINE |PERMANENT|LOGGING |DICTIONARY|USER |NO RBS01 | 40960| 40960| 1| 505| 50| 0|ONLINE |PERMANENT|LOGGING |DICTIONARY|USER |NO OLTS_ATTRSTORE| 4194304|2097152| 1| 2147483645| 0| 0|ONLINE |PERMANENT|LOGGING |DICTIONARY|USER |NO OLTS_CT_DN| 1048576|1048576| 1| 2147483645| 0| 0|ONLINE |PERMANENT|LOGGING |DICTIONARY|USER |NO OLTS_CT_CN| 1048576|1048576| 1| 2147483645| 0| 0|ONLINE |PERMANENT|LOGGING |DICTIONARY|USER |NO OLTS_CT_OBJCL | 1048576|1048576| 1| 2147483645| 0| 0|ONLINE |PERMANENT|LOGGING |DICTIONARY|USER |NO OLTS_CT_STORE | 4194304|2097152| 1| 2147483645| 0| 0|ONLINE |PERMANENT|LOGGING |DICTIONARY|USER |NO OLTS_DEFAULT |262144|1048576| 1| 2147483645| 0| 0|ONLINE |PERMANENT|LOGGING |DICTIONARY|USER |NO OLTS_TEMP | 1048576|1048576| 1| | 0| 0|ONLINE |TEMPORARY|LOGGING |DICTIONARY|USER |NO OLTS_IND_ATTRSTORE| 1048576|1048576| 1| 2147483645| 0| 0|ONLINE |PERMANENT|LOGGING |DICTIONARY|USER |NO OLTS_IND_CT_DN|524288|1048576| 1| 2147483645| 0| 0|ONLINE |PERMANENT|LOGGING |DICTIONARY|USER |NO TABLESPACE_NAME |INITIAL_EXTENT|NEXT_EXTENT|MIN_EXTENTS|MAX_EXTENTS|PCT_INCREASE|MIN_EXTLEN|STATUS |CONTENTS |LOGGING |EXTENT_MAN|ALLOCATIO|PLU --|--|---|---|---||--|-|-|-|--|-|--- OLTS_IND_CT_CN|524288|1048576| 1| 2147483645| 0| 0|ONLINE |PERMANENT|LOGGING |DICTIONARY|USER |NO OLTS_IND_CT_OBJCL |524288|1048576| 1| 2147483645| 0| 0|ONLINE |PERMANENT|LOGGING |DICTIONARY|USER |NO OLTS_IND_CT_STORE | 1048576|1048576| 1| 2147483645| 0| 0|ONLINE |PERMANENT|LOGGING |DICTIONARY|USER |NO [EMAIL PROTECTED] wrote From the Oracle 8.1.7 Solaris installation guide: "If Oracle Universal Installer detects an existing Oracle8i database in this location, it does not install another one. However, for optimal results, Oracle Corporation recommends that you install Oracle Internet Directory on a system that does not currently have an Oracle8i database." Is the purpose of this recommendation to ensure best performance, or is there some other issue? Thanks. Paul Baumgartel InstiPro, Inc. [EMAIL PROTECTED] 212 813-0829 x103 (office) 917 549-4717 (mobile) -- Oliver Artelt Oracle Certified DBA cubeoffice GmbH Co.KG # jordanstrasse 7 # 39112 magdeburg telefon: +49 (0)391 6 11 28 10 # telefax: +49 (0)391 6 11 28 19 email: [EMAIL PROTECTED] # web: http://www.cubeoffice.de -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Oliver Artelt INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
OFFTOPIC RE: OCI
Title: OFFTOPIC RE: OCI O, I want to buy some! Gimme yer click stream, data boy! ||-Original Message- ||From: Gogala, Mladen [mailto:[EMAIL PROTECTED]] ||Sent: Tuesday, April 03, 2001 11:26 AM ||To: Multiple recipients of list ORACLE-L ||Subject: RE: OCI || || ||Yes it is. In 8.1.7 it's moved to the more appropriate ||$ORACLE_HOME/rdbms/public. ||You work for AXCIOM? The same AXCIOM that has a huge database ||of personal ||data ||for sale? || ||-Original Message- ||Sent: Tuesday, April 03, 2001 10:45 AM ||To: Multiple recipients of list ORACLE-L || || ||All, || ||Using Oracle 8.0.5.0.0 Compaq Tru64 v4.f || ||One of the duhvelopers here wants to use OCI. I am sure it is ||installed as ||part of the server installation but where do all the relevant ||files live for ||him to use. I can only find oci files in ||$ORACLE_HOME/rdbms/demo. Is this ||normal. ?? || ||Regards || ||Lee Robertson ||Acxiom ||Tel: 0191 525 7344 ||Fax: 0191 525 7007 ||Email: [EMAIL PROTECTED] || || || || ||The information contained in this communication is ||confidential, is intended only for the use of the recipient ||named above, and may be legally privileged. If the reader ||of this message is not the intended recipient, you are ||hereby notified that any dissemination, distribution or ||copying of this communication is strictly prohibited. ||If you have received this communication in error, please ||re-send this communication to the sender and delete the ||original message or any copy of it from your computer ||system. || || ||-- ||Please see the official ORACLE-L FAQ: http://www.orafaq.com ||-- ||Author: Gogala, Mladen || INET: [EMAIL PROTECTED] || ||Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 ||San Diego, California -- Public Internet access / Mailing Lists || ||To REMOVE yourself from this mailing list, send an E-Mail message ||to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in ||the message BODY, include a line containing: UNSUB ORACLE-L ||(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 Question
Hello all, Can someone tell me whether or not there is a way do this in SQL? I want to select some data given a certain date range,i.e where some_date between start_date and end_date. Is there a way to group the output by week? In other words, something like: SELECT column_a, column_b, count(*), sum(column_c) FROM table_t WHERE some_date_column BETWEEN :start_date and :end_date GROUP BY ...? How this be grouped by week? Thanks a lot. __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.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).
Slightly OT: Capturing a failed status of an ftp process
I think I've seen an answer to this, but I never needed it before. If anyone can help, I would greatly appreciate it. We are trying to ftp files from one server to another. (Archive logs for Oracle). We want to be able to capture the status when the ftp fails, so that we can notify the DBAs to check the process out. This is all being done within a shell script that compress the log file first, then calls another script to do the actual ftp. But when the child script executes, it returns a successful status to the parent script. I don't know any way to tell the script that is doing the ftp to send the message, because any non-ftp command within that script fails. (Of course, that could just be because I don't know how to do what I want to do). If anybody has invented this wheel before, or has any tips on where to look for more info on how to do what I need to do, please let me know. TIA, Terry -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Terry Ball INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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*loader default value
Sorry I misunderstood your request. Try something like this: THE_VAL POSITION(111:120) DECIMAL EXTERNAL "NVL(:THE_VAL, 33)" It works for me - inserts 33 into numeric column when the datafile contains spaces or nothing (if it is the last field) HTH Witold On 3 Apr 2001, at 7:20, [EMAIL PROTECTED] wrote: Thanx to Witold and Prakash for suggesting NULLIF and DEFAULTIF. Unfortunately, it looks like both of those do basically the opposite of what I'm trying to accomplish. Essentially, I want to prevent sql*loader from ever inserting NULL in a column (which may not be numeric), substituting whatever value is appropriate for the given application instead. Something like using "nvl(:field,'unknown')" in the field specification of the control file for conventional path loads. As far as I can see, there's no way to do this within sql*loader itself. So the choices would be to run a cleanup just after the load (which may or may not negate the speed benefits of using direct path), or to somehow pre-process the data file to fill in the missing values (perhaps an awk or perl script). Of course, if I'm missing something obvious please let me know... the sql*loader documentation seems designed to confuse. (-: Cheers! == Witold Iwaniec Senior Software Developer NovaLIS Technologies [EMAIL PROTECTED] http://www.novalistech.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Witold Iwaniec INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Linux ver and Oracle
8.1.7 R3 Enterprise Edition. No OPS At 08:20 AM 4/3/01 -0800, you wrote: I used the Oracle 8.1.7 with OPS linux version. Were your version just 8.1.7 or 8.1.7 with OPS? Richard -Original Message- Taylor Sent: Tuesday, April 03, 2001 11:26 AM To: Multiple recipients of list ORACLE-L At 01:52 PM 4/2/01 -0800, you wrote: I've found RH6.2 and Oracle 8.1.7.0.1 to be pretty compatible. Don't know about the other Linux distributions. That's interesting. I have an 8.1.6 and 8.1.7 installation cd, and RH6.2 . Tried installing 8.1.7, and it died with the "800%cpu" thing. 8.1.6 installed in a snap. Of course, the Oracle installation is sensitive to latitude and longitude, the phase of the moon, proper use of cursing, the color of your tie, etc. Maybe I need to sacrifice a chicken first Dennis Taylor No one's life, liberty, or property is safe when the legislature is in session. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dennis Taylor INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Richard Ji INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Dennis Taylor No one's life, liberty, or property is safe when the legislature is in session. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dennis Taylor INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Recovery Manager vs. SQL Back Track
Send it through the list. I would like to see it also. Thanks. [EMAIL PROTECTED] 04/03/01 11:56AM I have used rman exclusively since I became an Oracle DBA because it was there and I needed a backup strategy. It has gotten better with later releases. We are now on 8.0.6. It used Oracle internals so that is an advantage. It comes free with Oracle so that is another advantage. I can send you a paper on why to love rman written by Francis Sanchez of Oracle Corp. if you need it. I can't send an attachment through the list. Regards, Ruth - Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Tuesday, April 03, 2001 10:45 AM Hi everyone - Currently we are doing backups manually, periodic cold backups, and hot backups in between - we are running in archivelog mode. We are running 8.1.5 and 8.1.6 (soon to be 8.1.7) on Sun Solaris. Today there are only a few small production servers (2 - 5 GB), but we are anticipating a couple large ones (~200GB), and a data warehouse (anticipated to be around 500GB). We have started playing around with Recovery Manager. Our Sybase DBAs are telling us we should look at SQL BackTrack instead. For those of you who are using either one, I'd appreciate your comments on how well you like / don't like it and any "gotcha's" that you have run into. Other than the cost factor, what would you recommend? Thanks very much - Lisa -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gene Sais INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Linux ver and Oracle
Richard, What was your experience (good/bad) with Oracle Parallel Server on linux? What kind of hardware did you use? Which linux os version? TIA, Gerardo -Original Message- Sent: Tuesday, April 03, 2001 9:21 AM To: Multiple recipients of list ORACLE-L I used the Oracle 8.1.7 with OPS linux version. Were your version just 8.1.7 or 8.1.7 with OPS? Richard -Original Message- Taylor Sent: Tuesday, April 03, 2001 11:26 AM To: Multiple recipients of list ORACLE-L At 01:52 PM 4/2/01 -0800, you wrote: I've found RH6.2 and Oracle 8.1.7.0.1 to be pretty compatible. Don't know about the other Linux distributions. That's interesting. I have an 8.1.6 and 8.1.7 installation cd, and RH6.2 . Tried installing 8.1.7, and it died with the "800%cpu" thing. 8.1.6 installed in a snap. Of course, the Oracle installation is sensitive to latitude and longitude, the phase of the moon, proper use of cursing, the color of your tie, etc. Maybe I need to sacrifice a chicken first Dennis Taylor No one's life, liberty, or property is safe when the legislature is in session. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dennis Taylor INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Richard Ji INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Molina, Gerardo INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: function to get GMT time
No, there's not. There are too many variations in timezones and daylight saving/summer time offsets. The only way to be certain with timezone adjustments is to run your computer in GMT and then build your own functions to adjust to local time. If you need to have multiple local times, be sure to stay up-to-date with daylight savings/summer time offsets. Many countries change these thruout the year for various reasons. For example, Australia had a very early summertime adjustment for one year last year for the Olympics. For current daylight savings adjustments see www.timeanddate.com. - Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Tuesday, April 03, 2001 10:45 AM Hi ! Is there a way to get GMT time within PL/SQL independent from the local time(zone), I'm looking for a function similar to SYSDATE, but it should return GMT instead of the local time. TIA Andreas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Haunschmidt Andreas VASL/FAS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Marc Perkowitz INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
HP environment - standby db?
Anybody out there using 2 HP servers attached to a single StoreEdge (AutoRaid) and setting up Oracle for a hot-standby db? Or are you running OPS instead of the hot-standby? Management thinking is to attach a N4000 and a L2000 servers to a 12H StoreEdge. I understand that a "HP Service Card" is required that will allow the L2000 to be the "fail to" server for the N4000. We would be starting with a 500G Oracle db, growing up to 9T at the end of 2 years. Oracle would be setup so that the L2000 would be serving the "hot standby" database. Or, should we toss the "hot standby" idea and go directly to Oracle Parallel Server? Would you care to comment on the good, the bad or the ugly to this idea? Yes, the 12H becomes the weak link in this idea, but there are budget constraints in this fiscal year that are forcing that config. In the next 2 fiscal years are monies to address the single storage device problem. Thx. [EMAIL PROTECTED] Portland OR USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Don Dealy II INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re:RE: Rollback seg for an entire session, not just per tran
Raj, OH, I hate to contradict people, but several months ago we had a couple of very long running jobs that accidentally filled all of the rollback segment space with the exception of SYSTEM. The processes all crashed with an Oracle error that said the SYSTEM rollback segment was strictly for changes in the data dictionary. Therefore NO it does not get used for user session transactions outside of data dictionary stuff which we all know does an autocommit. Dick Goulet Reply Separator Author: Raj Gopalan [EMAIL PROTECTED] Date: 4/3/2001 8:50 AM Dana 1. System rollback segment will be used for user session transactions. 2. The only way I think of assinging a rollback segment is by using SET TRANSACTION COMMAND. 3. There wont be any implict commits in a PL/SQL procedure and on exit of the PL/SQL will also not commit the data. You need to explicitly specify the commit. -Original Message- Sent: 03 April 2001 15:55 To: Multiple recipients of list ORACLE-L Implicit commits in PL/SQL? A colleague wants to do a large load using multiple PL/SQL programs; she typically (has the DBA) turns off all rollback segments except for SYSTEM and one large rollback segment. Some questions: Will the rollback segment called SYSTEM in the SYSTEM tablespace never be used for user session transactions? Is there any way to specify which rollback segment to use for an entire session versus per transaction? I'm not sure if her PL/SQL code performs implicit commits so I'm not sure doing one commit + set transaction before executing the procedure(s) will have the desired effect. Will Oracle ever do an implicit commit inside a PL/SQL procedure or is a commit performed only with the commit command or when exiting a procedure? Thanks very much. - Dana __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: dana INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Raj Gopalan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: function to get GMT time
Hi Andreas, Please try this. select sysdate, new_time(sysdate,'EST','GMT') from dual; Thanks, Gurdarshan -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 03, 2001 11:45 AM To: Multiple recipients of list ORACLE-L Hi ! Is there a way to get GMT time within PL/SQL independent from the local time(zone), I'm looking for a function similar to SYSDATE, but it should return GMT instead of the local time. TIA Andreas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Haunschmidt Andreas VASL/FAS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Singh, Gurdarshan (Gurdarshan)** CTR ** INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OCI
Lee, Our implementation of OCI makes use of the .h files in $ORACLE_HOME/rdbms/public and also the shared library libclntsh.so in $ORACLE_HOME/lib. These have to exist as part of the client installation. If I'm not mistaken, I had to select the programmer option from the list of installable pieces during the 8.0.5 client install. Hope this helps. Ron Morton Database Architect / Administrator Union Switch Signal Inc [EMAIL PROTECTED] -Original Message- From: lerobe - Lee Robertson [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, April 03, 2001 10:45 AM To: Multiple recipients of list ORACLE-L Subject: OCI All, Using Oracle 8.0.5.0.0 Compaq Tru64 v4.f One of the duhvelopers here wants to use OCI. I am sure it is installed as part of the server installation but where do all the relevant files live for him to use. I can only find oci files in $ORACLE_HOME/rdbms/demo. Is this normal. ?? Regards Lee Robertson Acxiom Tel:0191 525 7344 Fax:0191 525 7007 Email: [EMAIL PROTECTED] The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Morton, Ronald D INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RE: Rollback seg for an entire session, not just per tran
Oops.. That was typo :-) -Original Message- Sent: 03 April 2001 17:01 To: Raj Gopalan; Multiple recipients of list ORACLE-L Raj, OH, I hate to contradict people, but several months ago we had a couple of very long running jobs that accidentally filled all of the rollback segment space with the exception of SYSTEM. The processes all crashed with an Oracle error that said the SYSTEM rollback segment was strictly for changes in the data dictionary. Therefore NO it does not get used for user session transactions outside of data dictionary stuff which we all know does an autocommit. Dick Goulet Reply Separator Author: Raj Gopalan [EMAIL PROTECTED] Date: 4/3/2001 8:50 AM Dana 1. System rollback segment will be used for user session transactions. 2. The only way I think of assinging a rollback segment is by using SET TRANSACTION COMMAND. 3. There wont be any implict commits in a PL/SQL procedure and on exit of the PL/SQL will also not commit the data. You need to explicitly specify the commit. -Original Message- Sent: 03 April 2001 15:55 To: Multiple recipients of list ORACLE-L Implicit commits in PL/SQL? A colleague wants to do a large load using multiple PL/SQL programs; she typically (has the DBA) turns off all rollback segments except for SYSTEM and one large rollback segment. Some questions: Will the rollback segment called SYSTEM in the SYSTEM tablespace never be used for user session transactions? Is there any way to specify which rollback segment to use for an entire session versus per transaction? I'm not sure if her PL/SQL code performs implicit commits so I'm not sure doing one commit + set transaction before executing the procedure(s) will have the desired effect. Will Oracle ever do an implicit commit inside a PL/SQL procedure or is a commit performed only with the commit command or when exiting a procedure? Thanks very much. - Dana __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: dana INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Raj Gopalan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Raj Gopalan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: function to get GMT time
This gives GMT. Thanks! Ruth - Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Tuesday, April 03, 2001 1:15 PM Hi Andreas, Please try this. select sysdate, new_time(sysdate,'EST','GMT') from dual; Thanks, Gurdarshan -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 03, 2001 11:45 AM To: Multiple recipients of list ORACLE-L Hi ! Is there a way to get GMT time within PL/SQL independent from the local time(zone), I'm looking for a function similar to SYSDATE, but it should return GMT instead of the local time. TIA Andreas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Haunschmidt Andreas VASL/FAS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Singh, Gurdarshan (Gurdarshan)** CTR ** INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: function to get GMT time
You can always build qan external function to do so. -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 03, 2001 11:45 AM To: Multiple recipients of list ORACLE-L Hi ! Is there a way to get GMT time within PL/SQL independent from the local time(zone), I'm looking for a function similar to SYSDATE, but it should return GMT instead of the local time. TIA Andreas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Haunschmidt Andreas VASL/FAS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Slightly OT: Capturing a failed status of an ftp process
Try using expect to script the ftp session. http://expect.nist.gov/ -Original Message- Sent: Tuesday, April 03, 2001 1:31 PM To: Multiple recipients of list ORACLE-L I think I've seen an answer to this, but I never needed it before. If anyone can help, I would greatly appreciate it. We are trying to ftp files from one server to another. (Archive logs for Oracle). We want to be able to capture the status when the ftp fails, so that we can notify the DBAs to check the process out. This is all being done within a shell script that compress the log file first, then calls another script to do the actual ftp. But when the child script executes, it returns a successful status to the parent script. I don't know any way to tell the script that is doing the ftp to send the message, because any non-ftp command within that script fails. (Of course, that could just be because I don't know how to do what I want to do). If anybody has invented this wheel before, or has any tips on where to look for more info on how to do what I need to do, please let me know. TIA, Terry -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Terry Ball INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Wolfe, Charles INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Metalink Response ....FYI
But if everyone gives up on Metastink, then they'll be very interested in 9i because it eliminates the need for a dba or a developer or an iTAR. Listen to me now or hear me later. Dan -Original Message- Sent: Tuesday, April 03, 2001 12:16 PM To: Multiple recipients of list ORACLE-L Ranting on... They say there is unexpected demand. They created it by refusing to talk to anyone without their opening an iTar so how can they say it was unexpected. Maybe they are counting on everyone giving up on Metalink thereby reducing demand .. End of ranting... Ruth - Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Tuesday, April 03, 2001 11:50 AM rant 1500 users? And ORACLE FREAKING CORPORATION is having trouble meeting the demand? Geez Louise, this is *exactly* the type of thing companies get roasted alive for. I am supposed to believe these guys when they say "We'll scale all the way to Andromeda!". Sheesh, we run multiple databases around here with 1500+ active users from a base of 40,000 with nowhere near the response problems. We have had two unsked outages a year, on average. Oracle really needs to hire some system engineers and DBAs. What a freaking joke. rant/ Thanks for the news, Raj. Now I feel better about Metalink. ||-Original Message- ||From: Raj Sakthi [mailto:[EMAIL PROTECTED]] ||Sent: Tuesday, April 03, 2001 10:35 AM ||To: Multiple recipients of list ORACLE-L ||Subject: Metalink Response FYI || || ||Hi Folks , ||I know lot of Metastink info floating around...so I ||thought I would post this for fun/info . ||I got this response from Metastink .. || ||"Thank you for your comments on Metalink, the more ||feedback we get the better we ||here at Oracle Corporation will be able to service ||your needs. We have seen ||tremendous increase in customer usage of Metalink over ||the past 6 months. ||There are now about 240,000 registered users and at ||times we have over 1,500 active users. ||We know that the service does not meet our or ||customers expectations. With this in mind we ||have added capacity to our database servers and have ||also increased the number of middle ||tier application servers. Our experience is that the ||demand for online services has become ||so strong that as soon as we bring in more capacity, ||it is quickly consumed. We have also ||experience intermittent network and architecture ||problems that have caused several failovers ||from one server to the other resulting in slower ||performance than we expect. When these events ||occur, we strive to understand root cause and take ||corrective and preventive action. ||Sometime before summer, we exp!!ect to migrate the ||online services to Oracle's Customer ||Relationship Management (CRM) suite enabling us to ||deliver more to our customers.This is ||a global issue for us and it has great attention ||within Oracle management. We recognize ||how valuable our customers are to us and understand ||the immense value that Metalink can ||bring to them. We are working to meet your needs as ||fast as we can. Thank you for your ||patience as we continue to work to bring you the best ||in online support services." || ||Interesting.won't you say..: ) ||RS || ||__ ||Do You Yahoo!? ||Get email at your own domain with Yahoo! Mail. ||http://personal.mail.yahoo.com/ ||-- ||Please see the official ORACLE-L FAQ: http://www.orafaq.com ||-- ||Author: Raj Sakthi || INET: [EMAIL PROTECTED] || ||Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 ||San Diego, California-- Public Internet access / Mailing Lists || ||To REMOVE yourself from this mailing list, send an E-Mail message ||to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in ||the message BODY, include a line containing: UNSUB ORACLE-L ||(or the name of mailing list you want to be removed from). You may ||also send the HELP command for other information (like subscribing). || -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ This e-mail message has been scanned for the presence of all known computer viruses by the
Re: Slightly OT: Capturing a failed status of an ftp process
Terry, If I remember correctly the ftp supplies a return code. You could capture the return code and have a second script act accordingly on the return code. I think code 220 is successfull. ROR mm [EMAIL PROTECTED] 04/03/01 01:30PM I think I've seen an answer to this, but I never needed it before. If anyone can help, I would greatly appreciate it. We are trying to ftp files from one server to another. (Archive logs for Oracle). We want to be able to capture the status when the ftp fails, so that we can notify the DBAs to check the process out. This is all being done within a shell script that compress the log file first, then calls another script to do the actual ftp. But when the child script executes, it returns a successful status to the parent script. I don't know any way to tell the script that is doing the ftp to send the message, because any non-ftp command within that script fails. (Of course, that could just be because I don't know how to do what I want to do). If anybody has invented this wheel before, or has any tips on where to look for more info on how to do what I need to do, please let me know. TIA, Terry -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Terry Ball INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Script to reverse engineer all objects in a schema to DDL?
There are other programs such as SQL Navigator, DB Artisan, EZSQL are available but requires you to purchase a copy. SQL Programmer from Sylvain-Faust, another commercial product, will do this as well; at least on a per-object basis. It's a terrific tool all around: http://www.sfi-software.com/ - Dana __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: dana INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Slightly OT: Capturing a failed status of an ftp process
Why don't you use rcp or rdist instead? -Original Message- Sent: Tuesday, April 03, 2001 1:31 PM To: Multiple recipients of list ORACLE-L I think I've seen an answer to this, but I never needed it before. If anyone can help, I would greatly appreciate it. We are trying to ftp files from one server to another. (Archive logs for Oracle). We want to be able to capture the status when the ftp fails, so that we can notify the DBAs to check the process out. This is all being done within a shell script that compress the log file first, then calls another script to do the actual ftp. But when the child script executes, it returns a successful status to the parent script. I don't know any way to tell the script that is doing the ftp to send the message, because any non-ftp command within that script fails. (Of course, that could just be because I don't know how to do what I want to do). If anybody has invented this wheel before, or has any tips on where to look for more info on how to do what I need to do, please let me know. TIA, Terry -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Terry Ball INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: AT scheduler
echo "0,5,10,15,20,25,30,35,40,45,50,55 * * * * /usr/local/bin/myjob" /tmp/crontab crontab /tmp/crontab -Original Message- Sent: Tuesday, April 03, 2001 12:30 PM To: Multiple recipients of list ORACLE-L Can anyone tell me how to schedule a batch job to run every 5 minutes using the "AT" scheduler? Thanks! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re:Multi Threaded Server
Jack, I use MTS of any instance were the company intranet gets involved for similar reasons. There are two problems that I've run into with MTS over the years. The first is running out of shared pool space. With MTS the query and resulting data get stored in the shared pool, so at least one should increase this setting in init.ora. The second gets into the basics of configuring MTS. First, make sure there are a minimum of at least 2 shared servers per dispatcher. If you've for 3 dispatchers then you need a minimum of 6 shared servers. The DB will not complain on startup if this is wrong, but it will at some time thereafter, by crashing. The second has to do with the number of shared servers there are during normal operations. Remember that once a user submits a transaction to the database that it will sit in the shared pool awaiting processing until a server becomes available. This very much a FIFO operation, so if all of the servers are busy then it may wait for a long time. My rule of thumb is to set MTS_MAX_SERVERS equal to 75% of max expected connections. The actual number running at any time will vary between the minimum and maximum which is what it's suppose to do. Also, configure at least one connection method that will use a dedicated server. Helps an awful lot with batch data loads, actually an Oracle recommendation. Dick Goulet Reply Separator Author: [EMAIL PROTECTED] Date: 4/3/2001 7:32 AM Hi All, We have about 400-500 connections to our database and are now considering going to MTS. Can anybody share their experience? pitfalls? things to take care of? performance issues? Any help appreciated. Our main objective is to lower the amount of RAM consumed by the Oracle sessions. Jack (Oracle DBA) Informatie Systemen Ernst Young Informatie Communicatie Technologie Kantoor Gouda Tel.: 0182 575316 (intern: 923 316) Fax: 0182 536311 E-mail: [EMAIL PROTECTED] = De informatie verzonden in dit e-mailbericht is vertrouwelijk en is uitsluitend bestemd voor de geadresseerde. Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan derden is, behoudens voorafgaande schriftelijke toestemming van Ernst Young, niet toegestaan. Ernst Young staat niet in voor de juiste en volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch voor tijdige ontvangst daarvan. Ernst Young kan niet garanderen dat een verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden. Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u vriendelijk doch dringend het e-mailbericht te retourneren aan de verzender en het origineel en eventuele kopieën te verwijderen en te vernietigen. Ernst Young hanteert bij de uitoefening van haar werkzaamheden algemene voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De algemene voorwaarden worden u op verzoek kosteloos toegezonden. = The information contained in this communication is confidential and is intended solely for the use of the individual or entity to whom it is addressed. You should not copy, disclose or distribute this communication without the authority of Ernst Young. Ernst Young is neither liable for the proper and complete transmission of the information contained in this communication nor for any delay in its receipt. Ernst Young does not guarantee that the integrity of this communication has been maintained nor that the communication is free of viruses, interceptions or interference. If you are not the intended recipient of this communication please return the communication to the sender and delete and destroy all copies. In carrying out its engagements, Ernst Young applies general terms and conditions, which contain a clause that limits its liability. A copy of these terms and conditions is available on request free of charge. = -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858)
Re: function to get GMT time
This gives you the current sysdate from your server and calls it GMT. Ruth - Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Tuesday, April 03, 2001 1:21 PM Hi Andreas, You can do this with the NEW_TIME date funntion: SQL alter session set NLS_DATE_FORMAT = 'DD-MM-YYY HH24:MI:SS'; Session altered. SQL select sysdate "GMT" from dual; GMT -- 03-04-001 17:05:25 SQL select new_time(sysdate, 'GMT', 'AST') "AST" from dual; AST -- 03-04-001 13:08:41 This shows Atlantic Standard Time, there are a list of the time zones available, and description of the funciton in the SQL Reference Manaual - page 185 HTH Mark -Original Message- Andreas VASL/FAS Sent: Tuesday, April 03, 2001 04:45 To: Multiple recipients of list ORACLE-L Hi ! Is there a way to get GMT time within PL/SQL independent from the local time(zone), I'm looking for a function similar to SYSDATE, but it should return GMT instead of the local time. TIA Andreas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Haunschmidt Andreas VASL/FAS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- 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: sql query
Though I had some fair idea of what it was, but now things are very clear after all the replies. Thanks for all the reply. Ravindra -Original Message- [EMAIL PROTECTED] Sent: Tuesday, April 03, 2001 3:21 AM To: Multiple recipients of list ORACLE-L sysdate - 1 is sysdate minus one day sysdate - 1/24 is sysdate minus 1 hour sysdate - 1/24/60 is sysdate minus 1 minute = sysdate -1/(24*60) sysdate - 1/24/60/60 is sysdate minus 1 second = sysdate - 1/(24*60*60) = sysdate - 1/(24*3600) "Ravindra Basavaraja" To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] ravindra@sent cc: ica.com Subject: sql query Sent by: [EMAIL PROTECTED] om 03-04-2001 06:00 Please respond to ORACLE-L I found a query to get the time 5 seconds less than the current time as select to_char(sysdate-5/(24*3600),'dd-mon- hh24:mi:ss') from dual; I am really not sure as to why 24*3600 is used for. Can anyone tell me why it is used. Thanks Ravindra -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ravindra Basavaraja INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = De informatie verzonden in dit e-mailbericht is vertrouwelijk en is uitsluitend bestemd voor de geadresseerde. Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan derden is, behoudens voorafgaande schriftelijke toestemming van Ernst Young, niet toegestaan. Ernst Young staat niet in voor de juiste en volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch voor tijdige ontvangst daarvan. Ernst Young kan niet garanderen dat een verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden. Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u vriendelijk doch dringend het e-mailbericht te retourneren aan de verzender en het origineel en eventuele kopien te verwijderen en te vernietigen. Ernst Young hanteert bij de uitoefening van haar werkzaamheden algemene voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De algemene voorwaarden worden u op verzoek kosteloos toegezonden. = The information contained in this communication is confidential and is intended solely for the use of the individual or entity to whom it is addressed. You should not copy, disclose or distribute this communication without the authority of Ernst Young. Ernst Young is neither liable for the proper and complete transmission of the information contained in this communication nor for any delay in its receipt. Ernst Young does not guarantee that the integrity of this communication has been maintained nor that the communication is free of viruses, interceptions or interference. If you are not the intended recipient of this communication please return the communication to the sender and delete and destroy all copies. In carrying out its engagements, Ernst Young applies general terms and conditions, which contain a clause that limits its liability. A copy of these terms and conditions is available on request free of charge. = -- 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: Ravindra Basavaraja INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists
FOOT-AND-MOUTH
For all of you MicroSoft supporters out there! Sorry Jared! Dick Goulet Forward Header_ FOOT-AND-MOUTH BELIEVED TO BE FIRST VIRUS UNABLE TO SPREAD THROUGH MICROSOFT OUTLOOK Researchers Shocked to Finally Find Virus That Email App Doesn't Like Atlanta, Ga. (GPS) Scientists at the Centers for Disease Control and Symantec's AntiVirus Research Center today confirmed that foot-and-mouth disease cannot be spread by Microsoft's Outlook email application, believed to be the first time the program has ever failed to propagate a major virus. "Frankly, we've never heard of a virus that couldn't spread through Microsoft Outlook, so our findings were, to say the least, unexpected," said Clive Sarnow, director of the CDC's infectious disease unit. The study was immediately hailed by British officials, who said it will save millions of pounds and thousands of man hours. "Up until now we have, quite naturally, assumed that both foot-and-mouth and mad cow were spread by Microsoft Outlook," said Nick Brown, Britain's Agriculture Minister. "By eliminating it, we can focus our resources elsewhere." However, researchers in the Netherlands, where foot-and-mouth has recently appeared, said they are not yet prepared to disqualify Outlook, which has been the progenitor of viruses such as "I Love You," "Bubbleboy," "Anna Kournikova," and "Naked Wife," to name but a few. Said Nils Overmars, director of the Molecular Virology Lab at Leiden University, "It's not that we don't trust the research, it's just that as scientists, we are trained to be skeptical of any finding that flies in the face of established truth. And this one flies in the face like a blind drunk sparrow." Executives at Microsoft, meanwhile, were equally skeptical, insisting that Outlook's patented Virus Transfer Protocol (VTP) has proven virtually pervious to any virus. The company, however, will issue a free VTP patch if it turns out the application is not vulnerable to foot-and-mouth. Such an admission would be embarrassing for the software giant, but Symantec virologist Ariel Kologne insisted that no one is more humiliated by the study than she is. "Only last week, I had a reporter ask if the foot-and-mouth virus spreads through Microsoft Outlook, and I told him, 'Doesn't everything?'" she recalled. "Who would've thought?" -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RE: Rollback seg for an entire session, not just per tran
I hate to disagree with people, but SYSTEM rollback segment is actually not used at all if there are other rollback segments available. Those "dictionary transactions" are a myth, the same as that oracle is trying to "cache extents". Simply not true. -Original Message- Sent: Tuesday, April 03, 2001 2:01 PM To: Multiple recipients of list ORACLE-L Raj, OH, I hate to contradict people, but several months ago we had a couple of very long running jobs that accidentally filled all of the rollback segment space with the exception of SYSTEM. The processes all crashed with an Oracle error that said the SYSTEM rollback segment was strictly for changes in the data dictionary. Therefore NO it does not get used for user session transactions outside of data dictionary stuff which we all know does an autocommit. Dick Goulet Reply Separator Author: Raj Gopalan [EMAIL PROTECTED] Date: 4/3/2001 8:50 AM Dana 1. System rollback segment will be used for user session transactions. 2. The only way I think of assinging a rollback segment is by using SET TRANSACTION COMMAND. 3. There wont be any implict commits in a PL/SQL procedure and on exit of the PL/SQL will also not commit the data. You need to explicitly specify the commit. -Original Message- Sent: 03 April 2001 15:55 To: Multiple recipients of list ORACLE-L Implicit commits in PL/SQL? A colleague wants to do a large load using multiple PL/SQL programs; she typically (has the DBA) turns off all rollback segments except for SYSTEM and one large rollback segment. Some questions: Will the rollback segment called SYSTEM in the SYSTEM tablespace never be used for user session transactions? Is there any way to specify which rollback segment to use for an entire session versus per transaction? I'm not sure if her PL/SQL code performs implicit commits so I'm not sure doing one commit + set transaction before executing the procedure(s) will have the desired effect. Will Oracle ever do an implicit commit inside a PL/SQL procedure or is a commit performed only with the commit command or when exiting a procedure? Thanks very much. - Dana __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: dana INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Raj Gopalan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Recovery Manager vs. SQL Back Track
We currently use SQL BackTrack on both Solaris boxes where our interface to tape software is netware. To put it mildly, netware sucks. When we were going to disk SQL BackTrack worked like a charm. On our other system - AIX - our interface is ADSM. It too has worked like a charm. If you can stay away from using SQL BackTrack with netware's obsi interface, go for it. Otherwise, stay as far away as you can. Terry "Yttri, Lisa" wrote: Hi everyone - Currently we are doing backups manually, periodic cold backups, and hot backups in between - we are running in archivelog mode. We are running 8.1.5 and 8.1.6 (soon to be 8.1.7) on Sun Solaris. Today there are only a few small production servers (2 - 5 GB), but we are anticipating a couple large ones (~200GB), and a data warehouse (anticipated to be around 500GB). We have started playing around with Recovery Manager. Our Sybase DBAs are telling us we should look at SQL BackTrack instead. For those of you who are using either one, I'd appreciate your comments on how well you like / don't like it and any "gotcha's" that you have run into. Other than the cost factor, what would you recommend? Thanks very much - Lisa -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Terry Ball INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: FOOT-AND-MOUTH
Title: RE: FOOT-AND-MOUTH Yea, it sure spreads more viruses than ORACLE's EMAIL SOLUTION. ahem, well...what i meant to say was. Criminy, Oracle can't even run a 1500 user support site for it's paying freaking customers. Oracle support is as well-thought out as asking Ed Hazelton to captain the Ehime Maru. Ross p.s. Oxymorons for the day: Military Intelligence Jumbo Shrimp Oracle Support ||-Original Message- ||From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] ||Sent: Tuesday, April 03, 2001 2:51 PM ||To: Multiple recipients of list ORACLE-L ||Subject: FOOT-AND-MOUTH || || ||For all of you MicroSoft supporters out there! || ||Sorry Jared! || ||Dick Goulet || ||Forward Header_ || ||FOOT-AND-MOUTH BELIEVED TO BE FIRST VIRUS UNABLE TO SPREAD THROUGH ||MICROSOFT OUTLOOK || ||Researchers Shocked to Finally Find Virus That Email App Doesn't Like || ||Atlanta, Ga. (GPS) Scientists at the Centers for Disease Control and ||Symantec's AntiVirus Research Center today confirmed that ||foot-and-mouth ||disease cannot be spread by Microsoft's Outlook email application, ||believed to be the first time the program has ever failed to propagate ||a major virus. || ||Frankly, we've never heard of a virus that couldn't spread through ||Microsoft Outlook, so our findings were, to say the least, ||unexpected, ||said Clive Sarnow, director of the CDC's infectious disease unit. || ||The study was immediately hailed by British officials, who ||said it will ||save millions of pounds and thousands of man hours. Up until now we ||have, quite naturally, assumed that both foot-and-mouth and ||mad cow were ||spread by Microsoft Outlook, said Nick Brown, Britain's Agriculture ||Minister. By eliminating it, we can focus our resources elsewhere. || ||However, researchers in the Netherlands, where foot-and-mouth has ||recently appeared, said they are not yet prepared to ||disqualify Outlook, ||which has been the progenitor of viruses such as I Love You, ||Bubbleboy, Anna Kournikova, and Naked Wife, to name but a few. || ||Said Nils Overmars, director of the Molecular Virology Lab at Leiden ||University, It's not that we don't trust the research, it's ||just that ||as scientists, we are trained to be skeptical of any finding ||that flies ||in the face of established truth. And this one flies in the face ||like a blind drunk sparrow. || ||Executives at Microsoft, meanwhile, were equally skeptical, insisting ||that Outlook's patented Virus Transfer Protocol (VTP) has proven ||virtually pervious to any virus. The company, however, will issue a ||free VTP patch if it turns out the application is not vulnerable to ||foot-and-mouth. || ||Such an admission would be embarrassing for the software giant, but ||Symantec virologist Ariel Kologne insisted that no one is more ||humiliated by the study than she is. Only last week, I had ||a reporter ||ask if the foot-and-mouth virus spreads through Microsoft ||Outlook, and I ||told him, 'Doesn't everything?' she recalled. Who would've thought? || ||-- ||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: Recovery Manager vs. SQL Back Track
Title: RE: Recovery Manager vs. SQL Back Track I have worked with manual scripting, EBU, RMAN, and SQLBackTrack. If you can afford it, use SQLBackTrack. It's idiot proof for both backup and restore if you set it up right. (trust me). If you have other questions email me direct. Brian P. Mac Lean Oracle DBA/OCP v8/OMC Vcommerce Corp. 6262 N. Scottsdale Rd., Suite 110 Scottsdale, AZ 85250 480.922.9922 - Main 480.778.8449 - Direct 480.922.9921 - Fax [EMAIL PROTECTED] - Email vc_bmaclean - Yahoo Messenger http://www.vcommerce.com -Original Message- From: Yttri, Lisa [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 03, 2001 7:46 AM To: Multiple recipients of list ORACLE-L Subject: Recovery Manager vs. SQL Back Track Hi everyone - Currently we are doing backups manually, periodic cold backups, and hot backups in between - we are running in archivelog mode. We are running 8.1.5 and 8.1.6 (soon to be 8.1.7) on Sun Solaris. Today there are only a few small production servers (2 - 5 GB), but we are anticipating a couple large ones (~200GB), and a data warehouse (anticipated to be around 500GB). We have started playing around with Recovery Manager. Our Sybase DBAs are telling us we should look at SQL BackTrack instead. For those of you who are using either one, I'd appreciate your comments on how well you like / don't like it and any gotcha's that you have run into. Other than the cost factor, what would you recommend? Thanks very much - Lisa
Generating Forms through API or Designer
Hi Listers, I have the following questions: 1. I would like to generate Developer Forms fmb files through my C++ application. Is it difficult? Did any of you do similar things? I know Forms have an API for this, but I don't know how complex is it. I have pretty simple Forms. Should I try or should I forget it? 2. Does Oracle Designer 6i's Forms generator's revers engineering engine preserve or recapture the Form layout modifications I make on the generated Forms? TIA, Tamas Szecsy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Szecsy Tamas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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 Question
You can do something like select to_char(date_column,'YYWW'), count(*), sum(other_column) from table where date_column between date1 and date 2 group by to_char(date_column,'YYWW') where WW returns the week of the year ( 1 to 53) keeping in mind, of course, that you must include in the group by any column in the select which does not have a group function on it (sum, max, min, avg, etc). At 09:35 AM 4/3/01 -0800, you wrote: Hello all, Can someone tell me whether or not there is a way do this in SQL? I want to select some data given a certain date range,i.e where some_date between start_date and end_date. Is there a way to group the output by week? In other words, something like: SELECT column_a, column_b, count(*), sum(column_c) FROM table_t WHERE some_date_column BETWEEN :start_date and :end_date GROUP BY ...? How this be grouped by week? Thanks a lot. __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.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: Regina Harter INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
(Fwd) [Kent Graziano] ODTUG Meets with Oracle!
--- Forwarded message follows --- Date sent: Mon, 02 Apr 2001 15:01:46 -0800 S e n d r e p l y t o : O D T U G - D E V 2 K - L @ f a t c i t y . c o m F r o m : Oracle Development Tools User Group Dear List Users: I am pleased to report to you that the ODTUG board had a fantastic kick-off meeting for 2001 that included a session with some your favorite Oracle Corporation VPs. We were pleased to have Sohaib Abbasi (Senior VP), Marco Tilli, Ian Fisher, Bill Dwight, and Daryl Porter in attendance to discuss how the user group and the Tools division can work together this year. As a result of this meeting, you can expect to see the following: Participation by Oracle in our conference, with most of the above VPs giving at least one presentation. Participation in the ODTUG enhancement request (ER) system by the Oracle VPs and their product managers. The VPs enthusiastically pledged to become active in reviewing the ERssubmitted by our members using our new Oracle Portal-based system. Distribution of JDeveloper 9i beta CDs to our members (probably midyear, details pending). Creation of a white paper/case study on using the new SCM features of Designer, to be written by the Oracle U.K. Repository team. Development of surveys throughout the year from the various Oracle product teams about how you, our members, are using the tools. These surveys will be distributed by ODTUG. We were all in agreement that these results will provide a win-win for Oracle and ODTUG. ODTUG members will get tools to demo and information on how to more effectively use those tools. Oracle, in return, will get valuable information (via the ER system and surveys) to help them in their product direction and development. Even with all the recent turmoil in the market, it looks to be a great year for ODTUG. If you want to be part of all this and you are not a member, let me take this opportunity to invite you join now so you can use your discount to go to this year's conference in San Diego, California. Go to our Web site at www.odtug.com to sign up online for both a membership and the conference. See you in San Diego! Kent Graziano President, ODTUG --- End of forwarded message --- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eric D. Pierce INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: HP environment - standby db?
At a previous employer, I've used HP MC ServiceGuard w/ EMC and it worked great. Don't know about Storedge, but can compliment EMC on their storage solution as the best in the business. Of course thats my opinion. Also, used the standby box as a staging db for prototyping new applications. This worked out well b/c the box was being used while waiting for the moment of disaster :) Gene [EMAIL PROTECTED] 04/03/01 02:00PM Anybody out there using 2 HP servers attached to a single StoreEdge (AutoRaid) and setting up Oracle for a hot-standby db? Or are you running OPS instead of the hot-standby? Management thinking is to attach a N4000 and a L2000 servers to a 12H StoreEdge. I understand that a "HP Service Card" is required that will allow the L2000 to be the "fail to" server for the N4000. We would be starting with a 500G Oracle db, growing up to 9T at the end of 2 years. Oracle would be setup so that the L2000 would be serving the "hot standby" database. Or, should we toss the "hot standby" idea and go directly to Oracle Parallel Server? Would you care to comment on the good, the bad or the ugly to this idea? Yes, the 12H becomes the weak link in this idea, but there are budget constraints in this fiscal year that are forcing that config. In the next 2 fiscal years are monies to address the single storage device problem. Thx. [EMAIL PROTECTED] Portland OR USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Don Dealy II INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gene Sais INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: AT scheduler
My Computer/Scheduled Task might fit your needs better, since it has got a Windows GUI. It's easier to handle than the AT command. The GUI in some places is illogial, but still it might be usefull for you. Tamas Szecsy -Original Message- Sent: 2001.04.03. 8:22 PM To: Multiple recipients of list ORACLE-L If you are running on NT, I strongly recommend you obtain crontab for Windows. AT will run 99.99% of the time... but not 100% of the time. On one of the servers here AT failed to run the very night that we were changing the time last Fall, very suspicious in my opinion. In any case for AT just do: at hh24:mm /every:M,T,W,Th,F,S,Su cmd /c pointer_to_my_script_or_program e.g. at 22:00 /every:M,T,W,Th,F cmd /c c:\pat\coldbackup.cmd That will create an entry: Added a new job with Job ID = some number To see the listing, just type AT [enter] To remove an entry, at ID_num /delete e.g. at 12 /delete Don't try to keep your jobs listing in any particular order, NT shuffles them around sometimes when you do maintenance on the server or when you reboot. For AT jobs to run, of course the Scheduler service must be running. The service has a couple of different names, depending on which service pack you installed on your server. Regards, Patrice Boivin Systems Analyst (Oracle DBA) Bedford Institute of Oceanography Fisheries and Oceans Canada -Original Message- From: Smith, Ron L. [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, April 03, 2001 1:30 PM To: Multiple recipients of list ORACLE-L Subject: "AT" scheduler Can anyone tell me how to schedule a batch job to run every 5 minutes using the "AT" scheduler? Thanks! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Szecsy Tamas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: function to get GMT time
I know, it works! RBG - Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Tuesday, April 03, 2001 2:57 PM Ruth: Just reverse the logic...this converts Eastern Daylight Time to GMT: SELECT new_time(sysdate, 'EDT', 'GMT') FROM dual; SQL SELECT sysdate FROM dual; SYSDATE 03-APR-2001 13:51:35 SQL SELECT new_time(sysdate, 'EDT', 'GMT') FROM dual; NEW_TIME(SYSDATE,'ED 03-APR-2001 17:52:06 Kevin Toepke - The information in this electronic mail message is Cendant Confidential and may be legally privileged. It is intended solely for the addressee(s). Access to this Internet electronic mail message by anyone else is unauthorized. If you are not the intended recipient, any disclosure, copying, distribution or action taken or omitted to be taken in reliance on it is prohibited and may be unlawful. - The sender believes that this E-mail and any attachments were free of any virus, worm, Trojan horse, and/or malicious code when sent. This message and its attachments could have been infected during transmission. By reading the message and opening any attachments, the recipient accepts full responsibility for taking protective and remedial action about viruses and other defects. Cendant Corporation is not liable for any loss or damage arising in any way from this message or its attachments. - SNIP -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Toepke, Kevin M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Slightly OT: Capturing a failed status of an ftp process
Terry, I worked on what I think is a similar process. We are running SAP and need to be able to ftp files on and off of our unix SAP servers. Someone in the past wrote an SAP ABAP program that does all of the set up then calls a unix shell script to perform the ftp. If the ftp command truely failed to connect we had no problem getting back a failed error message to the SAP program. But where we ran into some problems was when the transfer command would start but get interrupted for some unknown reason and never fully complete the transfer. This was noticed by accident one day when someone was checking a report run off of one of the data transfers and there were only a few hundred records in the table to be processed instead of a few hundred thousand. I was then asked to come up with a solution that would look for an unexpected termination of the ftp connection. After lots of searching and getting one of our local unix gurus involved (I have worked directly on a unix platform), we implemented the following. It is not the best but it does seem to be working. We added a step to the ftp script. This step is a status command that is executed directly after the get or put command. This returns information about the ftp connection itself. It also returns a message if it is no longer connected. This output was passed back to the SAP program and parsed. If I had a message indicating that the remote host was still connected, I assumed that the get or put executed completely. If on the other hand I received the message indicating that the remote system was no longer connected I generated an error message from the program so that the user could check the data. Shari Dishop SAP ABAP - Project Systems Team Logicon - A Northrop Grumman Company Baltimore, MD RE: I think I've seen an answer to this, but I never needed it before. If anyone can help, I would greatly appreciate it. We are trying to ftp files from one server to another. (Archive logs for Oracle). We want to be able to capture the status when the ftp fails, so that we can notify the DBAs to check the process out. This is all being done within a shell script that compress the log file first, then calls another script to do the actual ftp. But when the child script executes, it returns a successful status to the parent script. I don't know any way to tell the script that is doing the ftp to send the message, because any non-ftp command within that script fails. (Of course, that could just be because I don't know how to do what I want to do). If anybody has invented this wheel before, or has any tips on where to look for more info on how to do what I need to do, please let me know. TIA, Terry -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Terry Ball INET: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shari Dishop INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Help - How to declare a cursor inside a FOR ... LOOP ?
You can't. It appears that you want to select all the detailed text extries related to a specific problem. You could define a cursor that selects all the detailed entries, or you could read all the detailed entries into a pl/sql table and then search through them. If you use the cursor, then you have to reopen the cursor for each new problem. Dan -Original Message-From: Wendy Y [mailto:[EMAIL PROTECTED]]Sent: Tuesday, April 03, 2001 2:51 PMTo: Multiple recipients of list ORACLE-LSubject: Help - How to declare a cursor inside a FOR ... LOOP ? Hey, Guys: I need to decalre a cursor inside a FOR .. LOOP,because the variables inSELECT statement for the CURSOR are coming from FOR .. LOOP. How could I do this? DECLARE V_AKTIV_NR aktiv.AKTIV_NR%TYPE; V_PROBLEM aktiv.PROBLEM%TYPE; V_ENDDAT aktiv.ENDDAT%TYPE; V_ENDUHR aktiv.ENDUHR%TYPE; V_AUSSAGEW aktiv.AUSSAGEW%TYPE; V_LANGTEXT aktiv.LANGTEXT%TYPE; V_LONGTEXT VARCHAR2(2); V_LONGTEXT_CUR VARCHAR2(13000); V_LONGTEXT_TRIM VARCHAR2(2000); p_PROBLEM PROBLEM.PROBLEM%TYPE; # This part need to be inside FOR.. LOOP, otherwise, I wouldn't get anything. CURSOR AKLangTextCur ISSELECT TO_CHAR(V_ENDDAT, 'MMDD')||' '|| V_ENDUHR||' '||rtrim(V_AUSSAGEW)||' '||rtrim(V_LANGTEXT) thisText FROM AKTIV WHERE V_PROBLEM = p_PROBLEM ORDER BY Aktiv_NR; AKLangTextRec AKLangTextCur%ROWTYPE; ### AboveBEGIN FOR v_LoopIndex IN 1..pkgFreeText.v_NumEntries LOOP V_AKTIV_NR := pkgFreeText.V_AKTIV_NR_P(v_LoopIndex); V_PROBLEM := pkgFreeText.V_PROBLEM_P(v_LoopIndex); V_ENDDAT := pkgFreeText.V_ENDDAT_P(v_LoopIndex); V_ENDUHR := pkgFreeText.V_ENDUHR_P(v_LoopIndex); V_AUSSAGEW := pkgFreeText.V_AUSSAGEW_P(v_LoopIndex); V_LANGTEXT := pkgFreeText.V_LANGTEXT_P(v_LoopIndex); SELECT PROBLEM INTO p_PROBLEM FROM PROBLEM; ## CURSOR DECLARE should be HERE ## BEGIN OPEN AKLangTextCur; LOOP FETCH AKLangTextCur into AKLangTextRec; EXIT WHEN AKLangTextCur%NOTFOUND; V_LONGTEXT_CUR := V_LONGTEXT_CUR ||AKLangTextRec.thisText; END LOOP; CLOSE AKLangTextCur; END;V_LONGTEXT := V_LONGTEXT || V_LONGTEXT_CUR; END LOOP;V_LONGTEXT_TRIM := RTRIM(V_LONGTEXT, 2000); Thanks a lot for help Wendy Do You Yahoo!?Yahoo! Mail Personal Address - Get email at your own domain with Yahoo! Mail. _This e-mail message has been scanned for the presence of all known computer viruses by the MessageLabs Virus Control Center. However, it is still recommended that you use local virus scanning software to monitor for the presence of viruses.
RE: Metalink Response ....FYI
Title: RE: Metalink Response FYI Sadly, I do not. I am not a TV watcher these days ==-Original Message- ==From: Eric D. Pierce [mailto:[EMAIL PROTECTED]] ==Sent: Tuesday, April 03, 2001 3:17 PM ==To: Multiple recipients of list ORACLE-L ==Subject: RE: Metalink Response FYI == == == == ==On 3 Apr 2001, at 7:50, Mohan, Ross scribbled with alacrity ==and cogency: == == ... I am == supposed to believe these guys when they say We'll scale == all the way to Andromeda!. == == ==You mean the SciFi show called Andromeda? == ==regards, ==ep == == ==-- ==Please see the official ORACLE-L FAQ: http://www.orafaq.com ==-- ==Author: Eric D. Pierce == INET: [EMAIL PROTECTED] == ==Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 ==San Diego, California -- Public Internet access / ==Mailing Lists == ==To REMOVE yourself from this mailing list, send an E-Mail message ==to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in ==the message BODY, include a line containing: UNSUB ORACLE-L ==(or the name of mailing list you want to be removed from). You may ==also send the HELP command for other information (like subscribing). ==
RE: Redo log size MAX = ?
So, based on the responses I've seen, this statement can be declared to be false. [EMAIL PROTECTED] 04/03/01 11:05AM hi forget about recovery from online redo logs It doesn't exist in Oracle Regards Tapiwa -Original Message- Sent: Tuesday, April 03, 2001 3:01 PM To: Multiple recipients of list ORACLE-L Hi, My database = noarchive mode (compulsory for our application) In case of instance failure can oracle perform recovery from redo log ? if can what will be tne maximum size of the redo log recommended. Because I need set that size for whole day transaction currently 512K (3 redo logs) switched every 15 - 30 minutes. Can oracle perform recovery from inactive or "other status" redo log ? 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: Zhou, Tapiwanashe INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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 Sawmiller INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Help - How to declare a cursor inside a FOR ... LOOP ?
Wendy: Actually, you don't need to declare the cursor inside the for loop, you just need to open it inside the loop and pass a parameter to the cursor. DECLARE V_AKTIV_NRaktiv.AKTIV_NR%TYPE; V_PROBLEMaktiv.PROBLEM%TYPE; V_ENDDAT aktiv.ENDDAT%TYPE; V_ENDUHR aktiv.ENDUHR%TYPE; V_AUSSAGEW aktiv.AUSSAGEW%TYPE; V_LANGTEXT aktiv.LANGTEXT%TYPE; V_LONGTEXTVARCHAR2(2); V_LONGTEXT_CUR VARCHAR2(13000); V_LONGTEXT_TRIM VARCHAR2(2000); p_PROBLEMPROBLEM.PROBLEM%TYPE; CURSOR AKLangTextCur (p_problem IN VARCHAR2) IS SELECT TO_CHAR(V_ENDDAT, 'MMDD')||' '|| V_ENDUHR||' '|| rtrim(V_AUSSAGEW)||' '|| rtrim(V_LANGTEXT) thisText FROM AKTIV WHERE V_PROBLEM = p_PROBLEM ORDER BY Aktiv_NR; AKLangTextRec AKLangTextCur%ROWTYPE; BEGIN FOR v_LoopIndex IN 1..pkgFreeText.v_NumEntries LOOP V_AKTIV_NR := pkgFreeText.V_AKTIV_NR_P(v_LoopIndex); V_PROBLEM := pkgFreeText.V_PROBLEM_P(v_LoopIndex); V_ENDDAT := pkgFreeText.V_ENDDAT_P(v_LoopIndex); V_ENDUHR := pkgFreeText.V_ENDUHR_P(v_LoopIndex); V_AUSSAGEW := pkgFreeText.V_AUSSAGEW_P(v_LoopIndex); V_LANGTEXT := pkgFreeText.V_LANGTEXT_P(v_LoopIndex); SELECT PROBLEM INTO p_PROBLEM FROM PROBLEM; OPEN AKLangTextCur(v_problem); LOOP FETCH AKLangTextCur into AKLangTextRec; EXIT WHEN AKLangTextCur%NOTFOUND; V_LONGTEXT_CUR := V_LONGTEXT_CUR ||AKLangTextRec.thisText; END LOOP; CLOSE AKLangTextCur; V_LONGTEXT := V_LONGTEXT || V_LONGTEXT_CUR; END LOOP; V_LONGTEXT_TRIM := RTRIM(V_LONGTEXT, 2000); END; / Kevin snip -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Toepke, Kevin M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Metalink Response ....FYI
Title: RE: Metalink Response FYI Randy Baker left, yes...and another fellow...forced out, virtually. Then, the cost cutting began. People attrited or let go...cheaper monitors and equipment...reduced training budgets. We Saved a Billion Dollars Last Year by not doing their job. == -Original Message- == From: Eric D. Pierce [mailto:[EMAIL PROTECTED]] == Sent: Tuesday, April 03, 2001 3:22 PM == To: Multiple recipients of list ORACLE-L == Subject: RE: Metalink Response FYI == == == Steve, == == Thanks for the very interesting comments. Are those webified == apps with similar requirements as metalink? == == Also, didn't the VP in charge of support leave Oracle about a == year or so ago? == == == regards, == ep == == On 3 Apr 2001, at 7:26, Steve Adams wrote: == == == I'd say that there must be something badly wrong with == the application if it == cannot cope with 1,500 concurrent users. I know of == sites supporting more than 20 == times that number of active users on a single server == with consistent sub-second == response times. == == ... == == -- == Please see the official ORACLE-L FAQ: http://www.orafaq.com == -- == Author: Eric D. Pierce == INET: [EMAIL PROTECTED] == == Fat City Network Services -- (858) 538-5051 FAX: == (858) 538-5051 == San Diego, California -- Public Internet access / == Mailing Lists == - == --- == To REMOVE yourself from this mailing list, send an E-Mail message == to: [EMAIL PROTECTED] (note EXACT spelling of == 'ListGuru') and in == the message BODY, include a line containing: UNSUB ORACLE-L == (or the name of mailing list you want to be removed == from). You may == also send the HELP command for other information (like == subscribing). ==
Re: function to get GMT time
Just keep in mind, as I mentioned earlier, DST is not accounted for. So you will first need to convert from EDT to EST and then use this function. Otherwise your GMT will be one hour off. Of course, if you run your machine on EST and do not switch to EDT, you will be fine. Oh, I've assuming you really mean Universal Time (UT) when you're saying GMT. If you actually mean the local time for the UK, then you'll need to take their summer time change into effect also. Their summer time took effect on March 25th this year, while US DST took effect on April 1st. So, for one week the time difference was less than usual, but now the difference is consistent. Marc Perkowitz Senior Consultant TWJ Consulting, LLP 847-256-8866 x15 www.twjconsulting.com - Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Tuesday, April 03, 2001 1:19 PM This gives GMT. Thanks! Ruth - Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Tuesday, April 03, 2001 1:15 PM Hi Andreas, Please try this. select sysdate, new_time(sysdate,'EST','GMT') from dual; Thanks, Gurdarshan -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Tuesday, April 03, 2001 11:45 AM To: Multiple recipients of list ORACLE-L Hi ! Is there a way to get GMT time within PL/SQL independent from the local time(zone), I'm looking for a function similar to SYSDATE, but it should return GMT instead of the local time. TIA Andreas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Haunschmidt Andreas VASL/FAS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Singh, Gurdarshan (Gurdarshan)** CTR ** INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Marc Perkowitz INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Script to reverse engineer all objects in a schema to DDL?
Hi Chris, You could use Richard Sutherland's exciting Perl work, with his new DDL::Oracle Perl module, and it's associated scripts, which you can find here: = http://www.perl.com/CPAN-local/modules/by-authors/id/R/RV/RVSUTHERL/ Richard and I have also started embedding this automatically too within the Orac Perl/Tk Perl DBI program, which now has Oracle development options, as well as DBA login options, which you can find here: = http://www.perl.com/CPAN-local/modules/by-module/DBI/ANDYDUNC/ You do have to load Perl, Perl/Tk, Perl DBI and DBD::Oracle (on Windows, Linux, Solaris etc), but once you have all that (and why would you not want to? :), Orac should just run straight up, with a host of scripts to reverse engineer many/all? parts of the Oracle database (and now updated by Richard to work with Oracle 8.1.7, parallel servers etc) or at least it hopefully will when you run it, as we're still very ALPHA at the moment 8) Orac is still very much a DBA tool, but we are progressing as rapidly as we can with the developer options. Rgds, AndyD = [EMAIL PROTECTED] O'Reilly's "Oracle and Open Source": = http://www.oreilly.com/catalog/oracleopen/ Orac, Perl/Tk and Perl DBI Database DBA Development Tool: = http://www.perl.com/CPAN-local/modules/by-module/DBI/ANDYDUNC/ __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andy Duncan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: AT scheduler
Even more, if you are running crontab on NT, I strongly suggest to take a look at www.SuSe.com or alike. -Original Message- Sent: Tuesday, April 03, 2001 2:22 PM To: Multiple recipients of list ORACLE-L If you are running on NT, I strongly recommend you obtain crontab for Windows. AT will run 99.99% of the time... but not 100% of the time. On one of the servers here AT failed to run the very night that we were changing the time last Fall, very suspicious in my opinion. In any case for AT just do: at hh24:mm /every:M,T,W,Th,F,S,Su cmd /c pointer_to_my_script_or_program e.g. at 22:00 /every:M,T,W,Th,F cmd /c c:\pat\coldbackup.cmd That will create an entry: Added a new job with Job ID = some number To see the listing, just type AT [enter] To remove an entry, at ID_num /delete e.g. at 12 /delete Don't try to keep your jobs listing in any particular order, NT shuffles them around sometimes when you do maintenance on the server or when you reboot. For AT jobs to run, of course the Scheduler service must be running. The service has a couple of different names, depending on which service pack you installed on your server. Regards, Patrice Boivin Systems Analyst (Oracle DBA) Bedford Institute of Oceanography Fisheries and Oceans Canada -Original Message- From: Smith, Ron L. [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, April 03, 2001 1:30 PM To: Multiple recipients of list ORACLE-L Subject: "AT" scheduler Can anyone tell me how to schedule a batch job to run every 5 minutes using the "AT" scheduler? Thanks! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Help - How to declare a cursor inside a FOR ... LOOP ?
i speak from ignorance, isn't there implicit and explicit cursor declarations and usage? can't you encapsulate that section you have identified in a loop and it will implicitly opens a cursor? then all you have to do is manipulate as needed to generate desired results... ===Lerone StreeterSystem AnalystAbbott LBG[EMAIL PROTECTED]=== -Original Message-From: Dasko, Dan [mailto:[EMAIL PROTECTED]]Sent: Tuesday, April 03, 2001 3:41 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Help - How to declare a cursor inside a FOR ... LOOP ? You can't. It appears that you want to select all the detailed text extries related to a specific problem. You could define a cursor that selects all the detailed entries, or you could read all the detailed entries into a pl/sql table and then search through them. If you use the cursor, then you have to reopen the cursor for each new problem. Dan -Original Message-From: Wendy Y [mailto:[EMAIL PROTECTED]]Sent: Tuesday, April 03, 2001 2:51 PMTo: Multiple recipients of list ORACLE-LSubject: Help - How to declare a cursor inside a FOR ... LOOP ? Hey, Guys: I need to decalre a cursor inside a FOR .. LOOP,because the variables inSELECT statement for the CURSOR are coming from FOR .. LOOP. How could I do this? DECLARE V_AKTIV_NR aktiv.AKTIV_NR%TYPE; V_PROBLEM aktiv.PROBLEM%TYPE; V_ENDDAT aktiv.ENDDAT%TYPE; V_ENDUHR aktiv.ENDUHR%TYPE; V_AUSSAGEW aktiv.AUSSAGEW%TYPE; V_LANGTEXT aktiv.LANGTEXT%TYPE; V_LONGTEXT VARCHAR2(2); V_LONGTEXT_CUR VARCHAR2(13000); V_LONGTEXT_TRIM VARCHAR2(2000); p_PROBLEM PROBLEM.PROBLEM%TYPE; # This part need to be inside FOR.. LOOP, otherwise, I wouldn't get anything. CURSOR AKLangTextCur ISSELECT TO_CHAR(V_ENDDAT, 'MMDD')||' '|| V_ENDUHR||' '||rtrim(V_AUSSAGEW)||' '||rtrim(V_LANGTEXT) thisText FROM AKTIV WHERE V_PROBLEM = p_PROBLEM ORDER BY Aktiv_NR; AKLangTextRec AKLangTextCur%ROWTYPE; ### AboveBEGIN FOR v_LoopIndex IN 1..pkgFreeText.v_NumEntries LOOP V_AKTIV_NR := pkgFreeText.V_AKTIV_NR_P(v_LoopIndex); V_PROBLEM := pkgFreeText.V_PROBLEM_P(v_LoopIndex); V_ENDDAT := pkgFreeText.V_ENDDAT_P(v_LoopIndex); V_ENDUHR := pkgFreeText.V_ENDUHR_P(v_LoopIndex); V_AUSSAGEW := pkgFreeText.V_AUSSAGEW_P(v_LoopIndex); V_LANGTEXT := pkgFreeText.V_LANGTEXT_P(v_LoopIndex); SELECT PROBLEM INTO p_PROBLEM FROM PROBLEM; ## CURSOR DECLARE should be HERE ## BEGIN OPEN AKLangTextCur; LOOP FETCH AKLangTextCur into AKLangTextRec; EXIT WHEN AKLangTextCur%NOTFOUND; V_LONGTEXT_CUR := V_LONGTEXT_CUR ||AKLangTextRec.thisText; END LOOP; CLOSE AKLangTextCur; END;V_LONGTEXT := V_LONGTEXT || V_LONGTEXT_CUR; END LOOP;V_LONGTEXT_TRIM := RTRIM(V_LONGTEXT, 2000); Thanks a lot for help Wendy Do You Yahoo!?Yahoo! Mail Personal Address - Get email at your own domain with Yahoo! Mail. _This e-mail message has been scanned for the presence of all known computer viruses by the MessageLabs Virus Control Center. However, it is still recommended that you use local virus scanning software to monitor for the presence of viruses.
Re: Slightly OT: Capturing a failed status of an ftp process
I tried this, but the exit from the ftp is successful, so the return code ends up being successful also. Terry Gene Sais wrote: i find the easiest thing to do is put the ftp code in a function within the shell script. call the function from the shell script and check the return code ($?) or you could output to a file and grep the file for errors. got to play with it to see what works best for you. [EMAIL PROTECTED] 04/03/01 02:12PM Terry, If I remember correctly the ftp supplies a return code. You could capture the return code and have a second script act accordingly on the return code. I think code 220 is successfull. ROR mm [EMAIL PROTECTED] 04/03/01 01:30PM I think I've seen an answer to this, but I never needed it before. If anyone can help, I would greatly appreciate it. We are trying to ftp files from one server to another. (Archive logs for Oracle). We want to be able to capture the status when the ftp fails, so that we can notify the DBAs to check the process out. This is all being done within a shell script that compress the log file first, then calls another script to do the actual ftp. But when the child script executes, it returns a successful status to the parent script. I don't know any way to tell the script that is doing the ftp to send the message, because any non-ftp command within that script fails. (Of course, that could just be because I don't know how to do what I want to do). If anybody has invented this wheel before, or has any tips on where to look for more info on how to do what I need to do, please let me know. TIA, Terry -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Terry Ball INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gene Sais INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Terry Ball INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 Command to view stored procedure
Title: SQL Command to view stored procedure What is the SQL command, v$ table or SQL*Plus command to see the contents of a stored procedure? I looked at DBA_SOURCE but it stored the code in separate rows based on the owner and procedure name. Is there any way to see the source code for OEM view of the procedures? It displays what I want to see but developer doesn't have access to OEM. Thanks in advance. Val Valerie H. Webber Management Systems Designers, Inc Database Administrator [EMAIL PROTECTED] 704-566-5321
Re: Metalink Response ....FYI
Ross, You sound bitter...just remember it is only your job, not your life. Let them founder, you will still have a job. Ruth - Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Tuesday, April 03, 2001 4:10 PM Randy Baker left, yes...and another fellow...forced out, virtually. Then, the cost cutting began. People attrited or let go...cheaper monitors and equipment...reduced training budgets. "We Saved a Billion Dollars Last Year" by not doing their job. == -Original Message- == From: Eric D. Pierce [mailto:[EMAIL PROTECTED]] == Sent: Tuesday, April 03, 2001 3:22 PM == To: Multiple recipients of list ORACLE-L == Subject: RE: Metalink Response FYI == == == Steve, == == Thanks for the very interesting comments. Are those webified == apps with similar requirements as metalink? == == Also, didn't the VP in charge of support leave Oracle about a == year or so ago? == == == regards, == ep == == On 3 Apr 2001, at 7:26, Steve Adams wrote: == == ==I'd say that there must be something badly wrong with == the application if it ==cannot cope with 1,500 concurrent users. I know of == sites supporting more than 20 ==times that number of active users on a single server == with consistent sub-second ==response times. == == ... == == -- == Please see the official ORACLE-L FAQ: http://www.orafaq.com == -- == Author: Eric D. Pierce == INET: [EMAIL PROTECTED] == == Fat City Network Services-- (858) 538-5051 FAX: == (858) 538-5051 == San Diego, California-- Public Internet access / == Mailing Lists == - == --- == To REMOVE yourself from this mailing list, send an E-Mail message == to: [EMAIL PROTECTED] (note EXACT spelling of == 'ListGuru') and in == the message BODY, include a line containing: UNSUB ORACLE-L == (or the name of mailing list you want to be removed == from). You may == also send the HELP command for other information (like == subscribing). == -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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: Help - How to declare a cursor inside a FOR ... LOOP ?
You're probably right, I think I got stuck on the whole DECLARE BEGIN EXCEPTION END thing. -Original Message-From: Streeter, Lerone A LBX [mailto:[EMAIL PROTECTED]]Sent: Tuesday, April 03, 2001 4:36 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Help - How to declare a cursor inside a FOR ... LOOP ? i speak from ignorance, isn't there implicit and explicit cursor declarations and usage? can't you encapsulate that section you have identified in a loop and it will implicitly opens a cursor? then all you have to do is manipulate as needed to generate desired results... ===Lerone StreeterSystem AnalystAbbott LBG[EMAIL PROTECTED]=== -Original Message-From: Dasko, Dan [mailto:[EMAIL PROTECTED]]Sent: Tuesday, April 03, 2001 3:41 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Help - How to declare a cursor inside a FOR ... LOOP ? You can't. It appears that you want to select all the detailed text extries related to a specific problem. You could define a cursor that selects all the detailed entries, or you could read all the detailed entries into a pl/sql table and then search through them. If you use the cursor, then you have to reopen the cursor for each new problem. Dan -Original Message-From: Wendy Y [mailto:[EMAIL PROTECTED]]Sent: Tuesday, April 03, 2001 2:51 PMTo: Multiple recipients of list ORACLE-LSubject: Help - How to declare a cursor inside a FOR ... LOOP ? Hey, Guys: I need to decalre a cursor inside a FOR .. LOOP,because the variables inSELECT statement for the CURSOR are coming from FOR .. LOOP. How could I do this? DECLARE V_AKTIV_NR aktiv.AKTIV_NR%TYPE; V_PROBLEM aktiv.PROBLEM%TYPE; V_ENDDAT aktiv.ENDDAT%TYPE; V_ENDUHR aktiv.ENDUHR%TYPE; V_AUSSAGEW aktiv.AUSSAGEW%TYPE; V_LANGTEXT aktiv.LANGTEXT%TYPE; V_LONGTEXT VARCHAR2(2); V_LONGTEXT_CUR VARCHAR2(13000); V_LONGTEXT_TRIM VARCHAR2(2000); p_PROBLEM PROBLEM.PROBLEM%TYPE; # This part need to be inside FOR.. LOOP, otherwise, I wouldn't get anything. CURSOR AKLangTextCur ISSELECT TO_CHAR(V_ENDDAT, 'MMDD')||' '|| V_ENDUHR||' '||rtrim(V_AUSSAGEW)||' '||rtrim(V_LANGTEXT) thisText FROM AKTIV WHERE V_PROBLEM = p_PROBLEM ORDER BY Aktiv_NR; AKLangTextRec AKLangTextCur%ROWTYPE; ### AboveBEGIN FOR v_LoopIndex IN 1..pkgFreeText.v_NumEntries LOOP V_AKTIV_NR := pkgFreeText.V_AKTIV_NR_P(v_LoopIndex); V_PROBLEM := pkgFreeText.V_PROBLEM_P(v_LoopIndex); V_ENDDAT := pkgFreeText.V_ENDDAT_P(v_LoopIndex); V_ENDUHR := pkgFreeText.V_ENDUHR_P(v_LoopIndex); V_AUSSAGEW := pkgFreeText.V_AUSSAGEW_P(v_LoopIndex); V_LANGTEXT := pkgFreeText.V_LANGTEXT_P(v_LoopIndex); SELECT PROBLEM INTO p_PROBLEM FROM PROBLEM; ## CURSOR DECLARE should be HERE ## BEGIN OPEN AKLangTextCur; LOOP FETCH AKLangTextCur into AKLangTextRec; EXIT WHEN AKLangTextCur%NOTFOUND; V_LONGTEXT_CUR := V_LONGTEXT_CUR ||AKLangTextRec.thisText; END LOOP; CLOSE AKLangTextCur; END;V_LONGTEXT := V_LONGTEXT || V_LONGTEXT_CUR; END LOOP;V_LONGTEXT_TRIM := RTRIM(V_LONGTEXT, 2000); Thanks a lot for help Wendy Do You Yahoo!?Yahoo! Mail Personal Address - Get email at your own domain with Yahoo! Mail. _This e-mail message has been scanned for the presence of all known computer viruses by the MessageLabs Virus Control Center. However, it is still recommended that you use local virus scanning software to monitor for the presence of viruses. _This e-mail message has been scanned for the presence of all known computer viruses by the MessageLabs Virus Control Center. However, it is still recommended that you use local virus scanning software to monitor for the presence of viruses.
RE: Slightly OT: Capturing a failed status of an ftp process
Isn't it possible to check size of the source and remote file(s) after ftp. If they are the same - it is a high probability that transfer was OK. Alex Hillman -Original Message- From: Shari Dishop [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, April 03, 2001 3:52 PM To: Multiple recipients of list ORACLE-L Subject:RE: Slightly OT: Capturing a failed status of an ftp process Terry, I worked on what I think is a similar process. We are running SAP and need to be able to ftp files on and off of our unix SAP servers. Someone in the past wrote an SAP ABAP program that does all of the set up then calls a unix shell script to perform the ftp. If the ftp command truely failed to connect we had no problem getting back a failed error message to the SAP program. But where we ran into some problems was when the transfer command would start but get interrupted for some unknown reason and never fully complete the transfer. This was noticed by accident one day when someone was checking a report run off of one of the data transfers and there were only a few hundred records in the table to be processed instead of a few hundred thousand. I was then asked to come up with a solution that would look for an unexpected termination of the ftp connection. After lots of searching and getting one of our local unix gurus involved (I have worked directly on a unix platform), we implemented the following. It is not the best but it does seem to be working. We added a step to the ftp script. This step is a status command that is executed directly after the get or put command. This returns information about the ftp connection itself. It also returns a message if it is no longer connected. This output was passed back to the SAP program and parsed. If I had a message indicating that the remote host was still connected, I assumed that the get or put executed completely. If on the other hand I received the message indicating that the remote system was no longer connected I generated an error message from the program so that the user could check the data. Shari Dishop SAP ABAP - Project Systems Team Logicon - A Northrop Grumman Company Baltimore, MD RE: I think I've seen an answer to this, but I never needed it before. If anyone can help, I would greatly appreciate it. We are trying to ftp files from one server to another. (Archive logs for Oracle). We want to be able to capture the status when the ftp fails, so that we can notify the DBAs to check the process out. This is all being done within a shell script that compress the log file first, then calls another script to do the actual ftp. But when the child script executes, it returns a successful status to the parent script. I don't know any way to tell the script that is doing the ftp to send the message, because any non-ftp command within that script fails. (Of course, that could just be because I don't know how to do what I want to do). If anybody has invented this wheel before, or has any tips on where to look for more info on how to do what I need to do, please let me know. TIA, Terry -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Terry Ball INET: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shari Dishop INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hillman, Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be
