Re: Data Transfer or Views from SQL Server to Oracle

2003-03-15 Thread Stephane Faroult
Nikunj Gupta wrote: Hello, SQL Server in on Windows 2000 Box. Oracle 8.1.7 is on Unix. Is there any process by which data can be transferred from SQL SERVER to ORACLE directly.. something like views / snapshots. (Requirement is almost realtime data from SQL Server to Oracle) I am

RE: Backup Strategy

2003-03-15 Thread Jack van Zanen
I put them on http://www.vanzanen.com/rman.zip They are oracle 8.0 (if memory serves me right) so they won't work with 9i. I'll see if I can find the time to do the same for 9i one of these days (have to learn SQL Server first) Jack -Original Message- Sent: vrijdag 14 maart 2003 20:24

Re: Data Transfer or Views from SQL Server to Oracle

2003-03-15 Thread Raman Pujani
2 Options: 1. Use MS Data Transport Service (DTS) and schedule transfer task 2. Write a Java program that will connect to both databases and transfer the data. Raman. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Saturday, March 15, 2003 12:48 PM

RE: Server Recommendations

2003-03-15 Thread Jamadagni, Rajendra
Title: RE: Server Recommendations Others have talked about CPU ... consider licensing costs too. But 512MG RAM? Gimme me a break ... I have 768MB RAM on my home PC that I use for casual work. But the max RAM that your bean counters will allow you to, and then some more. This is true,

RE: Multiple Instances and 9iRAC

2003-03-15 Thread Jamadagni, Rajendra
We run 4 production databases on one dual node RAC, each node hosting one instance of each database. Raj -Original Message-From: Thompson, Todd [mailto:[EMAIL PROTECTED]Sent: Friday, March 14, 2003 5:44 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Multiple

Re: Data Transfer or Views from SQL Server to Oracle

2003-03-15 Thread Arup Nanda
Nikunj, You can try something I did a long time ago, in Oracle 7.3; but it's also applicable now. Create an ODBC datasource on the machine where the SQL Server resides to pint to the Oracle database. For the initial load, I suppose you can create a table in SQL Server as select * from

RE: Statspack recomendations.

2003-03-15 Thread M Rafiq
The bookpool is no doubt the best and clean site for tech books with low SH charges. For price comparison http://www.bestwebbuys.com/books/ is a good site... Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Fri, 14 Mar 2003

Re: log buffer space

2003-03-15 Thread Mogens Nørgaard
It's a fantastic ratio :-). Anjo Kolk wrote: 1 log switch per minute ;-) AK wrote: log buffer is 320 K and log files are 30M approx. there are about 50 log switch /hr . -ak - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, March 14, 2003

RE: Server Recommendations

2003-03-15 Thread DENNIS WILLIAMS
Tom If this is a multitier system, what will be running on this server? Both Oracle DB and an application server? I second Raj's comment, consider Oracle licensing. Servers today are priced as commodities. Oracle DB is not. If you run only Oracle DB on a server, you will get maximum benefit

OT: Anybody using QlikView BI tools?

2003-03-15 Thread Don
After management learned the cost of Cognos PowerPlay, they decided to look at QlikView from QlikTech (Sweeden). I would be interested in hearing from anybody that has had experience with this BI tool. Pro and con issues are welcome. Thx - Don -- Please see the official ORACLE-L FAQ: