RE: OAS and iAS file size comparisons
Another thing to keep in mind with 9iAS (in relation to its size) is it's caching capabilities. How do you think it keeps all that information cached?? Replication. 9iAS also comes with and installs the Oracle database engine in addition to everything else. When you select certain options for caching, it automatically performs data replication from the database server for you. That's probably a huge part of the size of 9iAS in and of itself. -::YEX::- ))) -Original Message- Sent: Thursday, 01 March, 2001 13:01 PM To: Multiple recipients of list ORACLE-L Everything but the kitchen sink.. 9iAS includes Apache, Forms Server, Reports Server, Portal, DB Cache, Discoverer Server, Queue Manager, Wireless if you want it, and possibly others I've left out. Consider yourself lucky if you only had 2 CDs, we (Solaris) had 3. Linda (installed but not working) -Original Message- Sent: Thursday, March 01, 2001 8:32 AM To: Multiple recipients of list ORACLE-L OAS 4.0.8.2 for NT was 121M in size, zipped. iAS for NT is two CDs in size, 569,609K + 403,131K. What did they put in this new version that is so HUGE? Unbelievable. How big will Oracle 9i be, I wonder. Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Rgion des Maritimes, MPO E-Mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seley, Linda INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Yexley Robert D SSgt AFIT/SCA INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: 6i
Yes, the one for NT works (Win2K is based on the NT kernel). If you still have problems getting it (since Metalink's performance has been S good lately), try ftp://oracle-ftp.oracle.com/dev_tools/patchsets/dev2k/Win95NT/6i/ (in fact, I would even go so far as to recommend that you skip Metalink altogether and just get the patch here instead). That site IS actually working, and it has what you need. -::YEX::- ))) -Original Message- Sent: Thursday, 01 March, 2001 15:48 PM To: Multiple recipients of list ORACLE-L Here's a real stupid question. I have been looking on Metaslack for a patch for Forms 6i for Win2k and I can't find it. So should I just use the one for Winnt? Sincerely, Kevin Kostyszyn DBA Dulcian, Inc www.dulcian.com [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Kostyszyn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Yexley Robert D SSgt AFIT/SCA INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 8.0.5 with Windows 2000
Yeah, it works. -Original Message- Sent: Monday, 05 March, 2001 10:26 AM To: Multiple recipients of list ORACLE-L Would someone tell me if Oracle 8.0.5 will work with Windows 2000? TIA Matt -- 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: Yexley Robert D SSgt AFIT/SCA INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 Masters program
As to whether or not it still exists...this should answer your question: http://education.oracle.com/masters/index.html -Original Message- Sent: Tuesday, 06 March, 2001 9:05 AM To: Multiple recipients of list ORACLE-L Does it still exist? I can't find reference to it anywhere in the new www.oracle.com http://www.oracle.com layout. I am just curious - I had major problems with it when they informed me that taking Microsoft courses on NT wasn't good enough, to be certifiable as an Oracle on NT Master you had to have learned NT from... Oracle. Even though their course names were identical to the MS ones. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Rgion des Maritimes, MPO E-Mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yexley Robert D SSgt AFIT/SCA INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 installation
Yeah I can see that absolutely. I just completed migrating a test database that we are testing for migration from 7.3.4 to 8.1.6. The reason I migrated it was because it had originally been on an UltraSparc 1 that had 192 MB of RAM and the thing would hardly run on that hardware. We ended up having to move it to another machine because of the lack of resources on the original machine. So yeah, I can see how doing this on a machine with 128 MB of RAM would take more than a day. -::YEX::- ))) -Original Message- Sent: Wednesday, 14 March, 2001 6:40 AM To: Multiple recipients of list ORACLE-L Hi, Anyone tried install Oracle8i in Solaris with 128 Mbyte of memory ? Is a stand alone server Oracle 8.1.6, not a production, is not hang but more than 1 day to finish create a database ??? -- 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: Yexley Robert D SSgt AFIT/SCA INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: email Problem in WINDOWS 2000 Server -off Topic
Title: email Problem in WINDOWS 2000 Server -off Topic Yeah, that's probably a true statement. I wish I could say it was that easy to find answers to problems with Oracle. It's not like I can just log in to Metalink and find what I need. I consider it a good day if I can get it to load just once, let alone stay connected long enough to find what I need. -Original Message-From: Kevin Kostyszyn [mailto:[EMAIL PROTECTED]]Sent: Thursday, 22 March, 2001 13:34 PMTo: Multiple recipients of list ORACLE-LSubject: RE: email Problem in WINDOWS 2000 Server -off Topic That looks like an exchange server problem possibly. I would think the easiest way to solve this is to go to microslops web site and type in the error. I am sure someone else has come across this and solved it already. Or, as funny as it is, you could even type it in at Yahoo and probably get some answers. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Adi MurugaianSent: Thursday, March 22, 2001 12:58 PMTo: Multiple recipients of list ORACLE-LSubject: email Problem in WINDOWS 2000 Server -off Topic Please tell me, where do I find a user group for Windows 2000 Server: If any one help me to solve the following problem, greatly appreciated: We were using II4 on Windows NT 4 for Web server. Through ASP program using 'CDONT' we were sending emails. It was working properly till we upgrade our Webserver and Exchange Server. We upgraded our WEB Server from Winodws NT 4 to Windows 2000 and IIS 4 to IIS 5 and also we upgraded we Exchange server from Windows NT 4 to Windows 2000. Now all the mails are bouncing back. The body of the return message is as follows : "This is an automatically generated Delivery Status Notification. Unable to deliver message to the following recipients, due to being unable to connect successfully to the destination mail server. [EMAIL PROTECTED]"
RE: Question on lists
OK, this company is spending the money to support FOUR different database platforms for WHAT reason -Original Message- Sent: Thursday, 19 April, 2001 14:16 PM To: Multiple recipients of list ORACLE-L Hi I was wondering if anyone here knows of a DB2 list like this one, my company is getting a DB2 server running on OS390, so now I will have to support DB2 in addition to Oracle, Sybase and MS sqlserver this gets quite festive when you are the lone DBA. Thanks Rich Richard A Sharpe DBA Amherst Corporate Computer Sales and Solutions 40 Continental Blvd Merrimack, NH 03054 Phone: (603) 579-6180 / 800-431-8031 Fax: (603) 578-1072 Email: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sharpe, Richard INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Yexley Robert D SSgt AFIT/SCA INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: This maybe interesting
the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yexley Robert D SSgt AFIT/SCA INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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]: Oracle vs DB2
I too would love to see somebody give Oracle a reality check in regards to the prices of their software, but as much as I hate to say it, I just don't see it happening. Why? Because the ONLY reality check that Oracle is going to actually LISTEN to and do something about would be for people to stop using/buying their products. And I just don't see that happening either. In the enterprise data market, Oracle has the best product available (IMHO), and I think most people, and especially including Oracle Corp., know this. Based on that information alone, I just don't see them backing down their prices when, as much as people hate paying, they still will, because it's the best. =( -::YEX::- ))) -Original Message- Sent: Wednesday, 25 April, 2001 12:50 PM To: Multiple recipients of list ORACLE-L Tim, Thanks for the copy of the marketing speil, I had not heard that one before. But, I'll take great exception to the claim that: It would make sense to select a database product based on price alone if database products were the predominant part of the overall information technology expenditures But this is simply not the case. Software costs (including upgrades and technical support) typically represent less than 15% of an IT budget and are small compared to the overall costs of hardware, operations and maintenance, consulting and training. I don't know about the remainder of you, but the cost of Oracle's software is quickly eclipsing the cost of everything else. Hence the beginnings of this post, which I agree with. In our company our yearly Oracle Support Agreement renewal is the #3 cost item and the cost of a new Oracle license exceeds the cost of the server it's going on. Someone PLEASE give these guys a reality check or else a good swift kick in the pants!! Dick Goulet -- 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: Yexley Robert D SSgt AFIT/SCA INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Sample Scripts
Metalink has some really good scripts. I'd try that (it's actually been running half-way decent lately, you might get lucky =). -::YEX::- ))) -Original Message- Sent: Wednesday, 02 May, 2001 11:37 AM To: Multiple recipients of list ORACLE-L Hi, We recently lost our DBA, and as I was standing too close to our IT manager, now I'm it. As I get started on reading and studying, I quickly need some scripts to monitor 'normal' stuff on 7.3.4. I'm used to SQL as a developer, so that helps. So, do you know of a source where I can download some quality scripts? TIA, Rick __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Fred Collington INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Yexley Robert D SSgt AFIT/SCA INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Password with special character
If you're using the a profile with a password_verify function, then you shouldn't be using ALTER USER to change a user's password. If you are trying to change the password through SQL*Plus, then you should instead be using the SQL*Plus PASSWORD command: SQL PASSWORD username Using this command will validate the user's new password using the password_verify function that is specified in the user's profile, and will allow for the password to contain the special characters that you are trying to use. When you use ALTER USER it doesn't use that password_verify function, and because it is a DDL command, it limits you to Oracle's object naming restrictions, which will not allow you to use most special characters. For more information on this, see the Oracle8i Administrators Guide, pp 21-15 under Password Complexity Verification, and also the SQL*Plus Users Guide and Reference Release 8.1.6, pp 8-76 for details on using the PASSWORD command. Both of these documents are available on Metalink. -::YEX::- ))) -Original Message- Sent: Friday, 11 May, 2001 10:01 AM To: Multiple recipients of list ORACLE-L Hi Thye Hock Gan, Thank you for your info. I am using Oracle 8.1.6 Solaris 7 Install patch bug122 for SQL*PLUS How can I change user password with special character alter user teddy identified by bear12#$; is not working because of alter user teddy identified by 'bear12#$'; also not working I have password_verification profile with verify_function that provided by Oracle Administrator Guide that must at least 1 special character in user password. Thank you, Sinardy -Original Message- Sent: Friday, 11 May 2001 6:34 PM To: LazyDBA mailing list This are characters you can use: !#$%()'*+,-/:;+_ if I'm not mistaken. Try them anyway. --- Sinardy Xing [EMAIL PROTECTED] wrote: Hi all, Can Oracle User change their password with special characters? Thank you very much Sinady Think you know someone who can answer the above question? Forward it to them! To unsubscribe: send a blank email to [EMAIL PROTECTED] To subscribe: send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ Think you know someone who can answer the above question? Forward it to them! To unsubscribe: send a blank email to [EMAIL PROTECTED] To subscribe: send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy Xing INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yexley Robert D SSgt AFIT/SCA INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Datafile Migration Tool
Sounds to me like it could potentially save a considerable amount of time for someone who may be migrating their database across platforms. Especially if you're one of those shops out there that has a significantly large database. That can get to be a pretty big hassle (in just time consumption if nothing else) to have to do a full database export and then full database import to migrate your data. -::YEX::- ))) -Original Message- Sent: Tuesday, August 14, 2001 5:27 PM To: Multiple recipients of list ORACLE-L I'm not trying to be mean about it. I am honestly curious as to what kind of benefit is expected from the tool or how it will work to make my life easier. --Scott Rachel Carmichael wrote: it doesn't sound like an ftp type tool. If I am reading this correctly, he is proposing to provide a tool that copies datafiles directly from one OS to another. While this is an interesting trick, I'm not sure there's a large market for it. From: Scott Shafer [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: Datafile Migration Tool Date: Tue, 14 Aug 2001 12:00:53 -0800 Not to be a smartass, but don't most OS's already have ftp built in? What kind of value-added are you proposing? Just curious... Scott Shafer San Antonio, TX K Gopalakrishnan wrote: Hi , Will there be a market if I give a tool which migrates Oracle database from One OS to another OS. (Data file migration at Operating System Level.) i.e it will convert from Oracle data files on NT to Oracle Datafiles on Solaris and vice versa. In the target database you need to recreate the control files and you are done. You can startup the database. You don't need to export/import or CTAS over dblink.. Send your replies directly to me.. Thanks Yong..for bringing the cat out of the basket ;) = Have a nice day !! Best Regards, K Gopalakrishnan, Bangalore, INDIA. _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Shafer INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Shafer INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Yexley Robert D SSgt AFIT/SCA INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing
RE: NT backup script question
If you look in the WinZip help files, it can be used for this. It has it's own command line switches for creating archives from scripts also. -::YEX::- ))) -Original Message- Sent: Friday, August 17, 2001 12:25 PM To: Multiple recipients of list ORACLE-L PowerArchiver is another good one, I know a couple of the people on the list use it to compress their NT backup sets From: Mark Leith [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: NT backup script question Date: Fri, 17 Aug 2001 07:34:19 -0800 Try PKZIP, this has a command line interface.. You can most probably find it with a search for the name on the web.. HTH Mark -Original Message- Sent: Friday, August 17, 2001 12:41 To: Multiple recipients of list ORACLE-L I have a NT cold backup script but I would like to add at last a winzip or any other compress command. Any idea from someone who has already done this ? Thanx -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yexley Robert D SSgt AFIT/SCA INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: multiple copies of jre.exe on one server
I'm sorry to say that I can't tell you whether or not that is normal behavior, because I just don't know. But one thing that I CAN say is this...count your blessings that you're not running iFS...that thing runs like 8 different instances of jre.exe on average. It's crazyyou need a pretty massive, high powered server to effectively run that software. -::YEX::- ))) -Original Message- Sent: Thursday, August 23, 2001 10:01 AM To: Multiple recipients of list ORACLE-L How many copies of jre.exe should be running on an iAS 1.0.2.2. server? My server has four copies running, and the HTTP server NT service refuses to start. I am wondering whether I should shut down all the Oracle Web-related components, kill.exe any remaining jre.exe processes, then start everything up again. I would like to know why one copy of jre.exe isn't enough... Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yexley Robert D SSgt AFIT/SCA INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: RedoLogs switching
Check your alert log. -Original Message- Sent: Friday, August 24, 2001 11:51 AM To: Multiple recipients of list ORACLE-L Hi, How to Know when switching RedoLogs occur? Oracle 8.0.6.2 TRUE 64 5.0 Thank's... javs -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jairo Villalobos INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Yexley Robert D SSgt AFIT/SCA INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Database Trigger Confusion
I have created a trigger on a table to write information to a history table, and I've run into some behavior that's confusing me...some clarification would be greatly appreciated. My trigger code is as follows: CREATE OR REPLACE TRIGGER endb.budget_total_amt_hist_trg BEFORE UPDATE of total_amt_auth, expiration on endb.budget FOR EACH ROW BEGIN code_to_rollover_data_to_history_table END; Now my confusion lies in the fact that the trigger is supposed to fire ONLY when either the total_amt_auth column OR the expiration column gets updated. Now, of course it works fine when we update either of those columns. But the problem/confusion is why is it also firing when we update other fields in the table also?? If we update any column other than those two the trigger still fires. What am I doing wrong or missing/forgetting??? -::YEX::- Robert D. Yexley, SSgt Air Force Institute of Technology Applications Services Division (SCA) Oracle DBA Programmer ))) [EMAIL PROTECTED] DSN - 785-6565 x-4268 Commercial - (937) 255-6565 x-4268 _ God who gave us life gave us liberty. Can the liberties of a nation be secure when we have removed a conviction that these liberties are a gift of God? Indeed I tremble for my country when I reflect that God is just, that his justice cannot sleep forever. - Thomas Jefferson, 3rd US President __ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yexley Robert D SSgt AFIT/SCA INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Implementing Stored Procedures
Title: Implementing Stored Procedures One option (and I'm not suggesting that this is the BEST option by any means, but it IS an option =) might be to grant the developer(s) the 'CREATE ANY PROCEDURE' role, and then have them create their procedures/functions/packages etc as schema_name.object_name, with schema_name being the name of the application schema that the object will need to be in. -::YEX::- ))) -Original Message-From: Yttri, Lisa [mailto:[EMAIL PROTECTED]]Sent: Thursday, 31 May, 2001 13:02 PMTo: Multiple recipients of list ORACLE-LSubject: Implementing Stored Procedures Hi - I'd like some advice on implementing stored procedures containing application logic (ie. written by developers). We have several applications where the developers use stored procedures for much of their coding. We let the developers create or replace their procedures in a development environment under their own schema (with access to all application tables, etc.) to test the logic, but it currently requires a DBA to implement the proc under the application schema. It has gotten to be a very time-consuming job. We don't want to give out the schema owner password to the developers, nor do we know of a way they could add them as the schema owner without giving them more privileges than we want. I am curious of how others are handling stored procedure additions and modifications. Do you somehow allow developers this access? If so, how do you restrict them from damaging other things? If not, does the DBA do it? Does anyone have an automated way? Also, do you keep track of the original "source code" for the procedure, or do you extract it out of the database as needed? Thanks so much for your input - Lisa
RE: Renaming columns ...
You can get the same interface for the 8i docs as well at http://tahiti.oracle.com/pls/tahiti/tahiti.homepage. Just in case you were interested. =) -::YEX::- ))) -Original Message- Sent: Monday, 04 June, 2001 14:42 PM To: Multiple recipients of list ORACLE-L Kevin, see this link ... http://otn.oracle.com/docs/products/oracle9i/doc_library/901_doc/server.901/ a90117/tables.htm#12596 this link will be broken, but put it on one line and click ... there is a complete example ... BTW Oracle has done one job very well ... the 9i document search interface, it rocks !! Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art ! *4 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. *4 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jamadagni, Rajendra INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Yexley Robert D SSgt AFIT/SCA INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 stands for i in Oracle 8i
I believe it stands for "internet", as in, the "internet" database. -Original Message-From: Muthaiah [mailto:[EMAIL PROTECTED]]Sent: Wednesday, 06 June, 2001 12:56 PMTo: Multiple recipients of list ORACLE-LSubject: What stands for i in Oracle 8iHi,I am just curious about to know for what that i stands for in Oracle 8i.Can any one shed some light?Thanks, Muths"Do not go where the path may lead, go instead where there is no path and leave a trail."
RE: Oracle 8i database ER diagram
Would you mind explaining to me how to go about reverse-engineering a database with Designer please. I downloaded Designer6i a couple of weeks ago, and have been trying ever since to figure out how to reverse-engineer our database into an ER diagram, but the docs for Designer are absolutely WORTHLESS, and it doesn't explain anywhere (not that I can find anyway) HOW to go about doing a reverse-engineering of an existing database. Any help would be GREATLY appreciated. Thanks. -::YEX::- ))) -Original Message- Sent: Tuesday, 12 June, 2001 9:16 AM To: Multiple recipients of list ORACLE-L Magesh, You could use either of the following tools to build your ERD through reverse engineering. 1. Oracle Designer 2. ERWIN In my company we use both the above products. I personally prefer using Oracle Designer due to many reasons (My reasons are irrelevant here for the purpose of answering your question). If it is one time job, then you could download either of the products free (Please check whether you could do reverse engineering with a free downloaded version). Rao -Original Message- Sent: Tuesday, June 12, 2001 7:01 AM To: Multiple recipients of list ORACLE-L What about to use Oracle Designer?. Regards. Miguel Urosa. 12/06/2001 11.00 magesh [EMAIL PROTECTED] 12/06/2001 11.01 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rao, Maheswara INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Yexley Robert D SSgt AFIT/SCA INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 8i database ER diagram
THANK YOU TOM!!! This message alone is FAR better information than ALL of the GARBAGE put together that Oracle has available on their sites (TechNet, Metalink, all of 'em) on how to use Designer. At least now I have some idea of where to begin. Thanks so much! -::YEX::- ))) -Original Message- Sent: Tuesday, 12 June, 2001 11:01 AM To: Multiple recipients of list ORACLE-L Yex, Start Up designer. Click on Repsitory Object Navigator Select Application Systems Click the Green Plus Icon (left menu bar) and create an application system (name it something you like to identify it as your application). Noe, go back to the Oracle Designer startup panel and Click on the Design Editor Icon. Under Global Shared Workarea, open up your application. Create an Oracle database by (again) clicking on the Green Icon. Create the user you wish to reverse-engineer from. The user within the Repository database will become the placeholder for all of the database objects. Click on the user you just created. select (from the menu on the top) Generate|Capture Design of|Server Model This will give you a dialogue window with more options. Enter the Oracle Account/Password and connect string for the database you are rev-engineering from. *** Look at the TARGET CONTAINER/CAPTURE IMPLEMENTATIONS INTO selection at the bottom - make sure these are correct. Select the Objects tab and reverse engineer the database objects one at a time ion the following order: Tablespaces if these do not exist before you rev-eng the tables, you get warnings Database Roles (only capture the roles you created for your application) you need these to correctly reverse-engineer grants to objects. Database Users (skip the one user you created by hand) again - to capture the grants to database objects Now you can begin your schema objects Sequences Tables Views If you have a large amount of database objects, you may want to break up the capture of the tables into sections. Be prepared for application crashes - it gets overwhelmed at times. Also, have a lot of patience. Thsi can be done, but you may have to perservere to succeed! good luck! Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, June 12, 2001 10:27 AM To: Multiple recipients of list ORACLE-L Would you mind explaining to me how to go about reverse-engineering a database with Designer please. I downloaded Designer6i a couple of weeks ago, and have been trying ever since to figure out how to reverse-engineer our database into an ER diagram, but the docs for Designer are absolutely WORTHLESS, and it doesn't explain anywhere (not that I can find anyway) HOW to go about doing a reverse-engineering of an existing database. Any help would be GREATLY appreciated. Thanks. -::YEX::- ))) -- 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: Yexley Robert D SSgt AFIT/SCA INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: OCP Discount?
When you fill out their OCP survey, they will give you a promotion code for the discount. You use that promotion code when you schedule your test with Sylvan Prometric. -::YEX::- ))) -Original Message- Sent: Wednesday, 13 June, 2001 16:07 PM To: Multiple recipients of list ORACLE-L I was looking over the OCP stuff on Oracle's web site and them mentioned a 20% discount. However, I can't find were to apply for it. Any ideas? Thanks, Ken Janusz, CPIM -- 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: Yexley Robert D SSgt AFIT/SCA INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 NEEDED TO MAKE THE CREATE TABLE SCRIPTS OF A SCHEMA.
I just finished this the other day. It works for individual tables only, but you could pretty easily modify it to work for all of the tables within a schema. Hope it helps. -::YEX::- ))) -Original Message-From: Bunyamin K. Karadeniz [mailto:[EMAIL PROTECTED]]Sent: Monday, 02 July, 2001 13:46 PMTo: Multiple recipients of list ORACLE-LSubject: SCRIPT NEEDED TO MAKE THE CREATE TABLE SCRIPTS OF A SCHEMA. Hi Gurus, I do not have time to write it. IF you have a script creating the create table scripts of a schema, I will be so happy . Thanks Bunyamin gen_table_ddl.sql
RE: SCRIPT NEEDED TO MAKE THE CREATE TABLE SCRIPTS OF A SCHEMA.
I wanted to throw this out there for anyone/everyone, whatever. Being the struggling, wannabe DBA that I am, if anyone gets a chance (or would be willing, just to help me out) to take a look at this script (the one attached to the original message) and provide any feedback/observations as to how it could be improved, I would certainly be open and appreciative. Direct responses would probably be most appropriate. Thanks for your time. -::YEX::- ))) -Original Message-From: Yexley Robert D SSgt AFIT/SCA [mailto:[EMAIL PROTECTED]]Sent: Monday, 02 July, 2001 14:51 PMTo: Multiple recipients of list ORACLE-LSubject: RE: SCRIPT NEEDED TO MAKE THE CREATE TABLE SCRIPTS OF A SCHEMA. I just finished this the other day. It works for individual tables only, but you could pretty easily modify it to work for all of the tables within a schema. Hope it helps. -::YEX::- ))) -Original Message-From: Bunyamin K. Karadeniz [mailto:[EMAIL PROTECTED]]Sent: Monday, 02 July, 2001 13:46 PMTo: Multiple recipients of list ORACLE-LSubject: SCRIPT NEEDED TO MAKE THE CREATE TABLE SCRIPTS OF A SCHEMA. Hi Gurus, I do not have time to write it. IF you have a script creating the create table scripts of a schema, I will be so happy . Thanks Bunyamin
RE: arrays in PL/SQL
No, you can use PL/SQL tables for that. PL/SQL tables are the PL/SQL equivalent of arrays in other languages (well, it's about as close as you're going to get anyway). -Original Message- Sent: Tuesday, July 10, 2001 4:41 AM To: Multiple recipients of list ORACLE-L I want to create arrays of a user defined record in PL/SQL Do I need nested tables/varrays and therefore the Object option : do I need Enterprise Version is 8.1.7 John -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Dunn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Yexley Robert D SSgt AFIT/SCA INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Problems with patchsets to 8.1.7.0.0 on Windows 2000
I had that same problem with it. I ended up getting it to work OK when I navigated into the directory structure that the zip file creates (or on CD, whichever you're running it from) into patch_base\install\win32\setup.exe and ran it from there. This actually runs the OUI instead of the unnecessary little autorun executable that they put in the root directory. Try that, I think that will work for you. -::YEX::- ))) -Original Message- Sent: Tuesday, October 02, 2001 2:29 PM To: Multiple recipients of list ORACLE-L I have Oracle 8.1.7.0.0 running on a Windows 2000 Pro (sp2). I tried to install the 8.1.7.2.1 patchset according to the readme directions (shutdown all Oracle* services first, etc.), but when I try to run setup.exe, nothing happens. The icon flashes momentarily after being double-clicked, but nothing ever actually runs. I tried it a number of times. Then I tried it with an older 8.1.7.1.1 patchset - and the exactly same thing happened. These patchsets are for Windows NT, but I assumed they would work for 2000 as well. (Am I wrong in this assumption?) Does anyone have any experience with this and/or workarounds? -Don Granaman [OraSaurus - Honk if you remember UFI!] -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yexley Robert D SSgt AFIT/SCA INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 - SQL Server
Title: Oracle -> SQL Server The only thing that I can think of would be the Oracle Transparent Gateway for SQL Server. Although on the surface it appears to be a fairly complex tool, which means it may not be worth the effort over just going ahead and migrating. Just a thought. -::YEX::- ))) -Original Message-From: Christopher Spence [mailto:[EMAIL PROTECTED]]Sent: Tuesday, October 02, 2001 2:41 PMTo: Multiple recipients of list ORACLE-LSubject: Oracle - SQL Server I know there is a way in SQL server to query oracle tables, is there a way to do the reverse? I am looking at trying to create access from an Oracle DB to SQL Server data until we convert the SQL server database. Anyone have any ideas on this, I searched technet (ms/oracle) and metalink, as well as some search engines without luck. "Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes." Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax: (707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863