Re: On removing spaces from string

2001-08-20 Thread Jared Still
On Sunday 19 August 2001 21:50, Amar Kumar Padhi wrote: Hi, The need is to remove all spaces from a provided string, but if a space exists between two numbers, then it should not be removed. Look at the following examples. original string output required XT GB 100 XF 100

RE: On removing spaces from string

2001-08-20 Thread Amar Kumar Padhi
Thankyou Jared. -Original Message- Sent: Monday, August 20, 2001 10:57 AM To: Multiple recipients of list ORACLE-L On Sunday 19 August 2001 21:50, Amar Kumar Padhi wrote: Hi, The need is to remove all spaces from a provided string, but if a space exists between two numbers, then it

RE: Data Warehouse book

2001-08-20 Thread Thomas, Kevin
I bought one from the Oracle Press, don't actually have it on me at the moment, but it does explain the basics through to the more complicated concepts...I think it was simply called data warehousing or the datawarehouse handbook...something along those lines. -Original Message- Sent: 17

RE: but will it run windows?

2001-08-20 Thread Sinardy
Solaris Ultra 10 440Mhz UltraSPARC III with DDS3 drive, CDROM, Floppy drive, 256Mb memory, 17 monitor ect... cost me about US$5000 + Preinstalled Solaris 2.7 -Original Message- Kevin Sent: Monday, 20 August 2001 4:10 PM To: Multiple recipients of list ORACLE-L I run redhat linux 7 on

RE: Data Warehouse book

2001-08-20 Thread Daemen, Remco
Oracle 8i Data Warehousing, from Oracle Press, ISBN 0-07-212675-2 -Oorspronkelijk bericht- Van: Thomas, Kevin [mailto:[EMAIL PROTECTED]] Verzonden: maandag 20 augustus 2001 10:35 Aan: Multiple recipients of list ORACLE-L Onderwerp: RE: Data Warehouse book I bought one from the Oracle

Get Network Not OK : ORACLE OCI

2001-08-20 Thread paquette stephane
We're receiving the message : Get Network Not OK : ORACLE OCI when Business Objects WeBIntelligence tries to connect to Oracle 816. The client is running Solaris 8, the message is happening with Oracle client 817 or with Oracle client 816 64 bit. I can connect without problem using Sqlplus

Picking up the tab

2001-08-20 Thread O'Neill, Sean
I have to document our Oracle databases for the case where I'm e.g. hit by the proverbial bus. So if you DBA folk were to come on site to pick up the tab and start managing our databases what information would you like to be able to refer to, to allow you get up to speed as quickly as possible

RE: w2k scripting

2001-08-20 Thread Guy Hammond
Title: w2k scripting Perl on Windows is great, when you consider things like manipulating the user database or system log, it's probably more useful on Windows than it is even on Unix. And DBI works the same on both platforms. There is a thing called "Windows Scripting Host" which is

RE: LOTR Teaser Pictures! :The link

2001-08-20 Thread Boivin, Patrice J
What's with the hand over the jeweled ring? The picture is too dark to make out. Some pictures of orcs, but not of members of the Company, a dwarf, Elrond or Galadriel. Sigh I guess we'll have to wait. The picture of Frodo and Sam walking through the field looks really good, they did a good

FW: Data Warehouse book

2001-08-20 Thread Terrian, Tom
Here are the results so far.anyone else care to vote on a good data warehousing book? Oracle 8i Data Warehousing, Oracle Press - 2 vote The Data Warehouse Tool Kit, Ralph Kimball -3 votes The Data Warehouse Lifecycle Toolkit, - 1 vote Ralph Kimball Essential

blob field and FORMS6i

2001-08-20 Thread Bunyamin K. Karadeniz
I want to insert into a table and open a pdf and word document. here is the table create script . And I do a FORM and assign the blob field as OLE Conteiner and the problems start. And I can not do that . How do you do that ? Any idea please?Anyone did something like this Thank you

RE: Pre-assing space

