RE: Another Oracle DBA gets The Bullet in the UK - Seeking an Oracle

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: Guy Hammond

RE: pass a value from a shell script to a store procedure

-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: Guy Hammond INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051

reattaching datafiles

it, as the reuse clause does? Thanks, g -- Guy Hammond AVT Technologies Classic House 174-180 Old Street London EC1V 9BP Desk: 020 7454 4174 Mobile: 07966 164687 Web: http://www.avt.co.uk/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Guy Hammond INET: [EMAIL PROTECTED

RE: reattaching datafiles

be orphaned like this... Hmmm. Cheers, g -Original Message- Sent: 02 November 2001 14:05 To: Guy Hammond; Multiple recipients of list ORACLE-L Guy, The 'drop tablespace' command does a number of items. It purges the data dictionary of all references to that tablespace, removes the file

RE: bizarre AQ problem

could cause this (there are triggers on this table for INSERT, UPDATE and DELETE, each of which does submit a message to an AQ). Thanks, g -- Guy Hammond AVT Technologies 1 Martha's Buildings 180 Old Street London EC1V 9BP Telephone: 020 7454 4174 Mobile: 07966 164687 Web: http://www.avt.co.uk

bizarre AQ problem

on this table for INSERT, UPDATE and DELETE, each of which does submit a message to an AQ). Thanks, g -- Guy Hammond AVT Technologies 1 Martha's Buildings 180 Old Street London EC1V 9BP Telephone: 020 7454 4174 Mobile: 07966 164687 Web: http://www.avt.co.uk/ -- Please see the official ORACLE

RE: Uncle Larry in the news

') 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: Guy Hammond INET: [EMAIL

RE: Droping System User

Title: RE: Droping System User You know, I would have thought that if Oracle was going to give you messages in French, that you would be able to write SQL in French too, like SLdI effacement de sys.user$ où name='SYS'; SLdI commettez; (SQL is "Structuré Langage d'interrogation" in

RE: book?

awesome) O'Reilly Oracle Internals (More focused and advanced, but great) Oracle SQL High performance Tuning (Make sure you get the Guy Hammond version, excellent SQL Book) Oracle Press Oracle Performance Tuning (tusc) (Again, great book, more up to date, and detailed) Unix and Oracle 8i Performance

RE: find out ip

, 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: Guy Hammond INET: [EMAIL PROTECTED] Fat

RE: Backup Strategy

: 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: Guy Hammond INET: [EMAIL PROTECTED] Fat City Network Services

RE: Any experiences with JDBC?

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

RE: JDBC on Unix box

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

RE: Oravle vs. Informix

, 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: Guy Hammond INET: [EMAIL PROTECTED] Fat

RE: Oracle - SQL Server

? * does the data always need to be fresh? * how fresh? * how big is it? Since it's temporary, this may work for you. Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Guy Hammond INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858

RE: Background jobs inUnix

') 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: Guy Hammond INET: [EMAIL PROTECTED

RE: Insert from text file

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

RE: Background jobs inUnix

-L can you actually do dbv on a zipped file??? --- Guy Hammond [EMAIL PROTECTED] wrote: Is there a way to make pipes work with dbv? I get error 100, file not accessible when I do $ mknod /tmp/pipe p $ dbv file=/tmp/pipe blocksize=8192 When I'm doing $ bzcat system01.dbf.bz2 /tmp/pipe

RE: How much data can SQL*Server hold?

Title: How much data can SQL*Server hold? Hi Lisa, About the biggest MSSQL implementation I am aware of is this: http://terraserver.homeadvisor.msn.com/terra_tech.asp 1.5 terabytes on SQL Server 2000, Windows 2000 Datacenter and Compaq ProLiant. There's even a picture of what it looks

RE: Hot Backup Issue

