Re: Oracle Migration 8.1.6.0 to 8.1.7.2
Just an aside, I have been pretty unhappy with 8.1.7.1.2, lots of crashes/core dumps with 7445 errors. I would not suggest going there, I hope 8.1.7.4 is a better place to be. On Thu, Jul 18, 2002 at 09:43:26AM -0800, Fowler, Kenneth R wrote: List, One of the DBA's here needs to migrate a fairly sizeable database from 8.1.6.0 to 8.1.7.2 on Solaris. The doc's state that it is advisable to migrate to 8.1.7.0 and then go to 8.1.7.2 but we don't have 8.1.7.0 installed and don't want to install it unless we really have to. Anyone know if it is possible to migrate directly to 8.1.7.2 (docs don't explicitly say it can't be done but don't seem to suggest it either). Ken _ Clinical and Regulatory Informatics - Groton/New London Coordinator, Business and Technical Services Tel: (860) 732-0026 Fax: (860) 715-8346 Email: mailto:[EMAIL PROTECTED] LEGAL NOTICE Unless expressly stated otherwise, this message is confidential and may be privileged. It is intended for the addressee(s) only. Access to this E-mail by anyone else is unauthorized. If you are not an addressee, any disclosure or copying of the contents of this E-mail or any action taken (or not taken) in reliance on it is unauthorized and may be unlawful. If you are not an addressee, please inform the sender immediately. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Fowler, Kenneth R 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). -- === 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).
What do I call these Oracle/db things in Dutch?
Hi all, I'm trying to explain to some customers of ours in The Netherlands what I mean by some database terms - but my Dutch is limited to things about food ( broodjes, poffertjes, etc.), and their English is very good - but just not about databases. Any ideas what terms I'd use to describe referential integrity, cursors and extents? (Anjo, are you out there?) Thanks / Ahlsterbleift Fuzzy :-) -- Woo Hoo! - H. Simpson -- The contents of this post are my opinions only If swallowed seek medical advice (Apologies for the excess signature) This email message (and attachments) may contain information confidential to TOWER Software. If you are not the intended recipient you cannot use, distribute or copy the message or message attachments. If you are not the intended recipient, please notify the sender by return email immediately and delete all copies of the message and attachments. Opinions, conclusions and other information in this message and attachments that do not relate to the official business of TOWER Software, are not given or endorsed by it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Grant Allen 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).
connecting session to sqlarea to find the sql_text
Title: connecting session to sqlarea to find the sql_text Is there any means to connect session information (v$session) and v$sqlarea (or any other dynamic table) to find out which sessions have fired what sql_text? Any other workaround? rgds amar http://amzone.netfirms.com
V. Urgent - Got Stuck with trigger
Hi List, My friend has foll.(Big)problem. He'was testing the following trigger n now stuck. Do not execute this trigger on ur side. CREATE OR REPLACE TRIGGER tpp before alter or create or drop on database declare uname varchar2(20); begin select osuser into uname from v$session; if uname != 'Sachin' then raise_application_error(-20002,'not allowed); end if; end; Now he can't modify/drop this trigger, He gets the follow error: ERROR at line 1: ORA-00604: error occurred at recursive SQL level 1 ORA-01422: exact fetch returns more than requested number of rows ORA-06512: at line 4 - One thing I suggested is to make sure that there is only one session on server. Is that possible ? What are the other solutions ?? (Do not execute this trigger on ur side. if u don't know the solution) Thx Regards, Sam __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: sam d INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: OT: MicroSoft Admission
What the f* does this euphemistic cr*pola mean: ... | Our strategy has never changed with what we are | trying to do with consulting, but it sure looked | that way in the early part of the year because we | managed to get a disalignment between our | incentives and our resources and our strategy in | the marketplace, Ballmer said. That caused our | consultants to look sometimes less like your | friend and more like your foe than we ever have | intended it to. ... ??? On 19 Jul 2002 at 9:19, [EMAIL PROTECTED] wrote: Jared, First off my apologies for an off topic post, but considering the amount of OS discussions we have, I really don't think it's totally off base. Dick Goulet http://www.theregister.co.uk/content/4/26230.html Ballmer 'fesses up to Linux/Windows cost FUD By Thomas C Greene in Washington Posted: 16/07/2002 at 19:23 GMT ... -- 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).