2001-08-20 Thread Farnsworth, Dave
- RE: Pre-assing space This subject sounds like something to do with a damagement staging area! :o) Dave -Original Message- Sent: Friday, August 17, 2001 8:10 PM To: Multiple recipients of list ORACLE-L I need to know who many space is pre-assign in a oracle database?? javs

OT : Doing an Unix upgrade by using backup/restore from another s

2001-08-20 Thread Kuijten, F. (Frank)
Hello, This past weekend, we've tried to upgrade our TRU64 4.0d system (with TRUCluster) to 4.0g. However, things went terrible, terrible wrong (esp. with TRUCluster) and it wasn't until sunday late afternoon that we were up-and-running again with the original OS (4.0d). We cannot afford such

RE: transaction ???

2001-08-20 Thread Toepke, Kevin M
I use an anonymous PL/SQL block to do the job. (it truncates PL/SQL after the first few lines). Check out http://www.tuningoracle.com/scripts/sqlrunactive.sql Please let me know if you find any bugs with the script. Kevin -Original Message- Sent: Sunday, August 19, 2001 6:41 PM To:

SQL QUERY

2001-08-20 Thread Pallav Kalva
Hi List, I need an help on sql query, have a table with the following data OID INTEREST -- -- 100 1 100 2 100 3 100 4 I want the output to be displayed as OID

RE: slick looking website - VOUG - Portal

2001-08-20 Thread Kuijten, F. (Frank)
I got that too, the first time. However a 'Refresh' solved it. Greetings, Frank _ A good programmer is lazy !!! The best programmers become DBA ! -Original Message- From: Boivin, Patrice J [mailto:[EMAIL PROTECTED]] Sent: maandag 20 augustus

RE: Performance analysis (enqueue and buffer busy waits)

2001-08-20 Thread Babette Turner-Underwood
I am curious. What are you trying to accomplish by decreasing rollback segment size?? - Babette -Original Message- Lewis Sent: Tuesday, August 14, 2001 6:52 PM To: Multiple recipients of list ORACLE-L Looking at your trace file, most of your lost time appears to be in an update of

Re: Picking up the tab