and cons of each approach? (I'll probably use RMAN at some point, anyway :0) ). Cheers, g -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Guy Hammond INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

RE: Hot Backup Issue

at a time is having full blocks of changed data writing to the redo logs. The overall level of redo will be the same but contention (ah ha - better word) will be reduced John -Original Message- From: Guy Hammond [mailto:[EMAIL PROTECTED]] Sent: 02 October 01 12:15

control file contents

the database from the time of the previous backup to the time that the control file was written? Because, looking in my archive log destination, these are a lot older than the last hot backup. Cheers, g -- Guy Hammond AVT Technologies 12-16 Westland Place London N1 7LP UK Email: [EMAIL

RE: RE: ORACLE VS. SYBASE

it was obviously superior and anyone who bought Sybase was an idiot. They bought Sybase. Jay Miller -Original Message- Sent: Tuesday, September 25, 2001 9:40 AM To: Multiple recipients of list ORACLE-L -- Guy Hammond [EMAIL PROTECTED] That's about all I can be bothered to type for now

RE: ORACLE VS. SYBASE

on a comparison between the latest Sybase and an older Oracle -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Guy Hammond INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access

RE: SQLNet.ora file

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

RE: Physical access to servers for maintenance

') 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: Guy Hammond INET

RE: Does start with/connect by uses full table scan?

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: Guy Hammond INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego

RE: ORACLE VS. SYBASE

://www.orafaq.com -- Author: Guy Hammond 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: 2nd DBA or ?

of getting another permanent DBA , and i'd insist on interviewing the candidates, so i can get someone to share my knowledge with and learn from. DBAndrey * 03-9254520 * 053-464562 * mailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Guy Hammond

RE: How to move a databse from Solaris to Llinux

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

RE: Question on Gaja's Raid Document

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: Guy Hammond INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

RE: how to zip email?

). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Guy Hammond INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public

RE: Internal troublemaker

send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Guy Hammond INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access

RE: The DBA in the IS organization

the problems that they did mess up. Regards, Satar Please remember that TRUE muslims do not advocate violence. Please do not displace your anger on innocent muslims living in your local area. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Guy Hammond INET: [EMAIL PROTECTED] Fat

RE: Visio for ERD's ?

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

RE: Is Virus protection software safe on an NT / Oracle server?

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: Guy Hammond INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538

RE: Is Virus protection software safe on an NT / Oracle server?

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

RE: How do you audit a DBA?

the others? how else could you set up a role or continue to set them up? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Guy Hammond INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public

RE: How do you audit a DBA?

-- Author: Guy Hammond 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

RE: Interesting News..

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

RE: Duhvelopers and DB-ehs?

- Weirs Building) Tel: 0141 568 2377 Fax: 0141 568 2366 http://www.calanais.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Guy Hammond INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public

RE: awk, sed, windoze, sql*loader, other fun stuff

Title: awk, sed, windoze, sql*loader, other fun stuff Just use Perl... it's got all the functionality and most of the syntax of awk, sed and ksh, not to mention bits of C. And it even has a nice interface to Oracle. Once you start with it you'll be like, damn, how did I manage without this?

RE: OT : kernel using 75% of CPU

4.9 0.0 0.0 8.4 0 2 sd1120 7.2 0.4 292.4 3.2 0.0 0.0 6.8 0 3 sd1121 2.8 0.3 102.3 2.4 0.0 0.0 7.7 0 2 nfs1 0.0 0.0 0.0 0.0 0.0 0.0 18.0 0 0 - Original Message - From: Guy Hammond To: Multiple recipients of list ORACLE-L Sen

RE: Burning game CD's

-- Author: Guy Hammond 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

RE: DBMS_JOB Help

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

RE: financial problems with fatcity.com

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: Guy Hammond INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego

RE: OT RE: RE: How do you audit a DBA?

Title: RE: OT RE: RE: How do you audit a DBA? I went to see that movie, The Mummy Returns, when it came out, 'cos The Rock was in it, and I was hoping for some long, rambling monologues from the Scorpion King about how he planned to lay the smackdown on the Egyptians' candy asses, shut your

RE: Magazines for Oracle unix performance

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

RE: one file being relinked in wrong ORACLE_HOME

