-
| Brian McGraw -+- Senior DBA |
| mailto:[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 FAQ: http://w
I would opt to separate them.
I ran into some problems with a Collaboration Suite install, where I wanted to use the
OID database, to store my files data as well. It failed in a spectacular fashion. An
Oracle support analyst said that was a bad idea. When I asked him if I could just
create
It wasnt fixed in my version of 9.2.0.3:
ERROR at line 11:
ORA-00600: internal error code, arguments: [kkqwrm_noref: COLFDNF set], [],
[],
[], [], [], [], []
9.2.0.3, 32-bit. Solaris 8.
Brian
-
| Brian McGraw -+- Senior DBA |
| mailto:[EMAIL PROTECTED
I would suggest the $ORACLE_HOME/rdbms/admin/utlrp.sql script, which
recompiles any invalid objects, or the $ORACLE_HOME/rdbms/admin/utlirp.sql
script, which will invalidate and recompile objects for you.
-
| Brian McGraw -+- Senior DBA |
| mailto:[EMAIL
I actually sat for the beta of that exam, the week before OracleWorld. I
haven't received my scores yet, so I doubt that it is actually being offered
to the general public yet. But that *is* the plan.
Brian
-----
| Brian McGraw -+- Senior DBA |
| mailto:[
love OT Fridays. :)
Brian
-----
| Brian McGraw -+- Senior DBA |
| mailto:[EMAIL PROTECTED] |
-
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Brian McGraw
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http:
I think you might be referring to this footnote, from the same document:
NOTE: Although triggers of different types are fired in a specific order, triggers of
the same type for the same statement are not guaranteed to fire in any specific order.
For example, all BEFORE row triggers for a single
Affirmative. I used SQL*Plus during one of the Hands-On 10G Database sessions at
OracleWorld.
Brian
- Original Message -
Date: Monday, September 22, 2003 11:19 am
> Hello:
>
> Was watching Larry Ellison's key note and he mentioned that they
> still have
> SQL Plus in 10g.
> I heard
Title: Message
I believe the official publication date is
09/17.
“Tomorrow, Tomorrow… You’re
only a Day Away”
Brian
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Mladen
Gogala
Sent: Tuesday, September 16, 2003
10:05 AM
To: Multiple re
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.net
--
Author: Brian McGraw
INET: [
Is anyone attending the 9i Cram Session on Sunday? If so,
could you please email me off-list?
Thanks,
Brian
[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
I'll be there! And judging from all of the responses you've gotten,
looks like I'll finally get to meet some of my favorite posters from the
list.
Brian
-----
| Brian McGraw -+- Senior DBA |
| mailto:[
Title: RE: 9ias install - automatic creation of database
Paula –
To quote a former President, I feel your
pain.
I have been trying to get iAS installed
for *weeks* with only limited
success. I installed it once, only to find out later that I needed the
Portal option. To get the
Rachel -
Do you actually have the error text from the alert log?
Looks like I have something to add to my Perl script... :)
Brian
--
| Brian McGraw /* DBA */ Infinity Insurance |
| mailto:[EMAIL PROTECTED
Jared -
I assume you're attempting fast refreshes - Is it feasible to attempt a full refresh?
I remember problems w/ snapshots (in the 8.0.4 days) where the snapshot logs would
just stop working. I had to perform a full refresh of the snapshots, then drop and
recreate the snapshot logs.
Br
rated)' and type in the schema name.
2. That's a little more difficult. My first instinct would be to check
your path and make sure that the Oracle binaries are in it. Are you
able to successfully connect to the database via SQL*Plus? Can you
TNSPING it?
Brian
----
Hope that information is useful to someone out there...
Brian
--
| Brian McGraw /* DBA */ Infinity Insurance |
| mailto:[EMAIL PROTECTED] |
--
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Jo
min
Some were talking about an April Fool’s joke with local
tnsnames.ora files. I think you’d have a lot more fun with the .tnsnames.ora
file, if you’re on Solaris. J
Hope that information is useful to someone out there…
Brian
------
| Bria
.
Enjoy... Feel free to improve on it or point out any errors...
Brian
--
| Brian McGraw /* DBA */ Infinity Insurance |
| mailto:[EMAIL PROTECTED
strategists, if I recall correctly.
Brian
--
| Brian McGraw /* DBA */ Infinity Insurance |
| mailto:[EMAIL PROTECTED]
|
--
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]] On
Rick -
Are all of the sqlnet.ora files resolving hostnames in the same order
i.e., NAMES.DIRECTORY_PATH= (ONAMES, TNSNAMES, HOSTNAME)? I'd also
check for a rogue tnsnames.ora file in the same path as the executable.
Brian
--
| Brian McGraw /
ke subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Brian McGraw
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
---
Absolutely. Which is why none of my 8i OPS databases have gone to 9i
RAC yet. And from the recent article that was posted here (on Grid
Computing), I'm not alone.
--
| Brian McGraw /* DBA */ Infinity Insurance |
| mailto:Brian.McGraw@;Inf
With or without the *really fine* compression flag?? (-rf)
: )
--
| Brian McGraw /* DBA */ Infinity Insurance |
| mailto:[EMAIL PROTECTED]
|
--
-Original Message-
From: [EMAIL
backup. It honestly sounds
like you’re trying to do a cold backup while the database is still up,
but that’s just a guess.
Brian
--
| Brian McGraw /* DBA */ Infinity Insurance |
| mailto:[EMAIL PROTECTED
Title: RE: Oracle and Informix on one server memory issues
In the past, we ran an older incarnation of
Informix SE here, on a Solaris 2.6 box along with 8.1.6 and 8.1.7. There were no
issues / problems.
Brian
--
| Brian McGraw /* DBA
any “gotchas”
that I need to be aware of??
Thanks In Advance,
Brian
--
| Brian McGraw /* DBA */ Infinity Insurance |
| mailto:[EMAIL PROTECTED]
|
--
Rahul -
What error messages are you getting??
I had similar problems a while back w/ OEM 2.2, but followed the steps
laid out in Oracle Enterprise Manager 101 (Oracle Press), and it worked
like a champ.
Brian
--
| Brian McGraw /* DBA */ Infinity
lling everyone's leg :)
------
| Brian McGraw /* DBA */ Infinity Insurance |
| mailto:[EMAIL PROTECTED] |
--
-Original Message-
Robert
Sent: Friday, August 30, 2002 3:43 PM
To: Multiple recipients of list ORACLE-L
They are going to have iSQL*Plus (or howe
Not all Oracle API's support TAF. I know that the JDBC thin driver does
not support TAF, while the JDBC OCI driver does.
Brian
--
| Brian McGraw /* DBA */ Infinity Insurance |
| mailto:[EMAIL PROT
D] (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 FAQ: htt
he 32-bit version.
HTH -
Brian
--
| Brian McGraw /* DBA */ Infinity Insurance |
| mailto:[EMAIL PROTECTED] |
--
-Original Message-
Carmichael
Sent: Wednesday, July 17, 2002 12:09 PM
To: Mul
Sorry, all... That was obviously a message meant only for Robert...
Stupid hotkeys...
--
| Brian McGraw /* DBA */ Infinity Insurance |
| mailto:[EMAIL PROTECTED] |
--
-Original Message-
Robert
Sent
--
| Brian McGraw /* DBA */ Infinity Insurance |
| mailto:[EMAIL PROTECTED] |
--
-Original Message-
Robert
Sent: Monday, July 08, 2002 4:04 PM
To: Multiple recipients of list ORACLE-L
First of all, apologies to those I have talked to
Are there any DBAs out there supporting Saleslogix?
If so, could you email me privately? I have some questions
that I’d like to bounce off of someone more familiar with this…
application.
Thanks,
Brian
--
| Brian McGraw /* DBA
Would that be "more unbreakable" ???
------
| Brian McGraw /* DBA */ Infinity Insurance |
| mailto:[EMAIL PROTECTED] |
--
-Original Message-
Gorbatchev
Sent: Wednesday, June 26, 2002
Hmmm. Maybe that's changed, but we were actually advised to move the
objects when we set them up in v8.
--
| Brian McGraw /* DBA */ Infinity Insurance |
| mailto:[EMAIL PROTECTED] |
--
-Ori
That explains it.
We're just paying the license fees for the test software. :)
--
| Brian McGraw /* DBA */ Infinity Insurance |
| mailto:[EMAIL PROTECTED] |
--
-Original Message-
Sent: M
Can I get an Amen??? :)
--
| Brian McGraw /* DBA */ Infinity Insurance |
| mailto:[EMAIL PROTECTED] |
--
-Original Message-
Sent: Monday, June 17, 2002 9:38 PM
To: Multiple recipients of list
got to
try that out!'
I would bet that it has some information that you would find beneficial.
Brian
------
| Brian McGraw /* DBA */ Infinity Insurance |
| mailto:[EMAIL PROTECTED] |
--
-Original Me
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: Brian McGraw
INET: [EMAIL PROT
r information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Brian McGraw
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California
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: Brian McGraw
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 F
end the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Brian McGraw
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet ac
> And for others, I believe this was a major turning
> > > > > > point and an eye-opener
> > > > > > as far as the Wait Interface goes (This has
> > > > > > (un)officially been renamed to
> > > > > > OWI as per Kirti's slides :
end 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 subscribing).
--
Please
DELETEDIf set to YES indicates the piece is deleted
START_TIME The starting time.
COMPLETION_TIMEThe completion time.
ELAPSED_SECONDSThe number of elapsed seconds.
HTH -
Brian
------
| Brian McGraw /* DBA */
MSRP. Of course, the actual price depends on which part of the fiscal
year you catch the sales weasels in... :)
Brian
--
| Brian McGraw /* DBA */ Infinity Insurance |
| mailto:[EMAIL PROTECTED
y
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Brian McGraw
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public
DY, 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: Brian McGraw
I
;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).
--
--
| Brian McGraw
t his
wife had a close acquaintance whose sister was, in fact, related to Larry
Ellison and she talked to him about it, so therfore it must be true.
(Note: The Larry Ellison reference makes this an OT post).
Brian
--
------
| Brian McGraw /* DBA */ Infinity
Which docs? I looked at the init.ora file, and it had:
processes=530
and MTS enabled.
Brian
--
--
| Brian McGraw -- Oracle DBA |
| Central Alabama Oracle Users Group |
--
Rachel Carmichael wrote:
> they
ECTED]
--
--
| Brian McGraw -- Oracle
DBA |
| Central Alabama Oracle Users Group |
||
| mailto:[EMAIL PROTECTED] |
| http://bmcgraw.home.mindspring.com |
--
gt; 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 subs
tion is this - have any of you running OPS come across a similar
issue??
Thanks.
Brian
--
----------
| Brian McGraw -- Oracle DBA |
| Central Alabama Oracle Users Group |
||
| mailto:[EMAIL PROTECTED] |
| http
removed from). You may
> also send the HELP command for other information (like subscribing).
--
--
| Brian McGraw -- Oracle DBA |
| Central Alabama Oracle Users Group |
||
| mailto:[EMAIL PROTECTED] |
| http://bm
.orafaq.com
> <http://www.orafaq.com>
> --
> Author: Kimberly Smith
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> -
x27;) 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).
--
------
| Brian McGraw -- Orac
Guru') 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).
--
--
| Brian McGraw --
the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
--
--
| Brian McGraw -- Oracle DBA |
| Central Alabama Oracle Users Group |
|-
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).
--
--
| Brian McGraw -- Oracle DBA |
| Central Alabama Oracle
Oracle to enforce this in the past! I
> think it's a great idea!
>
> Tom Mercadante
> Oracle Certified Professional
>
> -Original Message-
> Sent: Wednesday, October 17, 2001 6:00 PM
> To: Multiple recipients of list ORACLE-L
>
> ok i'll guess
Michael -
This is Brian McGraw, from the OPS class. Please email me - I found the
documents that we discussed.
Brian
--
--
| Brian McGraw -- Oracle DBA |
| Central Alabama Oracle Users Group |
||
| mailto:[EMAIL
removed from). You may
> also send the HELP command for other information (like subscribing).
--
--
| Brian McGraw -- Oracle DBA |
| Central Alabama Oracle Users Group |
||
| mailto:[EMAIL PROTECTED] |
| http://bmcgraw.home
RACLE-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).
--
--
| Brian McGraw -- Oracle DBA |
| Central Alabama Oracle Users Grou
-
> 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
> als
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 command
#x27;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).
--
--
| Brian McGraw
VE 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 HE
All this, just to get a patch for a bug that I apparently do not have
access to on Metalink.
I'm so irritated that I could pull my hair out, but I like all 5 that
are left...
--
------
| Brian McGraw -- Oracle DBA |
| Central Alabama Ora
TECTED] (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 subscribin
*)
--
1
SQL> select count(*) from dbm_3;
COUNT(*)
--
1
Notice that the trigger handled the exception perfectly. Of
course, you'd want to code the exception more accurately, but
I think this example proves that it is possible.
Brian
--
--
f 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: Christopher Spence
sts
> --------
> 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 t
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 command for other information (like subscribing).
--
--
| Brian McGraw -- Oracle
DBA |
| Central Alabama Oracle Users Group |
||
| mailto:[EMAIL PROTECTED] |
| http://bmcgraw.home.mindspring.com |
--
MAIL 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).
--
--
Hmmm
SQL> select to_char(sysdate,'SSDD') from dual;
TO_C
3903
: )
Brian
--
--
| Brian McGraw -- Oracle DBA |
| Central Alabama Oracle Users Group |
||
| mailto:[EMAIL PROTECTED]
#x27;) 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).
--
--
| Brian McGraw -- Oracle DBA |
| Central Alaba
cial ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: =?iso-8859-1?q?paquette=20stephane?=
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> --
y 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
> &
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).
--
--
Most of the high-volume replicated sites that I have heard of over the past few years
use Quest's Shareplex. I've had no experience with Clustra.
Brian
--
------
| Brian McGraw -- Oracle DBA |
| Central Alabama Oracle U
85 matches
Mail list logo