subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: John Weatherman
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mai
tion (like
subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: John Weatherman
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, Calif
e 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: John Weatherman
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://w
age 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.net
--
Author: John Weatherman
INET: [EMAIL
.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: John Weatherman
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and
anything odd with 9iR2 or is everyone
pretty happy with it. Just going for a last sanity check here.
Thanks,
John P Weatherman
Oracle Database Administrator
Replacements, Ltd.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: John Weatherman
INET: [EMAIL PROTECTED
man
Oracle Database Administrator
Replacements, Ltd.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: John Weatherman
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hostin
ou may also send the HELP
command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: John Weatherman
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mai
q.net
--
Author: John Weatherman
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 yourself from this mailing
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).
--
Ple
Title: Message
Or if
you set autocommit, in which case a commit is issued every X number of
operations.
John P WeathermanOracle Database
AdministratorReplacements, Ltd.
-Original Message-From: Jamadagni,
Rajendra [mailto:[EMAIL PROTECTED]] Sent: Thursday,
January 02, 2003
Title: Message
So
they figured out the memory/personality transfer too?
John P WeathermanOracle Database
AdministratorReplacements, Ltd.
-Original Message-From: KENNETH JANUSZ
[mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 31, 2002 9:59
AMTo: Multiple recipients of
strator
Replacements, Ltd.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: John Weatherman
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and
e 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.net
--
Author: John Weatherman
INET: [EMAIL PROTECT
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 EXACT spelling of &
ly generate the connect to the database. :)
Thanks,
John P Weatherman
Database Administrator
Replacements Ltd.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: John Weatherman
INET: [EMAIL PROTECTED
trying to grep the ip (and ultimately port) of the listener so I can
dynamically generate the connect to the database. :)
Thanks,
John P Weatherman
Database Administrator
Replacements Ltd.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: John Weatherman
INET
();
}
myTablespaces.close();
Anybody with some Java experience have any insite?
As always, TIA,
John P Weatherman
Database Administrator
Replacements Ltd.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: John Weatherman
INET: [EMAIL PROTECTED]
Fat City Network Ser
+ filename);
}
myDataFiles.close();
}
myTablespaces.close();
Anybody with some Java experience have any insite?
As always, TIA,
John P Weatherman
Database Administrator
Replacements Ltd.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Aut
SUB 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: John Weatherman
INET: [EMAIL PROTECTED]
Fat City Network Services
for
access to OEM).
TIA,
John P Weatherman
Database Administrator
Replacements Ltd.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: John Weatherman
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego,
the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: John Weatherman
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
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: John Weatherman
INET: [EMAIL PROTECTED]
.
Then try to discover the node.
Reginald W. Bailey
DBA, Consultant and MOKF
John Weatherman <[EMAIL PROTECTED]>@fatcity.com on
10/17/2002 03:10:41 PM
Please respond to [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
c
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).
essage
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 see the of
Weatherman
Database Administrator
Replacements Ltd.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: John Weatherman
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hostin
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: John Weatherman
INET: [EMAIL PROTECTED]
Fat City N
command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: John Weatherman
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San D
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 maili
LE-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: John Weatherman
INET: [EMAIL PROTECTED]
Fat City Network Services
I am
trying to write a pl/sql package to allow end users to rebuild partitioned
indexes.
I have
everything working when the package.procedure is run as sys, however when
I
run it
as the object owner I get ORA-01031: insufficient privileges errors. Other
parts
the
the package (adding new
ing 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: UNSUB ORACLE-L
(or the name of mailing list
n P Weatherman
Database Administrator
Replacements Ltd.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: John Weatherman
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (8
istrator
Replacements Ltd.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: John Weatherman
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
N.PK_BUY_PRICE_PCE_TYPE_HISTORY' or partition of
such
index is in unusable state
SQL>
TIA,
John P Weatherman
Database Administrator
Replacements Ltd.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: John Weatherman
INET: [EMAIL PROTECTED]
Fat City Network
es the RDBMS have to determine whether
--- John Weatherman <[EMAIL PROTECTED]> wrote:
> Paul,
>
> The procedures are executed by a special "internal" trigger. These
> triggers are also NOT dropped by catrepr.sql (yes, I found out the
> hard way!). It is docume
ke subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: John Weatherman
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Pub
) 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: John Weatherman
IN
inal Message -
From:
John Weatherman
To: Multiple
recipients of list ORACLE-L
Sent: Wednesday, September 04, 2002
12:43 PM
Subject: Coercion issue
Hi
all,
I'm writing a package to manipulate a partitioned
table for the duhvelo
Hi
all,
I'm
writing a package to manipulate a partitioned table for the
duhvelopers and have run into
a
weird query that I can't figure out. I can convert a substring to a number
in a select clause,
but as
soon as I try to use that same number in the where clause, the thing
chokes. Ha
ee the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: John Weatherman
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
---
age
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 (lik
Kumar,
You
can't copy the datafiles between OSs unless they are binary compatable, with
Windows and any
flavor
of Unix are not. Also, you will have problems trying to export from 9i and
import to 8i. You need
to run
the export using 8i executables, or at least I could never get it to wo
cial ORACLE-L FAQ: http://www.orafaq.com
--
Author: John Weatherman
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
-
;m missing something obvious, but I haven't
worked these things before and am not seeing it in the M or the
code I have access too.
TIA,
John P Weatherman
Database Administrator
Replacements Ltd.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: John Weatherman
INE
ther information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: John Weatherman
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access
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 ma
it is considered to be now. Maybe someone else can illuminate.
PAX,
John P Weatherman
Database Administrator
Replacements Ltd.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: John Weatherman
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051
g: 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: John Weatherman
INET: [EMAIL PROTECTED]
Fat City Network Serv
w inflated setup
cost. We looked at the "let it expire" approach carefully...
John P Weatherman
Database Administrator
Replacements Ltd.
-Original Message-
Sent: Wednesday, August 14, 2002 10:09 AM
To: Multiple recipients of list ORACLE-L
-- John Weatherman <[EMAI
Close to a wash, but actually ended up slightly more expensive to
create the new contract. :)
John P Weatherman
Database Administrator
Replacements Ltd.
-Original Message-
Sent: Wednesday, August 14, 2002 11:34 AM
To: Multiple recipients of list ORACLE-L
-- John Weatherman
-
Sent: Wednesday, August 14, 2002 10:09 AM
To: Multiple recipients of list ORACLE-L
-- John Weatherman <[EMAIL PROTECTED]>
> Naveen,
>
> I can't say if it's a global policy or not. However in my last life,
> we initially purchased ALL modules assuming about 2000 use
he 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: John Weatherman
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051
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
--
Author: John
--
Author: John Weatherman
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,
e database creation scripts.
Can someone tell me where the server character set is set?
TIA,
John P Weatherman
Database Administrator
Replacements Ltd.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: John Weatherman
INET: [EMAIL PROTECTED]
Fat City Network Services
where the server character set is set?
TIA,
John P Weatherman
Database Administrator
Replacements Ltd.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: John Weatherman
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San
Title: RE: Jared, please do something
Way to
fan the flames
John P Weatherman Database Administrator Replacements Ltd.
-Original Message-From: Gesler, Rich
[mailto:[EMAIL PROTECTED]]Sent: Wednesday, July 31, 2002 2:18
PMTo: Multiple recipients of list ORACLE-LSubject: RE
of a post startup
trigger. Help?
TIA,
John P Weatherman
Database Administrator
Replacements Ltd.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: John Weatherman
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego,
So how do I get into the archives? I've got a question I know I've seen
answered.
Thanks,
John P Weatherman
Database Administrator
Replacements Ltd.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: John Weatherman
INET: [EMAIL PROTECTED]
Fat City Networ
r_handle);
19* END;
When I turn it into a trigger:
CREATE OR REPLACE TRIGGER sys.sync_spfile AFTER STARTUP ON DATABASE
{everything else the same}
It compiles fine. However it doesn't execute on startup for some reason.
Any ideas?
TIA,
John P Weatherman
Database Administrator
Replacements
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
Title: RE: RE: B&R solutions
There's also the little matter of the dev refresh
strategy being wedded to the backup strategy. Moving
generally means ripping out the best part of the
infrastructure. :)
John P Weatherman Database Administrator Replacements Ltd.
-Original Message-Fr
t 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: Mercadante, Thomas F
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Dieg
tGuru') 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: John Weat
ss to the raw data
(groan...loudly!)... I've argued every which-a-way against the concept, now
I have to fight the specifics
HELP!
John P Weatherman
Database Administrator
Replacements Ltd.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: John Weatherman
I
: [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 O
tabase Administrator
Replacements Ltd.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: John Weatherman
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet ac
ACLE-L
All,
When using automated UNDO in 9iR1, should the system rollback segment
normally be left offline?
TIA,
John P Weatherman
Database Administrator
Replacements Ltd.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: John Weatherman
INET: [EMAIL PROTECTED]
All,
When using automated UNDO in 9iR1, should the system rollback segment
normally be left offline?
TIA,
John P Weatherman
Database Administrator
Replacements Ltd.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: John Weatherman
INET: [EMAIL PROTECTED]
Fat City
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: John Weatherman
IN
, you must use a trigger, with some variation of
select .nextval into :new. from dual;
Paul Baumgartel
--- John Weatherman <[EMAIL PROTECTED]> wrote:
> OK, I RTFM and am probably just missing it. Is there an easy may to
> define
> a default as a NextVal? When I try, I'm getting
icial ORACLE-L FAQ: http://www.orafaq.com
--
Author: John Weatherman
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing
ACLE-L FAQ: http://www.orafaq.com
--
Author: CHAN Chor Ling Catherine (CSC)
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--
5 Jun 2002, John Weatherman wrote:
> I am in the process of writing a pl/sql block to run on instance A. At
one
> point, I need to run a procedure that resides in instance B against
instance
> B's dataset. Is there an easy way to do this?
>
> The basic problem is:
>
&
return code if everything is ready ###
Is it possible to issue a connect within a PL/Sql block?
TIA,
John P Weatherman
Database Administrator
Replacements Ltd.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: John Weatherman
INET: [EMAIL PROTECTED]
Fat City Network
x27;t find
anything but a white paper long on generalities and short on specifics that
references ODM. Any ideas?
TIA,
John P Weatherman
Database Administrator
Replacements Ltd.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: John Weatherman
INET: [EMAIL PROTECTED]
Fat
abase
--- John Weatherman <[EMAIL PROTECTED]> wrote:
> All very true. Of course the doc in question was written for 8i, so
> that
> explains some of it. :) Question: Does logical standby in 9.2 work
> across
> platforms? Haven't had too much time to look at new 9.2 fea
hold up" the primary site from continuing
on, but the databases are not true copies of one another. Sync are true
copies but you can hold up the commit waiting for a return from the
remote site.
And if it fails, it's messy to clean up
--- John Weatherman <[EMAIL PROTECTED]> wrote
( from anyone ) on why one would use AR for failover, rather
than using a standby database?
Jared
John Weatherman <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
06/14/2002 09:50 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
ts of list ORACLE-L
Hi all
I will work on replication soon. any advice for reference I can get.
Thanks in advance.
Mitchell
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: John Weatherman
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX:
q.com
--
Author: John Weatherman
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 ma
TIA,
John P Weatherman
Database Administrator
Replacements Ltd.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: John Weatherman
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (
Something for the internals
folks.
Last
week we had a situation where the production system froze and we had to reboot
to
get
everything working again. Working with Oracle Support, we determained that
we had
encountered bug 2230693. The workaround was to
set the event listed above
e official ORACLE-L FAQ: http://www.orafaq.com
--
Author: John Weatherman
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
-
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 command for ot
g again?
>
> TIA,
>
> John P Weatherman
> Database Administrator
> Replacements Ltd.
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: John Weatherman
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 5
ohn P Weatherman
Database Administrator
Replacements Ltd.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: John Weatherman
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access
All,
I had
an instance crash this morning and sence then have been getting
an
ORA-3113 whenever I try to open it. It will
startup nomount and mount,
the
error occurs on the open. A search on metalink showed this was likely
a
shared memory error and recommended a reboot, which I have n
Yes, this should be easy
I need to find all the tables that referance a given table in their
constraints.
Can somebody help, it's been a long day
TIA,
John
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: John Weatherman
INET: [EMAIL PROTECTED]
Fat
What
about issueing a HOST command through dbms_sql? Not saying it will work (I
haven't tried it)
but it
seems like it should.
-Original Message-From: Hately Mike
[mailto:[EMAIL PROTECTED]]Sent: Friday, April 19, 2002 5:53
AMTo: Multiple recipients of list ORACLE-LSubject: R
ing 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
--
Au
the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: John Weatherman
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
-
formation (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: John Weatherman
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access
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: John Weatherman
INET: [EMAIL PROTECTED]
Fat City Net
with differing version of Oracle for
the masters? Any special gotchas I should be aware of?
Thanks for any and all help!
Pax,
John
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: John Weatherman
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051
97 matches
Mail list logo