Re: Oracle 9.2 Stability Feedback Requested

2002-08-21 Thread Don Granaman

All the bugs?  Possible?  Perhaps...   Reality?  Nope.

The crippling bugs with SMU appear (at first glance) to be fixed in 9.2, but
there is no shortage of other bugs.  The first one I found was with many
queries against the data dictionary being 70-180 times slower!  I'm running
9.2.0.1 on Linux - exclusive and RAC - but not yet production.  On the
9.2.0.1 RAC nodes, I'm getting tons of trace files with CMInit warnings, but
support said "Don't worry.  Be happy.  Its OK"  Searching for patches for
9.2.0.1 on Linux, I get 22 hits.  Most are related to some bug ;)

Don Granaman
[certifiable OraSaurus]

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, August 20, 2002 2:13 PM


Dave - Can you post the bug number? I searched Metalink and couldn't find
any matches for 9.2. Is it possible that Oracle fixed the bugs by 9.2?

Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]


-Original Message-
Sent: Tuesday, August 20, 2002 12:57 PM
To: Multiple recipients of list ORACLE-L


Sam,

The only problem I have come acroos is using SMU [ system managed undo ]
instead of rollback segments Check metalink under bug database

Dave Clarke.
Cisco Systems - Amsterdam

-Original Message-
Sent: Tuesday, August 20, 2002 6:39 PM
To: Multiple recipients of list ORACLE-L


Hi

Can anybody tell me what the track record has been for Oracle 9.2?  Has
it
been reliable and stable?

We have clients asking us about Oracle 9.2 and I would like to gather
some
experience from the field on how reliable it has been.

Most of our clients are running Windows NT/2000, some are running UNIX.
Appreciate any feedback anybody can provide.

Thanks a lot.

Sam Bootsma, OCP
Technical Support Analyst
[EMAIL PROTECTED]



--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Sam Bootsma
  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: Dave Robert Clarke (daclarke)
  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: DENNIS WILLIAMS
  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: Don Granaman
  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: Senware AutoDBA

2002-08-21 Thread Don Granaman

That was truly a disaster of a session.  I, and the small group I was with,
left almost immediately.  I was on the sundeck for the post-mortem though
and even have a nice picture of Gaja discussing (emphasis on "cuss") it with
Stan.  I believe the presenter was the CTO, but I'm not sure.

I have been hounded constantly about AutoDBA by a sales rep from Insession
Technology.  After a cold call from her, long before the conference, I asked
for some technical material on it and got only marketing material - even the
supposed "technical white papers" were pure marketing blather.  I did try to
get a "trial download" off their web site.  I "registered" only to find out
that there was no trial download.  Instead, I got another call from the same
sales rep offering to come out and give a presentation to executive
management - and perhaps, after that, to come out and install a trial
version.

I have never seen AutoDBA nor used it, but I have formed a strong subjective
opinion that it is most likely pure garbage.  I apologize if anyone here is
associated with this product and offended.  Please don't take it
personally - my admittedly highly subjective opinion is based largely on the
tactics of marketing weasels.  Here is the basis:

1) The presentation at IOUG-A Live! 2002 (The last straw - I already had a
dislike for AutoDBA before that.)

2) The fact that they couldn't or wouldn't offer any substantial information
about it - only marketing rhetoric.

3) The marketing is hyperbole full of exotic-sounding buzz-phrases meant to
impress PHBs (e.g. "Utilizes advanced artificial intelligence, predictive
analysis algorithms, and intelligent neural network technologies")  - and it
seems to be based mostly on the standard tuning myths (e.g. "As space is
allocated in an Oracle database, the tablespaces become increasingly
fragmented which hinders database performance.  AutoDBA automatically
repairs these fragmented tablespaces, improving database efficiency").

4) The tactic of wanting to "sell" it to upper management before offering a
trial copy or even significant technical information about how it works and
what it does.

5) The proverbial "Big One" - I now work closely with someone who was not
long ago a manager at a company that markets AutoDBA and was the project
manager on that company's initial "evaluation" of the product.  They said
that AutoDBA sent out a couple of their "experts" who spent three days
trying to get it working - installing it, patching it, downloading stuff
from all over the web, patching it again, hacking ... and it still barely
worked.  They begged off the project (and shortly after left the company)
when told in no uncertain terms that their "evaluation" needed to be "very
positive".  Granted, that was over a year ago and the product may have
improved since then, but as recently as a few months ago a "registration"
for a "trial download" on the web lead only to a marketing call.

No thanks...  I feel a bit queasy even now just thinking about it.

Don Granaman
[certifiable OraSaurus]

- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, August 21, 2002 2:24 PM


FWIW, someone from Senware presented a paper at IOUG 2002 titled
'Performance management from the ground up' (or somthing like that) which
was a load of &*$% to say the least. Most of the audience (many on this
list) walked out in disgust after the first 10 minutes (Does someone
remember the 'green peas' story?) If their product is even twice as good as
their rep, it would not be worth considering.

I am not blaming their desperate tactics however. Anything to sell a product
in this economy :(  Just came off a marketing call on the office phone for
services I don't need!

John

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, August 21, 2002 11:04 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: Senware AutoDBA
>
>
> Interesting web site.
>
> They claim to eliminate chained rows by rebuilding the tables.
> I'd like to see how they intend to do that.
>
> They also claim that their product can detect corrupt indexes
> and rebuild them.  How hard can it be to detect ORA-1578?
> This kind of thing is fairly rare, and hardly seems worth the
> resources to run DBMS_REPAIR or dbv to check for.
>
> Their MO is hardly new.  IBM has had a team in place for years
> designed to make an end run around the purchasing mgr/DBA/whoever
> when their product wasn't selected.  They go to upper mgt to
> try and convince them of the foolish mistake the product
> evaluators made.
>
> Not surprising that others follow their lead.
>
> Jared
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: John Kanagaraj
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists

pls-00553 when 'Set Serverout On' in glogin.sql

2002-08-21 Thread Madhusudhanan Sampath

(reposting)
--
List,

Are we not supposed to 'Set Serveroutput On' in the glogin.sql file?

If the parameter is set in glogin.sql, I'm getting the following error when 
using DBMS_OUTPUT in pl/sql

SQL> Create or Replace Procedure TEST1 as
 Begin
 DBMS_OUTPUT.PUT_LINE('TEST');
 End;

Compiles ok, but presents error during run-time.

"PLS-00553 character set name is not recognized"

(8.1.6.0 on NT4 SP6; am testing this on a small DB/OS Server)

Regards
Madhu




_
Join the world’s largest e-mail service with MSN Hotmail. 
http://www.hotmail.com

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



Shutdown Immediate Hanging

2002-08-21 Thread Steve Perry
Title: Message



I hope somebody can help me with 
this  shutdown problem. There's 2 questions unless: how to 
troubleshoot a stalled shutdown and the best way to deal with 
it.
 
#1 - Database hangs during 
shutdown
We have several instances running 
8.1.7.3 on Win2k and continue to have intermittent shutdown 
problems.
The shutdown never 
completes.
Here's are the steps used to stop the 
database
1.) Stop the application 
servers
1.) run a kill session script to kill 
all remaining sessions except the one running the script 
2.) issue shutdown immediate and hope 
it shuts down.
 
At this point, the database closes 
but it never dismounts.
We never receive the "Completed: 
ALTER DATABASE DISMOUNT"
 
Is there anything I can do to 
diagnose the problem at this point? 
 
After 15 minutes, Arcserve backs 
up the files to tape (delay field in arcserve job).
After the backup is complete, the 
database startup script is run.
The alert log says the startup is 
normal, but no connections are allowed into the database.
 
I either have to do a shutdown abort 
or stop the service and then I can start the database.
I wrote a script to detect the 
shutdown hangs that will page me, do a shutdown abort, startup and 
then shutdown immediate (before the backup job starts)
There's not much I can do when it 
stalls and I don't mind running the script if it won't corrupt my 
database.

Is there a better way to handle 
this? 
 
I checked metalink and opened a tar. 

Oracle said it was a security dll 
issue with MS and that I should change the scripts to shutdown the service 
instead of using svrmgrl or sqlplus. That was fine until I realized that 
stopping the service will do a shutdown immediate. If the database doesn't 
complete before the ora__shutdown_timeout value, it does a shutdown 
abort (or equivalent).
 
Thanks,
Steve


SunFire v100

2002-08-21 Thread Maria Aurora VT de la Vega

Hello everyone.

Just want to ask if anybody tried to use a SunFire v100 as a database
server.
I was told this is a headless server, but otherwise, very similar to any
other sun servers. Looks like an oracle database on this baby can work
enough as a development server. Would like to get anybody's opinion.
Will oracle work on this or not?

Thanks.

=)



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Maria Aurora VT de la Vega
  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: drop tablespace including contents

2002-08-21 Thread paquette stephane

I had one experience with an ERP, since then I'm
avoiding those contract.

Developping a system is so much more interesting in my
point of view.
Unfortunately there is more and more ERP sold  :-(



 --- "Brooks, Russ" <[EMAIL PROTECTED]> a écrit :
> Yeah, that's what I do too.  I just wish it wouldn't
> clobber the stats on
> the indices after I've so carefully gathered them. 
> We have the 6.2 sapdba,
> so I don't think it's using dbastatc as much to
> control when and how it does
> the stats.
> 
> Russ
> 
> -Original Message-
> Sent: Wednesday, August 21, 2002 1:59 PM
> To: Multiple recipients of list ORACLE-L
> 
> 
> Ironically, analyzing tables is one of the jobs I
> leave up to SAPDBA.
> 
> There are a number of tables that shouldn't be
> analyzed, ( ~150
> on my system ) and the system knows which ones they
> are.
> 
> Just schedule the job through transaction DB13 and
> forget about it.
> 
> Jared
> 
> 
> 
> 
> 
> 
> paquette stephane <[EMAIL PROTECTED]>
> Sent by: [EMAIL PROTECTED]
> 08/20/2002 09:48 PM
> Please respond to ORACLE-L
> 
>  
> To: Multiple recipients of list ORACLE-L
> <[EMAIL PROTECTED]>
> cc: 
> Subject:Re:drop tablespace including
> contents
> 
> 
> At one client, one team was using SAP without a DBA,
> only the SAP administrator using SAPDBA. They were
> having poor performance.
> 
> After 2-3 days they came to see me, after 5 minutes
> I
> told them that 4000 tables out of 16 000 were having
> no statistics at all. They analyzed during the
> weekend
> and performance was pretty good 
> 
> 
> 
>  --- [EMAIL PROTECTED] a écrit : > Dick,
> > 
> > There is absolutely *nothing* that SAPDBA does
> that
> > a reasonably
> > knowledgeable DBA can't do from his of her
> favorite
> > toolset.
> > ( vi, Perl and sqlplus for me :)
> > 
> > SAP types have it drummed into their heads that
> the
> > only proper
> > way to do anything DBA work is via SAPDBA.
> > 
> > I refuse to use it, and it just drives the SAP
> > consultants crazy. 
> > 
> > There are many cases where a good DBA can do a
> much
> > better
> > job than SAPDBA.  The tablespace reorganization is
> a
> > good
> > example.  Trying to 'drop tablespace including
> > contents' with 
> > 3500 tables is not a terribly bright way of going
> > about it.
> > 
> > 
> > Jared
> > 
> > 
> > 
> > 
> > 
> > 
> > 
> > [EMAIL PROTECTED]
> > Sent by: [EMAIL PROTECTED]
> > 08/20/2002 02:43 PM
> > Please respond to ORACLE-L
> > 
> > 
> > To: Multiple recipients of list
> ORACLE-L
> > <[EMAIL PROTECTED]>
> > cc: 
> > Subject:Re:drop tablespace
> including
> > contents
> > 
> > 
> > Russ,
> > 
> > Your high usage of RBS was due to the updates
> > being done to the system 
> > data
> > dictionary.  Since you were dropping a tablespace
> > and contents the DDL
> > statements for the individual objects (tables and
> > indexes) needs to be 
> > done
> > first, but I've a funny idea from practice that
> > Oracle does not do an 
> > implicit
> > commit in this case but instead holds on till the
> > end.  This makes 
> > dropping a
> > tablespace with the "including contents" caviot
> very
> > nasty.  Thank GOD we 
> > never
> > implemented SAP over here.  I've heard nothing but
> > bad about SAP and 
> > sapdba.
> > 
> > Dick Goulet
> > 
> > Reply
> > Separator
> > Author: "Brooks; Russ" <[EMAIL PROTECTED]>
> > Date:   8/20/2002 11:13 AM
> > 
> > Hi, 
> > This past weekend we experienced a problem on a
> > production database, and I 
> > would
> > like to try to determine what went wrong, how to
> > avoid it in the future, 
> > and any
> > better ways of dealing with it should it be
> > encountered again. 
> > After moving some large objects out of tablespace
> to
> > spread I/O, we wanted 
> > to
> > reorganize the old tablespace to remove some
> > fragmentation. The tool we 
> > were
> > using, sapdba, does not readily permit you to drop
> > the individual tables 
> > between
> > the export and the drop tablespace including
> > contents. Since the 
> > tablespace had
> > over 3500 tables the drop tablespace was expected
> to
> > take a long time. We 
> > also
> > defined a large rollback segment for use this
> > weekend, although with only
> > maxextents of 100. When Oracle tried to allocate
> the
> > 101 extent in the 
> > RBS,
> > error messages were issued and things came to a
> > grinding halt. sar 
> > indicated
> > disk I/O to the new RBS, but not to any of the
> > datafiles. We waited 
> > several
> > hours, but the situation did not appear to change.
> 
> > Shutdown immediate did not work. We could alter
> the
> > datafiles back online, 
> > but
> > not the tablespace. Since it was production, the
> > decision was made to 
> > restore to
> > a recent backup. 
> > 1. Was the rollback activity due solely to storing
> > and restoring DDL for 
> > the
> > tables and indices? 
> > 2. Once the RBS was unable to extend, 

Re: how to reduce SQL*Net more data to client wait event

2002-08-21 Thread Tim Gorman



"SQL*Net more data to client" (as opposed 
to "from client") seems to indicate that flow is from server to client, 
which doesn't seem appropriate for SQL statements...

  - Original Message - 
  From: 
  Johnson, Michael 
  To: '[EMAIL PROTECTED]' ; 'Tim Gorman' 

  Sent: Wednesday, August 21, 2002 11:59 
  AM
  Subject: RE: how to reduce SQL*Net more 
  data to client wait event
  
  Tim,   more specifically could large SQL 
  have been passed across
  the 
  net ?   Stored procedures could help here.
   
  FWIW.
   
  Mike
  
-Original Message-From: Tim Gorman 
[mailto:[EMAIL PROTECTED]]Sent: Wednesday, August 21, 2002 12:03 
AMTo: Multiple recipients of list ORACLE-LSubject: Re: 
how to reduce SQL*Net more data to client wait event
Depending on the application, couldn't 
these large pauses be performance problems in the client 
program?  Not a server tuning issue nor a SQL*Net tuning issue at 
all?  For example, if the client program was pausing a long time 
between FETCH commands, processing previously fetched data?  Or would 
that just be accounted for under "SQL*Net message from client" 
events?

  - Original Message - 
  From: 
  Suhen Pather 
  To: Multiple recipients of list 
  ORACLE-L 
  Sent: Monday, August 19, 2002 8:08 
  PM
  Subject: how to reduce SQL*Net more 
  data to client wait event
  
  
  Hi,
   
  I am tuning a system at a 
  client site and notice lots of waits for SQL*Net 
  more data to client (97%) for a fraction 
  of the CPU consumed by the 
  system.
   
  I know this is not to be 
  characterized as an idle wait event and can yield better performance if we 
  increase
  the packet 
  size.
  The database is Oracle 7.3.4 
  (SQL Net 2.3).  What effect will increasing TDU and SDU have 
  
  on this wait to increase 
  packet size.
   
  It seems that if we can reduce this wait then we 
  can save lots of time (I Think).
   
  Will using BEQ protocol help at 
  all.
    
  Regards
  Suhen   
   
   


PLSExtProc

2002-08-21 Thread ltiu

PLSExtProc - found in listener.ora and tnsnames.ora - it's got to do with 
interMedia. What else is it good for?

Is this really necessary for an Oracle Database to function?

Thanks for any tips.

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



off topic - How to find used and free capacity on a DLT IV tape

2002-08-21 Thread Mandar A. Ghosalkar

Hello Guys,

I am testing some backup scripts on a dlt library and trying to run manual backups.

mc -p /dev/dltrobotics -s S15 -d D1
backup -f /dev/rmt/4m -i /prod1 -v

Is there any easy way (other than keeping track of files being copied to tape) to find 
out space left on the tape(uncompressed/compressed)?

I am using a Maxell DLT IV 40/70 tape on a HP DLT 7000.

Thanks
Mandar

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mandar A. Ghosalkar
  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: Senware AutoDBA

2002-08-21 Thread Rachel Carmichael

you are being kind. I was there, and was amazed that Gaja was as calm
as he was before he walked out.

I think we scared the next speaker (also on this list) with the venting
we ALL did.

I did try to correct something the speaker said by asking a question
with the correct answer in the question. he insisted he was right
at which  point I left. 


--- "Karniotis, Stephen" <[EMAIL PROTECTED]> wrote:
> I'll add to John's comments.  It took John, Kirti & myself to keep
> Gaja calm
> during the presentation.  Once we all walked out, Gaja went outside
> and
> vented.  Their solution is unusual as they believe that performance
> can
> optimized by adding hardware to the solution.
> 
> Thank You
> 
> Stephen P. Karniotis
> Product Architect
> Compuware Corporation
> Direct:   (248) 865-4350
> Mobile:   (248) 408-2918
> Email:[EMAIL PROTECTED]
> Web:  www.compuware.com
> 
>  -Original Message-
> Sent: Wednesday, August 21, 2002 3:24 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  RE: Senware AutoDBA
> 
> FWIW, someone from Senware presented a paper at IOUG 2002 titled
> 'Performance management from the ground up' (or somthing like that)
> which
> was a load of &*$% to say the least. Most of the audience (many on
> this
> list) walked out in disgust after the first 10 minutes (Does
> someone
> remember the 'green peas' story?) If their product is even twice as
> good as
> their rep, it would not be worth considering.
> 
> I am not blaming their desperate tactics however. Anything to sell a
> product
> in this economy :(  Just came off a marketing call on the office
> phone for
> services I don't need!
> 
> John
> 
> > -Original Message-
> > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> > Sent: Wednesday, August 21, 2002 11:04 AM
> > To: Multiple recipients of list ORACLE-L
> > Subject: Re: Senware AutoDBA
> > 
> > 
> > Interesting web site.
> > 
> > They claim to eliminate chained rows by rebuilding the tables.
> > I'd like to see how they intend to do that.
> > 
> > They also claim that their product can detect corrupt indexes
> > and rebuild them.  How hard can it be to detect ORA-1578?
> > This kind of thing is fairly rare, and hardly seems worth the
> > resources to run DBMS_REPAIR or dbv to check for.
> > 
> > Their MO is hardly new.  IBM has had a team in place for years
> > designed to make an end run around the purchasing mgr/DBA/whoever
> > when their product wasn't selected.  They go to upper mgt to
> > try and convince them of the foolish mistake the product 
> > evaluators made.
> > 
> > Not surprising that others follow their lead.
> > 
> > Jared
> > 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: John Kanagaraj
>   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).
> 
> 
> 
> The contents of this e-mail are intended for the named addressee
> only. It
> contains information that may be confidential. Unless you are the
> named
> addressee or an authorized designee, you may not copy or use it, or
> disclose
> it to anyone else. If you received it in error please notify us
> immediately
> and then destroy it. 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Karniotis, Stephen
>   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!?
HotJobs - Search Thousands of New Jobs
http://www.hotjobs.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rachel Carmichael
  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, in

RE: how to reduce SQL*Net more data to client wait event

2002-08-21 Thread Johnson, Michael



thank 
you.
 
mike

  -Original Message-From: Anjo Kolk 
  [mailto:[EMAIL PROTECTED]]Sent: Wednesday, August 21, 2002 1:09 
  PMTo: Multiple recipients of list ORACLE-LSubject: Re: 
  how to reduce SQL*Net more data to client wait event
  No,
   
  this is "to client", so it is the result of a 
  query (either to many columns or too many rows returned).
  Large SQL statements would result in "from 
  client" during the Parse phase and if people keep on parsing the same 
  statement, the client side will keep on sending it to the server. Parse 
  once/execute many 
   
  Anjo.
  
- Original Message - 
From: 
Johnson, Michael 
To: Multiple recipients of list ORACLE-L 

Sent: Wednesday, August 21, 2002 9:10 
PM
Subject: RE: how to reduce SQL*Net more 
data to client wait event

Tim,   more specifically could large SQL 
have been passed across
the net ?   Stored procedures could help 
here.
 
FWIW.
 
Mike

  -Original Message-From: Tim Gorman 
  [mailto:[EMAIL PROTECTED]]Sent: Wednesday, August 21, 2002 
  12:03 AMTo: Multiple recipients of list 
  ORACLE-LSubject: Re: how to reduce SQL*Net more data to client 
  wait event
  Depending on the application, couldn't 
  these large pauses be performance problems in the client 
  program?  Not a server tuning issue nor a SQL*Net tuning issue at 
  all?  For example, if the client program was pausing a long time 
  between FETCH commands, processing previously fetched data?  Or would 
  that just be accounted for under "SQL*Net message from client" 
  events?
  
- Original Message - 
From: 
Suhen Pather 
To: Multiple recipients of list 
ORACLE-L 
Sent: Monday, August 19, 2002 8:08 
PM
Subject: how to reduce SQL*Net more 
data to client wait event


Hi,
 
I am tuning a system at a 
client site and notice lots of waits for SQL*Net 
more data to client (97%) for a fraction 
of the CPU consumed by the 
system.
 
I know this is not to be 
characterized as an idle wait event and can yield better performance if 
we increase
the packet 
size.
The database is Oracle 7.3.4 
(SQL Net 2.3).  What effect will increasing TDU and SDU have 

on this wait to increase 
packet size.
 
It seems that if we can reduce this wait then we 
can save lots of time (I Think).
 
Will using BEQ protocol help at 
all.
  
Regards
Suhen   
 
 


RE: Cannot start database -- RESOLVED!

2002-08-21 Thread Butler, Mathew

I think 'startup force' would have worked as well.

-Original Message-
Sent: 22 August 2002 07:29
To: Multiple recipients of list ORACLE-L


Thanks Scott,Mike,Kevin, and Ruth.
I was so shocked to see the "database running" message (when I knew it was
not) that I didn't try the obvious.
shutdown abort did work.
And that caused the semaphore to disappear.

I do have an lkDESI file in $ORACLE_HOME/dbs, but I don't have access to see
it (let alone delete it).
Don't know if this is normally.  (We're pretty Abby here, as Igor would
say).
Thanks for your help!
Barb


