Re: PL/SQL : how to divide column exactly at space ?

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

Re: OT: insulated coffee mug lid tab failure - tech support

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

Re: Alter tablespace add datafile

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

RE: Alter tablespace add datafile

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

Locally vs Dictionary-Managed Tablespaces - was archive query - revisited

2001-09-05 Thread grant . g . holyoake
Now that I have ascertained how the allocation and deallocation of extents in Oracle affects logging, (thanks Mohammad and Jay!) I would like to know the pro's and cons people have experienced when changing tablespaces to locally-managed rather than dictionary-managed (apart from the hassle of

RE: Alter tablespace add datafile

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

Re: OT: insulated coffee mug lid tab failure - tech support

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

RE: Alter tablespace add datafile

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

Re: Locally vs Dictionary-Managed Tablespaces - was archive

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

RE: Alter tablespace add datafile

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

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

2001-09-05 Thread Yosi Greenfield
Nope, not really nearby. Same state and all that, but not nearby. Heck, we barely visited the people on the farm up the road. But I'm sure the Albacore misses you! Ken Janusz wrote: Did you stop by Portsmouth and visit my old friend the USS Albacore (AGSS-569)? Ken Janusz, CPIM Database

Re: Alter tablespace add datafile

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

RE: Alter tablespace add datafile

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

RE: Alter tablespace add datafile

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

Re: OT: insulated coffee mug lid tab failure - tech support

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

Re: Locally vs Dictionary-Managed Tablespaces - was archive

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

DBMS_JOB

2001-09-05 Thread David Turner
I finally figured out how to kill the process that was scheduled in dba_jobs. You have to break the job first or else Oracle will restart the job trying to complete it. So I sat their killing processes over and over until I read up on DBMS_JOB. Here's more detail: -- Mark the job that called

Re: Alter tablespace add datafile

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

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

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

Re: OT: insulated coffee mug lid tab failure - tech support

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

RE: Locally vs Dictionary-Managed Tablespaces - was archive

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

PL/SQL : how to divide column exactly at space ? (fwd)

2001-09-05 Thread saya
Hi all, How to divide column varchar2(20) into two, and cut exactly at space, so thare are no words truncated ? eg : aaa b ccc .. will break into aaa bb and ccc not aaa and bbb c regards -- Please see the official ORACLE-L FAQ:

RE: File Upload and Download via IAS

2001-09-05 Thread MacGregor, Ian A.
I don't believe the question I asked is covered by the FAQ or at least I cannot find it. Ian MacGregor (X3528) -Original Message- Sent: Wednesday, September 05, 2001 7:11 PM To: Multiple recipients of list ORACLE-L -- Please see the official ORACLE-L FAQ: http://www.orafaq.com --

RE: Alter tablespace add datafile

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

Re: DBMS_JOB

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

RE: Alter tablespace add datafile

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

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

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

RE: Alter tablespace add datafile

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

[Fwd: please forward to your system administrator - stop the spam

2001-09-05 Thread Paul Drake
Hi. I don't expect anything to happen in response to this from the sender's account until noon tomorrow. But I did send a blanket request to the site and their ISP. This ought to get someone's attention. In the meantime, set up a filter in your mail client. Part-time vigilante, Paul Paul

RE: File Upload and Download via IAS

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

Re: Alter tablespace add datafile

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

RE: Locally vs Dictionary-Managed Tablespaces - was archive

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

Oracle Query Tuning

2001-09-05 Thread Makarand Kurkure
Hi All, I want to know what are the sources on Internet which gives me good knowledge about SQL query tuning in Oracle. Please let me know any books are available on it also. Makarand -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Makarand Kurkure INET:

Re: Locally vs Dictionary-Managed Tablespaces - was archive

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

Re: PL/SQL : how to divide column exactly at space ? (fwd)

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

RE: File Upload and Download via IAS

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

Re: OT: insulated coffee mug lid tab failure - tech support

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

RE: Locally vs Dictionary-Managed Tablespaces - was archive

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

Re: OT: insulated coffee mug lid tab failure - tech support

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

Re: [Fwd: please forward to your system administrator - stop

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

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

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

RE: Alter tablespace add datafile

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

RE: Alter tablespace add datafile

2001-09-05 Thread
is it just me, or is anybody else getting blank replies (exluding the sig) from Arich Henneman? -Original Message- [mailto:X] Sent: Thursday, 6 September 2001 2:37 PM To: X -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author:

Re: DBMS_JOB

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

Re: Locally vs Dictionary-Managed Tablespaces - was archive

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

Re: PL/SQL : how to divide column exactly at space ? (fwd)

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

Re: Oracle Query Tuning

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

<    1   2   3