2001-08-20 Thread Rachel Carmichael
ooh I love doing brain dumps 1) how many databases, where are they (machine, disk layout) 2) backup schedules, all processes and procedures associated with them 3) monitoring scripts -- how often are they run, where are they run from 4) contact information -- who does what (sysadmin, operations,

RE: slick looking website - VOUG - Portal

2001-08-20 Thread Hallas John
Title: RE: slick looking website - VOUG - Portal I got those error messages twice and thought it was a sarcastic comment re the site but on the 3rd attempt I got in and it looks a useful site Worth trying again John -Original Message- From: Boivin, Patrice J [mailto:[EMAIL

RE: Picking up the tab

2001-08-20 Thread Page, Bruce
A few of the basics I can think of off the top of my head would be: passwords, backups (exports, hot, cold, retention of tapes), purposes of databases and their priority, where the databases are, tools available, space used, space available -Original Message- From: O'Neill, Sean

RE: slick looking website - VOUG - Portal

2001-08-20 Thread Mark Leith
Reload/Refresh the page. -Original Message- Patrice J Sent: Monday, August 20, 2001 13:10 To: Multiple recipients of list ORACLE-L You're joking, right? All I see is about a dozen error messages. Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original

RE: LOTR Teaser Pictures! :The link

2001-08-20 Thread Christopher Spence
That was all I was able to get my hands on, although Rivendell does look quite cool. I like the black riders, very cool looking. There is a new book, LOTR all in one paper back, it is $20, it has a few pictures on the back. They are of: Gimli, Strider, Frodo, and Galadriel. They are small

RE: Database using 100% of CPU

2001-08-20 Thread tday6
Are you using the OEM that came with 8.1.6? I have a dim memory that the JAVA executable that powers that version of OEM had a flaw that could consume 100% of the CPU. Personally, I don't use OEM versions after 8.1.5. HTH

Re: Picking up the tab

2001-08-20 Thread Rachel Carmichael
okay, had some caffeine, thought of some more. I'd want to see documentation on all the procedures and processes being run from this is what it is and why we do it to type in .. and press enter advice on doing this: as you go about your day, write it all down. keep the doc open on

RE: iAS Administration course

2001-08-20 Thread Jamadagni, Rajendra
Patrice, You can find some e-seminars (http://technet.oracle.com/training/tech/java/oc4j/content.html) and Best Practices papers (http://technet.oracle.com/products/ias/techlisting.html#Best) here. Some courses * http://education.oracle.com/new_desc/D10424GC11.html (has some part on

linux

2001-08-20 Thread Saravana Kumar
Hi Friends, I have small clarification to be made. Can oracle for linux software be intalled on FREE BSD. Thanks in advance Saravana

Re: raw devices

2001-08-20 Thread Don Granaman
I don't know about NT, but on Solaris you should have some sort of cluster volume manager - Veritos is the most common. Rather than repeat all the information for vxva, vxprint, etc. here, just read the manuals - $ man vxva. Another option is to run the vxva GUI and capture the commands it

WARNING: CURSOR_SHARING=FORCE on 8.1.7

2001-08-20 Thread Jesse, Rich
Hi all, Just thought I'd share an experience (ON-TOPIC!) with everyone. After upgrading from 8.0.6 to 8.1.7 on HP/UX 11.0, we've had a few problems with CURSOR_SHARING=FORCE. The reason I decided to use it is because our apps don't use bind variables and I wanted to decrease the size of our

Unique contraint violation

2001-08-20 Thread Smith, Ron L.
I have a trigger that does an insert on a table containing 5 columns. The first three columns are variable information. The fourth column in SYSDATE. The last column is either the constant INSERT or DELETE. The first four columns are in a unique index. When the user runs the program that

Re: Performance analysis (enqueue and buffer busy waits)

2001-08-20 Thread Jonathan Lewis
Small rollback segments can be recycled without being written to disc. This can reduce the total write-load on the system and enhance your general use of the db_block_buffer. Jonathan Lewis Host to The Co-Operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html Author of:

RE: slick looking website - VOUG - Portal

2001-08-20 Thread Boivin, Patrice J
A developer here asked me, so is anyone other than Oracle and Oracle users groups using Portal 3.0? : ) Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch

RE: but will it run windows?

2001-08-20 Thread Christopher Spence
Can do a blade and add 2Gb of ram for about $1700 with two 30Gb Ultra66 drives and be faster than that ultra 10 in all respects except for video. Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes.

RE: DBA tasks

2001-08-20 Thread Guy Hammond
We find the treasure, kill the bad guys, save the world and get the girl. I think that about covers it :0) g -Original Message- Sent: Friday, August 17, 2001 7:56 PM To: Multiple recipients of list ORACLE-L Hi... I'am searching for a oracle dba task guide. A doc that especifi all

RE: SQL QUERY

2001-08-20 Thread Daemen, Remco
Hi Pallv, Should be something like this: set serveroutput on size 100 set linesize 200 declare last_value_of_oid number:= null; result_string varchar2(100) := 'Hoi'; skipfirst boolean := true; begin for rec in (select * from your_table)

RE: raw devices

2001-08-20 Thread Andrey Bronfin
Thanks a lot ! I always concentrate on mice and don't see the elephant :-( -Original Message- Sent: Monday, August 20, 2001 3:42 PM To: Multiple recipients of list ORACLE-L Andrey, All your answers are in the Oracle manuals. I am currently preparing for an NT OPS install. The

RE: linux

2001-08-20 Thread Ed . Haskins
Nope! -Original Message-From: Saravana Kumar [mailto:[EMAIL PROTECTED]]Sent: Monday, August 20, 2001 10:46 AMTo: Multiple recipients of list ORACLE-LSubject: linux Hi Friends, I have small clarification to be made. Can oracle for linux software be intalled on

RE: DBA tasks

2001-08-20 Thread Adams, Matthew (GEA, 088130)
Title: RE: DBA tasks And we do it in 30 minutes and still have time for commercials Matt Adams - GE Appliances - [EMAIL PROTECTED] Doing linear scans over an associative array is like trying to club someone to death with a loaded Uzi. - Larry Wall (creator of Perl) -Original

RE: FW: Data Warehouse book

2001-08-20 Thread Terrian, Tom
You definitely have some Florida blood in you! :-) Thanks, Tom Tom Terrian Oracle DBA WPAFB - DAASC [EMAIL PROTECTED] 937-656-3844 -Original Message- Sent: Monday, August 20, 2001 10:44 AM To: [EMAIL PROTECTED]; Terrian, Tom I'm gonna split my vote, is that allowed, even

Re: FW: Data Warehouse book

2001-08-20 Thread Jared Still
I'm gonna split my vote, is that allowed, even though I'm not in Florida? If you're completly new to DW, go with 'The Data Warehouse Tool Kit' first, by Ralph Kimball. It will clearly explain DW. If you have some DW experience, or won't be overwhelmed by a much more comprehensize tome, go

Re: w2k scripting

2001-08-20 Thread Jared Still
On Monday 20 August 2001 04:05, Guy Hammond wrote: Perl on Windows is great, when you consider things like manipulating the user database or system log, it's probably more useful on Windows than it is even on Unix. And DBI works the same on both platforms. Interesting comment Guy. I had the

Re: Unique contraint violation

2001-08-20 Thread JOE TESTA
you can't get more than 1 record loaded per second? joe [EMAIL PROTECTED] 08/20/01 11:25AM I have a trigger that does an insert on a table containing 5 columns. Thefirst three columns are variable information. The fourth column in SYSDATE.The last column is either the constant INSERT or

RE: linux

2001-08-20 Thread Jon Baker
FreeBSD and OpenBSD are not supported by Oracle. -Original Message-From: Saravana Kumar [mailto:[EMAIL PROTECTED]]Sent: Monday, August 20, 2001 10:46 AMTo: Multiple recipients of list ORACLE-LSubject: linux Hi Friends, I have small clarification to be made.

RE: Unique contraint violation

2001-08-20 Thread Smith, Ron L.
Sorry, I found that there were two triggers tied to the table. Probably a vendor error made on a recent updrade. Thanks for the help. Ron -Original Message- Sent: Monday, August 20, 2001 9:58 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] you can't get more than 1 record loaded per