> --
> From: Hately Mike[SMTP:[EMAIL PROTECTED]]
> Reply To: [EMAIL PROTECTED]
> Sent: Wednesday, August 21, 2002 1:03 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  RE: Cannot start database (already running)
> 
> Barb,
> check for an LK file in your $ORACLE_HOME/dbs directory too. If
> it's
> there, delete it. 
> Just another thing to try.
> 
> Regards,
> Mike Hately
> 
> -Original Message-
> Sent: Wednesday, August 21, 2002 11:34 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> 
> Oracle 8.0.5
> Solaris 2.6
> HA Cluster 2.1
> 
> This is wacky.
> Any ideas on this one (other than reboot the box)???
> I cannot start up this database (claims it's already running).
> Clearly it is not.  No background processes for this instance.  The only
> process I see even remotely related to this database is the oracledesi
> process.  (I don't know what that process is.)
> 
> I do have a semaphore set for oracle.  Should I remove it? (I normally
> have
> other databases on this box, but I've shut them all down.)
> 
> This database worked fine till a network device was ripped out from under
> it, and the HA stuff kicked in and failed it over.
> 
> Any ideas?  Thanks for any help
> 
> Barb
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Vergara, Michael (TEM)
>   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).
> 
> 
>  
> __
> __
>  
> 
> This email and any attached to it are confidential and intended only for
> the
> individual or 
> entity to which it is addressed.  If you are not the intended recipient,
> please let us know 
> by telephoning or emailing the sender.  You should also delete the email
> and
> any attachment 
> from your systems and should not copy the email or any attachment or
> disclose their content 
> to any other person or entity.  The views expressed here are not
> necessarily
> those of 
> Churchill Insurance Group plc or its affiliates or subsidiaries. Thank
> you. 
> Churchill Insurance Group plc.  Company Registration Number - 2280426.
> England. 
> Registered Office: Churchill Court, Westmoreland Road, Bromley, Kent BR1
> 1DP. 
> 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Hately Mike
>   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: Baker, Barbara
  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).

This e-mail and any attachment is for authorised use by the intended recipient(s) 
only.  It may contain proprietary material, confidential information and/or be subject 
to legal privilege.  It should not be copied, disclosed to, retained or used by, any 
other party.  If you ar

Has anyone used Note 77335.1 (TCP Tuning for Oracle Application S

2002-08-21 Thread John Kanagaraj

Hi all,

As above... I am looking at opportunties to tune up a 9iAS W/server (for the
ERP application from your favorite vendor).

John Kanagaraj
Oracle Applications DBA
DBSoft Inc
(W): 408-970-7002

Disappointments are inevitable in Life, but discouragement is optional. You
decide!

** The opinions and statements above are entirely my own and not those of my
employer or clients **
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: John Kanagaraj
  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: Catching errors on inserts[SOLVED!]

2002-08-21 Thread Bob Metelsky


This was solved by the knowledgeable Charlie Mengler of the  list

The problem was the  "=" 
SQL> alter session set events='0001  trace name errorstack forever,level
10' ;

Took that off and it generated me a 14M trc file!! Not pretty but it
worked

Thanks to all who helped with this

Best regards bob
~

> Ok Im having a problem with this
> 
> [from init.ora]
> user_dump_dest = D:\db_track2data\admin\LTRACK2\udump
> 
> [recommended from a user on this list]
> select name, value
> from v$parameter
> where name like '%dump%' ; 
> 
> NAME VALUE
> 
> ---
> background_dump_dest
> D:\db_track2data\admin\LTRACK2\bdump
> user_dump_dest
> D:\db_track2data\admin\LTRACK2\udump
> max_dump_file_size
>204800
> 
> 3 rows selected.
> 
> ~
> 
> I run
> SQL> alter session set events='0001  trace name errorstack forever,
> level 10' ;
> Session altered
> 
> I run the 10K insert script which contains many errors
> 
> No TRC file gets created in the above dir or any place for that matter
> 
> I search for *.trc and "no files found" 
> There must be a problem with my syntax in the alter session 
> does anyone see a problem
> 
> Thanks
> bob
> 
> > check your init.ora setting for user_dump_dest (I believe).
> > 
> > Anjo.
> > 
> > - Original Message -
> > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> > Sent: Wednesday, August 21, 2002 8:43 PM
> > 
> > 
> > > > It is in the session trace file not the alert log file.
> > > > 
> > > 
> > > Where would I find this file?
> > > 
> > > Many thanks in advance
> > > bob
> > > > Anjo.
> > > > 
> > > > 
> > > > On Wednesday 21 August 2002 16:38, you wrote:
> > > > > Gogala
> > > > >
> > > > > Thanks for the tip this seems like just what I'm
> > > > looking for, however
> > > > > I must be doing something wrong as no errors are getting
> > > > written to my
> > > > > alrt.log
> > > > >
> > > > > Im running oracle 8.16 server on win2kpro (this is a 
> development
> > > > > database)
> > > > >
> > > > > I just got around  to running/testing this from my post
> > last week
> > > > >
> > > > > I do
> > > > > SQL> alter session set events='0001  trace name errorstack
> > > > > SQL> forever,
> > > > > level 10';
> > > > >
> > > > > Session altered.
> > > > >
> > > > > Then I run the offending insert script which show errors
> > > > being thrown
> > > > >
> > > > > I check the alrt.log in BDUMP dir and all it show are
> > > > my regular
> > > > > .ORA logs being written EG
> > > > > Wed Aug 21 09:19:07 2002
> > > > > Thread 1 advanced to log sequence 3240
> > > > >   Current log# 4 seq# 3240 mem# 0:
> > > > > D:\DB_TRACK2DATA\ORADATA\LTRACK2\LOG4LTRACK2.ORA
> > > > > Thread 1 advanced to log sequence 3241
> > > > >   Current log# 1 seq# 3241 mem# 0: 
> > > > > D:\DB_TRACK2DATA\ORADATA\LTRACK2\LOG1LTRACK2.ORA
> > > > > Thread 1 advanced to log sequence 3242
> > > > >   Current log# 2 seq# 3242 mem# 0: 
> > > > > D:\DB_TRACK2DATA\ORADATA\LTRACK2\LOG2LTRACK2.ORA
> > > > > Thread 1 advanced to log sequence 3243
> > > > >
> > > > > Also checked the alrt.log in Oracle\home\database
> > > > Nothing written
> > > > > there
> > > > >
> > > > > What am I missing?
> > > > >
> > > > > > alter session set events='0001  trace name errorstack
> > > > forever, level
> > > > > > 10'; All "duplicate value" errors will then be 
> trapped in the 
> > > > > > alert.log file. You can always substitute your own
> > > > favorite error in
> > > > > > place of 0001.
> > > > >
> > > > > Also If you have a extra min how can I substitute the error
> > > > > message?
> > > > >
> > > > > Thanks for your help
> > > > >
> > > > > Bob
> > > > 
> > > > 
> > > > --
> > > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > > --
> > > > Author: Anjo Kolk
> > > >   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: Bob Metelsky
> > >   INET: [EMAIL PROTECTED]
> > > 
> > > Fat City Network Services-- (858) 538-5051  FAX: 
> (858) 538-5051
> > > San Diego, California  

RE: Install Pro*C

2002-08-21 Thread Rodrigues, Bryan

Ron,

I believe you need to install the pro*c compiler from the installation
disks, but it is on the client option.

Bryan

-Original Message-
Sent: Wednesday, August 21, 2002 5:44 PM
To: Multiple recipients of list ORACLE-L


Someone forgot to install Pro*C on our 8.1.7 Sun server.  I need to install
it.
Is there anything that needs to be done after I run the installer?

Thanks!
R Smith
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Smith, Ron L.
  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: Rodrigues, Bryan
  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: Analyzing a Trigger for Performance: Ok for Now

2002-08-21 Thread johanna . doran

Hi All,  I'm going to take some time now to look into the DBMS_PROFILER and DBMS_TRACE 
packages.  They have been suggested by several people.

So, I may repost later when I get a better hanlde on them.

Thanks,

Hannah

>  -Original Message-
> From: "Aponte, Tony" <[EMAIL PROTECTED]>@SUNGARD  
> Sent: Wednesday, August 21, 2002 4:38 PM
> To:   [EMAIL PROTECTED]
> Cc:   Doran, Johanna
> Subject:  RE: Analyzing a Trigger for Performance
> 
> 
> Hi Hannah, 
> Have you looked into the DBMS_PROFILER and DBMS_TRACE packages?  They can be used to 
>trace PL/SQL execution and performance.  
> Tony Aponte 
> Home Shopping Network, Inc. 
> 
--
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).




RE: Analyzing a Trigger for Performance - Ok for Now

2002-08-21 Thread johanna . doran

Got enough info to start looking around.  I am using a third party replication tool , 
so that's won't be an issue.

Thanks for all the replies.

Hannah
--
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).



RE: Analyzing a Trigger for Performance

2002-08-21 Thread Gogala, Mladen

Make a dedicated server connection, execute the following
statement 
 alter session set events='10046 trace name context forever, level 10';
and ship the resulting trace file to Cary. More about the details
on http://www.hotsos.com

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, August 21, 2002 5:01 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Analyzing a Trigger for Performance
> 
> 
> Hi,
> 
> I had noticed that one of our triggers is performing very 
> badly.  I had disabled the trigger to test replication and 
> there was a issue with the trigger. When the developer 
> changed the trigger and enabled it, replication slowed down 
> to one record per second (other tables are being updated, 
> instered, and deleted from).
> 
>   I analyzed the plans for all sql statements generated 
> in the trigger itself and they are all using the correct 
> indices etc.  There are no full table scans etc.  We have 
> simliar trigger on our other replicated tables that are not 
> seeing THIS bad performance.
> 
>   Any one have any suggestions/links for putting this 
> trigger through the paces to determine the bottleneck?
> 
> Thanks,
> 
>   Hannah
> -- 
> 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: Gogala, Mladen
  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).



Install Pro*C

2002-08-21 Thread Smith, Ron L.

Someone forgot to install Pro*C on our 8.1.7 Sun server.  I need to install
it.
Is there anything that needs to be done after I run the installer?

Thanks!
R Smith
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Smith, Ron L.
  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: Analyzing a Trigger for Performance

2002-08-21 Thread Aponte, Tony
Title: RE: Analyzing a Trigger for Performance






Hi Hannah,


Have you looked into the DBMS_PROFILER and DBMS_TRACE packages?  They can be used to trace PL/SQL execution and performance.  

Tony Aponte

Home Shopping Network, Inc.


-Original Message-

From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]

Sent: Wednesday, August 21, 2002 5:01 PM

To: Multiple recipients of list ORACLE-L

Subject: Analyzing a Trigger for Performance



Hi,


I had noticed that one of our triggers is performing very badly.  I had disabled the trigger to test replication and there was a issue with the trigger. When the developer changed the trigger and enabled it, replication slowed down to one record per second (other tables are being updated, instered, and deleted from).

    I analyzed the plans for all sql statements generated in the trigger itself and they are all using the correct indices etc.  There are no full table scans etc.  We have simliar trigger on our other replicated tables that are not seeing THIS bad performance.

    Any one have any suggestions/links for putting this trigger through the paces to determine the bottleneck?


Thanks,


    Hannah

-- 

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).





Re:RE: Senware AutoDBA

2002-08-21 Thread dgoulet

OK, Since we're into a discussion of the pro's and con's of AutoDBA, My basic
problem with it is that I really don't like software that tries to "fix" things
based on it's idea of the perfect world.  Sure I appreciate the scripts, but
leave it to me to run them at a time that is more advantageous to me (namely
scheduled downtime, after a full cold backup) and allow me to watch it execute
and log it, or ignore the script all together.  Having written software that
does some proactive maintenance I find that it's impossible to handle every
possible error condition that could happen.  Oh, and throwing additional
hardware at a problem is certainly not the best solution.  It can make things
worse, not better.

Dick Goulet

Reply Separator
Author: "Karniotis; Stephen" <[EMAIL PROTECTED]>
Date:   8/21/2002 12:24 PM

I'll add to John's comments.  It took John, Kirti & myself to keep Gaja calm
during the presentation.  Once we all walked out, Gaja went outside and
vented.  Their solution is unusual as they believe that performance can
optimized by adding hardware to the solution.

Thank You

Stephen P. Karniotis
Product Architect
Compuware Corporation
Direct: (248) 865-4350
Mobile: (248) 408-2918
Email:  [EMAIL PROTECTED]
Web:www.compuware.com

 -Original Message-
Sent:   Wednesday, August 21, 2002 3:24 PM
To: Multiple recipients of list ORACLE-L

FWIW, someone from Senware presented a paper at IOUG 2002 titled
'Performance management from the ground up' (or somthing like that) which
was a load of &*$% to say the least. Most of the audience (many on this
list) walked out in disgust after the first 10 minutes (Does someone
remember the 'green peas' story?) If their product is even twice as good as
their rep, it would not be worth considering.

I am not blaming their desperate tactics however. Anything to sell a product
in this economy :(  Just came off a marketing call on the office phone for
services I don't need!

John

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, August 21, 2002 11:04 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: Senware AutoDBA
> 
> 
> Interesting web site.
> 
> They claim to eliminate chained rows by rebuilding the tables.
> I'd like to see how they intend to do that.
> 
> They also claim that their product can detect corrupt indexes
> and rebuild them.  How hard can it be to detect ORA-1578?
> This kind of thing is fairly rare, and hardly seems worth the
> resources to run DBMS_REPAIR or dbv to check for.
> 
> Their MO is hardly new.  IBM has had a team in place for years
> designed to make an end run around the purchasing mgr/DBA/whoever
> when their product wasn't selected.  They go to upper mgt to
> try and convince them of the foolish mistake the product 
> evaluators made.
> 
> Not surprising that others follow their lead.
> 
> Jared
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: John Kanagaraj
  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).



The contents of this e-mail are intended for the named addressee only. It
contains information that may be confidential. Unless you are the named
addressee or an authorized designee, you may not copy or use it, or disclose
it to anyone else. If you received it in error please notify us immediately
and then destroy it. 

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

Cannot start database -- RESOLVED!

2002-08-21 Thread Baker, Barbara

Thanks Scott,Mike,Kevin, and Ruth.
I was so shocked to see the "database running" message (when I knew it was
not) that I didn't try the obvious.
shutdown abort did work.
And that caused the semaphore to disappear.

I do have an lkDESI file in $ORACLE_HOME/dbs, but I don't have access to see
it (let alone delete it).
Don't know if this is normally.  (We're pretty Abby here, as Igor would
say).
Thanks for your help!
Barb


