Re: UNIX QUESTION.

2002-02-19 Thread James Manning
[Hamid Alavi] ANYBODY KNOW WHAT'S THE EQUIVALENT OF THIS COMMAND IN UNIX? host start cmd /c copy /u04/oradata/AMDEV/rbs01.dbf D:\oradata\fred\backup host cp /u04/oradata/AMDEV/rbs01.dbf /oradata/fred/backup -- James Manning [EMAIL PROTECTED] GPG Key fingerprint = B913 2FBD 14A9 CE18 B2B7

Re: Just got back from SQL*Server 2000 training...

2002-02-18 Thread James Manning
don't block readers? I had heard Progress was on that list, but never confirmed. -- James Manning [EMAIL PROTECTED] GPG Key fingerprint = B913 2FBD 14A9 CE18 B2B7 9C8E A0BF B026 EEBB F6E4 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James Manning INET: [EMAIL

Re: RedHat Linux 7.2 Oracle 9i Shutdown

2002-02-14 Thread James Manning
numbers (controlling order of execution) for startup and shutdown respectively. Much much easier, at least IMHO, than doing symlinks by hand. James -- James Manning [EMAIL PROTECTED] GPG Key fingerprint = B913 2FBD 14A9 CE18 B2B7 9C8E A0BF B026 EEBB F6E4 -- Please see the official ORACLE-L FAQ: http

Re: How to step over the STDIN, while input redirection is not given at commandline

2002-02-14 Thread James Manning
a jmm@bp6:/tmp cat b jmm@bp6:/tmp cat c jmm@bp6:/tmp perl -e 'shift; print ' a b c jmm@bp6:/tmp cat b c | perl -e 'shift; print ' a James -- James Manning [EMAIL PROTECTED] GPG Key fingerprint = B913 2FBD 14A9 CE18 B2B7 9C8E A0BF B026 EEBB F6E4 -- Please see

Re: Create Database ... really dumb question

2002-02-14 Thread James Manning
[SARKAR, Samir] Check Metalink Note : 56016.999 Is there any way to get access to metalink for those of us not fortunate enough to have an Oracle support contract? (Startup life is fun!) -- James Manning [EMAIL PROTECTED] GPG Key fingerprint = B913 2FBD 14A9 CE18 B2B7 9C8E A0BF B026 EEBB

Re: ora -01122

