RE: Re: Oracle vs Mysql

2004-01-20 Thread Grant Allen
: http://www.orafaq.net -- Author: Grant Allen 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

RE: MS Access

2004-01-19 Thread Grant Allen
: http://www.orafaq.net -- Author: Grant Allen 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

RE: Oracle vs Mysql

2004-01-14 Thread Grant Allen
for commercial use. Ciao Fuzzy :-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: oaktable people

2004-01-08 Thread Grant Allen
://www.orafaq.net -- Author: Grant Allen 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: oaktable people

2004-01-07 Thread Grant Allen
:-) -- The contents of this post are my opinions only If swallowed seek medical advice -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego

RE: oaktable people

2004-01-07 Thread Grant Allen
: http://www.orafaq.net -- Author: Grant Allen 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

RE: oracle client on PC's

2004-01-06 Thread Grant Allen
:-) -- The contents of this post are my opinions only If swallowed seek medical advice -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051

ANSI join syntax and Oracle 8i

2003-12-21 Thread Grant Allen
the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: ANSI join syntax and Oracle 8i

2003-12-21 Thread Grant Allen
-Original Message- From: Jonathan Gennick [mailto:[EMAIL PROTECTED] Sent: Monday, 22 December 2003 11:59 To: Multiple recipients of list ORACLE-L Subject: Re: ANSI join syntax and Oracle 8i Sunday, December 21, 2003, 7:14:27 PM, Grant Allen ([EMAIL PROTECTED]) wrote: GA Does

RE: Career Advice

2003-12-17 Thread Grant Allen
://www.oreilly.com/catalog/oracleperl A copy of which has just landed on my desk. Much kudos to yourself and Andy. Ciao Fuzzy :-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

RE: http://www.wintercorp.com/vldb/2003_TopTen_Survey/TopTenWinners.a sp

2003-12-11 Thread Grant Allen
-- Author: Grant Allen 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

RE: rebuilding indexes - sure to cause a ruckus

2003-12-10 Thread Grant Allen
see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: Oracle Client (9.2.0.4)

2003-12-09 Thread Grant Allen
to me how this installations should be done. We have a Windows Plattform, both on the server and the client. Hope that helps, Anders. Ciao Fuzzy :-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services

RE: partitioning option licensing

2003-12-03 Thread Grant Allen
://www.orafaq.net -- Author: Grant Allen 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

Experiences with Oracle and MS .Net data providers

2003-11-24 Thread Grant Allen
be much appreciated. Ciao Fuzzy :-) -- The contents of this post are my opinions only If swallowed seek medical advice -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City

RE: Local connect to database (default connection)

2003-11-19 Thread Grant Allen
the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Oracle shared object files on Solaris, and ELF class.

2003-11-18 Thread Grant Allen
: http://www.orafaq.net -- Author: Grant Allen 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

RE: OT (DB2)

2003-11-11 Thread Grant Allen
:-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: [OOT] digest

2003-10-30 Thread Grant Allen
the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: MSSQL Link Server connection failure to Oracle 817

2003-10-28 Thread Grant Allen
persists. Ciao Fuzzy :-) -- The contents of this post are my opinions only If swallowed seek medical advice -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services

RE: dba interview questions

2003-10-28 Thread Grant Allen
we're all individuals. Ciao Fuzzy :-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: anyone have opinions on the future of the 'grid'?

2003-10-28 Thread Grant Allen
Title: RE: anyone have opinions on the future of the 'grid'? Oracle confirmed at the road show event I went to yesterday that "pricing will not change". Let's see how many people are happy to buy 100's of EE CPU licences :-) And my favourite bit? The new OEM is all singing, all dancing ...

RE: starting/stopping DB2

2003-10-28 Thread Grant Allen
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: Oracle pricing ain't going down

2003-10-26 Thread Grant Allen
://www.orafaq.net -- Author: Grant Allen 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: Oracle pricing ain't going down

2003-10-26 Thread Grant Allen
[ .. snip snip ..] Sorry, correcting my own transposition (a page in SS2000 is eight 8kB extents) That should have read an extent is eight 8kB pages in SS2000. I'll go back to my cave, now. Ciao Fuzzy :-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant

RE: Oracle pricing ain't going down