> --
> From: Hately Mike[SMTP:[EMAIL PROTECTED]]
> Reply To: [EMAIL PROTECTED]
> Sent: Wednesday, August 21, 2002 1:03 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  RE: Cannot start database (already running)
> 
> Barb,
> check for an LK file in your $ORACLE_HOME/dbs directory too. If
> it's
> there, delete it. 
> Just another thing to try.
> 
> Regards,
> Mike Hately
> 
> -Original Message-
> Sent: Wednesday, August 21, 2002 11:34 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> 
> Oracle 8.0.5
> Solaris 2.6
> HA Cluster 2.1
> 
> This is wacky.
> Any ideas on this one (other than reboot the box)???
> I cannot start up this database (claims it's already running).
> Clearly it is not.  No background processes for this instance.  The only
> process I see even remotely related to this database is the oracledesi
> process.  (I don't know what that process is.)
> 
> I do have a semaphore set for oracle.  Should I remove it? (I normally
> have
> other databases on this box, but I've shut them all down.)
> 
> This database worked fine till a network device was ripped out from under
> it, and the HA stuff kicked in and failed it over.
> 
> Any ideas?  Thanks for any help
> 
> Barb
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Vergara, Michael (TEM)
>   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).
> 
> 
>  
> __
> __
>  
> 
> This email and any attached to it are confidential and intended only for
> the
> individual or 
> entity to which it is addressed.  If you are not the intended recipient,
> please let us know 
> by telephoning or emailing the sender.  You should also delete the email
> and
> any attachment 
> from your systems and should not copy the email or any attachment or
> disclose their content 
> to any other person or entity.  The views expressed here are not
> necessarily
> those of 
> Churchill Insurance Group plc or its affiliates or subsidiaries. Thank
> you. 
> Churchill Insurance Group plc.  Company Registration Number - 2280426.
> England. 
> Registered Office: Churchill Court, Westmoreland Road, Bromley, Kent BR1
> 1DP. 
> 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Hately Mike
>   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: Baker, Barbara
  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: PL/Sql question

2002-08-21 Thread DENNIS WILLIAMS


Tom - The developer reports that he tried this but it didn't work. The third
position is still a space value. Thanks to everyone for the good replies.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]


-Original Message-
Sent: Wednesday, August 21, 2002 3:13 PM
To: '[EMAIL PROTECTED]'
Cc: DENNIS WILLIAMS


Dennis,

Try changing your insert statement to:

 insert into JOBOFFERFACT_LOAD 
(LIFETOUCHID, SOURCEFISCALYEAR, JOBNBR, PACKAGEID,
 MARKETINGCODE,
 TERRITORYCODE, PLANTRECEIPTDATE, SEASON, PACKAGENAME,
 PACKAGEPRICE,
 PAIDPACKAGEQTY, UNPAIDPACKAGEQTY, SHIPPEDPACKAGEQTY, CMSNTYPE,
 PACKAGECMSNRATE, PACKAGETYPE, PACKAGECHARGEBACK, 
 PACKAGEPOINTS, PACKAGECODE, PACKAGECONFIG) 
   VALUES
(LIFETOUCHID, CURRENTFY, JOBNBR, PKGID, rtrim(MARKETINGCODE,'
'),
 TERRITORYCODE, PLANTRECEIPTDATE, SEASON, PKGNAME, PACKAGEPRICE,
 PAIDPACKAGES, UNPAIDPACKAGES, SHIPPEDPACKAGES, CMSNTYPE, 
 PACKAGECMSN, PACKAGETYPE, PACKAGECHARGEBACK, 
 PACKAGEPOINTS, PKGCODE, PKGCONFIG ) ;


Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Wednesday, August 21, 2002 2:04 PM
To: Multiple recipients of list ORACLE-L


In response to the questions for more details, here are the PL/SQL code and
SQL Loader control file. Everything is varchar2(2), explicitly defined as
such in PL/SQL. Thanks for all the nice replies.

PL/SQL snippets


<...snip...>

   marketingcodeVARCHAR2(3);

<...snip...>

FILELOCATION := '/usr/users/madmload/text_files';
OPEN_MODE:= 'r';
FILENAME := 'prodload.txt';

FILENBR := UTL_FILE.FOPEN (FILELOCATION , FILENAME, OPEN_MODE );

<...snip...>

   UTL_FILE.GET_LINE (FILENBR, OUTPUTSTRING);
   marketingcode := substr(outputstring, 21, 3);
 

<...snip...>

 insert into JOBOFFERFACT_LOAD 
(LIFETOUCHID, SOURCEFISCALYEAR, JOBNBR, PACKAGEID,
MARKETINGCODE,
 TERRITORYCODE, PLANTRECEIPTDATE, SEASON, PACKAGENAME,
PACKAGEPRICE,
 PAIDPACKAGEQTY, UNPAIDPACKAGEQTY, SHIPPEDPACKAGEQTY, CMSNTYPE,
 PACKAGECMSNRATE, PACKAGETYPE, PACKAGECHARGEBACK, 
 PACKAGEPOINTS, PACKAGECODE, PACKAGECONFIG) VALUES
(LIFETOUCHID, CURRENTFY, JOBNBR, PKGID, MARKETINGCODE,
 TERRITORYCODE, PLANTRECEIPTDATE, SEASON, PKGNAME, PACKAGEPRICE,
 PAIDPACKAGES, UNPAIDPACKAGES, SHIPPEDPACKAGES, CMSNTYPE, 
 PACKAGECMSN, PACKAGETYPE, PACKAGECHARGEBACK, 
 PACKAGEPOINTS, PKGCODE, PKGCONFIG ) ;





Sql*Loader script

LOAD DATA
INFILE '/usr/users/madmload/joblid.txt'
BADFILE '/usr/users/madmload/jobload.bad'
APPEND
INTO TABLE JOBFACT
(
JOBNBR  POSITION(1:10)  CHAR, 
LIFETOUCHID POSITION(11:20) INTEGER EXTERNAL,
MDRPRIMARYIDPOSITION(21:28) CHAR,
MARKETINGCODE   POSITION(29:31) CHAR,
SUBPROGRAMCODE  POSITION(32:32) CHAR,
TERRITORYCODE   POSITION(33:34) CHAR,
SUBTERRITORYCODEPOSITION(33:36) CHAR,
SELLINGMETHODCODE   POSITION(37:37) CHAR,
BIDIND  POSITION(38:38) CHAR,
PDKIND  POSITION(39:39) CHAR,
PDKPARTNBR  POSITION(40:44) CHAR,
RETAKEIND   POSITION(45:45) CHAR,
PLANTCODE   POSITION(46:46) CHAR,
PLANTRECEIPTDATEPOSITION(47:56) DATE "/MM/DD" NULLIF
PLANTRECEIPTDA,
PLANTRECEIPTYEARPOSITION(47:50) INTEGER EXTERNAL,
PLANTRECEIPTMONTH   POSITION(52:53) INTEGER EXTERNAL,
PHOTOGRAPHYDATE POSITION(57:66) DATE "/MM/DD" NULLIF
PHOTOGRAPHYDATE=BLANKS,
SHIPDATEPOSITION(67:76) DATE "/MM/DD" NULLIF SHIPDATE=BLANKS,
SHOTQTY POSITION(77:80) INTEGER EXTERNAL,
SHIPPEDPACKAGEQTY   POSITION(81:84) INTEGER EXTERNAL,
PAIDPACKAGEQTY  POSITION(85:88) INTEGER EXTERNAL,
UNPAIDPACKAGEQTYPOSITION(89:92) INTEGER EXTERNAL,
XNOPURCHASEQTY  POSITION(93:96) INTEGER EXTERNAL,
CASHRECEIVEDAMT POSITION(97:105)DECIMAL EXTERNAL,
CASHRETAINEDAMT POSITION(106:114)   DECIMAL EXTERNAL,
ACCTCMSNPAIDAMT POSITION(115:123)   DECIMAL EXTERNAL,
ESTACCTCMSNAMT  POSITION(124:132)   DECIMAL EXTERNAL,
CHARGEBACKAMT   POSITION(133:141)   DECIMAL EXTERNAL,
SALESTAXAMT POSITION(142:150)   DECIMAL EXTERNAL,
TERRITORYCMSNAMTPOSITION(151:159)   DECIMAL EXTERNAL,
TERRITORYEARNINGSAMTPOSITION(160:168)   DECIMAL EXTERNAL,
EXPECTEDCASHAMT POSITION(169:177)   DECIMAL EXTERNAL,
SOURCEFISCALYEARCONSTANT '2003',
PROOFPOSE   POSITION(178:178)   DECIMAL EXTERNAL,
PROOFCOUNT  POSITION(179:182)DECIMAL EXTERNAL,
SEASONDESC  POSITION(183:183)DECIMAL EXTERNAL,
EXTRACTDATE POSITION(184:193) DATE "/MM/DD" NULLIF
EXTRACTDATE=BLANKS,
FUNPACKJOB  POSITION(194:194)  CHAR,
CONNECTJOB  POSITION(195:195)  CHAR,
STICKYALBUMJOB  POSITION(196:196)  CHAR,
PAYSTATUS   POSITION(197:197)  CHAR,
ORIGINALDATERECEIVED  POSITION(198:207) DATE "/MM/DD" NULLIF
ORIGINALDATERE,
CM

Re: Analyzing a Trigger for Performance

2002-08-21 Thread Suzy Vordos


If the trigger does DML, check that it's written to not fire for
replicated transactions, just local ones, using
DBMS_REPUTIL.FROM_REMOTE.  

[EMAIL PROTECTED] wrote:
> 
> Hi,
> 
> I had noticed that one of our triggers is performing very badly.  I had disabled the 
>trigger to test replication and there was a issue with the trigger. When the 
>developer changed the trigger and enabled it, replication slowed down to one record 
>per second (other tables are being updated, instered, and deleted from).
> 
> I analyzed the plans for all sql statements generated in the trigger itself 
>and they are all using the correct indices etc.  There are no full table scans etc.  
>We have simliar trigger on our other replicated tables that are not seeing THIS bad 
>performance.
> 
> Any one have any suggestions/links for putting this trigger through the 
>paces to determine the bottleneck?
> 
> Thanks,
> 
> Hannah
> --
> 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: Suzy Vordos
  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: PL/Sql question

2002-08-21 Thread Mercadante, Thomas F

Dennis,

Try changing your insert statement to:

 insert into JOBOFFERFACT_LOAD 
(LIFETOUCHID, SOURCEFISCALYEAR, JOBNBR, PACKAGEID,
 MARKETINGCODE,
 TERRITORYCODE, PLANTRECEIPTDATE, SEASON, PACKAGENAME,
 PACKAGEPRICE,
 PAIDPACKAGEQTY, UNPAIDPACKAGEQTY, SHIPPEDPACKAGEQTY, CMSNTYPE,
 PACKAGECMSNRATE, PACKAGETYPE, PACKAGECHARGEBACK, 
 PACKAGEPOINTS, PACKAGECODE, PACKAGECONFIG) 
   VALUES
(LIFETOUCHID, CURRENTFY, JOBNBR, PKGID, rtrim(MARKETINGCODE,'
'),
 TERRITORYCODE, PLANTRECEIPTDATE, SEASON, PKGNAME, PACKAGEPRICE,
 PAIDPACKAGES, UNPAIDPACKAGES, SHIPPEDPACKAGES, CMSNTYPE, 
 PACKAGECMSN, PACKAGETYPE, PACKAGECHARGEBACK, 
 PACKAGEPOINTS, PKGCODE, PKGCONFIG ) ;


Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Wednesday, August 21, 2002 2:04 PM
To: Multiple recipients of list ORACLE-L


In response to the questions for more details, here are the PL/SQL code and
SQL Loader control file. Everything is varchar2(2), explicitly defined as
such in PL/SQL. Thanks for all the nice replies.

PL/SQL snippets


<...snip...>

   marketingcodeVARCHAR2(3);

<...snip...>

FILELOCATION := '/usr/users/madmload/text_files';
OPEN_MODE:= 'r';
FILENAME := 'prodload.txt';

FILENBR := UTL_FILE.FOPEN (FILELOCATION , FILENAME, OPEN_MODE );

<...snip...>

   UTL_FILE.GET_LINE (FILENBR, OUTPUTSTRING);
   marketingcode := substr(outputstring, 21, 3);
 

<...snip...>

 insert into JOBOFFERFACT_LOAD 
(LIFETOUCHID, SOURCEFISCALYEAR, JOBNBR, PACKAGEID,
MARKETINGCODE,
 TERRITORYCODE, PLANTRECEIPTDATE, SEASON, PACKAGENAME,
PACKAGEPRICE,
 PAIDPACKAGEQTY, UNPAIDPACKAGEQTY, SHIPPEDPACKAGEQTY, CMSNTYPE,
 PACKAGECMSNRATE, PACKAGETYPE, PACKAGECHARGEBACK, 
 PACKAGEPOINTS, PACKAGECODE, PACKAGECONFIG) VALUES
(LIFETOUCHID, CURRENTFY, JOBNBR, PKGID, MARKETINGCODE,
 TERRITORYCODE, PLANTRECEIPTDATE, SEASON, PKGNAME, PACKAGEPRICE,
 PAIDPACKAGES, UNPAIDPACKAGES, SHIPPEDPACKAGES, CMSNTYPE, 
 PACKAGECMSN, PACKAGETYPE, PACKAGECHARGEBACK, 
 PACKAGEPOINTS, PKGCODE, PKGCONFIG ) ;





Sql*Loader script

LOAD DATA
INFILE '/usr/users/madmload/joblid.txt'
BADFILE '/usr/users/madmload/jobload.bad'
APPEND
INTO TABLE JOBFACT
(
JOBNBR  POSITION(1:10)  CHAR, 
LIFETOUCHID POSITION(11:20) INTEGER EXTERNAL,
MDRPRIMARYIDPOSITION(21:28) CHAR,
MARKETINGCODE   POSITION(29:31) CHAR,
SUBPROGRAMCODE  POSITION(32:32) CHAR,
TERRITORYCODE   POSITION(33:34) CHAR,
SUBTERRITORYCODEPOSITION(33:36) CHAR,
SELLINGMETHODCODE   POSITION(37:37) CHAR,
BIDIND  POSITION(38:38) CHAR,
PDKIND  POSITION(39:39) CHAR,
PDKPARTNBR  POSITION(40:44) CHAR,
RETAKEIND   POSITION(45:45) CHAR,
PLANTCODE   POSITION(46:46) CHAR,
PLANTRECEIPTDATEPOSITION(47:56) DATE "/MM/DD" NULLIF
PLANTRECEIPTDA,
PLANTRECEIPTYEARPOSITION(47:50) INTEGER EXTERNAL,
PLANTRECEIPTMONTH   POSITION(52:53) INTEGER EXTERNAL,
PHOTOGRAPHYDATE POSITION(57:66) DATE "/MM/DD" NULLIF
PHOTOGRAPHYDATE=BLANKS,
SHIPDATEPOSITION(67:76) DATE "/MM/DD" NULLIF SHIPDATE=BLANKS,
SHOTQTY POSITION(77:80) INTEGER EXTERNAL,
SHIPPEDPACKAGEQTY   POSITION(81:84) INTEGER EXTERNAL,
PAIDPACKAGEQTY  POSITION(85:88) INTEGER EXTERNAL,
UNPAIDPACKAGEQTYPOSITION(89:92) INTEGER EXTERNAL,
XNOPURCHASEQTY  POSITION(93:96) INTEGER EXTERNAL,
CASHRECEIVEDAMT POSITION(97:105)DECIMAL EXTERNAL,
CASHRETAINEDAMT POSITION(106:114)   DECIMAL EXTERNAL,
ACCTCMSNPAIDAMT POSITION(115:123)   DECIMAL EXTERNAL,
ESTACCTCMSNAMT  POSITION(124:132)   DECIMAL EXTERNAL,
CHARGEBACKAMT   POSITION(133:141)   DECIMAL EXTERNAL,
SALESTAXAMT POSITION(142:150)   DECIMAL EXTERNAL,
TERRITORYCMSNAMTPOSITION(151:159)   DECIMAL EXTERNAL,
TERRITORYEARNINGSAMTPOSITION(160:168)   DECIMAL EXTERNAL,
EXPECTEDCASHAMT POSITION(169:177)   DECIMAL EXTERNAL,
SOURCEFISCALYEARCONSTANT '2003',
PROOFPOSE   POSITION(178:178)   DECIMAL EXTERNAL,
PROOFCOUNT  POSITION(179:182)DECIMAL EXTERNAL,
SEASONDESC  POSITION(183:183)DECIMAL EXTERNAL,
EXTRACTDATE POSITION(184:193) DATE "/MM/DD" NULLIF
EXTRACTDATE=BLANKS,
FUNPACKJOB  POSITION(194:194)  CHAR,
CONNECTJOB  POSITION(195:195)  CHAR,
STICKYALBUMJOB  POSITION(196:196)  CHAR,
PAYSTATUS   POSITION(197:197)  CHAR,
ORIGINALDATERECEIVED  POSITION(198:207) DATE "/MM/DD" NULLIF
ORIGINALDATERE,
CMSNSTATUS  POSITION(208:208) CHAR
)


==


All tables have the marketingcode field defined as varchar2(3)  (none are
char(3))


Bruce
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]

Fat City Network S

RE: :STATEMENT

2002-08-21 Thread Bob Metelsky
Title: Message



Yes, I thougt the 
same thing... here is a site that will give clear direction of installing 
modules
 
http://perl.about.com/library/weekly/aa030500a.htm
 
They 
cover ppm and  perl -MCPAN -e shell  
 
check out all the 
links on this page
 bob 


RE: Catching errors on inserts

2002-08-21 Thread Bob Metelsky


Ok Im having a problem with this

[from init.ora]
user_dump_dest = D:\db_track2data\admin\LTRACK2\udump

[recommended from a user on this list]
select name, value
from v$parameter
where name like '%dump%' ; 

NAME VALUE

---
background_dump_dest
D:\db_track2data\admin\LTRACK2\bdump
user_dump_dest
D:\db_track2data\admin\LTRACK2\udump
max_dump_file_size   204800

3 rows selected.

~

I run
SQL> alter session set events='0001  trace name errorstack forever,
level 10' ;
Session altered

I run the 10K insert script which contains many errors

No TRC file gets created in the above dir or any place for that matter

I search for *.trc and "no files found" 
There must be a problem with my syntax in the alter session does anyone
see a problem

Thanks
bob

> check your init.ora setting for user_dump_dest (I believe).
> 
> Anjo.
> 
> - Original Message - 
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Wednesday, August 21, 2002 8:43 PM
> 
> 
> > > It is in the session trace file not the alert log file.
> > > 
> > 
> > Where would I find this file?
> > 
> > Many thanks in advance
> > bob
> > > Anjo.
> > > 
> > > 
> > > On Wednesday 21 August 2002 16:38, you wrote:
> > > > Gogala
> > > >
> > > > Thanks for the tip this seems like just what I'm
> > > looking for, however
> > > > I must be doing something wrong as no errors are getting
> > > written to my
> > > > alrt.log
> > > >
> > > > Im running oracle 8.16 server on win2kpro (this is a development
> > > > database)
> > > >
> > > > I just got around  to running/testing this from my post 
> last week
> > > >
> > > > I do
> > > > SQL> alter session set events='0001  trace name errorstack 
> > > > SQL> forever,
> > > > level 10';
> > > >
> > > > Session altered.
> > > >
> > > > Then I run the offending insert script which show errors
> > > being thrown
> > > >
> > > > I check the alrt.log in BDUMP dir and all it show are
> > > my regular
> > > > .ORA logs being written EG
> > > > Wed Aug 21 09:19:07 2002
> > > > Thread 1 advanced to log sequence 3240
> > > >   Current log# 4 seq# 3240 mem# 0: 
> > > > D:\DB_TRACK2DATA\ORADATA\LTRACK2\LOG4LTRACK2.ORA
> > > > Thread 1 advanced to log sequence 3241
> > > >   Current log# 1 seq# 3241 mem# 0: 
> > > > D:\DB_TRACK2DATA\ORADATA\LTRACK2\LOG1LTRACK2.ORA
> > > > Thread 1 advanced to log sequence 3242
> > > >   Current log# 2 seq# 3242 mem# 0: 
> > > > D:\DB_TRACK2DATA\ORADATA\LTRACK2\LOG2LTRACK2.ORA
> > > > Thread 1 advanced to log sequence 3243
> > > >
> > > > Also checked the alrt.log in Oracle\home\database
> > > Nothing written
> > > > there
> > > >
> > > > What am I missing?
> > > >
> > > > > alter session set events='0001  trace name errorstack
> > > forever, level
> > > > > 10'; All "duplicate value" errors will then be trapped in the
> > > > > alert.log file. You can always substitute your own 
> > > favorite error in
> > > > > place of 0001.
> > > >
> > > > Also If you have a extra min how can I substitute the error 
> > > > message?
> > > >
> > > > Thanks for your help
> > > >
> > > > Bob
> > > 
> > > 
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > -- 
> > > Author: Anjo Kolk
> > >   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: Bob Metelsky
> >   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: Anjo Kolk
>   INET: [EMAIL PROTECTED]
> 
> Fat City Network Services-- (858) 538-5051  FAX: (858) 538-505

Re: Moving Oracle 9i / Windows 2000 Database to Red Hat Linux

2002-08-21 Thread Ron Rogers

Dharminder, 
  You will need the 9i disks for RedHat and then create a database on
the Linux box and export the data or  "insert as select" from the Win
2000 database.
There is no simple method of going across platforms.
Ron
ROR mª¿ªm

>>> [EMAIL PROTECTED] 08/21/02 04:24PM >>>
I want to move the Windows 2000/ Oracle 9i database to Linux Red Hat
7.1/
Oracle 8.1.6. Please suggest the options.

Thanks.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com 
-- 
Author: Dharminder Kumar
  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: Ron Rogers
  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).



Analyzing a Trigger for Performance

2002-08-21 Thread johanna . doran

Hi,

I had noticed that one of our triggers is performing very badly.  I had disabled the 
trigger to test replication and there was a issue with the trigger. When the developer 
changed the trigger and enabled it, replication slowed down to one record per second 
(other tables are being updated, instered, and deleted from).

I analyzed the plans for all sql statements generated in the trigger itself 
and they are all using the correct indices etc.  There are no full table scans etc.  
We have simliar trigger on our other replicated tables that are not seeing THIS bad 
performance.

Any one have any suggestions/links for putting this trigger through the paces 
to determine the bottleneck?

Thanks,

Hannah
--
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).



Re: FW: PL/Sql question

2002-08-21 Thread mkb

Geez, after re-reading my post, it seems that it
didn't make much sense to me, so to clarify...

I had a cursor in my procedure that took as an IN
param a varchar2 variable.  The cursor failed to
return any rows because in my where clause I was
comparing a char field against a varchar2 variable.  I
then decided to create a local variable of type char
and assigned my IN varchar2 variable to the local char
variable.  Using this in my cursors where clause I was
then able to get rows back.

There, sounds much better.

mkb

--- mkb <[EMAIL PROTECTED]> wrote:
> um...just a thought but how about setting
> marketingcode to char(3) in the PL/SQL code snippet.
> 
> I ran into this similar problem a couple days ago. 
> Had a var as varchar2 in PL/SQL but in the table it
> was char.  Changed my PL/SQL var to char, cursor in
> my
> code worked with ltrim and rtrim functions whereas
> before it wasn't.
> 
> hth
> 
> mkb
> 
> --- DENNIS WILLIAMS <[EMAIL PROTECTED]> wrote:
> > In response to the questions for more details,
> here
> > are the PL/SQL code and
> > SQL Loader control file. Everything is
> varchar2(2),
> > explicitly defined as
> > such in PL/SQL. Thanks for all the nice replies.
> > 
> > PL/SQL snippets
> > 
> > 
> > <...snip...>
> > 
> >marketingcodeVARCHAR2(3);
> > 
> > <...snip...>
> > 
> > FILELOCATION :=
> > '/usr/users/madmload/text_files';
> > OPEN_MODE:= 'r';
> > FILENAME := 'prodload.txt';
> > 
> > FILENBR := UTL_FILE.FOPEN (FILELOCATION ,
> > FILENAME, OPEN_MODE );
> > 
> > <...snip...>
> > 
> >UTL_FILE.GET_LINE (FILENBR, OUTPUTSTRING);
> >marketingcode := substr(outputstring, 21,
> 3);
> >  
> > 
> > <...snip...>
> > 
> >  insert into JOBOFFERFACT_LOAD 
> > (LIFETOUCHID, SOURCEFISCALYEAR,
> JOBNBR,
> > PACKAGEID,
> > MARKETINGCODE,
> >  TERRITORYCODE, PLANTRECEIPTDATE,
> > SEASON, PACKAGENAME,
> > PACKAGEPRICE,
> >  PAIDPACKAGEQTY, UNPAIDPACKAGEQTY,
> > SHIPPEDPACKAGEQTY, CMSNTYPE,
> >  PACKAGECMSNRATE, PACKAGETYPE,
> > PACKAGECHARGEBACK, 
> >  PACKAGEPOINTS, PACKAGECODE,
> > PACKAGECONFIG) VALUES
> > (LIFETOUCHID, CURRENTFY, JOBNBR,
> PKGID,
> > MARKETINGCODE,
> >  TERRITORYCODE, PLANTRECEIPTDATE,
> > SEASON, PKGNAME, PACKAGEPRICE,
> >  PAIDPACKAGES, UNPAIDPACKAGES,
> > SHIPPEDPACKAGES, CMSNTYPE, 
> >  PACKAGECMSN, PACKAGETYPE,
> > PACKAGECHARGEBACK, 
> >  PACKAGEPOINTS, PKGCODE, PKGCONFIG ) ;
> > 
> > 
> > 
> > 
> > 
> > Sql*Loader script
> > 
> > LOAD DATA
> > INFILE '/usr/users/madmload/joblid.txt'
> > BADFILE '/usr/users/madmload/jobload.bad'
> > APPEND
> > INTO TABLE JOBFACT
> > (
> > JOBNBR  POSITION(1:10)  CHAR, 
> > LIFETOUCHID POSITION(11:20) INTEGER EXTERNAL,
> > MDRPRIMARYIDPOSITION(21:28) CHAR,
> > MARKETINGCODE   POSITION(29:31) CHAR,
> > SUBPROGRAMCODE  POSITION(32:32) CHAR,
> > TERRITORYCODE   POSITION(33:34) CHAR,
> > SUBTERRITORYCODEPOSITION(33:36) CHAR,
> > SELLINGMETHODCODE   POSITION(37:37) CHAR,
> > BIDIND  POSITION(38:38) CHAR,
> > PDKIND  POSITION(39:39) CHAR,
> > PDKPARTNBR  POSITION(40:44) CHAR,
> > RETAKEIND   POSITION(45:45) CHAR,
> > PLANTCODE   POSITION(46:46) CHAR,
> > PLANTRECEIPTDATEPOSITION(47:56) DATE
> > "/MM/DD" NULLIF
> > PLANTRECEIPTDA,
> > PLANTRECEIPTYEARPOSITION(47:50) INTEGER
> > EXTERNAL,
> > PLANTRECEIPTMONTH   POSITION(52:53) INTEGER
> > EXTERNAL,
> > PHOTOGRAPHYDATE POSITION(57:66) DATE "/MM/DD"
> > NULLIF
> > PHOTOGRAPHYDATE=BLANKS,
> > SHIPDATEPOSITION(67:76) DATE "/MM/DD"
> > NULLIF SHIPDATE=BLANKS,
> > SHOTQTY POSITION(77:80) INTEGER EXTERNAL,
> > SHIPPEDPACKAGEQTY   POSITION(81:84) INTEGER
> > EXTERNAL,
> > PAIDPACKAGEQTY  POSITION(85:88) INTEGER EXTERNAL,
> > UNPAIDPACKAGEQTYPOSITION(89:92) INTEGER
> > EXTERNAL,
> > XNOPURCHASEQTY  POSITION(93:96) INTEGER EXTERNAL,
> > CASHRECEIVEDAMT POSITION(97:105)DECIMAL
> > EXTERNAL,
> > CASHRETAINEDAMT POSITION(106:114)   DECIMAL
> > EXTERNAL,
> > ACCTCMSNPAIDAMT POSITION(115:123)   DECIMAL
> > EXTERNAL,
> > ESTACCTCMSNAMT  POSITION(124:132)   DECIMAL
> > EXTERNAL,
> > CHARGEBACKAMT   POSITION(133:141)   DECIMAL
> > EXTERNAL,
> > SALESTAXAMT POSITION(142:150)   DECIMAL
> > EXTERNAL,
> > TERRITORYCMSNAMTPOSITION(151:159)  
> > DECIMAL EXTERNAL,
> > TERRITORYEARNINGSAMTPOSITION(160:168)  
> > DECIMAL EXTERNAL,
> > EXPECTEDCASHAMT POSITION(169:177)   DECIMAL
> > EXTERNAL,
> > SOURCEFISCALYEARCONSTANT '2003',
> > PROOFPOSE   POSITION(178:178)   DECIMAL
> > EXTERNAL,
> > PROOFCOUNT  POSITION(179:182)DECIMAL
> > EXTERNAL,
> > SEASONDESC  POSITION(183:183)DECIMAL
> > EXTERNAL,
> > EXTRACTDATE POSITION(184:193) DATE
> "/MM/DD"
> > NULLIF
> > EXTRACTDATE=BLANKS,
> > FUNPACKJOB  POSITION(194:194)  CHAR,
> > CONNECTJOB  

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

2002-08-21 Thread DENNIS WILLIAMS

Kumar 
   Ummm . . . are you using any 9i features? I'm assuming you have
considered using 9i on Red Hat. Sounds like probably use the 8i export
function to create the export file. I'm assuming the data involved is small
enough to make export/import practical. If you create a Net8 connection, you
can just copy the data.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]


-Original Message-
Sent: Wednesday, August 21, 2002 3:24 PM
To: Multiple recipients of list ORACLE-L
8.1.6


I want to move the Windows 2000/ Oracle 9i database to Linux Red Hat 7.1/
Oracle 8.1.6. Please suggest the options.

Thanks.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Dharminder Kumar
  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: DENNIS WILLIAMS
  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: Index move

2002-08-21 Thread DENNIS WILLIAMS

Seema - My interpretation of your question is that you are asking whether
having the indexes for a table on a separate physical would increase
performance.
 
Since this was a standard recommendation for many years, I feel it merits a
more detailed reply.
 
If you have an OLTP benchmarking situation with a single table that is
being read randomly using the index, then I would expect that moving the
index to a separate physical drive would increase performance significantly.
I have not tested this directly that I can recall, but I believe this was
based on benchmarks. The reason related to the idea that this arrangement
would minimize disk head movement. If the index and table are on the same
disk, likely they will reside on different positions on the disk. The
concern is that random accesses would be slowed by the time it took to
reposition the disk drive head from one location to another. This is a
mechanical device, so movement inevitably takes time. So, why isn't this
practice emphasized today? Here are the reasons I can think of:
 
1. Benchmarking is not production. A production OLTP system has many
simultaneous users accessing many tables. This tends to obscure the benefits
of table/index placement.
2. Full table scans don't use the index (by definition), so don't benefit
from this placement strategy.
3. Modern systems usually use RAID drives which are more complex, obscuring
the benefits of this strategy.
4. Caching inside Oracle (block buffers) and in the I/O system itself also
obscure the benefits of this simplistic strategy.
 
Personally I perform this placement whenever it is convenient but I don't
make a fetish of it. One practical reason for doing this is when you rebuild
an index, the performance benefits are noticeable. But how often do you
rebuild indexes?
 
 Hi 
Is any performance gain/impact if I move unique indexes from one tablespace 
to another tablespace if both tablespaces are on diffrent physical disk?
Thanks 
-Seema 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: DENNIS WILLIAMS
  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: double quotes column name

2002-08-21 Thread Jared . Still

You missed the 'or' in my sentence.

Maybe I should use || ?   ;)

Jared





"Marul Mehta" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
08/21/2002 01:03 PM
Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:Re: double quotes column name


I guess this is not the case.

1. create table t("TABLE" Varchar2(10));
2. select table_name,column_name from user_tab_columns where 
table_name='T';

TABLE_NAME COLUMN_NAME
-- --
T  TABLE

Even though TABLE is a reserved word it appeared in uppercase when
user_tab_columns was queried.

Marul.


- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, August 21, 2002 11:38 PM


> > how can we know that this table is created with "" column name
>
> When the column name is a reserved word, or appears with lower
> case characters.
>
> Jared
>
>
>
>
>
>
> "Harvinder Singh" <[EMAIL PROTECTED]>
> Sent by: [EMAIL PROTECTED]
> 08/21/2002 09:28 AM
> Please respond to ORACLE-L
>
>
> To: Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>
> cc:
> Subject:double quotes column name
>
>
> Hi,
>
> One of our clients has created a table with column name "access"
> since access is reserved word , they use double quotes.
> but when i query the table user_tab_columns it is still showing column
> name as access and not "access"
> how can we know that this table is created with "" column name..
>
> Thanks
> --Harvinder
>
>
> SQL> select table_name,column_name from user_tab_columns
>   2  where table_name='FF1'
>   3  /
>
> TABLE_NAME COLUMN_NAME
> -- --
> FF1access
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Harvinder Singh
>   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: Marul Mehta
  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).



Re: Catching errors on inserts

2002-08-21 Thread Igor Neyman

udump directory

Igor Neyman, OCP DBA
[EMAIL PROTECTED]
  


- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, August 21, 2002 2:43 PM


> It is in the session trace file not the alert log file.
> 

Where would I find this file?

Many thanks in advance
bob
> Anjo.
> 
> 
> On Wednesday 21 August 2002 16:38, you wrote:
> > Gogala
> >
> > Thanks for the tip this seems like just what I'm 
> looking for, however 
> > I must be doing something wrong as no errors are getting 
> written to my 
> > alrt.log
> >
> > Im running oracle 8.16 server on win2kpro (this is a development
> > database)
> >
> > I just got around  to running/testing this from my post last week
> >
> > I do
> > SQL> alter session set events='0001  trace name errorstack forever,
> > level 10';
> >
> > Session altered.
> >
> > Then I run the offending insert script which show errors 
> being thrown
> >
> > I check the alrt.log in BDUMP dir and all it show are  
> my regular 
> > .ORA logs being written EG
> > Wed Aug 21 09:19:07 2002
> > Thread 1 advanced to log sequence 3240
> >   Current log# 4 seq# 3240 mem# 0:
> > D:\DB_TRACK2DATA\ORADATA\LTRACK2\LOG4LTRACK2.ORA
> > Thread 1 advanced to log sequence 3241
> >   Current log# 1 seq# 3241 mem# 0:
> > D:\DB_TRACK2DATA\ORADATA\LTRACK2\LOG1LTRACK2.ORA
> > Thread 1 advanced to log sequence 3242
> >   Current log# 2 seq# 3242 mem# 0:
> > D:\DB_TRACK2DATA\ORADATA\LTRACK2\LOG2LTRACK2.ORA
> > Thread 1 advanced to log sequence 3243
> >
> > Also checked the alrt.log in Oracle\home\database 
> Nothing written 
> > there
> >
> > What am I missing?
> >
> > > alter session set events='0001  trace name errorstack 
> forever, level 
> > > 10'; All "duplicate value" errors will then be trapped in the 
> > > alert.log file. You can always substitute your own 
> favorite error in 
> > > place of 0001.
> >
> > Also If you have a extra min how can I substitute the error message?
> >
> > Thanks for your help
> >
> > Bob
> 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Anjo Kolk
>   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: Bob Metelsky
  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: Igor Neyman
  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: Cannot start database (already running)

