Re: Configuring for Online Redo Logfiles

Hi Vivek, >From performance point of view a single disk will be a little faster as there is a small overhead associated with the process of mirroring to the second member of the RAID1. Regards, Ed > EXCERPT from "Implementing Raid On Oracle Systems" by Gaja Krishna > Vaidyanatha, Quest Softwar

Sql question - please reply fast

Hej Would like to have som help with this. Please give me an example of sql statement. I have field1. Pelle T Kalle S1000 Info missing Pelle Svensson T3 Bad info and want this result after the selectstatement. Pelle Kalle Info missing Pelle Svensson Bad info which means that I dont

RE: Import Help

Hi Sujatha, First you import the definitions into a logfile and then create the tablespaces by editing the datafile locations. Imp userid=system/manager full=y file=fulldump.dmp log=fulldump.log show=y When you execute above command, the logfile fulldump.log would have all the tablespac

Re: DBA CHECKLIST

it must in a web site . not sure where it is exactly . Try www.oraclepower.com - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Thursday, November 15, 2001 7:30 AM > hi, > > is there a dba checklist to know a dba does? > > Best regards, > > G

Other Database Mailling Lists

Hi, Please recommend me some good Ms SQL Mailing List that as good as here Thanks, Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinard Xing INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, Califo

Efficiency testing

Hi, Could somebody tell me what all to be considered for testing the efficiency of an Oracle database application ? Thanks and Regards Pradeep -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051

select from dual?

Hi lists Whats wrong with the following statement:- select 30,'where name in ('NAME1','NAME2')' || ' ;' from dual; where as the following is working fine: select 30, 'where id in (10,20)' || ' ;' from dual; can anybody throw some light? thanx in adv srinivas -- Please see the official O

RE: Operating Systems

Might want to look at RH Linux and get a subscription to the KRUD patch service (see tummy.com). RH certianly isn't perfect but is realatively easy to get help on and has plenty of extenal documntation and tutorials written for it (e.g., www.ora.com/linux). -- Steven Lembark

DBA CHECKLIST

hi, is there a dba checklist to know a dba does? Best regards, Grace Lim Suy Sing Comm'l Corp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: grace INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

Re: range checking ??? URGENT

If you are on 8i (I know it works on 8.1.6 and 8.1.7), you can use select case: SQL> select * from junk; X -- 10 15 20 25 SQL> select x, (case when x < 11 then 'small' when x < 21 then 'med' when x < 31 then 'large' end) from junk 2 /

RE: Disk Layout Document

the very first time I ever saw Kevin present, he was talking about that. I went out and bought the DBA Handbook and came home to the operations people saying "I need 22 disks" when they picked themselves up off the floor I said "okay, I can get away with 17" again, I waited until they stopped la

Re: Disk Layout Document

dba handbook -- Kevin had a section on you should have 22 disks, then no, 17, then no 9.. --- Larry Elkins <[EMAIL PROTECTED]> wrote: > Listers, > > Okay, I've been googling for about an hour now and can't find it. It > seems > like I remember seeing a white paper, note, or some sort of referen

Re: Operating Systems

It does work good if you have a powerful enough server. --Scott - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, November 14, 2001 2:30 PM If there are no issues with Solaris on Intel, I would be enclined to prefer that to LINUX or N

RE: update query??? HELP!!!

