RE: Outer join in SQL server - A very simple question

ORACLE-L FAQ: http://www.orafaq.net -- Author: Adrian Roe INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: SQL Server Q?

Title: OT: SQL Server Q? sp configure 'user connections' This is an advanced option (believe it or not), so you may have to do "sp configure 'show advanced options', 1" before you do "sp configure 'user connections'". Alternatively you can just run SELECT @@MAX CONNECTIONS Returns

RE: Upgrading from 8.1.7 32 bit to 9.2.0.3 64 bit

immediately and delete the material from any computer. == -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Adrian Roe INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

RE: OT SQL Server 2000 databases and Oracle tablespaces

Title: Re: Amt of Training to be considered "up to date" A SQL7/SQL2K Filegroup is equivalent to an Oracle tablespace. -Original Message-From: Boivin, Patrice J [mailto:[EMAIL PROTECTED]Sent: 25 March 2003 20:04To: Multiple recipients of list ORACLE-LSubject: OT SQL Server 2000

RE: MTS config

the sender immediately and delete the material from any computer. == -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Adrian Roe INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538

RE: Oracle Migration Workbench for Sybase

is prohibited. If you received this in error, please contact the sender immediately and delete the material from any computer. == -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Adrian Roe INET

RE: Migration from SQL Server to ORACLE 9i

: Adrian Roe 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

RE: migration from Sybase to Oracle

. == -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Adrian Roe INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting

RE: Middle Tier spawning sessions, possible performance issues

. If you received this in error, please contact the sender immediately and delete the material from any computer. == -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Adrian Roe INET: [EMAIL

RE: Win2k/8.1.7/SQL Question

Title: RE: Win2k/8.1.7/SQL Question Have a look at the SQL Referenceguide in the 8i docs. It says that 8i is broadly compatible with the ANSI SQL-99 Core specification, that explains why the SQL listed below works with 8i. Ade -Original Message-From: Vergara, Michael (TEM)

RE: Oracle 9i installation - Basic Qs

://www.orafaq.com -- Author: Adrian Roe 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

RE: RMAN and TSM

. == -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Adrian Roe INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: rman question(allocating channels)

Joe, We only write out to tapes, so one channel equals one tape drive, each extra channel goes and gets another drive. Not too sure about disks, I guess it depends on I/O bandwith. Two channels will be faster than one, if the disk can cope with the input from two channels then maybe it

RE: Catalog target db on different version O/S

: Adrian Roe 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

RE: Catalog target db on different version O/S

. If you received this in error, please contact the sender immediately and delete the material from any computer. == -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Adrian Roe INET: [EMAIL

RE: Total Memory Usage in AIX System

contact the sender immediately and delete the material from any computer. == -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Adrian Roe INET: [EMAIL PROTECTED] Fat City Network Services

RE: Oracle - 32bit/64bit??

. == -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Adrian Roe INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: Weird Windoze 'AT' Behavior

FAQ: http://www.orafaq.com -- Author: Adrian Roe INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE

RE: High %wio on AIX O.S. DB Server after Oracle 8i Migration

any computer. == -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Adrian Roe INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

RE: Re:MTS performance is too bad.

-- Author: Adrian Roe 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

RE: Re:MTS performance is too bad.

is prohibited. If you received this in error, please contact the sender immediately and delete the material from any computer. == -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Adrian Roe

RE: export tables from sql Server to Oracle

this in error, please contact the sender immediately and delete the material from any computer. == -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Adrian Roe INET: [EMAIL PROTECTED] Fat City

RE: RMAN with Tivoli Data Protection for Oracle

Yep, we use it. You need to install TDP on every target server and then relink Oracle to use Tivoli's libobk.so (or libobk.a). This applies to version 2.1, version 2.2 does not require the relink stage. Ade -Original Message-From: Yahoo [mailto:[EMAIL PROTECTED]]Sent: 09 April

RE: Deleting files on w2k

Title: RE: Deleting files on w2k Unlike UNIX, NT will not let you delete a file while another process (ie. Oracle)has got a hold on it. I assume Win2K is the same. -Original Message-From: Koivu, Lisa [mailto:[EMAIL PROTECTED]]Sent: 03 December 2001 14:20To: Multiple recipients of

RE: Oracle to Sql Server

Your best bet is to look at SQL Servers Data Transformation Services. So long as you have Net8 plus an Oracle OLEDB provider installed on the SQL2000 box you should be able to pull all of the Oracle tables across. Ade -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL

RE: Converting Inner join in MS-SQL to Oracle SQL syntax

computer. == -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Adrian Roe INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

RE: moving tables to a different tablespace

this in error, please contact the sender immediately and delete the material from any computer. == -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Adrian Roe INET: [EMAIL PROTECTED] Fat City

RE: Extent allocation

PROTECTED]] Sent: Friday, July 20, 2001 4:57 PM To: Multiple recipients of list ORACLE-L Subject: Re: Extent allocation On Fri, 20 Jul 2001, Adrian Roe wrote: Is there any way to get Oracle (816) to do round robin extent allocation eg. if a tablespace has 4 data files

Extent allocation

contact the sender immediately and delete the material from any computer. == -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Adrian Roe INET: [EMAIL PROTECTED] Fat City Network Services

sort_area_size + temp tablespace extent sizing

://www.orafaq.com -- Author: Adrian Roe 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

RE: SQL Server basic sources of info?

ontact the sender immediately and delete the material from any computer == -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Adrian Roe INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538

RE: Solaris ODBC drivers

://www.orafaq.com -- Author: Adrian Roe 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