2002-08-21 Thread Scott . Shafer

Or go into svrmgrl, connect internal, issue a shutdown abort, then startup.

Scott Shafer
San Antonio, TX
210-581-6217


> -Original Message-
> From: Hately Mike [SMTP:[EMAIL PROTECTED]]
> Sent: Wednesday, August 21, 2002 2:04 PM
> To:   Multiple recipients of list ORACLE-L
> Subject:  RE: Cannot start database (already running)
> 
> Barb,
> check for an LK file in your $ORACLE_HOME/dbs directory too. If
> it's
> there, delete it. 
> Just another thing to try.
> 
> Regards,
> Mike Hately
> 
> -Original Message-
> Sent: Wednesday, August 21, 2002 11:34 AM
> To: Multiple recipients of list ORACLE-L
> 
> 
> 
> Oracle 8.0.5
> Solaris 2.6
> HA Cluster 2.1
> 
> This is wacky.
> Any ideas on this one (other than reboot the box)???
> I cannot start up this database (claims it's already running).
> Clearly it is not.  No background processes for this instance.  The only
> process I see even remotely related to this database is the oracledesi
> process.  (I don't know what that process is.)
> 
> I do have a semaphore set for oracle.  Should I remove it? (I normally
> have
> other databases on this box, but I've shut them all down.)
> 
> This database worked fine till a network device was ripped out from under
> it, and the HA stuff kicked in and failed it over.
> 
> Any ideas?  Thanks for any help
> 
> Barb
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Vergara, Michael (TEM)
>   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).
> 
> 
>  
> __
> __
>  
> 
> This email and any attached to it are confidential and intended only for
> the
> individual or 
> entity to which it is addressed.  If you are not the intended recipient,
> please let us know 
> by telephoning or emailing the sender.  You should also delete the email
> and
> any attachment 
> from your systems and should not copy the email or any attachment or
> disclose their content 
> to any other person or entity.  The views expressed here are not
> necessarily
> those of 
> Churchill Insurance Group plc or its affiliates or subsidiaries. Thank
> you. 
> Churchill Insurance Group plc.  Company Registration Number - 2280426.
> England. 
> Registered Office: Churchill Court, Westmoreland Road, Bromley, Kent BR1
> 1DP. 
> 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Hately Mike
>   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).



RE: Senware AutoDBA

2002-08-21 Thread Karniotis, Stephen

I'll add to John's comments.  It took John, Kirti & myself to keep Gaja calm
during the presentation.  Once we all walked out, Gaja went outside and
vented.  Their solution is unusual as they believe that performance can
optimized by adding hardware to the solution.

Thank You

Stephen P. Karniotis
Product Architect
Compuware Corporation
Direct: (248) 865-4350
Mobile: (248) 408-2918
Email:  [EMAIL PROTECTED]
Web:www.compuware.com

 -Original Message-
Sent:   Wednesday, August 21, 2002 3:24 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: Senware AutoDBA

FWIW, someone from Senware presented a paper at IOUG 2002 titled
'Performance management from the ground up' (or somthing like that) which
was a load of &*$% to say the least. Most of the audience (many on this
list) walked out in disgust after the first 10 minutes (Does someone
remember the 'green peas' story?) If their product is even twice as good as
their rep, it would not be worth considering.

I am not blaming their desperate tactics however. Anything to sell a product
in this economy :(  Just came off a marketing call on the office phone for
services I don't need!

John

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, August 21, 2002 11:04 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: Senware AutoDBA
> 
> 
> Interesting web site.
> 
> They claim to eliminate chained rows by rebuilding the tables.
> I'd like to see how they intend to do that.
> 
> They also claim that their product can detect corrupt indexes
> and rebuild them.  How hard can it be to detect ORA-1578?
> This kind of thing is fairly rare, and hardly seems worth the
> resources to run DBMS_REPAIR or dbv to check for.
> 
> Their MO is hardly new.  IBM has had a team in place for years
> designed to make an end run around the purchasing mgr/DBA/whoever
> when their product wasn't selected.  They go to upper mgt to
> try and convince them of the foolish mistake the product 
> evaluators made.
> 
> Not surprising that others follow their lead.
> 
> Jared
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: John Kanagaraj
  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).



The contents of this e-mail are intended for the named addressee only. It
contains information that may be confidential. Unless you are the named
addressee or an authorized designee, you may not copy or use it, or disclose
it to anyone else. If you received it in error please notify us immediately
and then destroy it. 

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



Moving Oracle 9i / Windows 2000 Database to Red Hat Linux 7.1 / 8.1.6

2002-08-21 Thread Dharminder Kumar

I want to move the Windows 2000/ Oracle 9i database to Linux Red Hat 7.1/
Oracle 8.1.6. Please suggest the options.

Thanks.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Dharminder Kumar
  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: FW: PL/Sql question

2002-08-21 Thread mkb

um...just a thought but how about setting
marketingcode to char(3) in the PL/SQL code snippet.

I ran into this similar problem a couple days ago. 
Had a var as varchar2 in PL/SQL but in the table it
was char.  Changed my PL/SQL var to char, cursor in my
code worked with ltrim and rtrim functions whereas
before it wasn't.

hth

mkb

--- DENNIS WILLIAMS <[EMAIL PROTECTED]> wrote:
> In response to the questions for more details, here
> are the PL/SQL code and
> SQL Loader control file. Everything is varchar2(2),
> explicitly defined as
> such in PL/SQL. Thanks for all the nice replies.
> 
> PL/SQL snippets
> 
> 
> <...snip...>
> 
>marketingcodeVARCHAR2(3);
> 
> <...snip...>
> 
> FILELOCATION :=
> '/usr/users/madmload/text_files';
> OPEN_MODE:= 'r';
> FILENAME := 'prodload.txt';
> 
> FILENBR := UTL_FILE.FOPEN (FILELOCATION ,
> FILENAME, OPEN_MODE );
> 
> <...snip...>
> 
>UTL_FILE.GET_LINE (FILENBR, OUTPUTSTRING);
>marketingcode := substr(outputstring, 21, 3);
>  
> 
> <...snip...>
> 
>  insert into JOBOFFERFACT_LOAD 
> (LIFETOUCHID, SOURCEFISCALYEAR, JOBNBR,
> PACKAGEID,
> MARKETINGCODE,
>  TERRITORYCODE, PLANTRECEIPTDATE,
> SEASON, PACKAGENAME,
> PACKAGEPRICE,
>  PAIDPACKAGEQTY, UNPAIDPACKAGEQTY,
> SHIPPEDPACKAGEQTY, CMSNTYPE,
>  PACKAGECMSNRATE, PACKAGETYPE,
> PACKAGECHARGEBACK, 
>  PACKAGEPOINTS, PACKAGECODE,
> PACKAGECONFIG) VALUES
> (LIFETOUCHID, CURRENTFY, JOBNBR, PKGID,
> MARKETINGCODE,
>  TERRITORYCODE, PLANTRECEIPTDATE,
> SEASON, PKGNAME, PACKAGEPRICE,
>  PAIDPACKAGES, UNPAIDPACKAGES,
> SHIPPEDPACKAGES, CMSNTYPE, 
>  PACKAGECMSN, PACKAGETYPE,
> PACKAGECHARGEBACK, 
>  PACKAGEPOINTS, PKGCODE, PKGCONFIG ) ;
> 
> 
> 
> 
> 
> Sql*Loader script
> 
> LOAD DATA
> INFILE '/usr/users/madmload/joblid.txt'
> BADFILE '/usr/users/madmload/jobload.bad'
> APPEND
> INTO TABLE JOBFACT
> (
> JOBNBR  POSITION(1:10)  CHAR, 
> LIFETOUCHID POSITION(11:20) INTEGER EXTERNAL,
> MDRPRIMARYIDPOSITION(21:28) CHAR,
> MARKETINGCODE   POSITION(29:31) CHAR,
> SUBPROGRAMCODE  POSITION(32:32) CHAR,
> TERRITORYCODE   POSITION(33:34) CHAR,
> SUBTERRITORYCODEPOSITION(33:36) CHAR,
> SELLINGMETHODCODE   POSITION(37:37) CHAR,
> BIDIND  POSITION(38:38) CHAR,
> PDKIND  POSITION(39:39) CHAR,
> PDKPARTNBR  POSITION(40:44) CHAR,
> RETAKEIND   POSITION(45:45) CHAR,
> PLANTCODE   POSITION(46:46) CHAR,
> PLANTRECEIPTDATEPOSITION(47:56) DATE
> "/MM/DD" NULLIF
> PLANTRECEIPTDA,
> PLANTRECEIPTYEARPOSITION(47:50) INTEGER
> EXTERNAL,
> PLANTRECEIPTMONTH   POSITION(52:53) INTEGER
> EXTERNAL,
> PHOTOGRAPHYDATE POSITION(57:66) DATE "/MM/DD"
> NULLIF
> PHOTOGRAPHYDATE=BLANKS,
> SHIPDATEPOSITION(67:76) DATE "/MM/DD"
> NULLIF SHIPDATE=BLANKS,
> SHOTQTY POSITION(77:80) INTEGER EXTERNAL,
> SHIPPEDPACKAGEQTY   POSITION(81:84) INTEGER
> EXTERNAL,
> PAIDPACKAGEQTY  POSITION(85:88) INTEGER EXTERNAL,
> UNPAIDPACKAGEQTYPOSITION(89:92) INTEGER
> EXTERNAL,
> XNOPURCHASEQTY  POSITION(93:96) INTEGER EXTERNAL,
> CASHRECEIVEDAMT POSITION(97:105)DECIMAL
> EXTERNAL,
> CASHRETAINEDAMT POSITION(106:114)   DECIMAL
> EXTERNAL,
> ACCTCMSNPAIDAMT POSITION(115:123)   DECIMAL
> EXTERNAL,
> ESTACCTCMSNAMT  POSITION(124:132)   DECIMAL
> EXTERNAL,
> CHARGEBACKAMT   POSITION(133:141)   DECIMAL
> EXTERNAL,
> SALESTAXAMT POSITION(142:150)   DECIMAL
> EXTERNAL,
> TERRITORYCMSNAMTPOSITION(151:159)  
> DECIMAL EXTERNAL,
> TERRITORYEARNINGSAMTPOSITION(160:168)  
> DECIMAL EXTERNAL,
> EXPECTEDCASHAMT POSITION(169:177)   DECIMAL
> EXTERNAL,
> SOURCEFISCALYEARCONSTANT '2003',
> PROOFPOSE   POSITION(178:178)   DECIMAL
> EXTERNAL,
> PROOFCOUNT  POSITION(179:182)DECIMAL
> EXTERNAL,
> SEASONDESC  POSITION(183:183)DECIMAL
> EXTERNAL,
> EXTRACTDATE POSITION(184:193) DATE "/MM/DD"
> NULLIF
> EXTRACTDATE=BLANKS,
> FUNPACKJOB  POSITION(194:194)  CHAR,
> CONNECTJOB  POSITION(195:195)  CHAR,
> STICKYALBUMJOB  POSITION(196:196)  CHAR,
> PAYSTATUS   POSITION(197:197)  CHAR,
> ORIGINALDATERECEIVED  POSITION(198:207) DATE
> "/MM/DD" NULLIF
> ORIGINALDATERE,
> CMSNSTATUS  POSITION(208:208) CHAR
> )
> 
> 
> ==
> 
> 
> All tables have the marketingcode field defined as
> varchar2(3)  (none are
> char(3))
> 
> 
> Bruce
> -- 
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> -- 
> Author: DENNIS WILLIAMS
>   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] (n

Re: Catching errors on inserts

2002-08-21 Thread Anjo Kolk

check your init.ora setting for user_dump_dest (I believe).

Anjo.

- Original Message - 
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, August 21, 2002 8:43 PM


> > It is in the session trace file not the alert log file.
> > 
> 
> Where would I find this file?
> 
> Many thanks in advance
> bob
> > Anjo.
> > 
> > 
> > On Wednesday 21 August 2002 16:38, you wrote:
> > > Gogala
> > >
> > > Thanks for the tip this seems like just what I'm 
> > looking for, however 
> > > I must be doing something wrong as no errors are getting 
> > written to my 
> > > alrt.log
> > >
> > > Im running oracle 8.16 server on win2kpro (this is a development
> > > database)
> > >
> > > I just got around  to running/testing this from my post last week
> > >
> > > I do
> > > SQL> alter session set events='0001  trace name errorstack forever,
> > > level 10';
> > >
> > > Session altered.
> > >
> > > Then I run the offending insert script which show errors 
> > being thrown
> > >
> > > I check the alrt.log in BDUMP dir and all it show are  
> > my regular 
> > > .ORA logs being written EG
> > > Wed Aug 21 09:19:07 2002
> > > Thread 1 advanced to log sequence 3240
> > >   Current log# 4 seq# 3240 mem# 0:
> > > D:\DB_TRACK2DATA\ORADATA\LTRACK2\LOG4LTRACK2.ORA
> > > Thread 1 advanced to log sequence 3241
> > >   Current log# 1 seq# 3241 mem# 0:
> > > D:\DB_TRACK2DATA\ORADATA\LTRACK2\LOG1LTRACK2.ORA
> > > Thread 1 advanced to log sequence 3242
> > >   Current log# 2 seq# 3242 mem# 0:
> > > D:\DB_TRACK2DATA\ORADATA\LTRACK2\LOG2LTRACK2.ORA
> > > Thread 1 advanced to log sequence 3243
> > >
> > > Also checked the alrt.log in Oracle\home\database 
> > Nothing written 
> > > there
> > >
> > > What am I missing?
> > >
> > > > alter session set events='0001  trace name errorstack 
> > forever, level 
> > > > 10'; All "duplicate value" errors will then be trapped in the 
> > > > alert.log file. You can always substitute your own 
> > favorite error in 
> > > > place of 0001.
> > >
> > > Also If you have a extra min how can I substitute the error message?
> > >
> > > Thanks for your help
> > >
> > > Bob
> > 
> > 
> > -- 
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > -- 
> > Author: Anjo Kolk
> >   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: Bob Metelsky
>   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: Anjo Kolk
  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: Cannot start database (already running)

2002-08-21 Thread Ruth Gramolini

Did you try shutdown abort?  That should do it. But remember to startup
restrict, shutdown normal, startup to allow smon to do his thing.

HTH<
Ruth
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, August 21, 2002 2:33 PM


>
> Oracle 8.0.5
> Solaris 2.6
> HA Cluster 2.1
>
> This is wacky.
> Any ideas on this one (other than reboot the box)???
> I cannot start up this database (claims it's already running).
> Clearly it is not.  No background processes for this instance.  The only
> process I see even remotely related to this database is the oracledesi
> process.  (I don't know what that process is.)
>
> I do have a semaphore set for oracle.  Should I remove it? (I normally
have
> other databases on this box, but I've shut them all down.)
>
> This database worked fine till a network device was ripped out from under
> it, and the HA stuff kicked in and failed it over.
>
> Any ideas?  Thanks for any help
>
> Barb
>
> atex-tad3> ps -ef | grep pmon
>   oracle  1604 23498  0 11:16:54 pts/30:00 grep pmon
>
> atex-tad3> ps -ef | grep -i desi
>   oracle 17319 1  0   Aug 15 ?0:00 oracledesi (LOCAL=NO)
>   oracle  1621 23498  0 11:17:02 pts/30:00 grep -i desi
>
> atex-tad3> svrmgrl
> Oracle Server Manager Release 3.0.5.0.0 - Production
> Oracle8 Enterprise Edition Release 8.0.5.2.1 - Production
> With the Partitioning and Objects options
> PL/SQL Release 8.0.5.2.0 - Production
>
> SVRMGR> connect internal
> Connected.
> SVRMGR> startup
> ORA-01081: cannot start already-running ORACLE - shut it down first
>
> atex-tad3> ipcs -b
> IPC status from  as of Wed Aug 21 11:28:38 2002
> Message Queue facility not in system.
> T ID  KEYMODEOWNERGROUP  SEGSZ
> Shared Memory:
> m  0   0x5e45 --rw-r--r-- root root 68
> m  1   0x2de8bf84 --rw-r-   oracle  dba   43458560
> m202   0x00280267 --rw-r--r-- root root1048576
> T ID  KEYMODEOWNERGROUP NSEMS
> Semaphores:
> s  0    --ra-r-   oracle  dba   100
> s 327681   0x00280269 --ra-ra-ra- root root14
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Baker, Barbara
>   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: Ruth Gramolini
  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: drop tablespace including contents

2002-08-21 Thread Brooks, Russ

Yeah, that's what I do too.  I just wish it wouldn't clobber the stats on
the indices after I've so carefully gathered them.  We have the 6.2 sapdba,
so I don't think it's using dbastatc as much to control when and how it does
the stats.

Russ

-Original Message-
Sent: Wednesday, August 21, 2002 1:59 PM
To: Multiple recipients of list ORACLE-L


Ironically, analyzing tables is one of the jobs I leave up to SAPDBA.

There are a number of tables that shouldn't be analyzed, ( ~150
on my system ) and the system knows which ones they are.

Just schedule the job through transaction DB13 and forget about it.

Jared






paquette stephane <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
08/20/2002 09:48 PM
Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:Re:drop tablespace including contents


At one client, one team was using SAP without a DBA,
only the SAP administrator using SAPDBA. They were
having poor performance.

After 2-3 days they came to see me, after 5 minutes I
told them that 4000 tables out of 16 000 were having
no statistics at all. They analyzed during the weekend
and performance was pretty good 



 --- [EMAIL PROTECTED] a écrit : > Dick,
> 
> There is absolutely *nothing* that SAPDBA does that
> a reasonably
> knowledgeable DBA can't do from his of her favorite
> toolset.
> ( vi, Perl and sqlplus for me :)
> 
> SAP types have it drummed into their heads that the
> only proper
> way to do anything DBA work is via SAPDBA.
> 
> I refuse to use it, and it just drives the SAP
> consultants crazy. 
> 
> There are many cases where a good DBA can do a much
> better
> job than SAPDBA.  The tablespace reorganization is a
> good
> example.  Trying to 'drop tablespace including
> contents' with 
> 3500 tables is not a terribly bright way of going
> about it.
> 
> 
> Jared
> 
> 
> 
> 
> 
> 
> 
> [EMAIL PROTECTED]
> Sent by: [EMAIL PROTECTED]
> 08/20/2002 02:43 PM
> Please respond to ORACLE-L
> 
> 
> To: Multiple recipients of list ORACLE-L
> <[EMAIL PROTECTED]>
> cc: 
> Subject:Re:drop tablespace including
> contents
> 
> 
> Russ,
> 
> Your high usage of RBS was due to the updates
> being done to the system 
> data
> dictionary.  Since you were dropping a tablespace
> and contents the DDL
> statements for the individual objects (tables and
> indexes) needs to be 
> done
> first, but I've a funny idea from practice that
> Oracle does not do an 
> implicit
> commit in this case but instead holds on till the
> end.  This makes 
> dropping a
> tablespace with the "including contents" caviot very
> nasty.  Thank GOD we 
> never
> implemented SAP over here.  I've heard nothing but
> bad about SAP and 
> sapdba.
> 
> Dick Goulet
> 
> Reply
> Separator
> Author: "Brooks; Russ" <[EMAIL PROTECTED]>
> Date:   8/20/2002 11:13 AM
> 
> Hi, 
> This past weekend we experienced a problem on a
> production database, and I 
> would
> like to try to determine what went wrong, how to
> avoid it in the future, 
> and any
> better ways of dealing with it should it be
> encountered again. 
> After moving some large objects out of tablespace to
> spread I/O, we wanted 
> to
> reorganize the old tablespace to remove some
> fragmentation. The tool we 
> were
> using, sapdba, does not readily permit you to drop
> the individual tables 
> between
> the export and the drop tablespace including
> contents. Since the 
> tablespace had
> over 3500 tables the drop tablespace was expected to
> take a long time. We 
> also
> defined a large rollback segment for use this
> weekend, although with only
> maxextents of 100. When Oracle tried to allocate the
> 101 extent in the 
> RBS,
> error messages were issued and things came to a
> grinding halt. sar 
> indicated
> disk I/O to the new RBS, but not to any of the
> datafiles. We waited 
> several
> hours, but the situation did not appear to change. 
> Shutdown immediate did not work. We could alter the
> datafiles back online, 
> but
> not the tablespace. Since it was production, the
> decision was made to 
> restore to
> a recent backup. 
> 1. Was the rollback activity due solely to storing
> and restoring DDL for 
> the
> tables and indices? 
> 2. Once the RBS was unable to extend, was the drop
> tablespace including 
> contents
> dead? We tried to alter maxextents on the RBS, but
> did not get a response 
> from
> the system. Was that the appropriate reaction to
> this problem. 
> 3. A join of v$session and v$sql did not indicate
> any active SQL. How 
> should we
> have monitored the progress of what we assume was
> rollback activity?   Any 
> way
> to estimate how much or how long the rollback would
> take?
> 4. If the database were shutdown during the rollback
> I assume the rollback 
> would
> recommence when Oracle came back up.  Would it start
> where it left off or 
> start
> from scratch.  It was my im

Re: double quotes column name

2002-08-21 Thread Marul Mehta

I guess this is not the case.

1. create table t("TABLE" Varchar2(10));
2. select table_name,column_name from user_tab_columns where table_name='T';

TABLE_NAME COLUMN_NAME
-- --
T  TABLE

Even though TABLE is a reserved word it appeared in uppercase when
user_tab_columns was queried.

Marul.


- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, August 21, 2002 11:38 PM


> > how can we know that this table is created with "" column name
>
> When the column name is a reserved word, or appears with lower
> case characters.
>
> Jared
>
>
>
>
>
>
> "Harvinder Singh" <[EMAIL PROTECTED]>
> Sent by: [EMAIL PROTECTED]
> 08/21/2002 09:28 AM
> Please respond to ORACLE-L
>
>
> To: Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>
> cc:
> Subject:double quotes column name
>
>
> Hi,
>
> One of our clients has created a table with column name "access"
> since access is reserved word , they use double quotes.
> but when i query the table user_tab_columns it is still showing column
> name as access and not "access"
> how can we know that this table is created with "" column name..
>
> Thanks
> --Harvinder
>
>
> SQL> select table_name,column_name from user_tab_columns
>   2  where table_name='FF1'
>   3  /
>
> TABLE_NAME COLUMN_NAME
> -- --
> FF1access
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Harvinder Singh
>   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: Marul Mehta
  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: :STATEMENT

2002-08-21 Thread Brooks, Russ

Point taken.  I'll redirect the question.

Russ

-Original Message-
Sent: Wednesday, August 21, 2002 1:53 PM
To: Multiple recipients of list ORACLE-L


It looks like there's a number of people on this list 
that could benefit from subscribing to the Perl DBI list:

http://lists.perl.org/showlist.cgi?name=dbi-users

Jared






"Bob Metelsky" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
08/21/2002 08:23 AM
Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:RE: :STATEMENT


Did you run the perl makefile.pl
 
cd dir\downloaded\fromppm\eg\.cpan\source\mymodule
 
make
make test
 
make install 
 
 
For win32 you have to download and use nmake from microsoft
 
bob
 
 
Hi,
  Has anyone played with Perl's SQL::STATEMENT?  I pulled it down with 
ppm, and the sample to evaluate the where clause gives the error:
 
Can't locate object method "where" via package "SQL::Statement" (perhaps 
you forgot to load "SQL::Statement"?) at test_sql.plx line 37.
 
And yes, I included a use SQL::STATEMENT; 
 
Cheers,
Russ


-- 
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: Brooks, Russ
  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: how to reduce SQL*Net more data to client wait event

2002-08-21 Thread Anjo Kolk



No,
 
this is "to client", so it is the result of a query 
(either to many columns or too many rows returned).
Large SQL statements would result in "from client" 
during the Parse phase and if people keep on parsing the same statement, the 
client side will keep on sending it to the server. Parse once/execute many 

 
Anjo.

  - Original Message - 
  From: 
  Johnson, Michael 
  To: Multiple recipients of list ORACLE-L 
  
  Sent: Wednesday, August 21, 2002 9:10 
  PM
  Subject: RE: how to reduce SQL*Net more 
  data to client wait event
  
  Tim,   more specifically could large SQL 
  have been passed across
  the 
  net ?   Stored procedures could help here.
   
  FWIW.
   
  Mike
  
-Original Message-From: Tim Gorman 
[mailto:[EMAIL PROTECTED]]Sent: Wednesday, August 21, 2002 12:03 
AMTo: Multiple recipients of list ORACLE-LSubject: Re: 
how to reduce SQL*Net more data to client wait event
Depending on the application, couldn't 
these large pauses be performance problems in the client 
program?  Not a server tuning issue nor a SQL*Net tuning issue at 
all?  For example, if the client program was pausing a long time 
between FETCH commands, processing previously fetched data?  Or would 
that just be accounted for under "SQL*Net message from client" 
events?

  - Original Message - 
  From: 
  Suhen Pather 
  To: Multiple recipients of list 
  ORACLE-L 
  Sent: Monday, August 19, 2002 8:08 
  PM
  Subject: how to reduce SQL*Net more 
  data to client wait event
  
  
  Hi,
   
  I am tuning a system at a 
  client site and notice lots of waits for SQL*Net 
  more data to client (97%) for a fraction 
  of the CPU consumed by the 
  system.
   
  I know this is not to be 
  characterized as an idle wait event and can yield better performance if we 
  increase
  the packet 
  size.
  The database is Oracle 7.3.4 
  (SQL Net 2.3).  What effect will increasing TDU and SDU have 
  
  on this wait to increase 
  packet size.
   
  It seems that if we can reduce this wait then we 
  can save lots of time (I Think).
   
  Will using BEQ protocol help at 
  all.
    
  Regards
  Suhen   
   
   


RE: List of all zip codes,city,state to load into table.

2002-08-21 Thread Magaliff, Bill

 The USPS department called AMS (Address Management Service) sells this data
in subscription format - we get it monthly.  Don't know cost, and data is
provided in ascii file that you the load into a table of your design.  We
use SQL Loader for the piece we need and it loads (with truncate existing
data) in about a minute.

I think their website is something like ribbs.usps.com . . .

bill

-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 8/21/02 9:13 AM

Hi All,

Where can I get a list of all zip codes,city,states to load into a
table. I
have searched but cannot find anything to download.
Anyone have a URL that I can get this info.

Thanks
Rick


-- 
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: Magaliff, Bill
  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: Cannot start database (already running)

2002-08-21 Thread Hately Mike

Barb,
check for an LK file in your $ORACLE_HOME/dbs directory too. If it's
there, delete it. 
Just another thing to try.

Regards,
Mike Hately

-Original Message-
Sent: Wednesday, August 21, 2002 11:34 AM
To: Multiple recipients of list ORACLE-L



Oracle 8.0.5
Solaris 2.6
HA Cluster 2.1

This is wacky.
Any ideas on this one (other than reboot the box)???
I cannot start up this database (claims it's already running).
Clearly it is not.  No background processes for this instance.  The only
process I see even remotely related to this database is the oracledesi
process.  (I don't know what that process is.)

I do have a semaphore set for oracle.  Should I remove it? (I normally have
other databases on this box, but I've shut them all down.)

This database worked fine till a network device was ripped out from under
it, and the HA stuff kicked in and failed it over.

Any ideas?  Thanks for any help

Barb

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


 

 

This email and any attached to it are confidential and intended only for the
individual or 
entity to which it is addressed.  If you are not the intended recipient,
please let us know 
by telephoning or emailing the sender.  You should also delete the email and
any attachment 
from your systems and should not copy the email or any attachment or
disclose their content 
to any other person or entity.  The views expressed here are not necessarily
those of 
Churchill Insurance Group plc or its affiliates or subsidiaries. Thank you. 
Churchill Insurance Group plc.  Company Registration Number - 2280426.
England. 
Registered Office: Churchill Court, Westmoreland Road, Bromley, Kent BR1
1DP. 


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



Cannot start database (already running)

2002-08-21 Thread Baker, Barbara


Oracle 8.0.5
Solaris 2.6
HA Cluster 2.1

This is wacky.
Any ideas on this one (other than reboot the box)???
I cannot start up this database (claims it's already running).
Clearly it is not.  No background processes for this instance.  The only
process I see even remotely related to this database is the oracledesi
process.  (I don't know what that process is.)

I do have a semaphore set for oracle.  Should I remove it? (I normally have
other databases on this box, but I've shut them all down.)

This database worked fine till a network device was ripped out from under
it, and the HA stuff kicked in and failed it over.

Any ideas?  Thanks for any help

Barb

atex-tad3> ps -ef | grep pmon
  oracle  1604 23498  0 11:16:54 pts/30:00 grep pmon

atex-tad3> ps -ef | grep -i desi
  oracle 17319 1  0   Aug 15 ?0:00 oracledesi (LOCAL=NO)
  oracle  1621 23498  0 11:17:02 pts/30:00 grep -i desi

atex-tad3> svrmgrl
Oracle Server Manager Release 3.0.5.0.0 - Production
Oracle8 Enterprise Edition Release 8.0.5.2.1 - Production
With the Partitioning and Objects options
PL/SQL Release 8.0.5.2.0 - Production

SVRMGR> connect internal
Connected.
SVRMGR> startup
ORA-01081: cannot start already-running ORACLE - shut it down first

atex-tad3> ipcs -b
IPC status from  as of Wed Aug 21 11:28:38 2002
Message Queue facility not in system.
T ID  KEYMODEOWNERGROUP  SEGSZ
Shared Memory:
m  0   0x5e45 --rw-r--r-- root root 68
m  1   0x2de8bf84 --rw-r-   oracle  dba   43458560
m202   0x00280267 --rw-r--r-- root root1048576
T ID  KEYMODEOWNERGROUP NSEMS
Semaphores:
s  0    --ra-r-   oracle  dba   100
s 327681   0x00280269 --ra-ra-ra- root root14

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Baker, Barbara
  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: Senware AutoDBA

2002-08-21 Thread John Kanagaraj

FWIW, someone from Senware presented a paper at IOUG 2002 titled
'Performance management from the ground up' (or somthing like that) which
was a load of &*$% to say the least. Most of the audience (many on this
list) walked out in disgust after the first 10 minutes (Does someone
remember the 'green peas' story?) If their product is even twice as good as
their rep, it would not be worth considering.

I am not blaming their desperate tactics however. Anything to sell a product
in this economy :(  Just came off a marketing call on the office phone for
services I don't need!

John

> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, August 21, 2002 11:04 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: Senware AutoDBA
> 
> 
> Interesting web site.
> 
> They claim to eliminate chained rows by rebuilding the tables.
> I'd like to see how they intend to do that.
> 
> They also claim that their product can detect corrupt indexes
> and rebuild them.  How hard can it be to detect ORA-1578?
> This kind of thing is fairly rare, and hardly seems worth the
> resources to run DBMS_REPAIR or dbv to check for.
> 
> Their MO is hardly new.  IBM has had a team in place for years
> designed to make an end run around the purchasing mgr/DBA/whoever
> when their product wasn't selected.  They go to upper mgt to
> try and convince them of the foolish mistake the product 
> evaluators made.
> 
> Not surprising that others follow their lead.
> 
> Jared
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: John Kanagaraj
  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: Catching errors on inserts

2002-08-21 Thread Bob Metelsky

> It is in the session trace file not the alert log file.
> 

Where would I find this file?

Many thanks in advance
bob
> Anjo.
> 
> 
> On Wednesday 21 August 2002 16:38, you wrote:
> > Gogala
> >
> > Thanks for the tip this seems like just what I'm 
> looking for, however 
> > I must be doing something wrong as no errors are getting 
> written to my 
> > alrt.log
> >
> > Im running oracle 8.16 server on win2kpro (this is a development
> > database)
> >
> > I just got around  to running/testing this from my post last week
> >
> > I do
> > SQL> alter session set events='0001  trace name errorstack forever,
> > level 10';
> >
> > Session altered.
> >
> > Then I run the offending insert script which show errors 
> being thrown
> >
> > I check the alrt.log in BDUMP dir and all it show are  
> my regular 
> > .ORA logs being written EG
> > Wed Aug 21 09:19:07 2002
> > Thread 1 advanced to log sequence 3240
> >   Current log# 4 seq# 3240 mem# 0:
> > D:\DB_TRACK2DATA\ORADATA\LTRACK2\LOG4LTRACK2.ORA
> > Thread 1 advanced to log sequence 3241
> >   Current log# 1 seq# 3241 mem# 0:
> > D:\DB_TRACK2DATA\ORADATA\LTRACK2\LOG1LTRACK2.ORA
> > Thread 1 advanced to log sequence 3242
> >   Current log# 2 seq# 3242 mem# 0:
> > D:\DB_TRACK2DATA\ORADATA\LTRACK2\LOG2LTRACK2.ORA
> > Thread 1 advanced to log sequence 3243
> >
> > Also checked the alrt.log in Oracle\home\database 
> Nothing written 
> > there
> >
> > What am I missing?
> >
> > > alter session set events='0001  trace name errorstack 
> forever, level 
> > > 10'; All "duplicate value" errors will then be trapped in the 
> > > alert.log file. You can always substitute your own 
> favorite error in 
> > > place of 0001.
> >
> > Also If you have a extra min how can I substitute the error message?
> >
> > Thanks for your help
> >
> > Bob
> 
> 
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: Anjo Kolk
>   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: Bob Metelsky
  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: drop tablespace including contents

2002-08-21 Thread Brooks, Russ

Mike,
  I've made the pitch before and will again.  Wish me luck.

Russ

-Original Message-
Sent: Wednesday, August 21, 2002 11:39 AM
To: Multiple recipients of list ORACLE-L


Russ,

You have my sympathies.  I've been managing SAP databases for the last 7
years, and the last time I let SAPDBA control a reorg was 6.95 years ago.
It performs some tasks reasonably well, like datafile additions and managing
CBO statistics refreshes (especially since SAP wants certain tables to be
left without statistics).  But for reorgs, I prefer more direct control.
Perhaps you can use this SNAFU to convince management to have sapdba
generate the scripts, then allow you to modified them appropriately.  

Mike Hand
Polaroid Corp.

-Original Message-
Sent: Wednesday, August 21, 2002 9:03 AM
To: Multiple recipients of list ORACLE-L


I fully agree.  Unfortunately management insists on it.

Russ

-Original Message-
Sent: Tuesday, August 20, 2002 9:13 PM
To: Multiple recipients of list ORACLE-L


Dick,

There is absolutely *nothing* that SAPDBA does that a reasonably
knowledgeable DBA can't do from his of her favorite toolset.
( vi, Perl and sqlplus for me :)
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Hand, Michael T
  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: Brooks, Russ
  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: PL/SQl question

2002-08-21 Thread Karniotis, Stephen

I believe it is acting appropriately.  You are trying to load a
two-"character" byte filed into three-byte "character" field.  Loader, if
you don't terminate by whitespace or nulls, will add the blank into the
field because it is character.  

Thus, you have two options:
1. Change the field to numeric.
2. Trim the data before it is loaded.  Check the third position to see if it
is a space or null; if so, only load n positions of data.

Thank You

Stephen P. Karniotis
Product Architect
Compuware Corporation
Direct: (248) 865-4350
Mobile: (248) 408-2918
Email:  [EMAIL PROTECTED]
Web:www.compuware.com

 -Original Message-
Sent:   Wednesday, August 21, 2002 12:33 PM
To: Multiple recipients of list ORACLE-L
Subject:RE: PL/SQl question

Dennis,

In your PL/SQL program, did you try the RTRIM(date_field,' ') command? 

I know that TRIM is new, but I thought it needed additional parameters to
tell it what to trim.

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Wednesday, August 21, 2002 10:28 AM
To: Multiple recipients of list ORACLE-L



> I have a question for from one of my developers related to PL/SQL and how
> data is loaded.
> 
> I have a field (marketcode) that is defined as VARCHAR2(3).
> 
> I have a problem when I try to load the value of '20' into this field.
> All values with three characters work fine.  The problem is when the value
> is less then 3 characters.   
> 
> When tables A and B have data loaded into this field using SQL/Loader the
> resulting value in the field appears to me as '20' with the third position
> =null.
> 
> I have a separate PL/SQL process that loads this field into table C.
> When PL/SQL populates this same value into this field the field appears to
> me as '20' with the third position = space.   I can't use SQL/Loader for
> this table as the data needs to be massaged before loading into Oracle.
> Thus when you try to link the tables together it does not find a match.
> 
>   select A.marketcode, C.marketcode
>   from tableA A, tableC C
>  where A.marketcode=C.marketcode;
>   
> (this returns 0 records)
> 
>  If I change the SQl statement to the following:
> 
>   select A.marketcode, C.marketcode
>   from tableA A, tableC C
>  where A.marketcode=trim(C.marketcode);
> 
>  (it correctly matches these up)
>   
> Things I have tried to remedy this problem:
> 1)  I have tried to modify my PL/SQL program to put a TRIM statement
> around the marketcode field when I populate table C.   This did not work.
> 2)  I have tried to check the 3rd position and if it is = space then I set
> the third position to null.  But the field in Oracle is still a space when
> the program is finished.
> 
> Does anyone have any thoughts on how I can properly output this field from
> Pl/SQl so it will match the data loaded via SQL/Loader? Thanks.
> 
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: DENNIS WILLIAMS
  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: Mercadante, Thomas F
  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).



The contents of this e-mail are intended for the named addressee only. It
contains information that may be confidential. Unless you are the named
addressee or an authorized designee, you may not copy or use it, or disclose
it to anyone else. If you received it in error please notify us immediately
and then destroy it. 

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

RE: dbms_utility and dbms_stat difference

2002-08-21 Thread Madhavan Amruthur

Hi Cherie,

> I can't speak for dbms_utility but dbms_stats is supposed to generate
> statistics at both the partition level and at the table level for
> partitioned tables, which analyze does not do.   

A small correction, ANALYZE also generates statisics at partition level
and when an "analyze table  compute statistics" is done it
generates statistics for the partitions.
Analyze can also be run at the partition level as "analyze table 
part () compute statistics" and this will generate statistics
only for that paritition.
Its very useful as analyze can be run for the partitions of a table in
parallel and so its a blessing when running analyze on huge partitioned
tables.

One of the big differences between analyze and dbms_stats is that
analye cannot be run in parallel on a non partitioned table and
definitely runs better in my opinion in general.

Hope this helps.
Regards,

Madhavan
http://www.dpapps.com
-- 
Madhavan Amruthur
DecisionPoint Applications

-- 
http://fastmail.fm
 - In the time it takes you to read this, you could be FastMailing
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Madhavan Amruthur
  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: how to reduce SQL*Net more data to client wait event

2002-08-21 Thread Johnson, Michael



Tim,   more specifically could large SQL have 
been passed across
the 
net ?   Stored procedures could help here.
 
FWIW.
 
Mike

  -Original Message-From: Tim Gorman 
  [mailto:[EMAIL PROTECTED]]Sent: Wednesday, August 21, 2002 12:03 
  AMTo: Multiple recipients of list ORACLE-LSubject: Re: 
  how to reduce SQL*Net more data to client wait event
  Depending on the application, couldn't 
  these large pauses be performance problems in the client 
  program?  Not a server tuning issue nor a SQL*Net tuning issue at 
  all?  For example, if the client program was pausing a long time between 
  FETCH commands, processing previously fetched data?  Or would 
  that just be accounted for under "SQL*Net message from client" 
  events?
  
- Original Message - 
From: 
Suhen Pather 
To: Multiple recipients of list ORACLE-L 

Sent: Monday, August 19, 2002 8:08 
PM
Subject: how to reduce SQL*Net more 
data to client wait event


Hi,
 
I am tuning a system at a client 
site and notice lots of waits for SQL*Net 
more data to client (97%) for a fraction 
of the CPU consumed by the system.
 
I know this is not to be 
characterized as an idle wait event and can yield better performance if we 
increase
the packet 
size.
The database is Oracle 7.3.4 
(SQL Net 2.3).  What effect will increasing TDU and SDU have 

on this wait to increase packet 
size.
 
It seems that if we can reduce this wait then we can 
save lots of time (I Think).
 
Will using BEQ protocol help at 
all.
  
Regards
Suhen   
 
 


RE: simple problem

2002-08-21 Thread Jamadagni, Rajendra

Yup, exactly that's what I meant.

Raj
__
Rajendra Jamadagni  MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.

QOTD: Any clod can have facts, but having an opinion is an art!


-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Wednesday, August 21, 2002 2:19 PM
To: Multiple recipients of list ORACLE-L




Raj,

Is this what you meant and what you would get?

SQL> get 1
  1  select m.id, cast(multiset(select fname
  2 from t s
  3 where s.id = m.id) as mystrtype) as fnamelst
  4  from t1 m
  5* group by id
SQL> /

ID FNAMELST
-- --
 1 MYSTRTYPE('RAM', 'SHAM', 'PAT')
 2 MYSTRTYPE('MAN', 'JOHN')

Chaim


*This e-mail 
message is confidential, intended only for the named recipient(s) above and may 
contain information that is privileged, attorney work product or exempt from 
disclosure under applicable law. If you have received this message in error, or are 
not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 
and delete this e-mail message from your computer, Thank 
you.*2



Re: double quotes column name

2002-08-21 Thread Jared . Still

> how can we know that this table is created with "" column name

When the column name is a reserved word, or appears with lower
case characters.

Jared






"Harvinder Singh" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
08/21/2002 09:28 AM
Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:double quotes column name


Hi, 

One of our clients has created a table with column name "access" 
since access is reserved word , they use double quotes. 
but when i query the table user_tab_columns it is still showing column 
name as access and not "access" 
how can we know that this table is created with "" column name.. 

Thanks 
--Harvinder 


SQL> select table_name,column_name from user_tab_columns
  2  where table_name='FF1'
  3  /

TABLE_NAME COLUMN_NAME
-- --
FF1access
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Harvinder Singh
  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).



UTF-16

2002-08-21 Thread MacGregor, Ian A.

So I set NLS_LANG to AL16UTF16?  I'd like the note to be more explicit.   I thought 
that would be the value to which I would set the "character set" argument of the 
create  database command.  The two are not the same.  For instance the  "character 
set" argument of the "create database" might be WE8ISO8859P1; whereas the NLS_LANG 
variable might be American_America.WE8ISO8859P1.  So I'm guessing, 
American_America.AL16UTF16 for the NLS_LANG variable?

As I understand UTF16 it takes 16 bits to encode each character.  This should result 
in more disk storage being required to store the same amount of information.  I also 
understand the varchar2 fields are  character-based; there is no need to increase the 
length of a varchar2 field which switching from 7/8 bit encoding to 16 bit; however, 
char fields are byte-based and would need to have their lengths altered.  One would 
need a char(60) field  to hold 30 characters encoded with UTF16.

I'm not sure what is mean by 

Since 9i and upwards, we support UTF-16 encoding at column level as
national
(alternative) database character set. In 9i, the UTF-16 encoding Oracle
character set AL16UTF16 has even become the default character set for
SQL NCHAR
data types.

How can I use that to my advantage?

My problem stems mainly from Intermedia.  The inso_filtering converts the document to  
the base character set for the database.  This is not too bad when Cerenkov loses the 
diacritical mark over the 'C' and is thus rendered as I have written it here.  It's 
not good at all when  a ligature such as the 'fl' in reflection is lost so that the 
filter converts in to 
re ection.

There is obviously a cost  of going to a 16 bit encoding system.  Twice as many bits 
need to be read to get the same information out.  The information which contains the 
special characters is stored in a BLOB.  I wouldn't think that character sets mattered 
to BLOBs at all.  However,  character set certainly does matter to the 
DR$$I  tokens of an "Intermedia Index".

I would certainly count myself as  a member of the ignorant masses when it comes to 
character sets.  If anything I have stated is untrue, or untrue under certain 
conditions, I'd sure like to know.

Ian MacGregor





-Original Message-
Sent: Tuesday, August 20, 2002 2:35 PM
To: LazyDBA.com Discussion


>From Note 77443.1 on metalink:

UTF-16 SUPPORT 
--
Since 9i and upwards, we support UTF-16 encoding at column level as
national
(alternative) database character set. In 9i, the UTF-16 encoding Oracle
character set AL16UTF16 has even become the default character set for
SQL NCHAR
datatypes.


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: MacGregor, Ian A.
  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: :STATEMENT

2002-08-21 Thread Brooks, Russ
Title: Message



Thanks 
Bob.  I thought if you pulled the module through ppm that was not 
necessary.
 
Russ

  -Original Message-From: Bob Metelsky 
  [mailto:[EMAIL PROTECTED]]Sent: Wednesday, August 21, 2002 11:24 
  AMTo: Multiple recipients of list ORACLE-LSubject: RE: 
  :STATEMENT
  Did 
  you run the perl makefile.pl
   
  cd 
  dir\downloaded\fromppm\eg\.cpan\source\mymodule
   
  make
  make 
  test
   
  make 
  install 
   
   
  For 
  win32 you have to download and use nmake from microsoft
   
  bob
   
   
  
Hi,
  Has 
anyone played with Perl's SQL::STATEMENT?  I pulled it down with ppm, 
and the sample to evaluate the where clause gives the 
error:
 
Can't locate 
object method "where" via package "SQL::Statement" (perhaps you forgot to 
load "SQL::Statement"?) at test_sql.plx line 37.
 
And yes, I 
included a use SQL::STATEMENT; 
 
Cheers,
Russ


Oracle Applications Hanging

2002-08-21 Thread Naveen Nahata

Hi All, 

I'm using 11.0.3 with 8.0.5 on Windows NT SP4 

Every once in a while, the users complain that they cannot login into the
applications. At that time I observe that the process WWWLSNR30.exe in the
application server is taking too much of CPU(more than 50%). 

No matter how much time I wait, it keeps on utilizing the CPU and the server
doesn't service any connect requests. 

Even when I shut down all the Apps Services, it still remains. I have to
restart the server again. 

What can be the cause of the problem, and how to remedy it? Since I'm running
production and test on the same server how to find out to which Application
the process is attached?

Regards,
Naveen
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Naveen Nahata
  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: Encryption of data

2002-08-21 Thread Jared . Still

But the data would be *very* secure.

Jared





"Tim Gorman" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
08/21/2002 12:03 AM
Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:Re: Encryption of data


I imagine they lost their job soon thereafter...  :-)
- Original Message - 
To: Multiple recipients of list ORACLE-L 
Sent: Tuesday, August 20, 2002 11:05 AM

What about encrypting the entire tablespace? has anybody tried this 
before?
 
Thanks,
Marul
- Original Message - 
To: Multiple recipients of list ORACLE-L 
Sent: Sunday, August 11, 2002 11:04 AM

Try dbms_obfuscation_toolkit.It supports DES, DES3 and MD5 encryption 
formats. You can use these for storing encrypted information in tables.
rgds 
amar 
http://amzone.netfirms.com 

-Original Message- 
Sent: Saturday, August 10, 2002 8:34 PM 
To: Multiple recipients of list ORACLE-L 

What is the best way to encrypt data in Oracle (like username/passwords, 
etc)? Is there a provision to encrypt the entire table/tablespace ? 
Thanks, 
Manav. 


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



Re: Senware AutoDBA

2002-08-21 Thread Jared . Still

Interesting web site.

They claim to eliminate chained rows by rebuilding the tables.
I'd like to see how they intend to do that.

They also claim that their product can detect corrupt indexes
and rebuild them.  How hard can it be to detect ORA-1578?
This kind of thing is fairly rare, and hardly seems worth the
resources to run DBMS_REPAIR or dbv to check for.

Their MO is hardly new.  IBM has had a team in place for years
designed to make an end run around the purchasing mgr/DBA/whoever
when their product wasn't selected.  They go to upper mgt to
try and convince them of the foolish mistake the product 
evaluators made.

Not surprising that others follow their lead.

Jared





[EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
08/21/2002 07:08 AM
Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:Re[2]:=?iso-8859-1?Q?A_friendly_reminder_-_AutoDBA_webcast_8


To all,

I don't often complain about vendors, but this is what I call 
exceptional
case.  I've no idea who the individual (not really the word I want to use) 
is,
but he came right out of the clear blue claiming to know who I was.  OK, 
so I
went to their web site & took a look at what they offer & was not 
interested for
a bunch of good reasons.  What does this damned person do, finds my CIO & 
sends
him the attached spam message.

Beware, this firm senware is on the top of mt trash pile.

Dick Goulet

Reply Separator
Author: 
Date:   8/21/2002 8:45 AM

Jack - I am forwarding this to the folks here who may be interested...

Doug

Reply Separator
Author: "=?iso-8859-1?Q?Jack_Wachtler?=" <[EMAIL PROTECTED]>
Date:   8/20/02 7:05 AM

Hi Douglas,

I sent you an email a couple weeks ago about getting someone at Vicor to 
review
our product.  We have a few open slots left in our upcoming webcasts (info
below).  Who would be the right person to attend?

To refresh your memory, our product, AutoDBA, can save you money, effort, 
and
hassle.  It gives your Oracle database people tremendous leverage and
efficiency, by automating all of the preventative maintenance your 
databases
need.

AutoDBA lets DBAs accomplish twice as much as they're doing now: storage
management, performance tuning, downtime avoidance, etc.  More info at
www.senware.com.

Our web-based product demos are short and informative, feature and 
technology
oriented rather than sales oriented.  Please forward this email to 
whomever at
Vicor you think would be interested, or reply and point me in the right
direction.

Again, thanks in advance.

Here's the information on the webcasts:

Dates:   Wednesday, Aug. 21 and Wednesday Aug. 28
Time:12:30 PDT (1:30 Mountain, 2:30 Central, 3:30 Eastern)

Instructions:
 Go to http://senware.raindance.com
 Click on "Participant Login"
 For Event Name, enter dba7924385
 For audio, dial 1-888-693-8686
 Enter audio ID 7924385

If you're interested, please reply back so I can reserve a spot for you.
Questions are welcome.  We can even do a custom savings analysis for your
organization.

Sincerely,

Jack Wachtler
Senware, Inc.
[EMAIL PROTECTED]
303-279-7626  x24


P.S.  Final thought: AutoDBA is definitely worth a look if you use Oracle. 
 It
monitors the DB and detects future problem areas, then generates custom 
scripts
to fix problems and manage the database.  The scripts are executed in a 
safe,
intelligent fashion, subject to your control, via a smart and simple user
interface.  For more info, drop me a line.  Thanks.


-- 
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: 
  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: DBA tools on NT - PERL

2002-08-21 Thread Jared . Still

Bob,

I don't have mine either.  :(

My editor just received a copy on Monday, so they have been printed,
and should be shipping now.

Jared






"Bob Metelsky" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
08/21/2002 08:23 AM
Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:RE: DBA tools on NT - PERL


I ve ordered the book from Oreilly about 2 weeks ago and at that time it 
was not avaiable.
http://www.oreilly.com/catalog/oracleperl/
 
Jared, do you know when the book will be shipped?  Im really looking 
forward to this. Ive setup the DBI and Oracle modules can connect and 
querry the database
the suspense is killing me.
 
 ;-) 
thanks
bob 
I am going to buy Jared book.
He wrote to me that the book is currently available on Amazon.
You can use www.perl.com to supplement tour needs.
 
Yechiel Adar
Mehish
- Original Message - 
To: Multiple recipients of list ORACLE-L 
Sent: Friday, August 16, 2002 7:53 PM

> -Original Message- 
> From: Pat Hildebrand [mailto:[EMAIL PROTECTED]] 
> 
> I'm not responding to any single message here but a few general 
> comments about perl. 
All right already! I'll quit using C/gcc and start using Perl! 
Is this the first book I need? 
Learning Perl, 3rd Edition 
Making Easy Things Easy and Hard Things Possible 
By Randal L. Schwartz, Tom Phoenix 
3rd Edition July 2001 
0-596-00132-0, Order Number: 1320 
http://www.oreilly.com/catalog/lperl3/ 


-- 
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).



RE: Odbc and reserve words

2002-08-21 Thread Fink, Dan

How about defining a view?

I know you can escape individual characters but I don't think you can do a
whole string.

-Original Message-
Sent: Wednesday, August 21, 2002 9:49 AM
To: Multiple recipients of list ORACLE-L


Hi,

One of our client has a table with column name "access".
Since access is reserver word...they use double quotes..
now when we try using ODBC to :
select access from table 
it gives error..but 
select "access" from table works..
But we want select access from table to work

IS there and escape sequence in ODBC where it will not give error for
reserved words..

Thanks
--Harvinder
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Harvinder Singh
  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: Fink, Dan
  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:drop tablespace including contents

2002-08-21 Thread Jared . Still

Ironically, analyzing tables is one of the jobs I leave up to SAPDBA.

There are a number of tables that shouldn't be analyzed, ( ~150
on my system ) and the system knows which ones they are.

Just schedule the job through transaction DB13 and forget about it.

Jared






paquette stephane <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
08/20/2002 09:48 PM
Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:Re:drop tablespace including contents


At one client, one team was using SAP without a DBA,
only the SAP administrator using SAPDBA. They were
having poor performance.

After 2-3 days they came to see me, after 5 minutes I
told them that 4000 tables out of 16 000 were having
no statistics at all. They analyzed during the weekend
and performance was pretty good 



 --- [EMAIL PROTECTED] a écrit : > Dick,
> 
> There is absolutely *nothing* that SAPDBA does that
> a reasonably
> knowledgeable DBA can't do from his of her favorite
> toolset.
> ( vi, Perl and sqlplus for me :)
> 
> SAP types have it drummed into their heads that the
> only proper
> way to do anything DBA work is via SAPDBA.
> 
> I refuse to use it, and it just drives the SAP
> consultants crazy. 
> 
> There are many cases where a good DBA can do a much
> better
> job than SAPDBA.  The tablespace reorganization is a
> good
> example.  Trying to 'drop tablespace including
> contents' with 
> 3500 tables is not a terribly bright way of going
> about it.
> 
> 
> Jared
> 
> 
> 
> 
> 
> 
> 
> [EMAIL PROTECTED]
> Sent by: [EMAIL PROTECTED]
> 08/20/2002 02:43 PM
> Please respond to ORACLE-L
> 
> 
> To: Multiple recipients of list ORACLE-L
> <[EMAIL PROTECTED]>
> cc: 
> Subject:Re:drop tablespace including
> contents
> 
> 
> Russ,
> 
> Your high usage of RBS was due to the updates
> being done to the system 
> data
> dictionary.  Since you were dropping a tablespace
> and contents the DDL
> statements for the individual objects (tables and
> indexes) needs to be 
> done
> first, but I've a funny idea from practice that
> Oracle does not do an 
> implicit
> commit in this case but instead holds on till the
> end.  This makes 
> dropping a
> tablespace with the "including contents" caviot very
> nasty.  Thank GOD we 
> never
> implemented SAP over here.  I've heard nothing but
> bad about SAP and 
> sapdba.
> 
> Dick Goulet
> 
> Reply
> Separator
> Author: "Brooks; Russ" <[EMAIL PROTECTED]>
> Date:   8/20/2002 11:13 AM
> 
> Hi, 
> This past weekend we experienced a problem on a
> production database, and I 
> would
> like to try to determine what went wrong, how to
> avoid it in the future, 
> and any
> better ways of dealing with it should it be
> encountered again. 
> After moving some large objects out of tablespace to
> spread I/O, we wanted 
> to
> reorganize the old tablespace to remove some
> fragmentation. The tool we 
> were
> using, sapdba, does not readily permit you to drop
> the individual tables 
> between
> the export and the drop tablespace including
> contents. Since the 
> tablespace had
> over 3500 tables the drop tablespace was expected to
> take a long time. We 
> also
> defined a large rollback segment for use this
> weekend, although with only
> maxextents of 100. When Oracle tried to allocate the
> 101 extent in the 
> RBS,
> error messages were issued and things came to a
> grinding halt. sar 
> indicated
> disk I/O to the new RBS, but not to any of the
> datafiles. We waited 
> several
> hours, but the situation did not appear to change. 
> Shutdown immediate did not work. We could alter the
> datafiles back online, 
> but
> not the tablespace. Since it was production, the
> decision was made to 
> restore to
> a recent backup. 
> 1. Was the rollback activity due solely to storing
> and restoring DDL for 
> the
> tables and indices? 
> 2. Once the RBS was unable to extend, was the drop
> tablespace including 
> contents
> dead? We tried to alter maxextents on the RBS, but
> did not get a response 
> from
> the system. Was that the appropriate reaction to
> this problem. 
> 3. A join of v$session and v$sql did not indicate
> any active SQL. How 
> should we
> have monitored the progress of what we assume was
> rollback activity?   Any 
> way
> to estimate how much or how long the rollback would
> take?
> 4. If the database were shutdown during the rollback
> I assume the rollback 
> would
> recommence when Oracle came back up.  Would it start
> where it left off or 
> start
> from scratch.  It was my impression that it is
> marking the header blocks 
> as it
> goes, but I would like to check.
> 
> Thanks, 
> Russ Brooks 
> 
>  Transitional//EN">
> 
> 
> 
> 
>  name=GENERATOR>
> 
> Hi, This past weekend we experienced a
> problem on a production 
> database, and I would like to try to determine what
> went wrong, how to 
> avoid it 
> in the future, and

RE: Cannot start database (already running)

2002-08-21 Thread Vergara, Michael (TEM)

Follow your instincts.  Use ipcrm and clear out those shared
memory segments.  Then it should start OK.


-Original Message-
Sent: Wednesday, August 21, 2002 11:34 AM
To: Multiple recipients of list ORACLE-L



Oracle 8.0.5
Solaris 2.6
HA Cluster 2.1

This is wacky.
Any ideas on this one (other than reboot the box)???
I cannot start up this database (claims it's already running).
Clearly it is not.  No background processes for this instance.  The only
process I see even remotely related to this database is the oracledesi
process.  (I don't know what that process is.)

I do have a semaphore set for oracle.  Should I remove it? (I normally have
other databases on this box, but I've shut them all down.)

This database worked fine till a network device was ripped out from under
it, and the HA stuff kicked in and failed it over.

Any ideas?  Thanks for any help

Barb

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



java.sql.SQLException: Io exception: Connection reset by peer: so

2002-08-21 Thread Michael Wu

Hello List,

Does anybody there know the following error message and how to resolve it?

java.sql.SQLException: Io exception: Connection reset by peer: socket write error


Environment

classes12.zip
Oracle 8.1.6.3
Solaris 2.8

Thanks,

Mike 


**
This e-mail contains privileged attorney-client communications and/or confidential 
information, and is only for the use by the intended recipient. Receipt by an 
unintended recipient does not constitute a waiver of any applicable privilege.

Reading, disclosure, discussion, dissemination, distribution or copying of this 
information by anyone other than the intended recipient or his or her employees or 
agents is strictly prohibited.  If you have received this communication in error, 
please immediately notify us and delete the original material from your computer.

Sempra Energy Trading Corp. (SET) is not the same company as SDG&E or SoCalGas, the 
utilities owned by SET's parent company.  SET is not regulated by the California 
Public Utilities Commission and you do not have to buy SET's products and services to 
continue to receive quality regulated service from the utilities.
**

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Michael Wu
  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: List of all zip codes,city,state to load into table.

2002-08-21 Thread Jesse, Rich

Interesting.  Apparently, my ZIP in a city of 24K people didn't make the
list.

I guess you get what you pay for.  :)

Rich Jesse   System/Database Administrator
[EMAIL PROTECTED]  Quad/Tech International, Sussex, WI USA

-Original Message-
Sent: Wednesday, August 21, 2002 10:18 AM
To: Multiple recipients of list ORACLE-L


Hi,  Hope this helps.  Its a text file, then you can load it using SQLloader
etc. 


http://www.cwpm.com/ZIP_DB.html 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jesse, Rich
  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: simple problem

2002-08-21 Thread Chaim . Katz



Raj,

Is this what you meant and what you would get?

SQL> get 1
  1  select m.id, cast(multiset(select fname
  2 from t s
  3 where s.id = m.id) as mystrtype) as fnamelst
  4  from t1 m
  5* group by id
SQL> /

ID FNAMELST
-- --
 1 MYSTRTYPE('RAM', 'SHAM', 'PAT')
 2 MYSTRTYPE('MAN', 'JOHN')

Chaim





"Jamadagni, Rajendra" <[EMAIL PROTECTED]>@fatcity.com on
08/20/2002 04:28:29 PM

Please respond to [EMAIL PROTECTED]

Sent by:[EMAIL PROTECTED]


To:Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:




create or replace mystrtype is table of varchar2(50)
/
select field1, cast(multiset(field2) as mystrtype)
  from my_table
 group by field1
/

HTH
Raj
__

Rajendra  Jamadagni       MIS, ESPN Inc.

Rajendra dot Jamadagni at ESPN dot  com

Any opinion expressed here is  personal and doesn't reflect that of ESPN
Inc.

QOTD: Any clod can have facts, but  having an opinion is an art!
-Original Message-
Sent: Tuesday, August 20, 2002 3:34  PM
To: Multiple recipients of list ORACLE-L


Here's an answer I posted to a similar question a few  weeks ago.

HTH

Tony  Aponte




I hope this is not to late for you.  Anyway, this  questions comes up
often.  Below is the solution to pivot rows for up to  12 values of field1.
Just adjust to fit your range of values.

HTH
Tony Aponte
Home Shopping Network, Inc.

create table tab1 (field1 number,field2 varchar2(30));
insert into tab1 values( 1,'RAM');
insert into tab1 values( 1,'SHAM');
insert into  tab1 values( 1,'PAT');
insert into tab1 values(  2,'MAN');
insert into tab1 values( 2,'JOHN');
commit;

SELECT
g1
,MAX(DECODE(line_no,01,value,NULL)) ||
MAX(DECODE(line_no,02,value,NULL)) ||
MAX(DECODE(line_no,03,value,NULL)) ||
MAX(DECODE(line_no,04,value,NULL)) ||
MAX(DECODE(line_no,05,value,NULL)) ||
MAX(DECODE(line_no,06,value,NULL)) ||
MAX(DECODE(line_no,07,value,NULL)) ||
MAX(DECODE(line_no,08,value,NULL)) ||
MAX(DECODE(line_no,09,value,NULL)) ||
MAX(DECODE(line_no,10,value,NULL)) ||
MAX(DECODE(line_no,11,value,NULL)) ||
MAX(DECODE(line_no,12,value,NULL))
FROM (SELECT  g1,value,row_number() over(partition by g1 order by g1 nulls
last) line_no
FROM (SELECT field1 g1,field2 value from tab1)
)
GROUP BY g1;

G1   MAX(DECODE(LINE_NO,01,VALUE,NU
1   RAMSHAMPAT
2   MANJOHN

-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Thursday, July 18, 2002 4:35 PM
To: Multiple recipients of list ORACLE-L

Hi Friends,
    I just need a help  in a sql . I am having rows in a table as
follows

Field1(ID)    Field2(NAME)
--
1          RAM
1          SHAM
1          PAT
2          MAN
2          JOHN

Now i want the output to be as follows

FIELD1  FIELD2
--
1        RAMSHAMPAT
2        MANJOHN

In the output i have to show all the names for the same id in  a single
row.
Please help me in getting this output  using a SQL query  and not through
cursors.

Thanks in advance.

Regards,
Shankar



-Original Message-
Sent: Tuesday, August 20, 2002 9:53  AM
To: Multiple recipients of list ORACLE-L


Hi Lists!
 I have one simple problem.  My query  is following

SELECT  SOD.DESCRIPTION
FROM
SO_TRN_DETAIL  SOD
WHERE
SOD.SO_TRN_ID =90
and result is :
 PREM_NET
 TAX_SPF
 TAX_SUR
 FEE_PDCR
 FEE_INSP
 PREM_GROSS
 COM_GROSS
 COM_PDCR

I want to concatenate all strings in a single  string and want to display
as a single record using SQL. I had seen  solution somewhere but i can not
search in archive.
How to do that?

Thanks in advance ...
Shishir Kumar Mishra
Agni Software (P) Ltd.
www.agnisoft.com
--
Vidya  Dadaati Viniyam
--


(See attached file: ESPN_Disclaimer.txt)





=?iso-8859-1?Q?ESPN=5FDisclaimer.txt?=
Description: Binary data


RE: PL/SQl question

2002-08-21 Thread kkennedy

Check the definition of table C.  It sounds like it is defined as CHAR(3) instead of 
VARCHAR2(3).  I would also check the PL/SQL for using CHAR instead of VARCHAR2 for 
storing the value -- the trim should have eliminated this problem if it was put in the 
right place.

Kevin Kennedy
First Point Energy Corporation

If you take RAC out of Oracle you get OLE!  What can this mean?

-Original Message-
Sent: Wednesday, August 21, 2002 7:28 AM
To: Multiple recipients of list ORACLE-L



> I have a question for from one of my developers related to PL/SQL and how
> data is loaded.
> 
> I have a field (marketcode) that is defined as VARCHAR2(3).
> 
> I have a problem when I try to load the value of '20' into this field.
> All values with three characters work fine.  The problem is when the value
> is less then 3 characters.   
> 
> When tables A and B have data loaded into this field using SQL/Loader the
> resulting value in the field appears to me as '20' with the third position
> =null.
> 
> I have a separate PL/SQL process that loads this field into table C.
> When PL/SQL populates this same value into this field the field appears to
> me as '20' with the third position = space.   I can't use SQL/Loader for
> this table as the data needs to be massaged before loading into Oracle.
> Thus when you try to link the tables together it does not find a match.
> 
>   select A.marketcode, C.marketcode
>   from tableA A, tableC C
>  where A.marketcode=C.marketcode;
>   
> (this returns 0 records)
> 
>  If I change the SQl statement to the following:
> 
>   select A.marketcode, C.marketcode
>   from tableA A, tableC C
>  where A.marketcode=trim(C.marketcode);
> 
>  (it correctly matches these up)
>   
> Things I have tried to remedy this problem:
> 1)  I have tried to modify my PL/SQL program to put a TRIM statement
> around the marketcode field when I populate table C.   This did not work.
> 2)  I have tried to check the 3rd position and if it is = space then I set
> the third position to null.  But the field in Oracle is still a space when
> the program is finished.
> 
> Does anyone have any thoughts on how I can properly output this field from
> Pl/SQl so it will match the data loaded via SQL/Loader? Thanks.
> 
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: DENNIS WILLIAMS
  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: kkennedy
  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: drop tablespace including contents

2002-08-21 Thread Brooks, Russ

Thanks Dennis,
  Yeah, I know how to do the work without the tool, using sqlplus.  That's not the 
problem.  Management won't even allow us to use OEM for maintenance tasks, only 
sapdba.  My hands are tied, at least for the moment.

Russ

-Original Message-
Sent: Wednesday, August 21, 2002 11:39 AM
To: Multiple recipients of list ORACLE-L


Russ - A couple of ideas for you.
  1. Check directly in Oracle before you perform a task with the tool. And
check afterward to verify what the tool did. This will make you a better
DBA. And in a future job interview, you'll have a more interesting
conversation than just saying "duh the only way I know to work with Oracle
is to use this tool." 
  2. Make a list of incidents where the tool messed things up or didn't use
the best method. Management is often impressed with detailed, documented
facts. It can also open a dialogue with the SAP tool developers. Often those
people want good feedback since they are developers, not production DBAs
(years ago I held that job at a different ERP vendor).
  3. Keep in mind that you face the same issues in using any tool, even if
it is Oracle's OEM, which management at some sites mandate their DBAs use.
Sometimes more efficient, but you are one degree removed from Oracle.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]


-Original Message-
Sent: Wednesday, August 21, 2002 8:03 AM
To: Multiple recipients of list ORACLE-L


I fully agree.  Unfortunately management insists on it.

Russ

-Original Message-
Sent: Tuesday, August 20, 2002 9:13 PM
To: Multiple recipients of list ORACLE-L


Dick,

There is absolutely *nothing* that SAPDBA does that a reasonably
knowledgeable DBA can't do from his of her favorite toolset.
( vi, Perl and sqlplus for me :)

SAP types have it drummed into their heads that the only proper
way to do anything DBA work is via SAPDBA.

I refuse to use it, and it just drives the SAP consultants crazy. 

There are many cases where a good DBA can do a much better
job than SAPDBA.  The tablespace reorganization is a good
example.  Trying to 'drop tablespace including contents' with 
3500 tables is not a terribly bright way of going about it.


Jared







[EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
08/20/2002 02:43 PM
Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:Re:drop tablespace including contents


Russ,

Your high usage of RBS was due to the updates being done to the system 
data
dictionary.  Since you were dropping a tablespace and contents the DDL
statements for the individual objects (tables and indexes) needs to be 
done
first, but I've a funny idea from practice that Oracle does not do an 
implicit
commit in this case but instead holds on till the end.  This makes 
dropping a
tablespace with the "including contents" caviot very nasty.  Thank GOD we 
never
implemented SAP over here.  I've heard nothing but bad about SAP and 
sapdba.

Dick Goulet

Reply Separator
Author: "Brooks; Russ" <[EMAIL PROTECTED]>
Date:   8/20/2002 11:13 AM

Hi, 
This past weekend we experienced a problem on a production database, and I 
would
like to try to determine what went wrong, how to avoid it in the future, 
and any
better ways of dealing with it should it be encountered again. 
After moving some large objects out of tablespace to spread I/O, we wanted 
to
reorganize the old tablespace to remove some fragmentation. The tool we 
were
using, sapdba, does not readily permit you to drop the individual tables 
between
the export and the drop tablespace including contents. Since the 
tablespace had
over 3500 tables the drop tablespace was expected to take a long time. We 
also
defined a large rollback segment for use this weekend, although with only
maxextents of 100. When Oracle tried to allocate the 101 extent in the 
RBS,
error messages were issued and things came to a grinding halt. sar 
indicated
disk I/O to the new RBS, but not to any of the datafiles. We waited 
several
hours, but the situation did not appear to change. 
Shutdown immediate did not work. We could alter the datafiles back online, 
but
not the tablespace. Since it was production, the decision was made to 
restore to
a recent backup. 
1. Was the rollback activity due solely to storing and restoring DDL for 
the
tables and indices? 
2. Once the RBS was unable to extend, was the drop tablespace including 
contents
dead? We tried to alter maxextents on the RBS, but did not get a response 
from
the system. Was that the appropriate reaction to this problem. 
3. A join of v$session and v$sql did not indicate any active SQL. How 
should we
have monitored the progress of what we assume was rollback activity?   Any 
way
to estimate how much or how long the rollback would take?
4. If the database were shutdown during the rollback I assume the rollback 
would
recommence when Oracle came back up.  Would it 

RE: Oracle 9i Application Server question

2002-08-21 Thread Hately Mike

Shirley,
it sounds like you're hitting bug number 1965439.
It occurs because the 9i database is installed when you try to install 9iAS.
It's allegedly fixed at 1.0.2.2.2. There doesn't seem to be a patch
available.

Regards,
Mike Hately
Oracle DBA



-Original Message-
Sent: 21 August 2002 16:19
To: Multiple recipients of list ORACLE-L


Shirley - By any chance is this a Pentium 4 system?

Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]


-Original Message-
Sent: Wednesday, August 21, 2002 9:18 AM
To: Multiple recipients of list ORACLE-L


Dear List,

I am trying to install Oracle 9i Release 1 (9.0.1) and Oracle 9i Application

Server version 1.0.2.2.0 onto a Windows 2000 server.  The installation
abends 
and produces the following message:

NOT ALL THE DEPENDENCIES OF THE COMPONENT ENTERPRISE MANAGER COMMON FILES 
2.2.0.0.0 were found. oracle.swd.jre.1.1.8.10.0 is missing.

Has anyone experienced this problem and how did you resolve it?

Shirley Mileca
Systems Analyst
Univ of Pittsburgh at Greensburg
Greensburg, PA  15601

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Shirley Mileca
  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: DENNIS WILLIAMS
  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).


 

 

This email and any attached to it are confidential and intended only for the
individual or 
entity to which it is addressed.  If you are not the intended recipient,
please let us know 
by telephoning or emailing the sender.  You should also delete the email and
any attachment 
from your systems and should not copy the email or any attachment or
disclose their content 
to any other person or entity.  The views expressed here are not necessarily
those of 
Churchill Insurance Group plc or its affiliates or subsidiaries. Thank you. 
Churchill Insurance Group plc.  Company Registration Number - 2280426.
England. 
Registered Office: Churchill Court, Westmoreland Road, Bromley, Kent BR1
1DP. 


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



FW: PL/Sql question

2002-08-21 Thread DENNIS WILLIAMS

In response to the questions for more details, here are the PL/SQL code and
SQL Loader control file. Everything is varchar2(2), explicitly defined as
such in PL/SQL. Thanks for all the nice replies.

PL/SQL snippets


<...snip...>

   marketingcodeVARCHAR2(3);

<...snip...>

FILELOCATION := '/usr/users/madmload/text_files';
OPEN_MODE:= 'r';
FILENAME := 'prodload.txt';

FILENBR := UTL_FILE.FOPEN (FILELOCATION , FILENAME, OPEN_MODE );

<...snip...>

   UTL_FILE.GET_LINE (FILENBR, OUTPUTSTRING);
   marketingcode := substr(outputstring, 21, 3);
 

<...snip...>

 insert into JOBOFFERFACT_LOAD 
(LIFETOUCHID, SOURCEFISCALYEAR, JOBNBR, PACKAGEID,
MARKETINGCODE,
 TERRITORYCODE, PLANTRECEIPTDATE, SEASON, PACKAGENAME,
PACKAGEPRICE,
 PAIDPACKAGEQTY, UNPAIDPACKAGEQTY, SHIPPEDPACKAGEQTY, CMSNTYPE,
 PACKAGECMSNRATE, PACKAGETYPE, PACKAGECHARGEBACK, 
 PACKAGEPOINTS, PACKAGECODE, PACKAGECONFIG) VALUES
(LIFETOUCHID, CURRENTFY, JOBNBR, PKGID, MARKETINGCODE,
 TERRITORYCODE, PLANTRECEIPTDATE, SEASON, PKGNAME, PACKAGEPRICE,
 PAIDPACKAGES, UNPAIDPACKAGES, SHIPPEDPACKAGES, CMSNTYPE, 
 PACKAGECMSN, PACKAGETYPE, PACKAGECHARGEBACK, 
 PACKAGEPOINTS, PKGCODE, PKGCONFIG ) ;





Sql*Loader script

LOAD DATA
INFILE '/usr/users/madmload/joblid.txt'
BADFILE '/usr/users/madmload/jobload.bad'
APPEND
INTO TABLE JOBFACT
(
JOBNBR  POSITION(1:10)  CHAR, 
LIFETOUCHID POSITION(11:20) INTEGER EXTERNAL,
MDRPRIMARYIDPOSITION(21:28) CHAR,
MARKETINGCODE   POSITION(29:31) CHAR,
SUBPROGRAMCODE  POSITION(32:32) CHAR,
TERRITORYCODE   POSITION(33:34) CHAR,
SUBTERRITORYCODEPOSITION(33:36) CHAR,
SELLINGMETHODCODE   POSITION(37:37) CHAR,
BIDIND  POSITION(38:38) CHAR,
PDKIND  POSITION(39:39) CHAR,
PDKPARTNBR  POSITION(40:44) CHAR,
RETAKEIND   POSITION(45:45) CHAR,
PLANTCODE   POSITION(46:46) CHAR,
PLANTRECEIPTDATEPOSITION(47:56) DATE "/MM/DD" NULLIF
PLANTRECEIPTDA,
PLANTRECEIPTYEARPOSITION(47:50) INTEGER EXTERNAL,
PLANTRECEIPTMONTH   POSITION(52:53) INTEGER EXTERNAL,
PHOTOGRAPHYDATE POSITION(57:66) DATE "/MM/DD" NULLIF
PHOTOGRAPHYDATE=BLANKS,
SHIPDATEPOSITION(67:76) DATE "/MM/DD" NULLIF SHIPDATE=BLANKS,
SHOTQTY POSITION(77:80) INTEGER EXTERNAL,
SHIPPEDPACKAGEQTY   POSITION(81:84) INTEGER EXTERNAL,
PAIDPACKAGEQTY  POSITION(85:88) INTEGER EXTERNAL,
UNPAIDPACKAGEQTYPOSITION(89:92) INTEGER EXTERNAL,
XNOPURCHASEQTY  POSITION(93:96) INTEGER EXTERNAL,
CASHRECEIVEDAMT POSITION(97:105)DECIMAL EXTERNAL,
CASHRETAINEDAMT POSITION(106:114)   DECIMAL EXTERNAL,
ACCTCMSNPAIDAMT POSITION(115:123)   DECIMAL EXTERNAL,
ESTACCTCMSNAMT  POSITION(124:132)   DECIMAL EXTERNAL,
CHARGEBACKAMT   POSITION(133:141)   DECIMAL EXTERNAL,
SALESTAXAMT POSITION(142:150)   DECIMAL EXTERNAL,
TERRITORYCMSNAMTPOSITION(151:159)   DECIMAL EXTERNAL,
TERRITORYEARNINGSAMTPOSITION(160:168)   DECIMAL EXTERNAL,
EXPECTEDCASHAMT POSITION(169:177)   DECIMAL EXTERNAL,
SOURCEFISCALYEARCONSTANT '2003',
PROOFPOSE   POSITION(178:178)   DECIMAL EXTERNAL,
PROOFCOUNT  POSITION(179:182)DECIMAL EXTERNAL,
SEASONDESC  POSITION(183:183)DECIMAL EXTERNAL,
EXTRACTDATE POSITION(184:193) DATE "/MM/DD" NULLIF
EXTRACTDATE=BLANKS,
FUNPACKJOB  POSITION(194:194)  CHAR,
CONNECTJOB  POSITION(195:195)  CHAR,
STICKYALBUMJOB  POSITION(196:196)  CHAR,
PAYSTATUS   POSITION(197:197)  CHAR,
ORIGINALDATERECEIVED  POSITION(198:207) DATE "/MM/DD" NULLIF
ORIGINALDATERE,
CMSNSTATUS  POSITION(208:208) CHAR
)


==


All tables have the marketingcode field defined as varchar2(3)  (none are
char(3))


Bruce
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: DENNIS WILLIAMS
  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: Odbc and reserve words

2002-08-21 Thread DENNIS WILLIAMS

Harvinder
   You've made my day! I have always fought developers on issues like this.
My advice would be for you to use this situation to get the column name
changed. I predict that this column will continue to cause you grief.

Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]


-Original Message-
Sent: Wednesday, August 21, 2002 10:49 AM
To: Multiple recipients of list ORACLE-L


Hi,

One of our client has a table with column name "access".
Since access is reserver word...they use double quotes..
now when we try using ODBC to :
select access from table 
it gives error..but 
select "access" from table works..
But we want select access from table to work

IS there and escape sequence in ODBC where it will not give error for
reserved words..

Thanks
--Harvinder
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Harvinder Singh
  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: DENNIS WILLIAMS
  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: Win2000/8.1.7.3.0/SQL

2002-08-21 Thread DENNIS WILLIAMS

John - It is available at http://www.hotsos.com/catalog/

Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]


