RE: Oracle 8i DB, 9i DB and 9iAS on same Unix box, refused

Don-   Look for port conflicts between the Apache installed with 9iAS and the one with 9.2.  If you're using web cache on iAS check the port that is using also. Are you using iAS Release 2 (9.0.2)?  If so, and both the infrastructure and mid-tier are on the same server, they will each have

RE: Oracle 9.2.0.1/2 on Mandrake 9 - solved

I've been told the same thing, but the reasoning was that they couldn't guarantee what was put out for download was actually the correct build. Not sure that's very reassuring, either. Jim -Original Message- Sent: Thursday, November 14, 2002 12:34 PM To: Multiple recipients of list ORA

RE: OT - interviewing your superior(fun question)

He also included something like "in the Congress" in his statement, so it was pretty clear he was speaking about providing political support as opposed to technological innovation.  If you read the transcript there's not much confusion.  But it does make for some good jokes.   Jim >>> [EMAIL

RE: exp performance question ( direct=y)

No, buffer is ignored for DIRECT=Y.  But RECORDLENGTH should be set to DB_BLOCK_SIZE, or a multiple of it.  I've had dramatic gains in performance doing this.   Also, pre-8i you couldn't do direct-mode export of LONG fields.  As of sometime in 8i you can (I know it works in 8.1.7).   Jim >>>

RE: Speed up massive delete

Well, that IS true (actually I think its NOLOGGING for index creation).  But if you have massive amounts of INSERTS or DELETES, dropping the index first and then re-creating can help.   If the number of deletes is truly large, and you've got spare disk space, and the table can be off-line fo

Re: Speed up massive delete

Not sure how this message looked to everybody on the list.  When I rec'd it, all I could see was the ALTER statements.  But I know that the create statements and direct loads work also.  When I went to reply as such, lo and behold the missing create/direct load statements appeared as they sh

Re: "ALTER SYNONYM"?

Can you use a view instead?   SVRMGR> create table temp1 (temp1 varchar2(1));Statement processed. SVRMGR> create table temp2 (temp1 varchar2(1));Statement processed. SVRMGR> insert into temp1 values ('a');1 row processed.SVRMGR> insert into temp1 values ('a');1 row processed.SVRMGR> insert

RE: Select only one of three tables

This could get ugly.  I'm thinking the decode/outer join method won't work because there's no table you can reliably use as a base for the outer join.  How about:   select emp_id, dept from dept_one union (select emp_id, dept from dept_two minus select emp_id, dept from dept_one) union (selec

RE: * Oracle DBA Needed in Phoenix..

Preferably with no close friends or relatives, nobody to notice if you just...disappear.   Jim>>> [EMAIL PROTECTED] 07/06/01 09:10AM orastaff wrote:>We would like to submit someone who is a renter and who is interested>in Phoenix but has not applied to Phoenix companies and is not workin

RE: Little Brother Larry not really ON topic

Y'know, Bambi is such a gentle name, but you're scaring me with this in-depth knowledge. :-)   JIm>>> [EMAIL PROTECTED] 10/19/01 03:59PM >>> Yes, well, I think that they thought that was a pretty snazzy way not to pay on life insurance.  In practice, though, if you've had your policy more th

RE: providing 24*7 database ---

Seemed fine when I tried it (and thanks for the idea!).  The trick with the indexes is that the ones on the partitioned table have to be local, which was in the scripts provided, and the 'exchange partition' had to say 'including indexes', which was not.  Adding 'including indexes' made this

Re: Java in the database

Jan-   I've heard some concerns about the scalability of Tomcat as an app server.  Of course, some of those concerns are voiced by guys like Oracle and BEA who have a nice little Java engine to sell you for $10-20K per CPU.  I know a lot of people use Tomcat for prototypes and such, then go

Re: Java in the database

Jan- Please do let us know how you do with 500 users. "Oracle App Server = Apache + Tomcat" Is this true?  I know that "Oracle HTTP Server" (ha ha) is basically Apache.  And I know that the Oracle Jserver was basically the Jserv precursor to Tomcat.  But I thought 8.1.7 and 9i came with a new

RE: Java in the database

ow.     "Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes." Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax:    (707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 0

RE: SAP and Oracle

Kimberly-   When we went to SAP about 5 years ago our SAP license came with limited use Oracle licenses.  This covered all the users of SAP, although in truth only the SAP superuser actually connected directly to Oracle.  The license did not allow creation of additional schemas in the Oracle

Re: Grumble, grumble

You darn skippy, Bambi.  We never got specific error messages, either.  Just got something like 'patch failed' with no reference to where or why.  The world's gone soft since the days when 'computer people' all wore white smocks and carried boxes of punch cards around.   Jim>>> [EMAIL PROTECT

RE: Long Problem??

nd for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jim Conboy INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego,

OT: Re: DBA Job at a Chocolate Factory

e EXACT 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: htt

Re: Oracle license costs

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

In Praise of Metalink

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

Re: How to use Export Transportable Tablespaces

e EXACT 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

RE: Oracle on Unix

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: Jim Conboy INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 S

Re: Am I too hard on the developper ?

ng Lists -------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing

Re:RE: MetaSlop

pelling 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.co

RE: RE: MetaSlop

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

RE: Oracle Licensing

t access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the

Re: (Fwd) Oracle's Savings Don't Add Up

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://

Deployment of Oracle Client

TOAD, or an ODBC connection, so that the download and install time would be within reason. Anybody have suggestions? How are people on this list deploying Oracle apps to many users? Thanks. Jim -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jim Conboy INET: [EMA

Re: Listener consolidation

: [EMAIL PROTECTED] (note EXACT 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 FA