RE: Big Dump file (12gb) from nt to unix and from 7.3.4 to 8.1.6

2001-02-25 Thread Amar Kumar Padhi

remove the table giving the error from the tables parameter and try. This
table may not have been exported in the first place.

Amar Kumar Padhi
Software Consultant


-Original Message-
Sent: Monday, February 26, 2001 10:25 AM
To: Multiple recipients of list ORACLE-L


Hi all,

I am facing some problems while trying to import the huge file (12gb) from 
nt db to unix db.

The error I'm receiving is like this:

IMP-9: abnormal end of export file
IMP-00033: Warning: Table "XXX_" not found in export file...

I am using the pipe but still it fails. Here is the syntax for import

imp SYSTEM/XX FROMUSER=XXX TOUSER=XXX BUFFER=15000 IGNORE=Y TABLES=XXX 
FILE=./XXX LOG=./imp.log

And the table is on that file...

Br and thanks,

Hessu
_
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Heikki Jantunen
  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, 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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Amar Kumar Padhi
  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, 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).



Re: Mailing frm Oracle

2001-02-25 Thread Paul Drake

John,

Thanks for the info.

Paul

John Dailey wrote:
> 
> Yes, and dbms_ijob will allow you to manage jobs that are not owned by you.
> I had to do the same thing as Regs... those jobs can be very persistent
> little guys.  Break them first, then kill the session ID running the job.
> This will stop them.
> 
> John Dailey
> Consultant
> Concept Solutions, LLC
> 
> - Original Message -
> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> Sent: Sunday, February 25, 2001 2:10 AM
> 
> > I also had same problem before, but dbms_job.broken procedure takes care
> of
> > it. I first broke the job and then removed it.
> >
> > It works.
> >
> > Regs,
> >
> > - Original Message -
> > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> > Sent: Friday, February 23, 2001 5:11 AM
> >
> >
> > > one caution:
> > >
> > > If you're using Oracle 8.1.x on NT (NT4 - W2K)
> > > you will have some serious issues with killing dba_jobs.
> > > okay - its very easy to kill a dbms_job.
> > > shutdown abort takes care of it - no problem.
> > > I had a dbms_job emptying a mail queue that opened 3976 connections to a
> > > Sendmail server last night - it stopped at port 4999 (testing code). The
> > > mail server didn't even blink.
> > >
> > > I could not kill a dbms_job - as it deferred the kill session.
> > > 7.3 use to have a parameter that allowed you to not keep the connection
> > > alive.
> > > That parameter isn't available in 8.1.6.
> > >
> > > So once again, less ways to get at the OS - less ways to maintain
> > processes.
> > > If you actually have users that don't want to have their instance
> > shutdown,
> > > better test that code very well ...
> > >
> > > Paul
> > >
> > >
> > >  Original Message 
> > > Date: Thu, 22 Feb 2001 14:40:27 -0800
> > > Reply-To: [EMAIL PROTECTED]
> > > Organization: Fat City Network Services, San Diego, California
> > > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> > >
> > > On 8.1.6+ you can use UTL_SMTP.
> > > Vadim Gorbounov
> > > Oracle DBA
> > >
> > > -Original Message-
> > > Sent: Thursday, February 22, 2001 3:11 PM
> > > To: Multiple recipients of list ORACLE-L
> > >
> > >
> > > Hi Everybody,
> > >
> > > I wanted to forward a mail to a particular Id thru an Oracle Procedure ,
> > > can anybody tell me whether I can do that thru an Oralce Procedure
> > > if so pls inform how to do the same.
> > >
> > > I dont want to mail to a Unix Login id , I want to mail to a mail server
> > >
> > > For e-g  [EMAIL PROTECTED]
> > >
> > >
> > > Thanks In Advance,
> > >
> > > Shankar Swamy.
> > >
> > >
> > >
> > >
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > --
> > > Author: Shankar Shanmugaswamy
> > >   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, 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).
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > --
> > > Author: Vadim Gorbounov
> > >   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, 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).
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > --
> > > Author: Paul Drake
> > >   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, 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).
> >
> >
> > _
> > Do You Yahoo!?
> > Get your free @yahoo.com address at http://mail.yah