-Original Message-
Sent: Tuesday, August 20, 2002 7:09 PM
To: Multiple recipients of list ORACLE-L


Mike,

Just one more thing to check before you close this: Can you run a 10053
trace? This is a 'CBO trace' and should provide some interesting reading.
There was an excellent paper from Wolfgang Breitling on the 10053 at the
recent IOUG and should be available somewhere...

Inquiring minds want to know!

John Kanagaraj
Oracle Applications DBA
DBSoft Inc
(W): 408-970-7002

Disappointments are inevitable in Life, but discouragement is optional. You
decide!

** The opinions and statements above are entirely my own and not those of my
employer or clients **


> -Original Message-
> From: Vergara, Michael (TEM) [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, August 20, 2002 4:34 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Win2000/8.1.7.3.0/SQL
> 
> 
> John:
> 
> That makes perfect sense in view of the fact that only the
> /*+ RULE */ hint makes the query run.  I'm not gonna try and
> find the root cause any more;  I've modified my queries and 
> I get answers again.
> 
> My Thanks to all who have helped me with this issue.
> 
> Cheers,
> Mike
> 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: John Kanagaraj
  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: DENNIS WILLIAMS
  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: double quotes column name

2002-08-21 Thread Hately Mike

Harvinder,
The column won't be created with a quotation mark as part of its name.
Oracle won't allow it.
All the quotation mark does is allow the creation of the column in the first
place, circumventing the syntax rules. 
This is not a good thing. I'll lay good odds that it causes problems
somewhere down the line.
Every time that column is referred to you'll have to enclose it in quotes.
It's a terrible design choice. Go back to them and make them change it.
Actually, as they're a client rather than a supplier you should "advise"
them to change it.  =)   
Flouting Oracle's object naming rules never did anyone any good.