2002-02-14 Thread James Manning
[Hamid Alavi] Database shutdown by itseld(don't know why) then I try to started get the error for datafile. Anything helpful in the alert log? Like, I/O errors during archiving so once all online redo logs needed archiving, the instance stopped accepting transactions? Just a guess -- James

Re: Preperation for OCP 9i

2002-02-13 Thread James Howerton
') 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: James Howerton INET

Re: high tkprof parse counts == real # of hard parses?

2002-02-12 Thread James Manning
that would be more helpful, I still have the raw trace around and would be happy to re-run it. Thanks! -- James Manning [EMAIL PROTECTED] GPG Key fingerprint = B913 2FBD 14A9 CE18 B2B7 9C8E A0BF B026 EEBB F6E4 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James Manning

Re: Moving Oracle Binaries from HP to SUN

2002-02-12 Thread James Manning
. I'd give the probability rating around 1% at best :) -- James Manning [EMAIL PROTECTED] GPG Key fingerprint = B913 2FBD 14A9 CE18 B2B7 9C8E A0BF B026 EEBB F6E4 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James Manning INET: [EMAIL PROTECTED] Fat City Network

How to find out Oracle patch applied

2002-02-12 Thread Xing, James
Hi DBAs, I want to find out what Oracle patch installed. Someone just installed Oracle817 binary on our server but no 817 instance setup yet, so can't query v$version. Thanks James -- Please see the official ORACLE-L FAQ: http://www.orafaq.com

RE: How to find out Oracle patch applied

2002-02-12 Thread Xing, James
Is there any Oracle file I can use Unix command strings to search for version/patch info? I don't have x-window session. James -Original Message- From: Magaliff, Bill [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, February 12, 2002 3:02 PM To: Multiple recipients of list ORACLE-L

Re: high tkprof parse counts == real # of hard parses?

2002-02-11 Thread James Manning
an insert trigger on the table that sets the PK field to a seq.nextval? Thanks for your help, Bjørn! James -- James Manning [EMAIL PROTECTED] GPG Key fingerprint = B913 2FBD 14A9 CE18 B2B7 9C8E A0BF B026 EEBB F6E4 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James

RE: Where does a DBA go from here?

2002-02-08 Thread James McCann
(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: James McCann INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX

RE: Where does a DBA go from here?

2002-02-08 Thread James McCann
the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James McCann INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Re: high tkprof parse counts == real # of hard parses?

2002-02-08 Thread James Manning
. But then, why isn't tkprof more clear on soft vs. hard parses? :( In any case, it looks like it's not the problem I thought it was. -- James Manning [EMAIL PROTECTED] GPG Key fingerprint = B913 2FBD 14A9 CE18 B2B7 9C8E A0BF B026 EEBB F6E4 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com

Re: high tkprof parse counts == real # of hard parses?

2002-02-08 Thread James Manning
count (total) 69494630 parse time cpu 1082154 parse time elapsed 1420764 That looks *much* better to me! James -- James Manning [EMAIL PROTECTED] GPG Key fingerprint = B913 2FBD 14A9 CE18 B2B7 9C8E A0BF B026 EEBB F6E4 -- Please see the official ORACLE-L FAQ: http

Re: FTP Exports

2002-02-08 Thread James Manning
of transferring large files, I'm all about using rsync whenever possible simply because you can just keep re-running the same command until it finally transfers. rsync's site has builds for most *nix's and google on rsync windows will lead to the various windows builds that are out there. HTH, James

Re: Remote Compromise in Oracle

2002-02-07 Thread James Howerton
://www.orafaq.com -- Author: James Howerton 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

high tkprof parse counts == real # of hard parses?

2002-02-07 Thread James Manning
:) Thanks! James -- James Manning [EMAIL PROTECTED] GPG Key fingerprint = B913 2FBD 14A9 CE18 B2B7 9C8E A0BF B026 EEBB F6E4 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James Manning INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538

9iAS and iPlanet LDAP

2002-02-05 Thread James Howerton
want to maintain several separate LDAP's unless there is no other way. Re-linking Apache with mod_auth_ldap is not supported??? 2. Is there a 9iAS listserv similar to this list? TIA ...JIM... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James Howerton INET: [EMAIL

Statspack question

2002-01-31 Thread James McCann
it work it out just between the 2 snaps you tell it to? i.e. the delta. Cheers, Jim -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James McCann INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

RE: Statspack question

2002-01-31 Thread James McCann
Thanks John, that's what I thought, but I just wasn't sure if it applied for the ratio's as well, Jim -Original Message- Sent: 31 January 2002 12:55 To: Multiple recipients of list ORACLE-L HI James, This will tell you these percentages during the time you are reporting on. John

RE: OPS$ / default accounts

2002-01-31 Thread James McCann
see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James McCann INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: OPS$ / default accounts

2002-01-31 Thread James McCann
of list ORACLE-L James McCann wrote: Speaking of default accounts with default passwords, here is my list that I check for. Anyone want to compare notes :) i.e. have I missed any? Thanks, Jim perfstat/perfstat TRACESVR ??? is only used with 7.x Databases REPADMIN ??? CTXSYS/CTXSYS

RE: OPS$ / default accounts

