RE: Who fired the trigger

2003-12-19 Thread John Weatherman
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

RE: tis a puzzlement...

2003-12-05 Thread John Weatherman
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

RE: Table partitioning Oracle 9.2

2003-10-31 Thread John Weatherman
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

RE: Oracle Apps: Single Node or Multi-node install?

2003-10-31 Thread John Weatherman
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

RE: file ownership

2003-08-20 Thread John Weatherman
. -- 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

9iR2

2003-08-04 Thread John Weatherman
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

OEM 4

2003-03-28 Thread John Weatherman
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

RE: Ora-00600 fun

2003-02-14 Thread John Weatherman
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

9.0.1.4 performance issues

2003-01-03 Thread John Weatherman
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

RE: functions/procedures and commits

2003-01-02 Thread John Weatherman
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

RE: functions/procedures and commits

2003-01-02 Thread John Weatherman
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

RE: ORA-1410 Silliness

2002-12-31 Thread John Weatherman
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

Java Database Connection

2002-12-23 Thread John Weatherman
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

RE: Restoring DB from specific RMAN backup set.

2002-12-19 Thread John Weatherman
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

RE: Backup DB files to the Tape

2002-12-18 Thread John Weatherman
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 &

RE: Another Java Question

2002-12-10 Thread John Weatherman
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

Another Java Question

2002-12-09 Thread John Weatherman
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

RE: Help with Java

2002-12-03 Thread John Weatherman
(); } 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

Help with Java

2002-12-03 Thread John Weatherman
+ 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

RE: OEM Config Assistant

2002-11-22 Thread John Weatherman
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

FW: Export from Previous Release

2002-11-18 Thread John Weatherman
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,

Export from Previous Release

2002-11-15 Thread John Weatherman
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

RE: OEM can't seem to discover 1 instance

2002-10-23 Thread John Weatherman
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]

RE: OEM can't seem to discover 1 instance

2002-10-18 Thread John Weatherman
. 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

RE: OEM can't seem to discover 1 instance

2002-10-17 Thread John Weatherman
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).

OEM can't seem to discover 1 instance

2002-10-17 Thread John Weatherman
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

RE: Multiple Listeners

2002-10-16 Thread John Weatherman
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

RE: Multiple Listeners

2002-10-16 Thread John Weatherman
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

RE: Multiple Listeners

2002-10-16 Thread John Weatherman
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

RE: Verrrry interesting article at MetaLink

2002-10-10 Thread John Weatherman
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

RE: Backups

2002-10-03 Thread John Weatherman
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

PL/SQL DDL Permissions

2002-09-19 Thread John Weatherman
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

RE: Satisfied customer

2002-09-12 Thread John Weatherman
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

RE: Disabling local partitioned indexes for load

2002-09-10 Thread John Weatherman
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

Disabling local partitioned indexes for load

2002-09-09 Thread John Weatherman
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

RE: Oracle and Cache Hit Ratio based training

2002-09-09 Thread John Weatherman
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

RE: Replication question

2002-09-05 Thread John Weatherman
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

RE: Replication question

2002-09-05 Thread John Weatherman
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

RE: Replication question

2002-09-05 Thread John Weatherman
) 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

RE: Coercion issue

2002-09-04 Thread John Weatherman
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

Coercion issue

2002-09-04 Thread John Weatherman
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

RE: Please need some help on imp

2002-08-30 Thread John Weatherman
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 ---

RE: Problem in creating DB Link

2002-08-26 Thread John Weatherman
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

RE: Moving Oracle 9i / Windows 2000 Database to Red Hat Linux 7.

2002-08-22 Thread John Weatherman
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

RE: EXTPROC

2002-08-20 Thread John Weatherman
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 -

EXTPROC

2002-08-20 Thread John Weatherman
;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

RE: Oracle 9.2 Client/Server cnct to Oracle7 NOT Supported

2002-08-19 Thread John Weatherman
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

RE: Oracle Arm Twisting?

2002-08-16 Thread John Weatherman
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