2003-10-23 Thread Grant Allen
-- Author: Grant Allen 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

RE: Boolean dates...

2003-10-22 Thread Grant Allen
wall. Ciao Fuzzy :-) -- The contents of this post are my opinions only If swallowed seek medical advice -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services

RE: Mauve databases use least RAM

2003-10-22 Thread Grant Allen
Oracle as I did, is entirely a matter for the reader :-) ). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web

RE: How To Pull Second Row from 100 ROWS

2003-10-21 Thread Grant Allen
: Grant Allen 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

RE: SQL Operation and Row size

2003-10-15 Thread Grant Allen
for just the computed/literal values; temp segments for the whole result set; somewhere in UGA/PGA; or somewhere else entirely? Any light shed on this would satisfy my curiosity. Ciao Fuzzy :-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant Allen INET

RE: 8.1.7 Support Extension?

2003-10-15 Thread Grant Allen
Strategic Platform :-) Microsoft Windows 98 Ciao Fuzzy :-) -- The contents of this post are my opinions only If swallowed seek medical advice -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant Allen INET

Perl DBI and Activestate 5.8.0

2003-10-13 Thread Grant Allen
:-) -- The contents of this post are my opinions only If swallowed seek medical advice -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

RE: Physical I/O and databases other than oracle

2003-10-02 Thread Grant Allen
(It's good to be back) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: Oracle to MSSQL conversion?

2003-08-04 Thread Grant Allen
Oracle logins. Ciao Fuzzy :-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: Oracle to MSSQL conversion?

2003-08-04 Thread Grant Allen
runs an instance per database where MSSQL is one instance running multiple databases. Is this right thinking? Yep, spot on. Ciao Fuzzy :-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538

RE: Oracle to MSSQL conversion?

2003-07-31 Thread Grant Allen
rubbish. A schema is a schema in both. Ciao Fuzzy :-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting

RE: Oracle to MSSQL conversion?

2003-07-31 Thread Grant Allen
(and DB2, Informix, Sybase and others which all have this). I'll stop there ... enough people on the list have heard my rant about this before :-) Ciao Fuzzy :-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services

RE: Emacs on SQLPlus, er uh... SQLPlus on emacs.

2003-07-30 Thread Grant Allen
FAQ: http://www.orafaq.net -- Author: Grant Allen 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

RE: Any German here ? Character set

2003-07-30 Thread Grant Allen
Title: Any German here ? Character set I'd recommend WE8ISO8859P15 (I think that's it) ... the difference is Euro support! Ciao Fuzzy :-) -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Goulet, DickSent: Wednesday, July 30, 2003 15:29To:

RE: Emacs on SQLPlus, er uh... SQLPlus on emacs.

2003-07-29 Thread Grant Allen
(even better than ultraedit in my opinion) Ciao Fuzzy :-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web

RE: Number of processors and standard edition

2003-07-29 Thread Grant Allen
: 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: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services

RE: ODBC Patch 8.1.5.7 where to download

2003-07-21 Thread Grant Allen
Title: ODBC Patch 8.1.5.7 where to download technet.oracle.com. Follow the download links. Ciao Fuzzy :-) -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of [EMAIL PROTECTED]Sent: Friday, July 18, 2003 15:49To: Multiple recipients of list

RE: SHOW ERRORS not working

2003-07-21 Thread Grant Allen
://www.orafaq.net -- Author: Grant Allen 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

RE: RE: SHOW ERRORS not working

2003-07-21 Thread Grant Allen
? Ive noticed this before. SHOW ERRORS is a function. Do you know where its created? you can find the code and then just craete the show errors function? might be in sql.bsq From: Grant Allen [EMAIL PROTECTED] Date: 2003/07/21 Mon PM 12:24:24 EDT To: Multiple recipients of list ORACLE-L

RE: Estimating User Load on the system

2003-07-14 Thread Grant Allen
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: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San

RE: LISTENER ON LINUX

2003-07-11 Thread Grant Allen
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: Grant Allen INET: [EMAIL PROTECTED] Fat City

RE: ER Tools (was: erwin)

2003-07-08 Thread Grant Allen
://www.orafaq.net -- Author: Grant Allen 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: Sybase to Oracle