Regards,
Mike Hately
Oracle DBA


-Original Message-
Sent: Wednesday, August 21, 2002 9:59 PM
To: Multiple recipients of list ORACLE-L

Hi, 

One of our clients has created a table with column name "access" 
since access is reserved word , they use double quotes. 
but when i query the table user_tab_columns it is still showing column name
as access and not "access" 
how can we know that this table is created with "" column name.. 

Thanks 
--Harvinder 


SQL> select table_name,column_name from user_tab_columns
  2  where table_name='FF1'
  3  /

TABLE_NAME COLUMN_NAME
-- --
FF1access
-- 


 

 

This email and any attached to it are confidential and intended only for the
individual or 
entity to which it is addressed.  If you are not the intended recipient,
please let us know 
by telephoning or emailing the sender.  You should also delete the email and
any attachment 
from your systems and should not copy the email or any attachment or
disclose their content 
to any other person or entity.  The views expressed here are not necessarily
those of 
Churchill Insurance Group plc or its affiliates or subsidiaries. Thank you. 
Churchill Insurance Group plc.  Company Registration Number - 2280426.
England. 
Registered Office: Churchill Court, Westmoreland Road, Bromley, Kent BR1
1DP. 


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Hately Mike
  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: :STATEMENT

2002-08-21 Thread Jared . Still