Title: RE: update query??? HELP!!! > -Original Message- > From: Janet Linsy [mailto:[EMAIL PROTECTED]] > > I got > > (select c.franchise_name >  * > ERROR at line 3: > ORA-01427: single-row subquery returns more than one > row > > How can I solve this?  Thank you again! > > SQL> u

RE: Import Help

Hi John, But wont this try and create the datafiles in the same location as the original database??? Regs Sujatha -Original Message- Sent: Thursday, 15 November 2001 10:57 AM To: Multiple recipients of list ORACLE-L Sujatha, > I have an export file from an 8.0.6 database which I nee

Mass Storage/Network Stuff

Are there any problems running Oracle on one box, and pointing the database files to a mass storage network device (ie. a disk array or some external storage solution). In other words, will Oracle run using network addressable storage? I'm assuming this is not a difficult thing to do, but I woul

RE: Re[2]: Oracle the best

- You might want to consider using orastack.exe to reduce the memory requirements. By default, every thread (oracle,tns, svrmgrl, sqlplus) takes 1M. That is more than enough of stack space. I would reduce it to 500K using the orastack.exe. - In addition to this, you may reduce your SGA to a con

RE: Failed to archive log

Um... What version? What does v$log say about the status? Do you have multiple archive log destinations specified? Is one of them set to "optional"? -Original Message- Sent: Wednesday, November 14, 2001 6:42 PM To: Multiple recipients of list ORACLE-L Has anyone seen the following i

RE: Failed to archive log

The alert is just telling you that there was a delay archiving your redo log. This does not mean that you have lost any data, or archive logs, but it can become a bottleneck in your database if transactions have to wait for archiving on a regular basis. If this was during a normal activity/load p

standard VS enterprize

someone earlier wanted this information .. check out http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=112591.1 Deepak __ Do You Yahoo!? Find the one for you at Yahoo! Personals http://personals.yahoo.c

Re: Operating Systems

They did as of last year. --S "Boivin, Patrice J" wrote: > > Does Oracle sell a version for Solaris on Intel? > > I thought they only offered Oracle for SPARC Solaris. > > Mind you it wouldn't be a bad thing if they did offer Oracle for Solaris on > Intel, esp. now that the Alphas are owned

RE: range function ??? URGENT

Leslie, More than likely you have a character value in franchise_name, quite possible since it is defined as a varchar2(32). When you try to do the to_number in the function, it throws the error: SQL> select check_range('ABC') from dual; select check_range('ABC') from dual * ERROR at line

RE: Import Help

Sujatha, > I have an export file from an 8.0.6 database which I need to > import into an > 8.1.7 db. However, the locations of the tablespaces are > different in the > 8.1.7 db. Precreate the databases, i.e. (a) Create the database (CREATE DATABASE statment) via dbassist or scripts, (b) Create

Re: update query??? HELP!!!

update SERVICE_LOCATION a set CENTRAL_OFFICE_CODE = (select FRANCHISE_NAME from FRANCHISE_AREA c, SERVICE_LOC b where a.SERVICE_LOCATION_ID = b.SERVICE_LOCATION_ID and b.FRANCHISE_ID = c.FRANCHISE_ID) At 02:55 PM 11/14/01 -0800, you wrote: >H

range function ??? URGENT

Hi all, Thank you for all who responded to my range checking question. I created a function check_range with in parameter varchar2, and return varchar2. This works fine: select check_range('301') from FRANCHISE_AREA; But when I select the column, I got: select check_range(FRANCHISE_NAME) from

Failed to archive log

Has anyone seen the following in their alert log? Is this serious? It does then go on and say it completed archiving that log. Thanks for your insights. Thread 1 advanced to log sequence 3513 Tue Nov 13 01:02:03 2001 ARC0: Beginning to archive log# 2 seq# 3512 Current log# 3 seq# 3513 mem# 0: /

Import Help

Hi, I have an export file from an 8.0.6 database which I need to import into an 8.1.7 db. However, the locations of the tablespaces are different in the 8.1.7 db. How can do the import? Any help will be appreciated. Thanks Sujatha -- Please see the official ORACLE-L FAQ: http://www.orafaq.co

RE: update query??? HELP!!!

Title: RE: update query??? HELP!!! > -Original Message- > From: Janet Linsy [mailto:[EMAIL PROTECTED]] > > How to do this query, I have three tables: > SERVICE_LOCATION a, SERVICE_LOC_AREA b, FRANCHISE_AREA > c. > > The relationship between them is: > a.SERVICE_LOCATION_ID = b.SERVIC

RE: Internal Benchmarking

Steve, > clicks but I > would like to mimic delays in transaction commits due to > network latency and > user indecision or whatever. I'd also like to be able to > increase the load > intensity by factors of 10 to 1000. Has anyone created any application > specific benchmark routines and can yo

Configuring for Online Redo Logfiles

EXCERPT from "Implementing Raid On Oracle Systems" by Gaja Krishna Vaidyanatha, Quest Software Inc. :- "RAID 1 - Ideal for online and archived redo logs, Leaves the write-head at the location of the last write. On most systems, you will need 3 volumes for the online redo logs (for 3 groups) and 1

Re: Operating Systems

Yeah, what was I thinking? Must be too much blood in my tequila system... ;-) --S "HAWKINS, JAMES W [IT/1000]" wrote: > > Scott, > > NT? I think the habaneros and tequila have finally taken over... > > ;) > > Seriously, stay away from NT. I have the unfortunate task of monitoring a > few