RE: Simple favor from the guru's

2002-08-16 Thread John Weatherman
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

RE: Hot Backup using EMC /BCV splits

2002-08-15 Thread John Weatherman
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

RE: Oracle Arm Twisting?

2002-08-14 Thread John Weatherman
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

RE: Oracle Arm Twisting?

2002-08-14 Thread John Weatherman
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

RE: Oracle Arm Twisting?

2002-08-14 Thread 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

RE: Oracle Arm Twisting?

2002-08-14 Thread John Weatherman
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

RE: E business Suite 11i - for Apps DBA's

2002-08-12 Thread John Weatherman
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

RE: NLS Question

2002-08-09 Thread John Weatherman
-- 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,

RE: NLS Question

2002-08-09 Thread John Weatherman
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

NLS Question

2002-08-09 Thread John Weatherman
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

RE: Jared, please do something

2002-07-31 Thread John Weatherman
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

Host System Commands from PL/SQL blocks

2002-07-30 Thread John Weatherman
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,

RE: Replication Question

2002-07-30 Thread John Weatherman
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

pfile/spfile Sync Problems

2002-07-29 Thread John Weatherman
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

RE: RE: B&R solutions

2002-07-26 Thread John Weatherman
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

RE: RE: B&R solutions

2002-07-25 Thread John Weatherman
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

RE: MUST read Oracle Architecture - Abrief Intro

2002-07-24 Thread John Weatherman
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

RE: Rant

2002-07-22 Thread John Weatherman
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

RE: Cognos

2002-07-18 Thread John Weatherman
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

RE: OT: Just a laff! "Gates gooses geese guano gunners"

2002-07-18 Thread John Weatherman
: [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

Cognos

2002-07-18 Thread John Weatherman
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

RE: UNDO

2002-07-17 Thread John Weatherman
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]

UNDO

2002-07-17 Thread John Weatherman
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

RE: Where is Oracle 9.2 init.ora?

2002-07-11 Thread John Weatherman
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

RE: Using a Sequence for a Default Value

2002-07-10 Thread John Weatherman
, 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

Using a Sequence for a Default Value

2002-07-10 Thread John Weatherman
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

RE: Oracle Applications Development Database Refresh

2002-07-09 Thread John Weatherman
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 --

RE: Remote execution of pl/sql

2002-06-25 Thread John Weatherman
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: > &

Remote execution of pl/sql

2002-06-25 Thread John Weatherman
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

The Right Manual

2002-06-20 Thread John Weatherman
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

RE: Replication question

2002-06-14 Thread John Weatherman
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

RE: Replication question

2002-06-14 Thread John Weatherman
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

RE: Replication question

2002-06-14 Thread John Weatherman
( 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]>

RE: Replication question

2002-06-14 Thread John Weatherman
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:

OEM Returns ORA-12154

2002-06-12 Thread John Weatherman
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

Error pushing deferred transactions

2002-06-12 Thread John Weatherman
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: (

EVENT="10235 trace name context forever, level 2"

2002-06-07 Thread John Weatherman
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

Setting Up EXTPROC

2002-06-03 Thread John Weatherman
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 -

RE: So, What is a 'Production DBA'?

2002-05-31 Thread John Weatherman
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

RE: ORA-2085

2002-05-21 Thread John Weatherman
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

ORA-2085

2002-05-21 Thread John Weatherman
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

ORA-03113: end-of-file on communication channel

2002-05-06 Thread John Weatherman
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

Constraints Lookup

2002-04-23 Thread John Weatherman
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

RE: Renaming files on Unix via PL/SQL

2002-04-19 Thread John Weatherman
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

RE: Upgrade 8.0.5 to 8.1.7.3

2002-04-17 Thread John Weatherman
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

Compatability Problem

2002-04-16 Thread John Weatherman
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 -

RE: Database shutdown

2002-04-16 Thread John Weatherman
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

RE: svrmgrl vs. sqlplus

2002-04-11 Thread John Weatherman
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

Replication Question

2002-04-10 Thread John Weatherman
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