Slow database

2001-03-20 Thread Roland . Skoldblom
Hallo all you experts, I have an Oracle database, every night it is read many files into the database, but all the procedures take so long, it keeps taking all the next day almost. It shouldnt do that, because the system is very slow because of this. When I run other things during the day,

SGA Parameters ...

2001-03-20 Thread Harsh Agrawal
Hi, Can u help me to knoe what are the initDB.ora parameters contributing these ? Pl. give one to one or one to many mapping of these with the parameters. - Total System Global Area 57124108 bytes Fixed Size70924

RE: CDI-21600: A running generator o

2001-03-20 Thread Belov Igor
:) the probled solved by upgrading Forms up to 6.0.8.8.0 -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 06, 2001 7:06 PM To: Multiple recipients of list ORACLE-L Subject: RE:CDI-21600: A running generator o I faced the

RE: How to find SEQUENCE#

2001-03-20 Thread Trassens, Christian
So rely on v$log_history. Regards. -Mensaje original- De: Vadim Gorbounov [SMTP:[EMAIL PROTECTED]] Enviado el: lunes 19 de marzo de 2001 21:11 Para: Multiple recipients of list ORACLE-L Asunto: How to find SEQUENCE# Hi, DBAs, Can anybody give me a guess,

RE: OT: Oracle *Chocolate* Monitoring Tools/Friday Recipe

2001-03-20 Thread lerobe - Lee Robertson
Been drinking it in the UK for most of my 37 years !!! Used to be a plain old pick me up for years (if you ever had to go into hospital or indeed went visiting, you were either given or giving a bottle). Nowadays it is used by sportsmen etc for exactly what you have described. Regards Lee

RE: OT: Oracle *Chocolate* Monitoring Tools/Friday Recipe

2001-03-20 Thread Steve . Parker
They even do a low calorie version with sweetners instead of glucose... What's the point ! Steve Parker Technical Consultant LIS -- Logistics Internet Systems Ltd. Knaves House, Knaves Beech Business Centre Loudwater, High Wycombe Buckinghamshire , HP10

BUG in installing Designer6 Repository on 8.1.7 database

2001-03-20 Thread Sonja ehovi
List hi! Here is description of the Bug we found. It is quite unpleasent. For a while everything looks just nice, then installation freeze. There are no errors of any kind; system just hangs (and it can lasts for hours)! It cost me 3 hours, before I realized something is very wrong (you think

RE: Re:RE: RE: Oracle DBA evolution path - please share your opi

2001-03-20 Thread Mark Leith
Title: RE: Re:RE: RE: Oracle DBA evolution path - please share your opi ---snip--- OK then, since you were including all the employees, and since you didn't mention Quest in your list of companies, I'll forgive you. But just in case you didn't know, the main source of the

NLS_DATE_FORMAT not effective..help!

2001-03-20 Thread Arul kumar
Hi Gurus, We want to change the default date format of oracle from 'dd-mon-yy' to 'MM/DD/' format for one of our database ( 8.1.6 ). I have set NLS_DATE_FORMAT as "MM/DD/" (also tried for year!) in init file. It doesn't seems to have any effect when i query sysdate (SQL PLUS)

RE: Recipes, as promised

2001-03-20 Thread Sonja Sehovic
That sounds great! Could you please translate this to European measures? TIA, Sonja -Original Message- Sent: Monday, March 19, 2001 4:36 PM To: Multiple recipients of list ORACLE-L Man, I am going to have to climb more mountains. -Original Message- Sent: Saturday,

Re: NLS_DATE_FORMAT not effective..help!

2001-03-20 Thread G . Plivna
Yea, to see it on a clint's SQL*Plus You have to modify \Hkey_local_machine\software\oracle\NLS_DATE_FORMAT At least this is on NT, I don't know about 95, 98 Gints Plivna

If-statement

2001-03-20 Thread Roland . Skoldblom
Hallo, Do you have any good example on how to write a procedure, that checks if there is a ? in a column in tna table in te database. If it is a ? then it will be put a "0" in the place where it is a ?. If it is not a ? then it will be the no change in that place. Please help me with this

RE: Recipes, as promised

2001-03-20 Thread Mark Leith
Ingredients: 1/2 lb (8oz/230g) unsweetened chocolate (8 squares) 1/2 lb (8oz/230g) sweet butter cut into cubes, plus butter for greasing the pan 8 egg yolks (large eggs) 1 1/4 (Again this around 8oz/230g) cups sugar 5 egg whites (5 jumbo sized super chicken eggs) 1 tsp powdered cocoa

Re: FK Constraints

2001-03-20 Thread Thater, William
Rachel Carmichael wrote: the DBA is not responsible for the data?? Could you PLEASE come to my office and explain that (I'll bring the heavy club) to my developers, users and management? They seem to believe that my primary function is to dig information out of the database for them.

Re: OT: Oracle *Chocolate* Monitoring Tools/Friday Recipe

2001-03-20 Thread Thater, William
Rachel Carmichael wrote: but Moom, the icky bugs TOUCHED the chocolate! :) just think of it as "quality protein". and yes i have munched a bug or to, with and without the chocolate.;-) -- Bill Thater Certifiable ORACLE DBA Telergy, Inc [EMAIL PROTECTED]