Re: Disk Layout Document

Larry, There is some discussion of this in the "Designing and Tuning for Performance" docs at: http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/a76992/ch20_io.htm#11672 URL will probably wrap. I'm sure this isn't exactly what you want, but its a good start. Scott Sha

RE: range checking ??? URGENT

Leslie, If you are on 8.1.6 or higher, look into using the CASE statement -- it will be a little easier to code and understand. If not, and it sounds like you want one of many columns to print in a *single* column based on the range. You can do this with the LEAST operator in conjunction with a D

update query??? HELP!!!

Hi all, How to do this query, I have three tables: SERVICE_LOCATION a, SERVICE_LOC_AREA b, FRANCHISE_AREA c. The relationship between them is: a.SERVICE_LOCATION_ID = b.SERVICE_LOCATION_ID and b.FRANCHISE_ID = c.FRANCHISE_ID I need to update CENTRAL_OFFICE_CODE column in table SERVICE_LOCATION

RE: range checking ??? URGENT

Title: RE: range checking ??? URGENT > -Original Message- > From: Leslie Lu [mailto:[EMAIL PROTECTED]] > > Can decode work on a range, like if Code is > 100 and > < 200, then name is A; if code>200 and code<300, then > name is B; I have about 20 ranges to check.  If > decode

CLOB datatype

Does anyone have any opinions on using CLOB/NCLOB datatypes in Oracle? I am running 8.1.7.2 on Solaris. Oracle Docs state that CLOBs can handle up to 4 Gig. Are there any gotchas by using CLOBs? Thanks for any information, Rick Stephenson -- Please see the official ORACLE-L FAQ: http://www.

RE: range checking ??? URGENT

Which version? Does it have the case clause? -Original Message- Sent: Wednesday, November 14, 2001 4:50 PM To: Multiple recipients of list ORACLE-L Hi all, Can decode work on a range, like if Code is > 100 and < 200, then name is A; if code>200 and code<300, then name is B; I hav

Re: ok..this is funny.. how do you pronounce "tuple"

- Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, November 14, 2001 12:25 PM > I say to-may-to, You say to-mah-to; > I say po-tay-to, You say po-tah-to; > > I say too-pul, You say tuh-pul > > There are N-1 ways to pronounce it. >

RE: range checking ??? URGENT

Title: RE: range checking ??? URGENT > -Original Message- > From: Leslie Lu [mailto:[EMAIL PROTECTED]] > > Can decode work on a range, like if Code is > 100 and > < 200, then name is A; if code>200 and code<300, then > name is B; I have about 20 ranges to check.  If > decode cann

RE: Disk Layout Document