: 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: Guy Hammond INET: [EMAIL PROTECTED] Fat City Network Services-- (858

RE: How do you audit a DBA?

://www.orafaq.com -- Author: Guy Hammond 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: CPU - load !

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: Guy Hammond INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego

RE: data modeling processes

, 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: Guy Hammond INET: [EMAIL PROTECTED] Fat City

RE: w2k db connections... shudder

How many angels can dance on the head of a pin? And what is the sound of one hand clapping? -Original Message-From: Koivu, Lisa [mailto:[EMAIL PROTECTED]]Sent: Tuesday, August 21, 2001 10:53 PMTo: Multiple recipients of list ORACLE-LSubject: w2k db connections... shudder

RE: Significance of TWO_TASK

? when and where it is used etc ? Thanks in advance Uma -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Guy Hammond INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing

RE: DBA tasks

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: Guy Hammond INET: [EMAIL PROTECTED] Fat City

foreign key constraints

a.r_constraint_name = b.constraint_name and a.constraint_type='R'; I will get back a result set containing a.table_name = t2 b.table_name = t1 b.column_name = col1 But what query would I run to find col2? Thanks, g -- Guy Hammond AVT Technologies 12-16 Westland Place London N1 7LP UK Email: [EMAIL

RE: foreign key constraints

='R'; :0) g -Original Message- From: Guy Hammond Sent: Tuesday, August 21, 2001 2:44 PM To: '[EMAIL PROTECTED]' Subject: foreign key constraints Let's say I had two tables: CREATE TABLE t1 ( col1 NUMBER PRIMARY KEY); CREATE TABLE t2 ( col2

RE: w2k scripting

Title: w2k scripting Perl on Windows is great, when you consider things like manipulating the user database or system log, it's probably more useful on Windows than it is even on Unix. And DBI works the same on both platforms. There is a thing called "Windows Scripting Host" which is

RE: DBA tasks

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: Guy Hammond INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

table create vs alter

)); ALTER TABLE mytable ADD (mycol3 VARCHAR2(30)); Since no data is loaded, will Oracle have create the table in exactly the same way at the end of both two methods? Thanks, g -- Guy Hammond AVT Technologies 12-16 Westland Place London N1 7LP UK Email: [EMAIL PROTECTED] Office: +44 (0) 207 454

RE: Splitting a database: pro and cons

Title: RE: Splitting a database: pro and cons I would be tempted to leave them in the same instance, but use resource consumer groups to control them. Also, I would have their schemas (and associated objects) in different tablespaces, just to make management easier too, for things like

RE: Comment on 'Practical Oracle 8i'

with a high-stress application, and then run a test which kept the total available MHz constant but changed the number of chips. But even then you'd have to be very careful about what it was you were actually measuring. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Guy Hammond

RE: table create vs alter

(mycol2 VARCHAR2(40)); ALTER TABLE mytable ADD (mycol3 VARCHAR2(30)); Since no data is loaded, will Oracle have create the table in exactly the same way at the end of both two methods? Thanks, g -- Guy Hammond AVT Technologies 12-16 Westland Place London N1 7LP UK Email: [EMAIL PROTECTED] Office

RE: An SQL question , not easy ;-)

an on-going problem. I've got managers who want to see graphs of their system's usage. Using this mechanism applied against the DBA_AUDIT_TRAIL view works perfectly. Thanks! Mike -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Guy Hammond INET: [EMAIL PROTECTED] Fat City

RE: is C compiler a must for oracle UNIX installations ?

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

RE: Q about Oracle Optimizer

may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Guy Hammond INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet

RE: VB vs. JAVA

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: Guy Hammond INET: [EMAIL PROTECTED] Fat City Network

RE: OT: cryptography speech

FAQ: http://www.orafaq.com -- Author: Guy Hammond 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: OT Slam for the day: Re: Oracle DBA Needed in Greensboro,

But there's an opportunity to become a key member of the team! Surely you wouldn't pass that up? *snicker* g -Original Message-From: JOE TESTA [mailto:[EMAIL PROTECTED]]Sent: Thursday, August 16, 2001 4:23 PMTo: Multiple recipients of list ORACLE-LSubject: OT Slam for

RE: I admit this is dumb. NT/W2K Services?

Title: I admit this is dumb. NT/W2K Services? Hi Lisa, Yes, I agree it can be confusing. The service is a background process that provides an environment for Oracle to execute in - I don't know about the specifics in this case, but Oracle on Unix is comprised of two logical parts, the VOS

RE: An SQL question , not easy ;-)

://www.orafaq.com -- Author: Guy Hammond 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

table lock problem?

until it happened again. How would I go about diagnosing something like this? A couple of the columns were from sequences, and I verified that these were OK. The others were just text inserted into VARCHAR2s. Thanks, g -- Guy Hammond AVT Technologies 12-16 Westland Place London N1 7LP UK Email

RE: O/S copies of datafiles

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

RE: OT -- suggestions to ensure nerdiness in potential IT staff

