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
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
Title: Location of trace files and alert log
SQL>show parameter background_dump_dest
SQL>show 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:
Locat
.
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
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
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, January 15, 2003 10:04 AM
> 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
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 Wil
?
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
? 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
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
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
ECTED] (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
can have facts, but having an opinion 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 In
ed 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 Wil
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
ng...
Thanks.
Ross
> -----Original 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
essage 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:
ACLE-L
>
>
> 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
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
taining: 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]
ssage
> 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 list you want to be removed from). You may
> also send the HELP command for other information (like subscribing
gt; also send the HELP command for other information (like subscribing).
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: DENNIS WILLIAMS
> > INET: [EMAIL PROTECTED]
> >
> > Fat City Network Services-- (858) 53
> 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 an E-Mail message
> to:
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
Jared 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
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
he list of events
to include 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, Califor
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
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 an E-Mail message
> to: [EMAI
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
> 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 Willia
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
#x27;. Has 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
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
istGuru') 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
--
A
)
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
uotes in the output. I cant do 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
exes 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
>
&g
Second, what do you mean by "The design of the application prohibits
> me from
> adding indexes to these tables. "? I've not seen any application that
> 'prohibits' adding indexes.
>
> Dick Goulet
>
> Reply Separator
hanks.
--
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 acce
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 off
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
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-- Public Interne
d 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 list you want to be removed from). You may
> also send the HELP command for other information (like sub
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
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 list you want to be removed from). You may
> also
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
its 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 Servi
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
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
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
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
complete list of system privileges?
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
? 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
54 matches
Mail list logo