Bingo! Chapter 4. I knew I had read the variations somewhere. Thanks for the assist. Regards, Larry G. Elkins [EMAIL PROTECTED] 214.954.1781 > -Original Message- > From: Grabowy, Chris [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, November 14, 2001 3:32 PM > To: '[EMAIL PROTECTED]' >

RE: Operating Systems

I liked Solaris Intel a lot. But it has a short HCL compare to Linux. And not as many applications are available on it as Solaris/Sparc or Linux. So if you have the hardware that's on the HCL and you are just running Oracle then go for it. Richard >>> [EMAIL PROTECTED] 11/14/01 03:30PM >>> I

range checking ??? URGENT

Hi all, Can decode work on a range, like if Code is > 100 and < 200, then name is A; if code>200 and code<300, then name is B; I have about 20 ranges to check. If decode cannot handle that, what's an easy way to do that? Thank you! Leslie _

Re: lack of memory

Hi Deepak, I'm on Linux. I'm afraid it's not accurate calculation because 'processes' parameter just get you upper limit on number of connections and a session only keeps its 'sort_area_size' untill a sort operation completes. Does pmap utility exist on Linux? I'll check it tomorrow (i'm at ho

RE: Enterprise Versus Standard - Thanks

Thanks Marin and all others that responded. Thats what I needed. Kevin -Original Message- Sent: Wednesday, November 14, 2001 11:54 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wedne

RE: Disk Layout Document

I believe the Oracle DBA Handbook by Kevin Loney has that... -Original Message- Sent: Wednesday, November 14, 2001 3:45 PM To: Multiple recipients of list ORACLE-L Listers, Okay, I've been googling for about an hour now and can't find it. It seems like I remember seeing a white paper,

RE: Operating Systems

If there are no issues with Solaris on Intel, I would be enclined to prefer that to LINUX or NT. Just an opinion, and I haven't worked with Oracle on Solaris for Intel, but it sounds good to me! Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original Message-

Internal Benchmarking

Howdy All, I want to create some database-only benchmarking scripts to reflect a typical day in the life of a custom application. I'm thinking about using LogMiner to get the redo and v$sqlarea to derive a representative mix of queries. Maybe we can also sniff/parse the network traffic to the DB

Disk Layout Document

Listers, Okay, I've been googling for about an hour now and can't find it. It seems like I remember seeing a white paper, note, or some sort of reference detailing "preferred" file layouts based on different number of disks -- e.g. 4 disks try this, with 5 disks try that. Does that ring a bell?

RE: Operating Systems

Patrice, Oracle Database 8i Release 3 (8.1.7 cd pack for Solaris Intel Apr-01 release Part # CDP No. A89290-01 v2 contains: 8i rel3 8.1.7 Enterprise Edition 8i rel3 8.1.7 Standard Edition 8i rel3 8.1.7. Client for MSWIN95/98/2000/NT Oracle Internet File System rel 1.1.9 for MS2000/nt OEM rel 2.

Re: Correction : EMC symetrix - 1M stripe width - Raid 0+

I agree with Don. We have always found it better to mirror at the EMC Symmetrix level and then handle striping requirements via the volume manager (such as Veritas Volume Manager). In fact, I presented a paper on this at IOUG-A last year. The bottom line is to make sure that you properly design

Re: Operating Systems

Patrice: Oracle for Solaris x86 has been out for a while. I am running it on one of my machines at home. It's Oracle! It's Solaris! It's Intel (AMD in my case)! It's a 3-in-1 wonder toy! ;-) Seriously, take a look at http://store.oracle.com under the "CD Packs" area. There will be one for "

Re: ORACLE-L Digest -- Volume 2001, Number 318

And the SAs *are* going to run weekly/monthly UPS tests from now on, right? :) regards, ep ORACLE-L Digest -- Volume 2001, Number 318 > -- > > From: "Farnsworth, Dave" <[EMAIL PROTECTED]> > Date: Tue, 13 Nov 2001 18:32:16 -0600 > Subject: RE: Power outage > > I

ORA-1410

Title: ORA-1410 Hi, I am running the following command analyze table BLOB compute statistics and I am getting the following error. * ERROR at line 1: ORA-01410: invalid ROWID Metal link tell me to export,drop,import the table. Does anyone know of a way to fix the table without dropp

RE: real newbie question (i think)

Hi Dick... Here are some thoughts... 1) You can't use the like operator on the LONG datatype... You will get an inconsistent datatype error... 2) A bunch of reasons... a) LONG are going away someday b) You can store LOB data out of line with the table to improve performance

RE: Operating Systems

Does Oracle sell a version for Solaris on Intel? I thought they only offered Oracle for SPARC Solaris. Mind you it wouldn't be a bad thing if they did offer Oracle for Solaris on Intel, esp. now that the Alphas are owned by the people developing the Itanium platform. Regards, Patrice Boivin Sys

RE: Oracle Text (ConText/InterMedia) and realtime updates

So, I fire up a Catalog Index on a column with an associated column in the index set (for ordering the results) and it comes back 10-12 times faster than the Context Index. The problem is that the result sets weren't the same. Upon investigating, I found out that catalog index searching ("catsea

Online index rebuilds

Compressed indexes: The docs don't say that compressed indexes cannot be rebuilt online but it doesn't work for me. I can rebuild normal indexes online, I can rebuild an index and compress it but I can't do both. Compute statistics: SQL> alter index rebuild online compute statistics nologging;

Re: ok..this is funny.. how do you pronounce "tuple"

The only way I ever heard is "tuh-pul" - must be a Minnesota thing, like "hot dish" instead of "casserole" :>) Bill Gentry DBA Allina Health System Minneapolis, MN 55403 612-775-1190 [EMAIL PROTECTED] - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Se

Re:Operating Systems