You trying to seduce me, Mrs Robinson? ;0) -Original Message- Sent: Friday, August 03, 2001 8:01 PM To: Multiple recipients of list ORACLE-L baby! :) From: Guy Hammond [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject

RE: off topic--oracle Vs ms sql

') 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: Guy Hammond INET

RE: Largest Oracle Databases

') 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: Guy Hammond INET: [EMAIL

RE: any way to stop rollback for dml?/8.1.7.1/Solaris 8

, but the rollback to undo the transaction is another set of overhead that if I could eliminate would speed things up... But thank you for the helpful spirit in which the message was sent... :) happy weekend... Steve -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Guy Hammond INET

RE: Solaris Release Vs. Version

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

RE: ORACLE8i cc compiler on SOLARIS

encoded content removed -- binaries not allowed by ListGuru The previous attachment was filtered out by the ListGuru mailing software at fatcity.com because binary attachments are not appropriate for mailing lists. If you want a copy of the attachment which was removed, contact the sender

RE: ER Diagram of a schema

; charset=us-ascii Hi guys, What queries to run on a schema to get info that would enable me to draw an ER Diagram of that schema ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Guy Hammond INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX

RE: constraint naming

system-generated names for foreign key constraints to something sensible without invoking Deep Magic? g -- Guy Hammond AVT Technologies 12-16 Westland Place London N1 7LP UK Email: [EMAIL PROTECTED] Office: +44 (0) 207 454 1224 Mobile: +44 (0) 7966 164687 -- Please see the official ORACLE-L FAQ

RE: retrieving BLOB column..

I don't remember in ODBC/OLEDB, but in JDBC there's quite a nice streams interface to CLOBs. You open the CLOB, then just read it as any other stream, for example as if it were a disk file, using the CLOB as a handle rather than a file descriptor. g -Original Message-From:

RE: Metablink .... down again?

://www.orafaq.com -- Author: Guy Hammond 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: books on data modelling

not finding anything related in online Oracle documentation. Please suggest me.. Thanks in Advance, Suren -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Guy Hammond INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego

constraint naming

O Wise and Powerful Oracle: Is there a way to change thy system-generated names for foreign key constraints to something sensible without invoking Deep Magic? g -- Guy Hammond AVT Technologies 12-16 Westland Place London N1 7LP UK Email: [EMAIL PROTECTED] Office: +44 (0) 207 454 1224 Mobile

RE: How to download website

://www.orafaq.com -- Author: Guy Hammond 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: Solaris 8 Question

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

RE: Another programming standard falls

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

RE: RE: I have a clarification

contention that way, but that kinda defeats the point of spending money on the array... Cheers, g -Original Message- Sent: Wednesday, July 11, 2001 6:02 PM To: Guy Hammond; Multiple recipients of list ORACLE-L Guy, If I understand the Network Appliance sales droids correctly WAFL

RE: x$table

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: Guy Hammond INET: [EMAIL PROTECTED] Fat City Network

RE:

: http://www.orafaq.com -- Author: Guy Hammond 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

RE: UNIX

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

RE: Unix tee command

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

RE: I have a clarification

on this? Waiting for your next book, Steve Orr -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Guy Hammond INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: Exceeding Open Cursors.. too many rows in v$open_cursors

-- Author: Guy Hammond 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

RE: UNIX SA

Title: OT: UNIX SA The Solaris FAQ: http://www.science.uva.nl/pub/solaris/solaris2.html Sun's own documentation, all available online for free (in PDF too): http://docs.sun.com/ The "Ferrari book" is excellent, even tho' that's actually a Porsche on the cover:

RE: gzip does not want to work with files 2G

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

RE: Sizing a new server

Title: RE: Sizing a new server Hi Lisa, That doesn't sound too bad, the 8400 is a solid piece of kit. 64-bit, up to 14 CPUs and 28G of memory. They have seriously good I/O bandwidth. Needs a three-phase power supply and weighs, literally, half a tonne. And best of all, you can run VMS on

RE: Keeping up w/list Email

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

RE: Sizing a new server

Title: Sizing a new server Hi Lisa, Pick your favorite vendor and ask 'em if they've got anything like this: http://www.compaq.com/solutions/enterprise/database-oracle-sizer-download.html If it's going to be a big purchase, most vendors will send someone over to take a look too. I

  1   2   >