Re: Bug in Execute Immediate clause???
First session: SQL CREATE OR REPLACE procedure testing authid current_user is 2 sql_stmt VARCHAR2(4000); 3 c number; 4 n number; 5 a varchar2(1000); 6 Begin 7 sql_stmt := 'Alter Session Set Current_Schema = scott'; 8 Execute Immediate sql_stmt; 9 Dbms_output.put_line(sys_context('userenv', 'Current_schema'));10 sql_stmt := 'Select count(*) From temp';11 Execute Immediate sql_stmt into c;12 Dbms_output.put_line(c);13 END;14 / Procedure created. Second Session: - SQL conn test1Enter password: *Connected.SQL exec test1.testing; PL/SQL procedure successfully completed. SQL set serveroutput onSQL exec test1.testing;SCOTT0 PL/SQL procedure successfully completed. SQL in second session when you execute the procedure the schema changed and not find the procedure in that schema try this one. With Regards, Manoj Kumar Jha - Original Message - From: Ranganath K To: Multiple recipients of list ORACLE-L Sent: Wednesday, July 02, 2003 9:00 PM Subject: Bug in Execute Immediate clause??? Hi Listers, The below procedure gets created successfully in TEST Schema. But when I execute the procedure by starting a fresh session connecting as TEST schema I get the below error and when I execute the procedure for the second time it executes successfully. I have granted the dba privileges and explicit granted select on TEMP1 to TEST Schema. Inspite of that I am getting the below errors. I tried this 8.1.7 and 9.2.1.0. Is it a bug in the code or the database? CREATE OR REPLACE procedure test authid current_user is c number; n number; a varchar2(1000); Begin Execute Immediate 'Alter Session Set Current_Schema = SCOTT'; Dbms_output.put_line(sys_context('userenv', 'Current_schema')); Select count(*) into c From temp1; Dbms_output.put_line(c); End; ERROR at line 1: ORA-00942: table or view does not exist ORA-06512: at "TEST.TEST", line 9 ORA-06512: at line 1 Can anybody help me out? Any help in this regard is very much appreciated. Thanks and Regards, Ranganath
Re: controlfile backup obsolete above 2 days
Thanks chip - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, July 02, 2003 11:10 : MetaLink Bug 2458246 (fixed in 9.2.0.2) : : DENNIS WILLIAMS wrote: : : Offhand it sounds to me like you may have uncovered an error. I would search : metalink and if you don't find an error matching this situation, I would : file a TAR. : : Dennis Williams : DBA, 80%OCP, 100% DBA : Lifetouch, Inc. : [EMAIL PROTECTED] : : : -Original Message- : Sent: Friday, June 20, 2003 9:34 PM : To: Multiple recipients of list ORACLE-L : : : Hello list : sorry to trouble you all so much, : I tried all that I stated below on another database I created, and as : long as I don't use an spfile , no problem. As soon as I start using : an spfile , I always get my backup shown as obsolete , irrespective of : the number of days (the value of n) I specify in ''report obsolete : recovery window of n days; '' . : Also a few more details , previously i was getting the problem on a : 9.2.0.1.0 enterprise edition database in noarchivelog mode. The : problem I stated above is on a 9.2.0.1.0 enterprise edition database : in archivelog mode with automatic archiving enabled. All this on : win32. : : : : - Original Message - : To: [EMAIL PROTECTED] : Sent: Saturday, June 21, 2003 00:28 : : : : Hello list : : I was having problems with my controlfile backups being reported as : : obsolete ; : : I have narrowed down the problem to the number of days specified in : : the recovery window . : : : : 1. My control_file_record_keep_time=7 : : : : 2. Suppose I start rman and there are no backups yet. (This is : : confirmed by the commands : : : delete noprompt force backup ; : : delete nopromt force copy ; : : list backup ; (This shows no o/p confirming that there are no : : backups ) : : list backup of controlfile ; (This shows no o/p confirming that : there : : are no backups ) : : : : 3. All the rman configuration settings are at their default values : . : : I did not modify any , and just to be sure I checked using 'show all : : ;' : : : : 4. Now I backup the database : : : backup database ; : : : : As expected it creates a single set with a single piece whose name : is : : in the o/p: : : : : channel ORA_DISK_1: finished piece 1 at 21-Jun-2003 00:13:01 : : piece handle=D:\ORACLEXP\ORA92\DATABASE\03EQ6ARH_1_1 comment=NONE : : channel ORA_DISK_1: backup set complete, elapsed time: 00:00:28 : : Finished backup at 21-Jun-2003 00:13:01 : : : : : : 5. I confirm this by using 'list backup ;' and : : list backup of controlfile ; : : : : 6. NOW THE PROBLEM IS : : : : : : : RMAN report obsolete recovery window of 1 days ; : : : : no obsolete backups found : : : : : : RMAN report obsolete recovery window of 2 days ; : : : : no obsolete backups found : : : : : : : : RMAN report obsolete recovery window of 3 days ; : : : : Report of obsolete backups and copies : : Type KeyCompletion TimeFilename/Handle : : - -- -- : : Backup Set3 21-Jun-2003 00:12:52 : : Backup Piece 3 21-Jun-2003 00:12:52 : : D:\ORACLEXP\ORA92\DATABASE\03EQ6ARH_1_1 : : : : Why is this happening for all values above 2 days ? : : Please advise : : . : : : : : : : : : -- : Please see the official ORACLE-L FAQ: http://www.orafaq.net : -- : Author: Chip : INET: [EMAIL PROTECTED] : : Fat City Network Services-- 858-538-5051 http://www.fatcity.com : San Diego, California-- Mailing list and web hosting services : - : To REMOVE yourself from this mailing list, send an E-Mail message : to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in : the message BODY, include a line containing: UNSUB ORACLE-L : (or the name of mailing list you want to be 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).
RE: fine grained access
thanks all for your quick replies. I think i will write a few triggers to do the trick. Re: fine grained access ---BeginMessage--- Hi Arup, LogMiner is fine for certain tasks but not for auditing everything, it has some deficiencies such as it cannot be used in an MTS environment as it uses PGA memory, it doesn't fully support chained and migrated rows (fixed in 9i), doesn't support selects (as they are not recorded in the redo prior to 9i), doesn't fully support objects of analysis of IOT's or clustered tables. But I do agree with you that the best solution is to use regular audit or normal user triggers. If the poster wants to use Fine Grained audit then there are a few links to some good documents on my site http://www.petefinnigan.com/orasec.htm that cover FGA. kind regards Pete However, FGA is bit of an overkill in your case. It's typically the only solution for auditing the seelct statements. For changes (insert/update/delete), you could employ the regular auditing (AUDIT). that will tell you who changed something, but not what. To see the what, you could use log miner to unearth those statements with the data. -- Pete Finnigan email:[EMAIL PROTECTED] Web site: http://www.petefinnigan.com - Oracle security audit specialists Book:Oracle security step-by-step Guide - see http://store.sans.org for details. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Finnigan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). ---End Message---
Oracle 9 on redhat 9...kernal settings
I have 512 MB RAM in my Redhat Linux intel machine running Oracle 9. What should I set the Kernal parameters to. shmmax, shmmni, shmall, sem JD -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Dunn INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Need to get the output of a column with its column name in as rows
Hi Have the following table columns curvedetails_id, curve_id, curvedetails_date, p0030, p0100, p0130, p0200, p0230, p0300, p0330, I need to do a query that does the following output CurveId ,CurveDate, PNumber, PReading 206116, 31-Dec-2002, P0030, 26.18 206116, 31-Dec-2002,P0100, 8.80 where the pnumber column is the column name in the table Is there anyway to get this without using a whole bunch of unions Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = A great pleasure in life is doing what people say you cannot do. - Walter Bagehot (1826-1877 British Economist) = Mincom The People, The Experience, The Vision = This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. -- 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: Redo Copy Latch contention ??
Please see the link... Steve Adams has given lots of information on it. http://www.ixora.com.au/ Yes you have contention problem and that may be causing high CPU Utilizxation. It is not simple to analyse redo copy contention problem and soln with below data... detail investigation, you have to performed - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, July 03, 2003 1:50 AM Thanks Kirti, We have HP Openview implemented on our database and hence got some alert on redo copy latch. When I have queried the database I found the contention on this latch. Yes we have other performance issues ( HIGH CPU utilization , because of lotta bad code ). and We are checking every possible contention on the database. Question : How can I determine if this redo copy latch is causing the performance issues , guess that is my main question before altering some hidden parameter in init.ora. Madhu Reddy X13944 -Original Message- Sent: Wednesday, July 02, 2003 1:56 PM To: Multiple recipients of list ORACLE-L According that suggestion you do seem to have redo copy latch contention. As far as getting that ratio close to suggested value, you may set some special init.ora parameters. There is plenty of notes on Metalink for that. But, you should first determine if this is causing any performance issue. Have you explored all other avenues to address those issues. If not, I would not worry about this contention. - Kirti --- Reddy, Madhusudana [EMAIL PROTECTED] wrote: Hello ALL, Do you guys think we have redo copy latch contention ?? Also what are your suggestions on tuning Redo Copy Latch ?? SUBSTR(LN.NAME,1,20) GETS MISSES IMMEDIATE_GETS IMMEDIATE_MISSES -- -- -- redo allocation 9433506468862115 00 redo copy 22097497 907958724 1592481 14:54:54 SQL select (497/22097)*100 from dual; (497/22097)*100 ~ (misses/gets)*100 --- 2.2491741 --- Oracle suggests it should be under 1% Madhu Reddy X13944 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Reddy, Madhusudana INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Reddy, Madhusudana INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Manoj Kumar Jha INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
sql loader question
Hello list I have a doubt regarding the following question : ** SQL*Loader reads a set of records from a file, generates INSERT commands, and passes them to the Oracle kernel. Oracle then finds places for those records in free blocks in the table and updates any associated indexes. Which SQL*Loader mode is used in this scenario? A. direct-path load B. conventional path load Answer : Direct-path load , ( It is said free blocks which implies Direct-Path Load, because Conventional-Path Load also use partially filled blocks. ) *** Shouldn't it be conventional path load, because insert commands are being used . Direct path load builds blocks of data in memory and saves these blocks directly into the extents allocated for the table being loaded -- 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).
SQL need help
Hi, I have two tables 1. ALL_CUSTOMER CustNo: 1 to 100 OtherDetail: bla bla bla 2. ORDER CustNo TotalOrder DateOrder I want to display like this CustomerNo 1Total Order For This month = 101 or CustomerNo 1 Total Order For This month = 0 My SQL statement is like this SELECT a.custno, sum(b.total_order) from all_customer a, order b where b.custno (+) = a.custno and to_char(dateorder, 'month') = 'JUNE' (PROBLEM is HERE) group by a.custno When I run this statement for those customer that never order anything, my statement return No row returns How to get something like this CustomerNo 1 Total Order For This month = 0 I tried this nvl(to_char(dateorder, 'month'), 'JUNE') = 'JUNE' Thanks Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sinardy Xing INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Script to check filename continuously
Hi All Does anyone have script(DOS batch file or Unix Shell) to do the following stuff? loop if exist FILE_NAME begin do something; copy files to remote machine,etc... EXIT; end; end loop; Thanks Sami -- 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: {SPAM?} Re: fine grained access
Interesting threads. May I just seek the advice of the list on the alternative means by which one might capture read only activity? We want to know if a 'select' statement is run against particular tables. peter edinburgh -Original Message- From: Rachel Carmichael [mailto:[EMAIL PROTECTED] Sent: 02 July 2003 16:46 To: Multiple recipients of list ORACLE-L Subject: {SPAM?} Re: fine grained access Fine grained access control doesn't tell you who did what, it restricts users from doing certain things. If you want to just capture the changes, not the actual update statement, you can do this via triggers which insert into a copy of the table, with the additional columns of timestamp and user --- [EMAIL PROTECTED] wrote: Hi list We have a dozen authorisation tables who are visibible for end-users and changeable for application owners. What our security officer wants is that he can see who changed something in those tables (including timestamp and update statement) Is FGA the solution for this ? Anyone with a few tips/hints how to do this with FGA ? thanks vr.gr. Geo Kor Sr. System Engineer IDM Db RDW Voertuiginformatie en -toelating Ict Bedrijf Holland * [EMAIL PROTECTED] -- 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). __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). * This e-mail message, and any files transmitted with it, are confidential and intended solely for the use of the addressee. If this message was not addressed to you, you have received it in error and any copying, distribution or other use of any part of it is strictly prohibited. Any views or opinions presented are solely those of the sender and do not necessarily represent those of the British Geological Survey. The security of e-mail communication cannot be guaranteed and the BGS accepts no liability for claims arising as a result of the use of this medium to transmit messages from or to the BGS. .http://www.bgs.ac.uk * -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Robson, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
cannot disable or drop the ON DATABASE trigger !!!!
Help list... i have created the following in 8.1.5 instance CREATE OR REPLACE TRIGGER DDL_TRIGGER BEFORE CREATE OR ALTER OR DROP ON DATABASE BEGIN null; END; / and now i cannot drop or disable this trigger ERROR at line 1: ORA-04045: errors during recompilation/revalidation of SYS.DDL_TRIGGER i'm loggin into svrmgrl and connecting as internal to try drop or disable.. is this a bug ?? TIA Rahul.. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: rahul sharma INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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 9 on redhat 9...kernal settings
Follow this link and it will work (did for me and a friend of mine and we have 512Mb memory also) http://codah.net/install-oracle9iR2-on-redhat9.html Jack -Original Message- Sent: Thursday, July 03, 2003 10:54 AM To: Multiple recipients of list ORACLE-L I have 512 MB RAM in my Redhat Linux intel machine running Oracle 9. What should I set the Kernal parameters to. shmmax, shmmni, shmall, sem JD -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Dunn INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: SQL need help
select 'CustomerNo '||a.custno||' Total Order for this month = '||nvl(c.totalorder,0) from all_customer a, (SELECT b.custno as custno, sum(b.totalorder) as totalorder from orders b group by b.custno,to_char(b.dateorder,'mm') having to_char(b.dateorder,'mm')='06') c where c.custno(+)=a.custno Jack -Original Message- Sent: Thursday, July 03, 2003 11:06 AM To: Multiple recipients of list ORACLE-L Hi, I have two tables 1. ALL_CUSTOMER CustNo: 1 to 100 OtherDetail: bla bla bla 2. ORDER CustNo TotalOrder DateOrder I want to display like this CustomerNo 1Total Order For This month = 101 or CustomerNo 1 Total Order For This month = 0 My SQL statement is like this SELECT a.custno, sum(b.total_order) from all_customer a, order b where b.custno (+) = a.custno and to_char(dateorder, 'month') = 'JUNE' (PROBLEM is HERE) group by a.custno When I run this statement for those customer that never order anything, my statement return No row returns How to get something like this CustomerNo 1 Total Order For This month = 0 I tried this nvl(to_char(dateorder, 'month'), 'JUNE') = 'JUNE' Thanks Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sinardy Xing INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: SQL need help
Outer join? Guang On Thu, 3 Jul 2003, Sinardy Xing wrote: Hi, I have two tables 1. ALL_CUSTOMER CustNo: 1 to 100 OtherDetail: bla bla bla 2. ORDER CustNo TotalOrder DateOrder I want to display like this CustomerNo 1Total Order For This month = 101 or CustomerNo 1 Total Order For This month = 0 My SQL statement is like this SELECT a.custno, sum(b.total_order) from all_customer a, order b where b.custno (+) = a.custno and to_char(dateorder, 'month') = 'JUNE' (PROBLEM is HERE) group by a.custno When I run this statement for those customer that never order anything, my statement return No row returns How to get something like this CustomerNo 1 Total Order For This month = 0 I tried this nvl(to_char(dateorder, 'month'), 'JUNE') = 'JUNE' Thanks Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sinardy Xing INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Guang Mei INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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[2]: Online tech books
here's a practical question: is there a way to put tech books online? what about a web site you'd pay a fee to use? i'd really like to have such a thing. [can't grep dead trees.;-)] is this possible? -- Bill Shrek Thater ORACLE DBA BAARF Party member #25 [EMAIL PROTECTED] If you don't know where you're going, any road will take you there. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Thater, William INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
calling an external procedure
Hi all, before I smash my head against the wall.. I am trying to execute an external procedure defined in a C .dll. I have set up my tnsnames/listener.ora as following : --- # C:\ORANT\NET80\ADMIN\TNSNAMES.ORA Configurationfile :C:\ORANT\net80\admin\tnsnames.ora # Generated by Oracle Net8 Assistant Tcp-loopback.world = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (Host = 127.0.0.1) (Port = 1521) ) ) (CONNECT_DATA = (SID = ORCL) ) ) extproc_connection_data.world = (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC) (KEY = ORCL) ) (CONNECT_DATA = (SID = extproc) ) ) # C:\ORANT\NET80\ADMIN\LISTENER.ORA Configuration File:C:\ORANT\net80\admin\listener.ora # Generated by Oracle Net8 Assistant LISTENER = (ADDRESS_LIST = (ADDRESS= (PROTOCOL= IPC) (KEY= oracle.world) ) (ADDRESS= (PROTOCOL= IPC) (KEY= ORCL) ) (ADDRESS= (PROTOCOL= TCP) (Host= ff1) (Port= 1521) ) (ADDRESS= (PROTOCOL= TCP) (Host= ff1) (Port= 1526) ) (ADDRESS= (PROTOCOL= SPX) (Service= inventory_lsnr) ) (ADDRESS= (PROTOCOL= NMP) (SERVER= nt_inventory_box) (PIPE= ORAPIPE) ) ) STARTUP_WAIT_TIME_LISTENER = 0 CONNECT_TIMEOUT_LISTENER = 10 SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = ff1) (SID_NAME = ORCL) ) (SID_DESC = (SID_NAME = extproc) (PROGRAM=extproc) (ORACLE_HOME=$ORACLE_HOME) ) ) LOG_DIRECTORY_LISTENER = c:\orant\net80\trace TRACE_DIRECTORY_LISTENER = c:\orant\net80\trace TRACE_LEVEL_LISTENER = admin The plsql test code is : drop library zPrintString; create library zPrintString as 'c:/newsys/bin/PrintString.dll'; select * from user_libraries; create or replace procedure PrintString (OutPutString IN VARCHAR2) as external Library zPrintString name zPrintString parameters (OutPutString STRING); begin execute PrintString('testing'); end; -- Oracle tells me, that it is not able, to loead the dll. Error message is : ORA-06520: PL/SQL: Error loading external library ORA-06522: Unable to load DLL ORA-06512: at SYS.PRINTSTRING, line 0 ORA-06512: at line 2 -- is anyone able, to help ? TNX Frank Confidentiality Notes This email and any files transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. If you are not the authorised recipient, any use, disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited. If you received this in error, please contact the sender and delete the material from any computer. E-mail messages are not necessarily secure. Scheidt Bachmann does not accept responsibility for any changes made to this message after it was sent. Thank you for your cooperation! Diese E-Mail und alle angehängten Dateien ist ausschließlich für die Person / Personen bestimmt, an die diese adressiert ist und könnte vertrauliche und / oder rechtlich geschützte Informationen enthalten. Sollten Sie nicht der für diese E-Mail bestimmte Adressat oder nicht zum Empfang berechtigt sein, ist Ihnen jeder Gebrauch, sowie jede Veröffentlichung, Vervielfältigung oder Weitergabe wie auch das Ergreifen oder Unterlassen von Maßnahmen im Vertrauen auf erlangte Information untersagt. Sollten Sie diese E-Mail irrtümlich erhalten haben, benachrichtigen Sie bitte den Absender und löschen diese E-Mail von jedem Computer. E-Mail-Mitteilungen sind nicht notwendigerweise sicher. Scheidt Bachmann übernimmt keine Verantwortung für Veränderungen dieser Mitteilung, die nach dem Senden vorgenommen wurden. Herzlichen Dank für Ihre Unterstützung! - -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Foelz.Frank INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L
Re: {SPAM?} Re: fine grained access
Peter, Are you interested to know whether a select statement ran againt a particular table, only? Then AUDIT command will do the job nicely. However, if you want to record 'what' was selected from that table, you need Fine Grained Auditing, which requires Oracle 9i. HTH. Arup Nanda www.prolignece.com - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, July 03, 2003 6:35 AM Interesting threads. May I just seek the advice of the list on the alternative means by which one might capture read only activity? We want to know if a 'select' statement is run against particular tables. peter edinburgh -Original Message- From: Rachel Carmichael [mailto:[EMAIL PROTECTED] Sent: 02 July 2003 16:46 To: Multiple recipients of list ORACLE-L Subject: {SPAM?} Re: fine grained access Fine grained access control doesn't tell you who did what, it restricts users from doing certain things. If you want to just capture the changes, not the actual update statement, you can do this via triggers which insert into a copy of the table, with the additional columns of timestamp and user --- [EMAIL PROTECTED] wrote: Hi list We have a dozen authorisation tables who are visibible for end-users and changeable for application owners. What our security officer wants is that he can see who changed something in those tables (including timestamp and update statement) Is FGA the solution for this ? Anyone with a few tips/hints how to do this with FGA ? thanks vr.gr. Geo Kor Sr. System Engineer IDM Db RDW Voertuiginformatie en -toelating Ict Bedrijf Holland * [EMAIL PROTECTED] -- 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). __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). * This e-mail message, and any files transmitted with it, are confidential and intended solely for the use of the addressee. If this message was not addressed to you, you have received it in error and any copying, distribution or other use of any part of it is strictly prohibited. Any views or opinions presented are solely those of the sender and do not necessarily represent those of the British Geological Survey. The security of e-mail communication cannot be guaranteed and the BGS accepts no liability for claims arising as a result of the use of this medium to transmit messages from or to the BGS. .http://www.bgs.ac.uk * -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Robson, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Arup Nanda INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services
Re: calling an external procedure
On Thu, 3 Jul 2003, Foelz.Frank wrote: Hi all, before I smash my head against the wall.. I am trying to execute an external procedure defined in a C .dll. I have set up my tnsnames/listener.ora as following : [snip] Oracle tells me, that it is not able, to loead the dll. Error message is : ORA-06520: PL/SQL: Error loading external library ORA-06522: Unable to load DLL ORA-06512: at SYS.PRINTSTRING, line 0 ORA-06512: at line 2 Problems can arise due to name mangling in the .DLL Use the Depends.exe utility to open the DLL and look at the entry point name for your function. It probably is not what you expect it is. What I have found that works in the past is to declare the fuction as #define ORACMD_API __declspec(dllexport) extern C ORACMD_API void RunCommand(char *); The problem you're going to find is that the 'extern C' syntax is only supported in C++, so you will have to convert it to C++. Alternatively use the 'mangled' name in the Oracle definition and try that route The depends.exe utility comes with Visual Studio and can also be found in the Resource Kit for NT Cheers Jeff Herrick -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeff Herrick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: calling an external procedure
A couple of other things 1) create library zPrintString as 'c:/newsys/bin/PrintString.dll'; This should be 'C:\newsys\bin\PrintString.dll' in the WinBlows world 2) can you TNSPING your ext_proc service? After re-looking at your note I think that 1) is your problem since it can't find the DLL with the path '/' you gave it...I'm pretty sure the text just gets passed to the LoadLibrary() API. Once it locates the DLL you _might_ have the name mangling issues from my previous note HTH Jeff Herrick -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeff Herrick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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[2]: Online tech books
Thanks Jonathan and Robert... Yes, Those book cases are wallmart specials I think the tall one was $25 and the small work modle was $15 or so. Hey, I even purchaced the work book case due to my distaste for justifying the cost of the purchace I figgured it was at least 100x easier to just buy my own bookcase for $15, then when I leave I can take it with me, to the next employer ... I can hear damagement now... hey Joe... This guy is serious.. He is bringing in his own bookcase Yes sad, but unfortunatly true. Just thinking about that... Im sure that's against some corporate policy ;-) In any event the book case(s) were cheaper than most books there. Lastly my favorite books are the Oracle SQL Plus by Jonathan I enjoyed how personally it was written as well as being clear and providing a lot of tips. Second favorite is the Oracle 8i DBA bible which I know some here dispute a chapter or two, nevertheless It's a very *direct* useful reference book One that is not as dry as most. Also like the 101 backup and recovery, very useful, with full example scenarios. Have a good 4th of July Holiday all! bob BM message) But, Ive taken some pictures of my collection.. Ive BM actually purchaced all the books you see! BM http://162.42.213.232/books/index.html Wow! Bob, I think you have me beat, and I'm no slouch when it comes to ordering books. Hey, you know what else, as I look very closely at your bookcases, I think you use the same cheap, partical-board-covered-with-paper, bendable-shelf brand that I usegrin. I better get on the stick and order more booksgrin. Best regards, Jonathan Gennick --- Brighten the corner where you are http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: calling an external procedure
Frank, You've got the TNSNAMES and Listener entries fouled up. Here are the ones I use, the critical Keys are marked: TNSNAMES: extproc_connection_data.world = (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC) (KEY = extproc_agent) --- Key1 ) (CONNECT_DATA = (SID = 11) --- Key2 (server=dedicated)) ) Listener: EXTPROC_LISTENER = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC) (KEY = extproc_agent) Key1 ) ) SID_LIST_EXTPROC_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = 11) Key2 (ORACLE_HOME = /ora1/81764) (PROGRAM = extproc) ) ) BTW: Oracle's recommendation is to use a seperate listener for extproc calls. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Thursday, July 03, 2003 8:26 AM To: Multiple recipients of list ORACLE-L Hi all, before I smash my head against the wall.. I am trying to execute an external procedure defined in a C .dll. I have set up my tnsnames/listener.ora as following : --- # C:\ORANT\NET80\ADMIN\TNSNAMES.ORA Configurationfile :C:\ORANT\net80\admin\tnsnames.ora # Generated by Oracle Net8 Assistant Tcp-loopback.world = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (Host = 127.0.0.1) (Port = 1521) ) ) (CONNECT_DATA = (SID = ORCL) ) ) extproc_connection_data.world = (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC) (KEY = ORCL) ) (CONNECT_DATA = (SID = extproc) ) ) # C:\ORANT\NET80\ADMIN\LISTENER.ORA Configuration File:C:\ORANT\net80\admin\listener.ora # Generated by Oracle Net8 Assistant LISTENER = (ADDRESS_LIST = (ADDRESS= (PROTOCOL= IPC) (KEY= oracle.world) ) (ADDRESS= (PROTOCOL= IPC) (KEY= ORCL) ) (ADDRESS= (PROTOCOL= TCP) (Host= ff1) (Port= 1521) ) (ADDRESS= (PROTOCOL= TCP) (Host= ff1) (Port= 1526) ) (ADDRESS= (PROTOCOL= SPX) (Service= inventory_lsnr) ) (ADDRESS= (PROTOCOL= NMP) (SERVER= nt_inventory_box) (PIPE= ORAPIPE) ) ) STARTUP_WAIT_TIME_LISTENER = 0 CONNECT_TIMEOUT_LISTENER = 10 SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = ff1) (SID_NAME = ORCL) ) (SID_DESC = (SID_NAME = extproc) (PROGRAM=extproc) (ORACLE_HOME=$ORACLE_HOME) ) ) LOG_DIRECTORY_LISTENER = c:\orant\net80\trace TRACE_DIRECTORY_LISTENER = c:\orant\net80\trace TRACE_LEVEL_LISTENER = admin The plsql test code is : drop library zPrintString; create library zPrintString as 'c:/newsys/bin/PrintString.dll'; select * from user_libraries; create or replace procedure PrintString (OutPutString IN VARCHAR2) as external Library zPrintString name zPrintString parameters (OutPutString STRING); begin execute PrintString('testing'); end; -- Oracle tells me, that it is not able, to loead the dll. Error message is : ORA-06520: PL/SQL: Error loading external library ORA-06522: Unable to load DLL ORA-06512: at SYS.PRINTSTRING, line 0 ORA-06512: at line 2 -- is anyone able, to help ? TNX Frank Confidentiality Notes This email and any files transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. If you are not the authorised recipient, any use, disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited. If you received this in error, please contact the sender and delete the material from any computer. E-mail messages are not necessarily secure. Scheidt Bachmann does not accept responsibility for any changes made to this message after it was sent. Thank you for your cooperation! Diese E-Mail und alle angehängten Dateien ist ausschließlich für die Person / Personen bestimmt, an die diese adressiert ist und könnte vertrauliche und / oder rechtlich geschützte Informationen enthalten. Sollten Sie nicht der für diese E-Mail bestimmte Adressat oder nicht zum Empfang berechtigt sein, ist Ihnen jeder Gebrauch, sowie jede Veröffentlichung, Vervielfältigung oder Weitergabe wie auch das Ergreifen oder Unterlassen von Maßnahmen im Vertrauen auf erlangte Information untersagt. Sollten Sie diese E-Mail irrtümlich erhalten haben, benachrichtigen Sie bitte den
RE: calling an external procedure
Jeff, You can also get that error if your session can't connect to the extproc listener and spawn a copy of the extproc executable. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Thursday, July 03, 2003 9:21 AM To: Multiple recipients of list ORACLE-L On Thu, 3 Jul 2003, Foelz.Frank wrote: Hi all, before I smash my head against the wall.. I am trying to execute an external procedure defined in a C .dll. I have set up my tnsnames/listener.ora as following : [snip] Oracle tells me, that it is not able, to loead the dll. Error message is : ORA-06520: PL/SQL: Error loading external library ORA-06522: Unable to load DLL ORA-06512: at SYS.PRINTSTRING, line 0 ORA-06512: at line 2 Problems can arise due to name mangling in the .DLL Use the Depends.exe utility to open the DLL and look at the entry point name for your function. It probably is not what you expect it is. What I have found that works in the past is to declare the fuction as #define ORACMD_API __declspec(dllexport) extern C ORACMD_API void RunCommand(char *); The problem you're going to find is that the 'extern C' syntax is only supported in C++, so you will have to convert it to C++. Alternatively use the 'mangled' name in the Oracle definition and try that route The depends.exe utility comes with Visual Studio and can also be found in the Resource Kit for NT Cheers Jeff Herrick -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeff Herrick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Raid 0+1 vs. mirrored pairs
Especially if all you have is three mirrors. With that few places to put things, you won't be able to separate everything (tables, indexes, archives, redo logs, sort areas, etc.) on its own mirror. Using a single striped mirror is the only way you can guarantee any kind of balanced I/O. -Original Message- Separating tables from indexes is one of those mythical things. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
How to install Oracle JVM on Oracle 8.1.7.
Hi all, I want to install, oracle JVM on oracle 817 database running on NT2000 server. I hope that initjvm.sql script has to be run under sys login. However i can't able to find that script file in my oracle home path %ORACLE_HOME%\RDBMS\ADMIN. Let know how to proceed futher and what are the pre requisities and post requiesties for this intallation?. Thanks. Nirmal,. = fsdfsdfsdfsdfs __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nirmal Kumar M INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: {SPAM?} Re: fine grained access
A particular select? or just any select? I think you can use Oracle auditing if that's all you need. --- Robson, Peter [EMAIL PROTECTED] wrote: Interesting threads. May I just seek the advice of the list on the alternative means by which one might capture read only activity? We want to know if a 'select' statement is run against particular tables. peter edinburgh -Original Message- From: Rachel Carmichael [mailto:[EMAIL PROTECTED] Sent: 02 July 2003 16:46 To: Multiple recipients of list ORACLE-L Subject: {SPAM?} Re: fine grained access Fine grained access control doesn't tell you who did what, it restricts users from doing certain things. If you want to just capture the changes, not the actual update statement, you can do this via triggers which insert into a copy of the table, with the additional columns of timestamp and user --- [EMAIL PROTECTED] wrote: Hi list We have a dozen authorisation tables who are visibible for end-users and changeable for application owners. What our security officer wants is that he can see who changed something in those tables (including timestamp and update statement) Is FGA the solution for this ? Anyone with a few tips/hints how to do this with FGA ? thanks vr.gr. Geo Kor Sr. System Engineer IDM Db RDW Voertuiginformatie en -toelating Ict Bedrijf Holland * [EMAIL PROTECTED] -- 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). __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). * This e-mail message, and any files transmitted with it, are confidential and intended solely for the use of the addressee. If this message was not addressed to you, you have received it in error and any copying, distribution or other use of any part of it is strictly prohibited. Any views or opinions presented are solely those of the sender and do not necessarily represent those of the British Geological Survey. The security of e-mail communication cannot be guaranteed and the BGS accepts no liability for claims arising as a result of the use of this medium to transmit messages from or to the BGS. .http://www.bgs.ac.uk * -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Robson, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send
Re: Oracle DBA 9i Books ever needed.
AHA! Thanks Hermione :) okay, now Jared will perform the crucias (sp? I don't have the book with me, I finished it and it's home) curse on me if I don't stop here and take this to the OT list. --- Nuno Souto [EMAIL PROTECTED] wrote: - Original Message - you mean we don't tune Oracle using spells, incantations and prayers? Dang, I knew I was doing something wrong! It's leviosa, not lehviosah... ;) 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). __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: CASE in PL/SQL
Surendra, The following query lists 12 months along with the actual year and quarter as well as the financial year and financial quarter ... probably you can modify this query to use in your cursor ... SELECT CUR_DATE, CUR_YEAR, CUR_QTR, FIN_QTR, LEAST(0,SIGN(CUR_QTR-FIN_QTR))+CUR_YEAR FIN_YEAR FROM( SELECT ADD_MONTHS(TO_DATE('01-JAN-2003','DD-MON-'),ROWNUM-1) CUR_DATE, TO_NUMBER(TO_CHAR(ADD_MONTHS(TO_DATE('01-JAN-2003','DD-MON-'),ROWNUM-1), '')) CUR_YEAR, TO_NUMBER(TO_CHAR(ADD_MONTHS(TO_DATE('01-JAN-2003','DD-MON-'),ROWNUM-1), 'Q')) CUR_QTR, TO_NUMBER(TO_CHAR(ADD_MONTHS(TO_DATE('01-JAN-2003','DD-MON-'),ROWNUM-1+6 ),'Q')) FIN_QTR FROMALL_OBJECTS WHERE ROWNUM 13 ); HTH ... Regards, Jayadas -Original Message- [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 02, 2003 6:11 PM To: Multiple recipients of list ORACLE-L I am already using it that way, but giving that condition in cursor is not possible. Thanks for your help. Surendra -Original Message- Sent: Wednesday, July 02, 2003 5:01 PM To: Multiple recipients of list ORACLE-L just use the sql to assign value to your variable ... if you really want my advise, make this a function or a procedure so you can call it from where ever you want. As function can be completely written in pl/sql you should be okay ... -- this is a procedure ... create or replace PROCEDURE dbp_calc_fin_qtr (pi_date in date, po_qtr number, po_year out number) is nCurrQtr pls_integer := to_number(to_char(pi_date,'Q')); nFinQtr pls_integer := 0; nFinYear pls_integer := to_number(to_char(pi_date,'')); begin if nCurrQtr in (1,2) then nFinQtr := nCurrQtr + 2; else nFinQtr := nCurrQtr - 2; nFinYear := nFinYear + 1; end if; -- end dbp_calc_fin_qtr; / -- this functions returns following string ... -- QQ where QQ is financial qtr and is financial year create or replace FUNCTION dbp_calc_fin_qtryr (pi_date in date, po_qtr number, po_year out number) return varchar2 is nCurrQtr pls_integer := to_number(to_char(pi_date,'Q')); nFinQtr pls_integer := 0; nFinYear pls_integer := to_number(to_char(pi_date,'')); begin if nCurrQtr in (1,2) then nFinQtr := nCurrQtr + 2; else nFinQtr := nCurrQtr - 2; nFinYear := nFinYear + 1; end if; -- return (to_char(nFinQtr,'09') || to_char(nFinYear)); -- end dbp_calc_fin_qtryr; / 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- [ mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] ] Sent: Wednesday, July 02, 2003 4:06 PM To: Multiple recipients of list ORACLE-L Hi George, With this solution you can only find Quarter number. but I also need Year of that quarter number. when you say to_char(date,'Q'), it might go next year or stay in current fiscal year depending on number of months we add to the date. Thanks, Surendra -Original Message- Sent: Wednesday, July 02, 2003 12:56 PM To: Multiple recipients of list ORACLE-L You don't need CASE. try : to_char( date , 'Q') George Hello ALL, I am trying to find quarter number from a given date . Here is the description Our Financial year runs from July thru June. So, Given any date between these dates I need to find 3 quarters(9 months) from it. July -Sep - 1st Quarter Oct -Dec - 2nd Quarter Jan -Mar - 3rd Quarter Apr -Jun - 4th Quarter I got this done using the following Select select decode(to_char(add_months(sysdate,9),'Q'), '1','3', '2','4', '3','1', '4','2', '') Decode function is used to change calender quarter to our Quarter. But I am unable to find the Year for that quarter. I was using Case statement to solve my problem,as below Select case when decode(to_char(add_months(sysdate,9),'Q'), '1','3', '2','4', '3','1', '4','2', '') 3 then to_number(to_char(main_rec.termination_date,''''))+1 else to_number(to_char(main_rec.termination_date,'''')) P.S The reason for 3 condition check in CASE Statement is, if a sysdate+9months falls in next Financial year , I need to change Year accordingly. But,this works only in SQL, in Procedures, i cannot do this using CASE Statement Can anybody give some ideas on how to approach this?. I have to use this in a cursor (not in the body of my procedure, so condition checking like If then else after fetching year is not possible) Any help would be greatly appreciated. Thanks, Surendra
RE: CASE in PL/SQL
Title: RE: CASE in PL/SQL Can you at-least _show_ us what you are doing, what you want to do and where the code is failing? We are shooting in the dark here .. Like I mentioned before, youcan _always_ use SQL to assign values to pl/sql variables. 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: Wednesday, July 02, 2003 6:11 PMTo: Multiple recipients of list ORACLE-LSubject: RE: CASE in PL/SQL I am already using it that way, but giving that condition in cursor is not possible. Thanks for your help. Surendra *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
grant for package body
Hi , what prvilage ( role ) canlet other schemas (users) to see package body in my schema . without giving "select_catalog_role" thanks, -ak
LINUX instance startup problem
Hi, I'm having problem during startup of instance on LINUX.I have oracle 8.1.7 on red hat. When I start instance it try to come upto this below lines background_dump_dest = user_dump_dest = core_dump_dest = after that I'm getting following message SVRMGR connect internal; Connected. SVRMGR startup; ORA-03113: end-of-file on communication channel SVRMGR connect internal; Password: ORA-03113: end-of-file on communication channel SVRMGR When I see semaphore and shared memory.Its locked.I'm unable to get into server manager without killing all shared mem process. Let me know how to fix this problem pl thx -seema _ MSN 8 with e-mail virus protection service: 2 months FREE* http://join.msn.com/?page=features/virus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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 Technology Champion OTC
Peter: I am the OTC for both the eBusiness Suite and Technology tracks. If you know the products, you are 50% there. To pass the exams, you have to think like Oracle. Sounds silly, but there are some very-non technical portions of the exam that highlight product competitive issues against IBM and others. If you need specifics, call me. BTW: Say Hi to Stan Yellott for me. Tell him little FAM says HI Thank You Stephen P. Karniotis Strategic Alliance Manager Compuware Corporation Direct: (313) 227-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web:www.compuware.com -Original Message- Sent: Wednesday, July 02, 2003 11:59 PM To: Multiple recipients of list ORACLE-L Subject:Oracle Technology Champion OTC Hi has anyone sat the OTC exam before and did they find it difficult Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = A great pleasure in life is doing what people say you cannot do. - Walter Bagehot (1826-1877 British Economist) = Mincom The People, The Experience, The Vision = This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. -- 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). The contents of this e-mail are intended for the named addressee only. It contains information that may be confidential. Unless you are the named addressee or an authorized designee, you may not copy or use it, or disclose it to anyone else. If you received it in error please notify us immediately and then destroy it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Karniotis, Stephen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: grant for package body
User X creates a package. You want user Y to be able to see the package body by querying ALL_SOURCE. The privilege needed by Y would be create any procedure. Or you can create a procedure owned by X that Y can run to retrieve the header and body source code of a package. -Original Message- Sent: jeudi, 3. juillet 2003 11:59 To: Multiple recipients of list ORACLE-L Hi , what prvilage ( role ) can let other schemas (users) to see package body in my schema . without giving select_catalog_role thanks, -ak -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jacques Kilchoer INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: How to install Oracle JVM on Oracle 8.1.7.
These metalink URLs may help: ORA KB for db-JVM How to Tell if Java Virtual Machine Has Been Installed Correctly HTH, -Roy Roy PardeeProgrammer/Analyst/DBASWFPAC Lockheed Martin ITExtension 8487-Original Message-From: Nirmal Kumar M [mailto:[EMAIL PROTECTED]]Sent: Thursday, July 03, 2003 7:16 AMTo: Multiple recipients of list ORACLE-LSubject: How to install Oracle JVM on Oracle 8.1.7.Hi all,I want to install, oracle JVM on oracle 817 databaserunning on NT2000 server.I hope that initjvm.sql script has to be run under syslogin. However i can't able to find that script filein my oracle home path %ORACLE_HOME%\RDBMS\ADMIN.Let know how to proceed futher and what are the prerequisities and post requiesties for thisintallation?.Thanks.Nirmal,.=fsdfsdfsdfsdfs__Do you Yahoo!?SBC Yahoo! DSL - Now only $29.95 per month!http://sbc.yahoo.com--Please see the official ORACLE-L FAQ: http://www.orafaq.net--Author: Nirmal Kumar M 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: How to install Oracle JVM on Oracle 8.1.7.
Hi Try oracle:venus cd $ORACLE_HOME oracle:venus find . -name initjvm.sql -print 2/dev/null ./javavm/install/initjvm.sql kind regards Pete I hope that initjvm.sql script has to be run under sys login. However i can't able to find that script file in my oracle home path %ORACLE_HOME%\RDBMS\ADMIN. -- Pete Finnigan email:[EMAIL PROTECTED] Web site: http://www.petefinnigan.com - Oracle security audit specialists Book:Oracle security step-by-step Guide - see http://store.sans.org for details. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Finnigan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: How to install Oracle JVM on Oracle 8.1.7.
This was taken from my build db script. Most of it is from MetaLink Doc's. REM Scripts needed for JVM version 8.1.5 REM ~ REM @?/javavm/install/initjvm.sql -- Setup a database for running Java and the ORB REM REM Scripts needed for JVM version 8.1.6 REM ~ REM @?/javavm/install/initjvm.sql -- Setup a database for running Java and the ORB REM @?/rdbms/admin/initplsj.sql-- Initializes Java library needed by PL/SQL REM @?/rdbms/admin/initaqjms.sql -- Load AQ/JMS jar files into the database REM @?/rdbms/admin/initrepapi.sql -- Load RepAPI server classes and publish 'repapi' obj REM REM Scripts needed for JVM version 8.1.7 REM ~ @?/javavm/install/initjvm.sql -- Setup a database for running Java and the ORB @?/oracore/admin/initxml.sql -- Loads xml components into the JServer @?/rdbms/admin/catxsu.sql -- loads the XMLSQL Utility (XSU) into the database @?/javavm/install/init_jis.sql -- JIS (OSE) installation @?/javavm/install/jisja.sql-- Turn on JAccelerator (ncomp) for JIS @?/javavm/install/jisaephc.sql -- Adds the set of default end points to the server -- with hardcoded values for the admin service @?/rdbms/admin/initplgs.sql-- Load PLSQL Gateway Servlet jar files into the database @?/jsp/install/initjsp.sql -- Install Oracle JSP @?/jsp/install/jspja.sql -- Turn on JAccelerator for JSP libs @?/rdbms/admin/initplsj.sql-- Initializes Java library needed by PL/SQL @?/rdbms/admin/initjms.sql -- Load AQ/JMS jar files into the database @?/rdbms/admin/initrepapi.sql -- Load RepAPI server classes and publish 'repapi' obj @?/rdbms/admin/initsoxx.sql-- loads sql, objects, extensibility and xml related java REM REM Note: Run the following at your own risk. REM @?/javavm/install/jisaep admin 8080 9090 -- Configure OSE defauls admin Web Service REM REM END~OF~JAVA~SCRIPTS AK [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] .comcc: Sent by: Subject: Re: How to install Oracle JVM on Oracle 8.1.7. [EMAIL PROTECTED] .com 07/03/2003 12:34 PM Please respond to ORACLE-L Look in $ORACLE_HOME\javavm\install\initjvm.sql -ak - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, July 03, 2003 7:15 AM Hi all, I want to install, oracle JVM on oracle 817 database running on NT2000 server. I hope that initjvm.sql script has to be run under sys login. However i can't able to find that script file in my oracle home path %ORACLE_HOME%\RDBMS\ADMIN. Let know how to proceed futher and what are the pre requisities and post requiesties for this intallation?. Thanks. Nirmal,. -- 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
RE: ODS and data modeling
Title: Message Thanks, Using one code tableis easier to manage from a development point of view but it prevents using referential integrity in the database, that's my main concern. 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] -Original Message-From: Tierstein, Leslie [mailto:[EMAIL PROTECTED]Sent: Thursday, July 03, 2003 11:42 AMTo: '[EMAIL PROTECTED]'Cc: '[EMAIL PROTECTED]'Subject: RE: ODS and data modeling Handling codes in one table via separate tables has been extensively discussed in development-oriented lists. The consensus falls heavily on having one single table -- it is much easier to manage. For example, you only need one fairly simplemaintenance form to allow users to maintain/view the code values. SampleDESC for one physical table which holds multiple logical code tables: SQL desc cn_codesName Null? Type- ---CODE_IDNOT NULL NUMBER(10)ACTIVE_INDNOT NULL VARCHAR2(1)CODE_SHORT_DESC_TXTNOT NULL VARCHAR2(70)CODE_TABLE_NMNOT NULL VARCHAR2(30) -- logical code table nameCODE_VALUE_CDNOT NULL VARCHAR2(15) -- logical code valueCREATE_DTNOT NULL DATECREATE_USER_NMNOT NULL VARCHAR2(12)MOD_DTNOT NULL DATEMOD_USER_NM NOT NULL VARCHAR2(12)CODE_LONG_DESC_TXT VARCHAR2(1000)TABLE_SPECIFIC_TXTVARCHAR2(40)DISPLAY_SEQ_NBR NUMBER(3) Couple of notes on the above: (1) Above table definition includes artificial, sequence-generated PK, which is recommeded for DW or ODS, given issues with changing dimensions. (2) Don't know if you will want just an Active indicator or a range of dates in which the particular code is active. (3) OLTP system needs additional information about codes, stored in table_specific_txt; might not be required in ODS/DW environment. (4) Specific definition of table_specific_txt, and a definitive list of all the code tables is contained in another logical table, which could be another code table or stored elsewhere. (5) If required, very easy to create views on top of the above, to hide the physical table from developers. -Original Message-From: Stephane Paquette [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 02, 2003 4:56 PMTo: Multiple recipients of list ORACLE-LSubject: ODS and data modeling Hi all, I'm doing the data model for an Operational Data Store. The ODS will serve to consolidate data from many operational systems and mainly from a new ERP, then most of the data will go in an existing data warehouse. I've worked with datawarehouses before but never withODS. I've check about Bill Inmon and at IBM red book site on the web. Any other good site on ODS ? Also, what are your arguments when choosing between1 table handling all codes or having a table for each code. TIA 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]
RE: LINUX instance startup problem
What version of Red Hat? --Walt -Original Message- From: Seema Singh [mailto:[EMAIL PROTECTED] Sent: Thursday, July 03, 2003 1:09 PM To: Multiple recipients of list ORACLE-L Subject: LINUX instance startup problem Hi, I'm having problem during startup of instance on LINUX.I have oracle 8.1.7 on red hat. When I start instance it try to come upto this below lines background_dump_dest = user_dump_dest = core_dump_dest = after that I'm getting following message SVRMGR connect internal; Connected. SVRMGR startup; ORA-03113: end-of-file on communication channel SVRMGR connect internal; Password: ORA-03113: end-of-file on communication channel SVRMGR When I see semaphore and shared memory.Its locked.I'm unable to get into server manager without killing all shared mem process. Let me know how to fix this problem pl thx -seema _ MSN 8 with e-mail virus protection service: 2 months FREE* http://join.msn.com/?page=features/virus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Weaver, Walt INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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] OT List
Clearly a lot of what I say is at best tangential to Oracle. I see there is an OT list, all I would belooking for is the subscription instructions and then hopefully (incompetence and confusion permitting) I'll direct OT stuff to the OT list. Cheers Niall -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Niall Litchfield INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Microsoft VS Oracle (again)
Hey, you beat me to it. We also did that. The issue I had with the db admin class was nothing to do with admin tasks (whih are pretty simple) but the whole now hif you measure x,y and z (including ratios :( ) then you can see that there is a performance issue. Me: So then what do you do? Ans: Ah well you will need to attend the developers class for that where they go through things like explain plan etc. GRRR. As if developers optimize code :( Niall P.S. Nice to see you here Nuno. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of david davis Sent: 03 July 2003 01:01 To: Multiple recipients of list ORACLE-L Subject: Re: Microsoft VS Oracle (again) Well, I am not particularly fond of SQL Server, but it does point in time recovery and online recovery. At least we did it in the DB Admin class for SQL Server 2000. Docn isn't that great (except maybe the IT Professional series). From: Nuno Souto [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: Microsoft VS Oracle (again) Date: Tue, 01 Jul 2003 23:45:30 -0800 - Original Message - Any comments? Yes. got that one last year. Still got it. Installed the doco in my PC at work so I could read it in peace and quiet (!). Installed the s/w as well so I could play with it. Went straight to their recovery manual. Basically, it reads like this: restore all db files apply saved logs No partial recovery, no online recovery, no PITR, nothing. Put me off the whole thing straight away. But if I may quote dubya: make no mistake, they'll fix it. And then it will be quite interesting... 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). _ MSN 8 with e-mail virus protection service: 2 months FREE* http://join.msn.com/?page=features/virus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: david davis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Niall Litchfield INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: grant for package body
create any procedure 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: AK [mailto:[EMAIL PROTECTED]Sent: Thursday, July 03, 2003 2:59 PMTo: Multiple recipients of list ORACLE-LSubject: grant for package body Hi , what prvilage ( role ) canlet other schemas (users) to see package body in my schema . without giving "select_catalog_role" thanks, -ak *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: How to install Oracle JVM on Oracle 8.1.7.
Hi... your initjvm.sql is under: $ORACLE_HOME/javavm/install HTH JL I hope that initjvm.sql script has to be run under sys login. However i can't able to find that script file in my oracle home path %ORACLE_HOME%\RDBMS\ADMIN. __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jose Luis Delgado INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Do Not Call
It could be Oracle running on unix--all we know for sure is that the web server is a windows box. I assume that even if the web server was a unix box, it could be hitting a database (of whatever stripe) that ran on windows... Roy Pardee Programmer/Analyst/DBA SWFPAC Lockheed Martin IT Extension 8487 -Original Message- Sent: Tuesday, July 01, 2003 12:10 PM To: Multiple recipients of list ORACLE-L http://uptime.netcraft.com/up/graph/?host=www.donotcall.gov Well, if it were unix then it couldn't be SQLserver. It is Windows, therefore I assume its SQLserver, but it could be Oracle. But who runs Oracle on Windows anyway *hahahaha* [EMAIL PROTECTED] 07/01/03 02:29PM Paradox for DOS -Original Message- Sent: Tuesday, July 01, 2003 2:00 PM To: Multiple recipients of list ORACLE-L There have been over 10,000,000 entries made in the National Do Not Call Registry since Friday June 27. Does anyone know the database engine in which this is stored? Curious in Bozeman, MT -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Pardee, Roy E INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Script to check filename continuously
Here is a start for you. You can get the sleep command at any of these places http://www.weihenstephan.de/~syring/win32/UnxUtils.html http://www.cruzio.com/~jeffl/mrtg/docs/sleep.exe http://www.nextgeneration.dk/gnu/index.shtml @ECHO OFF set BASE_DIR=d:\oracle\oradata\sid\archive set BASE_FILE=*.arc set RMT_DIR=x:\rmt_path :LOOP for /F %%T In ('dir %BASE_FILE% /B /O:-N') Do ( copy %%T %RMT_DIR%\%%T ) sleep 5 GOTO LOOP Saminathan_Seeran [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED]Subject: Script to check filename continuously .com 07/03/2003 03:30 AM Please respond to ORACLE-L Hi All Does anyone have script(DOS batch file or Unix Shell) to do the following stuff? loop if exist FILE_NAME begin do something; copy files to remote machine,etc... EXIT; end; end loop; Thanks Sami -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: How to install Oracle JVM on Oracle 8.1.7.
Hi, You can follow metalink note 156477.1 which describes the detailed steps of installing JVM manually. Hope this helps. Regards, Inder -Original Message- Sent: Thursday, July 03, 2003 4:20 PM To: Multiple recipients of list ORACLE-L Hi Try oracle:venus cd $ORACLE_HOME oracle:venus find . -name initjvm.sql -print 2/dev/null ./javavm/install/initjvm.sql kind regards Pete I hope that initjvm.sql script has to be run under sys login. However i can't able to find that script file in my oracle home path %ORACLE_HOME%\RDBMS\ADMIN. -- Pete Finnigan email:[EMAIL PROTECTED] Web site: http://www.petefinnigan.com - Oracle security audit specialists Book:Oracle security step-by-step Guide - see http://store.sans.org for details. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Finnigan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Singh Pushpinder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ODS and data modeling
Title: Message I agree with Stephane ... 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: Stephane Paquette [mailto:[EMAIL PROTECTED]Sent: Thursday, July 03, 2003 4:49 PMTo: Multiple recipients of list ORACLE-LSubject: RE: ODS and data modeling Thanks, Using one code tableis easier to manage from a development point of view but it prevents using referential integrity in the database, that's my main concern. 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] 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: [OT] OT List
Head on over to http://groups.yahoo.com/group/oracle-l-ot/ Jared On Thursday 03 July 2003 13:59, Niall Litchfield wrote: Clearly a lot of what I say is at best tangential to Oracle. I see there is an OT list, all I would belooking for is the subscription instructions and then hopefully (incompetence and confusion permitting) I'll direct OT stuff to the OT list. Cheers Niall -- 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: Need to get the output of a column with its column name in as rows
One way to do this is to write an PL/SQL block and use utl_file package Guang -Original Message- [EMAIL PROTECTED] Sent: Thursday, July 03, 2003 4:21 AM To: Multiple recipients of list ORACLE-L rows Hi Have the following table columns curvedetails_id, curve_id, curvedetails_date, p0030, p0100, p0130, p0200, p0230, p0300, p0330, I need to do a query that does the following output CurveId ,CurveDate, PNumber, PReading 206116, 31-Dec-2002, P0030, 26.18 206116, 31-Dec-2002,P0100, 8.80 where the pnumber column is the column name in the table Is there anyway to get this without using a whole bunch of unions Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = A great pleasure in life is doing what people say you cannot do. - Walter Bagehot (1826-1877 British Economist) = Mincom The People, The Experience, The Vision = This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. -- 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: Guang Mei INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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 9 on redhat 9...kernal settings
Unless you've run into errors requiring adjustment of these parameters, don't bother with them. I've run 4 databases on a 2Gig RAM RH 7.1 box without ever touching these. Modifying them requires rebuilding the kernel, which can be quite a hassle. It also invalidates Oracle support on linux. Jared John Dunn [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/03/2003 01:54 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Oracle 9 on redhat 9...kernal settings I have 512 MB RAM in my Redhat Linux intel machine running Oracle 9. What should I set the Kernal parameters to. shmmax, shmmni, shmall, sem JD -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Dunn INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: CACHE/NOCACHE
Ravi, The DB Buffer cache 'aging' algorithm has changed in 8.1.x - it is now based on a touch count algorithm. If the table is not updated and is frequently accessed, it will continue to remain in the Buffer cache, whether it is NOCACHE or not. Figuring out performance problems should usually start with looking at wait events, rather than the buffer cache. the 'Oracle Performance Tuning 101' book by Gaja Vaidyanatha and Kirti Deshpande of this list should be you first stop! John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 I don't know what the future holds for me, but I do know who holds my future! ** The opinions and statements above are entirely my own and not those of my employer or clients ** -Original Message- From: Ravi Kulkarni [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 02, 2003 4:41 PM To: Multiple recipients of list ORACLE-L Subject: CACHE/NOCACHE Gurus, Reposting.. since this might have got lost in emails. Any thoughts...? Thanks, -Ravi. .. Help me figure this one out. Was helping a colleague diagnose slow response time (8.1.7/Solaris running Peoplesoft ). x$bh showed 102,248 out of 170,000 buffers belonged to a single table, which he said he cached explicitly. He did NOCACHE (on my suggestion) on the large table. I still find that the table is in buffer cache (even Buff# haven't changed - starts with buf#=1 - not sure if this means LRU end) even after a week. DB cannot be bounced since it is production. Do you know of any reason why it is not flushed out of cache when table is altered to NoCache? Thanks, Ravi. .. __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ravi Kulkarni INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: cannot disable or drop the ON DATABASE trigger !!!!
Are you sure that you created the trigger on sys schema? with the sys user? I got something similar when, by mistake, I created a logon trigger on another schema... with another username I whould check: select owner, object_name, object_type, status from dba_objects where object_name = 'DDL_TRIGGER' HTH JL --- rahul sharma [EMAIL PROTECTED] wrote: Help list... i have created the following in 8.1.5 instance CREATE OR REPLACE TRIGGER DDL_TRIGGER BEFORE CREATE OR ALTER OR DROP ON DATABASE BEGIN null; END; / and now i cannot drop or disable this trigger ERROR at line 1: ORA-04045: errors during recompilation/revalidation of SYS.DDL_TRIGGER i'm loggin into svrmgrl and connecting as internal to try drop or disable.. is this a bug ?? TIA Rahul.. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: rahul sharma INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jose Luis Delgado INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: calling an external procedure
Title: RE: calling an external procedure There are also some security advisories related to extprocs ... so read them as well. 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: Goulet, Dick [mailto:[EMAIL PROTECTED]] Sent: Thursday, July 03, 2003 9:56 AM To: Multiple recipients of list ORACLE-L Subject: RE: calling an external procedure Frank, You've got the TNSNAMES and Listener entries fouled up. Here are the ones I use, the critical Keys are marked: TNSNAMES: extproc_connection_data.world = (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC) (KEY = extproc_agent) --- Key1 ) (CONNECT_DATA = (SID = 11) --- Key2 (server=dedicated)) ) Listener: EXTPROC_LISTENER = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC) (KEY = extproc_agent) Key1 ) ) SID_LIST_EXTPROC_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = 11) Key2 (ORACLE_HOME = /ora1/81764) (PROGRAM = extproc) ) ) BTW: Oracle's recommendation is to use a seperate listener for extproc calls. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Thursday, July 03, 2003 8:26 AM To: Multiple recipients of list ORACLE-L Hi all, before I smash my head against the wall.. I am trying to execute an external procedure defined in a C .dll. I have set up my tnsnames/listener.ora as following : --- # C:\ORANT\NET80\ADMIN\TNSNAMES.ORA Configurationfile :C:\ORANT\net80\admin\tnsnames.ora # Generated by Oracle Net8 Assistant Tcp-loopback.world = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (Host = 127.0.0.1) (Port = 1521) ) ) (CONNECT_DATA = (SID = ORCL) ) ) extproc_connection_data.world = (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC) (KEY = ORCL) ) (CONNECT_DATA = (SID = extproc) ) ) # C:\ORANT\NET80\ADMIN\LISTENER.ORA Configuration File:C:\ORANT\net80\admin\listener.ora # Generated by Oracle Net8 Assistant LISTENER = (ADDRESS_LIST = (ADDRESS= (PROTOCOL= IPC) (KEY= oracle.world) ) (ADDRESS= (PROTOCOL= IPC) (KEY= ORCL) ) (ADDRESS= (PROTOCOL= TCP) (Host= ff1) (Port= 1521) ) (ADDRESS= (PROTOCOL= TCP) (Host= ff1) (Port= 1526) ) (ADDRESS= (PROTOCOL= SPX) (Service= inventory_lsnr) ) (ADDRESS= (PROTOCOL= NMP) (SERVER= nt_inventory_box) (PIPE= ORAPIPE) ) ) STARTUP_WAIT_TIME_LISTENER = 0 CONNECT_TIMEOUT_LISTENER = 10 SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = ff1) (SID_NAME = ORCL) ) (SID_DESC = (SID_NAME = extproc) (PROGRAM=extproc) (ORACLE_HOME=$ORACLE_HOME) ) ) LOG_DIRECTORY_LISTENER = c:\orant\net80\trace TRACE_DIRECTORY_LISTENER = c:\orant\net80\trace TRACE_LEVEL_LISTENER = admin The plsql test code is : drop library zPrintString; create library zPrintString as 'c:/newsys/bin/PrintString.dll'; select * from user_libraries; create or replace procedure PrintString (OutPutString IN VARCHAR2) as external Library zPrintString name zPrintString parameters (OutPutString STRING); begin execute PrintString('testing'); end; -- Oracle tells me, that it is not able, to loead the dll. Error message is : ORA-06520: PL/SQL: Error loading external library ORA-06522: Unable to load DLL ORA-06512: at SYS.PRINTSTRING, line 0 ORA-06512: at line 2 -- is anyone able, to help ? TNX Frank Confidentiality Notes This email and any files transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. If you are not the authorised recipient, any use, disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited. If you received this in error, please contact the sender and delete the material from any computer. E-mail messages are not necessarily secure. Scheidt Bachmann does not accept responsibility for any changes made to this message after it was sent. Thank you for your cooperation! Diese E-Mail und alle angehängten Dateien ist ausschließlich für die Person / Personen bestimmt, an die diese adressiert ist und könnte vertrauliche und / oder rechtlich geschützte Informationen enthalten. Sollten Sie nicht der für diese E-Mail bestimmte Adressat oder nicht zum Empfang berechtigt sein, ist Ihnen jeder Gebrauch, sowie jede Veröffentlichung, Vervielfältigung oder Weitergabe wie auch das Ergreifen oder Unterlassen von Maßnahmen im Vertrauen auf erlangte Information untersagt. Sollten
RE: Script to check filename continuously
Script would be good for this kind of thing, I think. Dig how similar this windows scripting host script is to your pseudocode: ' Dim FSO Const WatchForFile = c:\pretend.txt Const CopyFileTo = c:\copied.txt Set FSO = CreateObject(Scripting.FileSystemObject) Do While True If FSO.FileExists(WatchForFile) Then WScript.Echo Found WatchForFile ! Copying... Call FSO.CopyFile(WatchForFile, CopyFileTo) Exit Do Else WScript.Echo Still no WatchForFile --going to sleep for 10 seconds... WScript.Sleep 1 End If Loop Set FSO = Nothing WScript.Echo Finished running WScript.ScriptFullName ' Save that off to a text file w/extension .vbs execute it at the command line by typing cscript filename.vbs. There's documentation for the windows scripting host at http://www.microsoft.com/scripting. HTH, -Roy Roy Pardee Programmer/Analyst/DBA SWFPAC Lockheed Martin IT Extension 8487 -Original Message- Sent: Thursday, July 03, 2003 3:31 AM To: Multiple recipients of list ORACLE-L Hi All Does anyone have script(DOS batch file or Unix Shell) to do the following stuff? loop if exist FILE_NAME begin do something; copy files to remote machine,etc... EXIT; end; end loop; Thanks Sami -- 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: Pardee, Roy E INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Redo Copy Latch contention ??
You can still tune the buffers, you just don't need BCHR to do it. See http://www.ixora.com.au/scripts/sql/ideal_cache_size.sql and http://www.ixora.com.au/newsletter/2001_03.htm I've procedurized this script to run from dbms_jobs every 15 minutes. Two reports are used to give current buffer size, ideal buffers average and ideal buffers max. One does an aggregate of the whole enchilada, the other breaks it down into weekly aggregates. The whole set of files is at http://www.cybcon.com/~jkstill/util/zips/idcs.tgz Jared Mladen Gogala [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/02/2003 07:50 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: Redo Copy Latch contention ?? You are probably right but it was good to have V6-type control over the mechanism. log_simultaneous_copies, log_small_entry_max_size (maximum number of characters that was allocated when allocation latch was acquired) and log_entry_prebuild_threshold (the size of redo after which the user process was building redo entries, instead of LGWR) were easy to understand and maintain. These days, I have no control. Do you remember X$KCBCH tables (I'm not sure about the spelling of this one) that was helping you compute hit ratio if there were few more block buffers? World certainly was simpler before you and Cary destroyed the hit ratio. Shame on you :)! On 2003.07.02 22:24, Anjo Kolk wrote: Wrong alert in HP Open view (you can configure that) and (again) ignoring other more relevant performance information ('High CPU usage'). I have never seen a system where tuning the redo copy latches made a huge improvement in performance. Anjo. -- Mladen Gogala Oracle DBA -- 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: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
* Sr. Oracle DBA with 8i and 9i experience needed..
Minneapolis, Minnesota company has a great opportunity available for a Sr. level Oracle DBA to join their IT staff. The selected candidate must be highly skilled in solving extremely complex and very critical customer issues. With preferably over 10 years experience in a large-scale multi-network open-systems environment, the candidate anticipates and plans for reliability, availability, and serviceability in the design, development and implementation of Oracle 8i and 9i solutions. The candidate will be recognized as a technical authority in the design, analysis, implementation and integration of large-scale database management systems. Candidates local to the Minneapolis area are preferred, but any candidate who meets the qualifications for the position will be considered. Base Salary is in the 85-100K range plus bonus. PLEASE Do Not send your resume for this position UNLESS you have the skills outlined below for this position. Please Do Not send your resume unless you have a stable work history. Candidates whose work history includes frequent job changes connot be considered. This is a full time staff position so no sub-contractors or third parties please. NO H-1B candidates please. *MUST meet these requirements: -BS degree in CS or related field. -8-10 years experience in a large-scale multi-network open-systems environment. -Very solid Oracle DBA experience..including 8i and 9i. -Proficient at capacity monitoring and management capabilities, preferably an expert knowledge of Enterprise Manager 9i (OEM), and STATSPACK. -Experience performing Oracle installations, upgrades, and supporting Oracle utilities and services in a variety of operating systems (Solaris, NT, Linux) is required. -Migration and upgrade experience is essential. -Expert knowledge of on-line back-up/recovery procedures with snapshotting a plus. -Proficiency with RMAN is essential. -Ability to work with engineering staff to configure SAN storage for optimal Oracle performance. -Expert knowledge of UNIX scripting including CRON Jobs, Oracle Stored Procedures, Triggers, Packages, Real Application Clusters (RAC). -Performance Tuning and Performance management skills are required, SQL*Plus, PL/SQL, SQL*Loader, SQL, and UNIX. -The applicant must have in-depth experience with ER diagramming, data modeling tools, (erWIN preferred) normalization, de-normalization, database programming and design, query optimization, index optimization, use of hints. Optimal setup of dblink, views, and use of Oracle gateway is required. Must understand how to design and tune an Oracle database to optimize performance for potentially thousands of concurrent, browser-based users together with ETL processes. -Excellent written and verbal communications skills with the ability to effectively communicate technical and business problems/issues in a non-technical manner, strong problem resolution, analysis, and customer service skills are required. -Ability to manage multiple tasks with shifting priorities is a necessity. -Ability to work within a team environment and communicate effectively with other team members is required. -Proven mentoring skills to build the strength of the DBA staff. For immediate consideration, please email your resume as an attachment to: OraStaff, Inc. Email: [EMAIL PROTECTED] Please Use Job Code: Minn./DBA/MH Phone: 1-800-549-8502. I pay referral fees. So please contact me if you know of anyone who would be qualified/interested in the position described above- if it is not a match for your skills. Thanks. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: OraStaff INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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: Should percent increase higher than 0 in 817?
Don't know. I bet Dan Fink does. He's in the air right now on his way to Portland, so I guess he won't be answering this. I can ask him at lunch. :) Jared Ryan [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/02/2003 03:50 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: RE: Should percent increase higher than 0 in 817? does the 32k limit hold in 9i with undo tablespaces? - Original Message - To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Wednesday, July 02, 2003 5:31 PM Due to bugs and limitations in the internal structure of rollback segments. ie. they aren't allowed more than 32k extents. See MetaLink note 50380.1 Jared [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/02/2003 01:55 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: RE: Should percent increase higher than 0 in 817? i read this somewhere. why is it a bad idea to use maxextents unlimited in your rollback tablespaces? From: Goulet, Dick [EMAIL PROTECTED] Date: 2003/07/02 Wed PM 04:40:45 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: Should percent increase higher than 0 in 817? Guang, In temp I really don't watch anything. In Rollback I watch for segments that are approaching maxextents and just plain running out of space. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Wednesday, July 02, 2003 3:51 PM To: Multiple recipients of list ORACLE-L What are the things that we should be monitoring in ROLLBACK or TEMP tablespace? So far I don't have any script to monitor ROLLBACK or TEMP (havn't had any problem though). I too thought Oracle would take care of rollback and temp ts space management. Right or wrong? Guang -Original Message- Kirtikumar Deshpande Sent: Wednesday, July 02, 2003 2:16 PM To: Multiple recipients of list ORACLE-L After we rolled out our own scripts to monitor TS usage (de-Installing BMC Patrol) following is a line from a Very Senior DBA's email sent to us (not-so-senior-DBA-team-members) yesterday: I don't think the script should monitor ROLLBACK or TEMP tablespace for space issues - these normally resolve themselves (I will surely get in trouble when my co-workers see this post, but what the heck.. We will get outsourced soon anyway);) BTW, the VSDBA supports 8.1.7.4 databases. - Kirti --- Goulet, Dick [EMAIL PROTECTED] wrote: That's OK, I know a couple who never heard of optimal and/or organization index either. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Tuesday, July 01, 2003 7:14 PM To: Multiple recipients of list ORACLE-L I saw a Sr. DBA few years ago, who claimed he had worked with Oracle since V4.0, and he didn't have a clue what PCTINCREASE is... Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, July 01, 2003 11:51 PM What about ones that you don't know? Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message- Sent: Tuesday, July 01, 2003 4:11 PM To: Multiple recipients of list ORACLE-L PCTINCREASE is a bad good thing. Every DBA that I know of hunts down objects with a pctincrease other than 0 and resets them. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Guang Mei INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list,
Re[4]: Online tech books
Thursday, July 3, 2003, 8:25:54 AM, you wrote: TW is there a way to put tech books online? what about a web site you'd pay a TW fee to use? i'd really like to have such a thing. [can't grep dead TW trees.;-)] is this possible? See: http://safari.oreilly.com You can even register for a free trial: https://secure.safaribooksonline.com/promo.asp?code=ORA14portal=oreillyCMP=IL13759 Not only are O'Reilly books available from Safari, but so are most of Pearson's current titles. Pearson is Addison-Wesley, Prentice-Hall, SAMS, and a whole bunch of other imprints. 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).
Re: cannot disable or drop the ON DATABASE trigger !!!!
At first glance it appears that you have created a self referencing trigger. You can't drop it, because dropping it fires the trigger. Check metalink, open a TAR, etc. Jared rahul sharma [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/03/2003 03:40 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:cannot disable or drop the ON DATABASE trigger Help list... i have created the following in 8.1.5 instance CREATE OR REPLACE TRIGGER DDL_TRIGGER BEFORE CREATE OR ALTER OR DROP ON DATABASE BEGIN null; END; / and now i cannot drop or disable this trigger ERROR at line 1: ORA-04045: errors during recompilation/revalidation of SYS.DDL_TRIGGER i'm loggin into svrmgrl and connecting as internal to try drop or disable.. is this a bug ?? TIA Rahul.. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: rahul sharma INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Performance
Stephane, I continue having the same problem, in LAB 2 minutes and in PRODUCTION forever. I made the changes you indicate me. This is the explain plan in LAB, NO STATISTICS with data from yesterday Execution Plan -- 0 SELECT STATEMENT Optimizer=CHOOSE 10 SORT (GROUP BY) 21 NESTED LOOPS 32 VIEW 43 SORT (GROUP BY) 54 TABLE ACCESS (BY INDEX ROWID) OF 'TCON_ACUM' 65 INDEX (RANGE SCAN) OF 'IDX_ACUM_02' (NON-UNIQUE) 72 TABLE ACCESS (BY INDEX ROWID) OF 'TCON_ACUM' 87 INDEX (RANGE SCAN) OF 'IDX_ACUM_02' (NON-UNIQUE) Statistics -- 0 recursive calls 0 db block gets 311 consistent gets 0 physical reads 0 redo size 353 bytes sent via SQL*Net to client 1159 bytes received via SQL*Net from client 3 SQL*Net roundtrips to/from client 2 sorts (memory) 0 sorts (disk) 1 rows processed - This the explain plan in PRODUCTION. Execution Plan -- 0 SELECT STATEMENT Optimizer=CHOOSE (Cost=9 Card=1 Bytes=53) 10 SORT (GROUP BY) (Cost=9 Card=1 Bytes=53) 21 NESTED LOOPS (Cost=7 Card=1 Bytes=53) 32 VIEW (Cost=6 Card=1 Bytes=15) 43 SORT (GROUP BY) (Cost=6 Card=1 Bytes=26) 54 TABLE ACCESS (FULL) OF 'TCON_ACUM' (Cost=4 Card=1 Bytes=26) 62 TABLE ACCESS (BY INDEX ROWID) OF 'TCON_ACUM' (Cost=2 C ard=1 Bytes=38) 76 INDEX (RANGE SCAN) OF 'IDX_ACUM_02' (NON-UNIQUE) (Co st=3 Card=1) Statistics -- 0 recursive calls 4 db block gets 108 consistent gets 0 physical reads 0 redo size 245 bytes sent via SQL*Net to client 981 bytes received via SQL*Net from client 3 SQL*Net roundtrips to/from client 2 sorts (memory) 0 sorts (disk) 1 rows processed Ramon E. Estevez [EMAIL PROTECTED] 809-535-8994 -Original Message- Stephane Faroult Sent: Tuesday, July 01, 2003 4:16 PM To: Multiple recipients of list ORACLE-L Ramon, I have had a closer look at your coe. My gut feeling is that SELECT MAX(A.ACM_FECACUM), Nvl(A.ACM_ACUMDBANT,0) - nvl(A.ACM_ACUMCRANT,0) + nvl(A.ACM_ACUMDB,0)- nvl(A.ACM_ACUMCR,0) into vFechaIni, vSaldoAnt from tcon_acum A, (select ACM_Oficina, ACM_Moneda, nvl(max(TRUNC(ACM_FECACUM)), '2001/01/01') MAXFECACUM FROM TCON_ACUM WHERE Acm_codigo = pCuenta AND ACM_Sucursal = i GROUP BY ACM_Oficina, ACM_Moneda) T where A.acm_codigo= pCuenta AND A.acm_sucursal = i AND T.ACM_Oficina = A.ACM_Oficina AND T.ACM_Moneda = A.ACM_MOneda AND TRUNC(A.ACM_FECACUM) = T.MAXFECACUM GROUP BY Nvl(A.ACM_ACUMDBANT,0), nvl(A.ACM_ACUMCRANT,0), nvl(A.ACM_ACUMDB,0),nvl(A.ACM_ACUMCR,0); nvl(A.ACM_ACUMDB,0),nvl(A.ACM_ACUMCR,0); would return the same thing as what you have, only faster. On first readin I had not noticed that you IN (SELECT ...) was correlated. Ouch. If ACM_CODIGO and ACM_SUCURSAL are indexed (and the index is discriminant enough), and if (ACM_OFICINA, ACM_MONEDA) are also separately indexed (with the same restriction as before), it should run reasonably fast. Ramon E. Estevez wrote: Tks Stephane and Madlen, Still the same problem. I added the hint /*+ FIRST_ROWS */ to the query that invoke the function and it changed from FTS to use Index but still have the same problem. I added the same hint to the function and Nothing. I checked the v$session_wait during the execution of the procedure and the only thing that Was waiting was SQL NET TO CLIENT MESSAGE. Ramon E. Estevez [EMAIL PROTECTED] 809-535-8994 -Original Message- Stephane Faroult Sent: Friday, June 27, 2003 6:15 PM To: Multiple recipients of list ORACLE-L Ramon, This is not a strange case at all; I find quite customary to see dazzling fast queries in a development environment crawl pathetically in production. My Spanish being reduced to some vague remnants of Latin (and just enough to understand the promotion of Mexican holiday resorts) I must confess
Re: sql loader question
Since direct path loads do an append, I would say the answer shown is incorrect. [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/03/2003 02:40 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:sql loader question Hello list I have a doubt regarding the following question : ** SQL*Loader reads a set of records from a file, generates INSERT commands, and passes them to the Oracle kernel. Oracle then finds places for those records in free blocks in the table and updates any associated indexes. Which SQL*Loader mode is used in this scenario? A. direct-path load B. conventional path load Answer : Direct-path load , ( It is said free blocks which implies Direct-Path Load, because Conventional-Path Load also use partially filled blocks. ) *** Shouldn't it be conventional path load, because insert commands are being used . Direct path load builds blocks of data in memory and saves these blocks directly into the extents allocated for the table being loaded -- 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: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: LISTENER ON LINUX
1521 and 1522 netstat 9i From: Gogala, Mladen [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: LISTENER ON LINUX Date: Wed, 02 Jul 2003 11:15:56 -0800 What is the port? How did you check that it wasn't used? Which distro, which version of the database? Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message- Sent: Wednesday, July 02, 2003 2:36 PM To: Multiple recipients of list ORACLE-L Hi, When I am trying to start listener on Linux box ,getting error TNS-12542: TNS:address already in use TNS-12560: TNS:protocol adapter error TNS-00512: Address already in use Linux Error: 98: Address already in use I checked no process fro listener and no port used by another process. Let me know how to fix that pl thx -Seema _ Help STOP SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 new MSN 8: smart spam protection and 2 months FREE* http://join.msn.com/?page=features/junkmail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: service name, sid ..
Hi! There's actually more: db_name - identifies database name, has to be the same what is stated in controlfile (using create database or create controlfile). You can have several databases with same db_name in one server, there is no restriction. SID - When we actually want to open and use the database, we have to start an instance whichwill be servicing the database. When starting instance, whe have to specify SID (system identifier) for it. This is actually just a operating system name for instance (or should I say SGA shared memory segments). As you know, SID is specified using ORACLE_SID OS environment variable and is only used by listener, when spawning new processesor when attaching directly to SGA using bequeath protocol. You can not have instances with same SID in one server, even if you use different oracle homes. instance_name - An Oracle parameter for specifying Oracle instance name. Seems that operating system doesn't know anything about it.For example, if you use SID_LIST parameters in your listener.ora, then listener always knows how to spawn processes for given SID, because (almost) all it takes to start another server process, is the location of oracle executable and SID value. But if you want to connect using instance name (not SID itself) then Oracle instance actually has to register itself with listener before any server processes can be spawned. Note that ORACLE_SID and instance_name variables do not have to match. (Tested on 9.2.0.1 on W2K). If my SID is ORCL for example and instance_name is TEST, then I can connect using both SID=ORCL and SID=TEST in CONNECT_DATA section of TNSNAMES (again, the instance name has to be registered with listener). V$INSTANCE still shows SID (ORCL) in instance name fielt. As we know, in OPS and RAC environment you could have several instances servicing one database, this is one ofcommon reasons why db_name and instance_name would be different. (ORCL for db_name, ORC0, ORC1, ORC2, etc.. for instance names for example). Btw, does anyone know if I can have the same instance name in all RAC nodes? RAC shouldn't care much, because it uses instance numbers anyway? service_names - this is an additionallayer for logically spreading work across nodes in RAC (and possibly other load balanced environments such replicated databases and even logical standby). For example, if you have 4 node RAC and have defined two "services" such OLTP and REPORTING, then you could assign OLTP for nodes and REPORTING for one, but during month end reporting you could still keep OLTP on 3 nodes, 1 node purely for REPORTING and add REPORTING to one or more OLTPs as well. So, when user's are connecting, they don't request a specific node or instance, they just request a service. And in load balancing environments then users are directed to instances, where appropriate service is defined. It gives somewhat flexibility, but I've never used it myself (thus my explanation here might wrong ;) Cheers, Tanel. - Original Message - From: AK To: Multiple recipients of list ORACLE-L Sent: Wednesday, July 02, 2003 9:49 PM Subject: service name, sid .. I am reading oracle network admin guide and getting confused abt service name, instance name , db name , sid .. why service name is not same as db name. Earlier service name and sid used to be same thing .. isn't it ( ? ) . Can some one clarify with some examples . TIA -ak
Re: Logical standby?
Even some of the MetaLink papers are buggy--I was advised to rely on the 9.2.0.2.0 docs. --- Stephane Faroult [EMAIL PROTECTED] wrote: Paul Baumgartel wrote: OK, I'm going to aim a little lower: is _anyone_ using Logical Standby? Any tips, gotchas, implementation accounts to share? TIA = Paul Baumgartel, Adept Computer Associates, Inc. [EMAIL PROTECTED] Paul, I am not using it but sometimes testing it. One gotcha : RENAME messes up everything (doesn't travel). Monitoring what happens (or doesn't) is extremely difficult. And if you don't automate the 22 step setup ... Also : don't use the doc, totally bug-ridden, but the Metalink papers. -- Regards, Stephane Faroult Oriole Software -- 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). __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: CASE in PL/SQL
Title: RE: CASE in PL/SQL I think I have clearly explained what I am doing/looking for in my original mail. As I have mentioned in one of the replies, I have posted same question in Metalink Forum and they gave me the exact/simple solution I am looking for. Here is below the conversation between me and OSS person. Anyway thank you all for your replies. Surendra Surendra, You could code: SQL SELECT (MOD(TO_NUMBER(TO_CHAR(add_months(sysdate,9),'Q'))+1,4) + 1) qtr 2 , DECODE(SIGN(TO_NUMBER(TO_CHAR(main_rec.termination_date,'Q')) - 3) 3 , -1, TO_NUMBER(TO_CHAR(main_rec.termination_date,'')) 4 , TO_NUMBER(TO_CHAR(main_rec.termination_date,'')) + 1) yr 5 ... 6 Here's a data sampling of the above: DT QTR YR -- -- -- Wed 1/9/2002 3 2002 Wed 3/6/2002 3 2002 Sat 3/30/2002 3 2002 Sun 4/7/2002 4 2002 Fri 5/17/2002 4 2002 Wed 6/26/2002 4 2002 Thu 7/4/2002 1 2003 Mon 9/30/2002 1 2003 Tue 10/8/2002 2 2003 Fri 12/27/2002 2 2003 Sat 1/4/2003 3 2003 Wed 2/5/2003 3 2003 Tue 3/25/2003 3 2003 Wed 4/2/2003 4 2003 Tue 5/20/2003 4 2003 Sun 6/29/2003 4 2003 Mon 7/7/2003 1 2004 Thu 9/25/2003 1 2004 Fri 10/3/2003 2 2004 Sat 10/11/2003 2 2004 Tue 12/30/2003 2 2004 Wed 1/7/2004 3 2004 Wed 3/3/2004 3 2004 Thu 3/11/2004 3 2004 HTH, T. From: Surendra Tirumala 02-Jul-03 19:44 Subject: Re : CASE in PL/SQL Hi Tebbe, "SELECT (MOD(TO_NUMBER(TO_CHAR(add_months(sysdate,9),'Q'))+1,4) + 1) qtr , DECODE(SIGN(TO_NUMBER(TO_CHAR(sysdate,'Q')) - 3) , -1, TO_NUMBER(TO_CHAR(sysdate,'')) , TO_NUMBER(TO_CHAR(sysdate,'')) + 1) yr from dual " This query is what I was looking for . Thankyou very much. But I did not understand why you are adding '1' to to_number(TO_CHAR(add_months(sysdate,9),'Q'))? Thanks again Surendra From: T Tebbe 02-Jul-03 20:27 Subject: Re : CASE in PL/SQL Good question, Surendra. To answer it, I'll be beginning with the following query, which does nothing more than returns eight dates for us to work with. These eight dates fall in eight different quarter/year combinations, so it'll be a good test: SQL SELECT ADD_MONTHS(TO_DATE('20030101','MMDD'),(ROWNUM - 1) * 3) dt 2 FROM sys.all_users 3 WHERE ROWNUM = 8 4 / DT --- 01-JAN-2003 01-APR-2003 01-JUL-2003 01-OCT-2003 01-JAN-2004 01-APR-2004 01-JUL-2004 01-OCT-2004 8 rows selected. Now, we use TO_CHAR to convert these dates to quarters the way Oracle has defined them: SQL SELECT dt 2 , TO_CHAR(dt,'Q') as_q 3 FROM (SELECT ADD_MONTHS(TO_DATE('20030101','MMDD'),(ROWNUM - 1) * 3) dt 4 FROM sys.all_users 5 WHERE ROWNUM = 8) 6 / DT A --- - 01-JAN-2003 1 01-APR-2003 2 01-JUL-2003 3 01-OCT-2003 4 01-JAN-2004 1 01-APR-2004 2 01-JUL-2004 3 01-OCT-2004 4 8 rows selected. I'm going to perform math on those quarters, but right now they're characters (TO_CHAR), so I have to do a TO_NUMBER on that column: SQL SELECT dt 2 , TO_NUMBER(TO_CHAR(dt,'Q')) as_q 3 FROM (SELECT ADD_MONTHS(TO_DATE('20030101','MMDD'),(ROWNUM - 1) * 3) dt 4 FROM sys.all_users 5 WHERE ROWNUM = 8) 6 / DT AS_Q --- -- 01-JAN-2003 1 01-APR-2003 2 01-JUL-2003 3 01-OCT-2003 4 01-JAN-2004 1 01-APR-2004 2 01-JUL-2004 3 01-OCT-2004 4 8 rows selected. Now, I want to turn Oracle's quarters (1,2,3,4,1,2,3,4) into your quarters (3,4,1,2,3,4,1,2). I can't just add 2, because then for quarters 3 and 4 I'd get quarters 5 and 6, which makes no sense. So I use MOD. I need to use MOD(something,4) because there are four quarters to a year. MOD(positive integer,4) will always return one of 0,1,2 or 3, so the OUTERMOST "+ 1" converts the members of this 0,1,2 and 3 subset (which we don't want) into 1,2,3 and 4 (which we do want). So to get from 1,2,3,4,1,2,3,4 (what we're starting with) to 2,3,0,1,2,3,0,1 (where we want to be), I add one (that's the innermost "+1" you're asking about). SQL SELECT dt 2 , TO_NUMBER(TO_CHAR(dt,'Q')) as_q 3 , TO_NUMBER(TO_CHAR(dt,'Q')) + 1 "AS_Q + 1" 4 , MOD(TO_NUMBER(TO_CHAR(dt,'Q')) + 1,4) "MOD_4'D" 5 , MOD(TO_NUMBER(TO_CHAR(dt,'Q')) + 1,4) + 1 "MOD_4'D + 1" 6 FROM (SELECT ADD_MONTHS(TO_DATE('20030101','MMDD'),(ROWNUM - 1) * 3) dt 7 FROM sys.all_users 8 WHERE ROWNUM = 8) 9 / DT AS_Q AS_Q + 1 MOD_4'D MOD_4'D + 1 --- -- -- -- --- 01-JAN-2003 1 2 2 3 01-APR-2003 2 3 3 4 01-JUL-2003 3 4 0 1 01-OCT-2003 4 5 1 2 01-JAN-2004 1 2 2 3 01-APR-2004 2 3 3 4 01-JUL-2004 3 4 0 1 01-OCT-2004 4 5 1 2 8 rows selected. SQL The last column there follows your organization's fiscal quarter schedule. Hope this helps, Surendra. T. -Original Message-From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED]Sent: Thursday, July 03, 2003 9:11 AMTo: Multiple recipients of list ORACLE-LSubject: RE: CASE in PL/SQL Can you at-least _show_ us what you are doing, what you want to do and where the code is failing? We are shooting in the dark here .. Like I mentioned before, youcan _always_ use
RE: calling an external procedure
This line jumps out: create library zPrintString as 'c:/newsys/bin/PrintString.dll'; Any difference if you change those to backslashes? HTH, -Roy Roy Pardee Programmer/Analyst/DBA SWFPAC Lockheed Martin IT Extension 8487 -Original Message- Sent: Thursday, July 03, 2003 5:26 AM To: Multiple recipients of list ORACLE-L Hi all, before I smash my head against the wall.. I am trying to execute an external procedure defined in a C .dll. I have set up my tnsnames/listener.ora as following : --- # C:\ORANT\NET80\ADMIN\TNSNAMES.ORA Configurationfile :C:\ORANT\net80\admin\tnsnames.ora # Generated by Oracle Net8 Assistant Tcp-loopback.world = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP) (Host = 127.0.0.1) (Port = 1521) ) ) (CONNECT_DATA = (SID = ORCL) ) ) extproc_connection_data.world = (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC) (KEY = ORCL) ) (CONNECT_DATA = (SID = extproc) ) ) # C:\ORANT\NET80\ADMIN\LISTENER.ORA Configuration File:C:\ORANT\net80\admin\listener.ora # Generated by Oracle Net8 Assistant LISTENER = (ADDRESS_LIST = (ADDRESS= (PROTOCOL= IPC) (KEY= oracle.world) ) (ADDRESS= (PROTOCOL= IPC) (KEY= ORCL) ) (ADDRESS= (PROTOCOL= TCP) (Host= ff1) (Port= 1521) ) (ADDRESS= (PROTOCOL= TCP) (Host= ff1) (Port= 1526) ) (ADDRESS= (PROTOCOL= SPX) (Service= inventory_lsnr) ) (ADDRESS= (PROTOCOL= NMP) (SERVER= nt_inventory_box) (PIPE= ORAPIPE) ) ) STARTUP_WAIT_TIME_LISTENER = 0 CONNECT_TIMEOUT_LISTENER = 10 SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME = ff1) (SID_NAME = ORCL) ) (SID_DESC = (SID_NAME = extproc) (PROGRAM=extproc) (ORACLE_HOME=$ORACLE_HOME) ) ) LOG_DIRECTORY_LISTENER = c:\orant\net80\trace TRACE_DIRECTORY_LISTENER = c:\orant\net80\trace TRACE_LEVEL_LISTENER = admin The plsql test code is : drop library zPrintString; create library zPrintString as 'c:/newsys/bin/PrintString.dll'; select * from user_libraries; create or replace procedure PrintString (OutPutString IN VARCHAR2) as external Library zPrintString name zPrintString parameters (OutPutString STRING); begin execute PrintString('testing'); end; -- Oracle tells me, that it is not able, to loead the dll. Error message is : ORA-06520: PL/SQL: Error loading external library ORA-06522: Unable to load DLL ORA-06512: at SYS.PRINTSTRING, line 0 ORA-06512: at line 2 -- is anyone able, to help ? TNX Frank Confidentiality Notes This email and any files transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. If you are not the authorised recipient, any use, disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it, is prohibited. If you received this in error, please contact the sender and delete the material from any computer. E-mail messages are not necessarily secure. Scheidt Bachmann does not accept responsibility for any changes made to this message after it was sent. Thank you for your cooperation! Diese E-Mail und alle angehängten Dateien ist ausschließlich für die Person / Personen bestimmt, an die diese adressiert ist und könnte vertrauliche und / oder rechtlich geschützte Informationen enthalten. Sollten Sie nicht der für diese E-Mail bestimmte Adressat oder nicht zum Empfang berechtigt sein, ist Ihnen jeder Gebrauch, sowie jede Veröffentlichung, Vervielfältigung oder Weitergabe wie auch das Ergreifen oder Unterlassen von Maßnahmen im Vertrauen auf erlangte Information untersagt. Sollten Sie diese E-Mail irrtümlich erhalten haben, benachrichtigen Sie bitte den Absender und löschen diese E-Mail von jedem Computer. E-Mail-Mitteilungen sind nicht notwendigerweise sicher. Scheidt Bachmann übernimmt keine Verantwortung für Veränderungen dieser Mitteilung, die nach dem Senden vorgenommen wurden. Herzlichen Dank für Ihre Unterstützung! - -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Foelz.Frank INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051
RE: Oracle DBA 9i Books ever needed.
I have only one question: in the Hogwarts school of Oracle Wizardry Cary Dumbledore is probably the headmaster, but who will have the role of Lord Voldemort? Are developers to be considered muggles? Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message- Sent: Thursday, July 03, 2003 10:31 AM To: Multiple recipients of list ORACLE-L AHA! Thanks Hermione :) okay, now Jared will perform the crucias (sp? I don't have the book with me, I finished it and it's home) curse on me if I don't stop here and take this to the OT list. --- Nuno Souto [EMAIL PROTECTED] wrote: - Original Message - you mean we don't tune Oracle using spells, incantations and prayers? Dang, I knew I was doing something wrong! It's leviosa, not lehviosah... ;) 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). __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Microsoft VS Oracle (again)
Richard, I'm not totally sure, but the one site that I saw that tried it got a memory error, memory cannot be written, when they started it. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Tuesday, July 01, 2003 5:00 PM To: Multiple recipients of list ORACLE-L Not familiar with SQL*Server but why not? What's preventing it from work? I run Oracle under a Linux environment which runs in VMware for my dev and test. Also run a RAC under Linux using VMware. Other people have done RAC running under Windows under VMware. So, what is it with SQL*Server that it won't work under VMware? Just would like know. Regards, Richard -Original Message- Sent: Tuesday, July 01, 2003 4:47 PM To: Multiple recipients of list ORACLE-L Nope, does not work that way. I've seen it tried. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Tuesday, July 01, 2003 4:15 PM To: Multiple recipients of list ORACLE-L None. Hmmm, maybe if you run VMware on Linux then you can run SQL Server from a virtual machine. Richard Ji -Original Message- Sent: Tuesday, July 01, 2003 3:00 PM To: Multiple recipients of list ORACLE-L On which unix boxes does SQL Server work? I don't want to replace all of my AIX, HP-UX and Solaris boxes with NT. I'll consider SQL Server as a replacement as soon as it starts operating on Unix. Microsoft operating systems have spurned the whole industry trying to protect them from viruses, which makes them completely unsuitable for a central database of a Fortune 500 company. Does SQL Server work on Linux? Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message- Sent: Tuesday, July 01, 2003 1:00 PM To: Multiple recipients of list ORACLE-L FYI One of my friends at Microsoft, (yes I must to confess, I have friends at MS) gave me a present, it's a 4 cd's kit called SQL Server 2000 for the Oracle Customer, the kit consist in 4 cd's with demos, docs, presentations, videos and a lot of stuff showing why sql server is a better option as a DB instead oracle, contains price lists, performance evaluation and many other information, maybe you'd like to spend some of your time giving Billy a chance to defend his product. The 4 cd's are available (almost completely) as links in: http://www.microsoft.com/sql/oraclekit Any comments? Gabriel = Any dream worth having is a dream worth fighting for(Cualquier sueño que valga la pena tener, es un sueño por el que vale la pena luchar)Charles Xavier __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Gabriel Aragon INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Richard Ji INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- 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
[Q] Shutdown database on LINUX redhat AS 2.1 problem?
We are doing ORACLE 9ir2 database migration from SUN to LINUX Redhar AS 2.1. I setupp /etc/init.d/dbora, /etc/oratab, /etc/rc5.d/K10dbora and /etc/rc5.d/S99dbora. I can dbstart and dbshut without problem. When system boot up, it also bring startup /etc/rc5.d/S99dbora. The problem I have is when system shutdonw (shutdown now -r), it does NOT run /etc/rc5.d/K10dbora to shutdown database. Does anyone know why? Thanks. __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: mike mon INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
wierd wait event - library cache load lock
We have a PeopleSoft system (Finanacials) that is just moving into production. Some of the conversion and data entry stuff was running slowly so I peaked at our system and session wait events (as well as looking at some recent history with statspack). There was a huge amount of time_waited for 'library cache load lock'. Never came across this one before. According to the Docs, it is a lock used to load an object into the library cache (you don't want the same object loaded more than once). I am trying to find more information so I can debug this. Of course the problem isn't there today (other modules are being worked on. Maybe that is why). Just trying to be ready when/if this happens again. I'm thinking a 10046 trace might give me some object information about what is being loaded/locked. Metalink suggests taking a systemstate dump (though they seem to mix up 'library cache lock' with 'library cache load lock'. Don't know if the same tracking techniques work on both.). Anybody else see this before? Suggestions on what to do if it shows up again? Thanks. Henry -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Henry Poras INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: {SPAM?} Re: fine grained access
Hi Peter, If you only want to know that the table was accessed with a select and not the details at row level then you can use regular audit. It sounds like you want to capture explicit selects though at row level so you should look at using fine grained audit. I am not aware of any other way to record read access at the row level other than esoteric solutions that involve reading SQL*net packets or inserting a layer in OCI to be able to grab the SQL statements at source. A more workable solution would involve you parsing SQL from the SGA regularly but all this is overkill when fine grained audit will do exactly what you want. kind regards Pete -- Pete Finnigan email:[EMAIL PROTECTED] Web site: http://www.petefinnigan.com - Oracle security audit specialists Book:Oracle security step-by-step Guide - see http://store.sans.org for details. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Finnigan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Accessing forms server through proxy server
Hi List, i have set up a oracle forms server on public network, if i am accesing the forms from a PC which on directly connected to internet , am able to open the forms. my problem is if i access the same forms from a PC which is behind the filrewall that time not able to open the forms ,error is 'FRM-29050 failed to connect to server' what can be problem. Thanks Arvind -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Arvind Kumar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: wierd wait event - library cache load lock
encoded content removed -- binaries not allowed by ListGuru The previous attachment was filtered out by the ListGuru mailing software at fatcity.com because binary attachments are not appropriate for mailing lists. If you want a copy of the attachment which was removed, contact the sender directly and ask for it to be sent to you by private E-mail. This warning is inserted into all messages containing binary attachments which have been removed by ListGuru. If you have questions about this message, contact [EMAIL PROTECTED] for clarification. winmail.dat
Re: Script to check filename continuously
Hi Sami Try something like this in korn shell, i have typed it in from memory so please check the syntax...:-) #!/bin/ksh location=/tmp filename=YOURFILENAME done=false while [[ $done = false ]]; do if [[ ! -a $filename ]]; then echo do something cp $filename $location done=true fi done kind regards Pete -- Pete Finnigan email:[EMAIL PROTECTED] Web site: http://www.petefinnigan.com - Oracle security audit specialists Book:Oracle security step-by-step Guide - see http://store.sans.org for details. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pete Finnigan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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[2]: Online tech books
O'Reilly does this for almost all its books: http://safari.oreilly.com. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Hotsos Clinic 101 in Dallas, Washington, Denver, Sydney - Hotsos Symposium 2004, March 7-10 Dallas - Visit www.hotsos.com for schedule details... -Original Message- Thater, William Sent: Thursday, July 03, 2003 7:26 AM To: Multiple recipients of list ORACLE-L here's a practical question: is there a way to put tech books online? what about a web site you'd pay a fee to use? i'd really like to have such a thing. [can't grep dead trees.;-)] is this possible? -- Bill Shrek Thater ORACLE DBA BAARF Party member #25 [EMAIL PROTECTED] If you don't know where you're going, any road will take you there. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Thater, William INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be 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: Cary Millsap INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: How to install Oracle JVM on Oracle 8.1.7.
Here's an example for unix. Don't have a Windohs example handy. Modify this one, or check metalink. Jared /u01/app/oracle/product/8.1.7/bin/svrmgrl EOF spool /u01/app/oracle/admin/dv02/create/jvminst.log connect internal @/u01/app/oracle/product/8.1.7/javavm/install/initjvm.sql spool off spool /u01/app/oracle/admin/dv02/create/initxml.log @/u01/app/oracle/product/8.1.7/oracore/admin/initxml.sql spool off spool /u01/app/oracle/admin/dv02/create/init_jis.log @/u01/app/oracle/product/8.1.7/javavm/install/init_jis.sql spool off spool /u01/app/oracle/admin/dv02/create/jisja.log @/u01/app/oracle/product/8.1.7/javavm/install/jisja.sql spool off spool /u01/app/oracle/admin/dv02/create/jisaephc.log @/u01/app/oracle/product/8.1.7/javavm/install/jisaephc.sql spool off spool /u01/app/oracle/admin/dv02/create/initplgs.log @/u01/app/oracle/product/8.1.7/rdbms/admin/initplgs.sql spool off spool /u01/app/oracle/admin/dv02/create/initjsp.log @/u01/app/oracle/product/8.1.7/jsp/install/initjsp.sql spool off spool /u01/app/oracle/admin/dv02/create/jspja.log @/u01/app/oracle/product/8.1.7/jsp/install/jspja.sql spool off spool /u01/app/oracle/admin/dv02/create/initplsj.log @/u01/app/oracle/product/8.1.7/rdbms/admin/initplsj.sql spool off spool /u01/app/oracle/admin/dv02/create/initjms.log @/u01/app/oracle/product/8.1.7/rdbms/admin/initjms.sql spool off spool /u01/app/oracle/admin/dv02/create/initrepapi.log @/u01/app/oracle/product/8.1.7/rdbms/admin/initrepapi.sql spool off spool /u01/app/oracle/admin/dv02/create/initsoxx.log @/u01/app/oracle/product/8.1.7/rdbms/admin/initsoxx.sql spool off exit; Nirmal Kumar M [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 07/03/2003 07:15 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:How to install Oracle JVM on Oracle 8.1.7. Hi all, I want to install, oracle JVM on oracle 817 database running on NT2000 server. I hope that initjvm.sql script has to be run under sys login. However i can't able to find that script file in my oracle home path %ORACLE_HOME%\RDBMS\ADMIN. Let know how to proceed futher and what are the pre requisities and post requiesties for this intallation?. Thanks. Nirmal,. = fsdfsdfsdfsdfs __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nirmal Kumar M INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- 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: ODS and data modeling
Title: Message Handling codes in one table via separate tables has been extensively discussed in development-oriented lists. The consensus falls heavily on having one single table -- it is much easier to manage. For example, you only need one fairly simplemaintenance form to allow users to maintain/view the code values. SampleDESC for one physical table which holds multiple logical code tables: SQL desc cn_codesName Null? Type- ---CODE_IDNOT NULL NUMBER(10)ACTIVE_INDNOT NULL VARCHAR2(1)CODE_SHORT_DESC_TXTNOT NULL VARCHAR2(70)CODE_TABLE_NMNOT NULL VARCHAR2(30) -- logical code table nameCODE_VALUE_CDNOT NULL VARCHAR2(15) -- logical code valueCREATE_DTNOT NULL DATECREATE_USER_NMNOT NULL VARCHAR2(12)MOD_DTNOT NULL DATEMOD_USER_NM NOT NULL VARCHAR2(12)CODE_LONG_DESC_TXT VARCHAR2(1000)TABLE_SPECIFIC_TXTVARCHAR2(40)DISPLAY_SEQ_NBR NUMBER(3) Couple of notes on the above: (1) Above table definition includes artificial, sequence-generated PK, which is recommeded for DW or ODS, given issues with changing dimensions. (2) Don't know if you will want just an Active indicator or a range of dates in which the particular code is active. (3) OLTP system needs additional information about codes, stored in table_specific_txt; might not be required in ODS/DW environment. (4) Specific definition of table_specific_txt, and a definitive list of all the code tables is contained in another logical table, which could be another code table or stored elsewhere. (5) If required, very easy to create views on top of the above, to hide the physical table from developers. -Original Message-From: Stephane Paquette [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 02, 2003 4:56 PMTo: Multiple recipients of list ORACLE-LSubject: ODS and data modeling Hi all, I'm doing the data model for an Operational Data Store. The ODS will serve to consolidate data from many operational systems and mainly from a new ERP, then most of the data will go in an existing data warehouse. I've worked with datawarehouses before but never withODS. I've check about Bill Inmon and at IBM red book site on the web. Any other good site on ODS ? Also, what are your arguments when choosing between1 table handling all codes or having a table for each code. TIA 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]
Re: LINUX instance startup problem
Most modern versions of linux have shared memory/semaphore parameters set high enough that oracle can start (unless, of course, you have an exceptionally large SGA). (Note 187397.1) If this is a fresh install (in particular a download from OTN) of 8.1.7, locate the glibc-2.1.3-stubs.tar.gz patch from Oracle. (http://otn.oracle.com/software/products/oracle8i/htdocs/linuxsoft.html). There is also a good document entitled: Oracle RDBMS OTN Downloads: Files, Sizes and Directions (Note 209555.1) -- James Seema Singh wrote: Hi, I'm having problem during startup of instance on LINUX.I have oracle 8.1.7 on red hat. When I start instance it try to come upto this below lines background_dump_dest = user_dump_dest = core_dump_dest = after that I'm getting following message SVRMGR connect internal; Connected. SVRMGR startup; ORA-03113: end-of-file on communication channel SVRMGR connect internal; Password: ORA-03113: end-of-file on communication channel SVRMGR When I see semaphore and shared memory.Its locked.I'm unable to get into server manager without killing all shared mem process. Let me know how to fix this problem pl thx -seema _ MSN 8 with e-mail virus protection service: 2 months FREE* http://join.msn.com/?page=features/virus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: James J. Morrow INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: [Q] Shutdown database on LINUX redhat AS 2.1 problem?
Yup! Linux != Slowaris. Slowaris executes K* in /etc/init.d/rc5.d unconditionally. Linux has the following code in /etc/rc.d/rc script (the one that executes run level initialization); [ -f /var/lock/subsys/$subsys -o -f /var/lock/subsys/$subsys.init ] \ || continue which means that if the activation file doesn't exist in /var/lock/subsys, the continue command will be executed and the loop will immediately jump to the next iteration. Take out that line and K* scripts will be executed unconditionally, just as on Slowaris. That is just a little bit of good ol' Linux hacking. On 2003.07.03 14:19, mike mon wrote: We are doing ORACLE 9ir2 database migration from SUN to LINUX Redhar AS 2.1. I setupp /etc/init.d/dbora, /etc/oratab, /etc/rc5.d/K10dbora and /etc/rc5.d/S99dbora. I can dbstart and dbshut without problem. When system boot up, it also bring startup /etc/rc5.d/S99dbora. The problem I have is when system shutdonw (shutdown now -r), it does NOT run /etc/rc5.d/K10dbora to shutdown database. Does anyone know why? Thanks. __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: mike mon INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Mladen Gogala Oracle DBA -- 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).
FTP command -without user interaction
Hi All, How to execute FTP command without interaction. Basically i want to supply hostname,username,passwors,filename thru batch script. For example ftp hostname userName passWord fileName Could someone help me to do the same? Thanks Sami -- 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: FTP command -without user interaction
What OS? Since you say batch file I will presume Windows. Use the -s:filename parameter and pass a scriptfile to the ftp command You can generate the scriptfile on the fly with echo commands and symbol redirection: eg: echo verbose off %ftp_tfile% echo open %ftp_tgt_node% %ftp_tfile% echo %ftp_tgt_user% %ftp_tfile% echo %ftp_tgt_pwd% %ftp_tfile% echo type ascii %ftp_tfile% echo cd %3 %ftp_tfile% echo put %1%2 %ftp_tfile% echo bye %ftp_tfile% rem Do the actual ftp using this script file rem TYPE %ftp_tfile% ftp -s:%ftp_tfile% Example: C:\Temptype ftpscript.ftp open mynode username secretpassword type ascii cd sys$login get login.com bye C:\Tempftp -s:ftpscript.ftp ftp open mynode Connected to mynode. 220 mynode FTP Server (Version V4.1-12) Ready. User (mynode:(none)): 331 Username USERNAME requires a Password. 230 User logged in. ftp ftp type ascii 200 TYPE set to ASCII. ftp cd sys$login 250 CWD command succesful. ftp get login.com 200 PORT command successful. 150 Opening data connection for login.com (a.b.c.d,2828) 226 Transfer complete. ftp: 1570 bytes received in 0.20Seconds 7.85Kbytes/sec. ftp bye 221 Goodbye. C:\Temp HTH, Bruce Reardon -Original Message- Sent: Friday, 4 July 2003 4:09 PM Hi All, How to execute FTP command without interaction. Basically i want to supply hostname,username,passwors,filename thru batch script. For example ftp hostname userName passWord fileName Could someone help me to do the same? Thanks Sami -- 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: How to install Oracle JVM on Oracle 8.1.7.
Look in $ORACLE_HOME\javavm\install\initjvm.sql -ak - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, July 03, 2003 7:15 AM Hi all, I want to install, oracle JVM on oracle 817 database running on NT2000 server. I hope that initjvm.sql script has to be run under sys login. However i can't able to find that script file in my oracle home path %ORACLE_HOME%\RDBMS\ADMIN. Let know how to proceed futher and what are the pre requisities and post requiesties for this intallation?. Thanks. Nirmal,. = fsdfsdfsdfsdfs __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nirmal Kumar M INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- 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).