Red Hat Linux. Dick Goulet Reply Separator Author: Regina Harter <[EMAIL PROTECTED]> Date: 11/14/2001 9:45 AM Hi Guys, Our SA/DBA is considering dumping Unixware and moving to a different OS. Sun is out for reasons that are not being shared with

Re:real newbie question (i think)

Rich, Since no one has yet posted an answer, here is my opinion/questions. 1) Why do you want the 'new column'? What it looks like it that you just need to query the table for the keywords your interested in. The 'like' operator shoudl work just fine. 2) A long can contain 2GB wor

Re: Re[2]: Correction : EMC symetrix - 1M stripe width - Raid 0+

I have used the Symmetrix with hardware mirroring and software (Veritas Volume Manager) striping and seen significant performance gains over just mirroring in the Sym. It is going to depend a lot on your I/O patterns and volume though. I have used SAME, but in general wouldn't really recommend i

Re: EnCrypting

hey i think there is a article on the new dbms_obsfusion (confusion) package that you can use for data encryption. Deepak PS: and yes i did not use spell checker; --- Marin Dimitrov <[EMAIL PROTECTED]> wrote: > > - Original Message - > To: "Multiple recipients of list ORACLE-L" > <[EM

Re: lack of memory

Edward, why you thinking of going MTS route to support just 400-500 users. On 4GB like you have, i can support 2000+ users (non-mts) with no problems .. most of the boxes are E-450's, 4500's Deepak --- Connor McDonald <[EMAIL PROTECTED]> wrote: > (Of course depending on the app), its seems odd

Re: lack of memory

Edward, how about checking your processes parameter and then multiplying that # with your sort area size .. thats would give you a good idea about the size of your PGA .. also i guess there is a 250 K overhead per connection so you need to add that as well. for more accurate information, yopu cou

Re:

money for one; Deepak PS: enterprize has bunch of more features than standard including tspitr support and partitions.. for more check out technet.oracle.com --- grace <[EMAIL PROTECTED]> wrote: > hi gurus, > > wat's the difference of 8i ias standard and > enterprise? > > Best regards, >

Re: real newbie question (i think)

Hi Rich >am i better off creating a new column in the existing >table of the type clob or blob? should i create a >new table to store this data? This depends on what kind of queries hit this table. If most of your queries hit columns other than the lob then you are justified in creating ne

Re: Operating Systems

Regina Harter wrote: > Hi Guys, > > Our SA/DBA is considering dumping Unixware and moving to a different > OS. Sun is out for reasons that are not being shared with me, probably > because they don't want to buy new hardware, so aside from that, would > anyone care to weigh in with opinions on wh

RE: Operating Systems

Scott, NT? I think the habaneros and tequila have finally taken over... ;) Seriously, stay away from NT. I have the unfortunate task of monitoring a few minor databases on NT in addition to my Unix ones, and I hate every minute of it. The locks it places on open files prevent you from doing

Re: Operating Systems

I chose Linux over Solaris for Intel because the Solaris did not support the hardware configuration I had to work with. The corporate bean-counters would prefer to pay for something rather than use a free and supported product. Very happy with the ease of admin and speed. ROR mª¿ªm >>> [EMAIL

RE: ok..this is funny.. how do you pronounce "tuple"

I say to-may-to, You say to-mah-to; I say po-tay-to, You say po-tah-to; I say too-pul, You say tuh-pul There are N-1 ways to pronounce it. :^) -Original Message- Sent: Wednesday, November 14, 2001 12:26 PM To: Multiple recipients of list ORACLE-L Tuple. Like Tupplewear. Bambi.

RE: import/export problem in oem

Do you have sysdba or sysoper privs and are you connecting to OEM with sysdba/ Rick -Original Message- Sent: Wednesday, November 14, 2001 12:31 PM To: Multiple recipients of list ORACLE-L hi,gurus help me ,in this problem through command prompt i got export/import facility .bu

Re: Operating Systems

This one is quite obvious: linux. The question is which flavor :). >>> [EMAIL PROTECTED] 11/14/01 12:45PM >>> Hi Guys, Our SA/DBA is considering dumping Unixware and moving to a different OS. Sun is out for reasons that are not being shared with me, probably because they don't want to buy ne

Re: Operating Systems

Linux or Solaris Intel. And maybe (gods help me! ) NT? Scott Shafer San Antonio, TX Regina Harter wrote: > > Hi Guys, > > Our SA/DBA is considering dumping Unixware and moving to a different > OS. Sun is out for reasons that are not being shared with me, probably > because they don't want t