It looks like there's a number of people on this list 
that could benefit from subscribing to the Perl DBI list:

http://lists.perl.org/showlist.cgi?name=dbi-users

Jared






"Bob Metelsky" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
08/21/2002 08:23 AM
Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:RE: :STATEMENT


Did you run the perl makefile.pl
 
cd dir\downloaded\fromppm\eg\.cpan\source\mymodule
 
make
make test
 
make install 
 
 
For win32 you have to download and use nmake from microsoft
 
bob
 
 
Hi,
  Has anyone played with Perl's SQL::STATEMENT?  I pulled it down with 
ppm, and the sample to evaluate the where clause gives the error:
 
Can't locate object method "where" via package "SQL::Statement" (perhaps 
you forgot to load "SQL::Statement"?) at test_sql.plx line 37.
 
And yes, I included a use SQL::STATEMENT; 
 
Cheers,
Russ


-- 
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).



RE: List of all zip codes,city,state to load into table.

2002-08-21 Thread Stephen Andert

As long as you don't need current data.  This page says the file was
last updated Jan 8, 1997.  In my personal contact manager, I'm still
using one I downloaded from quite some time ago.  Unless you need real
current data, the price is right. (Send the guy $10 though)

Stephen



>>> [EMAIL PROTECTED] 08/21/02 08:18AM >>>

Hi,  Hope this helps.  Its a text file, then you can load it using
SQLloader etc. 

http://www.cwpm.com/ZIP_DB.html 

 -Original Message- 
[EMAIL PROTECTED] 
Sent:   Wednesday, August 21, 2002 9:14 AM 
To: Multiple recipients of list ORACLE-L 
Hi All, 
Where can I get a list of all zip codes,city,states to load into a
table. I 
have searched but cannot find anything to download. 
Anyone have a URL that I can get this info. 
Thanks 
Rick 

-- 
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:
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: Stephen Andert
  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: drop tablespace including contents

2002-08-21 Thread DENNIS WILLIAMS

Russ - A couple of ideas for you.
  1. Check directly in Oracle before you perform a task with the tool. And
check afterward to verify what the tool did. This will make you a better
DBA. And in a future job interview, you'll have a more interesting
conversation than just saying "duh the only way I know to work with Oracle
is to use this tool." 
  2. Make a list of incidents where the tool messed things up or didn't use
the best method. Management is often impressed with detailed, documented
facts. It can also open a dialogue with the SAP tool developers. Often those
people want good feedback since they are developers, not production DBAs
(years ago I held that job at a different ERP vendor).
  3. Keep in mind that you face the same issues in using any tool, even if
it is Oracle's OEM, which management at some sites mandate their DBAs use.
Sometimes more efficient, but you are one degree removed from Oracle.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]


-Original Message-
Sent: Wednesday, August 21, 2002 8:03 AM
To: Multiple recipients of list ORACLE-L


I fully agree.  Unfortunately management insists on it.

Russ

-Original Message-
Sent: Tuesday, August 20, 2002 9:13 PM
To: Multiple recipients of list ORACLE-L


Dick,

There is absolutely *nothing* that SAPDBA does that a reasonably
knowledgeable DBA can't do from his of her favorite toolset.
( vi, Perl and sqlplus for me :)

SAP types have it drummed into their heads that the only proper
way to do anything DBA work is via SAPDBA.

I refuse to use it, and it just drives the SAP consultants crazy. 

There are many cases where a good DBA can do a much better
job than SAPDBA.  The tablespace reorganization is a good
example.  Trying to 'drop tablespace including contents' with 
3500 tables is not a terribly bright way of going about it.


Jared







[EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
08/20/2002 02:43 PM
Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:Re:drop tablespace including contents


Russ,

Your high usage of RBS was due to the updates being done to the system 
data
dictionary.  Since you were dropping a tablespace and contents the DDL
statements for the individual objects (tables and indexes) needs to be 
done
first, but I've a funny idea from practice that Oracle does not do an 
implicit
commit in this case but instead holds on till the end.  This makes 
dropping a
tablespace with the "including contents" caviot very nasty.  Thank GOD we 
never
implemented SAP over here.  I've heard nothing but bad about SAP and 
sapdba.

Dick Goulet

Reply Separator
Author: "Brooks; Russ" <[EMAIL PROTECTED]>
Date:   8/20/2002 11:13 AM

Hi, 
This past weekend we experienced a problem on a production database, and I 
would
like to try to determine what went wrong, how to avoid it in the future, 
and any
better ways of dealing with it should it be encountered again. 
After moving some large objects out of tablespace to spread I/O, we wanted 
to
reorganize the old tablespace to remove some fragmentation. The tool we 
were
using, sapdba, does not readily permit you to drop the individual tables 
between
the export and the drop tablespace including contents. Since the 
tablespace had
over 3500 tables the drop tablespace was expected to take a long time. We 
also
defined a large rollback segment for use this weekend, although with only
maxextents of 100. When Oracle tried to allocate the 101 extent in the 
RBS,
error messages were issued and things came to a grinding halt. sar 
indicated
disk I/O to the new RBS, but not to any of the datafiles. We waited 
several
hours, but the situation did not appear to change. 
Shutdown immediate did not work. We could alter the datafiles back online, 
but
not the tablespace. Since it was production, the decision was made to 
restore to
a recent backup. 
1. Was the rollback activity due solely to storing and restoring DDL for 
the
tables and indices? 
2. Once the RBS was unable to extend, was the drop tablespace including 
contents
dead? We tried to alter maxextents on the RBS, but did not get a response 
from
the system. Was that the appropriate reaction to this problem. 
3. A join of v$session and v$sql did not indicate any active SQL. How 
should we
have monitored the progress of what we assume was rollback activity?   Any 
way
to estimate how much or how long the rollback would take?
4. If the database were shutdown during the rollback I assume the rollback 
would
recommence when Oracle came back up.  Would it start where it left off or 
start
from scratch.  It was my impression that it is marking the header blocks 
as it
goes, but I would like to check.

Thanks, 
Russ Brooks 








Hi, This past weekend we experienced a problem on a production 
database, and I would like to try to determine what went wrong, how to 
avoid it 
in the future, and any bette

RE: Reasons to upgrade from Oracle 7.3.4 to 8i - DONE

2002-08-21 Thread Andrey Bronfin

Thanks a lot to all who replied !
The upgrade issue is postponed by the customer ;-(
Apparently they'll need to upgrade the O/S as well (they currently use
Digital 4.0d , while the earliest version Oracle8i OPS is certified on is
4.0e, and 9i RAC is supported on 5.*).
So , now the customer should decide whether or not they'd go for it.
BTW , support is not an issue for them. The customer is the largest (and
arguably the only) wireline telephone company in Israel and is the largest
customer of Oracle Israel. Their support contract includes (among the rest)
FREE upgrades , performed by Oracle consultants on site.



DBAndrey

* 03-9254520
* 058-548133
* mailto:[EMAIL PROTECTED]





-Original Message-
Sent: Monday, August 19, 2002 3:42 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]


Andrey,

Playing Devil's advocate, the only valid reason I can think of
is due to support issues.

An unsupported version of Oracle is something of problem should
you find new bugs.  The platform it's on will no doubt leave it's support
window at sometime in the future.

If the customers are happy, how will they benefit from partitioning?

I know there is an incredible array of new features available in 9i RAC
that will enhance performance,  but if the customers are happy they 
won't care.

There may be other issues they have concerns about, such as
security.  Maybe they would like encryption built into the database?
Or perhaps the Virtual Private Database is of interest to them?

Why not check the new features list, and see if there are items
there that would be beneficial the customer from a business 
perspective.

As a fellow DBA, I can understand your point of view.  But 
the $$ needs to be justified.

Jared










Andrey Bronfin <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
08/19/2002 06:33 AM
Please respond to ORACLE-L

 
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc: 
Subject:Reasons to upgrade from Oracle 7.3.4 to 8i


Dear gurus !
I know it's a "beaten to death horse", but...
I want to convince a customer to upgrade their OPS 7.3.4 DB to an Oracle
8.1.7 OPS or even (in a best case for me) to Oracle9i RAC (don't even know
whether or not one exists and is supported for Digital UNIX on EMC 
Symmetrix
storage).
I am sure this has been discussed 1000s of times here , but ... i need the
arguments to convince them.
I can't tell them "upgrade because 8.1.7 delivers better performance ,
availability etc...and 7.3.4 is outdated" , they simply won't buy it. 
They run that OPS 7.3.4 DB for several years now and are quite happy with
it. 
I need to explain in details why they should invest in the upgrade.
Now , the only real reason i can think of is partitioning . They will
definetly benefit from it.
I need more reasons.
Thanks a lot in advance.


DBAndrey

* 03-9254520
* 058-548133
* mailto:[EMAIL PROTECTED]




-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Andrey Bronfin
  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: Andrey Bronfin
  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: Reasons to upgrade from Oracle 7.3.4 to 8i

2002-08-21 Thread Andrey Bronfin

Yes ,that would be one of my favorite points , but  the backup is done
by EMC BCV split at the OS / storage level, i.e. this is not an argument too
;-(


DBAndrey

* 03-9254520
* 058-548133
* mailto:[EMAIL PROTECTED]





-Original Message-
Sent: Monday, August 19, 2002 6:28 PM
To: Multiple recipients of list ORACLE-L


And don't forget you can use rman with 8x.  Ruth
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Monday, August 19, 2002 11:28 AM


> Not "completely unsupported" - plenty of old patches exist and can be
> downloaded and applied. There's tons of support docs on solving issues
aside
> from applying patches. If the DB crashes (which doesn't happen often as
the
> databases are usually stable and the hardware unchanging) support will
work
> with you to get it back up. BUT if you do have to change hardware or OS,
and
> the DB doesn't work with it, you are SOL (and will get the song and dance
> from support about only option is upgrade).
> Many companies are unwilling to invest the money, time and effort to
upgrade
> the DB and application for a stable system, unless they see a ROI that
isn't
> solely related to desupport of the DB.
>
> Other reasons to upgrade: ability to upgrade OS and hardware, tools that
> only work on newer versions, index options (bitmap, etc.).
>
> Margaret
>
>
> > -Original Message-
> > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> > Sent: Monday, August 19, 2002 10:48 AM
> > To: Multiple recipients of list ORACLE-L
> > Subject: RE: Reasons to upgrade from Oracle 7.3.4 to 8i
> >
> >
> >
> > How about the fact
> >
> > You are completely unsupported by Oracle in that version.
> >
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Murray, Margaret
>   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: Ruth Gramolini
  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: Andrey Bronfin
  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: Odbc and reserve words

2002-08-21 Thread kkennedy

Harvinder,

Why do you want this grief?  I would do everything in my power to convince the client 
to rebuild the table with a different column name.

To the best of my knowledge, you have locked yourself into a situation requiring the 
double quotes.  I don't know of any way around it.  Maybe someone else does.

Kevin Kennedy
First Point Energy Corporation

If you take RAC out of Oracle you get OLE!  What can this mean?

-Original Message-
Sent: Wednesday, August 21, 2002 8:49 AM
To: Multiple recipients of list ORACLE-L


Hi,

One of our client has a table with column name "access".
Since access is reserver word...they use double quotes..
now when we try using ODBC to :
select access from table 
it gives error..but 
select "access" from table works..
But we want select access from table to work

IS there and escape sequence in ODBC where it will not give error for reserved 
words..

Thanks
--Harvinder
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Harvinder Singh
  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: kkennedy
  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[2]:=?iso-8859-1?Q?A_friendly_reminder_-_AutoDBA_webcast_8

2002-08-21 Thread dgoulet

To all,

I too often allow the dark side of my personality to rule uncontrollably. 
The previous e-mail on this subject/vendor was a manifestation of that dark
side.  I would like to apologize to all for the rantings that were expressed. 
Please be so kind as to delete the message & flame/censure the sender(me) as you
see appropriate.

Dick Goulet

Reply Separator
Author: 
Date:   8/21/2002 8:45 AM

Jack - I am forwarding this to the folks here who may be interested...

Doug

Reply Separator
Author: "=?iso-8859-1?Q?Jack_Wachtler?=" <[EMAIL PROTECTED]>
Date:   8/20/02 7:05 AM

Hi Douglas,

I sent you an email a couple weeks ago about getting someone at Vicor to review
our product.  We have a few open slots left in our upcoming webcasts (info
below).  Who would be the right person to attend?

To refresh your memory, our product, AutoDBA, can save you money, effort, and
hassle.  It gives your Oracle database people tremendous leverage and
efficiency, by automating all of the preventative maintenance your databases
need.

AutoDBA lets DBAs accomplish twice as much as they're doing now: storage
management, performance tuning, downtime avoidance, etc.  More info at
www.senware.com.

Our web-based product demos are short and informative, feature and technology
oriented rather than sales oriented.  Please forward this email to whomever at
Vicor you think would be interested, or reply and point me in the right
direction.

Again, thanks in advance.

Here's the information on the webcasts:

Dates:   Wednesday, Aug. 21 and Wednesday Aug. 28
Time:12:30 PDT (1:30 Mountain, 2:30 Central, 3:30 Eastern)

Instructions:
 Go to http://senware.raindance.com
 Click on "Participant Login"
 For Event Name, enter dba7924385
 For audio, dial 1-888-693-8686
 Enter audio ID 7924385

If you're interested, please reply back so I can reserve a spot for you.
Questions are welcome.  We can even do a custom savings analysis for your
organization.

Sincerely,

Jack Wachtler
Senware, Inc.
[EMAIL PROTECTED]
303-279-7626  x24


P.S.  Final thought: AutoDBA is definitely worth a look if you use Oracle.  It
monitors the DB and detects future problem areas, then generates custom scripts
to fix problems and manage the database.  The scripts are executed in a safe,
intelligent fashion, subject to your control, via a smart and simple user
interface.  For more info, drop me a line.  Thanks.


-- 
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).



Re: Catching errors on inserts

2002-08-21 Thread Anjo Kolk

It is in the session trace file not the alert log file.

Anjo.