Re: Mailing from Oracle

2001-02-25 Thread Paul Drake

Anjali,

thanks much for the info.
I'm looking forward to 'breaking' some jobs tomorrow.

Paul


Anjali R wrote:
> 
> I also had same problem before, but dbms_job.broken procedure takes care of
> it. I first broke the job and then removed it.
> 
> It works.
> 
> Regs,
> 
> - Original Message -
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Friday, February 23, 2001 5:11 AM
> 
> > one caution:
> >
> > If you're using Oracle 8.1.x on NT (NT4 - W2K)
> > you will have some serious issues with killing dba_jobs.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Paul Drake
  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, 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).



Big Dump file (12gb) from nt to unix and from 7.3.4 to 8.1.6

2001-02-25 Thread Heikki Jantunen

Hi all,

I am facing some problems while trying to import the huge file (12gb) from 
nt db to unix db.

The error I'm receiving is like this:

IMP-9: abnormal end of export file
IMP-00033: Warning: Table "XXX_" not found in export file...

I am using the pipe but still it fails. Here is the syntax for import

imp SYSTEM/XX FROMUSER=XXX TOUSER=XXX BUFFER=15000 IGNORE=Y TABLES=XXX 
FILE=./XXX LOG=./imp.log

And the table is on that file...

Br and thanks,

Hessu
_
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Heikki Jantunen
  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, 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).



Re: Anyone using CA products?

2001-02-25 Thread Thomas A. Lowery

If anyone from CA attempts to sell you what was called Cool:* (Cool:Gen,
Biz... not sure of the new names, was Sterling product) run, run away 
quickly.  It's a sure way to bring your development to a halt, and
send good dba's looking for employement else where.


On Fri, Feb 23, 2001 at 02:05:41PM -0800, [EMAIL PROTECTED] wrote:
> Ron,
> 
> Common on now, this is suppose to be at least a polite list.  There was no
> call for the use of foul language.  OH, sorry you don't work over here, CA is a
> four letter work here used only in EXTREME circumstances like when the fire dept
> accidentally sets off the fire suppression system in the computer room on a
> Friday late afternoon.
> 
> Reply Separator
> Author: "Smith; Ron L." <[EMAIL PROTECTED]>
> Date:   2/23/2001 1:00 PM
> 
> I have been trying to get upgrades from Computer Associates for about two
> months.  Does anyone use any of Computer Associates products?  What has been
> your experience?

-- 
Thomas A. Lowery[EMAIL PROTECTED]
http://tlowery.hypermart.net

_
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: Thomas A. Lowery
  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, 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).



RE: A basic forms question

2001-02-25 Thread Nguyen, Long

Thanks for teh info.

Regards
Long

-Original Message-
Sent: Wednesday, 21 February 2001 11:46 AM
To: Multiple recipients of list ORACLE-L


You'll get those messages when the calling form's FMX was created with a
newer version of Oracle Forms than the called form's FMX.  Maybe the calling
form was converted to Forms 6 and the called form is still in Forms 5
format.  Just re-compile the older FMB using Forms 6 (or whatever your most
current version is) and you should be able to run the form.

> -Original Message-
> From: Nguyen, Long [mailto:[EMAIL PROTECTED]]
> Sent: Monday, February 19, 2001 10:00 PM
> To: Multiple recipients of list ORACLE-L
> Subject: A basic forms question
> 
> 
> Hi,
> 
> A user aksed me (a DBA) the question below about forms:
> 
> 
> << gives me this
> message: "form was created by an old version of form builder" 
> or "cannot
> open form".  Do you know what this mean? I looked at the fmb files and
> appears to be dated the 9/2/00 when the fmx files are dated 
> the 9/6/00.  Is
> there a way to fix this?  It's the same for the other computers in our
> office but somehow you can open the forms without any hiccups.  
> 
> Also, Is it possible to import the structure of Oracle forms 
> to Access or
> you have to build them from scratch in Access.  So far, we've 
> only been able
> to import the data from Oracle to Access only. >>>
> 
> 
> I never use forms so do not know the answer. It seems that 
> the user was
> using a newer version of forms to open an a form created in 
> an old version.
> For Forms do you need to upgrade old forms when you upgrade the forms
> software? Also pls answer the Access question if you can.
> 
> Much appreciated. Many thanks.
> 
> Long
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Nguyen, Long
>   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, 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).
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  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, 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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Nguyen, Long
  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, 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).