RE: maintaining a backup table on another server

2001-03-20 Thread john . armani
Thanks for the reply Jacques. I need to insert quite a bit of data (say 300-400 rows), and would like to perform the inserts as the data is collected. I would like to have the two server connections open at once. Otherwise, I would need to buffer the data and update each server separately.

DBMS_OUTPUT.PUT_LINE

2001-03-20 Thread Roland . Skoldblom
Hello, Anyone who has a suggestion how to write the DBMS_OUTPUT.PUT_LINE command if I want to display the numbers of inserts done in that script? Would appreciate it very much if anyone could help.. Roland Skldblom -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author:

Re: FK Constraints

2001-03-20 Thread Sherrie . Kubis
Ramani: I live daily with the negative effects of referential integrity enforced (sometimes) at the application level. From my standpoint, there have been no "pros" to this method. I need to use a lot of data from our mainframe DB2 database, where all of the RI is written into their

Re: If-statement

2001-03-20 Thread Andor Gyula
Hi Try using Translate function [EMAIL PROTECTED] wrote: Hallo, Do you have any good example on how to write a procedure, that checks if there is a ? in a column in tna table in te database. If it is a ? then it will be put a "0" in the place where it is a ?. If it is not a ? then it

RE: How to find SEQUENCE#

2001-03-20 Thread Vadim Gorbounov
Thank you Christian, That's almost what I was looking for. One issue - it doesnt work when I replace unrecoverable file with fresh hot copy. Vadim -Original Message- Sent: Tuesday, March 20, 2001 2:55 AM To: Multiple recipients of list ORACLE-L So rely on

RE: If-statement