2002-01-31 Thread James McCann
[-sysdba || -sysoper] }; exit $exitval; } James McCann [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01/31/02 08:42 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: OPS$ / default accounts Speaking

Re: INFORMIX 7.3 to ORACLE 8.1.7

2002-01-29 Thread James Howerton
FAQ: http://www.orafaq.com -- Author: James Howerton INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE

RE: Databases on Solaris: Online Forum Jan. 22-28

2002-01-25 Thread James McCann
send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James McCann INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet

Add mod_ldap to 9iAS Apache

2002-01-25 Thread James Howerton
... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James Howerton INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: Standby Instance questions and HA

2002-01-18 Thread James McCann
Sun great sums of money. The Sun web site has more info on HA. Let me know if you need more info. Good luck! Barb -- From: James McCann[SMTP:[EMAIL PROTECTED]] Reply To: [EMAIL PROTECTED] Sent: Thursday, January 17, 2002 5:40 AM To: Multiple recipients

RE: Standby Instance questions and HA

2002-01-18 Thread James McCann
Oracle to run this crap, but you'll be paying Sun great sums of money. The Sun web site has more info on HA. Let me know if you need more info. Good luck! Barb -- From: James McCann[SMTP:[EMAIL PROTECTED]] Reply To: [EMAIL PROTECTED] Sent: Thursday, January 17, 2002

Standby Instance questions and HA

2002-01-17 Thread James McCann
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James McCann INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: Standby Instance questions and HA

2002-01-17 Thread James McCann
version (Standard/workgroup can be used), only runs on NT, and requires MicroSoft Cluster Services (MSCS) which is included in NT4.0 EE or W2K Advanced Server. As for Sun Solaris, I know nothing so will be of no help to you there. James McCann james@openet

RE: Standby Instance questions and HA

2002-01-17 Thread James McCann
the standby implemented. There's no additional cost from Oracle to run this crap, but you'll be paying Sun great sums of money. The Sun web site has more info on HA. Let me know if you need more info. Good luck! Barb -- From: James McCann[SMTP:[EMAIL PROTECTED]] Reply

RE: Virtual Private Databases

2002-01-15 Thread James McCann
As far as I know, it only comes with Enterprise or Personal, Jim -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of [EMAIL PROTECTED]Sent: 15 January 2002 13:55To: Multiple recipients of list ORACLE-LSubject: RE: Virtual Private

RE: Any other OCP discount code ? S36 code can no longer be used

2002-01-14 Thread James McCann
Bee -Original Message- From: James McCann [mailto:[EMAIL PROTECTED]] Sent: Friday, January 11, 2002 6:25 PM To: Multiple recipients of list ORACLE-L Subject:RE: Any other OCP discount code ? S36

RE: Database Comparison

2002-01-10 Thread HAWKINS, JAMES W [IT/1000]
may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: HAWKINS, JAMES W [IT/1000] INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

ORA-600 Parser...

2002-01-09 Thread HAWKINS, JAMES W [IT/1000]
] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: HAWKINS, JAMES W [IT/1000] INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: Database Comparison

2002-01-09 Thread HAWKINS, JAMES W [IT/1000]
, JAMES W [IT/1000] 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: How to Trace PL/SQL

2002-01-08 Thread James McCann
). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James McCann INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: Reversing Unused Setting on a Column

2002-01-08 Thread James McCann
command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James McCann INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing

RE: EMC Not Releasing Space

2002-01-08 Thread HAWKINS, JAMES W [IT/1000]
for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: HAWKINS, JAMES W [IT/1000] INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access

RE: Best practices for data warehousing in 9i

2002-01-08 Thread HAWKINS, JAMES W [IT/1000]
: http://www.orafaq.com -- Author: HAWKINS, JAMES W [IT/1000] INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

utl_http - help!

2001-12-20 Thread James
=%5Eixic'); end; Peace, James Reddi _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James INET: [EMAIL PROTECTED] Fat City Network

Synonyms causing a strange problem-Solved.

2001-12-19 Thread James Damiano
://www.orafaq.com -- Author: James Damiano 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

utl_http package

2001-12-19 Thread James
=01e=31f=01g=ds=ADCTy=0z=%5Eixic'); end; Peace, James Reddi _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James INET: [EMAIL

Re: Palladium Consulting

2001-12-19 Thread James Howerton
). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James Howerton INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

[no subject]

2001-12-18 Thread James
=31f=01g=ds=ADCTy=0z=%5Eixic'); end; Peace, James Reddi _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James INET: [EMAIL PROTECTED

RE: relink SGI 64 bit Oracle 8.1.7 Veritas Netbackup

2001-12-14 Thread James Howerton
Thanks Ron, The SGI install only has $ORACLE_HOME/lib32/ $ORACLE_HOME/lib/ dir's. ...JIM... [EMAIL PROTECTED] 12/13/01 7:40:17 PM James, You need to have the library for the 64 bit of Veritas... on AIX, it is done as follows: ln -s /usr/openwin/netbackup/bin/libobk.a $ORACLE_HOME/lib64

Many small or few large extents for RBS Ora-1555

2001-12-14 Thread James Damiano
great insights... Jim Damiano -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James Damiano INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Re: Many small or few large extents for RBS Ora-1555

2001-12-14 Thread James Damiano
address where I can read this paper? thanks Gene -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James Damiano INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access