RE: Oracle 8i On solaris

2001-02-25 Thread Nguyen, Long

I found that the 'oinstall' group causes confusion in term of Unix file
permissions. It is still not clear to me what's the advantages of having the
'oinstall' and whether it is a 'must'. 

Long

  

-Original Message-
Sent: Saturday, 24 February 2001 10:11 AM
To: Multiple recipients of list ORACLE-L


Follow the installation guide VERY CAREFULLY.  Most people fail to install
Oracle on Unix because they don't read the instructions.  You must modify
kernal parameters and do other Unix admin steps prior to installation.

One thing to ignore (at least in my opinion) -- the instruction to create an
"oinstall" user.  I've found this causes more trouble than it's worth when
it comes to patching.  Just use the "oracle" user in the "dba" group.

Go to technet.oracle.com for the installation guide.

Regards,

Diana

-Original Message-
Sent: Friday, February 23, 2001 11:06 AM
To: Multiple recipients of list ORACLE-L


Hi everyone:

I am about to install Oracle 8i Enterprise on Sun Solaris version 10. Any
Practical documentation or site which could help me on installing and
configuring this system will be appreciated. I was away from Unix for a
while. I have already checked the Oracle.com.
I appreciate your help in advance.
Majid
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Majid Kazemi
  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, 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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Diana Duncan
  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, 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).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Nguyen, Long
  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, 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).



RE: Rolling Upgrade of Oracle on a 24*7 implementation

2001-02-25 Thread Steve Adams

Hi Murali,

There was a thread on this on Ixora Answers in January ...
http://www.ixora.com.au/q+a/0101/06105002.htm

@   Regards,
@   Steve Adams
@   http://www.ixora.com.au/
@   http://www.christianity.net.au/


-Original Message-
Sent: Friday, 23 February 2001 4:41
To: Multiple recipients of list ORACLE-L




Any body have ideas on how a Oracle Upgrade is done in a 24*7 installation 
for a very large database specifically using OPS.

TIA

Murali

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Steve Adams
  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, 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).



Re: Tuning, RAID5, and fragmentation

2001-02-25 Thread Dave Weber

dana mn wrote:

> Presuming a DBA is forced to use RAID5, what elements of tuning become
> irrelevant? (in the sense that if you're stuck with RAID5, warts and
> all, then trying to tune X, Y, and Z would be a waste of time /
> ineffective).
>
> Load balancing files would be one thing.. no way to put indexes and
> tables on different disks (ditto redo log file members, etc) with one
> massive RAID5 volume.
>
> What about fragmentation and coalescing? Are these still a concern for
> tablespaces located on RAID5 volumes?
>
> Has anyone written an article about Oracle and "living with RAID5"? I'm
> finding that a customer has several Oracle databases on systems with
> nothing else but RAID5 storage for everything.
>
> Thanks very much.
>
>  - Dana
>
> __
> Do You Yahoo!?
> Get email at your own domain with Yahoo! Mail.
> http://personal.mail.yahoo.com/
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: dana mn
>   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, 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).

Personally, I like the fail safe that RAID5 provides, however, it is nice
if asked, to have a mixed RAID, i.e., 5 and 10.  10 for indexs.

Fragmentation is generally more a function of segment extensions, that is,
the more you have to extend the more likely you will fragment. If you can,
plan your tablespaces so table with similar growth expectations are placed
together. Ideally, the initial and next extensions should be identical.
Avoid setting pctincrease to anything but zero to keep extents the same
within a table space. Non contiguous extents will occur, however the hope
is the extent space will be contiguous.  Set the tablespace default
settings appropriate for the tables they contain. Coalesce tablespaces
manually rather than configuring SMON to do it, as that process requires
pctincrease to be greater than zero.