2003-07-08 Thread Grant Allen
Yep, it's certainly possible. And from both ends. You can use the Oracle Transparent Gateway product, or the equivalent Sybase gadget (its name escapes me at the moment). Really depends from which end you wish to do the driving. Ciao Fuzzy :-) -Original Message-From: [EMAIL

RE: WHY IT DOES NOT WORK == rman target / as sysdba THANKS

2003-06-27 Thread Grant Allen
send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web

RE: ADO and bind variables (was RE: Performance improvement required :-))

2003-06-26 Thread Grant Allen
--I would bet that it does... Cheers, -Roy Roy, I tried with the Oracle provider (OraOLEDB.Oracle.1), and the bind variables work. Another reason to stick with the Oracle provider :-) Ciao Fuzzy :-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant Allen

RE: DBLink to SQL Server problem

2003-04-03 Thread Grant Allen
the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: Oracle encouraging Linux software developers

2003-03-28 Thread Grant Allen
to speak :-) Ciao Fuzzy :-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: Oracle connection through Crystal Reports

2003-03-28 Thread Grant Allen
) is probably not on the path. Add it, and it should work. Ciao Fuzzy :-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list

Using the /*+ append */ insert hint

2003-03-17 Thread Grant Allen
with this hint? Specifically, does anyone know what would happen on Oracle 7.3.x or 8.0.x if I used this (assuming it's supported ... would it silently ignore the hint if not supported?) Thanks Fuzzy :-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant Allen INET

RE: Using the /*+ append */ insert hint

2003-03-17 Thread Grant Allen
Connor (and Darrell in the previous post). Connor, I saw a post that suggested you might be heading back to Oz - is that true? Ciao Fuzzy :-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538

RE: Using the /*+ append */ insert hint

2003-03-17 Thread Grant Allen
time. That's pretty much what we're targeting. Bulk inserts using insert ... select ... , possibly in the millions of rows. That kind of speed increase would be good. Ciao Fuzzy :-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant Allen INET: [EMAIL PROTECTED

RE: Quick question on cursor resource use

2003-03-12 Thread Grant Allen
is not allocated by setting the parameter, but it will be allocated when you actually start opening and using cursors. (I have also seen people increasing it only because the application was buggy and didn't close cursors after use. This is not a good idea) /Bjørn. Grant Allen wrote

RE: Quick question on cursor resource use

2003-03-11 Thread Grant Allen
not complaining about getting the error. I just want some ideas about the resource hit if I up this to 500, 1000, 50? The Oracle architecture stuff was silent on the subject. Ciao Fuzzy :-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant Allen INET: [EMAIL PROTECTED

RE: POLL: Database to DBA ratio

2003-03-11 Thread Grant Allen
. It fluctates pretty wildly for us depending on the RD effort at any one point in time. But it's not unusual for us to have 50:3, though the 50 are of mixed types (Oracle, DB2, SQLServer etc.) Ciao Fuzzy :-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant Allen INET

Quick question on cursor resource use

2003-03-10 Thread Grant Allen
space in the PGA. Anyone know how much, or if there's a basic overhead + variable component based on SQL statement used? Thanks Fuzzy :-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538

RE: Purely for your amusement

2003-02-28 Thread Grant Allen
to respond with Data! You don't need no stinkin' data! Ciao Fuzzy :-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list

RE: DBV

2003-02-27 Thread Grant Allen
://www.orafaq.net -- Author: Grant Allen 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

RE: Performance issue

2003-02-26 Thread Grant Allen
, I'd recommend the same :-) ) Ciao Fuzzy :-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: GRRRRR OWS

2003-02-25 Thread Grant Allen
://www.orafaq.net -- Author: Grant Allen 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

RE: Which is beter a cursor or a for loop?

2003-02-24 Thread Grant Allen
on the complexity of the 'do lots of database stuff', you might need to resort to cursors or loops. But these shouldn't be the first option!) Just my 2¢ Ciao Fuzzy :-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City

RE: RMAN gui...in OEM 9.x i

2003-02-21 Thread Grant Allen
of the console is the status messages provided during backup and recovery ... better than watching spinning wheels or an hour-glass in a GUI! Ciao Fuzzy :-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services-- 858

RE: Programming languages that make DBA's lives easier

2003-02-21 Thread Grant Allen
: http://www.orafaq.net -- Author: Grant Allen 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

RMAN ready or not!

2003-02-19 Thread Grant Allen
dropped)? Just tinkering. Ciao Fuzzy :-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: Service startup on Windows 2000 fails

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

When were Locally Managed Tablespaces introduced?

2003-02-17 Thread Grant Allen
:-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: Oracle Migration Workbench for Sybase

2003-02-06 Thread Grant Allen
://www.orafaq.net -- Author: Grant Allen 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: books recommendations

2003-02-03 Thread Grant Allen
, I may be unfairly misquoting him, so I'll leave the authorative comments to him. Ciao Fuzzy :-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego

Base conversion

2003-01-28 Thread Grant Allen
://www.orafaq.net -- Author: Grant Allen 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: New Schema or New Database?

2003-01-23 Thread Grant Allen
refer to it as being like a database in informix of sybase :-) :-) :-) Ciao Fuzzy :-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