Re: ora-24334

2001-08-20 Thread Christian Trassens
It is an OCI error. You should debug the app. Regards. --- Gene Gurevich [EMAIL PROTECTED] wrote: Hi all: My application is getting ora-24334 errors: no descriptor for this position. The information I found on Metalink is hot very helpful, something like use correct position. Does

Re: Help: truncate lasting 2+ hours

2001-08-20 Thread Christian Trassens
As someone said, probably that a lot of extents. However the main deal here is that you could lock the users with an ST lock. Therefore, you mustn't try it where all the users are in. And also you could try with a truncate tablereuse storage, and then issuing several alter table deallocate of

Interview Queries

2001-08-20 Thread Harvinder Singh
Hi, My manager is going to take interview of a person who has about 10 years of experience as Data Architect. Since i am out of office he wants me to send some sample tricky queries which he can ask in interview. I will appreicate if someone can point me to site having some sample tricky

Re: w2k scripting

2001-08-20 Thread Chaim . Katz
Lisa, I use Tcl and OraTcl that comes with Oracle Enterprise Manager. Chaim Koivu, Lisa [EMAIL PROTECTED] on 08/19/2001 05:15:21 PM Please respond to [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc:(bcc: Chaim Katz/Completions/Bombardier)

Using Table Partitions in 8.0.5

2001-08-20 Thread Kevin Lange
Hi folks; I have tried to setup a partitioned table in 8.0.5 and I get the message create table calc_sched_geo_factor_p*ERROR at line 1:ORA-00439: feature not enabled: Partitioning Is there something someplace I need to turn on in order to use partitions ?? Thanks Kevin

RE: w2k scripting

2001-08-20 Thread Jyoti N
Sometime back I was struggling to convert my Unix backup scripts to NT world, I came across this book which was quite useful . Check it out. Windows NT shell scripting.. by Tim hill. HTH, Jyoti From: "Guy Hammond" <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] To: Multiple recipients

