RE: how to send mail from windows command prompt?

Check out a dos program called BLAT. I think that is what you are looking for. Erik -Original Message- From: Mercadante, Thomas F [mailto:[EMAIL PROTECTED] Sent: Friday, October 03, 2003 3:19 PM To: Multiple recipients of list ORACLE-L Subject: RE: how to send mail from

Virtual Circuit Status

the clients are set to use dedicated server. Should I try reduce this event by tuning MTS or is it truely an idle event? Thanks Erik Erik Williams (E-mail).vcf Description: Binary data

RE: Location of trace files and alert log

Title: Location of trace files and alert log SQLshow parameter background_dump_dest SQLshow parameter user_dump_dest -Original Message-From: Nguyen, David M [mailto:[EMAIL PROTECTED]Sent: Thursday, July 10, 2003 11:44 AMTo: Multiple recipients of list ORACLE-LSubject:

Installed Product Components

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

RE: SQLPlus Substitution Variables

in SQLPlus, but don't want to be prompted for their values. I want to set them at the start of the script. Kind of like a preprocessor directive. Is this possible? Erik -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Erik Williams INET: [EMAIL PROTECTED] Fat

Unix Max Extent Script

on the results. Has anyone written a shell script that will do this that they would like to share? There are many other SQL scripts that I would like to run from cron to evaluate SQL script results. Thanks Erik -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Erik

SQLPlus Substitution Variables

I am using substitution variables in SQLPlus, but don't want to be prompted for their values. I want to set them at the start of the script. Kind of like a preprocessor directive. Is this possible? Erik -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Erik Williams

Oracle Environment Documentation

for this? I had a good base document to work from at one time, but cant find it now that I need it. Thanks Erik -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Erik Williams INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego

Specify Rollback for an Export

segment without taking all the others (except System) offline? I have seen this question asked on the list before, but did not find a definitive follow-up answer. Thanks Erik -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Erik Williams INET: [EMAIL PROTECTED] Fat City

RE: Specify Rollback for an Export

FAQ: http://www.orafaq.com -- Author: Erik Williams 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: Specify Rollback for an Export

? I have seen this question asked on the list before, but did not find a definitive follow-up answer. Thanks Erik -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Erik Williams INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

RE: DBA work load

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

RE: Automatic generation of Statspack report ...

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

RE: Schedule Statspack Report Creation

to automate the creation of these reports? I am being asked to produce these reports by other people in my group who do not have access to the database. I am hoping that there is a way to automate this. Erik -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Erik Williams

Schedule Statspack Report Creation

group who do not have access to the database. I am hoping that there is a way to automate this. Erik -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Erik Williams INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego

RE: UNIX OT: Strange Unix behavior

Message- From: Erik Williams [mailto:[EMAIL PROTECTED]] Sent: Monday, 26 August 2002 22:53 To: Multiple recipients of list ORACLE-L Subject: RE: UNIX OT: Strange Unix behavior This directory might be under the control of the automount daemon. If you want locally managed home

RE: UNIX OT: Strange Unix behavior

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

Listener Log Aging Script

Could anyone share their Unix script to age the listener log file? I know that this has been posted to the group in the past, but I was unable to find it in the archives at FatCity. Thanks. Erik -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Erik Williams INET

RE: Listener Log Aging Script

the listener log file? I know that this has been posted to the group in the past, but I was unable to find it in the archives at FatCity. Thanks. Erik -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Erik Williams INET: [EMAIL PROTECTED] Fat City Network

RE: 9i RAC on NetApp

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

RE: OTN discount for OCP exams

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

RE: Oracle and NAS storage systems

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

RE: Oracle and NAS storage systems

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

Oracle8i Upgrade Exam Material

I am going to be taking the Oracle8i: New Features for Administrators (1Z0-020) exam and am looking for study materials. Can anyone recommend and books for this exam? Thanks Erik -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Erik Williams INET: [EMAIL PROTECTED

RE: Log file synch / direct path writes

Still [SMTP:[EMAIL PROTECTED]] Sent: Saturday, June 22, 2002 1:30 PM To: [EMAIL PROTECTED]; Erik Williams Subject: Re: Log file synch / direct path writes Just how large is your overly large log buffer? 10 meg? 100 meg? 1 Gig??? ( ok, I've never heard of one this big, but you

Log file synch / direct path writes

if it is the DBWR causing them? Multiple DBWR? The datafiles are not on QuickIO, just the redo. Thanks Erik -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Erik Williams INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego

Wait Event Calculation

for my version of the database (the doc is quite old)? Thanks Erik -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Erik Williams INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public

Solaris RC Script Output

Where can I find the output of the Solaris run control scripts? I am trying to debug a database startup problem and would like to view the output of the echo commands in these scripts. Thanks Erik -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Erik Williams INET

RE: Erwin - Does this thing work?

, 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: Erik Williams INET: [EMAIL PROTECTED

Partitoned Table Insert Performance

partitioned and the other not? Any input would be appreciated. Thanks. Erik -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Erik Williams INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public

RE: Oracle learning network v Oracle CBT-Select

') 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: Erik Williams INET

FTP Exports

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

NOHUP SQLPLUS

anyone used this or run into issues using it? Every time I assume something will 'just work', IT DOESNT! Thanks Erik -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Erik Williams INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051

Enable Constraint

here? Am I being too critical of the time it takes to do 20M index lookups? Am I mistaken about how a foreign key constraint is re-enabled? Any thoughts would be much appreciated. Thanks Erik -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Erik Williams INET

RE: using Net8 through NAT router

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

Partitioning Tables

) event_datetime (date) Table C - Session Quote session_quote (primary key) session_id (FK to session table) quote_datetime (date) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Erik Williams INET: [EMAIL PROTECTED] Fat City Network Services

Concatinate with a '''

this: select sysdate || ''' || sysdate from dual How do I concatinate a ' with the colum values? Thanks Erik -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Erik Williams INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051

Data Deletion in Tables with Foreign Keys

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

RE: Data Deletion in Tables with Foreign Keys

adding indexes to these tables. ? I've not seen any application that 'prohibits' adding indexes. Dick Goulet Reply Separator Author: Erik Williams [EMAIL PROTECTED] Date: 11/1/2001 5:45 AM I need to prune data from a set of tables every day

RE: Data Deletion in Tables with Foreign Keys

Goulet Reply Separator Author: Erik Williams [EMAIL PROTECTED] Date: 11/1/2001 5:45 AM I need to prune data from a set of tables every day. I need to retain the last 90 days of information. Two of the tables, A and B, have foreign keys to a third, C

RE: Code to Validate email addresses

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

v$sqlarea statistics

measures? Thanks. Erik -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Erik Williams 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

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

Migration v. Upgrade

I cannot find a definitive definition of these two terms on metalink. Can these terms be used interchangeably or is there a difference? Thanks Erik -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Erik Williams INET: [EMAIL PROTECTED] Fat City Network Services

RE: connecting to sqlplus within a shell script

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

Last Update

How can I tell when a table was last updated? I am able to tell when it is last anylized, but I am looking for the date of the last DML on the table. Thanks Erik -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Erik Williams INET: [EMAIL PROTECTED] Fat City Network

OT: Unix tee command

standard input into its standard output. I have been instructed to use the latter, but dont want to do it blindly without understanding why. Thanks Erik -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Erik Williams INET: [EMAIL PROTECTED] Fat City Network Services

OT: Pin a CPU in Solaris

Does anyone know how to pin a Solaris CPU at a high utilization? I am doing some testing and want to evaluate a system under a high CPU load. Thanks. Erik -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Erik Williams INET: [EMAIL PROTECTED] Fat City Network

Datafile Coruption

to it, but would like to hear any other suggestions others may have. Thanks Erik -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Erik Williams INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public

FTP Archive Logs

I need to ftp several archive logs from one server to another. Do I need to specify either ASCI or BINARY modes? What difference does this make when ftping files? Thanks. Erik -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Erik Williams INET: [EMAIL PROTECTED

RE: Backup Control File Privilege

Thanks for the response. I will certainly think about that one!!! -Original Message- From: Jared Still [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, June 05, 2001 2:33 PM To: [EMAIL PROTECTED]; Deshpande, Kirti; Erik Williams Subject: Re: Backup Control File Privilege Hmmm

ERD Diagramming Program

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