RE: snapshot too old
2. Fix: Increase Rll Back segments 1. Why: Oracle RDBMS tries to provide "Read consistent " viiew of the data ( changed or clean ) at the "statement level" read consitency and "transaction level" read consistency This isone of the whys- an Oracle DBA's makeshis living in their employment as Oracle DBA. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]Sent: Friday, March 28, 2003 12:19 PMTo: Multiple recipients of list ORACLE-LSubject: snapshot too old why a select statement can give snapshot too old erorr . there is no update , yes but its a long running query . what is fix for this ? -ak
RE: enterprise manager console and sqlplus worksheet can't work
If it is NT/2000 platform, Oracle installer normally screws up the registry entries, for example TNS_ADMIN in registry etc. Some product also screws up DLL ( specially microsoft DLL) files , if installed in the same oracle Home ( overwrite good DLLs with new but incompatible DLL) . 1. See, if OLD TNS_ADMIN is overridden by new TNS_ADMIN. Copy old stuff into the tnsnames.ora of new TNS_ADMIN. You will be lucky if this is the case. 2. Deinstall and reinstall all of the stuff in seperate home. Lots of work. In between install(s), you can export registry entries for backup and compare. 3. Some products have to be in same oracle home and will still screw up. In that case call Oracle :). Meanwhile, you can again deinstall everything and try, change the order of install of the product. I am assuming here that you have no other work, but do these over and over again. Pradip -Original Message- Sent: Thursday, March 27, 2003 12:09 AM To: Multiple recipients of list ORACLE-L afer installed the development tools I downloadd the developer suites from www.oracle.com such as jdeveloper. But after I installed it .my oracle enterprise manager console and sqlplus worksheet cant work which I installed before. Why ,and how to make them work . Thanks in advance! Regards Liujd -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: liujd INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: moving away from mainframeing
Oracle corp provides some migration assistance. In my experience, database migration is easier part ( in terms of man days, technical difficulties , testing etc.). Application conversion/migration could be tougher and more time consuming depending on the decision you have made ( complete rewrite/ convert on Oracle RDBMs). For Migration related help/service/toolkit, you can search oracle site or contact Oracle Folks (they have a migration expertise group within their org). If you are using COBOL with embedded Sql ( Pro*CoBOL for Oracle product), then you will be able to convert to Oracle with less pain. It also depends on the architecture of the application or how the apps/rdbms inteface has been handled. Other (significant)factor would be usage of special datatypes ( LOB/CLOB/Raw of your rdbms) and how that mapps to Oracle datatypes and Cobol/application data types Thanks and Best Regards, Pradip -Original Message- Sent: Wednesday, March 26, 2003 4:49 AM To: Multiple recipients of list ORACLE-L hi list Is there somebody on this wonderfull list considering to move away from the mainframe computer with his old RDMS to another platform (MS or UNIX) with oracle/sqlserver ? What are your scenarios : Big bang or keep 2 database in synch (how ?) Anyone with Unisys Clearpath systems with this case ? Thanks for your contribution vr.gr. G.g. Kor Sr. System Engineer IDM Db RDW Voertuiginformatie en -toelating -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle Vs DB2
Oracle has some internal site for "competetive" info. You can browse the oracle site www.oracle.com to start with. You can also contact oracle "Sales" Consultants if know your Oracle Account Manager ( Sales Rep). www.oracle.com may also have some contact info ( for example some Telesales contacts) who would love the "lead", given by you. Thanks and Best Regards, -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]Sent: Monday, March 24, 2003 3:15 AMTo: Multiple recipients of list OR[Biswas, Pradip]ACLE-LSubject: Oracle Vs DB2 Dear All, Strange as it seems, my client has asked me to compare Oracle with DB2 with regard to all the DB functional aspects. They are more inclined towards DB2 and we have the application built on Oracle. We are in for a one-to-one comparison based on the features that we already have in Oracle and that are in use in our application. For eg, function based indexes, table clustering, RAC, partitioning (of all kinds - list,range,hash), External tables, to name a few. I would really appreciate if anyone can throw some light into this. Links to any sites would also be helpful. We dont have much time for this activity, so please help us. I havent worked in DB2 as well which is the biggest bottleneck that I face.Best RegardsJai