RE: Using Table Partitions in 8.0.5

2001-08-20 Thread Yuval Arnon
Kevin, You need Oracle Enterprise to use the partition feature. For a comparison of features between EE and SE please see http://otn.oracle.com/products/oracle8i/pdf/8i_fam.pdf Yuval. -Original Message-From: Kevin Lange [mailto:[EMAIL PROTECTED]]Sent: Monday, August 20, 2001

Differences in sql server2000 and oracle8i

2001-08-20 Thread ARUN K C
Hi, Does anybody has any documents or links which shows the difference major between sql server 2000 and oracle 8i Here the management is asking for some docs which says that 8i is better than sql server 2000. Looks like the replication is very good on sql server 2000 than 8i. Please let me

RE: raw devices

2001-08-20 Thread Valuthur, Srikanth
Don Oracle Gurus, Going by your answers, I have a question for you? What you have explained is excatly the same environment we had back in our previous work place. But here we have everything what you have MINUS the raw devices. The question I have for Don and the forum folks is, What is the

RE: WARNING: CURSOR_SHARING=FORCE on 8.1.7

2001-08-20 Thread Jesse, Rich
Hey Jon, We're on 8.1.7.1.0. And as luck would have it, 8.1.7.2.0 came out THE DAY AFTER our upgrade, so I dunno if it appears there. Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original

Re: Followup: Database upgrade w/ standby

2001-08-20 Thread Rachel Carmichael
nice when things actually work :) one for our side! From: Hand, Michael T [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Followup: Database upgrade w/ standby Date: Mon, 20 Aug 2001 08:31:27 -0800 The patch level upgrade

Re: Interview Queries

2001-08-20 Thread DBarbour
You want this person to design the database or develop against it? I'd skip the finer points of SQL and concentrate on stuff like normalization/de-normalization. David A. Barbour Oracle DBA, OCP AISD 512-414-1002

OT: DBA tasks

2001-08-20 Thread Koivu, Lisa
Title: OT: DBA tasks Ahem... the female DBA's save the database, save the world, flatten the evil people with her well-tuned martial arts skills, swims in icy cold water without showing one goose pimple on her Barbie-proportioned body, impresses the Diet Coke guy, and then tells him thanks

RE: DBA tasks

2001-08-20 Thread Thater, William
At 01:38 PM 8/20/2001, Rachel Carmichael wrote: ahem... get the girl lol well, now, they didn't define get now did they?;-) -- Bill Shrek Thater ORACLE DBA Telergy,Inc. [EMAIL PROTECTED]

RE: DBA tasks

2001-08-20 Thread Page, Bruce
Hey, Oracle IS a company based in San Francisco. -Original Message- From: Rachel Carmichael [mailto:[EMAIL PROTECTED]] Sent: Monday, August 20, 2001 1:39 PM To: Multiple recipients of list ORACLE-L Subject: RE: DBA tasks ahem... get the girl lol -- Please see

Summary advisor question

2001-08-20 Thread JOE TESTA
Is anyone using this (or dbms_olap.recommend_mv) successfully. I"m getting a ORA-30479: Summary Advisor errorQSM-00511: invalid fact-tables specified in fact-filter after RTFM and battling with it for a week, i've come to the experts. I've got a simple time table and create a time

RE: Performance analysis (enqueue and buffer busy waits)

2001-08-20 Thread Post, Ethan
FYI, in a previous message I detailed some of the tuning efforts we have been working on in regards to getting a EDI sales order processing job to process 150,000 lines per hour. Well the major point of contention was freelists. We went from 250 lines per minute to over 1500 lines per minute

Re: linux

2001-08-20 Thread Joe Raube
There has been some success with 8.0.5 on FreeBSD, but little to none with 8i. -Joe --- Saravana Kumar [EMAIL PROTECTED] wrote: Hi Friends, I have small clarification to be made. Can oracle for linux software be intalled on FREE BSD. Thanks in advance Saravana

RE: OT: DBA tasks

2001-08-20 Thread Koivu, Lisa
Title: RE: OT: DBA tasks Nope, not yet. When (and if) that happens, the advertising companies and networks are going to scream bloody murder. However, you can turn on a program, wait 10 minutes, and then watch the entire thing fast-forwarding thru all commercials. Super slick. by far the

Re: OT: DBA tasks

2001-08-20 Thread JOE TESTA
Barbie proportioned body, thats just nasty, waist is way to skinny :) joe [EMAIL PROTECTED] 08/20/01 01:38PM Ahem... the female DBA's save the database, save the world, flatten the evil people with her well-tuned martial arts skills, swims in icy cold water without showing one goose