RE: doubt

2003-01-02 Thread Grant Allen
Excuse the heresy for answering an SS question on this list. Jai, you can fight with the INFORMATION_SCHEMA views, or use sp_help to see all the objects for allusers(not just tables). If you looking for just tables, and only for a given user, use select o.namefrom sysobjects o, sysusers

RE: Footprint of 9i

2002-12-19 Thread Grant Allen
\* to free up 100MB of the scripts used to create the sample schemas - again if you don't use them. There might be more that can be removed ... doco and the like ... but that's a start. Ciao Fuzzy :-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grant Allen INET

RE: Oracle on windows and shadow thread file access

2002-12-02 Thread Grant Allen
a user's dedicated server process - as opposed to smon, pmon, chpt, arch, lgwr, dbwr, etc. - actually acquired a file handle and opened the file. Thanks for the discussion on this. Ciao Fuzzy :-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Grant Allen INET: [EMAIL

Oracle on windows and shadow thread file access

2002-11-29 Thread Grant Allen
:-) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: Oracle on windows and shadow thread file access

2002-11-29 Thread Grant Allen
of processes running under windows too. So in the limit...you could hit a wall but only due to the per-process overhead. Cheers Jeff Herrick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538

RE: Open Source Security Comes Under Fire

2002-11-27 Thread Grant Allen
Title: BackupExec & Oracle You've got to love blinkered analyst reports - SQL Server alone has had nearlya dozen critical security issues this year (http://support.microsoft.com/default.aspx?scid=kb;en-us;Q316333id=Q316333). But I guess that doesn't count :-) Ciao Fuzzy (yes, I'm back -

Help on resolving block number and file number from 10046 trace to table or index

2002-10-15 Thread Grant Allen
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 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: Are ODBC connection handles shareable over multiple threads?

2002-10-08 Thread Grant Allen
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 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: Are ODBC connection handles shareable over multiple threads?

2002-10-07 Thread Grant Allen
, 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

RE: Falling off my seat ( 9i R2)

2002-10-03 Thread Grant Allen
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 http://www.fatcity.com San Diego, California

Falling off my seat ( 9i R2)

2002-10-02 Thread Grant Allen
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

RE: _spin_count Revealed

2002-09-17 Thread Grant Allen
ORACLE-L FAQ: http://www.orafaq.com -- Author: Grant Allen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: mixed case text

2002-09-12 Thread Grant Allen
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

RE: Who don't I see my posting ?

2002-09-02 Thread Grant Allen
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

RE: Can DB tell if connection from odbc?

2002-09-02 Thread Grant Allen
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

RE: Moving to UK - what are Oracle contracts like?

2002-08-18 Thread Grant Allen
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

OT: Moving to UK - what are Oracle contracts like?

2002-08-16 Thread Grant Allen
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

RE: db2

2002-07-24 Thread Grant Allen
, 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

RE: MUST read Oracle Architecture - Abrief Intro

2002-07-24 Thread Grant Allen
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

What do I call these Oracle/db things in Dutch?

2002-07-21 Thread Grant Allen
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

RE: the ora certified masters cert, yet again

2002-06-27 Thread Grant Allen
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

RE: the ora certified masters cert, yet again

2002-06-26 Thread Grant Allen
. 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

RE: comp.databases.oracle newsgroups

2002-06-20 Thread Grant Allen
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