relink SGI 64 bit Oracle 8.1.7 Veritas Netbackup

2001-12-13 Thread James Howerton
is no help as usual. TIA ...JIM... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James Howerton INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Re: relink SGI 64 bit Oracle 8.1.7 Veritas Netbackup

2001-12-13 Thread James Howerton
James, Have you tried Veritas's web site? It's at http://support.veritas.com/menu_ddProduct_NETBACKUP.htm Click on advanced search under Knowledge Base in the middle right part of the page. Search on the error message that you get. Try all the error numbers by themselves. You should get

RE: SQL to find duplicate rows...

2001-12-07 Thread HAWKINS, JAMES W [IT/1000]
. Austin, Texas www.iNetProfit.com [EMAIL PROTECTED] (512)327-9068 -Original Message- JAMES W [IT/1000] Sent: Thursday, December 06, 2001 2:26 PM To: Multiple recipients of list ORACLE-L Hello all, I know this has come across many times now, and I thought I had it saved somewhere - you

SQL to find duplicate rows...

2001-12-06 Thread HAWKINS, JAMES W [IT/1000]
the official ORACLE-L FAQ: http://www.orafaq.com -- Author: HAWKINS, JAMES W [IT/1000] INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: BMC Patrol DBXray / CA Unicenter

2001-12-05 Thread HAWKINS, JAMES W [IT/1000]
://www.orafaq.com -- Author: HAWKINS, JAMES W [IT/1000] 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

RE: BMC Patrol DBXray / CA Unicenter

2001-12-05 Thread HAWKINS, JAMES W [IT/1000]
://www.orafaq.com -- Author: HAWKINS, JAMES W [IT/1000] 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

RE: rman restore arclogs

2001-12-04 Thread HAWKINS, JAMES W [IT/1000]
ergh Blvd. St. Louis, Missouri 63167 Work (314) 694-4417 Cellular (314) 724-9664 Pager (314) 294-9797 [EMAIL PROTECTED] -Original Message-From: Koivu, Lisa [mailto:[EMAIL PROTECTED]]Sent: Monday, December 03, 2001 2:46 PMTo: '[EMAIL PROTECTED]'; HAWKINS, JAMES W [IT/1000]Subject

RE: BMC Patrol DBXray / CA Unicenter

2001-12-04 Thread HAWKINS, JAMES W [IT/1000]
Title: RE: BMC Patrol DBXray / CA Unicenter Lisa, We are now concluding a very lengthy selection process, and it looks like we will go with BMC Patrol/DB X-Ray. We refuse to do business with CA, and had a very bad experience with Quest I/Watch. None of these are easy to roll-out enterprise

RE: rman restore arclogs

2001-12-03 Thread HAWKINS, JAMES W [IT/1000]
Title: rman restore & arclogs I just wanted to throw something else out there - it may have already come up though. We backup the archivelogs first without deleting them, and then immediately backup another set with the "delete" specified. Obviously, this is because anything can happen to

RE: Oracle 9i and OEM

2001-11-21 Thread HAWKINS, JAMES W [IT/1000]
the official ORACLE-L FAQ: http://www.orafaq.com -- Author: HAWKINS, JAMES W [IT/1000] INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: Disk to Disk backups and RMAN

2001-11-19 Thread HAWKINS, JAMES W [IT/1000]
FAQ: http://www.orafaq.com -- Author: HAWKINS, JAMES W [IT/1000] INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: Disk to Disk backups and RMAN