RE: Interview Queries

2001-08-20 Thread Christopher Spence
Exactly. Focus on ACID theory and steps of normalization. Also how to resolve common design issues. A good data architect may NOT even need to know sql. Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their

environmental variables

2001-08-20 Thread lhoska
Is there any way to create NT environmental variables through script? Lyuda Hoska -- 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

RE: OT: DBA tasks

2001-08-20 Thread Grabowy, Chris
Ken, I do not believe that is an option. Perhaps version 2.5 will have that. They have message boards at www.tivo.com, so you may want to post the question there. Thanks. Chris -Original Message- Sent: Monday, August 20, 2001 2:03 PM To: Multiple recipients of list ORACLE-L

RE: OT: DBA tasks

2001-08-20 Thread Kevin Kostyszyn
Yeah, but she'd still be pretty hot? -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of JOE TESTASent: Monday, August 20, 2001 2:22 PMTo: Multiple recipients of list ORACLE-LSubject: Re: OT: DBA tasks Barbie proportioned body, thats just

Re:Get Network Not OK : ORACLE OCI

2001-08-20 Thread dgoulet
Stephane, Sounds like they maybe getting an ORA-20102 navigation error which would be indicatative of a bad TNSnames.ora file or if it's on teh extranet, are you using DNS or Oracle Names? Most of those will not work through a firewall. Dick Goulet Reply

RE: OT: DBA tasks..turning into Tivo.

2001-08-20 Thread Grabowy, Chris
Title: RE: OT: DBA tasks While that's a great feature. I like the ability of Tivo to pick up shows that you like, based on your own tastes that it "learns". Almost on a weekly basis it captures some movie that I have never seen or saw many years ago. And then I will watch it that night, or

Re: OT: DBA tasks

2001-08-20 Thread Rachel Carmichael
you go girl! :) do I have to have Barbie-blond hair though? I'm thinking a nice, brilliant red myself From: Koivu, Lisa [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: OT: DBA tasks Date: Mon, 20 Aug 2001 09:38:58 -0800

RE: PS lock

2001-08-20 Thread Li, Xiangli
No, I didn't get enqueue waits. rgds, Li -Original Message- From: Diego Cutrone [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, August 15, 2001 4:48 PM To: Multiple recipients of list ORACLE-L Subject: RE: PS lock Hi, PS lock is related to Parallel Slave Synchronization.

Re: environmental variables

2001-08-20 Thread Jon Walthour
Simple. Put them in a batch file: @echo off set env1 = One set env2 = Two set oracle_sid = mydb ... Then reference like normal C:\ echo %oracle_sid% mydb Jon Walthour From: [EMAIL PROTECTED] Date: 2001/08/20 Mon PM 02:36:36 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]

RE: environmental variables

2001-08-20 Thread Mercadante, Thomas F
Lyuda, I do it all the time. Not exactly what type of environmental you want to create, but you can always do something like: echo set oracle_sid=Prod setsid.bat call setsid.bat Is this what you mean? I do this as well as echo sql commands to an output file, and run the sql thru sqlplus.

Re: RE: WARNING: CURSOR_SHARING=FORCE on 8.1.7

2001-08-20 Thread Jon Walthour
Rich: Please let me know if the problem goes away for you with any of the patches or if the only real fix is to go to 9i. Jon Walthour From: Jesse, Rich [EMAIL PROTECTED] Date: 2001/08/20 Mon PM 01:32:30 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: WARNING:

RE: OT: DBA tasks

