RE: VB/Oracle question

2001-09-26 Thread Shaw, John B
') 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.com -- Author: Shaw, John B INET

Copy - why doesn't this work?

2001-09-11 Thread Shaw, John B
ERROR: ORA-04043: object test3 does not exist -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shaw, John B INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: Fail over with ODBC and standard edition

2001-09-05 Thread Shaw, John B
and Microsoft's ODBC driver is not. You will also have to setup TNSNAMES for TAF to work with your application. Now my big disclaimer is that I only setup the ODBC driver, I never tested it because I don't have any apps that use ODBC. Scott --- Shaw, John B [EMAIL PROTECTED] wrote: Do you need to have

Fail over with ODBC and standard edition

2001-09-04 Thread Shaw, John B
been able to find a magic combination to make it work. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shaw, John B INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access

RE: Oracle Licensing for a Clustered Server Configuration

2001-08-27 Thread Shaw, John B
Title: Oracle Licensing for a Clustered Server Configuration Only if it's active on the fail over node - if it's passive you don't need a second license. -Original Message-From: Srinagesh Battula [mailto:[EMAIL PROTECTED]]Sent: Monday, August 27, 2001 1:07 PMTo: Multiple

Help - Fail Safe ODBC not working

2001-08-21 Thread Shaw, John B
keep the connection alive during the failover - I get 3113 end-of-file error - both from access and a foxpro front end, I have to stop and restart the app's and then everything connects up fine. Any ideas? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shaw, John B INET

long to clob scripts?

2001-07-18 Thread Shaw, John B
Title: OFF-TOPIC : remsh from a WIN workstation to a UNIX We are finally getting around to replacing all our long data types with clobs and blobs - anybody already have a script that does this?

Probelm with W2K large datafile creation

2001-07-12 Thread Shaw, John B
worked fine, and I could create tablespace datafiles this size on P3 systems. Did a pentium 4 search on metalink and all I got was the patch stuff. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shaw, John B INET: [EMAIL PROTECTED] Fat City Network Services

RE: unable to allocate 4096 bytes of shared memory - HELP!!!!

2001-07-11 Thread Shaw, John B
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.com -- Author: Shaw, John B INET: [EMAIL PROTECTED] Fat City Network

RE: 81714 aborted upgrade and core dumps on NT

2001-07-10 Thread Shaw, John B
: Shaw, John B 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: Client Connection-SQLNET and?/or? ODBC.

2001-07-10 Thread Shaw, John B
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.com -- Author: Shaw, John B INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San

Pentium 4 (gotta love wintel) install (attempt)

2001-07-03 Thread Shaw, John B
? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shaw, John B INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: Pentium 4 (gotta love wintel) install (attempt)

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

Sql question

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

Another NT question

2001-06-26 Thread Shaw, John B
Anybody currently have more than 500 concurrent users on an NT box? Just trying to validate a compaq claim that they can handle a large system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shaw, John B INET: [EMAIL PROTECTED] Fat City Network Services-- (858

RE: Digestive

2001-06-12 Thread Shaw, John B
(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.com -- Author: Shaw, John B INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051

RE: URGENT ODBC HELP REQUIRED

2001-05-31 Thread Shaw, John B
Title: URGENT ODBC HELP REQUIRED be something like this (check for errors): open database data1LOCAL lcCursorName, lnreturnlcCursorName = "SQLRESULT"gcODBCDataSource = 'odbcname'gcSQLUserID = 'oracleuser'gcSQLPassword = 'oraclepass' gnConnHandle = SQLCONNECT(gcODBCDataSource,

RE: ODBC Connections Bad?

2001-05-10 Thread Shaw, John B
command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shaw, John B INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: Need oracle patch 8.1.7.1.1

2001-05-08 Thread Shaw, John B
it to .1.1 then .1.2. Cheers, Earl --- TheOracleDBA [EMAIL PROTECTED] On Fri, 04 May 2001 10:31:23 Shaw, John B wrote: I just downloaded patch 8.1.7.1.2 from metalink - in the readme (yes I actually read it before installing ) it states that the earliest version that this patch may

Need oracle patch 8.1.7.1.1

2001-05-04 Thread Shaw, John B
it? . .-.. .--. .. ...- . -... . . -. .--. .-. --- -... . -.. John B. Shaw Intergraph Public Safety mailstop LR24A4 [EMAIL PROTECTED] 256-730-8038 All the usual disclaimers and some of the certifications -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shaw, John B INET: [EMAIL PROTECTED

RE: Help - temp tablespace growing constantly

2001-04-30 Thread Shaw, John B
, then grows up to around 25G before I drop and recreate it. Called oracle support and they gave me a patch that hasn't helped. Anybody have some hints as to what to look for? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shaw, John B INET: [EMAIL PROTECTED] Fat City

RE: Help - temp tablespace growing constantly

2001-04-30 Thread Shaw, John B
and they gave me a patch that hasn't helped. Anybody have some hints as to what to look for? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shaw, John B INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

Can you create a database link back to same database?

2001-04-20 Thread Shaw, John B
I'm missing something in my syntax or this can't work - which is it? SQL create database link fr.is.inr.com@toad connect to test identified by test using 2 'fr.is.inr.com'; -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shaw, John B INET: [EMAIL PROTECTED] Fat City

RE: OFF-TOPIC: RE: OT -- A humorous reply to the Canada rulz

2001-03-20 Thread Shaw, John B
T 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.com -- Author:

Replication - 8.1.6 to 8.1.7

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

RE: Java pools and 8i -- necessary?

2001-03-15 Thread Shaw, John B
subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shaw, John B INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: oracle and America

2001-03-12 Thread Shaw, John B
for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shaw, John B INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: COPY command dieing - help

2001-02-06 Thread Shaw, John B
v55/v55@int to user/pwd@frog create DMF - using select * from DMF@int / Notice that if you have several lines, you need to put a space and hyphen after each line except the last one. At least, that has been my experience. [EMAIL PROTECTED] 02/02/01 11:00AM On Thu, 1 Feb 2001, Shaw, John B wrote

COPY command dieing - help

2001-02-01 Thread Shaw, John B
of what's going on? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shaw, John B INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists