Re: Oracle's jdbc driver

2003-12-13 Thread David Hau
The method you need is: OracleDatabaseMetaData.getDriverVersion() Write a small Java program to call this method, or take a look at Metalink note 94091.1 or 73629.1 for sample code to get JDBC driver version. Regards, Dave [EMAIL PROTECTED] wrote: Hi All How can I findout what is the version

Code Conversion from MSSQL into Oracle

2003-12-13 Thread VIVEK_SHARMA
Are there any TOOLs for converting Sample Code (like the following) from MSSQL into Oracle? SAMPLE :- DECLARE @entity_id char(32), @branch_id char(9) DECLARE cur_temp_GEMT CURSOR FOR select branch_id,entity_id from GEMT where other_party_name='' and entity_type='D' OPEN

Re: automate backup and export

2003-12-13 Thread John
Any reference concerning the rman? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, December 12, 2003 10:19 PM Yes. It's called RMAN. On 12/12/2003 02:04:46 PM, John wrote: Do you know any script for doing export and backup of Oracle 9i

Re: 170systems

2003-12-13 Thread Eric King
If the zip file is less than 1MB, can you also send me one copy. I heard it on the radio, but do not know how it works. Thanks Eric - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Saturday, December 13, 2003 00:24 Hi Allan , Thanks for your quick

Re: 170systems

2003-12-13 Thread Nalla Ravi
hi , CAN YOU PLEASE SEND ME ONE COPY AS WELL. Reg, Ravi --- Eric King [EMAIL PROTECTED] wrote: If the zip file is less than 1MB, can you also send me one copy. I heard it on the radio, but do not know how it works. Thanks Eric - Original Message - To: Multiple recipients of

Re: 24 x 7 x 365

2003-12-13 Thread Murali Vallath
Tanel, I think this is a good solution, provided the application can handle two phased commit protocol across both the databases, else there could be orphan records on one or both these databases. Murali Tanel Poder [EMAIL PROTECTED] wrote: When you want true 24x7 without compromises, then you

Re: 24 x 7 x 365

2003-12-13 Thread Murali Vallath
If this is the customer you are talking about, this database supports over 12 million subscribers.. Murali Tim Gorman [EMAIL PROTECTED] wrote: As I mentioned a few minutes ago in another thread, there is an application using Oracle Rdb on an HP OpenVMS cluster located at HP in Colorado Springs

Re: 24 x 7 x 365

2003-12-13 Thread Ryan
i was just in the bookstore. are you the one who wrote the new RAC book? you do realize the whole thing word for word is in a .pdf on otn? - Original Message - From: Murali Vallath To: Multiple recipients of list ORACLE-L Sent: Saturday, December 13, 2003 10:09

Re: automate backup and export

2003-12-13 Thread Paul Drake
John, Oracle publishes reference material available on OTN. You can sign up for an account on http://otn.oracle.com, where you can find their documentation and articles. for example: Configuring Oracle Recovery Manager http://otn.oracle.com/oramag/oracle/02-nov/o62support.html or the RMAN

Re: automate backup and export

2003-12-13 Thread Mladen Gogala
In addition to that, you don't need any expensive software. The original poster said that his platform is SuSE. Well, I'm on RH-9, which is almost the same. Almost. When I want to back up a database, I write 700M backup pieces to the filesystem that I have for this purpose and use xdroast to

Re: Re: 24 x 7 x 365

2003-12-13 Thread Tanel Poder
Yep, I also think so. I'm currently developing a small prototype for this kind of transparent proxy, which I'll post here when it's stable... Tanel. Tanel,   I think this is a good solution, provided the application can handle two phased commit protocol across both the databases, else there

How to Install Oracle Management Server

2003-12-13 Thread Nirmal Kumar M
How to configure oracle management server. I want to explore OEM fully. I cann't find any installation guide for this in otn. Is OMS is must for dataguard, RAC?. Nirmal. = fsdfsdfsdfsdfs __ Do you Yahoo!? New Yahoo! Photos - easier uploading and sharing.

RE: How to Install Oracle Management Server

2003-12-13 Thread Chandra Pabba
Hi Nirmal, Please take a look at the following two links which are pointers to the OEM documentation. Oracle Enterprise Manager Configuration Guide http://download-west.oracle.com/docs/cd/B10501_01/em.920/a96673/toc.htm Oracle Enterprise Manager Administrator's Guide

RE: How to Install Oracle Management Server

2003-12-13 Thread Sami
what is ur OS? If it is windows select Enterprise Manager Configuration Assitant which is under Configuration Tools. This will install configure OEM repository for you. -Original Message- Nirmal Kumar M Sent: Saturday, December 13, 2003 5:24 PM To: Multiple recipients of list ORACLE-L

Re: Who are certified Oracle Masters?

2003-12-13 Thread Jared Still
This is a family oriented mailing list folks. :) Jared On Fri, 2003-12-12 at 15:19, Richard Foote wrote: Hi Jeremiah, I find the mental image of the six of you holding up your shafts for a publicity shot profoundly disturbing... Cheers ;o) Richard - Original Message - To:

RE: automate backup and export

2003-12-13 Thread DENNIS WILLIAMS
John What is your intention? If you have created a test Oracle database on your Linux system just to learn, then just shut the database down and back up all files. If you have some important data in this database that changes frequently, then you need to learn about Oracle backup recovery.

Changing Character Set from WE8ISO8859P1 to UTF8

2003-12-13 Thread Arnold, Sandra
I am in the process of planning our upgrade for our 8.1.5 database to 8.1.7.4. This is the first step in upgrading all my databases to 9.2.0.4. As part of this upgrade I am changing the character set from WE8ISO8859P1 to UTF8. Has anyone done this change using the ALTER DATABASE CHARACTER SET

RE: Changing Character Set from WE8ISO8859P1 to UTF8

2003-12-13 Thread Pandian, Thiru
I have upgraded the database from 8.0.5/8.1.7 to 9.2.0.4 and changed character set using alter database character set. It will work without any problem. Go for it. -Original Message- Sent: Saturday, December 13, 2003 9:39 PM To: Multiple recipients of list ORACLE-L I am in the process

RE: Performance tuning in complex environment

2003-12-13 Thread Cary Millsap
Avnish, The book goes through this a bit on p61. There are a few tools out there, including three from Oracle. As I mention in the book, I use our own Hotsos Profiler, described at www.hotsos.com/products/profiler.html. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming

RE: rebuilding indexes - sure to cause a ruckus

2003-12-13 Thread Cary Millsap
not to mention running 48 batch jobs on a 8CPU box with all of them committing after every record and using the table to generate keys (Cary would love this one) ;) They wanted to find other reasons and he conveniently ignored the real problem. Beautiful... Cary Millsap Hotsos