Re: Operating Systems

We're really happy w/ linux. We can't stand the notion of having our OS being rebooted every so often just so it can be run optimally. --Yohans On Wed, 14 Nov 2001, Regina Harter wrote: > Hi Guys, > > Our SA/DBA is considering dumping Unixware and moving to a different > OS. Sun is out for

Re: Enterprise Versus Standard

- Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, November 14, 2001 19:05 > Does anyone have a good Oracle Standard to Oracle Enterprise comparison > Chart ?? I am looking on the various Oracle ran sites and most of the docs > seem to

Operating Systems

Hi Guys, Our SA/DBA is considering dumping Unixware and moving to a different OS. Sun is out for reasons that are not being shared with me, probably because they don't want to buy new hardware, so aside from that, would anyone care to weigh in with opinions on what OS is most stable with Ora

import/export problem in oem

hi,gurus help me ,in this problem through command prompt i got export/import facility .but with same user (with all permissions),i am not able to do same job. error is: The following error has occurred while trying to make the connection to the target database using preferential cr

RE: seouc in Feb.

Title: RE: seouc in Feb. SouthEastern Oracle Users Conference Feb 21-22, 2002 Charlotte, NC Sketchy details are available at www.seouc.org Matt Adams - GE Appliances - [EMAIL PROTECTED] "Doing linear scans over an associative array is like trying to club someone to death with a loaded U

Re: seouc in Feb.

Stefan See http://seouc.orgFeb 21,22 2002 ROR mª¿ªm >>> [EMAIL PROTECTED] 11/14/01 10:50AM >>> Hi, when exactly will it be ? cheers, Stefan "Bowes, Chris" schrieb: > Going to try, since it's only 30 min from the house. --Chris > [EMAIL PROTECTED] > > -Original Message- >

Re: IDL_UB1$

Why do you think 700 extents is causing you a problem ? Just about every read to these tables will always be an indexed one (since the dictionary is rule-based), so its not going to matter too much how 'fragmented' things are. hth connor --- [EMAIL PROTECTED] wrote: > Hello All > I found in ou

Enterprise Versus Standard

