Re: Oracle 9.2 Stability Feedback Requested
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
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
(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 worlds 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
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
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
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
"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
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
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
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
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!
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
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!]
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
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
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
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
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
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
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
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!
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
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
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
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
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
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
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
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
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.
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
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
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
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)
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
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
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
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
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)
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
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
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
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
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.
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)
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)
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
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
> 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
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
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
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
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
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
> 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
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
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
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
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
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
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
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
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)
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
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.
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
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
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
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
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
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
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
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
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
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.
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
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
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
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
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
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
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
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
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
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
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
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
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.
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
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
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
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
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.
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
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
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
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.
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.
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.
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).