OTN service
I mentioned that the 32 bit solaris gz file for 8.1.7 that I downloaded from otn provided one disk image on the order of 900MB. What technology do I need to move to in order to burn this onto plastic? Are we talking dvd burner here? I asked oracle what the intent was with this, the answer is a classic: The OTN Service Network is specifically designed for customers who need support on software downloaded via OTN. The OTN Service Network offers pay-per-incident support provided by Oracle certified professionals. Support is available on Oracle Database Server, Oracle9I Application Server and Oracle Tools products. Pricing is $50, $75 or $100 based on the complexity of the issue. By intent, I ment what technology was targeted. Anybody know? === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: pl/sql is INTERPRETED?
I can give you a hand in that :-) Or If you want to write it in spanish. Ramon -Original Message- Thomas F Sent: Thursday, 02 May, 2002 8:13 AM To: Multiple recipients of list ORACLE-L Independent contractors in Albany NY who know Cobol are getting $120/hour because all of the original employees who know Cobol are retiring. And the legacy systems are going to be around for quite awhile. -Original Message- Sent: Thursday, May 02, 2002 7:58 AM To: Multiple recipients of list ORACLE-L You THINK that you are kidding. I submit to you that in a few years there will be a great demand for Cobol programmers as the current old crop goes into retirement and all the newbe's are learning Java and perl. Start writing those books. They will be needed by the time that you finish them. Just my 2$ (inflation, you know) Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Wednesday, May 01, 2002 7:48 PM > Whatever happend to COBOL anyway?? That was so easy to code, along with > Fortran, BASIC, Pascal was a lot of fun. What's wrong with storing your > data in VSAM files??? > > I think I hear my pasture calling me...35, and retired...that would be nice. > I can write COBOL books to fund my retirement... > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ramon E. Estevez INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Changing SQL statements inside the database
The Virtual Private Database (VPD) facility (a.k.a. "fine-grain" or "row-level" security) can be used to alter SQL on the server, regardless of origin. I implemented an access control list (ACL) feature for a system two years ago, complete with recursion inside PL/SQL for navigating the (implied) double-dimensioned linked-lists that typical ACL functionality requires. Navigating linked-lists is naturally something that you wouldn't want to code in a SQL statement, but VPDs did it quite nicely by allowing me to run a custom PL/SQL packaged function during the PARSE phase of a SQL statement. The packaged function is supposed to return a string which is tacked onto the SQL statement, so you cannot "modify" existing text in the SQL, but you can add additional SQL text to the WHERE clause, including subqueries. There are other little useful twists and tricks and gotchas involved, but that's the general idea... But, be *very* careful! You can just imagine how badly you can harm performance and accessibility through casual use of this feature... :-) - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, May 02, 2002 7:18 AM > Hello list > > This time I need your help on how to implement a weird idea. > We have a third party application that fire wasteful SQL's to the database. > (Remember the discussion on using x$dual Vs dual some days ago?) > > I am wondering: Is there a way to change the SQL that the user send? > > In ADABAS on the mainframe I can activate a user exit that gets the command > that > the user send to the database and change it (Not only can, but we are doing > it!). > > Is there a way to do the same with SQL in Oracle? > > In the server (preferably) or in the client. > > Thanks > > Yechiel Adar > Mehish > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Yechiel Adar > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: datatypes
Hi, One way is to do the following: 1. Export the table for backup purposes 2. Create a temp table containing the primary key and column to be altered. 3. update original_table set number_column=null; 4. alter original_table MODIFY (column(3,2)); 5. Update column from temp table. (Assuming all the data in temp table will go in number(3,2) format. Rick Imran Ashraf o.com> cc: Sent by: Subject: datatypes root@fatcity. com 05/02/2002 09:18 AM Please respond to ORACLE-L Hi, i have a column set to number(3). However this needs to be changed to number (3,2). But i cannot do a straight alter table as there is data in the column. how can i get round this? cheers __ Do You Yahoo!? Yahoo! Health - your guide to health and wellness http://health.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Imran Ashraf INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
9i new features update
I finally got the website updated. For those of you who lost, never saw, would like to review, all of the past editions of the 9i new features series is at http://www.oracle-dba.com click on the 9i link. joe
Can't Connect to DB
Oracle 9i on XP Prof. DB is on a single PC. When I try to do a DB connection I get this error. Yesterday I created a second DB on my PC and was able to connect successfully to either of them. This morning I rebooted my PC and now I cannot connect. Any idea what the problem is? TIA, Ken Janusz, CPIM - ORA-12541: TNS:no listener Details:Building Oracle HOMES List HOME Name OraHome90 added to list. Found multiple homes, searching each HOMEx for valid PATH searching in SOFTWARE\ORACLE\HOME0 Oracle_Home found in SOFTWARE\ORACLE\HOME0 IS in system path! oci.dll found
RE: ERD generation tool
Moving the columns should not be a problem for anyone, heck you should be able to alphabetize them and everything be okay. If you take the output and use it to create tables that should not cause a problem except for the developer that codes for columns to appear in a specific order. Ron ROR mª¿ªm >>> [EMAIL PROTECTED] 05/01/02 06:56PM >>> No, no Paul is stating it as a bug. This has happend to me, where on occasion ERwin decides to move columns around for no reason when it creates the table in the database. I have looked at every single option and I can't find anything, so I am assuming it's a bug. But if anyone knows otherwise...please do share... * -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: pl/sql is INTERPRETED?
May be it's time to switch back to Cobol! I've done it for four years (Cobol & F77 with Codasyl). Regards, Waleed -Original Message- To: Multiple recipients of list ORACLE-L Sent: 5/2/02 8:13 AM Independent contractors in Albany NY who know Cobol are getting $120/hour because all of the original employees who know Cobol are retiring. And the legacy systems are going to be around for quite awhile. -Original Message- Sent: Thursday, May 02, 2002 7:58 AM To: Multiple recipients of list ORACLE-L You THINK that you are kidding. I submit to you that in a few years there will be a great demand for Cobol programmers as the current old crop goes into retirement and all the newbe's are learning Java and perl. Start writing those books. They will be needed by the time that you finish them. Just my 2$ (inflation, you know) Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Wednesday, May 01, 2002 7:48 PM > Whatever happend to COBOL anyway?? That was so easy to code, along with > Fortran, BASIC, Pascal was a lot of fun. What's wrong with storing your > data in VSAM files??? > > I think I hear my pasture calling me...35, and retired...that would be nice. > I can write COBOL books to fund my retirement... > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Khedr, Waleed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Correcting user sql inside the database
I did something way back wehn using PIPES to catch a runaway third party encapsulated pl sql code. I dont remember the specifics but you can look at the docs for it. Hannah > -Original Message- > From: [EMAIL PROTECTED]@SUNGARD On Behalf Of "Yechiel Adar" ><[EMAIL PROTECTED]> > Sent: Thursday, May 02, 2002 8:48 AM > To: Multiple recipients of list ORACLE-L > Subject: Correcting user sql inside the database > > Hello list > > This time I need your help on how to implement a weird idea. > We have a third party application that fire wasteful SQL's to the database. > (Remember the discussion on using x$dual Vs dual some days ago?) > > I am wondering: Is there a way to change the SQL that the user send? > > In ADABAS on the mainframe I can activate a user exit that gets the command > that > the user send to the database and change it (Not only can, but we are doing > it!). > > Is there a way to do the same with SQL in Oracle? > > In the server (preferably) or in the client. > > Thanks > > Yechiel Adar > Mehish > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Correcting user sql inside the database
Outlines is one way, but there is another sneaky way, but that involves a lot of programming depending on what you want to change. And it also depends on where the client runs and how it is linked Anjo. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, May 02, 2002 2:48 PM > Hello list > > This time I need your help on how to implement a weird idea. > We have a third party application that fire wasteful SQL's to the database. > (Remember the discussion on using x$dual Vs dual some days ago?) > > I am wondering: Is there a way to change the SQL that the user send? > > In ADABAS on the mainframe I can activate a user exit that gets the command > that > the user send to the database and change it (Not only can, but we are doing > it!). > > Is there a way to do the same with SQL in Oracle? > > In the server (preferably) or in the client. > > Thanks > > Yechiel Adar > Mehish > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Yechiel Adar > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anjo Kolk INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: datatypes
Imran, what I do is the following: create table temp_table as select primary_key_column, number_column from table_to_be_changed; update table_to_be_changed set number_column=null; alter table_to_be_changed modify(number_column(3,2)); declare cursor c1 is select primary_key_column, number_column from temp_table; begin for c1_rec in c1 loop update table_to_be_changed set numebr_column = c1_rec.number_column where primary_key_column = c1_rec.primary_key_column; end loop; commit; end; / Hope this helps. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Thursday, May 02, 2002 9:39 AM To: Multiple recipients of list ORACLE-L Perhaps: Export, truncate table, alter table, import or Create as select * from , truncate table , alter table, insert from , drop Imran Ashraf <[EMAIL PROTECTED]>@fatcity.com on 02-05-2002 14:18:28 Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Hi, i have a column set to number(3). However this needs to be changed to number (3,2). But i cannot do a straight alter table as there is data in the column. how can i get round this? cheers __ Do You Yahoo!? Yahoo! Health - your guide to health and wellness http://health.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Imran Ashraf INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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 know if another database is running on the same machine?
v$database will always show one and only one database - the database to which the instance you are running the query against is attached. As for how to find out on Windows, I'll leave that to someone who knows Windows better than I. Don Granaman [OraSaurus] - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, May 02, 2002 6:48 AM > Hi! > > On my win2k server I configured two databases one for data (MYData) and the > other for EM Repository OEMREP. The tools do not seem to be able to connect > to the database having data. The error reported is that TNS couldn't > identify SID. > > The v$database shows only the OEMREP database (Could be because the other > one is not accessible or perhaps the view shows the one that is active). > > How do I know whether the other database is there or not and how to make it > accessible? > > TIA! > > Aleem for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Don Granaman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
datatypes
Hi, i have a column set to number(3). However this needs to be changed to number (3,2). But i cannot do a straight alter table as there is data in the column. how can i get round this? cheers __ Do You Yahoo!? Yahoo! Health - your guide to health and wellness http://health.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Imran Ashraf INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: migration MS SQL 6.5 to ORACLE 8i
See otn.oracle.com for Oracle Migration Workbench. -Joe --- Arslan Bahar <[EMAIL PROTECTED]> wrote: > > How !? > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Arslan Bahar > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing > Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! Health - your guide to health and wellness http://health.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Raube INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: datatypes
Perhaps: Export, truncate table, alter table, import or Create as select * from , truncate table , alter table, insert from , drop Imran Ashraf <[EMAIL PROTECTED]>@fatcity.com on 02-05-2002 14:18:28 Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Hi, i have a column set to number(3). However this needs to be changed to number (3,2). But i cannot do a straight alter table as there is data in the column. how can i get round this? cheers __ Do You Yahoo!? Yahoo! Health - your guide to health and wellness http://health.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Imran Ashraf INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Changing SQL statements inside the database
Hello list This time I need your help on how to implement a weird idea. We have a third party application that fire wasteful SQL's to the database. (Remember the discussion on using x$dual Vs dual some days ago?) I am wondering: Is there a way to change the SQL that the user send? In ADABAS on the mainframe I can activate a user exit that gets the command that the user send to the database and change it (Not only can, but we are doing it!). Is there a way to do the same with SQL in Oracle? In the server (preferably) or in the client. Thanks Yechiel Adar Mehish -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: pl/sql is INTERPRETED?
Independent contractors in Albany NY who know Cobol are getting $120/hour because all of the original employees who know Cobol are retiring. And the legacy systems are going to be around for quite awhile. -Original Message- Sent: Thursday, May 02, 2002 7:58 AM To: Multiple recipients of list ORACLE-L You THINK that you are kidding. I submit to you that in a few years there will be a great demand for Cobol programmers as the current old crop goes into retirement and all the newbe's are learning Java and perl. Start writing those books. They will be needed by the time that you finish them. Just my 2$ (inflation, you know) Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Wednesday, May 01, 2002 7:48 PM > Whatever happend to COBOL anyway?? That was so easy to code, along with > Fortran, BASIC, Pascal was a lot of fun. What's wrong with storing your > data in VSAM files??? > > I think I hear my pasture calling me...35, and retired...that would be nice. > I can write COBOL books to fund my retirement... > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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 know if another database is running on the same machine?
Hi Dmit, When you connect to a database and look at v$database, it will only show you information about the current database. On win2k you should check the following: 1. go to the services panel and make sure you have services created and started for each database 2. from the dos prompt check the listener to make sure it is listening for each of these databases 3. assuming you are using tnsnames file check to make sure each of these databases are in the tnsnames file 4. from the dos prompt see if you can connect to each of these databases using the oracle_sid set oracle_sid=oemrep sqlplus user/password select * from v$database; exit set oracle_sid=mydata sqlplus user/password select * from v$database; exit If all of the above are ok, you should be able to connect using the listener as well. Good luck, John [EMAIL PROTECTED] wrote: >Hi! > >On my win2k server I configured two databases one for data (MYData) and the >other for EM Repository OEMREP. The tools do not seem to be able to connect >to the database having data. The error reported is that TNS couldn't >identify SID. > >The v$database shows only the OEMREP database (Could be because the other >one is not accessible or perhaps the view shows the one that is active). > >How do I know whether the other database is there or not and how to make it >accessible? > >TIA! > >Aleem > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ora NT DBA INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ITS THE PHB, STOOOOPID (was: anti-virus spam)
what - you changing careers - trying out for Denis Miller's show? nice rant. you win the award for the most number of '*' words in an essay. take a chill-pill, babe. :) -Original Message- Sent: Wednesday, May 01, 2002 4:42 PM To: Multiple recipients of list ORACLE-L It is kind of amazing how irrelevant and lacking in substance this discussion is. It has been explained that the original offender's email server was configured in *stupid mode* because of damagement, not because of the techies. fyi: PHB = pointed headed boss ( http://kltp.kldp.org/eunjea/jargon/?idx=PHB ) to clarify: it is a complete outrage that an email server is set up to barf out a whole screen full of worthless, erroneous and time wasting "virus warning" messages back to a message sender *MONTHS* (almost a *YEAR*?) after a text attachment has been sent to the list. certainly the above situation qualifies for the WHAT THE F* award of the week, doesn't it? certainly the list owner's attention ought to be brought to bear on whether or not a subscriber ought to be allowed to remain if their system is generating such a huge pile of unwanted fecal material, and certainly consideration should be given to pressuring the email admin, or other f*ing d*kheads in positions of "respoinsibility" at said subscriber's corporation/organization into reversing their f*ing stupid email configuration policy, no? presumably an expression of outrage at the f*ing stupidity of said f*ing email server configuration would tend to put the issue on someones f*ing radar screen more than some "polite" request that everyone ignores? anyways, Tim was wrong in thinking that I was insulting fatcity's email admin. Tim's observations about language and tone were irrelevant and lacking in substance, and frankly, regardless of Tim's many other undoubtedly great/vast/endless virtues, culinary or not, I don't care about such ninny-like posturing and false rectitude anyway, so his advice was completely wasted on me. I'm sure everyone was infinitely amused and entertained by your story of being fooled into eating a dead animals' testicles (apparently that topic wasn't covered in 5th grade). regards, ep ORACLE-L Digest -- Volume 2002, Number 121 > -- > > From: Mogens =?ISO-8859-1?Q?N=F8rgaard?= <[EMAIL PROTECTED]> > Date: Tue, 30 Apr 2002 18:17:09 +0200 > Subject: Re: ANTI-VIRUS SPAM - YOUR EMAIL ADMIN IS A DIKHEAD > > --030707020805030006050203 > Content-Type: text/plain; charset=us-ascii; format=flowed > Content-Transfer-Encoding: 7bit > > Sigh. I wish I understood half the words used in this exchange. Or maybe > not. But I still think Tim is a cool guy and I'm looking forward to > drinking beer with him next time we meet. The first time I met with Tim > was in Denver where he tricked me into eating something he called Rocky > Mountain Oysters. If he ever makes it to Denmark I'll trick him into > eating our world-famous blood sausage. > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eric D. Pierce INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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 IFS
Samba, best is its free. >>> [EMAIL PROTECTED] 05/02/02 04:48AM >>> Hi All, We are looking for possible solutions to share files between Windows & Unix. And also store millions of little files that are now a backup nightmare. Does anybody have any experience with IFS (performance, possibilities, pitfalls ) TIA Jack === De informatie verzonden in dit e-mailbericht is vertrouwelijk en is uitsluitend bestemd voor de geadresseerde. Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan derden is, behoudens voorafgaande schriftelijke toestemming van Ernst & Young, niet toegestaan. Ernst & Young staat niet in voor de juiste en volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch voor tijdige ontvangst daarvan. Ernst & Young kan niet garanderen dat een verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden. Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u vriendelijk doch dringend het e-mailbericht te retourneren aan de verzender en het origineel en eventuele kopieën te verwijderen en te vernietigen. Ernst & Young hanteert bij de uitoefening van haar werkzaamheden algemene voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De algemene voorwaarden worden u op verzoek kosteloos toegezonden. = The information contained in this communication is confidential and is intended solely for the use of the individual or entity to whom it is addressed. You should not copy, disclose or distribute this communication without the authority of Ernst & Young. Ernst & Young is neither liable for the proper and complete transmission of the information contained in this communication nor for any delay in its receipt. Ernst & Young does not guarantee that the integrity of this communication has been maintained nor that the communication is free of viruses, interceptions or interference. If you are not the intended recipient of this communication please return the communication to the sender and delete and destroy all copies. In carrying out its engagements, Ernst & Young applies general terms and conditions, which contain a clause that limits its liability. A copy of these terms and conditions is available on request free of charge. === -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack van Zanen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gene Sais INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ERD generation tool
I dont mind the PK thing, I prefer it that way, but it also inconsistently places migrated foreign keys on the bottom (this is just mdoeling, no reverse engineering). This is just a slight pain for us as we have a bunch of auditing fields that I like to be last for readability. Sometimes I can move them, soemtimes I can't. Hannah > -Original Message- > From: [EMAIL PROTECTED]@SUNGARD On Behalf Of "Koivu, Lisa" ><[EMAIL PROTECTED]> > Sent: Wednesday, May 01, 2002 6:32 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: ERD generation tool > > I have seen it create two columns with the exact same name in a table. It > did this by putting double quotes around the column it was adding (that > actually already existed.) > > What's so bad about moving the pk fields to the top? Why would you put them > in the middle of the table? I think having pk at the top is more readable, > and it assists with more optimal storage at a very low level. > > Lisa Koivu > Oracle Database Administrator > Fairfield Resorts, Inc. > 5259 Coconut Creek Parkway > Ft. Lauderdale, FL, USA 33063 > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
migration MS SQL 6.5 to ORACLE 8i
How !? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Arslan Bahar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Correcting user sql inside the database
Hello list This time I need your help on how to implement a weird idea. We have a third party application that fire wasteful SQL's to the database. (Remember the discussion on using x$dual Vs dual some days ago?) I am wondering: Is there a way to change the SQL that the user send? In ADABAS on the mainframe I can activate a user exit that gets the command that the user send to the database and change it (Not only can, but we are doing it!). Is there a way to do the same with SQL in Oracle? In the server (preferably) or in the client. Thanks Yechiel Adar Mehish -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ERD generation tool - Active Comparisons
Why? For consistnecy. I am in charge of making ALL changes to the data model, then rolling out those changes to the db. Our developers RELY on me and my tools for a database that reflects the model that we developed (Without Error). Therefore, everything we do here STARTS with the model (dreamy, huh?). And the developers agree with this as we can get literally hundreds of changes (this has calmed down now that we have our first release), and this is the best way in our case to manage it (one point of change). Now, I had been seeing some *weird* stuff creep into the model (inconsistencies, datatypes not being consistent from the logical to physical model etc). So, I spent some time going throught the entire model *fixing* the little stuff and syncing the logical and physical models. I ran a bunch of reports to looks at it (and got some of the wierdness that I mentioned previously like pk cloumn showing up a NULLABLE...etc). So, as a further TEST, I rolled out the model using the scripts generated by ERWin and just for the Heck of it, decided to do the compare and it failed. NO ONE was mucking with the database. But compares from model to db are useful for syncing the db IF something like that should happen. Think of it this way, copying a file in an editor (take Word for example). You may not NEED that extra file, but you would be completely WIGGED out if your copy was NOT the same as the original. Which was my point of doing it in the first - to test ERWin. It failed. Hannah -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: SIMPLE QUESTION
Dave I checked this out and it depends on the oracle version. Editing the listener.log of 8.1.6.3.4 on NT failed as: Another process is using the file. The same for 9.0.1.3 on NT. Editing not problem. Marked the whole text except for the last day and deleted it and then I saved the file. Size down to 9k from about 10,000k. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Wednesday, May 01, 2002 7:58 PM If you are running Oracle on Windoze, you have to stop the listener service, then rename the listener.log, then start the listener service again. I don't know how on Unix. Dave -Original Message- Sent: Wednesday, May 01, 2002 12:18 PM To: Multiple recipients of list ORACLE-L HI AGAIN, JUST WANT TO CHECK WITH YOU GUYS, MY LISTENER.LOG IS GETTING BIG I TRY TO RENAME IT THEN CREATE A NEW LISTENER.LOG BUT STILL THE OLD ONE IS USING BY ORACLE. HOW CAN I TRUNCATE THE LISTENER.LOG OR CAN I JUST SIMPLY DELETE IT OR NOT? THANKS FOR HELP. Hamid Alavi Office 818 737-0526 Cell818 402-1987 === Confidentiality Statement === The information contained in this message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from disclosure under applicable law. If you have received this message in error, you are prohibited from copying, distributing, or using the information. Please contact the sender immediately by return e-mail and delete the original message from your system. = End Confidentiality Statement = -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hamid Alavi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: pl/sql is INTERPRETED?
You THINK that you are kidding. I submit to you that in a few years there will be a great demand for Cobol programmers as the current old crop goes into retirement and all the newbe's are learning Java and perl. Start writing those books. They will be needed by the time that you finish them. Just my 2$ (inflation, you know) Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Wednesday, May 01, 2002 7:48 PM > Whatever happend to COBOL anyway?? That was so easy to code, along with > Fortran, BASIC, Pascal was a lot of fun. What's wrong with storing your > data in VSAM files??? > > I think I hear my pasture calling me...35, and retired...that would be nice. > I can write COBOL books to fund my retirement... > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 know if another database is running on the same machine?
Hi! On my win2k server I configured two databases one for data (MYData) and the other for EM Repository OEMREP. The tools do not seem to be able to connect to the database having data. The error reported is that TNS couldn't identify SID. The v$database shows only the OEMREP database (Could be because the other one is not accessible or perhaps the view shows the one that is active). How do I know whether the other database is there or not and how to make it accessible? TIA! Aleem -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Abdul Aleem INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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-L gathering etc.
Well, if rumors are true, Howard Rogers ordered about 60 tons of James' book in order to get his barbeque going. That would explain it. They're sold out. Don't expect this special bargain again until they've re-printed James' book (maybe with a new title like "Failing Oracle9i" or such). Mogens Jonathan Lewis wrote: >Strange, > >But I can't get to see the offer now either. >Yesterday you could get all three books >Practical Oracle 8i ... >Internal services for waits, latches .. >Scaling Oracle 8i ... > >For the knock-down price of $78.91 instead >of $109.89 (and I've got the html to prove it !) > >Today the offer has disappeared. > > >Thank for the tip about ISBN > > >Jonathan Lewis >http://www.jlcomp.demon.co.uk > >Author of: >Practical Oracle 8i: Building Efficient Databases > >Next Seminar - Australia - July/August >http://www.jlcomp.demon.co.uk/seminar.html > >Host to The Co-Operative Oracle Users' FAQ >http://www.jlcomp.demon.co.uk/faq/ind_faq.html > > > >-Original Message- >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Date: 01 May 2002 23:42 > > >|On Wed, 1 May 2002, Connor McDonald wrote: >| >|> Having seem some of the presenters in action, I can >|> heartily recommend the seminar in Oz to anyone that >|> can get there...I can also heartily recommend Oz as >|> easily the best place on the planet! (touch of bias) >|> >|> ... also interesting is that under my piddly old >|> Netscape 3 I can see the "Great Buy" offer Jonathan >|> alludes to, but it does not appear under IE 5.5 >|> >|> Jeremiah - comment? >| >|Well having never been down under it is a little hard to comment. >|Being under the restrictions of employee NDA with the zon, it is even >|harder to say. >| >|But I'll give you this: It isn't the flavor of browser. >| >|Also, remember when posting that you can specify Amazon detail page >|URLs as shorter strings by cutting off everything after the ISBN, >like >|so: >| >|http://www.amazon.com/exec/obidos/ASIN/0201715848 >| >|-- >|Jeremiah Wilton >|http://www.speakeasy.net/~jwilton >| > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mogens =?ISO-8859-1?Q?N=F8rgaard?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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-L gathering etc.
Strange, But I can't get to see the offer now either. Yesterday you could get all three books Practical Oracle 8i ... Internal services for waits, latches .. Scaling Oracle 8i ... For the knock-down price of $78.91 instead of $109.89 (and I've got the html to prove it !) Today the offer has disappeared. Thank for the tip about ISBN Jonathan Lewis http://www.jlcomp.demon.co.uk Author of: Practical Oracle 8i: Building Efficient Databases Next Seminar - Australia - July/August http://www.jlcomp.demon.co.uk/seminar.html Host to The Co-Operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html -Original Message- To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Date: 01 May 2002 23:42 |On Wed, 1 May 2002, Connor McDonald wrote: | |> Having seem some of the presenters in action, I can |> heartily recommend the seminar in Oz to anyone that |> can get there...I can also heartily recommend Oz as |> easily the best place on the planet! (touch of bias) |> |> ... also interesting is that under my piddly old |> Netscape 3 I can see the "Great Buy" offer Jonathan |> alludes to, but it does not appear under IE 5.5 |> |> Jeremiah - comment? | |Well having never been down under it is a little hard to comment. |Being under the restrictions of employee NDA with the zon, it is even |harder to say. | |But I'll give you this: It isn't the flavor of browser. | |Also, remember when posting that you can specify Amazon detail page |URLs as shorter strings by cutting off everything after the ISBN, like |so: | |http://www.amazon.com/exec/obidos/ASIN/0201715848 | |-- |Jeremiah Wilton |http://www.speakeasy.net/~jwilton | -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonathan Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or 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 deinstall oracle 9i and leave 8i intact
Hi, May be those are shared component with your old 8i, btw what are those component regards Sinardy -Original Message- Sent: 30 April 2002 22:28 To: Multiple recipients of list ORACLE-L Tom, I started with using the installer. It appears it installed Oracle software. Of course this does nothing with the registry,services,etc. When I go back into installer it still shows some 9i installed. When I try to uninstall it insist on un-installing some oracle 8i software. I have been working in Oracle since the end of Oracle 5 and one thing is constant Oracle install/uninstall procedures SUCKS. Ok I feel a little better now,back to the problem. I found a Oracle document detailing removal or oracle software and a oracle home, followed it to the letter. Everything appears to work fine except the installer still shows some 9i software installed when I know there is not. It mus be stored elsewhere but do not know how to correct. This may cause problems if I attempt to re-install 9i. Any ideas? Thanks Rick "Mercadante, Thomas F" To: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]> <[EMAIL PROTECTED]cc: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]> ate.ny.us> Subject: RE: How to deinstall oracle 9i and leave 8i intact 04/30/2002 09:01 AM Rick, how about using the installer? Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, April 30, 2002 9:23 AM To: Multiple recipients of list ORACLE-L Reposting as I forgot to include a subject line on previous post. I have Oracle 8i with 4 instances and Oracle 9i with 1 instance. How can I just remove all of Oracle 9i without touching Oracle 8i? Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy Xing INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE:
What is the OS ? -Original Message- Sent: 30 April 2002 22:38 To: Multiple recipients of list ORACLE-L I have been reading/searching the DAMN documentation like I always do before posting a question. It is frustrating enough to get this to work correctly. I do not need this type of reply so keep it to yourself. All it does is add to the frustration. I greatly appreciate the constructive help I have gotten from the others. bill thater scape.net> cc: Sent by: Subject: Re: root@fatcity. com 04/30/2002 09:33 AM Please respond to ORACLE-L [EMAIL PROTECTED] wrote: > I have Oracle 8i with 4 instances and Oracle 9i with 1 instance. > How can I just remove all of Oracle 9i without touching Oracle 8i? > > > Thanks > Rick > > > how about reading the documentation that came with the damn software? -- -- Bill "Shrek" Thater ORACLE DBA [EMAIL PROTECTED] You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. A computer scientist is someone who fixes things that aren't broken. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: bill thater INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy Xing INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Oracle IFS
Hi All, We are looking for possible solutions to share files between Windows & Unix. And also store millions of little files that are now a backup nightmare. Does anybody have any experience with IFS (performance, possibilities, pitfalls ) TIA Jack === De informatie verzonden in dit e-mailbericht is vertrouwelijk en is uitsluitend bestemd voor de geadresseerde. Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan derden is, behoudens voorafgaande schriftelijke toestemming van Ernst & Young, niet toegestaan. Ernst & Young staat niet in voor de juiste en volledige overbrenging van de inhoud van een verzonden e-mailbericht, noch voor tijdige ontvangst daarvan. Ernst & Young kan niet garanderen dat een verzonden e-mailbericht vrij is van virussen, noch dat e-mailberichten worden overgebracht zonder inbreuk of tussenkomst van onbevoegde derden. Indien bovenstaand e-mailbericht niet aan u is gericht, verzoeken wij u vriendelijk doch dringend het e-mailbericht te retourneren aan de verzender en het origineel en eventuele kopieën te verwijderen en te vernietigen. Ernst & Young hanteert bij de uitoefening van haar werkzaamheden algemene voorwaarden, waarin een beperking van aansprakelijkheid is opgenomen. De algemene voorwaarden worden u op verzoek kosteloos toegezonden. = The information contained in this communication is confidential and is intended solely for the use of the individual or entity to whom it is addressed. You should not copy, disclose or distribute this communication without the authority of Ernst & Young. Ernst & Young is neither liable for the proper and complete transmission of the information contained in this communication nor for any delay in its receipt. Ernst & Young does not guarantee that the integrity of this communication has been maintained nor that the communication is free of viruses, interceptions or interference. If you are not the intended recipient of this communication please return the communication to the sender and delete and destroy all copies. In carrying out its engagements, Ernst & Young applies general terms and conditions, which contain a clause that limits its liability. A copy of these terms and conditions is available on request free of charge. === -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack van Zanen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: pl/sql is INTERPRETED?
Hold on Lisa! Java is not complex. It's a very simple language actually. It took me a week to learn it, though I'm not using it now: I much prefer Perl. Getting a handle on all of the libraries and API's is another story, but Java as a language is pretty simple. Jared On Tuesday 30 April 2002 11:14, Koivu, Lisa wrote: > You have a point Chris, but pl/sql is nowhere near as complex as an OO > language like java or C++, IMHO. I agree with Tom that pl/sql can be > learned fairly easily in comparison to the many other choices out there. > However, it takes a bit of database savvy to do it correctly. (Not much > tho) > > I was amazed in my "database" class in college that the same people failing > the simple entity-relationship modeling portion of the class that had aced > the Op Systems and networking classes we took. I nearly failed both > classes, they were so complex. I was the teacher's pet in the db class > because I asked him questions that made him think, and he sometimes > couldn't answer. (And I had to wear a skirt - night student, straight from > work.) > > What's easy for who is dependent on the person's strengths. > > Lisa Koivu > Oracle Database Monkey Mama > Fairfield Resorts, Inc. > 5259 Coconut Creek Parkway > Ft. Lauderdale, FL, USA 33063 > > > -Original Message- > > From: Grabowy, Chris [SMTP:[EMAIL PROTECTED]] > > Sent: Tuesday, April 30, 2002 1:14 PM > > To: Multiple recipients of list ORACLE-L > > Subject:RE: pl/sql is INTERPRETED? > > > > IMHO, I don't believe that you can "properly" learn PL/SQL in a very > > short period of time, or for that matter, any other language. > > > > I attended Steve Feuerstein's presentation at MAOP-AOTC conference, and > > he tore into many real-life examples of PL/SQL. Supposedly, these were > > written > > by developers that knew what they were doing. > > > > Granted, if a smart developer sits down and reads Feuerstein's Learning > > PL/SQL and Best Practices books, then perhaps they will be good. But who > > the hell has free time? There is no free time on any project or effort > > that > > I know of!! I'm struggling with trying to improve my Oracle DBA skills, > > plus some developers skills so I can speak their language when they blow > > out > > OPEN_CURSORS or something. My head is swimming in the stupid technical > > alphabet soup, XML, XDK, XSQL, XSLT, XPath, SOAP, ASP, ADO, EJB, BC4J, > > JDBC, > > SQLJ, PSP, JVM, JSP, J2EE, EAD, RMI, CORBA, IIOP...and don't ask me what > > all > > those mean, because I can't keep them straight. But I do keep hearing > > that > > XML is going to put me out of a job, so I guess I should learn > > that...whatever that is. Isn't XML an add-on, or extension, or something > > to > > DML??? > > > > Now where the heck did I hide that bottle... > > > > -Original Message- > > Sent: Tuesday, April 30, 2002 12:15 PM > > To: Multiple recipients of list ORACLE-L > > > > > > Lisa, > > > > You are right about the debate between PL/SQL & Java (or anything else > > outside of the db). > > > > In my mind, the deciding factor (and something that is *never* mentioned) > > is > > what programming langauage the organization is satisfied with/settled > > upon. > > > > In my little opinion, *any* programmer can learn PL/SQL in a very short > > period of time. This means that development and maintenance costs are > > relatively low. If an IT shop is stronger in Java, then they should > > probably program in Java, or Cobol, or Ada, or whatever the flavor of the > > decade happens to be (lets bring back APL!). > > > > IT tool selection/standards should be the deciding factor. > > > > Tom Mercadante > > Oracle Certified Professional > > > > > > -Original Message- > > Sent: Tuesday, April 30, 2002 11:34 AM > > To: Multiple recipients of list ORACLE-L > > > > > > This is something that's been debated on the list in the past. The > > general > > consensus was: > > > > For manipulating data in the database, nothing beats pl/sql. It is well > > suited for this purpose. > > > > For everything else, java could beat it. > > > > I am sure fellow list members will post links describing studies. I > > remember seeing these last year. > > > > Stefan, have you tried running your own test? There's a sure fire way to > > convince yourself. Even a small test (no fancy code) would suffice. > > Wish I > > had more time to play... > > > > Lisa Koivu > > Oracle Database Monkey Mama > > Fairfield Resorts, Inc. > > 5259 Coconut Creek Parkway > > Ft. Lauderdale, FL, USA 33063 > > > > > -Original Message- > > > From: Stefan Jahnke [SMTP:[EMAIL PROTECTED]] > > > Sent: Tuesday, April 30, 2002 10:49 AM > > > To: Multiple recipients of list ORACLE-L > > > Subject: AW: pl/sql is INTERPRETED? > > > > > > Hi > > > > > > how about Java within Oracle. What do you think about it ? > > > When does it make sense to use Java instead of PL/SQL ? > > > The problem is that I dislike a mix