RE: Forms - as sysdba
Hi I don't have 9i to test, but I believe you might be able to set O7_DICTIONARY_ACCESSIBILITY = TRUE in init.ora and then you should be able to connect as sys without specifying sysdba. This might be suitable for the upgrade - certainly test it out on a test system first. Regarding the upgrade - why exactly does it need to be connected as sys - eg what doesn't work if you connect as system. HTH, Bruce Reardon -Original Message- Sent: Friday, 22 August 2003 4:49 PM Robo You can connect as ifrun60.EXE C:\...\..\logon2.fmx Regards Suhen -Original Message- Sent: Friday, 22 August 2003 4:39 PM I MUST connect as sys, because it's a part of an upgrade of our system. I will try to find some kind of patch for this situation as Jared suggested. Anyway, it should be possible to connect from command line, shouldn't it? Something like: c:\orant\bin\ifrun60.exe C:\dev\form.fmx sys/[EMAIL PROTECTED] \/'as sysdba' =RP= -Original Message- Sent: Thursday, August 21, 2003 5:54 PM Rather, why do you want to connect as SYS ? If you've created some custom tables in the SYS schema in an earlier version, create another user, connect as SYS in sqlplus, GRANT privileges to that user and connect as that new user in Forms. -- and think about migrating the tables out of the SYS schema. If you are querying standard tables, OEM provides good views for most of what you need and the group here can provide better SQL scripts anyway. Hemant At 07:29 AM 21-08-03 -0800, you wrote: Try if it works if you put sys/sys as sysdba to forms username prompt? (without quotes) But why do you want to connect as sysdba anyway? Tanel. - Original Message - To: Multiple recipients of list ORACLE-L Sent: Thursday, August 21, 2003 11:54 AM Hi all, I have a 9.2.0.3 DB and I need to connect to Forms 6i as user sys. There are 3 boxes for username, password and database. I tried a lot of combinations, eg: Username: sys as sysdba Password: sys Database: db sys/[EMAIL PROTECTED] as sysdba sys/[EMAIL PROTECTED] /as sysdba sys/[EMAIL PROTECTED] 'as sysdba' sys/[EMAIL PROTECTED] '/as sysdba' But I always get an error message - either invalid username/password or TNS error (can't recognize the connect string). I have also tried it from command line but didn't succeed. Does anyone know if/how is it possible? Thanks a lot Robert Pipich -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Reardon, Bruce (CALBBAY) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Nature of Oracle-l has changed
Yes I would say that most of the topics have been more in line with operational issues. I think RMAN has probably had a higher hit in the conversation counter and that i guess is due to more DBA's flirting with it in there environment, Roberts book probably helps. Since I am fortunate enough to be working with in a development project I will have to see what I can do to stir up some conversations. Should have a major AQ design sub project coming up, so here's hoping Maybe now that there is signs of life back in the US economy things might become a bit more active in the development world, unless America has shipped all development work offshore these days. Its Friday arvo and almost beer o'clock so the brain is about to hit neutral. Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = If people did not sometimes do silly things, nothing intelligent would ever get done. - Ludwig Wittgenstein = Mincom The People, The Experience, The Vision = This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. Jared Still [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 22/08/2003 04:19 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Nature of Oracle-l has changed Has anyone else noticed? Not so long ago, we saw quite a few more questions about such things as data modeling, application security architecture, physical database design, and Oracle Designer Not so much anymore. Do you think it's because there are so few development projects taking place? Seems like in house development died with the dot bomb and has not begun to recover. I know at my place of employment there is very little development, but that is due more to the size and nature of this place, as well as the management. ( they don't like in house development :( ) Now I spend my days with stuff like making NetBackup work with Oracle, migrating SAP all over the place and keeping things running. Not that we haven't always done those things, but I miss some not having a good development project. Ah, to do some real data modeling again. Just some food for thought. Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Collaboration Suite
Actually I'm a bit surprised, that OCS works that well for you. My impression about Oracle products is that Oracle Server is the only Oracle server-type product which may work out-of-the-box. I've worked with iAS since v.2 and yes, E-Business suite as well. The worst experiences are with IFS (v.1.1) that crashed so hard we had to hack our data out of it and switch back to regular fileserver which I now know should be used for serving files anyway. That's why I didn't even take a look on OCS when it came out - I remember the InterOffice disaster too well.. But if several people say, especially here, that it works for you, I think it's time to check it out. Wonder if it'll run in test env with 512MB of RAM using Linux? Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, August 21, 2003 9:24 PM Brian, We're using OCS Release 2 on Linux (RHAS2.1) internally (15 users). We also did a production install of OCS Release 2 on Linux RHAS2.1 for a customer in NJ (100 users). They are very happy and impressed with the OCS functionality, especially iMeeting. The price comparison to Exchange didn't hurt, either... :-) By the way, both of these installs were on a single Dell server, which is something that Oracle has not yet figured out how to do, apparently. The complicating issue is not collapsing everything onto a single server, which is pretty straightforward (as with Oracle E-Business Suites). Rather, it is more that a single-server install makes things more complicated from a security perspective, as you have to be much more specific about what ports are opened to the internet and which ports are not. As with Oracle E-Business Suites, OCS uses lots and lots of network ports, but E-Biz is usually a purely intranet app and rarely (if ever?) faces the big bad internet. Believe me, put a server on the internet and you *will* be hacked within 4 hours... For 500 users, you'd definitely want a two-server configuration anyway, so it's probably a moot point. Let me know if you'd like some HW sizing info? Hope this helps... -Tim on 8/20/03 2:49 PM, Brian Haas at [EMAIL PROTECTED] wrote: Hello all, We're looking at Oracle collaboration suite and I'm wondering if anyone here is using it? If so, how is it working? Any issues? I know Oracle corp is using it for all their internal mail so I assume it could handle our 500 or so users just fine. Thanks, -Brian -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: question on how to retrive document
Ok, in that case it's nice - you can index your BFILEs and retrieve them using other methods such NFS or webserver accessing files directly Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, August 22, 2003 12:34 AM Yes, context can index BFILEs. We used in to index a collection of pdfs. This is probably not fastest way of reading data, but it is not always a goal. Vadim -Original Message- Sent: Thursday, August 21, 2003 5:10 PM To: Multiple recipients of list ORACLE-L Agree. When using NFS or any other OS file sharing mechanism, then there's no point of using BFILEs at all Or is context catrtidge/oracle text able to index contents of bfiles? Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, August 21, 2003 7:59 PM Tanel, if you use oracle to read BFILE's, you're no faster then by reading normal LOB's, because the mechanism is exactly the same: DBMS_LOB.READ into a buffer and buffer sent to you through Oracle*Net. The only way that you can be faster then that is to read the file name from a normal VARCHAR2 variable and then bypass oracle in accessing that file, and access it through some non-oracle mechanism,typically NFS or CIFS (Samba). Oracle database is created for reading structured tables by means of SQL, not for reading plain files. To read a plain file, you will use software designed exactly for that purpose. It's called file system. Both NFSv3 and Samba V2 can beat oracle hands down in speed of reading/writing files to a remote node. What Samba and NFS cannot do is to retrieve record sets from those files using SQL. They can help you to bulk read the file into a document processor and nothing more. if speed is all that matters, you read the file name from oracle and then read the file by using appropriate tools like NFS, Samba or something else. -- Mladen Gogala Oracle DBA -Original Message- Tanel Poder Sent: Thursday, August 21, 2003 11:55 AM To: Multiple recipients of list ORACLE-L Hi! Of course, you could give IFS a shot. I would still go with CLOBS if I were you. You can do bfiles, but hten you have to set NFS server and you can retrieve the document only if you have access to something called /docs/oracle/bfile or similar, and that is rather hard to do from an NT station. You can also store an ASCII file as an external You can read BFILEs without having client access to the file. As long Oracle has access to the file, it can open it stream it to you. But if you want write access to these files you have to do it from OS or with utl_file or similar packages. Gets too complicated to use if your end users want to modify those docs, but it could work if you're loading your doc's once and they are only read afterwards. But yes, internal lobs can be fast if implemented properly. Tanel. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL
RE: Making my firts job
Hi!! I am making my firts job and I have some problems calculating the correct = time to lauch the job. I have the next procedure: CREATE OR REPLACE PROCEDURE SP_SOH_HAND AS BEGIN INSERT INTO TB_ICTRANSX select COMPANY, LOCATION,ITEM,SOH_QTY,AVERAGE_COST,= SYSDATE-1, UPDATE_TIME from iTEMLOC where TRACKING_FL=3D'Y'; COMMIT; END SP_SOH_HAND; / This procedure will feed a table every day, I want this to happen after = midnight, on the first second of the next day, every day. How can I create = a job to do that? Teresita, Just read $ORACLE_HOME/rdbms/admin/dbmsjob.sql, comments (which used to be inexact) explain fairly well how to do it. The interval you need is 'trunc(sysdate) + 1'. And don't forget to check that parameter job_processes is 0 (I even prefer 1). Regards, Stephane Faroult Oriole -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Online Document for Windows XP Home edition Severity 3
Title: Message Try copying the contents of the CD to a directory on your hard drive. Search for all instances of symcjit.dll in that directory and below and rename them to symcjit.dll.old. Then run setup from the directory on your hard drive. Gudmundur -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Sinardy XingSent: 21. ágúst 2003 15:01To: Multiple recipients of list ORACLE-LSubject: Online Document for Windows XP Home edition Severity 3 Hi all, I have new notebook, I want to install Oracle Doc 8.1.7, but Oraclefail to run when I clickInstall/Deinstall button Some said XP home edition cannot install Oracle, is this because Sun demand Ms toremovethe JVM? Can someonehelp me please.. Thanks Sinardy
Re: Forms - as sysdba
Robo wrote: Hi all, I have a 9.2.0.3 DB and I need to connect to Forms 6i as user sys. There are 3 boxes for username, password and database. Does anyone know if/how is it possible? Yes, you could do this by creating an ON-LOGON trigger. But this is a really, really bad idea. Scott Lamb -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Scott Lamb INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Online Document for Windows XP Home edition Severity 3
Title: Message If you have reached a point where you could press the Install/DeInstall button, it means that you dont have any problem with your Java installation/settings. Try to troubleshoot in other areas. Also, update the Forum with your success story once you are done. ~Venu -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Gudmundur Bjarni Josepsson Sent: Friday, August 22, 2003 2:54 PM To: Multiple recipients of list ORACLE-L Subject: RE: Online Document for Windows XP Home edition Severity 3 Try copying the contents of the CD to a directory on your hard drive. Search for all instances of symcjit.dll in that directory and below and rename them to symcjit.dll.old. Then run setup from the directory on your hard drive. Gudmundur -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Sinardy Xing Sent: 21. ágúst 2003 15:01 To: Multiple recipients of list ORACLE-L Subject: Online Document for Windows XP Home edition Severity 3 Hi all, I have new notebook, I want to install Oracle Doc 8.1.7, but Oraclefail to run when I clickInstall/Deinstall button Some said XP home edition cannot install Oracle, is this because Sun demand Ms toremovethe JVM? Can someonehelp me please.. Thanks Sinardy **Disclaimer Information contained in this E-MAIL being proprietary to Wipro Limited is 'privileged' and 'confidential' and intended for use only by the individual or entity to which it is addressed. You are notified that any use, copying or dissemination of the information contained in the E-MAIL in any manner whatsoever is strictly prohibited. ***
AW: RH not-so-Advanced 2.1 and new hardware
Hi Rich ! Most of the NICs are NE2000 compatible. This means that you could run your NIC by using the module 'ne2k-pci.o' in '/lib/modules/$KERNEL_VERSION/kernel/drivers/net'. (on RH9 or RG AS2.1) I am using this module at home to run my RT8139 NIC under RHAS 2.1 HTH. Milen -Ursprüngliche Nachricht- Von: Jesse, Rich [mailto:[EMAIL PROTECTED] Gesendet: Donnerstag, 21. August 2003 18:35 An: Multiple recipients of list ORACLE-L Betreff: RH not-so-Advanced 2.1 and new hardware We're trying to test/prove 9iRAC on a cheap setup. Has anyone used newer hardware when trying to install RH not-so-AS 2.1? I've got an Intel D845GERG2 motherboard and the old 2.4-9 kernel doesn't have a module for the onboard ethernet. Also, intel.com has a few Linux drivers for this MB, but they require 2.4-11+. I'm going to try and run -- shudder -- up2date, but I thought I'd ask here, too, since I can't be the first to put up with this horse hockey. TIA, Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kulev, Milen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Online Document for Windows XP Home edition Severity 3
Title: Message Sinardy, I've installed the Oracle docs simply by copying all the directories from the CD to my hard drive - no need to perform an installation. Hope this helps. Tom Mercadante Oracle Certified Professional -Original Message-From: Gudmundur Bjarni Josepsson [mailto:[EMAIL PROTECTED]Sent: Friday, August 22, 2003 5:24 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Online Document for Windows XP Home edition Severity 3 Try copying the contents of the CD to a directory on your hard drive. Search for all instances of symcjit.dll in that directory and below and rename them to symcjit.dll.old. Then run setup from the directory on your hard drive. Gudmundur -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Sinardy XingSent: 21. ágúst 2003 15:01To: Multiple recipients of list ORACLE-LSubject: Online Document for Windows XP Home edition Severity 3 Hi all, I have new notebook, I want to install Oracle Doc 8.1.7, but Oraclefail to run when I clickInstall/Deinstall button Some said XP home edition cannot install Oracle, is this because Sun demand Ms toremovethe JVM? Can someonehelp me please.. Thanks Sinardy
RE: Making my firts job
Simple: TRUNC(SYSDATE) + 1 + 1/60/60/24 TRUNC(SYSDATE) is midnight today. +1 is midnight tomorrow. +1/60/60/24 is one second past midnight- 1/60th of a minute, which is 1/60th of an hour, which is 1/24th of a day. -Original Message-From: Teresita Castro [mailto:[EMAIL PROTECTED]Sent: Thursday, August 21, 2003 8:15 PMTo: Multiple recipients of list ORACLE-LSubject: Making my firts job Hi!! I am making my firts job and I have some problems calculating the correct time to lauch the job. I have the next procedure: CREATE OR REPLACE PROCEDURE SP_SOH_HANDASBEGININSERT INTO TB_ICTRANSX select COMPANY, LOCATION,ITEM,SOH_QTY,AVERAGE_COST, SYSDATE-1, UPDATE_TIME from iTEMLOC where TRACKING_FL='Y';COMMIT;END SP_SOH_HAND;/ This procedure will feed a table every day, I want this tohappen after midnight, on the first second of the next day, every day. How can I create a job to do that?
Oracle 9i versus MS SQL 2K w.r.t. Performance
Need to give a presentation on Oracle 9i versus MS SQL Server 2K with respect to Performance primarily . Any Docs , Links ? Thanks
Re: Row level security and latch waits - LONG email...
- Original Message - Policy function: DPA42HP92.DP_PREDICATE_FUNCTION_PKG.DP_PREDICATE_FUNCTION RLS view : SELECT CURRENCY,CURRENCY_CODE,CURRENCY_DESC,CURRENCY_KEY FROM DPA42HP9 2.DPR70_CURRENCY_D DPR70_CURRENCY_D WHERE (CURRENCY_CODE in (select value_ v from dp_security_values where group_id in (select group_id from dp_upd_user_groups where comp_group_id = sys_context('dp_comp_group_id_ctx','comp_group_id')) as you can see the context variable is being used in the generated predicate clause That makes perfect sense now. Thanks a lot for the feedback. Cheers Nuno Souto [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nuno Souto INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Nature of Oracle-l has changed
Jared, I agree that the development has declined at a lot of sites. We are a VB shop and damagement has decided to outsource the hosting of our reports database and the web based development of the application to access the reports database. I soon will go from a 84 GIG database to a 5 GIG database that houses 5 in-house applications. I guess that it is cheaper to outsource than pay for training of your employees. All of the changes in the bottom line on the financial reports have a lot of people scrambling to increase their knowledge in different arenas to enable their continued employment. If you look at the different threads that have been in the email's, it points to the fact that a lot of oracle users are testing and trying the newer OS's and Oracle combinations. I think that this points out the fact that a lot of the DBA are trying to increase their knowledge and worth as well as damagement trying to show a better bottom line. The great advantage with this list is that a lot of users have tried a lot of different combinations (OS,hardware,Oracle versions) and have solved a lot of problems. The questions are posted and there is an abundant supply of answers available. Times are changing and the dinosaur will become extinct if the don't become like a shark.. My 2$. Ron [EMAIL PROTECTED] 08/22/03 02:19AM Has anyone else noticed? Not so long ago, we saw quite a few more questions about such things as data modeling, application security architecture, physical database design, and Oracle Designer Not so much anymore. Do you think it's because there are so few development projects taking place? Seems like in house development died with the dot bomb and has not begun to recover. I know at my place of employment there is very little development, but that is due more to the size and nature of this place, as well as the management. ( they don't like in house development :( ) Now I spend my days with stuff like making NetBackup work with Oracle, migrating SAP all over the place and keeping things running. Not that we haven't always done those things, but I miss some not having a good development project. Ah, to do some real data modeling again. Just some food for thought. Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: SharePlex info
Title: Message Tony, My question was inspired by belief that SharePlex does log mining on the source DB and hence do not send unnecessary data over the network. Apparently, this is not the case. I didn't want to compare SharePlex to logical standby cause I know that logical standby definitely needs all logs transported to the target site where is does log mining. We considering remote disaster recovery site where we want to have working data and we don't care much about "log" tables. Thank you for valuable info. -Original Message-From: Aponte, Tony [mailto:[EMAIL PROTECTED]Sent: Thursday, August 21, 2003 5:44 PMTo: Multiple recipients of list ORACLE-LSubject: RE: SharePlex info Your bandwidth requirements will be the rate of changes to the actual data. The traffic consists of the actual data and control information needed to reassemble the transaction on the target. The source database's other redo payload (i.e., index operations, rollback segment maintenance, etc.) is not used by Shareplex. In our environment of dual Sun 6800's, 10 CPU's each, we observe less that 1% CPU consumption on the source and target sides combined. It varies according to the DML load on the source but not by much. We've never had a problem with it consuming a noticeable amount. I have a question on the comparison between a physical standby and Shareplex replication.Isn't9i's logical standby featurebetter suited for the comparison to Shareplex? I'm assuming that you are considering offloading some processing to another host since you are looking to replicate about 50% of the tables in the source database. HTH Tony Aponte -Original Message-From: Gorbounov,Vadim [mailto:[EMAIL PROTECTED]Sent: Thursday, August 21, 2003 1:49 PMTo: Multiple recipients of list ORACLE-LSubject: SharePlex info Hi All, I'm trying to find some technical details about SharePlex, that is: - How much network bandwidth I'd expect to replicate from database, generating 1-5 MB/sec redo. DoesSharePlex send SQL text over the network or data in some internal (hopefully compressed)format - How much CPU on the source DB server side would it cost - just a ball park - very little- little - or a lot - Of two options, using 9.2 physical async standby db and clone whole database vs replicate 50% (enough from business requirements) of tables using SharePlex, which onesounds preferrable keeping in mind minimizing CPU burden on the source database. Any opinion or pointer to any benchmark is highly appreciated. Thanks a lot Vadim
Business Rules approach to design?
I know this is big in the ODTUG circles. Has anyone used this approach to design databases? Seems promising. Though the hardest part would be in convincing the 'i just want to code' folks to adapt it. I havent really read that much into it. It also appears that the level of skill and experience required at the upper levels of the project would have to be quite high to make this work. anyone have an opinion? (see jared, now we have a database design post). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle 9i memory Leaks and other errors
anyone helppp -Original Message- Sent: Thursday 21 August 2003 07:59 To: Multiple recipients of list ORACLE-L -Original Message- Sent: Monday 18 August 2003 06:36 To: '[EMAIL PROTECTED]' Hi Can anyone help me with Oracle 9i database - ie 9.2.0.3 where there are issues such as memory leaks and other issues or bugs. Has anyone doing data warehousing or transaction processing encountered any issues with this version of Oracle and what have you done to fix it. I have found errors with using FOR CURSOR loops - encountered problems with it where it took extremely long to run due to a memory leak in Oracle. We had to apply a patch to fix this. HAs anyone encountered any other problems as DBAs or Developers? Regards Bhavesh -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bhavesh Lala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bhavesh Lala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RH not-so-Advanced 2.1 and new hardware
Thanks for the suggestion! Since our RAC tests have two main goals -- to test RAC functionality and to test it on RH AS 2.1 -- I've temporarily given up on AS 2.1 and installed RH9 instead. Of course with the newer kernel and more mods included, it installed easily without a problem. I'll be saving this message for the future. Thanks! Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- From: Kulev, Milen [mailto:[EMAIL PROTECTED] Sent: Friday, August 22, 2003 5:04 AM To: Multiple recipients of list ORACLE-L Subject: AW: RH not-so-Advanced 2.1 and new hardware Hi Rich ! Most of the NICs are NE2000 compatible. This means that you could run your NIC by using the module 'ne2k-pci.o' in '/lib/modules/$KERNEL_VERSION/kernel/drivers/net'. (on RH9 or RG AS2.1) I am using this module at home to run my RT8139 NIC under RHAS 2.1 HTH. Milen -Ursprüngliche Nachricht- Von: Jesse, Rich [mailto:[EMAIL PROTECTED] Gesendet: Donnerstag, 21. August 2003 18:35 An: Multiple recipients of list ORACLE-L Betreff: RH not-so-Advanced 2.1 and new hardware We're trying to test/prove 9iRAC on a cheap setup. Has anyone used newer hardware when trying to install RH not-so-AS 2.1? I've got an Intel D845GERG2 motherboard and the old 2.4-9 kernel doesn't have a module for the onboard ethernet. Also, intel.com has a few Linux drivers for this MB, but they require 2.4-11+. I'm going to try and run -- shudder -- up2date, but I thought I'd ask here, too, since I can't be the first to put up with this horse hockey. TIA, Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
OT: Mysql PHP list
Title: OT: Mysql PHP list Hi, Does anybody know a good list for questions about PHP in combination with Mysql (and oracle) TIA Jack
+++ Oracle + RAID +++++++++
Dear Friends, I have read some book to know about Oracle on RAID. I better idea about various RAIDs. But Implementing Oracle on RAID , I am not much clear. My understaning is 1. All files on RAID 1 +0 ( because its good in IO rates, better protective ) 2. Read only TS on RAID 5.(because its read intensive ). He has given some examples ,but could explain it well, Can you please send some case studies on RAID for Oracle. Please send me details about ur production Oracle systems, and lot of examples. Any good we site with pictorial information. NOTE: This is just for information only. Thanks a lot. Regards Rajuveera ** This email (including any attachments) is intended for the sole use of the intended recipient/s and may contain material that is CONFIDENTIAL AND PRIVATE COMPANY INFORMATION. Any review or reliance by others or copying or distribution or forwarding of any or all of the contents in this message is STRICTLY PROHIBITED. If you are not the intended recipient, please contact the sender by email and delete all copies; your cooperation in this regard is appreciated. ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Veeraraju_Mareddi INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
UNIX and Oracle
Dear Friends, Any good article to explain the above subject, SHARED Memory Sema phores on SUN / LINUX for Oracle. I just know what is shared memory , sema phores are. But never involved practically much. Please also send me some typical configurations , with explanation(if possible ) Please send me details about ur UNIX production Oracle systems, and lot of examples. Any good we site with pictorial information. NOTE: This is just for information only. Thanks a lot. Regards Rajuveera ** This email (including any attachments) is intended for the sole use of the intended recipient/s and may contain material that is CONFIDENTIAL AND PRIVATE COMPANY INFORMATION. Any review or reliance by others or copying or distribution or forwarding of any or all of the contents in this message is STRICTLY PROHIBITED. If you are not the intended recipient, please contact the sender by email and delete all copies; your cooperation in this regard is appreciated. ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Veeraraju_Mareddi INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle 9i memory Leaks and other errors
You can find the interesting information on http://www.metalink.com -- Mladen Gogala Oracle DBA -Original Message- Bhavesh Lala Sent: Friday, August 22, 2003 10:09 AM To: Multiple recipients of list ORACLE-L anyone helppp -Original Message- Sent: Thursday 21 August 2003 07:59 To: Multiple recipients of list ORACLE-L -Original Message- Sent: Monday 18 August 2003 06:36 To: '[EMAIL PROTECTED]' Hi Can anyone help me with Oracle 9i database - ie 9.2.0.3 where there are issues such as memory leaks and other issues or bugs. Has anyone doing data warehousing or transaction processing encountered any issues with this version of Oracle and what have you done to fix it. I have found errors with using FOR CURSOR loops - encountered problems with it where it took extremely long to run due to a memory leak in Oracle. We had to apply a patch to fix this. HAs anyone encountered any other problems as DBAs or Developers? Regards Bhavesh -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bhavesh Lala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bhavesh Lala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Nature of Oracle-l has changed
That's why my post on historic tables and views seem lonely ;-) Stephane -Original Message- Jared Still Sent: Friday, August 22, 2003 2:19 AM To: Multiple recipients of list ORACLE-L Has anyone else noticed? Not so long ago, we saw quite a few more questions about such things as data modeling, application security architecture, physical database design, and Oracle Designer Not so much anymore. Do you think it's because there are so few development projects taking place? Seems like in house development died with the dot bomb and has not begun to recover. I know at my place of employment there is very little development, but that is due more to the size and nature of this place, as well as the management. ( they don't like in house development :( ) Now I spend my days with stuff like making NetBackup work with Oracle, migrating SAP all over the place and keeping things running. Not that we haven't always done those things, but I miss some not having a good development project. Ah, to do some real data modeling again. Just some food for thought. Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Paquette INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: OT: Mysql PHP list
Jack, if you've got some specific questions shoot them my way, i'm doing php/mysql development right now for dynamic web pages. joe Jack van Zanen wrote: Hi, Does anybody know a good list for questions about PHP in combination with Mysql (and oracle) TIA Jack -- Joseph S Testa Chief Technology Officer Data Management Consulting p: 614-791-9000 f: 614-791-9001 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Business Rules approach to design?
I have a growing respect for the business rules approach to system design. For instance, entities and relationships as drawn in a traditional entity/relationship (E/R) diagram are representations of business rules about what data your system will read, update, store and write and how various pieces of that data are related. This is implemented as tables, columns, keys, referencial integrity, constraints, and triggers. However, these same implementation methods and languages also need to include implementations of other business rules that cannot be easily depicted on E/R diagrams, such as entity life cycles and use cases. The trouble is in translating rules to code, mostly because the code can vary in language and place of implementatation according to what kind of business rule you are trying to implement. One approach that is seeing some success, is to include all business rules in a rule database, and using generators to translate the rules into code. One interesting thing to note is that most of the code associated with the rules has nothing to do with the presentation layer - the GUI that most users see. This means that once you have defined the logical subset of data that a module will use, you can set developers free to just code a simple module based on that data - providing that it has good error handling for whatever informational, warning and error messages the code enforcing the rules may send back. Where is this code? In the database and/or application server, not in the Forms or Java or whatever code that provides the GUI. -Original Message- Sent: Friday, August 22, 2003 9:49 AM To: Multiple recipients of list ORACLE-L I know this is big in the ODTUG circles. Has anyone used this approach to design databases? Seems promising. Though the hardest part would be in convincing the 'i just want to code' folks to adapt it. I havent really read that much into it. It also appears that the level of skill and experience required at the upper levels of the project would have to be quite high to make this work. anyone have an opinion? (see jared, now we have a database design post). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Flack INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Collaboration Suite
switch back to regular fileserver which I now know should be used for serving files anyway. In the future of course, 'regular' file servers will actually be running on top of a database. SQL Server if your file server happens to be of the M$ variety. Will SysAdmins also need to be DBA's? ;) Jared On Fri, 2003-08-22 at 00:39, Tanel Poder wrote: Actually I'm a bit surprised, that OCS works that well for you. My impression about Oracle products is that Oracle Server is the only Oracle server-type product which may work out-of-the-box. I've worked with iAS since v.2 and yes, E-Business suite as well. The worst experiences are with IFS (v.1.1) that crashed so hard we had to hack our data out of it and switch back to regular fileserver which I now know should be used for serving files anyway. That's why I didn't even take a look on OCS when it came out - I remember the InterOffice disaster too well.. But if several people say, especially here, that it works for you, I think it's time to check it out. Wonder if it'll run in test env with 512MB of RAM using Linux? Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, August 21, 2003 9:24 PM Brian, We're using OCS Release 2 on Linux (RHAS2.1) internally (15 users). We also did a production install of OCS Release 2 on Linux RHAS2.1 for a customer in NJ (100 users). They are very happy and impressed with the OCS functionality, especially iMeeting. The price comparison to Exchange didn't hurt, either... :-) By the way, both of these installs were on a single Dell server, which is something that Oracle has not yet figured out how to do, apparently. The complicating issue is not collapsing everything onto a single server, which is pretty straightforward (as with Oracle E-Business Suites). Rather, it is more that a single-server install makes things more complicated from a security perspective, as you have to be much more specific about what ports are opened to the internet and which ports are not. As with Oracle E-Business Suites, OCS uses lots and lots of network ports, but E-Biz is usually a purely intranet app and rarely (if ever?) faces the big bad internet. Believe me, put a server on the internet and you *will* be hacked within 4 hours... For 500 users, you'd definitely want a two-server configuration anyway, so it's probably a moot point. Let me know if you'd like some HW sizing info? Hope this helps... -Tim on 8/20/03 2:49 PM, Brian Haas at [EMAIL PROTECTED] wrote: Hello all, We're looking at Oracle collaboration suite and I'm wondering if anyone here is using it? If so, how is it working? Any issues? I know Oracle corp is using it for all their internal mail so I assume it could handle our 500 or so users just fine. Thanks, -Brian -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Business Rules approach to design?
And I thank you. :) On Fri, 2003-08-22 at 06:49, [EMAIL PROTECTED] wrote: I know this is big in the ODTUG circles. Has anyone used this approach to design databases? Seems promising. Though the hardest part would be in convincing the 'i just want to code' folks to adapt it. I havent really read that much into it. It also appears that the level of skill and experience required at the upper levels of the project would have to be quite high to make this work. anyone have an opinion? (see jared, now we have a database design post). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Exact fetch
Hallo, anyon who can tell me whatthis mean`? I get it while I am trying to load some data in some tables? ORA-01422: exact fetch re turns more than requested number of rows Thanks in advance Roland S -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle 9i memory Leaks and other errors
I have tried there and they just have a patch but not much other info which can help -Original Message- Sent: Friday 22 August 2003 04:20 To: Multiple recipients of list ORACLE-L You can find the interesting information on http://www.metalink.com -- Mladen Gogala Oracle DBA -Original Message- Bhavesh Lala Sent: Friday, August 22, 2003 10:09 AM To: Multiple recipients of list ORACLE-L anyone helppp -Original Message- Sent: Thursday 21 August 2003 07:59 To: Multiple recipients of list ORACLE-L -Original Message- Sent: Monday 18 August 2003 06:36 To: '[EMAIL PROTECTED]' Hi Can anyone help me with Oracle 9i database - ie 9.2.0.3 where there are issues such as memory leaks and other issues or bugs. Has anyone doing data warehousing or transaction processing encountered any issues with this version of Oracle and what have you done to fix it. I have found errors with using FOR CURSOR loops - encountered problems with it where it took extremely long to run due to a memory leak in Oracle. We had to apply a patch to fix this. HAs anyone encountered any other problems as DBAs or Developers? Regards Bhavesh -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bhavesh Lala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bhavesh Lala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bhavesh Lala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Exact fetch
Title: RE: Exact fetch it means Exact fetch returns more than requested number of rows, nothing more, nothing less. HTH Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, August 22, 2003 10:45 AM To: Multiple recipients of list ORACLE-L Subject: Exact fetch Hallo, anyon who can tell me whatthis mean`? I get it while I am trying to load some data in some tables? ORA-01422: exact fetch re turns more than requested number of rows Thanks in advance Roland S -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*2
RE: Exact fetch
What does the load procedure look like? AFAIK this means that a select into returns more than one row in the subquery, which would indicate use of PL/SQL Any triggers etc..?? Jack -Original Message- Sent: Friday, August 22, 2003 4:45 PM To: Multiple recipients of list ORACLE-L Hallo, anyon who can tell me whatthis mean`? I get it while I am trying to load some data in some tables? ORA-01422: exact fetch re turns more than requested number of rows Thanks in advance Roland S -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jack van Zanen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle 9i versus MS SQL 2K w.r.t. Performance
The Yukon Database Try this link http://www.oracle.com/features/insider/index.html?1101_db_yukonlate.htmland http://www.oracle.com/ip/deploy/database/oracle9i/db_sqlpartners.html Alessandro Guimarães - Original Message - From: VIVEK_SHARMA To: Multiple recipients of list ORACLE-L Sent: Friday, August 22, 2003 6:04 AM Subject: Oracle 9i versus MS SQL 2K w.r.t. Performance Need to give a presentation on Oracle 9i versus MS SQL Server 2K with respect to Performance primarily . Any Docs , Links ? Thanks
Re: Exact fetch
7:24-sherlock:ts01:jkstill-0 oerr ora 1422 01422, 0, exact fetch returns more than requested number of rows // *Cause: The number specified in exact fetch is less than the rows returned. // *Action: Rewrite the query or change number of rows requested 07:25:43 sherlock - [EMAIL PROTECTED] SQL 07:25:43 sherlock - [EMAIL PROTECTED] SQL drop table x; Table dropped. 07:25:44 sherlock - [EMAIL PROTECTED] SQL 07:25:44 sherlock - [EMAIL PROTECTED] SQL create table x 07:25:44 2 as 07:25:44 3 select table_name 07:25:44 4 from user_tables 07:25:44 5 / Table created. 07:25:44 sherlock - [EMAIL PROTECTED] SQL 07:25:44 sherlock - [EMAIL PROTECTED] SQL declare 07:25:44 2 y x.table_name%type; 07:25:44 3 begin 07:25:44 4 select table_name into y from x; 07:25:44 5 end; 07:25:44 6 / declare * ERROR at line 1: ORA-01422: exact fetch returns more than requested number of rows ORA-06512: at line 4 On Fri, 2003-08-22 at 07:44, [EMAIL PROTECTED] wrote: Hallo, anyon who can tell me whatthis mean`? I get it while I am trying to load some data in some tables? ORA-01422: exact fetch re turns more than requested number of rows Thanks in advance Roland S -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Partitions in RH AS 2.1
Title: Partitions in RH AS 2.1 Hi list, New in linux. I configured a RAID 0 in a Dell Server and installed RH AS 2.1. Now as a result I have a /dev/sda4 of 200 GB. I used fdisk and made 3 partitions that became /dev/sda9, /dev/sda10, /dev/sda11. Now I want to make the file systems and mount the partitions and haven't been able to do it. Any help would be appreciated. TIA Ramon E. Estevez [EMAIL PROTECTED] 809-535-8994
Re: RE: Business Rules approach to design?
i head paul dorsey(from dulcian) speak last night. he was talking about a business rules repository modeller that his company has called 'BRIM' supposed it will generate the bulk of the code for you. anyone ever work with that? From: John Flack [EMAIL PROTECTED] Date: 2003/08/22 Fri AM 10:34:29 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Business Rules approach to design? I have a growing respect for the business rules approach to system design. For instance, entities and relationships as drawn in a traditional entity/relationship (E/R) diagram are representations of business rules about what data your system will read, update, store and write and how various pieces of that data are related. This is implemented as tables, columns, keys, referencial integrity, constraints, and triggers. However, these same implementation methods and languages also need to include implementations of other business rules that cannot be easily depicted on E/R diagrams, such as entity life cycles and use cases. The trouble is in translating rules to code, mostly because the code can vary in language and place of implementatation according to what kind of business rule you are trying to implement. One approach that is seeing some success, is to include all business rules in a rule database, and using generators to translate the rules into code. One interesting thing to note is that most of the code associated with the rules has nothing to do with the presentation layer - the GUI that most users see. This means that once you have defined the logical subset of data that a module will use, you can set developers free to just code a simple module based on that data - providing that it has good error handling for whatever informational, warning and error messages the code enforcing the rules may send back. Where is this code? In the database and/or application server, not in the Forms or Java or whatever code that provides the GUI. -Original Message- Sent: Friday, August 22, 2003 9:49 AM To: Multiple recipients of list ORACLE-L I know this is big in the ODTUG circles. Has anyone used this approach to design databases? Seems promising. Though the hardest part would be in convincing the 'i just want to code' folks to adapt it. I havent really read that much into it. It also appears that the level of skill and experience required at the upper levels of the project would have to be quite high to make this work. anyone have an opinion? (see jared, now we have a database design post). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Flack INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Oracle on RAID - Thanks
To whomever posted the link to Gaja's paper Implementing RAID on Oracle - thank you. I previously had printed and passed this article on to my system administrator -- no reaction. But yesterday he was building our new Sun system with all the latest features, and was so excited about the paper that he asked for a second copy to share with his junior sys admin. He stopped building the system to take a day to study Gaja's paper in detail. Of course, the Sun engineer is saying our new RAID 5 is just as fast as RAID 10 because we stripe parity across all disks. Since this will be an OLTP system, I am planning on an 8K Oracle block size, unless anyone has better information on how to pick a block size. Apparently there are a lot of storage system parameters you can optimize, but they are based on the Oracle block size. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle 9i memory Leaks and other errors
Are you sure it is a memory leak or is it problem with program design? What are the error messeges? Bit tough to provide any feedback with the minimal information you have provided. Brad O. -Original Message- Sent: Friday, August 22, 2003 9:09 AM To: Multiple recipients of list ORACLE-L anyone helppp -Original Message- Sent: Thursday 21 August 2003 07:59 To: Multiple recipients of list ORACLE-L -Original Message- Sent: Monday 18 August 2003 06:36 To: '[EMAIL PROTECTED]' Hi Can anyone help me with Oracle 9i database - ie 9.2.0.3 where there are issues such as memory leaks and other issues or bugs. Has anyone doing data warehousing or transaction processing encountered any issues with this version of Oracle and what have you done to fix it. I have found errors with using FOR CURSOR loops - encountered problems with it where it took extremely long to run due to a memory leak in Oracle. We had to apply a patch to fix this. HAs anyone encountered any other problems as DBAs or Developers? Regards Bhavesh -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bhavesh Lala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bhavesh Lala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Odland, Brad INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
HP-UX 11/9iR2/Processes
Hi Everyone: I've noticed a new type of background process in my 9iR2 databases. It's name is ora_j00n_SID. Does anyone know what this process is? Any links to Docs? Thanks, Mike -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Vergara, Michael (TEM) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle 9i versus MS SQL 2K w.r.t. Performance
Vivek - This subject has been discussed on this list from time to time. You can go to Google and search for Oracle-L SQL Server and variations to pull up previous discussions. Awhile back eWeek magazine did an extensive benchmark. It is a little date, but make sure you re-read that for insights. They also had a recent article discussing the shortcomings of their benchmark. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, August 22, 2003 8:05 AM To: Multiple recipients of list ORACLE-L Need to give a presentation on Oracle 9i versus MS SQL Server 2K with respect to Performance primarily . Any Docs , Links ? Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Nature of Oracle-l has changed
There is another thing happening: companies are more and more relying on canned, off the shelf applications, in a hope to become compliant with present standards. That has dramatically cut down the number of needed developers, because if you don't have to develop your general ledger, payroll, CRM and HR software, you only need IT staffers to monitor production. That is why I think that Jonathan Lewis is wrong in his Practical Databases when he talks about DBA being a repository of knowledge. No, the role of the DBA today is the one of a crane operator: just get the darned thing going, buddy. DBA is a mechanic that fixes database when it's slow, and that's it. The business role of IT is no longer to be at the forefront of the organization, but to keep thins running and do what business people tell them to do. Companies are no longer doing development are leaving cooking to the cooks and software development to the big software companies. One of the reasons is also the culture clash among very well educated, liberal and hippie computer geeks and somewhat less educated old school drill sergeant type managers who want everybody to be at their desks at 7:30, cleanly shaven, no jeans, no surf naked Dilbert T-shirts or I am a DMCA circumvention device T-shirts. Basically, what I'm noticing is sort of returning to the roots cultural movement where business management no longer wants to tolerate the laid back IT culture. When cost cutting decisions are made, IT people are the 1st to go. They stil need DBA's because they'd better have somebody monitoring their multi-TB databases, but development is no longer necessary. IT applications are going to be as standardized as a stapler, so there is less and less need for development. Friends, we're dinosaurs, a dying breed. I'm considering a career of a second hand car salesman or a real estate agent. -- Mladen Gogala Oracle DBA -Original Message- Stephane Paquette Sent: Friday, August 22, 2003 10:29 AM To: Multiple recipients of list ORACLE-L That's why my post on historic tables and views seem lonely ;-) Stephane -Original Message- Jared Still Sent: Friday, August 22, 2003 2:19 AM To: Multiple recipients of list ORACLE-L Has anyone else noticed? Not so long ago, we saw quite a few more questions about such things as data modeling, application security architecture, physical database design, and Oracle Designer Not so much anymore. Do you think it's because there are so few development projects taking place? Seems like in house development died with the dot bomb and has not begun to recover. I know at my place of employment there is very little development, but that is due more to the size and nature of this place, as well as the management. ( they don't like in house development :( ) Now I spend my days with stuff like making NetBackup work with Oracle, migrating SAP all over the place and keeping things running. Not that we haven't always done those things, but I miss some not having a good development project. Ah, to do some real data modeling again. Just some food for thought. Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Paquette INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of
RE: Nature of Oracle-l has changed
Jared, Yes, the nature of the list has changed, so have the times. While development work here is not slowing, the direction that we're going in has changed. Oracle's development tools are just about history here replaced by PeopleSlop and JAVA. Also I've spent a significant amount of time delving into open source database options such as PostGreSQL and MySql (soon to be off the open source list I do believe). I have the advantage of a CIO who does not like having the business too dependent on a single vendor for anything. I must admit I don't agree since having a multitude of vendors involved causes problem resolution to stretch out since they like to point fingers at each other. Also I think MetaLink has improved a whole lot. I find 80 to 90% of the answers on Oracle related questions on MetaLink. BTW: If you think this list has changed, subscribe to ODTUG-L. That list has just about died!! Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Friday, August 22, 2003 2:19 AM To: Multiple recipients of list ORACLE-L Has anyone else noticed? Not so long ago, we saw quite a few more questions about such things as data modeling, application security architecture, physical database design, and Oracle Designer Not so much anymore. Do you think it's because there are so few development projects taking place? Seems like in house development died with the dot bomb and has not begun to recover. I know at my place of employment there is very little development, but that is due more to the size and nature of this place, as well as the management. ( they don't like in house development :( ) Now I spend my days with stuff like making NetBackup work with Oracle, migrating SAP all over the place and keeping things running. Not that we haven't always done those things, but I miss some not having a good development project. Ah, to do some real data modeling again. Just some food for thought. Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Goulet, Dick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Nature of Oracle-l has changed
OK, who let Chicken Little out of his room?? As someone at a location that is doing a lot of third party application buying, yes we in some ways are crane operators and mechanics. But then comes the fun of integrating the data from that new application into the remainder of the applications in place. 99% of the time these interactions, and reporting needs, are outside of the vendors scope of knowledge. SO who do you think gets the job? You guessed it, the DBA. Are we dinosaurs? Yes, if you don't open your eyes to other possibilities. I believe the mantra needs to be evolve and prosper, stagnate and die. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Friday, August 22, 2003 11:49 AM To: Multiple recipients of list ORACLE-L There is another thing happening: companies are more and more relying on canned, off the shelf applications, in a hope to become compliant with present standards. That has dramatically cut down the number of needed developers, because if you don't have to develop your general ledger, payroll, CRM and HR software, you only need IT staffers to monitor production. That is why I think that Jonathan Lewis is wrong in his Practical Databases when he talks about DBA being a repository of knowledge. No, the role of the DBA today is the one of a crane operator: just get the darned thing going, buddy. DBA is a mechanic that fixes database when it's slow, and that's it. The business role of IT is no longer to be at the forefront of the organization, but to keep thins running and do what business people tell them to do. Companies are no longer doing development are leaving cooking to the cooks and software development to the big software companies. One of the reasons is also the culture clash among very well educated, liberal and hippie computer geeks and somewhat less educated old school drill sergeant type managers who want everybody to be at their desks at 7:30, cleanly shaven, no jeans, no surf naked Dilbert T-shirts or I am a DMCA circumvention device T-shirts. Basically, what I'm noticing is sort of returning to the roots cultural movement where business management no longer wants to tolerate the laid back IT culture. When cost cutting decisions are made, IT people are the 1st to go. They stil need DBA's because they'd better have somebody monitoring their multi-TB databases, but development is no longer necessary. IT applications are going to be as standardized as a stapler, so there is less and less need for development. Friends, we're dinosaurs, a dying breed. I'm considering a career of a second hand car salesman or a real estate agent. -- Mladen Gogala Oracle DBA -Original Message- Stephane Paquette Sent: Friday, August 22, 2003 10:29 AM To: Multiple recipients of list ORACLE-L That's why my post on historic tables and views seem lonely ;-) Stephane -Original Message- Jared Still Sent: Friday, August 22, 2003 2:19 AM To: Multiple recipients of list ORACLE-L Has anyone else noticed? Not so long ago, we saw quite a few more questions about such things as data modeling, application security architecture, physical database design, and Oracle Designer Not so much anymore. Do you think it's because there are so few development projects taking place? Seems like in house development died with the dot bomb and has not begun to recover. I know at my place of employment there is very little development, but that is due more to the size and nature of this place, as well as the management. ( they don't like in house development :( ) Now I spend my days with stuff like making NetBackup work with Oracle, migrating SAP all over the place and keeping things running. Not that we haven't always done those things, but I miss some not having a good development project. Ah, to do some real data modeling again. Just some food for thought. Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Paquette INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to:
RE: Nature of Oracle-l has changed
It also seems that once the big canned application are up and running, companies are outsourcing more and more the operations. Those canned applications need to be integrated and that's the best and last place where DBA and dev people can be today, in the BI place. Here, in the architecture principles we are buying instead of developping. That's easy to do for payroll and that kind of stuff. But when you have over 20 bought applications, you need something to integrate all this to an ODS and or DW. And those 2 are not in the canned application market (not yet, I've heard from an Oracle DW consulting manager that Oracle wants to automate that part also). Stephane Paquette Administrateur de bases de donnees Database Administrator Standard Life www.standardlife.ca Tel. (514) 499-7999 7470 and (514) 925-7187 [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- Mladen Gogala Sent: Friday, August 22, 2003 11:49 AM To: Multiple recipients of list ORACLE-L There is another thing happening: companies are more and more relying on canned, off the shelf applications, in a hope to become compliant with present standards. That has dramatically cut down the number of needed developers, because if you don't have to develop your general ledger, payroll, CRM and HR software, you only need IT staffers to monitor production. That is why I think that Jonathan Lewis is wrong in his Practical Databases when he talks about DBA being a repository of knowledge. No, the role of the DBA today is the one of a crane operator: just get the darned thing going, buddy. DBA is a mechanic that fixes database when it's slow, and that's it. The business role of IT is no longer to be at the forefront of the organization, but to keep thins running and do what business people tell them to do. Companies are no longer doing development are leaving cooking to the cooks and software development to the big software companies. One of the reasons is also the culture clash among very well educated, liberal and hippie computer geeks and somewhat less educated old school drill sergeant type managers who want everybody to be at their desks at 7:30, cleanly shaven, no jeans, no surf naked Dilbert T-shirts or I am a DMCA circumvention device T-shirts. Basically, what I'm noticing is sort of returning to the roots cultural movement where business management no longer wants to tolerate the laid back IT culture. When cost cutting decisions are made, IT people are the 1st to go. They stil need DBA's because they'd better have somebody monitoring their multi-TB databases, but development is no longer necessary. IT applications are going to be as standardized as a stapler, so there is less and less need for development. Friends, we're dinosaurs, a dying breed. I'm considering a career of a second hand car salesman or a real estate agent. -- Mladen Gogala Oracle DBA -Original Message- Stephane Paquette Sent: Friday, August 22, 2003 10:29 AM To: Multiple recipients of list ORACLE-L That's why my post on historic tables and views seem lonely ;-) Stephane -Original Message- Jared Still Sent: Friday, August 22, 2003 2:19 AM To: Multiple recipients of list ORACLE-L Has anyone else noticed? Not so long ago, we saw quite a few more questions about such things as data modeling, application security architecture, physical database design, and Oracle Designer Not so much anymore. Do you think it's because there are so few development projects taking place? Seems like in house development died with the dot bomb and has not begun to recover. I know at my place of employment there is very little development, but that is due more to the size and nature of this place, as well as the management. ( they don't like in house development :( ) Now I spend my days with stuff like making NetBackup work with Oracle, migrating SAP all over the place and keeping things running. Not that we haven't always done those things, but I miss some not having a good development project. Ah, to do some real data modeling again. Just some food for thought. Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Paquette INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list
Re: HP-UX 11/9iR2/Processes
It is the snp equivalent ...in 9i rel2 there is a job coordinator process and based on the job_queue_processes parameter ...that many jnnn processes. Murali. Vergara, Michael (TEM) To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] [EMAIL PROTECTED] cc: ant.com Subject: HP-UX 11/9iR2/Processes Sent by: [EMAIL PROTECTED] ity.com 08/22/2003 11:34 AM Please respond to ORACLE-L Hi Everyone: I've noticed a new type of background process in my 9iR2 databases. It's name is ora_j00n_SID. Does anyone know what this process is? Any links to Docs? Thanks, Mike -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Vergara, Michael (TEM) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: Murali_Pavuloori/[EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: (long) Design question, historic and views
Hi! To answer your original question about the design DW transport, there is too much to write to answer it completely. There's too many different ways to do the task. I'll try to give you a reply from my past experience with OLTP- DW transfer (from up to 800GB OLTP systems to 2-3TB DWs). 1) Let say we have a table EMP which we want to replicate to DW. 2) EMP has a monotonically increasing timestamp/sequence column for being able to put versions in order or enforce optimistic locking. 3) There is a trigger on EMP which duplicates rows to EMP2 table, based on our rules (insert/update/delete in our case) 4) EMP2 table is range partititioned table on timestamp column, with single partition. 5) When we decide to transfer changes to DW, we split the EMP2 table to 2 partitions, one partition with all current rows in EMP2 table, second partitions for all values from max(timestamp in EMP2)+1 .. MAXVALUE 6) We do exchange partitions with table EMP3 (all the rows in EMP2 first partition go to EMP3 table) 7) Now we can safely transport the changes to DW staging area without interrupting triggered inserts to EMP2 and without having to worry about whether any new rows were inserted into EMP2 meanwhile. 8) We drop partition 1 of EMP2 table, generating practically no redo, and leaving only the records inserted after split partition into EMP2. 9) And we start all over from step 5 again if want to transport next set of changes. Btw, if you write your trigger accordingly, you can just update the master table when new version arrives and let the trigger handle copying old version to EMP2 - no deletes are required. It could even be possible to write trigger to update only those columns in row which actually have changed, to reduce rollback and redo amount, but this will probably be harder on your CPU. Anyway if you do so, and your trigger gets fairly large, it might be reasonable to put the code in a package, pin it and call the package from trigger. It's matter of benchmarking. So, I just described a solution we used to you - this was back in 8.0 days, today there's a lot of other solutions like logminer/streams for example. Ok, that much from transporting. I don't quite get where do you want to place the views and what is their purpose? In your ODS? Or DW? Were you asking for a mean to distinguish between current and old versions? If in ODS you have your current and old version tables separate (EMP vs. EMP2) then there's no problems - all current versions are in EMP table. But in DW where all records are together you have two options (which first come into my mind): 1) Modify ETL process to update some column of future old record to set current=N when new record comes in. This means that you have to search update old current version of a record every time you insert a new version. 2) Do not modify ETL process at all, use timestamp column instead (timestamp/sqn is monotonically increasing column), so whichever record has larger sequence# is the current one. There are buts as well, for example if you want to keep deleted versions also in your DW, then you could update timestamp to 0 or similar. Also, depending on average number of versions, this might get quite slow if you aren't able to use indexes properly (should use ascending index range scan instead of sorting with large number of versions). I hope it was what you were asking about. This was my... erm... 3 cents (sync, sync, sync ;) Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, August 22, 2003 5:29 PM That's why my post on historic tables and views seem lonely ;-) Stephane -Original Message- Jared Still Sent: Friday, August 22, 2003 2:19 AM To: Multiple recipients of list ORACLE-L Has anyone else noticed? Not so long ago, we saw quite a few more questions about such things as data modeling, application security architecture, physical database design, and Oracle Designer Not so much anymore. Do you think it's because there are so few development projects taking place? Seems like in house development died with the dot bomb and has not begun to recover. I know at my place of employment there is very little development, but that is due more to the size and nature of this place, as well as the management. ( they don't like in house development :( ) Now I spend my days with stuff like making NetBackup work with Oracle, migrating SAP all over the place and keeping things running. Not that we haven't always done those things, but I miss some not having a good development project. Ah, to do some real data modeling again. Just some food for thought. Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services
AW: Nature of Oracle-l has changed
Hi Stephane Looks like I missed that post amongst all the very technical ones ;). I'm working on a development project now (social security), which includes heavy modelling, especially in the arena of historical data etc. So, it looks like I have to go back and browse the archive for your posting. Stefan Stefan Jahnke Consultant BOV Aktiengesellschaft Tel.: +49 201/45 13-289 mailto:[EMAIL PROTECTED] http://www.bov.de Abonnieren Sie unseren Newsletter: http://www.bov.de/enews Kosten senken - strategische IT-Ziele erreichen! BOV Microsoft Day am 24.07.03 in Essen. Anmeldung unter http://www.bov.de/microsoft-day oder mailto:[EMAIL PROTECTED] Wie Sie wissen, koennen ueber das Internet versandte E-Mails leicht unter fremden Namen erstellt oder manipuliert werden. Aus diesem Grunde bitten wir um Verstaendnis dafuer, dass wir zu Ihrem und unserem Schutz die rechtliche Verbindlichkeit der vorstehenden Erklaerungen und Aeusserungen ausschliessen. As you are probably aware, e-mails sent via the Internet can easily be copied or manipulated by third parties. For this reason we would ask for your understanding that, for your own protection and ours, we must decline all legal responsibility for the validity of the statements and comments given above. -Ursprüngliche Nachricht- Von: Stephane Paquette [mailto:[EMAIL PROTECTED] Gesendet: Freitag, 22. August 2003 16:29 An: Multiple recipients of list ORACLE-L Betreff: RE: Nature of Oracle-l has changed That's why my post on historic tables and views seem lonely ;-) Stephane -Original Message- Jared Still Sent: Friday, August 22, 2003 2:19 AM To: Multiple recipients of list ORACLE-L Has anyone else noticed? Not so long ago, we saw quite a few more questions about such things as data modeling, application security architecture, physical database design, and Oracle Designer Not so much anymore. Do you think it's because there are so few development projects taking place? Seems like in house development died with the dot bomb and has not begun to recover. I know at my place of employment there is very little development, but that is due more to the size and nature of this place, as well as the management. ( they don't like in house development :( ) Now I spend my days with stuff like making NetBackup work with Oracle, migrating SAP all over the place and keeping things running. Not that we haven't always done those things, but I miss some not having a good development project. Ah, to do some real data modeling again. Just some food for thought. Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Paquette INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stefan Jahnke INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RE: Nature of Oracle-l has changed
Mladen, There is another thing happening: companies are more and more relying on canned, off the shelf applications, in a hope to become compliant with present standards. That has dramatically cut down the number of needed developers, because if you don't have to develop your general ledger, payroll, CRM and HR software, you only need IT staffers to monitor production. Granted for these functions, which are rarely at the core of your business. However, by turning to canned applications for everything, firms are doing nothing that turning themselves into commodities - the road to bust for those unable to sustain a price war. And most canned applications of some breadth seem to require a degree of 'parameterization' which demands teams often bigger (and more expensive) than yesterday's in-house development teams. Interestingly, the amount of data which everybody is storing seems to outpace Moore's law by a comfortable factor. Which, if nothing else, proves that the payroll and HR software is not where the action is. They stil need DBA's because they'd better have somebody monitoring their multi-TB databases, but development is no longer necessary. Wait for 10G, which takes care of itself :-). Stephane Faroult Oriole -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
AW: Nature of Oracle-l has changed
Hi Mladen I guess you summarized the whole drama of IT today pretty well. I'm already VERY concerned about the near future (esp. as a former developer, now more DBA/Data Manager guy). What's left to do, or to concentrate on, when development will be shipped to elsewhere and DBAing means Hey Joe, just keep the thingy running ... kind of work (Also looks like a good opportunitiy for a neat salary ... nooot). Move over to become a business analyst type (ouch, how boring), ... do BI, like Data Mining/Statistics ?! Who knows. Stefan -Ursprüngliche Nachricht- Von: Mladen Gogala [mailto:[EMAIL PROTECTED] Gesendet: Freitag, 22. August 2003 17:49 An: Multiple recipients of list ORACLE-L Betreff: RE: Nature of Oracle-l has changed There is another thing happening: companies are more and more relying on canned, off the shelf applications, in a hope to become compliant with present standards. That has dramatically cut down the number of needed developers, because if you don't have to develop your general ledger, payroll, CRM and HR software, you only need IT staffers to monitor production. That is why I think that Jonathan Lewis is wrong in his Practical Databases when he talks about DBA being a repository of knowledge. No, the role of the DBA today is the one of a crane operator: just get the darned thing going, buddy. DBA is a mechanic that fixes database when it's slow, and that's it. The business role of IT is no longer to be at the forefront of the organization, but to keep thins running and do what business people tell them to do. Companies are no longer doing development are leaving cooking to the cooks and software development to the big software companies. One of the reasons is also the culture clash among very well educated, liberal and hippie computer geeks and somewhat less educated old school drill sergeant type managers who want everybody to be at their desks at 7:30, cleanly shaven, no jeans, no surf naked Dilbert T-shirts or I am a DMCA circumvention device T-shirts. Basically, what I'm noticing is sort of returning to the roots cultural movement where business management no longer wants to tolerate the laid back IT culture. When cost cutting decisions are made, IT people are the 1st to go. They stil need DBA's because they'd better have somebody monitoring their multi-TB databases, but development is no longer necessary. IT applications are going to be as standardized as a stapler, so there is less and less need for development. Friends, we're dinosaurs, a dying breed. I'm considering a career of a second hand car salesman or a real estate agent. -- Mladen Gogala Oracle DBA -Original Message- Stephane Paquette Sent: Friday, August 22, 2003 10:29 AM To: Multiple recipients of list ORACLE-L That's why my post on historic tables and views seem lonely ;-) Stephane -Original Message- Jared Still Sent: Friday, August 22, 2003 2:19 AM To: Multiple recipients of list ORACLE-L Has anyone else noticed? Not so long ago, we saw quite a few more questions about such things as data modeling, application security architecture, physical database design, and Oracle Designer Not so much anymore. Do you think it's because there are so few development projects taking place? Seems like in house development died with the dot bomb and has not begun to recover. I know at my place of employment there is very little development, but that is due more to the size and nature of this place, as well as the management. ( they don't like in house development :( ) Now I spend my days with stuff like making NetBackup work with Oracle, migrating SAP all over the place and keeping things running. Not that we haven't always done those things, but I miss some not having a good development project. Ah, to do some real data modeling again. Just some food for thought. Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Paquette INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the
RE: Forms - as sysdba
Title: RE: Forms - as sysdba What about granting sysdba priviledge to yourself? then you could do everything sys could do! my 0.02 Luis -Original Message-From: Suhen Pather [mailto:[EMAIL PROTECTED]Sent: Thursday, August 21, 2003 6:19 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Forms - as sysdba One thing to bear in mind for forms development is Oracle does not support connecting as "/" (OPS$). Suhen -Original Message- From: Jared Still [mailto:[EMAIL PROTECTED]] Sent: Friday, 22 August 2003 1:02 AM To: Multiple recipients of list ORACLE-L Subject: Re: Forms - as sysdba As this is Forms 6i, which was around long before "connect '/ as sysdba'" was required, Forms does not know about the new syntax. Try checking on MetaLink for a patch. Jared On Thu, 2003-08-21 at 01:54, Robo wrote: Hi all, I have a 9.2.0.3 DB and I need to connect to Forms 6i as user sys. There are 3 boxes for username, password and database. I tried a lot of combinations, eg: Username: sys as sysdba Password: sys Database: db sys/[EMAIL PROTECTED] as sysdba sys/[EMAIL PROTECTED] /as sysdba sys/[EMAIL PROTECTED] 'as sysdba' sys/[EMAIL PROTECTED] '/as sysdba' But I always get an error message - either invalid username/password or TNS error (can't recognize the connect string). I have also tried it from command line but didn't succeed. Does anyone know if/how is it possible? Thanks a lot Robert Pipich -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
time/date granularity
Hi, Is there a way for me to get the time of a particular sysdate past the granularity of one second? Thanks! Josh -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Josh Collier INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Making my firts job
Thanks !! A friend of mine give an example of how to do a procedure that runs a job: CREATE OR REPLACE PROCEDURE lanza_job IS jobno number; instno number; begin dbms_job.submit( jobno, 'SP_SOH_HAND;', TRUNC(SYSDATE) + 1/60/60/24 ,'TRUNC(SYSDATE) + 1 + 1/60/60/24 '); commit; END lanza_job; After add the start and end date I want to ask you if this procedure is correct. I want the job to start today and continue runs every single day. Thanks a lot for your help, I am learning so much been in this list. ( I hope you understand my English) [EMAIL PROTECTED] 08/22/03 07:04AM Simple: TRUNC(SYSDATE) + 1 + 1/60/60/24 TRUNC(SYSDATE) is midnight today. +1 is midnight tomorrow. +1/60/60/24 is one second past midnight- 1/60th of a minute, which is 1/60th of an hour, which is 1/24th of a day. -Original Message-From: Teresita Castro [mailto:[EMAIL PROTECTED]Sent: Thursday, August 21, 2003 8:15 PMTo: Multiple recipients of list ORACLE-LSubject: Making my firts job Hi!! I am making my firts job and I have some problems calculating the correct time to lauch the job. I have the next procedure: CREATE OR REPLACE PROCEDURE SP_SOH_HANDASBEGININSERT INTO TB_ICTRANSX select COMPANY, LOCATION,ITEM,SOH_QTY,AVERAGE_COST, SYSDATE-1, UPDATE_TIME from iTEMLOC where TRACKING_FL='Y';COMMIT;END SP_SOH_HAND;/ This procedure will feed a table every day, I want this tohappen after midnight, on the first second of the next day, every day. How can I create a job to do that?
ADMIN: Collaboration Suite mailing list?
Hi group -- I've been toying with starting a new mailing list for Oracle Collaboration Suite (OCS) users and administrators. It's a fairly new product and I haven't seen any mailing lists other than what is on OTN, so there might be a need. I realize that participation might be low as the list starts, but I think it will grow. Certainly, the dollar justification is becoming HUGE as compared with Exchange, and I think more and more companies are turning to OCS as a COTS solution. I would like some input (both pro and con) as to whether you think there is value in starting a new list. If you don't think it would be a good idea, I'd like to know why (you saw another mailing list already, you don't think there's much to talk about, this list is enough, etc). If you do think it is a good idea, I'd like to know if it is a mailing list you would join and whether you think it would be valuable. PLEASE SEND REPLIES TO ME ([EMAIL PROTECTED]) PRIVATELY, not to the list! I'll summarize to the list, but there's no point in having a bunch of me too! type replies go to the list. ;-) thanks! bruce -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bruce A. Bergman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RE: Nature of Oracle-l has changed
There is another problem with canned applications. The damanagement has to make a choice to either bend the business to match the application of bend the application to match the business. From my point of view, the latter is happening more than the former. Also, as a side note, I believe the list's tone has changed as companies are trying to find cheaper solutions to their database needs. Although in the end run Sql*Server and DB2 come out close to Oracle in cost, they hide most of the added stuff as either third party applications or else unmentioned extras that you'll need. Oracle just bundles it all up front making then look more expensive than the others. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Friday, August 22, 2003 12:59 PM To: Multiple recipients of list ORACLE-L Mladen, There is another thing happening: companies are more and more relying on canned, off the shelf applications, in a hope to become compliant with present standards. That has dramatically cut down the number of needed developers, because if you don't have to develop your general ledger, payroll, CRM and HR software, you only need IT staffers to monitor production. Granted for these functions, which are rarely at the core of your business. However, by turning to canned applications for everything, firms are doing nothing that turning themselves into commodities - the road to bust for those unable to sustain a price war. And most canned applications of some breadth seem to require a degree of 'parameterization' which demands teams often bigger (and more expensive) than yesterday's in-house development teams. Interestingly, the amount of data which everybody is storing seems to outpace Moore's law by a comfortable factor. Which, if nothing else, proves that the payroll and HR software is not where the action is. They stil need DBA's because they'd better have somebody monitoring their multi-TB databases, but development is no longer necessary. Wait for 10G, which takes care of itself :-). Stephane Faroult Oriole -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Goulet, Dick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE:OT:UNIX: Anyway to run this in the background and return to ca
Title: RE:OT:UNIX: Anyway to run this in the background and return to calling process $ORACLE_HOME/bin/sqlplus / as sysdba EOD select .. exit EOD echo this is a test ps -ef|grep sqlplus I wish to put that into a unix command but at the same time run it in the background and return back to the parent script to do some other stuff? Anyone done this?
RE: time/date granularity
Josh - Which Oracle version? I think 9i has provision for this. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, August 22, 2003 12:20 PM To: Multiple recipients of list ORACLE-L Hi, Is there a way for me to get the time of a particular sysdate past the granularity of one second? Thanks! Josh -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Josh Collier INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Nature of Oracle-l has changed
Do you see outsourcing orientation to the canned products in Germany? I imagined that Siemens, Software AG, MBB (Airbus) and some other companies must be doing heavy development there, and that, given the language barrier, the supply for the off the shelf products is not as good as here in the US. The analysis from my earlier message was depicting my view of the situation here in the US. Situation is probably very similar in UK, because their language is very similar to the American (why don't they adopt the ANSI spelling rules, so that I don't have to think about rumour, humour, colour, pavement, tube, fag and alike?), but I wasn't so sure about the rest of the EU. -- Mladen Gogala Oracle DBA -Original Message- Stefan Jahnke Sent: Friday, August 22, 2003 1:00 PM To: Multiple recipients of list ORACLE-L Hi Mladen I guess you summarized the whole drama of IT today pretty well. I'm already VERY concerned about the near future (esp. as a former developer, now more DBA/Data Manager guy). What's left to do, or to concentrate on, when development will be shipped to elsewhere and DBAing means Hey Joe, just keep the thingy running ... kind of work (Also looks like a good opportunitiy for a neat salary ... nooot). Move over to become a business analyst type (ouch, how boring), ... do BI, like Data Mining/Statistics ?! Who knows. Stefan -Ursprüngliche Nachricht- Von: Mladen Gogala [mailto:[EMAIL PROTECTED] Gesendet: Freitag, 22. August 2003 17:49 An: Multiple recipients of list ORACLE-L Betreff: RE: Nature of Oracle-l has changed There is another thing happening: companies are more and more relying on canned, off the shelf applications, in a hope to become compliant with present standards. That has dramatically cut down the number of needed developers, because if you don't have to develop your general ledger, payroll, CRM and HR software, you only need IT staffers to monitor production. That is why I think that Jonathan Lewis is wrong in his Practical Databases when he talks about DBA being a repository of knowledge. No, the role of the DBA today is the one of a crane operator: just get the darned thing going, buddy. DBA is a mechanic that fixes database when it's slow, and that's it. The business role of IT is no longer to be at the forefront of the organization, but to keep thins running and do what business people tell them to do. Companies are no longer doing development are leaving cooking to the cooks and software development to the big software companies. One of the reasons is also the culture clash among very well educated, liberal and hippie computer geeks and somewhat less educated old school drill sergeant type managers who want everybody to be at their desks at 7:30, cleanly shaven, no jeans, no surf naked Dilbert T-shirts or I am a DMCA circumvention device T-shirts. Basically, what I'm noticing is sort of returning to the roots cultural movement where business management no longer wants to tolerate the laid back IT culture. When cost cutting decisions are made, IT people are the 1st to go. They stil need DBA's because they'd better have somebody monitoring their multi-TB databases, but development is no longer necessary. IT applications are going to be as standardized as a stapler, so there is less and less need for development. Friends, we're dinosaurs, a dying breed. I'm considering a career of a second hand car salesman or a real estate agent. -- Mladen Gogala Oracle DBA -Original Message- Stephane Paquette Sent: Friday, August 22, 2003 10:29 AM To: Multiple recipients of list ORACLE-L That's why my post on historic tables and views seem lonely ;-) Stephane -Original Message- Jared Still Sent: Friday, August 22, 2003 2:19 AM To: Multiple recipients of list ORACLE-L Has anyone else noticed? Not so long ago, we saw quite a few more questions about such things as data modeling, application security architecture, physical database design, and Oracle Designer Not so much anymore. Do you think it's because there are so few development projects taking place? Seems like in house development died with the dot bomb and has not begun to recover. I know at my place of employment there is very little development, but that is due more to the size and nature of this place, as well as the management. ( they don't like in house development :( ) Now I spend my days with stuff like making NetBackup work with Oracle, migrating SAP all over the place and keeping things running. Not that we haven't always done those things, but I miss some not having a good development project. Ah, to do some real data modeling again. Just some food for thought. Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services
RE: Nature of Oracle-l has changed
Well...I made the transition from development to DBA when we initially got SAP'd (1993) partly because it looked interesting, partly because I was the only one on the development staff who bothered to dig into the technical end of things and...partly because management at the time had this overly optimistic assumption that they wouldn't need programmers after they dumped all the in-house applications and dinosaur software packages. There was also the assumption that client-server systems would require fewer people to support. Hah! Through various mergers, divestments, acquistions, and so on -- neither of these assumptions have proven to be true. The panacea of packaged software may have changed things...but in my experience it has mostly been tool changes. And, OK, I guess it could be argued that my job is more system integrator than traditional DBA now...whatever the heck that is...but this has tended to be my role regardless of title I was given. ;-) Kip Bryant |There is another thing happening: companies are more and more relying on |canned, |off the shelf applications, in a hope to become compliant with present |standards. |That has dramatically cut down the number of needed developers, because if |you don't |have to develop your general ledger, payroll, CRM and HR software, you only |need |IT staffers to monitor production. |That is why I think that Jonathan Lewis is wrong in his Practical |Databases when he talks |about DBA being a repository of knowledge. No, the role of the DBA today |is the one |of a crane operator: just get the darned thing going, buddy. DBA is a |mechanic that |fixes database when it's slow, and that's it. The business role of IT is no |longer |to be at the forefront of the organization, but to keep thins running and do |what |business people tell them to do. Companies are no longer doing development |are leaving |cooking to the cooks and software development to the big software companies. |One of the reasons is also the culture clash among very well educated, |liberal and hippie |computer geeks and somewhat less educated old school drill sergeant type |managers who want |everybody to be at their desks at 7:30, cleanly shaven, no jeans, no surf |naked Dilbert |T-shirts or I am a DMCA circumvention device T-shirts. Basically, what I'm |noticing is |sort of returning to the roots cultural movement where business management |no longer |wants to tolerate the laid back IT culture. When cost cutting decisions are |made, IT people |are the 1st to go. They stil need DBA's because they'd better have somebody |monitoring |their multi-TB databases, but development is no longer necessary. IT |applications |are going to be as standardized as a stapler, so there is less and less need |for development. |Friends, we're dinosaurs, a dying breed. I'm considering a career of a |second |hand car salesman or a real estate agent. |-- |Mladen Gogala |Oracle DBA |-Original Message- |Stephane Paquette |Sent: Friday, August 22, 2003 10:29 AM |To: Multiple recipients of list ORACLE-L |That's why my post on historic tables and views seem lonely ;-) |Stephane |-Original Message- |Jared Still |Sent: Friday, August 22, 2003 2:19 AM |To: Multiple recipients of list ORACLE-L |Has anyone else noticed? |Not so long ago, we saw quite a few more questions about |such things as data modeling, application security architecture, physical |database design, and Oracle Designer |Not so much anymore. |Do you think it's because there are so few development projects taking |place? Seems like in house development died with the dot bomb and has not |begun to recover. |I know at my place of employment there is very little development, but that |is due more to the size and nature of this place, as |well as the management. ( they don't like in house development :( ) |Now I spend my days with stuff like making NetBackup work with Oracle, |migrating SAP all over the place and keeping things running. |Not that we haven't always done those things, but I miss some not having a |good development project. Ah, to do some real |data modeling again. |Just some food for thought. |Jared |-- |Please see the official ORACLE-L FAQ: http://www.orafaq.net |-- |Author: Jared Still | INET: [EMAIL PROTECTED] |Fat City Network Services-- 858-538-5051 http://www.fatcity.com |San Diego, California-- Mailing list and web hosting services |- |To REMOVE yourself from this mailing list, send an E-Mail message |to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the |message BODY, include a line containing: UNSUB ORACLE-L (or the name of |mailing list you want to be removed from). You may also send the HELP |command for other information (like subscribing). |-- |Please see the official ORACLE-L FAQ: http://www.orafaq.net |-- |Author: Stephane Paquette | INET: [EMAIL PROTECTED] |Fat City Network
RE: time/date granularity
Title: RE: time/date granularity if you are pre 9i you can get up to 100th of a second using dbms_utility.get_time(). in post 9i, you can use systimestamp which will give you a microsecond if you wish. Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- From: Josh Collier [mailto:[EMAIL PROTECTED]] Sent: Friday, August 22, 2003 1:20 PM To: Multiple recipients of list ORACLE-L Subject: time/date granularity Hi, Is there a way for me to get the time of a particular sysdate past the granularity of one second? Thanks! Josh -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Josh Collier INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). *This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*1
RE: OT:UNIX: Anyway to run this in the background and return to c
Title: RE:OT:UNIX: Anyway to run this in the background and return to calling process Never mind I got it. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]Sent: Friday, August 22, 2003 1:25 PMTo: Multiple recipients of list ORACLE-LSubject: RE:OT:UNIX: Anyway to run this in the background and return to ca $ORACLE_HOME/bin/sqlplus "/ as sysdba" EOD select .. exit EOD echo "this is a test" ps -ef|grep sqlplus I wish to put that into a unix command but at the same time run it in the background and return back to the parent script to do some other stuff? Anyone done this?
RE: time/date granularity
Sorry I left out the important thing: 9i rel 2. Thanks. -Original Message- Sent: Friday, August 22, 2003 10:29 AM To: Multiple recipients of list ORACLE-L Josh - Which Oracle version? I think 9i has provision for this. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, August 22, 2003 12:20 PM To: Multiple recipients of list ORACLE-L Hi, Is there a way for me to get the time of a particular sysdate past the granularity of one second? Thanks! Josh -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Josh Collier INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Josh Collier INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: time/date granularity
Title: RE: time/date granularity The issue at hand is this: There is a column, setup_date that is populated by a trigger with sysdate after insert. Now the developers want to know if there is a way they can get the time of this date to a granularity of 10ths or 100ths of a second. If I insert sysdate, can I then extract the centisecond or decisecond of that date/time? Make sense? Thanks -Original Message-From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED]Sent: Friday, August 22, 2003 10:30 AMTo: Multiple recipients of list ORACLE-LSubject: RE: time/date granularity if you are pre 9i you can get up to 100th of a second using dbms_utility.get_time(). in post 9i, you can use systimestamp which will give you a microsecond if you wish. Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- From: Josh Collier [mailto:[EMAIL PROTECTED]] Sent: Friday, August 22, 2003 1:20 PM To: Multiple recipients of list ORACLE-L Subject: time/date granularity Hi, Is there a way for me to get the time of a particular sysdate past the granularity of one second? Thanks! Josh -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Josh Collier INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OT:UNIX: Anyway to run this in the background and return to ca
Title: Message #!/usr/bin/perluse strict;use bytes;my $pid=0;if (!defined ($pid=fork())) { die "Problem with cutlery:$!\n"}elsif ($pid) { print "Do stuff here\n"; waitpid($pid,0); print "Cutlery is back\n"; }else { open(SPY,"ps -ef|grep sqlplus|"); while (SPY) { print;} } --Mladen GogalaOracle DBA -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED]Sent: Friday, August 22, 2003 1:25 PMTo: Multiple recipients of list ORACLE-LSubject: RE:OT:UNIX: Anyway to run this in the background and return to ca $ORACLE_HOME/bin/sqlplus "/ as sysdba" EOD select .. exit EOD echo "this is a test" ps -ef|grep sqlplus I wish to put that into a unix command but at the same time run it in the background and return back to the parent script to do some other stuff? Anyone done this? Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error,please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient.Wang Trading LLCand any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity.
RE: time/date granularity
Title: RE: time/date granularity Josh, sysdate has the granularity of a second only. You might want to add a new column for fractional seconds or change the column datatype to systimestamp; if you create new column, you can just add the fractional part as follows ... create or replace trigger ... after insert into my_table ... where ... begin :new.frac_seconds := to_char(systimestamp,'FFF'); end; / HTHS Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message-From: Josh Collier [mailto:[EMAIL PROTECTED]Sent: Friday, August 22, 2003 1:44 PMTo: Multiple recipients of list ORACLE-LSubject: RE: time/date granularity The issue at hand is this: There is a column, setup_date that is populated by a trigger with sysdate after insert. Now the developers want to know if there is a way they can get the time of this date to a granularity of 10ths or 100ths of a second. If I insert sysdate, can I then extract the centisecond or decisecond of that date/time? Make sense? Thanks -Original Message-From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED]Sent: Friday, August 22, 2003 10:30 AMTo: Multiple recipients of list ORACLE-LSubject: RE: time/date granularity if you are pre 9i you can get up to 100th of a second using dbms_utility.get_time(). in post 9i, you can use systimestamp which will give you a microsecond if you wish. Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- From: Josh Collier [mailto:[EMAIL PROTECTED]] Sent: Friday, August 22, 2003 1:20 PM To: Multiple recipients of list ORACLE-L Subject: time/date granularity Hi, Is there a way for me to get the time of a particular sysdate past the granularity of one second? Thanks! Josh -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Josh Collier INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*2
Re: time/date granularity
Title: RE: time/date granularity You can't even store sub second precision values in date datatype. Use timestamp instead (9i) or some custom format. In 8i you can have a java class which returns you date with high enough precision. Tanel. - Original Message - From: Josh Collier To: Multiple recipients of list ORACLE-L Sent: Friday, August 22, 2003 8:44 PM Subject: RE: time/date granularity The issue at hand is this: There is a column, setup_date that is populated by a trigger with sysdate after insert. Now the developers want to know if there is a way they can get the time of this date to a granularity of 10ths or 100ths of a second. If I insert sysdate, can I then extract the centisecond or decisecond of that date/time? Make sense? Thanks -Original Message-From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED]Sent: Friday, August 22, 2003 10:30 AMTo: Multiple recipients of list ORACLE-LSubject: RE: time/date granularity if you are pre 9i you can get up to 100th of a second using dbms_utility.get_time(). in post 9i, you can use systimestamp which will give you a microsecond if you wish. Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- From: Josh Collier [mailto:[EMAIL PROTECTED]] Sent: Friday, August 22, 2003 1:20 PM To: Multiple recipients of list ORACLE-L Subject: time/date granularity Hi, Is there a way for me to get the time of a particular sysdate past the granularity of one second? Thanks! Josh -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Josh Collier INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Kerberos OKINIT , OKLIST, ORA-12699
I'm trying to get Kerberos authentication to work. I am not using LDAP at all. I just want to authenticate with Kerberos. Kerberos itself is working fine. kinit and klist work as expected. I had our security admin create a service principle. Does there have to be one per machine or one per database? Does the service principle need to match the sql*net service name? When one issues okinit username what is the format of the username? No matter what I use okinit does not request a password and oklist shows no credentials. After configuring sqlnet.ora. I am testing now on the database machine itself any connects which employ that version fail with ora-12699 whether or not they are identified externally or via the database. Being old school, I don't like using aids such as netmgr. Nearly all these types of tools are awful when they first come out. But I tried to use them to setup Kerberos authentication. I save the network configuration, but when I go back into the tool nothing appears to be saved. Is this normal? Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Nature of Oracle-l has changed
I believe the mantra needs to be evolve and prosper, stagnate and die. I've been thinking along much the same lines. Jared Goulet, Dick [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 08/22/2003 09:09 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Nature of Oracle-l has changed OK, who let Chicken Little out of his room?? As someone at a location that is doing a lot of third party application buying, yes we in some ways are crane operators and mechanics. But then comes the fun of integrating the data from that new application into the remainder of the applications in place. 99% of the time these interactions, and reporting needs, are outside of the vendors scope of knowledge. SO who do you think gets the job? You guessed it, the DBA. Are we dinosaurs? Yes, if you don't open your eyes to other possibilities. I believe the mantra needs to be evolve and prosper, stagnate and die. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Friday, August 22, 2003 11:49 AM To: Multiple recipients of list ORACLE-L There is another thing happening: companies are more and more relying on canned, off the shelf applications, in a hope to become compliant with present standards. That has dramatically cut down the number of needed developers, because if you don't have to develop your general ledger, payroll, CRM and HR software, you only need IT staffers to monitor production. That is why I think that Jonathan Lewis is wrong in his Practical Databases when he talks about DBA being a repository of knowledge. No, the role of the DBA today is the one of a crane operator: just get the darned thing going, buddy. DBA is a mechanic that fixes database when it's slow, and that's it. The business role of IT is no longer to be at the forefront of the organization, but to keep thins running and do what business people tell them to do. Companies are no longer doing development are leaving cooking to the cooks and software development to the big software companies. One of the reasons is also the culture clash among very well educated, liberal and hippie computer geeks and somewhat less educated old school drill sergeant type managers who want everybody to be at their desks at 7:30, cleanly shaven, no jeans, no surf naked Dilbert T-shirts or I am a DMCA circumvention device T-shirts. Basically, what I'm noticing is sort of returning to the roots cultural movement where business management no longer wants to tolerate the laid back IT culture. When cost cutting decisions are made, IT people are the 1st to go. They stil need DBA's because they'd better have somebody monitoring their multi-TB databases, but development is no longer necessary. IT applications are going to be as standardized as a stapler, so there is less and less need for development. Friends, we're dinosaurs, a dying breed. I'm considering a career of a second hand car salesman or a real estate agent. -- Mladen Gogala Oracle DBA -Original Message- Stephane Paquette Sent: Friday, August 22, 2003 10:29 AM To: Multiple recipients of list ORACLE-L That's why my post on historic tables and views seem lonely ;-) Stephane -Original Message- Jared Still Sent: Friday, August 22, 2003 2:19 AM To: Multiple recipients of list ORACLE-L Has anyone else noticed? Not so long ago, we saw quite a few more questions about such things as data modeling, application security architecture, physical database design, and Oracle Designer Not so much anymore. Do you think it's because there are so few development projects taking place? Seems like in house development died with the dot bomb and has not begun to recover. I know at my place of employment there is very little development, but that is due more to the size and nature of this place, as well as the management. ( they don't like in house development :( ) Now I spend my days with stuff like making NetBackup work with Oracle, migrating SAP all over the place and keeping things running. Not that we haven't always done those things, but I miss some not having a good development project. Ah, to do some real data modeling again. Just some food for thought. Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ:
RE: (long) Design question, historic and views
Thanks for sharing. It may have been 'back in the 8.0 days', but is nonetheless a clever process. Streams and Logminer may be available now, but I like the elegance of the dual partition exchange. Jared Tanel Poder [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 08/22/2003 09:34 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: (long) Design question, historic and views Hi! To answer your original question about the design DW transport, there is too much to write to answer it completely. There's too many different ways to do the task. I'll try to give you a reply from my past experience with OLTP- DW transfer (from up to 800GB OLTP systems to 2-3TB DWs). 1) Let say we have a table EMP which we want to replicate to DW. 2) EMP has a monotonically increasing timestamp/sequence column for being able to put versions in order or enforce optimistic locking. 3) There is a trigger on EMP which duplicates rows to EMP2 table, based on our rules (insert/update/delete in our case) 4) EMP2 table is range partititioned table on timestamp column, with single partition. 5) When we decide to transfer changes to DW, we split the EMP2 table to 2 partitions, one partition with all current rows in EMP2 table, second partitions for all values from max(timestamp in EMP2)+1 .. MAXVALUE 6) We do exchange partitions with table EMP3 (all the rows in EMP2 first partition go to EMP3 table) 7) Now we can safely transport the changes to DW staging area without interrupting triggered inserts to EMP2 and without having to worry about whether any new rows were inserted into EMP2 meanwhile. 8) We drop partition 1 of EMP2 table, generating practically no redo, and leaving only the records inserted after split partition into EMP2. 9) And we start all over from step 5 again if want to transport next set of changes. Btw, if you write your trigger accordingly, you can just update the master table when new version arrives and let the trigger handle copying old version to EMP2 - no deletes are required. It could even be possible to write trigger to update only those columns in row which actually have changed, to reduce rollback and redo amount, but this will probably be harder on your CPU. Anyway if you do so, and your trigger gets fairly large, it might be reasonable to put the code in a package, pin it and call the package from trigger. It's matter of benchmarking. So, I just described a solution we used to you - this was back in 8.0 days, today there's a lot of other solutions like logminer/streams for example. Ok, that much from transporting. I don't quite get where do you want to place the views and what is their purpose? In your ODS? Or DW? Were you asking for a mean to distinguish between current and old versions? If in ODS you have your current and old version tables separate (EMP vs. EMP2) then there's no problems - all current versions are in EMP table. But in DW where all records are together you have two options (which first come into my mind): 1) Modify ETL process to update some column of future old record to set current=N when new record comes in. This means that you have to search update old current version of a record every time you insert a new version. 2) Do not modify ETL process at all, use timestamp column instead (timestamp/sqn is monotonically increasing column), so whichever record has larger sequence# is the current one. There are buts as well, for example if you want to keep deleted versions also in your DW, then you could update timestamp to 0 or similar. Also, depending on average number of versions, this might get quite slow if you aren't able to use indexes properly (should use ascending index range scan instead of sorting with large number of versions). I hope it was what you were asking about. This was my... erm... 3 cents (sync, sync, sync ;) Tanel.
RE: Kerberos OKINIT , OKLIST, ORA-12699
With kerberos, you shouldn't do identified externally, you should do identified globally. And yes, gooey tools are just for wimps. Real programmers use ed. -- Mladen Gogala Oracle DBA -Original Message- MacGregor, Ian A. Sent: Friday, August 22, 2003 3:14 PM To: Multiple recipients of list ORACLE-L I'm trying to get Kerberos authentication to work. I am not using LDAP at all. I just want to authenticate with Kerberos. Kerberos itself is working fine. kinit and klist work as expected. I had our security admin create a service principle. Does there have to be one per machine or one per database? Does the service principle need to match the sql*net service name? When one issues okinit username what is the format of the username? No matter what I use okinit does not request a password and oklist shows no credentials. After configuring sqlnet.ora. I am testing now on the database machine itself any connects which employ that version fail with ora-12699 whether or not they are identified externally or via the database. Being old school, I don't like using aids such as netmgr. Nearly all these types of tools are awful when they first come out. But I tried to use them to setup Kerberos authentication. I save the network configuration, but when I go back into the tool nothing appears to be saved. Is this normal? Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
ADMIN: Warning about virus threats this week
Hello everyone -- As you undoubtedly know, the Internet has been slammed this week and last week with mass mailings, intrusions, worms and viruses. More are on their way. Fat City has seen a huge increase in the number of spoofed messages coming into our systems. In fact, more than three times the normal load, and this could potentially cause some problems for all of our mailing lists. In order to mitigate this potential problem, I have decided to turn off many of the auto-repsonses that ListGuru sends. Because of the way viruses like SoBig and Klez spoof addresses, and because there are so many fatcity.com addresses in your address books and inboxes, this results in a large number of spoofed messages that ListGuru tries to reply to. Not only is that useless, but it's also annoying for those whose addresses have been spoofed. By shutting off those responses which aren't considered valid, this will reduce the amount of back and forth traffic between our servers and you. What this means to you is that unless you've sent a properly formatted request or command to ListGuru, you now will NOT get a response. If you are a subscriber to a list and you try to post, but your posting address has changed, you will NOT be told that your address needs changed. Etc. Instead, auto-responses like these will be thrown away and your messages, effectively, ignored. I know this sounds rather rude ;-), but I assure you, the intent is not to be rude at all -- it is to reduce the amount of E-mail traffic being sent to the net by these viruses. I apologize in advance if this causes any problems or confusion for anyone. If you have any questions or concerns about whether your mail was received okay here or your subscription is working, please contact me directly. I expect that these measures will be needed for the next few weeks, but after that I will return ListGuru's functionality to normal. Please bear with us during the intervening weeks. Thank you! Bruce A. Bergman ListMaster, Fat City Hosting -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bruce A. Bergman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RE: Nature of Oracle-l has changed
Well, I wanted to add my .2 Cents here. Custom development projects have shrunk over the past year because companies are tired of the maintenance issues associated with custom applications. More organizations are shifting their efforts towards implementing canned solutions and taking the bite, as Dick indicates, of modifying either the business or the applications to complement the opposite. Custom application development seems to be occurring only where a canned application is either not available or does not match the true requirements. Now on the downside, everyone seems to think that shifting development via an outsourced model, especially overseas, is going to same LOTS of money. I wish some of these people would read Information Week or other magazines to fully understand the increase in cost Outsourced development efforts create. I can say that we (Compuware) are seeing more outsourcing transfer to in-house projects because of quality or time to delivery issues. As a caveat, development within the US is shifting from one region to another and is dependent on tax breaks, etc. that governments offer companies to move. Food for thought: Stay liquid and flexible. Thank You Stephen P. Karniotis Technical Alliance Manager Compuware Corporation Direct: (313) 227-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web:www.compuware.com -Original Message- Sent: Friday, August 22, 2003 1:25 PM To: Multiple recipients of list ORACLE-L There is another problem with canned applications. The damanagement has to make a choice to either bend the business to match the application of bend the application to match the business. From my point of view, the latter is happening more than the former. Also, as a side note, I believe the list's tone has changed as companies are trying to find cheaper solutions to their database needs. Although in the end run Sql*Server and DB2 come out close to Oracle in cost, they hide most of the added stuff as either third party applications or else unmentioned extras that you'll need. Oracle just bundles it all up front making then look more expensive than the others. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Friday, August 22, 2003 12:59 PM To: Multiple recipients of list ORACLE-L Mladen, There is another thing happening: companies are more and more relying on canned, off the shelf applications, in a hope to become compliant with present standards. That has dramatically cut down the number of needed developers, because if you don't have to develop your general ledger, payroll, CRM and HR software, you only need IT staffers to monitor production. Granted for these functions, which are rarely at the core of your business. However, by turning to canned applications for everything, firms are doing nothing that turning themselves into commodities - the road to bust for those unable to sustain a price war. And most canned applications of some breadth seem to require a degree of 'parameterization' which demands teams often bigger (and more expensive) than yesterday's in-house development teams. Interestingly, the amount of data which everybody is storing seems to outpace Moore's law by a comfortable factor. Which, if nothing else, proves that the payroll and HR software is not where the action is. They stil need DBA's because they'd better have somebody monitoring their multi-TB databases, but development is no longer necessary. Wait for 10G, which takes care of itself :-). Stephane Faroult Oriole -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Goulet, Dick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). The contents of this e-mail are intended for the named addressee only. It contains information that may be
RE: (long) Design question, historic and views
Hi, Thanks for the info. Our site is way smaller, the ODS will be around 30G of raw data. So partitionning is out of the question here (I've used the one partition table trick to use the exchange feature before on a bigger db). Management is even considering DB2 for all the BI initiatives since the IBM reps are almost giving it for free. So the cost makes the partitionning option not being considered. We will use an ETL tool to copy data from the sources to the ODS. I'm not sure what will be done by the database and by the ETL tool. I'll probably go with the 1 table containing current and old versions approach. For the view part, in the case where the old and current versions are in the same table, the views are there to simplify the queries. It should be easy to query the data, can not rely on using the maximum key and sort at each access, those tables will be accessed by end-users via the internet. From experience, I prefer the query part to be easy to work with and the loads can be less easy as no users are waiting on it. Stephane -Original Message- Tanel Poder Sent: Friday, August 22, 2003 12:34 PM To: Multiple recipients of list ORACLE-L Hi! To answer your original question about the design DW transport, there is too much to write to answer it completely. There's too many different ways to do the task. I'll try to give you a reply from my past experience with OLTP- DW transfer (from up to 800GB OLTP systems to 2-3TB DWs). 1) Let say we have a table EMP which we want to replicate to DW. 2) EMP has a monotonically increasing timestamp/sequence column for being able to put versions in order or enforce optimistic locking. 3) There is a trigger on EMP which duplicates rows to EMP2 table, based on our rules (insert/update/delete in our case) 4) EMP2 table is range partititioned table on timestamp column, with single partition. 5) When we decide to transfer changes to DW, we split the EMP2 table to 2 partitions, one partition with all current rows in EMP2 table, second partitions for all values from max(timestamp in EMP2)+1 .. MAXVALUE 6) We do exchange partitions with table EMP3 (all the rows in EMP2 first partition go to EMP3 table) 7) Now we can safely transport the changes to DW staging area without interrupting triggered inserts to EMP2 and without having to worry about whether any new rows were inserted into EMP2 meanwhile. 8) We drop partition 1 of EMP2 table, generating practically no redo, and leaving only the records inserted after split partition into EMP2. 9) And we start all over from step 5 again if want to transport next set of changes. Btw, if you write your trigger accordingly, you can just update the master table when new version arrives and let the trigger handle copying old version to EMP2 - no deletes are required. It could even be possible to write trigger to update only those columns in row which actually have changed, to reduce rollback and redo amount, but this will probably be harder on your CPU. Anyway if you do so, and your trigger gets fairly large, it might be reasonable to put the code in a package, pin it and call the package from trigger. It's matter of benchmarking. So, I just described a solution we used to you - this was back in 8.0 days, today there's a lot of other solutions like logminer/streams for example. Ok, that much from transporting. I don't quite get where do you want to place the views and what is their purpose? In your ODS? Or DW? Were you asking for a mean to distinguish between current and old versions? If in ODS you have your current and old version tables separate (EMP vs. EMP2) then there's no problems - all current versions are in EMP table. But in DW where all records are together you have two options (which first come into my mind): 1) Modify ETL process to update some column of future old record to set current=N when new record comes in. This means that you have to search update old current version of a record every time you insert a new version. 2) Do not modify ETL process at all, use timestamp column instead (timestamp/sqn is monotonically increasing column), so whichever record has larger sequence# is the current one. There are buts as well, for example if you want to keep deleted versions also in your DW, then you could update timestamp to 0 or similar. Also, depending on average number of versions, this might get quite slow if you aren't able to use indexes properly (should use ascending index range scan instead of sorting with large number of versions). I hope it was what you were asking about. This was my... erm... 3 cents (sync, sync, sync ;) Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, August 22, 2003 5:29 PM That's why my post on historic tables and views seem lonely ;-) Stephane -Original Message- Jared Still Sent: Friday, August 22, 2003 2:19 AM To: Multiple recipients of list ORACLE-L Has anyone else noticed? Not so
SharePlex info
Title: Message You are correct in the first place. SharePlex works as you describe, it mines the log and sends only the absolute minimum to reassemble the transaction on the target. It doesn't send SQL. The target side processes take the data and rebuild a SQL statement from the DDL definitions it got from the data dictionaries of the source and target (just in case you only want a subset of the columns.) Sorry if I confused you. Tony -Original Message-From: Gorbounov,Vadim [mailto:[EMAIL PROTECTED]Sent: Thursday, August 21, 2003 5:01 PMTo: Aponte, TonySubject: RE: SharePlex info Tony, My question was inspired by belief that SharePlex does log mining on the source DB and hence do not send unnecessary data over the network. Apparently, this is not the case. I didn't want to compare SharePlex to logical standby cause I know that logical standby definitely needs all logs transported to the target site where is does log mining. We considering remote disaster recovery site where we want to have working data and we don't care much about "log" tables. Thank you for valuable info. -Original Message-From: Aponte, Tony [mailto:[EMAIL PROTECTED]Sent: Thursday, August 21, 2003 4:40 PMTo: [EMAIL PROTECTED]Cc: [EMAIL PROTECTED]Subject: RE: SharePlex info Your bandwidth requirements will be the rate of changes to the actual data. The traffic consists of the actual data and control information needed to reassemble the transaction on the target. The source database's other redo payload (i.e., index operations, rollback segment maintenance, etc.) is not used by Shareplex. In our environment of dual Sun 6800's, 10 CPU's each, we observe less that 1% CPU consumption on the source and target sides combined. It varies according to the DML load on the source but not by much. We've never had a problem with it consuming a noticeable amount. I have a question on the comparison between a physical standby and Shareplex replication.Isn't9i's logical standby featurebetter suited for the comparison to Shareplex? I'm assuming that you are considering offloading some processing to another host since you are looking to replicate about 50% of the tables in the source database. HTH Tony Aponte -Original Message-From: Gorbounov,Vadim [mailto:[EMAIL PROTECTED]Sent: Thursday, August 21, 2003 1:49 PMTo: Multiple recipients of list ORACLE-LSubject: SharePlex info Hi All, I'm trying to find some technical details about SharePlex, that is: - How much network bandwidth I'd expect to replicate from database, generating 1-5 MB/sec redo. DoesSharePlex send SQL text over the network or data in some internal (hopefully compressed)format - How much CPU on the source DB server side would it cost - just a ball park - very little- little - or a lot - Of two options, using 9.2 physical async standby db and clone whole database vs replicate 50% (enough from business requirements) of tables using SharePlex, which onesounds preferrable keeping in mind minimizing CPU burden on the source database. Any opinion or pointer to any benchmark is highly appreciated. Thanks a lot Vadim
RE: Forms - as sysdba
Hi Bruce, this is EXACTLY what I needed, great! Many thanks =RP= Hi I don't have 9i to test, but I believe you might be able to set O7_DICTIONARY_ACCESSIBILITY = TRUE in init.ora and then you should be able to connect as sys without specifying sysdba. This might be suitable for the upgrade - certainly test it out on a test system first. Regarding the upgrade - why exactly does it need to be connected as sys - eg what doesn't work if you connect as system. HTH, Bruce Reardon -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Robo INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OT:UNIX: Anyway to run this in the background and return to c
Title: Message Thanks, Hmmm perl... Well, I came up with a loop using while and a ps -ef|grep $pid command but this looks interesting. -Original Message-From: Mladen Gogala [mailto:[EMAIL PROTECTED]Sent: Friday, August 22, 2003 2:04 PMTo: Multiple recipients of list ORACLE-LSubject: RE: OT:UNIX: Anyway to run this in the background and return to ca #!/usr/bin/perluse strict;use bytes;my $pid=0;if (!defined ($pid=fork())) { die "Problem with cutlery:$!\n"}elsif ($pid) { print "Do stuff here\n"; waitpid($pid,0); print "Cutlery is back\n"; }else { open(SPY,"ps -ef|grep sqlplus|"); while (SPY) { print;} } --Mladen GogalaOracle DBA -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED]Sent: Friday, August 22, 2003 1:25 PMTo: Multiple recipients of list ORACLE-LSubject: RE:OT:UNIX: Anyway to run this in the background and return to ca $ORACLE_HOME/bin/sqlplus "/ as sysdba" EOD select .. exit EOD echo "this is a test" ps -ef|grep sqlplus I wish to put that into a unix command but at the same time run it in the background and return back to the parent script to do some other stuff? Anyone done this? Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error,please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient.Wang Trading LLCand any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity.
convert number to word ???
Hi, Is there a function that can conver number to word? ef: 100 is ONE HUNDRED, 2003 is TWO THOUSAND AND THREE. Thank you in advanced!!! __ Do you Yahoo!? Yahoo! Calendar - Free online calendar with sync to Outlook(TM). http://calendar.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Andrea Oracle INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Nature of Oracle-l has changed
Title: Message I'm planning on doing #4 next fall. Look out Mississippi State, here I come! Kevin Toepke -Original Message-From: Odland, Brad [mailto:[EMAIL PROTECTED] Sent: Friday, August 22, 2003 5:14 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Nature of Oracle-l has changed Evolve and prosper may mean leavingIT work Here are some other possibilities: 1. Open your own pub 2. Become a carney - (Hard work but you get to party ALL THE TIME) 3. Enter Damagement (If you like that) 4. Go back to school (Art, theology, history, science use your gifted brain for something other than crappy canned software that noone gives a rat's a** about) 5. Sell everything and go overseas and work with an aid agency...(die poor but rich in so many ways) 6. Write that novel you have dreamed about(you know the one where the DBAreveals thetruth bihind the 9/11conspiracy based on data hidden in the archive logs found on a tape in a box in theCIA during a systems upgrade...WAIT get your own idea..!!) -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]Sent: Friday, August 22, 2003 2:09 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Nature of Oracle-l has changed I believe the mantra needs to be "evolve and prosper, stagnate and die". I've been thinking along much the same lines. Jared "Goulet, Dick" [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 08/22/2003 09:09 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Nature of Oracle-l has changedOK, who let "Chicken Little" out of his room?? As someone at a location that is doing a lot of third party application buying, yes we in some ways are crane operators and mechanics. But then comes the fun of integrating the data from that new application into the remainder of the applications in place. 99% of the time these interactions, and reporting needs, are outside of the vendors scope of knowledge. SO who do you think gets the job? You guessed it, the DBA. Are we dinosaurs? Yes, if you don't open your eyes to other possibilities. I believe the mantra needs to be "evolve and prosper, stagnate and die".Dick GouletSenior Oracle DBAOracle Certified 8i DBA-Original Message-Sent: Friday, August 22, 2003 11:49 AMTo: Multiple recipients of list ORACLE-LThere is another thing happening: companies are more and more relying oncanned, off the shelf applications, in a hope to become "compliant with presentstandards".That has dramatically cut down the number of needed developers, because ifyou don'thave to develop your general ledger, payroll, CRM and HR software, you onlyneed IT staffers to monitor production. That is why I think that Jonathan Lewis is wrong in his "PracticalDatabases" when he talksabout "DBA being a repository of knowledge". No, the role of the DBA todayis the oneof a crane operator: "just get the darned thing going, buddy". DBA is amechanic thatfixes database when it's slow, and that's it. The business role of IT is nolonger to be at the forefront of the organization, but to keep thins running and dowhatbusiness people tell them to do. Companies are no longer doing developmentare leavingcooking to the cooks and software development to the big software companies.One of the reasons is also the culture clash among very well educated,liberal and hippiecomputer geeks and somewhat less educated "old school" drill sergeant typemanagers who want everybody to be at their desks at 7:30, cleanly shaven, no jeans, no "surfnaked" Dilbert T-shirts or "I am a DMCA circumvention device" T-shirts. Basically, what I'mnoticing issort of "returning to the roots" cultural movement where business managementno longerwants to tolerate the laid back IT culture. When cost cutting decisions aremade, IT peopleare the 1st to go. They stil need DBA's because they'd better have somebodymonitoringtheir multi-TB databases, but development is no longer necessary. ITapplicationsare going to be as standardized as a stapler, so there is less and less needfor development.Friends, we're dinosaurs, a dying breed. I'm considering a career of asecond hand car salesman or a real estate agent.--Mladen GogalaOracle DBA -Original Message-Stephane PaquetteSent: Friday, August 22, 2003 10:29 AMTo: Multiple recipients of list ORACLE-LThat's why my post on historic tables and views seem lonely ;-)Stephane-Original Message-Jared StillSent: Friday,
RE: Nature of Oracle-l has changed
We are in the middle of a development revolution here. It is being driven by a desire to allow greater access to the Peoplesoft databases. The Peoplesoft folks want to continue using those tools. But the folks that are responsible for the application server which will connect to Psoft want to use Web Logic or possibly .net. As we are considering J2EE environments, I've asked them to consider Jbuilder, Jdeveloper, and IBM's WebSphere stuff. It will be interesting to see how this plays out. There is a sect who wants whatever is chosen to be the sole development platform here. Ian -Original Message- Sent: Thursday, August 21, 2003 11:19 PM To: Multiple recipients of list ORACLE-L Has anyone else noticed? Not so long ago, we saw quite a few more questions about such things as data modeling, application security architecture, physical database design, and Oracle Designer Not so much anymore. Do you think it's because there are so few development projects taking place? Seems like in house development died with the dot bomb and has not begun to recover. I know at my place of employment there is very little development, but that is due more to the size and nature of this place, as well as the management. ( they don't like in house development :( ) Now I spend my days with stuff like making NetBackup work with Oracle, migrating SAP all over the place and keeping things running. Not that we haven't always done those things, but I miss some not having a good development project. Ah, to do some real data modeling again. Just some food for thought. Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: ADMIN: Warning about virus threats this week
Thanks for staying on top of this Bruce. Jared Bruce A. Bergman [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 08/22/2003 12:39 PM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:ADMIN: Warning about virus threats this week Hello everyone -- As you undoubtedly know, the Internet has been slammed this week and last week with mass mailings, intrusions, worms and viruses. More are on their way. Fat City has seen a huge increase in the number of spoofed messages coming into our systems. In fact, more than three times the normal load, and this could potentially cause some problems for all of our mailing lists. In order to mitigate this potential problem, I have decided to turn off many of the auto-repsonses that ListGuru sends. Because of the way viruses like SoBig and Klez spoof addresses, and because there are so many fatcity.com addresses in your address books and inboxes, this results in a large number of spoofed messages that ListGuru tries to reply to. Not only is that useless, but it's also annoying for those whose addresses have been spoofed. By shutting off those responses which aren't considered valid, this will reduce the amount of back and forth traffic between our servers and you. What this means to you is that unless you've sent a properly formatted request or command to ListGuru, you now will NOT get a response. If you are a subscriber to a list and you try to post, but your posting address has changed, you will NOT be told that your address needs changed. Etc. Instead, auto-responses like these will be thrown away and your messages, effectively, ignored. I know this sounds rather rude ;-), but I assure you, the intent is not to be rude at all -- it is to reduce the amount of E-mail traffic being sent to the net by these viruses. I apologize in advance if this causes any problems or confusion for anyone. If you have any questions or concerns about whether your mail was received okay here or your subscription is working, please contact me directly. I expect that these measures will be needed for the next few weeks, but after that I will return ListGuru's functionality to normal. Please bear with us during the intervening weeks. Thank you! Bruce A. Bergman ListMaster, Fat City Hosting -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bruce A. Bergman INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OT:UNIX: Anyway to run this in the background and return to ca
Title: Message Errrm -this script doesn't dowhat I think you're trying to do.Perl starts, it forks a child process, the parent process "does abunch of stuff", but the child process only runs ps once. S, you end up with azombie child process (until the parent is donewith its business)and a parent process that is doing all the work. A better solution would be to reverse the ps and the "doing stuff". Let the child process do the dirty work and let the parent focus on either generating more children or status monitoring the existing children. You could use a loop that watches for the existence of a particular pid or has a set condition and add a SIGCHLD handler that will handle cleanup of the child and remove the loop condition. Thanks, Matt --Matthew ZitoGridApp SystemsEmail: [EMAIL PROTECTED]Cell: 646-220-3551Phone: 212-358-8211 x 359http://www.gridapp.com -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mladen GogalaSent: Friday, August 22, 2003 2:04 PMTo: Multiple recipients of list ORACLE-LSubject: RE: OT:UNIX: Anyway to run this in the background and return to ca #!/usr/bin/perluse strict;use bytes;my $pid=0;if (!defined ($pid=fork())) { die "Problem with cutlery:$!\n"}elsif ($pid) { print "Do stuff here\n"; waitpid($pid,0); print "Cutlery is back\n"; }else { open(SPY,"ps -ef|grep sqlplus|"); while (SPY) { print;} } --Mladen GogalaOracle DBA -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED]Sent: Friday, August 22, 2003 1:25 PMTo: Multiple recipients of list ORACLE-LSubject: RE:OT:UNIX: Anyway to run this in the background and return to ca $ORACLE_HOME/bin/sqlplus "/ as sysdba" EOD select .. exit EOD echo "this is a test" ps -ef|grep sqlplus I wish to put that into a unix command but at the same time run it in the background and return back to the parent script to do some other stuff? Anyone done this? Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error,please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient.Wang Trading LLCand any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity.
Re: convert number to word ???
some where I got this create or replace function spell_number( p_number in number ) return varchar2 as type myArray is table of varchar2(255); l_str myArray := myArray( '', ' thousand ', ' million ', ' billion ', ' trillion ', ' quadrillion ', ' quintillion ', ' sextillion ', ' septillion ', ' octillion ', ' nonillion ', ' decillion ', ' undecillion ', ' duodecillion ' ); l_num varchar2(50) default trunc( p_number ); l_return varchar2(4000); begin for i in 1 .. l_str.count loop exit when l_num is null; if ( substr(l_num, length(l_num)-2, 3) 0 ) then l_return := to_char( to_date(substr(l_num, length(l_num)-2, 3),'J' ), 'Jsp' ) || l_str(i) || l_return; end if; l_num := substr( l_num, 1, length(l_num)-3 ); end loop; return l_return; end; / SQL select 2 spell_number( 12345678901234567890123456789012345678 ) 3 from dual; SPELL_NUMBER(1234567890123456789012345678901234567 -- Twelve undecillion Three Hundred Forty-Five decill ion Six Hundred Seventy-Eight nonillion Nine Hundr ed One octillion Two Hundred Thirty-Four septillio n Five Hundred Sixty-Seven sextillion Eight Hundre d Ninety quintillion One Hundred Twenty-Three quad rillion Four Hundred Fifty-Six trillion Seven Hund red Eighty-Nine billion Twelve million Three Hundr ed Forty-Five thousand Six Hundred Seventy-Eight a-k - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, August 22, 2003 2:19 PM Hi, Is there a function that can conver number to word? ef: 100 is ONE HUNDRED, 2003 is TWO THOUSAND AND THREE. Thank you in advanced!!! __ Do you Yahoo!? Yahoo! Calendar - Free online calendar with sync to Outlook(TM). http://calendar.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Andrea Oracle INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: AK INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OT:UNIX: Anyway to run this in the background and return to ca
Title: Message No, I just wanted to demonstrate thefork mechanism in perl. The proper way to handle stuff would be to call exit at the end of the child process, which would clean things up properly and not leave za zombie lying around. And yes, "ps -ef" is executed only once, when the SPY handle is open. --Mladen GogalaOracle DBA -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Matthew ZitoSent: Friday, August 22, 2003 5:45 PMTo: Multiple recipients of list ORACLE-LSubject: RE: OT:UNIX: Anyway to run this in the background and return to ca Errrm -this script doesn't dowhat I think you're trying to do.Perl starts, it forks a child process, the parent process "does abunch of stuff", but the child process only runs ps once. S, you end up with azombie child process (until the parent is donewith its business)and a parent process that is doing all the work. A better solution would be to reverse the ps and the "doing stuff". Let the child process do the dirty work and let the parent focus on either generating more children or status monitoring the existing children. You could use a loop that watches for the existence of a particular pid or has a set condition and add a SIGCHLD handler that will handle cleanup of the child and remove the loop condition. Thanks, Matt --Matthew ZitoGridApp SystemsEmail: [EMAIL PROTECTED]Cell: 646-220-3551Phone: 212-358-8211 x 359http://www.gridapp.com -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mladen GogalaSent: Friday, August 22, 2003 2:04 PMTo: Multiple recipients of list ORACLE-LSubject: RE: OT:UNIX: Anyway to run this in the background and return to ca #!/usr/bin/perluse strict;use bytes;my $pid=0;if (!defined ($pid=fork())) { die "Problem with cutlery:$!\n"}elsif ($pid) { print "Do stuff here\n"; waitpid($pid,0); print "Cutlery is back\n"; }else { open(SPY,"ps -ef|grep sqlplus|"); while (SPY) { print;} } --Mladen GogalaOracle DBA -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED]Sent: Friday, August 22, 2003 1:25 PMTo: Multiple recipients of list ORACLE-LSubject: RE:OT:UNIX: Anyway to run this in the background and return to ca $ORACLE_HOME/bin/sqlplus "/ as sysdba" EOD select .. exit EOD echo "this is a test" ps -ef|grep sqlplus I wish to put that into a unix command but at the same time run it in the background and return back to the parent script to do some other stuff? Anyone done this? Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error,please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient.Wang Trading LLCand any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error,please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient.Wang Trading LLCand any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity.
RE: Kerberos OKINIT , OKLIST, ORA-12699
I'm using externally because I am not using a directory service. Ian -Original Message- Sent: Friday, August 22, 2003 12:42 PM To: Multiple recipients of list ORACLE-L With kerberos, you shouldn't do identified externally, you should do identified globally. And yes, gooey tools are just for wimps. Real programmers use ed. -- Mladen Gogala Oracle DBA -Original Message- MacGregor, Ian A. Sent: Friday, August 22, 2003 3:14 PM To: Multiple recipients of list ORACLE-L I'm trying to get Kerberos authentication to work. I am not using LDAP at all. I just want to authenticate with Kerberos. Kerberos itself is working fine. kinit and klist work as expected. I had our security admin create a service principle. Does there have to be one per machine or one per database? Does the service principle need to match the sql*net service name? When one issues okinit username what is the format of the username? No matter what I use okinit does not request a password and oklist shows no credentials. After configuring sqlnet.ora. I am testing now on the database machine itself any connects which employ that version fail with ora-12699 whether or not they are identified externally or via the database. Being old school, I don't like using aids such as netmgr. Nearly all these types of tools are awful when they first come out. But I tried to use them to setup Kerberos authentication. I save the network configuration, but when I go back into the tool nothing appears to be saved. Is this normal? Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: convert number to word ???
You can find perl module doing that at: http://www.bayview.com/software/perl.shtml -- Mladen Gogala Oracle DBA -Original Message- Andrea Oracle Sent: Friday, August 22, 2003 5:19 PM To: Multiple recipients of list ORACLE-L Hi, Is there a function that can conver number to word? ef: 100 is ONE HUNDRED, 2003 is TWO THOUSAND AND THREE. Thank you in advanced!!! __ Do you Yahoo!? Yahoo! Calendar - Free online calendar with sync to Outlook(TM). http://calendar.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Andrea Oracle INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: convert number to word ???
I got this off of metalink: select to_char( to_date( 1, 'J' ), 'jsp' ) from dual; SQLselect to_char( to_date( 123,'J'), 'jsp') from dual; TO_CHAR(TO_DATE(123,'J') -- one hundred twenty-three SQLselect to_char( to_date( 123,'J'), 'Jsp') from dual; TO_CHAR(TO_DATE(123,'J') -- One Hundred Twenty-Three SQLselect to_char( to_date( 123,'J'), 'JSP') from dual; TO_CHAR(TO_DATE(123,'J') -- ONE HUNDRED TWENTY-THREE I suspect there is an upper limit imposed by some integer conversion or julian date thingy... Shannon Shannon St. DennisDatabase AdministratorCity of Regina(306) 777-7415 (phone)(306) 777-6804 (fax)[EMAIL PROTECTED] The degree of normality in a database is inversely proportional to that of its DBA [EMAIL PROTECTED] 08/22/03 03:19pm Hi,Is there a function that can conver number to word? ef: 100 is ONE HUNDRED, 2003 is TWO THOUSAND ANDTHREE. Thank you in advanced!!!__Do you Yahoo!?Yahoo! Calendar - Free online calendar with sync to Outlook(TM).http://calendar.yahoo.com-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Andrea Oracle INET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
Re: convert number to word ???
SELECT TO_CHAR(TO_DATE(2003,'J'),'JSP') FROM DUAL; TO_CHAR(TO_DATE(20 -- TWO THOUSAND THREE - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, August 22, 2003 4:19 PM Hi, Is there a function that can conver number to word? ef: 100 is ONE HUNDRED, 2003 is TWO THOUSAND AND THREE. Thank you in advanced!!! __ Do you Yahoo!? Yahoo! Calendar - Free online calendar with sync to Outlook(TM). http://calendar.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Andrea Oracle INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Oracle-L INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OT:UNIX: Anyway to run this in the background and return to ca
Title: Message Oh, I see - okay, I just misunderstood what was being demonstrated. You can't simply call exit at the end of a child execution, however - you must either terminate the parent process or call wait(), waitpid(), etc. exit() will leave a zombie until the parent waits() for a cleanup. The easiest way to do that is to add a SIGCHLD handler that calls wait when the signal is raised. Thanks, Matt --Matthew ZitoGridApp SystemsEmail: [EMAIL PROTECTED]Cell: 646-220-3551Phone: 212-358-8211 x 359http://www.gridapp.com -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mladen GogalaSent: Friday, August 22, 2003 6:14 PMTo: Multiple recipients of list ORACLE-LSubject: RE: OT:UNIX: Anyway to run this in the background and return to ca No, I just wanted to demonstrate thefork mechanism in perl. The proper way to handle stuff would be to call exit at the end of the child process, which would clean things up properly and not leave za zombie lying around. And yes, "ps -ef" is executed only once, when the SPY handle is open. --Mladen GogalaOracle DBA -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Matthew ZitoSent: Friday, August 22, 2003 5:45 PMTo: Multiple recipients of list ORACLE-LSubject: RE: OT:UNIX: Anyway to run this in the background and return to ca Errrm -this script doesn't dowhat I think you're trying to do.Perl starts, it forks a child process, the parent process "does abunch of stuff", but the child process only runs ps once. S, you end up with azombie child process (until the parent is donewith its business)and a parent process that is doing all the work. A better solution would be to reverse the ps and the "doing stuff". Let the child process do the dirty work and let the parent focus on either generating more children or status monitoring the existing children. You could use a loop that watches for the existence of a particular pid or has a set condition and add a SIGCHLD handler that will handle cleanup of the child and remove the loop condition. Thanks, Matt --Matthew ZitoGridApp SystemsEmail: [EMAIL PROTECTED]Cell: 646-220-3551Phone: 212-358-8211 x 359http://www.gridapp.com -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mladen GogalaSent: Friday, August 22, 2003 2:04 PMTo: Multiple recipients of list ORACLE-LSubject: RE: OT:UNIX: Anyway to run this in the background and return to ca #!/usr/bin/perluse strict;use bytes;my $pid=0;if (!defined ($pid=fork())) { die "Problem with cutlery:$!\n"}elsif ($pid) { print "Do stuff here\n"; waitpid($pid,0); print "Cutlery is back\n"; }else { open(SPY,"ps -ef|grep sqlplus|"); while (SPY) { print;} } --Mladen GogalaOracle DBA -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED]Sent: Friday, August 22, 2003 1:25 PMTo: Multiple recipients of list ORACLE-LSubject: RE:OT:UNIX: Anyway to run this in the background and return to ca $ORACLE_HOME/bin/sqlplus "/ as sysdba" EOD select .. exit EOD echo "this is a test" ps -ef|grep sqlplus I wish to put that into a unix command but at the same time run it in the background and return back to the parent script to do some other stuff? Anyone done this? Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error,please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient.Wang Trading LLCand any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error,please immediately delete it and
Re: ADMIN: Warning about virus threats this week
I think its a GREAT IDEA! Thank you for maintaining this list and keeping it virus free, well almost :). Other lists, I belong to are slamming me w/ the SOBig virus. Gene [EMAIL PROTECTED] 08/22/03 03:39PM Hello everyone --As you undoubtedly know, the Internet has been slammed this week and last week with mass mailings, intrusions, worms and viruses. More are on their way. Fat City has seen a huge increase in the number of spoofed messages coming into our systems. In fact, more than three times the normal load, and this could potentially cause some problems for all of our mailing lists.In order to mitigate this potential problem, I have decided to turn off many of the auto-repsonses that ListGuru sends. Because of the way viruses like SoBig and Klez spoof addresses, and because there are so many fatcity.com addresses in your address books and inboxes, this results in a large number of spoofed messages that ListGuru tries to reply to. Not only is that useless, but it's also annoying for those whose addresses have been spoofed. By shutting off those responses which aren't considered valid, this will reduce the amount of back and forth traffic between our servers and you.What this means to you is that unless you've sent a properly formatted request or command to ListGuru, you now will NOT get a response. If you are a subscriber to a list and you try to post, but your posting address has changed, you will NOT be told that your address needs changed. Etc. Instead, auto-responses like these will be thrown away and your messages, effectively, ignored. I know this sounds rather "rude" ;-), but I assure you, the intent is not to be rude at all -- it is to reduce the amount of E-mail traffic being sent to the net by these viruses.I apologize in advance if this causes any problems or confusion for anyone. If you have any questions or concerns about whether your mail was received okay here or your subscription is working, please contact me directly. I expect that these measures will be needed for the next few weeks, but after that I will return ListGuru's functionality to normal. Please bear with us during the intervening weeks.Thank you!Bruce A. BergmanListMaster, Fat City Hosting-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Bruce A. Bergman INET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
Re: ADMIN: Warning about virus threats this week
Bruce A. Bergman wrote: Hello everyone -- As you undoubtedly know, the Internet has been slammed this week and last week with mass mailings, intrusions, worms and viruses. More are on their way. Fat City has seen a huge increase in the number of spoofed messages coming into our systems. In fact, more than three times the normal load, and this could potentially cause some problems for all of our mailing lists. In order to mitigate this potential problem, I have decided to turn off many of the auto-repsonses that ListGuru sends. Because of the way viruses like SoBig and Klez spoof addresses, and because there are so many fatcity.com addresses in your address books and inboxes, this results in a large number of spoofed messages that ListGuru tries to reply to. Not only is that useless, but it's also annoying for those whose addresses have been spoofed. By shutting off those responses which aren't considered valid, this will reduce the amount of back and forth traffic between our servers and you. This is very much appreciated. I can filter the actual worms out, but I'm getting walloped by responses to spoofed worm emails. It's nice to know there's at least one place deliberately not sending them. Thanks, Scott Lamb -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Scott Lamb INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle World anyone?
All, I having taken on co-ordinating the Oracle-l listers get-together at OOW this year (Sep 7-11). So far, I have Jonathan Gennick, Matt Adams, Brian McGraw, Gerardo Molina and self. If any of you are considering a visit to the Bay area at that time - OOW or otherwise - you are welcome to attend. I will send out another invite closer to that time. John Kanagaraj -Original Message- Sent: Thursday, August 14, 2003 8:14 PM To: Multiple recipients of list ORACLE-L And there will be a bunch of us 'Silicon Valley' types who can arrange a get-together for ORACLE-L members. The rowdy bunch that got together last year nearly tore up the Restaurant, btw John Kanagaraj Oracle Applications DBA DB Soft Inc Work : (408) 970 7002 Listen to great, commercial-free christian music 24x7x365 at http://www.klove.com ** The opinions and facts contained in this message are entirely mine and do not reflect those of my employer or customers ** -Original Message- From: Jonathan Gennick [mailto:[EMAIL PROTECTED] Sent: Thursday, August 14, 2003 7:29 PM To: Multiple recipients of list ORACLE-L Subject: Re: Oracle World anyone? Thursday, August 14, 2003, 9:24:29 PM, you wrote: SM Just completed the registration, and was wondering how much company I was SM going to have there. SM Who else has plans to attend? I'll be there. I'm even presenting this year. Best regards, Jonathan Gennick --- Brighten the corner where you are http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED] Join the Oracle-article list and receive one article on Oracle technologies per month by email. To join, visit http://four.pairlist.net/mailman/listinfo/oracle-article, or send email to [EMAIL PROTECTED] and include the word subscribe in either the subject or body. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Gennick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Kanagaraj INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Kanagaraj INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle World anyone?
I will be there too and looking forward to seeing everyone again. -Ari Ari Kaplan CEO, Expand Beyond www.XB.com Worldwide Leader in Mobile Software for IT Management Maximize Performance and Productivity Beyond the Desktop e| [EMAIL PROTECTED] w| 312-587-9990 -Original Message- John Kanagaraj Sent: Friday, August 22, 2003 7:19 PM To: Multiple recipients of list ORACLE-L All, I having taken on co-ordinating the Oracle-l listers get-together at OOW this year (Sep 7-11). So far, I have Jonathan Gennick, Matt Adams, Brian McGraw, Gerardo Molina and self. If any of you are considering a visit to the Bay area at that time - OOW or otherwise - you are welcome to attend. I will send out another invite closer to that time. John Kanagaraj -Original Message- Sent: Thursday, August 14, 2003 8:14 PM To: Multiple recipients of list ORACLE-L And there will be a bunch of us 'Silicon Valley' types who can arrange a get-together for ORACLE-L members. The rowdy bunch that got together last year nearly tore up the Restaurant, btw John Kanagaraj Oracle Applications DBA DB Soft Inc Work : (408) 970 7002 Listen to great, commercial-free christian music 24x7x365 at http://www.klove.com ** The opinions and facts contained in this message are entirely mine and do not reflect those of my employer or customers ** -Original Message- From: Jonathan Gennick [mailto:[EMAIL PROTECTED] Sent: Thursday, August 14, 2003 7:29 PM To: Multiple recipients of list ORACLE-L Subject: Re: Oracle World anyone? Thursday, August 14, 2003, 9:24:29 PM, you wrote: SM Just completed the registration, and was wondering how much company I was SM going to have there. SM Who else has plans to attend? I'll be there. I'm even presenting this year. Best regards, Jonathan Gennick --- Brighten the corner where you are http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED] Join the Oracle-article list and receive one article on Oracle technologies per month by email. To join, visit http://four.pairlist.net/mailman/listinfo/oracle-article, or send email to [EMAIL PROTECTED] and include the word subscribe in either the subject or body. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Gennick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Kanagaraj INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Kanagaraj INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ari Kaplan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: convert number to word ???
-Original Message- AK Sent: Friday, August 22, 2003 3:09 PM To: Multiple recipients of list ORACLE-L some where I got this create or replace function spell_number( p_number in number ) return varchar2 . . . That is the same routine i was directed to a few months back when I asked this question. It is from the ask tom site. It worked perfectly, and the use of to_date was brilliant and elegant. Seeing routines like that reminds me of just how far I have to go to be good at what I do. Steve McClure -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Steve McClure INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: convert number to word ???
This trick is rather limited, as it runs out of steam at amounts somewhat greater than my salary. Best go to asktom.oracle.com for this, I recall seeing a rather good one there that had much higher limits. Jared Shannon St. Dennis [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 08/22/2003 03:29 PM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: convert number to word ??? I got this off of metalink: select to_char( to_date( 1, 'J' ), 'jsp' ) from dual; SQL select to_char( to_date( 123,'J'), 'jsp') from dual; TO_CHAR(TO_DATE(123,'J') -- one hundred twenty-three SQL select to_char( to_date( 123,'J'), 'Jsp') from dual; TO_CHAR(TO_DATE(123,'J') -- One Hundred Twenty-Three SQL select to_char( to_date( 123,'J'), 'JSP') from dual; TO_CHAR(TO_DATE(123,'J') -- ONE HUNDRED TWENTY-THREE I suspect there is an upper limit imposed by some integer conversion or julian date thingy... Shannon Shannon St. Dennis Database Administrator City of Regina (306) 777-7415 (phone) (306) 777-6804 (fax) [EMAIL PROTECTED] The degree of normality in a database is inversely proportional to that of its DBA [EMAIL PROTECTED] 08/22/03 03:19pm Hi, Is there a function that can conver number to word? ef: 100 is ONE HUNDRED, 2003 is TWO THOUSAND AND THREE. Thank you in advanced!!! __ Do you Yahoo!? Yahoo! Calendar - Free online calendar with sync to Outlook(TM). http://calendar.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Andrea Oracle INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OT:UNIX: Anyway to run this in the background and return to ca
Here's a rather standard way of doing a fork in Perl. Also a nice little daemon. Works very well for Oracle utilities. Jared package Daemon; use strict; use Carp; use POSIX; sub daemon { my($tries, $pid, $sess_id); { if ($pid = fork) { exit 0 } # exit parent if (defined($pid )) { close STDOUT; close STDIN; chdir('/'); croak Cannot detach from controlling terminal unless $sess_id = POSIX::setsid(); return $pid; } if (++$tries5 ) { die fork failed after $tries attempts: $!\n } else { sleep 3; redo; } } } Matthew Zito [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 08/22/2003 02:44 PM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: OT:UNIX: Anyway to run this in the background and return to ca Errrm - this script doesn't do what I think you're trying to do. Perl starts, it forks a child process, the parent process does a bunch of stuff, but the child process only runs ps once. S, you end up with a zombie child process (until the parent is done with its business) and a parent process that is doing all the work. A better solution would be to reverse the ps and the doing stuff. Let the child process do the dirty work and let the parent focus on either generating more children or status monitoring the existing children. You could use a loop that watches for the existence of a particular pid or has a set condition and add a SIGCHLD handler that will handle cleanup of the child and remove the loop condition. Thanks, Matt -- Matthew Zito GridApp Systems Email: [EMAIL PROTECTED] Cell: 646-220-3551 Phone: 212-358-8211 x 359 http://www.gridapp.com -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mladen Gogala Sent: Friday, August 22, 2003 2:04 PM To: Multiple recipients of list ORACLE-L Subject: RE: OT:UNIX: Anyway to run this in the background and return to ca #!/usr/bin/perl use strict; use bytes; my $pid=0; if (!defined ($pid=fork())) { die Problem with cutlery:$!\n} elsif ($pid) { print Do stuff here\n; waitpid($pid,0); print Cutlery is back\n; } else { open(SPY,ps -ef|grep sqlplus|); while (SPY) { print;} } -- Mladen Gogala Oracle DBA -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Friday, August 22, 2003 1:25 PM To: Multiple recipients of list ORACLE-L Subject: RE:OT:UNIX: Anyway to run this in the background and return to ca $ORACLE_HOME/bin/sqlplus / as sysdba EOD select .. exit EOD echo this is a test ps -ef|grep sqlplus I wish to put that into a unix command but at the same time run it in the background and return back to the parent script to do some other stuff? Anyone done this? Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity.
Recover 8.1.7 DB with _allow_resetlogs_corruption
8.1.7.0 on HP-UX. Another DBA (really, it wasn't me) forgot which server he was on and deleted the RBS tablespace datafile and all the archived redo logs - on different mount points - of our Production Financials database. No time for the whys of that story or why we don't mirror our archived redo logs (which we will do starting today!). We dug up references to these undocumented parameters: _allow_resetlogs_corruption _corrupted_rollback_segments _offline_rollback_segments We have all the current database datafiles (plus the hot backup RBS datafile from last night), online redo logs, control files, etc. and have included those undocumented parameters in our init.ora. A message in the alert log looks hopeful when we attempt to Open Resetlogs: RESETLOGS is being done without consistancy checks. This may result in a corrupted database. The database should be recreated. RESETLOGS after incomplete recovery UNTIL CHANGE 4806846187 However, all our attempts to open the database have failed with various errors: ORA-00600: internal error code, arguments: [4000], [25], [], [], [], [], [], [] ORA-704 signalled during: alter database open resetlogs ORA-1139 signalled during: alter database open resetlogs We also tried to recreate the control files from a trace coltrolfile, but get this error in the alert log. On the screen it's a snapshot too old error, referring to a rollback segment with no number or name. ORA-604 signalled during: ALTER DATABASE OPEN ResetLogs Are we hopelessly hosed? We backed up the database, unfortunately only _after_ we tried a couple of recovery attempts. Have we messed around with these datafiles too much and need to restore from our backup? Did our messing with the database before we backed it up eliminate the possibility of any kind of recovery, even using those undocumented parameters? Remember, ALL our archived redo logs between last night's hot backup and today's fiasco are gone, and there were enough log switches to have cycled through the online redo logs several times. We're logging a tar with Oracle Support, but any advice would be helpful. Thanks. Jack C. Applewhite Database Administrator Austin Independent School District Austin, Texas 512.414.9715 (wk) 512.935.5929 (pager) [EMAIL PROTECTED]
9iR2, grant select on a column (without using views) using RLS
list, i'm ikn the process of designing security for a highly sensitive schema for a bank, plan: have multiple oracle users, and use roles, and grant minimum required privs, all the user/role/privs management coded in the application (with in turn would create the db role and user etc) probolem: i cannot do a grant select(col1)on tabname to role1, as select grant on a column level is not supported, to workaround this i must 1) use views and include all the columns granted seleted privs for a user, then give grant select on this view to user. 2) somehow use RLS ?? TIA -Rahul -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: rahul INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Replication options Was: SharePlex info
Hi there In the past few weeks, there have been lots of discussion about HA, data replication and using Shareplex, dataguard, Streams, logical physical standby. As most of you have found out each has it own pros and cons. You also need two sets of Database licences and Shareplex licences. Then there are real technical issues like DDLs, db patches/upgrades, external files like INIT.ORA etc etc. I would like to suggest that you also consider using filesystem replication. At one site I have the following Prod }--- Sync replication - Standby }--- Async replication - DR I also use checkpoints/snapshots on the Prod box which gets replicated to the target boxes as well. This allows me to start the standby/DR box to any point in time that had the checkpoint/snapshot. Why did I recommend this to the client? because it does not need a highly paid DBA to do any of the work required. Now depending on your situation and country, you do not need to purchase oracle for the Standby and DR site. The cost savings can go towards the cost of using this filesystem replication option. Which ones? Try NetApps and Veritas Volume replicator. my 2cents worth ta tony At 09:49 AM 21/08/2003 -0800, you wrote: Hi All, I'm trying to find some technical details about SharePlex, that is: - How much network bandwidth I'd expect to replicate from database, generating 1-5 MB/sec redo. Does SharePlex send SQL text over the network or data in some internal (hopefully compressed) format - How much CPU on the source DB server side would it cost - just a ball park - very little- little - or a lot - Of two options, using 9.2 physical async standby db and clone whole database vs replicate 50% (enough from business requirements) of tables using SharePlex, which one sounds preferrable keeping in mind minimizing CPU burden on the source database. Any opinion or pointer to any benchmark is highly appreciated. Thanks a lot Vadim