2001-11-16 Thread HAWKINS, JAMES W [IT/1000]
(like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: HAWKINS, JAMES W [IT/1000] INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: Operating Systems

2001-11-14 Thread HAWKINS, JAMES W [IT/1000]
ORACLE-L FAQ: http://www.orafaq.com -- Author: HAWKINS, JAMES W [IT/1000] INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: Oracle Archiving insanely

2001-11-04 Thread James Morle
obvious. James -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of K Gopalakrishnan Sent: 04 November 2001 14:35 To: Multiple recipients of list ORACLE-L Subject: RE: Oracle Archiving insanely By any chance HOTBACKUP is turned on? Best Regards, K

Hosing of Data Dict by catalog.sql

2001-10-30 Thread James Damiano
, drop the users, then import the same kind of export I mentioned in #2. Any thoughts or opinions would be greatly appreciated. Thanks in advance. Jim Damiano -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James Damiano INET: [EMAIL PROTECTED

RE: Internal error code problem

2001-10-30 Thread James Morle
. James -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Ramasubramanian, Shankar (Cognizant) Sent: 30 October 2001 12:46 To: Multiple recipients of list ORACLE-L Subject: Internal error code problem Hi friends, I am running a package in my

Re: event= to capture deadlock debug info

2001-10-22 Thread James Howerton
what may have caused the situation. I guess I'll have to wait until it happens again and get the users to wait until I can gather more info befor I fix it. ...JIM... [EMAIL PROTECTED] 10/19/01 1:02:35 PM Hi James, setting an event at init/session level would basically dump the error state

event= to capture deadlock debug info

2001-10-19 Thread James Howerton
ORACLE-L FAQ: http://www.orafaq.com -- Author: James Howerton INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

CLOB trigger problem

2001-09-18 Thread Campbell, James
. if needed. Cheers, James Campbell [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Campbell, James INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access

Need script to generate DDL for snapshot/materialized view recrea

2001-09-13 Thread HAWKINS, JAMES W [IT/1000]
for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: HAWKINS, JAMES W [IT/1000] INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing

RE: Ftp from Oracle

2001-09-12 Thread James Turner
events. HTH, James Turner -Original Message- [EMAIL PROTECTED] Sent: Tuesday, September 11, 2001 8:10 AM To: Multiple recipients of list ORACLE-L Hallo, Is it possible to do ftp commands directly from PL/SQL procedur? Including logon to the ftp server.? Give me an example please

CLOB help

2001-09-05 Thread James Howerton
figured it out. The friendly manual is helpfull as usual, IOUG diddn't have anything we could use. We have data being loaded in a 8.1.6.2.1 database via ODBC from a hub(interface) engine. TIA ...JIM... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James Howerton INET

RE: OT: Duhvelopers and DB-ehs?

2001-08-31 Thread HAWKINS, JAMES W [IT/1000]
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: HAWKINS, JAMES W [IT/1000] INET: [EMAIL PROTECTED] Fat City Network Services

RE: OT: football fan-hood

2001-08-30 Thread HAWKINS, JAMES W [IT/1000]
Title: RE: OT: football fan-hood Lisa, I, for one, hold you in the highest esteem and wish you would talk some sense into my wife. My typical Sunday during Rams home games goes something like this: 6AM - Coffee, breakfast, read the Sports section for today's matchup. 8:30AM - Meet at my

RE: OT: football fan-hood

2001-08-30 Thread HAWKINS, JAMES W [IT/1000]
can't see the issue here. sounds like your wife needs a hobby. -Original Message-From: HAWKINS, JAMES W [IT/1000] [mailto:[EMAIL PROTECTED]]Sent: Thursday, August 30, 2001 11:01 AMTo: Multiple recipients of list ORACLE-LSubject: RE: OT: football fan-hood Lisa

O8i install solution to ORA-3113 problems on RH 7

2001-08-30 Thread James Damiano
, including the assitants, will work fine after this and will work with RedHat 7.0 and kernel 2.2.16 kernel, as well as the 2.4.0 and 2.4.1-pre11 kernels. Jim Damiano -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James Damiano INET: [EMAIL PROTECTED] Fat City Network

RE: OT: football fan-hood

2001-08-30 Thread HAWKINS, JAMES W [IT/1000]
. St. Louis, Missouri 63167 (314) 694-4417 [EMAIL PROTECTED] -Original Message- Sent: Thursday, August 30, 2001 12:27 PM To: Multiple recipients of list ORACLE-L I think it's that pass out part she's upset with :) From: HAWKINS, JAMES W [IT/1000] [EMAIL PROTECTED] Reply-To: [EMAIL

RE: OT: football fan-hood

2001-08-30 Thread HAWKINS, JAMES W [IT/1000]
(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: HAWKINS, JAMES W [IT/1000] INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538

RE: OT: football fan-hood

2001-08-30 Thread HAWKINS, JAMES W [IT/1000]
). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: HAWKINS, JAMES W [IT/1000] INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

!! *Very* important Oracle-L message !!

2001-08-29 Thread James Howerton
Jared, I'm in for $12. Jim Howerton Senior Oracle DBA University of Alabama at Birmingham Health System Information Services e: [EMAIL PROTECTED] v: 205-934-9111 f: 205-934-0632 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James Howerton INET: [EMAIL

RE: Stored procedures that return multiple rows

2001-08-23 Thread James Turner
a DBA, you have a lot of leeway to change things around on the back end w/o breaking the app. One drawback to the approach is that it requires more up-front planning on the app developers to identify the database calls. James Turner DBA Unplugged Games -Original Message-From: [EMAIL

Re: avoid duplicate sql

2001-08-08 Thread james ellis
Can you change from a sql statement to an anonymous pl/sql block? You can trap for dup val on index or check for the records existence prior to trying to insert the new record. james --- Tatireddy, Shrinivas (MED, Keane) [EMAIL PROTECTED] wrote: Hi lists i need help in writing a sql query

dba_data_files sizes disagree with Op. Sys?

2001-08-08 Thread James Damiano
there is this mismatch - or am I missing something obvious? Another bit of information, all the datafiles are AUTOEXTENSIBLE. Thanks very much, Jim Damiano -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James Damiano INET: [EMAIL PROTECTED] Fat City Network Services

RE: how to stop a killed session bothering me ?

2001-08-07 Thread HAWKINS, JAMES W [IT/1000]
for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: HAWKINS, JAMES W [IT/1000] INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access

RE: computer history stories - Now: Age discrimination?

2001-08-06 Thread HAWKINS, JAMES W [IT/1000]
: http://www.orafaq.com -- Author: HAWKINS, JAMES W [IT/1000] INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: OT -- suggestions to ensure nerdiness in potential IT

2001-08-04 Thread HAWKINS, JAMES W [IT/1000]
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: HAWKINS, JAMES W [IT/1000] INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858

RE: RAID 5/Oracle

2001-08-01 Thread James Howerton
also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James Howerton INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet

RE: (Fwd) Oracle8i Database Administration Boot camp [small/Sacr

2001-07-31 Thread HAWKINS, JAMES W [IT/1000]
: HAWKINS, JAMES W [IT/1000] 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

Re: Metablink .... down again?

2001-07-23 Thread James Howerton
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: James Howerton INET: [EMAIL PROTECTED

Client Connection-SQLNET and?/or? ODBC.

2001-07-10 Thread James Damiano
that actually makes the connection to the SQLNET (Net 8) running on the server: - ODBC itselfor - ODBC through SQLNET? Thanks very much in advance! Jim Damiano Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James Damiano INET: [EMAIL

Re: temp problem when rebuilding Index

2001-07-02 Thread james ellis
://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: james ellis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Oracle 9i orderabls on Metalink

2001-06-13 Thread James Howerton
All, Oracle9i EE show's up as orderable on Metalink this morining for Solaris, OS390, HPUX. ...JIM... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James Howerton INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San

RE: iAS installation update

2001-06-07 Thread James Howerton
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: James Howerton INET: [EMAIL PROTECTED] Fat City

Re: iAS installation update

2001-06-05 Thread James Howerton
the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James Howerton INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: RE SQLServer archivingq

2001-06-03 Thread James Xing
for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James Xing INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: RE SQLServer archivingq

2001-06-03 Thread James Xing
for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James Xing INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: OT: Archiving not possible with SQL Server?

2001-05-30 Thread James Xing
is to setup thresholdaction, it will be fired up automically when the space reach certain percentage defined. James And thus you discover the inane mechanism that SQL Server inherited from Sybase, by which both try to do concurrency. Guess what happens when a long running transaction marks the log

RE: OT: Archiving not possible with SQL Server?

2001-05-30 Thread James Xing
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: James Xing INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858

RE: Maximo

2001-05-24 Thread James Xing
. James -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Bowes, ChrisSent: Wednesday, May 23, 2001 8:28 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Maximo ON all the maximo installations I have done, the biggest problems have been

OT: Winnie quote

2001-05-24 Thread Campbell, James
Walt @#$$^^@! Disney. The REAL Pooh is much wiser than that cheap greetings-card stuff! Regards, James Campbell (Oracle DBA when all the real ones have left; Duhveloper; Pooh fan of 45 years standing) It's Friday in Australia... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com

<    1   2   3   >