Does anyone have a good Oracle Standard to Oracle Enterprise comparison Chart ?? I am looking on the various Oracle ran sites and most of the docs seem to try and steer you to Enterprise. Kevin -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Lange INET: [EMAI

RE: ok..this is funny.. how do you pronounce "tuple"

Tuple. Like Tupplewear. Bambi. -Original Message- Sent: Wednesday, November 14, 2001 10:15 AM To: Multiple recipients of list ORACLE-L Hi, it's just like "Tulip", just kind of different... cheers, Stefan "Thomas, Kevin" schrieb: > Kindof like "tooyoupull" only different...! > > ;o

Re: Personal Oracle & tools on WIN98

Patrick, I had the same problem and round robin difficulties when I tried to install the WebDB 2.2 on a machine that had the 8.1.7 client. If you choose another location as the home it will fail and say it has to use the original Oracle home. I installed the developer 6i-rel 2 in a different d

RE: STATSPACK Info

Raj, http://www.oracle.com/oramag/oracle/00-Mar/index.html?o20tun.html http://www.oracle.com/oramag/oracle/00-sep/index.html?o50tun.html http://www.oracle.com/oramag/oracle/00-nov/index.html?o60tun.html This was a 3 part series from the Oracle magazine. HTH Lee -Original Message- Se

Re: real newbie question (i think)

>From 8.1.x upwards, there is a TO_LOB function to convert from longs. The best way would be for the app to understand CLOB's - but I guess thats not an option. If the longs are less than 32k, then you can use PL/SQL to search them - PL/SQL will support a varchar2(32767). hth connor --- Rich

RE: Oracle Text (ConText/InterMedia) and realtime updates

Hey Tony, >From my understanding of an Autonomous Transaction (which admittedly isn't much), the sync would always be one update behind, correct? Because the auto-trans would execute the sync in the trigger body, the current update/insert of the indexed column that caused the trigger to fire wou

Re[2]: Correction : EMC symetrix - 1M stripe width - Raid 0+

We're using the Symetrix storage system as well, but we did not use stripping, but full mirroring instead. Performance has been more than acceptable, but we really haven't pushed it I think. As far as the SAME (Stripe And Mirror Everything) idea from Oracle, that's great if you have the funds an

Re: Another Oracle DBA gets "The Bullet" WAS: Help!: Job Descrip

Sorry, I wasn't paying attention to the headers. I thought it _WAS_ on the OT list... I will make sure Rachel flogs me with wet spaghetti as penance. --S Rachel Carmichael wrote: > > at this point guys move this to the ot list before Jared gets > annoyed... > > but while I have your atte

Re: ok..this is funny.. how do you pronounce "tuple"

Hi, it's just like "Tulip", just kind of different... cheers, Stefan "Thomas, Kevin" schrieb: > Kindof like "tooyoupull" only different...! > > ;o) > > -Original Message- > Sent: 14 November 2001 11:05 > To: Multiple recipients of list ORACLE-L > > Yeah - kind of like "too-you-pull" b

Re: seouc in Feb.

Hi, when exactly will it be ? cheers, Stefan "Bowes, Chris" schrieb: > Going to try, since it's only 30 min from the house. --Chris > [EMAIL PROTECTED] > > -Original Message- > From: Adams, Matthew (GEA, 088130) > [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, Novem

Personal Oracle & tools on WIN98

Hi,   I just installed Personal Oracle 8.1.7 on a win98 machine, this seems ok Now i want to install developer 6i-rel 2 on this machine. But after starting the Oracle installer and fill in the company name I get the following error message   The location specified "C:\Oracle\Ora81", is alre

Re: STATSPACK Info

Raj, I think there is a book devoted to Statspack if you search Amazon or Bookpool. Scott Shafer San Antonio, TX "Jamadagni, Rajendra" wrote: > > Hope the list is up ... this message just returned to me about half hour ago > ... > > Are there any docs available on interpreting statspack outp

RE: Next extent problem

Gene, a shot-in-the-darkis your 'minimum extent' size set to 24K..? That is the only other thing that comes to my mind Cheers, RS --- Gene Gurevich <[EMAIL PROTECTED]> wrote: > Dennis, > > I'm not even sure what is the uniform extents (are > you > talking about the LMTS?). So I think the ans

RE: IDL_UB1$

Pl take a look at Note # 1021102.6 on Metalink. It may help you fix this problem.. HTH, Regards. - Kirti > -Original Message- > From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] > Sent: Wednesday, November 14, 2001 7:51 AM > To: Multiple recipients of list ORACLE-L > Subject: ID

RE: seouc in Feb.

Title: seouc in Feb. Going to try, since it's only 30 min from the house.   --Chris [EMAIL PROTECTED]   -Original Message-From: Adams, Matthew (GEA, 088130) [mailto:[EMAIL PROTECTED]]Sent: Wednesday, November 14, 2001 8:59 AMTo: Multiple recipients of list ORACLE-LSubject:

Bug 1367773

Hi List, does anyone have description (body) of bug # 1367773 Thanks in advance, Ed -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Edward Shevtsov INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California

RE: Power outage

Congrats on pulling yer A** out of the fire.. Amazing that it was a control file...given that L:\ORADATA\LV54\DATA\TBL_FCS_FBTS1_01.DBF was showing as being unwriteable. Nice work -Original Message- Sent: Tuesday, November 13, 2001 7:35 PM To: Multiple recipients of list ORA

RE: Next extent problem

Dennis, I'm not even sure what is the uniform extents (are you talking about the LMTS?). So I think the answer is no Gene --- DENNIS WILLIAMS <[EMAIL PROTECTED]> wrote: > Gene - Are you using uniform extents by any chance? > Just thought it wouldn't > hurt to ask. > Dennis Williams > DBA > Lifet

RE: RE: komplex sql

Not on my data it doesn't. SQL> select * from mytable; FIELD1 Jimmy J1000 No Info Timmy Jimmy J1000 Missing Info SQL> @lee FIELD1 DECODE(FIELD1,'NOINF Jimmy J1000 Jimmy No Info No Info Timmy Jimm

seouc in Feb.

Title: seouc in Feb. I know it's a little far in advance, but is anyone planning on going to the SEOUC in Feb. in Charlotte, North Carolina? It looks like I'll be presenting at it. Matt Adams - GE Appliances - [EMAIL PROTECTED] "Doing linear scans over an associative array is like try

  1   2   >