2001-03-20 Thread Jorma . Vuorio
You don't have to use any if's, but use translate function: update Your_table set Your_column = translate(Your_column,'?','0'); HTH Jorma -Original Message- From: ext [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 20 March, 2001 13:41 To: Multiple recipients of list ORACLE-L

RE: RE: OT: Oracle *Chocolate* Monitoring Tools/Friday Recipe

2001-03-20 Thread Rachel Carmichael
Kirti, I'd have to be truly desperate to eat chocolate that bugs had touched :) Of course, most American milk chocolate has a high wax content, which is why I prefer Europrean milk chocolate. Bittersweet rules totally though, wherever it's made Rachel From: "Deshpande, Kirti" [EMAIL

ops on linux

2001-03-20 Thread cyhu
Has anyone here installed ops on linux? ( oralce 8.1.7.0.1) I just could not start the related daemons by using $ORACLE_HOME/oracm/bin/ocmstart.sh. The machine just hanged every time I ran ocmstart.sh. Any suggestions? Thanks in advance. -- Please see the official ORACLE-L FAQ:

RE: OT: Oracle *Chocolate* Monitoring Tools/Friday Recipe

2001-03-20 Thread Rachel Carmichael
rhubarb flavored rock I'm working on a tentative assumption here that you don't mean actual rocks... translation please! From: lerobe - Lee Robertson [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: OT: Oracle

Re:RE: RE: OT: Oracle *Chocolate* Monitoring Tools/Friday Re

2001-03-20 Thread dgoulet
Rachel, If you were given one, as I was in Nam, you'd not know the difference. Looks like, tastes like a crunch bar for the most part, except for the logo on top. It just crunches better. Dick Goulet Reply Separator Author: "Rachel Carmichael"

RE: If-statement

2001-03-20 Thread William Rogge
Not worth all the effort. select translate(te.tna,'?','0') from dual; done deal. -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, March 20, 2001 6:41 AM To: Multiple recipients of list ORACLE-L Subject:If-statement Hallo, Do you have

RE: Lemon Juice in Ants Pooh-Poohed

2001-03-20 Thread Paul Baumgartel
Can't the list members PUH-LEEZE stick (mostly) to messages germane to the purpose of this list? I don't mind the occasional off-topic post, but, for crying out loud, how about a little restraint? The original recipe posting(s) have given rise to a plethora of messages about chocolate, sugar,

RE: NLS_DATE_FORMAT not effective..help!

2001-03-20 Thread Martin Kendall
Just create a Database on-logon trigger and setup the date as you want it. Then providing any "client" does not do an alter session you will have a standard DB date format. -Original Message- Sent: 20 March 2001 08:36 To: Multiple recipients of list ORACLE-L Hi Gurus, We want to

Insert without telling column names

2001-03-20 Thread Roland . Skoldblom
Hallo, How can I create an insert statement without telling all the names of the columns? Give an example, please. Roland Skldblom -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858)

Re:RE: Re:RE: RE: Oracle DBA evolution path - please share y

2001-03-20 Thread dgoulet
Well, Since I started this I guess I'll wade back in, but I'll save everyone some bandwidth in the process. To Jaques (sorry I don't think I spelled that right) point and Mike's too most of the rotten third party software I've seen does have a BAD management team behind it in one way or

Re: FK Constraints

2001-03-20 Thread Rodd Holman
Rachel, One way I got this across to my developers and users was in creating new users for the DB. Every time I got a new user request, I would forward it to the director of the group that officially "owns" the data to get his permission to allow them in HIS data. After a few round robins of

oracle training

2001-03-20 Thread Streeter, Lerone A LBX
what's a favored source for training? === Lerone Streeter System Analyst Abbott LBG [EMAIL PROTECTED] === -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Streeter, Lerone A LBX

ITL and possible deadlocks

2001-03-20 Thread Shevtsov, Eduard
Hello List, it's rather a theoretical question. Let say two sessions update a table. Each transaction allocated a transaction slot in a block (I consider the two different blocks). Each block has only one slot and there is no free space in these blocks to allocate additional transaction slots.

Re: DBMS_OUTPUT.PUT_LINE

2001-03-20 Thread Bunyamin K.Karadeniz
I looked at the documentation and could not see a function giving that . But you can declare a variable and increase it after each insert ( if you do the inserts in a loop , it is good). Then dbms_output.put_line(variable_name); Bunyamin - Original Message - To: Multiple recipients

RE: Lemon Juice in Ants Pooh-Poohed

2001-03-20 Thread Toepke, Kevin M
Kevin, Kevin, Kevin... Don't diss my Cave Crickets. Are you sure they're cave crickets? (They're not even crickets! They're related to the grasshopper) Are the antenea as long as the rest of the body? And even if they are Cave Crickets, they won't bother you. They just come out of the cave to

RE: Lemon Juice in Ants Pooh-Poohed

2001-03-20 Thread Mohan, Ross
Title: RE: Lemon Juice in Ants Pooh-Poohed Paul, I agree with you: enough is enough. Post a recipe and get it out of your system. Kwitcherbitchin'. G Any thoughts on the evolution or travel patterns of sugar/chocolate coated arthropods who have chosen database clerking as a career? I

RE: OT: Oracle *Chocolate* Monitoring Tools/Friday Recipe

2001-03-20 Thread Anderson, Brian
-Original Message- Just keep the supply of Diet Coke coming. :) Make that "Tab", for me. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anderson, Brian INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San

RE: DBMS_OUTPUT.PUT_LINE

2001-03-20 Thread Diana Duncan
Roland, The only trick with dbms_output.put_line is to set your serveroutput on. The following is a sample script to be run in SQL*Plus. Warning: it's a stupid script, you'd never want to do this in real life. :) set serverout on declare cursor some_cursor is select *

Re: Insert without telling column names

2001-03-20 Thread David A. Barbour
Roland, You can't. There are a number of ways to really cut down on the code required to do an insert, but if you think about it, how will Oracle know where the data is supposed to go if you don't give it the column name(at some point)? If you're using 8i, there is a direct load insert, but as

RE: OT: Oracle *Chocolate* Monitoring Tools/Friday Recipe

2001-03-20 Thread lerobe - Lee Robertson
ermI don't know how this travels. Like a sugary candy which is extremely hard, you do have candy canes in the States for Christmas trees etc ?? Sort of thicker, straighter version and normally minty in the UK - very popular at Seaside resorts where the sweet is manufactured with the name of

RE: Slow database

2001-03-20 Thread Diana Duncan
Maybe the "big" process is not doing intermittent commits, and is straining the rollback segments? Have you checked the growth and skew of your indices? Have you checked whether you can disable the indices while the process is running, then enable them? Is it doing inserts or updates or both?

How long will 8.0.6 be supported?

2001-03-20 Thread Smith, Ron L.
I can't get into Metalink. Can anyone tell me how long 8.0.6 will be supported? Ron Smith Database Administration [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- (858)

Re: DBMS_OUTPUT.PUT_LINE

2001-03-20 Thread David A. Barbour
Roland - Depending on how your inserts are being generated, why don't you use a counter or the ROWCOUNT function? Regards, David A. Barbour Oracle DBA Formerly with the now defunct and bankrupt ConnectSouth "Bunyamin K.Karadeniz" wrote: I looked at the documentation and could not see a

Re: Insert without telling column names

2001-03-20 Thread jkstill
On Tue, 20 Mar 2001 [EMAIL PROTECTED] wrote: Hallo, How can I create an insert statement without telling all the names of the columns? Give an example, please. Roland Sköldblom Roland, You can omit column names only if you are inserting into all columns of the table, in the same order

RE: Someone changed INTERNAL password URGENT

2001-03-20 Thread Hillman, Alex
If you are on unix - you do not need internal password if you log in as member of dba group. On NT before 8.1 you need internal password but you can change it recreating password file or recreating instance using oradim. Alex Hillman -Original Message- From: Murali

RE: Someone changed INTERNAL password URGENT

2001-03-20 Thread Miller, Dave
There is not internal password, per se. If you are using unix, you need to be part of the DBA group to connect internal. I'm not sure how it works on NT. -Original Message- Sent: Tuesday, March 20, 2001 9:18 AM To: Multiple recipients of list ORACLE-L URGENT, Someone changed the

RE: How long will 8.0.6 be supported?

2001-03-20 Thread Malkuns, Skip
Oct 2001 -Original Message- From: Smith, Ron L. [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, March 20, 2001 11:36 AM To: Multiple recipients of list ORACLE-L Subject: How long will 8.0.6 be supported? I can't get into Metalink. Can anyone tell me how long 8.0.6 will be

Re: Insert without telling column names

2001-03-20 Thread Ruth Gramolini
Here is what my sqlplus training (Oracle) says: Inserting New Rows Insert a new tow containing values for each column. Optionally lisgt the columsn in the INSERT clause. HTH, Ruth - Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Tuesday, March

RE: OT: Oracle *Chocolate* Monitoring Tools/Friday Recipe

2001-03-20 Thread Mark Leith
They do sweets over here - kind of like hard boiled sweets - or the famous British Rock - which is basically a long stick of hard sweet. The rhubarb sort is more commonly known to me in the form of a "Rhubarb Custard" flavoured sweet (small hard boiled kind of things :) Lucozade was another of

RE: Lemon Juice in Ants Pooh-Poohed

2001-03-20 Thread Hillman, Alex
Paul, you are in deep trouble :-). Somebody will sure "remind" you in that you have delete button etc. Alex Hillman -Original Message- From: Paul Baumgartel [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, March 20, 2001 9:31 AM To: Multiple recipients of

Re:Just like Christmas

2001-03-20 Thread dgoulet
Kimberly, Enjoy the N class boxes, especially in 64 bit mode. They really cook compared to a K. Dick Goulet Reply Separator Author: Kimberly Smith [EMAIL PROTECTED] Date: 3/20/2001 8:15 AM Two brand spanking new N-Class servers arrived

RE: Lemon Juice in Ants Pooh-Poohed

2001-03-20 Thread Hillman, Alex
Paul, you are in big trouble :-). Somebody will sure remind (with !) you that you have delete button. Alex Hillman -Original Message- From: Paul Baumgartel [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, March 20, 2001 9:31 AM To: Multiple recipients of

RE: DBMS_OUTPUT.PUT_LINE

2001-03-20 Thread Jeffery Stevenson
Won't that continuously print: Inserted 1 rows. Inserted 1 rows. ... (well, as long as you don't get a primary/foreign key exception) :) Jeffery Stevenson Chief Databeast Tamer Medical Present Value, Inc. Austin, TX -Original Message- Sent: Tuesday, March 20, 2001 10:11 AM To:

RE: Someone changed INTERNAL password SOLVED..

2001-03-20 Thread Murali Vallath
We do not have a practice to give password for the internal account. So when it promoted it sounded like someone had assigned a password. Apparently there was a parameter SQLNET.AUTHENTICATION_SERVICES parameter added to the sqlnet.ora file. when I commented this out. It worked. Thanks for

Free Oracle DBA tests on the web

2001-03-20 Thread andrey
Hi DBAs ! I'm looking for some FREE Oracle DBA / developer resources on the web : self-tests , OCP preparations materials , articles , books , etc ... Please share your resources ! Thanks a lot in advance . Andrey .

RE: Insert without telling column names

2001-03-20 Thread Jacques Kilchoer
Title: RE: Insert without telling column names -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] How can I create an insert statement without telling all the names of the columns? Give an example, please. As Jared mentioned, if you are inserting into all

RE: RE: RE: OT: Rachel in Vietnam

2001-03-20 Thread Mohan, Ross
Title: RE: RE: RE: OT: Rachel in Vietnam Dick , Didn't you know? Rachel WAS in Nam. But she never talks about it. I think it had to do with the bugs. Just a thought. Ross -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Tuesday, March 20, 2001

RE: Someone changed INTERNAL password URGENT

2001-03-20 Thread Harsh Agrawal
Hi, Pl. check in {ORACLE_HOME}/database directory there is a file PWDSID NAME.ora. Just move this file some where and try to connect. Bye -Original Message- Sent: Tuesday, March 20, 2001 4:18 PM To: Multiple recipients of list ORACLE-L URGENT, Someone changed the internal

