st_ld.orig
> em_contact_hist_ld.ctl
In the script, this was followed by a call to sqlldr with the control
file em_contact_hist_ld.ctl.
Scott Canaan ([EMAIL PROTECTED])
(585) 475-7886
"Life is like a sewer, what you get out of it depends on what you put
into it." - Tom Lehrer.
-Ori
, century. This is
used for rollup reporting within the data mart. I don’t see any good use
of it in an OLTP environment, but I may be wrong.
Scott Canaan ([EMAIL PROTECTED])
(585) 475-7886
"Life is like a sewer, what you get
out of it depends on what you put into it." -
Did you remember to cut the db_file_multiblock_read_count
in half, since you doubled the blocksize? I would assume that you also started
seeing more full table scans, as well.
Scott Canaan ([EMAIL PROTECTED])
(585) 475-7886
"Life is like a sewer, what you get
out of it de
How about:
insert into table3(company_id,lev_id,vare_id)
(select table2.company_id,lev_id,vare_id
from table1, table2
where table1.company_id = table2.company_id);
Scott Canaan ([EMAIL PROTECTED])
(585) 475-7886
"Life is like a sewer, what you get out of it depends on wha
unt
lock';
end loop;
end;
/
Scott Canaan ([EMAIL PROTECTED])
(585) 475-7886
"Life is like a sewer, what you get out of it depends on what you put
into it." - Tom Lehrer.
-Original Message-
Sent: Friday, October 24, 2003 2:00 PM
To: Multiple recipi
done to
get around it? Let me know if I forgot any
important piece of
information.
Thank you.
--
Scott Canaan ([EMAIL PROTECTED])
(585) 475-7886
"Life is like a sewer, what you get out of it
depends on what you put
into it." - Tom Lehrer.
__
ervices-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> -
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note
TED]
>
> Fat City Network Services-- 858-538-5051 http://www.fatcity.com
> San Diego, California-- Mailing list and web hosting services
> ---------
> To REMOVE yourself from this mailing list, send an E-Mail messag
hich would require a rebuild of the
entire cluster.
Has anyone else run into this problem? If so, what have you done to
get around it? Let me know if I forgot any important piece of
information.
Thank you.
--
Scott Canaan ([EMAIL PROTECTED])
(585) 475-7886
"Life is like a sewer, what yo
Have you looked into using logminer? Even if it can't restore your
table, it can give you the exact time that it was dropped.
Scott Canaan ([EMAIL PROTECTED])
(585) 475-7886
"Life is like a sewer, what you get out of it depends on what you put
into it." - Tom Lehrer.
-O
Since, I believe, Paypal is owned by eBay, has any that's received this
sent a message to safeharbor? I would think they should be made aware
of it.
Scott Canaan ([EMAIL PROTECTED])
(585) 475-7886
"Life is like a sewer, what you get out of it depends on what you put
into it.&quo
According to the presentation by Dave Foster of Oracle at the last
UNYOUG meeting, there will be a direct upgrade from 8.1.7 and 9.2.
Also, the new dbassistant has an undo feature, to rollback the upgrade.
Scott Canaan ([EMAIL PROTECTED])
(585) 475-7886
"Life is like a sewer, what you get o
That's what I was thinking, too. I tried it on 8.1.7.4 and it works the
same way, as I expected. You would need an outer join to get something
back.
Scott Canaan ([EMAIL PROTECTED])
(585) 475-7886
"Life is like a sewer, what you get out of it depends on what you put
into it.&quo
ssword
2 from dba_users
3 where username = 'SCOTT';
PASSWORD
--
F894844C34402B67
SQL>
Scott Canaan ([EMAIL PROTECTED])
(585) 475-7886
"Life is like a sewer, what you get out of it depends on what you put
into it." - Tom Lehrer.
-Origi
Have you tried mailx? That's what we use here.
Scott Canaan ([EMAIL PROTECTED])
-Original Message-
Sent: Tuesday, September 09, 2003 10:04 AM
To: Multiple recipients of list ORACLE-L
Hi List
I tried the following stuff but it says "Service
Unavailable".
$mail -
4.789
>
> And if any of you
out there use Cognos Impromptu, perhaps you
> could tell
> me how I can achieve
these results in a report.
Would
this work?
select
a.whse_code,
a.item_num, a.last_cost,
b.last_cost
as last_cost_rev
from
item_w
a, item_w b
where
a.last
been interrupted? I have been looking in metalink and on the net
and haven't found anything that says how to do it. I tried technet, but
it was way too slow. Any thoughts would be greatly appreciated.
Thank you,
--
Scott Canaan ([EMAIL PROTECTED])
(585) 475-7886
"Life is like a sewer, what yo
Are you using Oracle Services? I've seen this happen before and we
change SERVICE_NAME to SID and everything works fine.
Scott Canaan ([EMAIL PROTECTED])
(585) 475-7886
"Life is like a sewer, what you get out of it depends on what you put
into it." - Tom Lehrer.
-O
me up with
nothing.
The vitals are:
Oracle 8.1.6.0.0
Digital Unix V4.0F (Rev. 1229)
Unfortunately, upgrading Oracle isn't an option because the
processor is too old. Oracle won't support it on any versions higher
than 8.1.6. A patchset may be possible, though.
Thank you.
--
be removed from).
You may
also send the HELP command for other information (like
subscribing).
--
Scott Canaan ([EMAIL PROTECTED])
(585) 475-7886
"Life is like a sewer, what you get out of it depends on what you put
into it." - Tom Lehrer.
e has on this.
Thank you.
--
Scott Canaan ([EMAIL PROTECTED])
(585) 475-7886
"Life is like a sewer, what you get out of it depends on what you put
into it" - Tom Lehrer
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Scott Canaan
INET: [EMAIL PROTECTED]
Fat Ci
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).
--
Scott Canaan ([EMAIL PROTECTED])
(585) 475-7886
"Life is like a sewer, what you get out of it depends on what yo
xpecting that I will).
Thank you.
--
Scott Canaan ([EMAIL PROTECTED])
(585) 475-7886
"Life is like a sewer, what you get out of it depends on what you put
into it." - Tom Lehrer.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Scott Canaan
INET: [EMAIL PROTECT
.I tried kill -9 pid
> . It shows killed.
> But procedure is still continuing..
>
> Thanks
> Manoj
--
Scott Canaan ([EMAIL PROTECTED])
(585) 475-7886
"Life is like a sewer, what you get out of it depends on what you put into
it" - Tom Lehrer
--
Please see the off
ted maximum number of concurrent procedure calls.
>
> Regards,
>
> Waleed
>
> -Original Message-
> Sent: Monday, July 01, 2002 2:20 PM
> To: Multiple recipients of list ORACLE-L
>
> Advanced Queuing will do what you need.
>
> There are examples at otn.oracle.c
case.
Required information:
Oracle Version: 8.1.7.0.0
Platform: Sun Solaris 2.8
Thank you,
--
Scott Canaan ([EMAIL PROTECTED])
(585) 475-7886
"Life is like a sewer, what you get out of it depends on what you put
into it" - Tom Lehrer
--
Please see the official ORACLE-L FAQ: http://
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 subscribing).
-
> 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 yo
- GE Appliances - [EMAIL PROTECTED]
Doing linear scans over an associative array is like
trying to club someone to death with a loaded
Uzi.
- Larry Wall (creator of Perl)
--
Scott Canaan ([EMAIL PROTECTED])
(716) 475-7886
"Life is like a sewer, what you get out of it depends on
in any way from this message
or its attachments.
--
Scott Canaan ([EMAIL PROTECTED])
(716) 475-7886
"Life is like a sewer, what you get out of it depends on what you put
into it" - Tom Lehrer
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Scott Canaan
INE
also tried the underlying tables), but
Oracle won't let me create a trigger on any of these.
I don't know where else to go, and I hate to tell a customer that I
can't do it, but I'm out of ideas. Anyone here have any?
Thank you,
--
Scott Canaan ([EMAIL PROTECTED])
(716)
rnet 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
he 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).
--
Scott Canaan ([EMAIL PROTECTED])
(585) 475-7886
"Life is like a sewer, what you ge
? If so, how did you
"correct" it? My feeling is that EMC is trying to give us a bandage to
cover up the real problem, by trying to get Oracle to ignore it.
Thank you.
--
Scott Canaan ([EMAIL PROTECTED])
(585) 475-7886
"Life is like a sewer, what you get out of it depends on what
u
> > "correct" it? My feeling is that EMC is trying to give us a bandage to
> > cover up the real problem, by trying to get Oracle to ignore it.
> >
> > Thank you.
> >
> > --
> > Scott Canaan ([EMAIL PROTECTED])
> > (585) 475-7886
>
, and
haven't had the problem since. Now we need to get the power supply
replaced. Interesting that EMC tried to blame it on Oracle first.
Scott Canaan wrote:
> We have implemented a Sun Solaris Cluster (4 machines), connected to
> an EMC storage array. The migration began last
internal error code, arguments: [25012], [1], [2], [], [],
> > [], [], []
> >
> > Does anyone know what I was doing wrong? I can't figure it out, and
> > Oracle support couldn't figure it out, either. I was able to get the
> > database up by getting more di
tablespace and rollback segments, smaller than
> > > those in production. This didn't work, even though Oracle support said
> > > it should have. When I did the clone, the database would not open. I
> > > kept getting the following error:
> > >
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).
--
Scott Canaa
> 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 ma
st, 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 send the HELP command for other information
---------
> 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
http://www.orafaq.com
> --
> Author: Yosi Greenfield
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> ----
> San Diego, California-- Public Internet 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
>
er by phone or email and delete this
e-mail message from your computer.Thank
you.
--
Scott Canaan ([EMAIL PROTECTED])
(585) 475-7886
"Life is like a sewer, what you get out of it depends on what you put
into it" - Tom Lehrer
--
> 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 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).
--
Scott Canaan ([EMAIL PROTECTED])
(585) 475-7886
"Life is like
; Name: ESPN_Disclaimer.txt
>ESPN_Disclaimer.txt Type: Plain Text (text/plain)
> Encoding: 7BIT
--
Scott Canaan ([EMAIL PROTECTED])
(585) 475-7886
"Life is like a sewer, what you get out of it depends on what you put into it" -
as
done to trick me into admitting that I had implemented the feature.
--
Scott Canaan ([EMAIL PROTECTED])
(585) 475-7886
"Life is like a sewer, what you get out of it depends on what you put
into it" - Tom Lehrer
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: S
t; license
> was purchased prior to Partioning being available, so that doesn't
> count.
>
> I'm telling everyone about this as a heads-up. It appears that Oracle
> is digging for money, and I feel that the approach that was used was
> done to trick me into admitting that
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
anned for Viruses and Content and cleared
by MailMarshal - For more information
please visit www.marshalsoftware.com
--
Scott Canaan ([EMAIL PROTECTED])
(585) 475-7886
"Life is like a sewer, what you get out of it depends on what you put
into it" - Tom Lehrer
ant to be removed from). You may
> also send the HELP command for other information (like subscribing).
--
Scott Canaan ([EMAIL PROTECTED])
(716) 475-7886
"Life is like a sewer, what you get out of it depends on what you put into it"
- Tom Lehrer
--
Please see the official ORACLE-
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).
--
Scott Canaan ([EMAIL PROTECTED])
(716) 475
ng 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 send the HELP command for other information (
name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
--
Scott Canaan ([EMAIL PROTECTED])
(716) 475-7886
"Life is like a sewer, what you get out of it depends on what you put into
it" - Tom Lehrer
--
Pl
t; (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
--
Scott Canaan ([EMAIL PROTECTED])
(716) 475-7886
"Life is like a sewer, what you get out of it depends on what you put
into it" - Tom Lehrer
--
EMOVE 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 send the HELP com
ase see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Boivin, Patrice J
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
>
date and time.
This is on Oracle 8.1.6.0 on Sun Solaris.
Any suggestions? Thank you.
--
Scott Canaan ([EMAIL PROTECTED])
(716) 475-7886
"Life is like a sewer, what you get out of it depends on what you put
into it" - Tom Lehrer
--
Please see the official ORACLE-L FAQ: http://www.or
presume because it has a
> comma before it and it assumes that it is a different field. I can't
> figure out any way to get this loaded with the trans_date field
> containing both the date and time.
>
> This is on Oracle 8.1.6.0 on Sun Solaris.
>
> Any suggestions?
E 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 send the HELP comm
ding the message and opening any attachments,
the recipient accepts full responsibility for taking protective and remedial
action about viruses and other defects. Cendant Corporation or Affiliates
are not liable for any loss or damage arising in any way from this message
or its attachments.
--
ontaining: 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).
--
Scott Canaan ([EMAIL PROTECTED])
(716) 475-7886
"Life is like a sewer, what you get out of it depends on what you put into
de 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).
--
Scott Canaan ([EMAIL PROTECTED])
(716) 475-7886
"Life is like a sewer, what you get out of it depends on what yo
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).
--
Scott Canaan ([EMAIL PROTECTED])
"Life is like a sewer, what you get out of it depends on w
> 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).
--
Scott Canaan ([EMAIL PROTECTED])
(716) 475-7886
"Life is like a sewer, what yo
NSUB 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).
--
Scott Canaan ([EMAIL PROTECTED])
(716) 475-7886
"Life is like a sewer, what you get out of it depends on what you put into it"
k that between A and # exist
some strange character that i can´t identify it .. How can I
do it ? Regards Eriovaldo
--
Scott Canaan ([EMAIL PROTECTED])
"Life is like a sewer, what you get out of it depends on what you put
into it" - Tom Lehrer
--
Please see the official ORACL
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 send the HEL
--
> 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 fro
71 matches
Mail list logo