2001-08-20 Thread Mercadante, Thomas F
didn't Barbies slutty friend have that bright red hair? I think her name was Easy. :) (ducking and heading out the door) -Original Message- Sent: Monday, August 20, 2001 2:51 PM To: Multiple recipients of list ORACLE-L you go girl! :) do I have to have Barbie-blond hair though?

RE: OT: DBA tasks..turning into Tivo.

2001-08-20 Thread Kevin Lange
Title: RE: OT: DBA tasks What has the recording time on Tivo gotten up to and does it work on all satelite systems ?? I have Dish and I know there is a package for Direct TV and Tivo ... but not sure if Dish is supported. -Original Message-From: Grabowy, Chris

RE: Performance analysis (enqueue and buffer busy waits)

2001-08-20 Thread Post, Ethan
In regards to my last post, here is an example of the type of statement that is killing my CPU. #! ITEM/CUSTOMER KEY ID MASTER FILE SELECT * FROM CRPDTA.F4094 WHERE ( KIPRGR = :KEY1 AND KIIGP1 = :KEY2 AND KIIGP2 = :KEY3 AND KIIGP3 = :KEY4 AND KIIGP4 = :KEY5 AND KICPGP = :KEY6 AND KICGP1

RE: OT: DBA tasks

2001-08-20 Thread Koivu, Lisa
Title: RE: OT: DBA tasks I'm only blonde on football game days, when I put on my blonde stripper wig and braid it :) A nice Nicole Kidman red would be a wise choice. I'm brunette and proud of it! Just anything but blonde. HA -Original Message- From: Rachel Carmichael [SMTP:[EMAIL

RE: OT: DBA tasks..turning into Tivo.

2001-08-20 Thread Koivu, Lisa
Title: RE: OT: DBA tasks..turning into Tivo. Zapped card that allows you to get EVERY channel, and the adapter that stops DirecTV from zapping your card to nothing (in other words, they caught you). Then you have to get another card from DirecTV or buy it from someone. I'm kinda glad we

RE: OT: DBA tasks..turning into Tivo.

2001-08-20 Thread Koivu, Lisa
Title: RE: OT: DBA tasks..turning into Tivo. What do you mean? AFAIK it will record ~30+ hours of programming. Is that what you're asking? I'm not sure about Dish. -Original Message- From: Kevin Lange [SMTP:[EMAIL PROTECTED]] Sent: Monday, August 20, 2001 3:22 PM To: Multiple

Re: Substitute for Materialized Views/Snapshots?

2001-08-20 Thread Chris Rezek
Anita, I would be a very happy man today if snapshots existed in SE. However, I have verified the non-existence of snapshots in SE by: (1) running basic create statements and having them fail and (2) filing an iTAR about the existence of snapshots/MVs in SE and receiving an answer of 'no'

RE: OT: DBA tasks

2001-08-20 Thread Rachel Carmichael
rats! you figured out my secret :) From: Mercadante, Thomas F [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: OT: DBA tasks Date: Mon, 20 Aug 2001 11:22:05 -0800 didn't Barbies slutty friend have that bright red hair? I

RE: OT: DBA tasks

2001-08-20 Thread Rachel Carmichael
Grandpa was a redhead... I was born brunette but when I get in the sun it goes red... so I sometimes help it along G From: Koivu, Lisa [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: OT: DBA tasks Date: Mon, 20 Aug 2001

OT -- Does PlumTree use Oracle Portal

2001-08-20 Thread Boivin, Patrice J
Does PlumTree rely on Oracle Portal? Just wondering, they are listing IBM as one of their partners, but not Oracle... Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques

RE: How to sign-off this group?

2001-08-20 Thread Farnsworth, Dave
To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other

changing long to lob

2001-08-20 Thread JOE TESTA
while looking thru the migration guide(for downgrade info in case it happens), alter table table_name modify long_col clob; and supposedly POOF its now a clob. interesting. joe

Re: linux

2001-08-20 Thread Oliver Artelt
Hi, I've heard on a OpenBSD mailinglist about such thing. Seems that they've made it after some adjustments. Go to the FreeBSD mailinglists for these questions. oli [EMAIL PROTECTED] wrote: Hi Friends, I have small clarification to be made. Can oracle for linux

RE: How to sign-off this group?

2001-08-20 Thread Page, Bruce
To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other

Re: How to sign-off this group?

2001-08-20 Thread Scott Shafer
Must... resist... temptation... sound of teeth grinding Ben Le wrote: Would some one please tell me how to sign-off this group. It was a pleasure to be in this excellent group in the past years. Thank you. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ben

RE: OT: DBA tasks..turning into Tivo.

2001-08-20 Thread Grabowy, Chris
Title: RE: OT: DBA tasks As for the recording time, its 30 hours. There's another model that does 60 hours. The 30 hour model gives you about 18 hours worth of decent recording quality. So it truly not 30 hours, unless you only record cartoons or something like that. Regardless, I can

Re: How to sign-off this group?

2001-08-20 Thread Jon Walthour
Read the bottom of your email. From: Ben Le [EMAIL PROTECTED] Date: 2001/08/20 Mon PM 04:04:08 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: How to sign-off this group? Would some one please tell me how to sign-off this group. It was a pleasure to be in this

RE: OT: DBA tasks..turning into Tivo.

2001-08-20 Thread Grabowy, Chris
Title: RE: OT: DBA tasks Nothing for DISH. Probably never will be. Direct TV and Tivo probably have an exclusive greement. -Original Message-From: Kevin Lange [mailto:[EMAIL PROTECTED]]Sent: Monday, August 20, 2001 3:22 PMTo: Multiple recipients of list ORACLE-LSubject: RE:

RE: OT: DBA tasks..turning into Tivo.

2001-08-20 Thread Grabowy, Chris
Title: RE: OT: DBA tasks..turning into Tivo. Lisa, There are options within Tivo so that you can tell it which channels you dont get. Also, it needs to know if your using Basic, or Extended Basic, what pay channels, etc. Yes, it tries to record stuff that you like. Like I selected Tennis

RE: environmental variables

2001-08-20 Thread lhoska
John, may be it is a dump question.. but... there are certain directories my variables would go under. Note: I am declaring custom environmental variables. How do I address this issue? -Original Message- Sent: Monday, August 20, 2001 3:12 PM To: Multiple recipients of list ORACLE-L

Oracle Acquires 'Seminal' E-Commerce Patent

2001-08-20 Thread Glenn Travis
http://www.internetnews.com/intra-news/article/0,,7_868161,00.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Glenn Travis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public

RE: environmental variables

2001-08-20 Thread Mercadante, Thomas F
Lyuda, I have exactly these type of environmental files on my NT server. The PATH on the NT server is altered to include the directory where these files exist. I have one file for each database instance on each server. For example, the listing below is the WTWD.BAT file (representing the WTWD

RE: Performance analysis (enqueue and buffer busy waits)

2001-08-20 Thread Gogala, Mladen
Increase the snapshot too old query mortality rate? -Original Message- From: Babette Turner-Underwood [mailto:[EMAIL PROTECTED]] Sent: Monday, August 20, 2001 9:22 AM To: Multiple recipients of list ORACLE-L Subject: RE: Performance analysis (enqueue and buffer busy waits) I am

High DML Table - Suggestions??

2001-08-20 Thread Walter K
Hi, I have a table that is going to have a large amount of inserts, updates and deletes performed against it daily. Approximately 1,000,000 transactions per day (some single-record, some multi-record). The table is ~100Mb in size. I'm looking for some suggestions on what I can do to have the

UTLB/E stat

2001-08-20 Thread Joe Frohne
Hi, I have been looking over report.txt output for some of my instances. I am wondering if anybody can tell me about the system wide wait events for the events named pmon timer smon timer I don't know much about what this information portrays. The reason I even ask is on one instnace the

Re: Recovery Question

2001-08-20 Thread Peter Gram
Hi Kamel You have to tell oracle that the controlfile is not originale one by using recover database using backup controlefile GL2Z/ INF DBA BENLATRECHE wrote: Hi List, I am testing one situation where : - The database is in archive log mode, - I have a cold backup of all the

  1   2   >