RE: OT: Oracle *Chocolate* Monitoring Tools/Friday Recipe

2001-03-20 Thread Hand, Michael T
Sorry Lee, it looks like Rachel is too much of a chocoholic to be up on her hard candy nomenclature. In the US its refered to as Rock candy, basically colored, flavored, crystaline sugar (sucrose, not glucose) available in various shapes and sizes though I haven't seen much of it lately. [It's

Just like Christmas

2001-03-20 Thread Kimberly Smith
Two brand spanking new N-Class servers arrived yesterday as I was leaving work. Sure look nicer then the K-Class's we currently run on. Can't wait to get my hands on it. Plus I got a brand new NT server just waiting for me as well (although its awfully hard to get excited about that one let me

RE: Someone changed INTERNAL password URGENT

2001-03-20 Thread Cale, Rick T (Richard)
You can use the orapwd utility to recreate password file with new internal password. Rick -Original Message- From: Murali Vallath [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, March 20, 2001 9:17 AM To: Multiple recipients of list ORACLE-L Subject: Someone changed INTERNAL

AUDITING - DEFAULT FOR CONNECT INTERNAL

2001-03-20 Thread Raj Sakthi
Hi Folks , When I was tracing connect internal in sqlplus I came across this quirk and of course I have to investigate Guess what I found...: ) Bookmark Fixed font Go to End Doc ID: Note:107842.1 Audit Trail: Connect Internal Type: BULLETIN Status: PUBLISHED Content Type:

RE: Lemon Juice in Ants Pooh-Poohed/Redo Log Switching

2001-03-20 Thread MacGregor, Ian A.
While I've stayed away from the discussions about offended dieties and the like where people espouse their philosophies of life, I could not let an assertion which was clearly mistaken stand. In fairness to Mr. Steven, ants will have some citric acid in their bodies; it is an intermediate

RE: Insert without telling column names

2001-03-20 Thread Diana Duncan
Roland, Check out the SQL manual, the syntax diagram clearly illustrates that you don't need to explicitly name the column names as long as you are inserting into all of the columns in the order they are defined in the data dictionary. insert into table_A values ('Hi', 'there'); A word of

RE: DBMS_OUTPUT.PUT_LINE

2001-03-20 Thread Diana Duncan
Yup. Like I said, you'd never want to do this in real life. I was just illustrating the idea. -Original Message- Sent: Tuesday, March 20, 2001 12:30 PM To: Multiple recipients of list ORACLE-L Won't that continuously print: Inserted 1 rows. Inserted 1 rows. ... (well, as long as

RE: Lemon Juice in Ants Pooh-Poohed

2001-03-20 Thread Kevin Kostyszyn
Everything about them is long except their body's. Oh Man!! If you like'em, come on down to my house this spring and you take all of them out of the pool change room!! They sit in there, on the cieling, on the floor on the walls!! I can't deal, I know they can't hurt me, but they are just so

RE: NLS_DATE_FORMAT not effective..help!

2001-03-20 Thread VIVEK_SHARMA
Arul In init.ora have you specified MM/DD/ WITHOUT Quotes , as follows simply :- NLS_DATE_FORMAT=MM/DD/ -Original Message- From: Martin Kendall [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, March 20, 2001 6:36 PM To: Multiple recipients of list ORACLE-L Subject: RE:

Re: FK Constraints

2001-03-20 Thread Rachel Carmichael
I don't get new user requests.. I get requests from end-users for data. But I understand. And I know that it's a question of coming in with the baseball bat and assorted heavy weaponry and making a stand (or as my CTO is fond of saying "putting a stake in the ground") Just haven't collected

RE: Lemon Juice in Ants Pooh-Poohed

2001-03-20 Thread Hillman, Alex
It was sarcastic. Alex Hillman -Original Message- From: Kimberly Smith [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, March 20, 2001 12:37 PM To: Multiple recipients of list ORACLE-L Subject:RE: Lemon Juice in Ants Pooh-Poohed

Re: How long will 8.0.6 be supported?

2001-03-20 Thread Bill Gentry
09/30/2001 unless you have Extended Support, then it's 09/30/2004 - Original Message - To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED] Sent: Tuesday, March 20, 2001 10:36 AM I can't get into Metalink. Can anyone tell me how long 8.0.6 will be supported? Ron Smith

RE: Lemon Juice in Ants Pooh-Poohed

2001-03-20 Thread Kimberly Smith
Actually, he was very valid in his request. He did not ask that you completely stop but rather add the OFF-TOPIC into the subject so it can be ruled out. It has been a rather long discussion with lots of e-mails (not that I am complaining, just seeing his point). -Original Message-

Re: Free Oracle DBA tests on the web

2001-03-20 Thread Ron Rogers
Andrey, Here is a partial list that I have. I give credit for these site and their content to the original authors. This is a partial list I have gleaned from this list. ROR mm http://www.stewartmc.com/oracle http://www.stewartmc.com/oracle/tips.html www.oraes.com/scr/expfull.sh

Re: Insert without telling column names

2001-03-20 Thread Regina Harter
At 08:36 AM 3/20/01 -0800, you wrote: Roland, You can't. There are a number of ways to really cut down on the code required to do an insert, but if you think about it, how will Oracle know where the data is supposed to go if you don't give it the column name(at some point)? Of course you can.

32bit vs 64bit (was: Just like Christmas)

2001-03-20 Thread Jesse, Rich
Interesting. We've got a 4-way K570 w/3GB mem that we'll be moving from HPUX 10.20 to HPUX 11.0 this weekend (8 hours of watching tape spin), which means I can FINALLY get us to 8i! YAY! So, why or why not should one go to 64bit? Here's my perception: Pros ---

RE: How long will 8.0.6 be supported?

2001-03-20 Thread Adams, Matthew (GEA, 088130)
Title: RE: How long will 8.0.6 be supported? According to a spreadsheet I've got normal support ends 30-Sep-2001 Extended Assistance Support ends 30-Sep-2004 Matt Adams - GE Appliances - [EMAIL PROTECTED] Doing linear scans over an associative array is like trying to club someone

OT -- Canada Rules!

2001-03-20 Thread Kathe Newsome
Well, group- I have completely enjoyed the discussion on Canada, especially since I make my first trip to Toronto this April. But can someone tell me what Smarties are? And Crispy Crunch/Coffee Crisp? Thanks- Kathe -- Kathe C. Newsome Centenary College of Louisiana Sr. Software

RE: OT -- A humorous reply to the Canada rulz

2001-03-20 Thread Dasko, Dan
U, Is this kinda like Mr. Sulu on Star Trek who was sure that the Russians invented everything? I might be wrong (happens all the time), but I thought Baseball and Basketball were distinctly inventions of the USA. You might be able to tell I'm a rabid fan of neither. Penicillin and the

SUN vs. HP

2001-03-20 Thread Alex Apostolopoulos
Hi, we are currently in the process of evaluating a high availiability cluster for our production database. The final two solutions are: SunCluster 2x420R 2Gig 2x450Mhz Storage 100Gig Hewlett Packard MC ServiceGuard 2xL-Class 2x440Mhz 2Gig Storage VA 7100 100Gig Based on our criterias

RE: OT -- Canada Rules! (fwd)

2001-03-20 Thread Kevin Kostyszyn
Yeah, but we could kick your XXX!! Not to mention that American Hockey players are just as good if not better than Canadians! -Original Message- Patrice J Sent: Tuesday, March 20, 2001 12:37 PM To: Multiple recipients of list ORACLE-L Sorry about this, but someone sent me this and I

Re: redo log timing

2001-03-20 Thread Rodd Holman
Ian, This is one of those where you can get the old "it depends" answer. What type of database is this? What level of transaction activity do you have? How big are your redo logs if you switch every 15 min, 20 min, 30 min? How critical is recovery to the current time to you? If you don't

Re: Free Oracle DBA tests on the web

2001-03-20 Thread Ron Rogers
Andrey ' Electronic books can be found at: RUSSIAN FREE BOOKS HTML FORMAT_+++ http://docs.rinet.ru/ ROR mm [EMAIL PROTECTED] 03/20/01 12:36PM Hi DBAs ! I'm looking for some FREE Oracle DBA / developer resources on the web : self-tests , OCP preparations materials , articles , books

OFF-TOPIC: RE: OT -- A humorous reply to the Canada rulz

2001-03-20 Thread Kimberly Smith
First off, I had no idea that a Canadian had invented baseball but a Canadian most definitely invented Basketball. Go look it up. However, he was in the States when he invented it. Once we get rid of Quebec we will have no issues as to what language we are. We are bilingual. Except for

RE: OT -- A humorous reply to the Canada rulz

2001-03-20 Thread Kevin Kostyszyn
Wow that was good!! You know, I don't really like baseball, but I am pretty sure that when you drive into Hoboken it says on a sign "Home of Baseball and Frank Sinatra". hmm Canada invented hockey, but they also invented curling didn't they. Yeah, isn't that like the Canadian version of

RE: 32bit vs 64bit (was: Just like Christmas)

2001-03-20 Thread Kimberly Smith
We are going 64-bit for HP but keeping Oracle at 32-bit. We really had no choice for the HP side. We just need the memory that 32 bit could not support. We have 9 K-class servers here that have been running 11-64-bit for quite some time (relatively speaking). But we are getting rid of all our

RE: RE: RE: OT: Rachel in Vietnam

2001-03-20 Thread Rachel Carmichael
I'm old but not THAT old :) would not have been draftable even at the end of the war (even if I were male!) From: "Mohan, Ross" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: RE: RE: OT: Rachel in Vietnam Date: Tue, 20 Mar

RE: OT: Oracle *Chocolate* Monitoring Tools/Friday Recipe

2001-03-20 Thread Rachel Carmichael
I thought it was that, but figured it was better to ask... you can find rock candy these days in the fancier candy stores masquerading as coffee stir sticks :) From: "Hand, Michael T" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]

RE: OT -- Canada Rules!

2001-03-20 Thread Kimberly Smith
Smarties rule. Much better then MM's. And for those of you who think that Smarties are those sugar candies, its not that man. People here at work had no clues either so I had my mom ship up a whole wack of them. I don't like Crispy Crunch bars but the Coffee Crisp bars are pretty good.

RE: OT -- Canada Rules! (fwd)

2001-03-20 Thread Kimberly Smith
Do you know that all most of the top ranked American/European hockey players actually played in the CHL. They start by getting drafted in the major junior leagues. So ya, you could be just as good as an American, as long as you train in Canada. In Canada if you are playing hockey for your

RE: SUN vs. HP

2001-03-20 Thread Kimberly Smith
I have no experience with the Sun cluster but I do have experience with the HP ServiceGuard as its what we run here. We have even had it fail. We do have a Sun server here with a database on it and although I like the server and have no complaints I am much happier with HP. There are just

Re: SUN vs. HP

2001-03-20 Thread Gene Sais
Check the numbers again, especially the software. Having done the same study 1.5 yrs ago, HP was a little more expensive in the HW but much cheaper in SW. Reason being Sun uses Veritas Trusted Cluster (expensive $100k) for HA and HP uses MCServiceguard. I've worked 5 yrs w/ Sun and 1.5 yrs

Find special characters in the database

2001-03-20 Thread Shakeel Qureshi
Can someone give me a guideline as to how I should draw a script to find special characters in the database and replace them with blanks. TIA Shakeel Qureshi [EMAIL PROTECTED] __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail.

RE: OT -- Canada Rules! / Chocolate ...

2001-03-20 Thread Hand, Michael T
Kathe, I thought every red-blooded American knew what Smarties where. And since I have become the newest OCP (Other Confection Professional), I will enlighten you. Smarties are a "penny" candy, sour in taste about the size of an MM vended in plastic wrap of 12-15 in a stack. I think Crispy

RE: OT -- A humorous reply to the Canada rulz

2001-03-20 Thread Hand, Michael T
Dan, You've made one of the only mortal sins of the Internet, it's not dis'ing the Canadians. It's making an inaccurate Star Trek reference. The ensign of Russian-descent was Pavel Checkov played by . . . joined the cast in episode # ... entitled ... Your penance should be long and severe.

Indexes and tablespaces

2001-03-20 Thread Berindei Alex
Hello, I have a partitioned historical table in tablespace TS1 with 8 local indexes. I'm not sure how is better to: - put the eight indexes in separate tablespaces (with small extents) or - create just one big tablespace (with larger extents) for all indexes. Other concerns include: - a

RE: OFF-TOPIC: RE: OT -- A humorous reply to the Canada rulz - s

2001-03-20 Thread Dasko, Dan
WoooHooo, this could really get things hot down here. Again, I have no idea of what I'm talking about. Just a bunch of stuff that I "know" which is probably wrong. Additionally, I imagine people in Miami think Philadelphia is the Great White North, so the whole bikini thing was a jab at the

Re: Free Oracle DBA tests on the web

2001-03-20 Thread Andy Duncan
Hi Andrey, Hi DBAs ! I'm looking for some FREE Oracle DBA / developer resources on the web : self-tests , OCP preparations materials , articles , books , etc ... Please share your resources ! Thanks a lot in advance . cheap_salesman_hey_a_guys_gotta_eat Check out the links in Table 1-1 on

RE: OFF TOPIC: RE: Lemon Juice in Ants Pooh-Poohed

2001-03-20 Thread Kevin Kostyszyn
OH GOD THAT'S IT!!! I can't even look at the thing on my monitor...man I have problems! -Original Message- Travis Sent: Tuesday, March 20, 2001 1:51 PM To: Multiple recipients of list ORACLE-L I think what you are referring to is the camel [back] cricket, which is also known as the

RE: OFF-TOPIC: RE: OT -- A humorous reply to the Canada rulz

2001-03-20 Thread Kevin Kostyszyn
Answered your own question, we have more money!!! It's fun to go to Canada and feel like a "wealthy" american. Jeez, I wished I lived in Buffalo, I would go to Canada and hang out and spend less money! hahaah jk, not trying to pick a fight USA RULES -Original Message- Smith

RE: OFF-TOPIC: RE: OT -- A humorous reply to the Canada rulz

2001-03-20 Thread Shaw, John B
And like a lot of Canadian doctors he became an U.S. citizen -Original Message- Sent: Tuesday, March 20, 2001 12:57 PM To: Multiple recipients of list ORACLE-L First off, I had no idea that a Canadian had invented baseball but a Canadian most definitely invented Basketball. Go look it

RE: OT -- Canada Rules! / Chocolate ...

2001-03-20 Thread Kimberly Smith
The Smarties we are talking about in Canada are much different. Candy covered chocolate. No sour taste at all. Crispy Crunch is a chocolate bar (forget what the inside is, maybe peanut butter). -Original Message- Sent: Tuesday, March 20, 2001 1:30 PM To: Multiple recipients of

  1   2   >