Tablespace fragmentation may not be perceptable, however, segment
fragmentation can be depending on the activity of the table. I personally
like to set minextents equal to the number of datafiles I have, and I have
note less scattering of free space blocks. I can only assume then that
contiguous space is being allocated.  8x offering partioned indexes and
tables helps as well, and depending on the availability requirements of
the instance partitioned tables may be exported and imported to really
clean up an area if there was a miss on the settings for the inital
sizing.

I am assuming you have a number of RAID volumes and can apply archive and
redo with tables that are not as active as others, which will help further
distribute I/0 over the volumes.

I like RAID5 since it has saved my neck on more than on occasion, however,
RAID 10 (1 & 0) is very nice if you need the speed for indexes and can
afford to loose and reconstruct an index if necessary.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Dave Weber
  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, 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).



Tuning, RAID5, and fragmentation

2001-02-25 Thread dana mn


Presuming a DBA is forced to use RAID5, what elements of tuning become
irrelevant? (in the sense that if you're stuck with RAID5, warts and
all, then trying to tune X, Y, and Z would be a waste of time /
ineffective).

Load balancing files would be one thing.. no way to put indexes and
tables on different disks (ditto redo log file members, etc) with one
massive RAID5 volume.

What about fragmentation and coalescing? Are these still a concern for
tablespaces located on RAID5 volumes?

Has anyone written an article about Oracle and "living with RAID5"? I'm
finding that a customer has several Oracle databases on systems with
nothing else but RAID5 storage for everything.


Thanks very much.

 - Dana



__
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail. 
http://personal.mail.yahoo.com/
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: dana mn
  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, 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).



Re: RE: Mailing frm Oracle

2001-02-25 Thread John Dailey

Yes, and dbms_ijob will allow you to manage jobs that are not owned by you.
I had to do the same thing as Regs... those jobs can be very persistent
little guys.  Break them first, then kill the session ID running the job.
This will stop them.

John Dailey
Consultant
Concept Solutions, LLC

- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Sunday, February 25, 2001 2:10 AM


> I also had same problem before, but dbms_job.broken procedure takes care
of
> it. I first broke the job and then removed it.
>
> It works.
>
> Regs,
>
> - Original Message -
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Friday, February 23, 2001 5:11 AM
>
>
> > one caution:
> >
> > If you're using Oracle 8.1.x on NT (NT4 - W2K)
> > you will have some serious issues with killing dba_jobs.
> > okay - its very easy to kill a dbms_job.
> > shutdown abort takes care of it - no problem.
> > I had a dbms_job emptying a mail queue that opened 3976 connections to a
> > Sendmail server last night - it stopped at port 4999 (testing code). The
> > mail server didn't even blink.
> >
> > I could not kill a dbms_job - as it deferred the kill session.
> > 7.3 use to have a parameter that allowed you to not keep the connection
> > alive.
> > That parameter isn't available in 8.1.6.
> >
> > So once again, less ways to get at the OS - less ways to maintain
> processes.
> > If you actually have users that don't want to have their instance
> shutdown,
> > better test that code very well ...
> >
> > Paul
> >
> >
> >  Original Message 
> > Date: Thu, 22 Feb 2001 14:40:27 -0800
> > Reply-To: [EMAIL PROTECTED]
> > Organization: Fat City Network Services, San Diego, California
> > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
> >
> > On 8.1.6+ you can use UTL_SMTP.
> > Vadim Gorbounov
> > Oracle DBA
> >
> > -Original Message-
> > Sent: Thursday, February 22, 2001 3:11 PM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > Hi Everybody,
> >
> > I wanted to forward a mail to a particular Id thru an Oracle Procedure ,
> > can anybody tell me whether I can do that thru an Oralce Procedure
> > if so pls inform how to do the same.
> >
> > I dont want to mail to a Unix Login id , I want to mail to a mail server
> >
> > For e-g  [EMAIL PROTECTED]
> >
> >
> > Thanks In Advance,
> >
> > Shankar Swamy.
> >
> >
> >
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Shankar Shanmugaswamy
> >   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, 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).
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Vadim Gorbounov
> >   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, 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).
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Paul Drake
> >   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, 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).
>
>
> _
> 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: Anjali R
>   INET: [EMAIL PROTECTED]
>
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
> San Diego, California-- Public Internet access / Mailing Lists
> -