On Wednesday 21 August 2002 16:38, you wrote:
> Gogala
>
>   Thanks for the tip this seems like just what I'm looking for,
> however I must be doing something wrong as no errors are getting written
> to my alrt.log
>
> Im running oracle 8.16 server on win2kpro (this is a development
> database)
>
> I just got around  to running/testing this from my post last week
>
> I do
> SQL> alter session set events='0001  trace name errorstack forever,
> level 10';
>
> Session altered.
>
> Then I run the offending insert script which show errors being thrown
>
> I check the alrt.log in BDUMP dir and all it show are  my regular
> .ORA logs being written
> EG
> Wed Aug 21 09:19:07 2002
> Thread 1 advanced to log sequence 3240
>   Current log# 4 seq# 3240 mem# 0:
> D:\DB_TRACK2DATA\ORADATA\LTRACK2\LOG4LTRACK2.ORA
> Thread 1 advanced to log sequence 3241
>   Current log# 1 seq# 3241 mem# 0:
> D:\DB_TRACK2DATA\ORADATA\LTRACK2\LOG1LTRACK2.ORA
> Thread 1 advanced to log sequence 3242
>   Current log# 2 seq# 3242 mem# 0:
> D:\DB_TRACK2DATA\ORADATA\LTRACK2\LOG2LTRACK2.ORA
> Thread 1 advanced to log sequence 3243
>
> Also checked the alrt.log in Oracle\home\database
> Nothing written there
>
> What am I missing?
>
> > alter session set events='0001  trace name errorstack
> > forever, level 10'; All "duplicate value" errors will then be
> > trapped in the alert.log file. You can always substitute your
> > own favorite error in place of 0001.
>
> Also If you have a extra min how can I substitute the error message?
>
> Thanks for your help
>
> Bob


--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Anjo Kolk
  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 9i Application Server question

2002-08-21 Thread Hemant K Chitale


When you say "Oracle 9i Release 1 (9.0.1) and Oracle 9i Application Server 
version 1.0.2.2.0 "
are you installing the two different products into the same ORACLE_HOME ?
They have to be seperate Oracle_Homes.  9iAS 1.0.2 is not built on 9.0.1 
libraries,
it is on 8.1.7 libraries.
I believe that you should be installing 9iAS first into one ORACLE_HOME and 
then 9iDB
into another ORACLE_HOME.
Hemant

At 06:18 AM 21-08-02 -0800, you wrote:
>Oracle 9i Release 1 (9.0.1) and Oracle 9i Application Server version 
>1.0.2.2.0

Hemant K Chitale
Now using Eudora Email.  Try it !

My home page is :  http://hkchital.tripod.com


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Hemant K Chitale
  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: double quotes column name

2002-08-21 Thread Naveen Nahata

Harvinder,

The columns created with double quotes show as such in user_tab_columns, i
mean they show the name in the same case

so...

NameDisplayed
"Access" - Access
"ACCess" - ACCess

and so on. and when u query the table use  select "Access" FROM.

Naveen

-Original Message-
Sent: Wednesday, August 21, 2002 9:59 PM
To: Multiple recipients of list ORACLE-L


Hi, 

One of our clients has created a table with column name "access" 
since access is reserved word , they use double quotes. 
but when i query the table user_tab_columns it is still showing column name
as access and not "access" 
how can we know that this table is created with "" column name.. 

Thanks 
--Harvinder 


SQL> select table_name,column_name from user_tab_columns
  2  where table_name='FF1'
  3  /

TABLE_NAME COLUMN_NAME
-- --
FF1access
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Harvinder Singh
  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: Naveen Nahata
  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: :STATEMENT

2002-08-21 Thread Bob Metelsky
Title: Message



Did 
you run the perl makefile.pl
 
cd 
dir\downloaded\fromppm\eg\.cpan\source\mymodule
 
make
make 
test
 
make 
install 
 
 
For 
win32 you have to download and use nmake from microsoft
 
bob
 
 

  Hi,
    Has anyone 
  played with Perl's SQL::STATEMENT?  I pulled it down with ppm, and the 
  sample to evaluate the where clause gives the error:
   
  Can't locate 
  object method "where" via package "SQL::Statement" (perhaps you forgot to load 
  "SQL::Statement"?) at test_sql.plx line 37.
   
  And yes, I 
  included a use SQL::STATEMENT; 
   
  Cheers,
  Russ


double quotes column name

2002-08-21 Thread Harvinder Singh

Hi, 

One of our clients has created a table with column name "access" 
since access is reserved word , they use double quotes. 
but when i query the table user_tab_columns it is still showing column name as access 
and not "access" 
how can we know that this table is created with "" column name.. 

Thanks 
--Harvinder 


SQL> select table_name,column_name from user_tab_columns
  2  where table_name='FF1'
  3  /

TABLE_NAME COLUMN_NAME
-- --
FF1access
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Harvinder Singh
  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 9i Application Server question

2002-08-21 Thread DENNIS WILLIAMS

Shirley - By any chance is this a Pentium 4 system?

Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]


-Original Message-
Sent: Wednesday, August 21, 2002 9:18 AM
To: Multiple recipients of list ORACLE-L


Dear List,

I am trying to install Oracle 9i Release 1 (9.0.1) and Oracle 9i Application

Server version 1.0.2.2.0 onto a Windows 2000 server.  The installation
abends 
and produces the following message:

NOT ALL THE DEPENDENCIES OF THE COMPONENT ENTERPRISE MANAGER COMMON FILES 
2.2.0.0.0 were found. oracle.swd.jre.1.1.8.10.0 is missing.

Has anyone experienced this problem and how did you resolve it?

Shirley Mileca
Systems Analyst
Univ of Pittsburgh at Greensburg
Greensburg, PA  15601

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Shirley Mileca
  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: DENNIS WILLIAMS
  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).



iAS 1.0.2.2.2 and ssoxlad.so an ELF32 instead of ELF64

2002-08-21 Thread Markus Reger

hello listmates

we installed on a first solaris 8 a database 9.2.0.1.0 and on a second iAS 1.0.2.2.2 - 
it worked fine, until we decided (out of necessity) to configure portal for ldap 
authentication. 

the problem is: we have a file called "ssoxldap.so" which is a ELF 32-bit - but we 
need one beeing a ELF 64-bit. we haven't got a clue where to get it from or how to 
make/compile it ourselves.  

has anyone ever solved this problem ?

we studied lots of pertinent pages - all patches are applied, all necessary libraries 
exist so far.

does this iAS 1.0.2.2.2 for solaris only come in 32-bit version? 

faithfully mr
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Markus Reger
  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: List of all zip codes,city,state to load into table.

2002-08-21 Thread Ruth Gramolini

Have you check the USPS web site?  RBG
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, August 21, 2002 9:13 AM


> Hi All,
>
> Where can I get a list of all zip codes,city,states to load into a table.
I
> have searched but cannot find anything to download.
> Anyone have a URL that I can get this info.
>
> Thanks
> Rick
>
>
> --
> 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: Ruth Gramolini
  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: double quotes column name

2002-08-21 Thread Fink, Dan

This is not a guaranteed method, but the fact that 'access' is stored in the
data dictionary is an indicator that they used "" to force the name. Anytime
you see lowercase, you can assume that they used "". Of course, if the
created it as "ACCESS", my method won't work...

Dan Fink

-Original Message-
Sent: Wednesday, August 21, 2002 10:28 AM
To: Multiple recipients of list ORACLE-L


Hi, 

One of our clients has created a table with column name "access" 
since access is reserved word , they use double quotes. 
but when i query the table user_tab_columns it is still showing column name
as access and not "access" 
how can we know that this table is created with "" column name.. 

Thanks 
--Harvinder 


SQL> select table_name,column_name from user_tab_columns
  2  where table_name='FF1'
  3  /

TABLE_NAME COLUMN_NAME
-- --
FF1access
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Harvinder Singh
  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: Fink, Dan
  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: PL/SQl question

2002-08-21 Thread Mercadante, Thomas F

Dennis,

In your PL/SQL program, did you try the RTRIM(date_field,' ') command? 

I know that TRIM is new, but I thought it needed additional parameters to
tell it what to trim.

Tom Mercadante
Oracle Certified Professional


-Original Message-
Sent: Wednesday, August 21, 2002 10:28 AM
To: Multiple recipients of list ORACLE-L



> I have a question for from one of my developers related to PL/SQL and how
> data is loaded.
> 
> I have a field (marketcode) that is defined as VARCHAR2(3).
> 
> I have a problem when I try to load the value of '20' into this field.
> All values with three characters work fine.  The problem is when the value
> is less then 3 characters.   
> 
> When tables A and B have data loaded into this field using SQL/Loader the
> resulting value in the field appears to me as '20' with the third position
> =null.
> 
> I have a separate PL/SQL process that loads this field into table C.
> When PL/SQL populates this same value into this field the field appears to
> me as '20' with the third position = space.   I can't use SQL/Loader for
> this table as the data needs to be massaged before loading into Oracle.
> Thus when you try to link the tables together it does not find a match.
> 
>   select A.marketcode, C.marketcode
>   from tableA A, tableC C
>  where A.marketcode=C.marketcode;
>   
> (this returns 0 records)
> 
>  If I change the SQl statement to the following:
> 
>   select A.marketcode, C.marketcode
>   from tableA A, tableC C
>  where A.marketcode=trim(C.marketcode);
> 
>  (it correctly matches these up)
>   
> Things I have tried to remedy this problem:
> 1)  I have tried to modify my PL/SQL program to put a TRIM statement
> around the marketcode field when I populate table C.   This did not work.
> 2)  I have tried to check the 3rd position and if it is = space then I set
> the third position to null.  But the field in Oracle is still a space when
> the program is finished.
> 
> Does anyone have any thoughts on how I can properly output this field from
> Pl/SQl so it will match the data loaded via SQL/Loader? Thanks.
> 
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: DENNIS WILLIAMS
  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: Mercadante, Thomas F
  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: dbms_utility and dbms_stat difference

2002-08-21 Thread Cherie_Machler


Barbara,

I can't speak for dbms_utility but dbms_stats is supposed to generate
statistics at both the partition level and at the table level for
partitioned tables, which analyze does not do.   These are supposed to be
better quality statistics.   Be aware that there are bugs related to
dbms_stats for partitioned tables at certain levels of 8.1.7.x.

Cherie Machler
Oracle DBA
Gelco Information Network


   
  
"Baker, Barbara"   
  
   
gency.com> cc: 
  
Sent by:   Subject: RE: dbms_utility and 
dbms_stat difference
[EMAIL PROTECTED]   
  
   
  
   
  
08/21/02 10:13 AM  
  
Please respond to  
  
ORACLE-L   
  
   
  
   
  





Is there an advantage to either of these over "roll your own" (select
'analyze table ' || table_name|| 'compute statistics')?
(Besides ease of use.)

Since I already have the scripts in place that run the analyze statmement,
I'm wondering if it's worth the effort to change the jobs to use
dbms_utility.analyze_schema.
Thx!
Barb


> --
> From: Connor McDonald[SMTP:[EMAIL PROTECTED]]
> Reply To:  [EMAIL PROTECTED]
> Sent: Wednesday, August 21, 2002 3:58 AM
> To:   Multiple recipients of list ORACLE-L
> Subject:   Re: dbms_utility and dbms_stat difference
>
> dbms_utility is basically a wrapper around a series of
> ANALYZE commands.  Oracle's recommendation is to use
> DBMS_STATS but do some testing first - I've send
> instances where dbms_stats runs a lot heavier than
> analyze
>
> hth
> connor
>
>  --- Chuan Zhang <[EMAIL PROTECTED]> wrote:
> >
> > Hi, ALL,
> >
> >   Sorry if this one is posted more than once.
> >
> > What is the difference between dbms_utility and
> > dbms_stats in terms of
> > statistics gathering?
> >
> > Any clues would be much appreciated.
> >
> > Chuan
> > > Unless otherwise stated, this e-mail does not
> > represent the views of
> > TransACT Communications Pty Limited.  This text and
> > any attachments of
> > this e-mail are confidential and may be legally
> > privileged.  This email
> > is for the use of the intended recipient only. If
> > you are not the intended
> > recipient do not take any action in relation to this
> > email, other than to
> > notify TransACT Communications by replying to this
> > e-mail and destroying
> > the original communication.  Except as required by
> > law, TransACT
> > Communications does not represent that this
> > transmission is free of errors,
> > viruses or interference.
> >
> >
> >
>
> =
> Connor McDonald
> http://www.oracledba.co.uk
> http://www.oaktable.net
>
> "Remember amateurs built the ark - Professionals built the Titanic"
>
> __
> Do You Yahoo!?
> Everything you'll ever need on one web page
> from News and Sport to Email and Music Charts
> http://uk.my.yahoo.com
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: =?iso-8859-1?q?Connor=20McDonald?=
>   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: Baker, Barbara
  INET: [EMAIL PROTECTED]

Fat City Network Services-- (858) 538-5051  FAX: (858) 538-5051
San Diego, California   

RE: dbms_utility and dbms_stat difference

2002-08-21 Thread Baker, Barbara


Is there an advantage to either of these over "roll your own" (select
'analyze table ' || table_name|| 'compute statistics')?
(Besides ease of use.)

Since I already have the scripts in place that run the analyze statmement,
I'm wondering if it's worth the effort to change the jobs to use
dbms_utility.analyze_schema.
Thx!
Barb


> --
> From: Connor McDonald[SMTP:[EMAIL PROTECTED]]
> Reply To: [EMAIL PROTECTED]
> Sent: Wednesday, August 21, 2002 3:58 AM
> To:   Multiple recipients of list ORACLE-L
> Subject:  Re: dbms_utility and dbms_stat difference
> 
> dbms_utility is basically a wrapper around a series of
> ANALYZE commands.  Oracle's recommendation is to use
> DBMS_STATS but do some testing first - I've send
> instances where dbms_stats runs a lot heavier than
> analyze
> 
> hth
> connor
> 
>  --- Chuan Zhang <[EMAIL PROTECTED]> wrote:
> > 
> > Hi, ALL,
> > 
> >   Sorry if this one is posted more than once.
> > 
> > What is the difference between dbms_utility and
> > dbms_stats in terms of
> > statistics gathering?
> > 
> > Any clues would be much appreciated.
> > 
> > Chuan
> > > Unless otherwise stated, this e-mail does not
> > represent the views of 
> > TransACT Communications Pty Limited.  This text and
> > any attachments of 
> > this e-mail are confidential and may be legally
> > privileged.  This email 
> > is for the use of the intended recipient only. If
> > you are not the intended 
> > recipient do not take any action in relation to this
> > email, other than to 
> > notify TransACT Communications by replying to this
> > e-mail and destroying 
> > the original communication.  Except as required by
> > law, TransACT 
> > Communications does not represent that this
> > transmission is free of errors, 
> > viruses or interference.
> > 
> > 
> >  
> 
> =
> Connor McDonald
> http://www.oracledba.co.uk
> http://www.oaktable.net
> 
> "Remember amateurs built the ark - Professionals built the Titanic"
> 
> __
> Do You Yahoo!?
> Everything you'll ever need on one web page
> from News and Sport to Email and Music Charts
> http://uk.my.yahoo.com
> -- 
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> -- 
> Author: =?iso-8859-1?q?Connor=20McDonald?=
>   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: Baker, Barbara
  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: List of all zip codes,city,state to load into table.

2002-08-21 Thread Farrell, Thomas M.Mr. NGB-ARNG

Rick,

You can purchase what you want from the USPS for something like $300. I have
never seen it free.
http://www.usps.com/ncsc/

Cheers,
Thom
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Farrell, Thomas M.Mr. NGB-ARNG
  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: PL/SQl question

2002-08-21 Thread Rick_Cale


Is the field in question in table C defined as CHAR or VARCHAR2?  If CHAR
that is why it is blank padded.  Check datatype of variables
in pl/sql

Rick


   
 
DENNIS WILLIAMS
 
   
touch.com>cc:  
 
Sent by:  Subject: PL/SQl question 
 
[EMAIL PROTECTED]
 
m  
 
   
 
   
 
08/21/2002 
 
10:28 AM   
 
Please respond 
 
to ORACLE-L
 
   
 
   
 





> I have a question for from one of my developers related to PL/SQL and how
> data is loaded.
>
> I have a field (marketcode) that is defined as VARCHAR2(3).
>
> I have a problem when I try to load the value of '20' into this field.
> All values with three characters work fine.  The problem is when the
value
> is less then 3 characters.
>
> When tables A and B have data loaded into this field using SQL/Loader the
> resulting value in the field appears to me as '20' with the third
position
> =null.
>
> I have a separate PL/SQL process that loads this field into table C.
> When PL/SQL populates this same value into this field the field appears
to
> me as '20' with the third position = space.   I can't use SQL/Loader for
> this table as the data needs to be massaged before loading into Oracle.
> Thus when you try to link the tables together it does not find a match.
>
>   select A.marketcode, C.marketcode
>   from tableA A, tableC C
>  where A.marketcode=C.marketcode;
>
> (this returns 0 records)
>
>  If I change the SQl statement to the following:
>
>   select A.marketcode, C.marketcode
>   from tableA A, tableC C
>  where A.marketcode=trim(C.marketcode);
>
>  (it correctly matches these up)
>
> Things I have tried to remedy this problem:
> 1)  I have tried to modify my PL/SQL program to put a TRIM statement
> around the marketcode field when I populate table C.   This did not work.
> 2)  I have tried to check the 3rd position and if it is = space then I
set
> the third position to null.  But the field in Oracle is still a space
when
> the program is finished.
>
> Does anyone have any thoughts on how I can properly output this field
from
> Pl/SQl so it will match the data loaded via SQL/Loader? Thanks.
>
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]

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



RE: PL/Sql question

2002-08-21 Thread Jamadagni, Rajendra

Sounds like in the table the field c.marketcode is a char(3) instead of
varchar2(3).

Raj
__
Rajendra Jamadagni  MIS, ESPN Inc.
Rajendra dot Jamadagni at ESPN dot com
Any opinion expressed here is personal and doesn't reflect that of ESPN Inc.

QOTD: Any clod can have facts, but having an opinion is an art!


-Original Message-
Sent: Wednesday, August 21, 2002 10:28 AM
To: Multiple recipients of list ORACLE-L



> I have a question for from one of my developers related to PL/SQL and how
> data is loaded.
> 
> I have a field (marketcode) that is defined as VARCHAR2(3).
> 
> I have a problem when I try to load the value of '20' into this field.
> All values with three characters work fine.  The problem is when the value
> is less then 3 characters.   
> 
> When tables A and B have data loaded into this field using SQL/Loader the
> resulting value in the field appears to me as '20' with the third position
> =null.
> 
> I have a separate PL/SQL process that loads this field into table C.
> When PL/SQL populates this same value into this field the field appears to
> me as '20' with the third position = space.   I can't use SQL/Loader for
> this table as the data needs to be massaged before loading into Oracle.
> Thus when you try to link the tables together it does not find a match.
> 
>   select A.marketcode, C.marketcode
>   from tableA A, tableC C
>  where A.marketcode=C.marketcode;
>   
> (this returns 0 records)
> 
>  If I change the SQl statement to the following:
> 
>   select A.marketcode, C.marketcode
>   from tableA A, tableC C
>  where A.marketcode=trim(C.marketcode);
> 
>  (it correctly matches these up)
>   
> Things I have tried to remedy this problem:
> 1)  I have tried to modify my PL/SQL program to put a TRIM statement
> around the marketcode field when I populate table C.   This did not work.
> 2)  I have tried to check the 3rd position and if it is = space then I set
> the third position to null.  But the field in Oracle is still a space when
> the program is finished.
> 
> Does anyone have any thoughts on how I can properly output this field from
> Pl/SQl so it will match the data loaded via SQL/Loader? Thanks.
> 
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]

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


*This e-mail 
message is confidential, intended only for the named recipient(s) above and may 
contain information that is privileged, attorney work product or exempt from 
disclosure under applicable law. If you have received this message in error, or are 
not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 
and delete this e-mail message from your computer, Thank 
you.*2



RE: drop tablespace including contents

2002-08-21 Thread Hand, Michael T

Russ,

You have my sympathies.  I've been managing SAP databases for the last 7
years, and the last time I let SAPDBA control a reorg was 6.95 years ago.
It performs some tasks reasonably well, like datafile additions and managing
CBO statistics refreshes (especially since SAP wants certain tables to be
left without statistics).  But for reorgs, I prefer more direct control.
Perhaps you can use this SNAFU to convince management to have sapdba
generate the scripts, then allow you to modified them appropriately.  

Mike Hand
Polaroid Corp.

-Original Message-
Sent: Wednesday, August 21, 2002 9:03 AM
To: Multiple recipients of list ORACLE-L


I fully agree.  Unfortunately management insists on it.

Russ

-Original Message-
Sent: Tuesday, August 20, 2002 9:13 PM
To: Multiple recipients of list ORACLE-L


Dick,

There is absolutely *nothing* that SAPDBA does that a reasonably
knowledgeable DBA can't do from his of her favorite toolset.
( vi, Perl and sqlplus for me :)
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Hand, Michael T
  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: List of all zip codes,city,state to load into table.

2002-08-21 Thread Rick_Cale


Sure, please send it
:-)))

RC


   

Jan Pruner 

<[EMAIL PROTECTED]   To: Multiple recipients of list ORACLE-L 
<[EMAIL PROTECTED]>   
>cc:   

Sent by: Subject: Re: List of all zip 
codes,city,state to load into table. 
[EMAIL PROTECTED] 

om 

   

   

08/21/2002 

10:23 AM   

Please respond 

to ORACLE-L

   

   





If you need zip codes, city, streets for Czech Republic I can send it to
you
:-)))

JP

--
 Pruner Jan
   [EMAIL PROTECTED]
 http://jan.pruner.cz/
-

On Wednesday 21 August 2002 15:13, you wrote:
> Hi All,
>
> Where can I get a list of all zip codes,city,states to load into a table.
I
> have searched but cannot find anything to download.
> Anyone have a URL that I can get this info.
>
> Thanks
> Rick

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



RE: List of all zip codes,city,state to load into table.

2002-08-21 Thread DENNIS WILLIAMS

Rick - I think Barbara is right, to get the info in bulk you'll probably
have to pay. A few years ago a friend of mine got a diskette from the U.S.
Post Office that was intended to get bulk mailers to use 9-digit zip codes.
Might be worth a check.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]


-Original Message-
Sent: Wednesday, August 21, 2002 10:08 AM
To: Multiple recipients of list ORACLE-L


Rick:
We pay for a service that gives us this info (for the U.S. and Canada).

The service is from GreatData (www.greatdata.com).  They send us updated
zips about once a quarter.

HTH.
Barb


> --
> From: [EMAIL PROTECTED][SMTP:[EMAIL PROTECTED]]
> Reply To: [EMAIL PROTECTED]
> Sent: Wednesday, August 21, 2002 7:13 AM
> To:   Multiple recipients of list ORACLE-L
> Subject:  List of all zip codes,city,state to load into table.
> 
> Hi All,
> 
> Where can I get a list of all zip codes,city,states to load into a table.
> I
> have searched but cannot find anything to download.
> Anyone have a URL that I can get this info.
> 
> Thanks
> Rick
> 
> 
> -- 
> 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: Baker, Barbara
  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: DENNIS WILLIAMS
  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: List of all zip codes,city,state to load into table.

2002-08-21 Thread Mark Leith

I've heard good things about Quick Address over here in the UK, and see that
they may have a US version as well:

http://www.postcode.com/us/

HTH

Mark

===
 Mark Leith | T: +44 (0)1905 330 281
 Sales & Marketing  | F: +44 (0)870 127 5283
 Cool Tools UK Ltd  | E: [EMAIL PROTECTED]
===
   http://www.cool-tools.co.uk
   Maximising throughput & performance


-Original Message-
Beth
Sent: 21 August 2002 15:58
To: Multiple recipients of list ORACLE-L



Hi Rick,

There are alot of services out there that will sell you a database, with

periodic updates.  Here's one -

www.zipinfo.com

Beth

-Original Message-
Sent: Wednesday, August 21, 2002 9:14 AM
To: Multiple recipients of list ORACLE-L


Hi All,

Where can I get a list of all zip codes,city,states to load into a
table. I
have searched but cannot find anything to download.
Anyone have a URL that I can get this info.

Thanks
Rick


--
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: Seefelt, Beth
  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: Mark Leith
  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).



  1   2   >