RE: Boolean dates...
Jared's close. It's 2718 - BC -. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Goulet, DickSent: Wednesday, October 22, 2003 3:24 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Boolean dates... Jared, If that's true there has got to be something a little "strange" in the way that Oracle computes julian dates. Beacuse to_date(728,464,'J') returns 05-JUN-2718, where as to_char(sysdate,'J') returns 2,452,935. (comma's added for clarity) Dick GouletSenior Oracle DBAOracle Certified 8i DBA -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]Sent: Wednesday, October 22, 2003 11:39 AMTo: Multiple recipients of list ORACLE-LSubject: Re: Boolean dates...I think what your boss really means is 'julian' date. Does he also want his database in mauve? Try this: select to_date(bdate,'j') from paam; That said, the dates in your example are about 700 years into the future. Jared Jose Luis Delgado <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 10/22/2003 08:19 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject: Boolean dates...Hi to all!We have an old app that manages something that my bosscalls: boolean dates.He told me that exists an algorithm that manages datesas a boolean format.We have several tables in this form:Note: The following table: PAAM has the field BDATE defined as NUMBER.sql> select bdate from paamsql> where rownum < 6BDATE--728464728434728403728495728283now, I need to convert that format to an'understandable' format to get the old data and olddates.I'm looking (google-ing) for that subject but, withoutluck.any ideas? help?, pls...Thanks in advanceRegards!JL__Do you Yahoo!?The New Yahoo! Shopping - with improved product searchhttp://shopping.yahoo.com-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Jose Luis Delgado INET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
RE: db version control - schemas, code
Title: RE: db version control - schemas, code It's on their website, and it does look excellent. Thanks for the tip. Anyone ever use OEM Change Manager? -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Adams, Matthew (GECP, MABG, 088130)Sent: Thursday, October 16, 2003 3:04 PMTo: Multiple recipients of list ORACLE-LSubject: RE: db version control - schemas, code there was an excellent presentation by Mark Stock at SEOUC 2002 called Tag! Whose Code is it? about embedding versioning inside of Oracle objects. I'm reluctant to send it without getting approval from the copyright holder, but the authors e-mail address is [EMAIL PROTECTED] Matt Adams - GE Appliances - [EMAIL PROTECTED] We have enough youth. How about a fountain of intelligence? -Original Message----- From: Yosi Greenfield [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 16, 2003 1:24 PM To: Multiple recipients of list ORACLE-L Subject: db version control - schemas, code Hi All, Client would like me to propose a solution for managing schemas and code in their databases. There are several developers, each making changes to their own schema, and then there's test, qa, and production. There are both schema changes and code changes. Mostly schema changes though. Client would like software (scripts and/or packaged sw) AND a methodology. I've looked at the specs for Oracle Change Manager. Any experiences with that? Can anyone recommend a methodology and/or sw for this? Or articles/books? Thanks, Yosi -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Yosi Greenfield INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
db version control - schemas, code
Hi All, Client would like me to propose a solution for managing schemas and code in their databases. There are several developers, each making changes to their own schema, and then there's test, qa, and production. There are both schema changes and code changes. Mostly schema changes though. Client would like software (scripts and/or packaged sw) AND a methodology. I've looked at the specs for Oracle Change Manager. Any experiences with that? Can anyone recommend a methodology and/or sw for this? Or articles/books? Thanks, Yosi -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Yosi Greenfield INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Change PCTINCREAE for SYSTEM Tablespace
Ken, The system tablespace is created in the file sql.bsq, which should be found in %ORACLE_HOME%\rdbms\admin. Create tablespace system is the first statement in the file. However, before you touch that file, you MUST read Steve's article at http://www.ixora.com.au/tips/creation/bsq.htm. Two points he makes: 1 - Don't edit sql.bsq, make a copy and edit and use the copy, 2- leave the defaults alone, and set a minimum extent of 64k on the system ts. Really, read the page before you do it. HTH, Yosi Ken Janusz wrote: > Is there any way that I can change the PCTINCREASE for the SYSTEM tablespace > without recreating the DB? For some reason the person who created the DB I > am working on set PCTINCREASE to 50 (or didn't did not include this > parameter).I am using this DB for a data conversion so there is no > software connected to it and in turn no users on it. > > Thanks, > Ken Janusz, CPIM > Database Conversion Lead > Sufficient Systems, Inc. > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Ken Janusz > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yosi Greenfield INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Another Oracle DBA gets "The Bullet" in the UK - Seeking an Oracle
Oh no - not you Rachel! Oy vey! Is nothing sacred? You'd think that all of us talented, intelligent, technologically savvy people with time on our hands could come up with a start-up type thing and turn the world upside down, no? Any takers? Any great ideas that you wouldn't mind sharing with this small, informal audience of several hundred thousand? My friend at the major bank cut his 5%. I wonder how they got to keep it out of the news... And he has a meeting with his boss next week sometime. Feeling the heat, as we say... I met with three tech people last week at my sole interview since 9/11 (not like I was rolling in them before that...), of course none of them were in position to hire Oracle people, so then I had to go back to meet with HR. Now my interview process is stuck in HR and there are 'Issues.' If we solve the 'Issues' I get to meet some tech people who might actually be in a position to hire Oracle people. A bit of cart pulling the horse here... Layla tov, buenos noches, bon nuit (sic), gutte nacht, oyasumi (Japanese, as in 'O I suyu, Oyasumi'). Ciao y'all. I'm outtahere. yosi Rachel Carmichael wrote: > and in another month, I'll find out if I'll be joining you and Yosi and > all the others in "the hunt for work". > > We are being absorbed by another internet subsidiary of our parent > company. Tech will either be asked to stay on for the transition period > (meaning we would still be laid off but we'd have some time to prepare > for it) or will be asked to stay on -- but relocate to San Diego or LA. > > I don't know which will be my fate, and I don't know if I'd want to > relocate if asked. > > I'm starting to look around now, I don't expect it to be easy or fast. > I expect I will be asked to take a pay cut if I'm offered anything. I'm > also (like Don and Jenny) thinking of doing something else with my > life. > > at least I know in advance, won't be blindsided and through other, > unfortunate circumstances, have enough money to live on for quite a > while before I have to think about sending the cats out to work. > > But, like the rest here, if anyone hears of something, please contact > me privately. > > Rachel -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yosi Greenfield INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Messy Messy SQL
Jeff,
That's a pretty silly way to store zip codes. Could you create a
zipcode-id table, where you break out each zip and its id? Then
search that table and join back to table a?
Or, if you're at 8i, and if you only get up to a really small number
(like the 3 you display) of zips in a combined zip field, you could
create the first index on the zip field, and two additional function-
based indexes on the second and third zip codes. Then instead of
using like '%9%', you could use the function with which you
created the index, like where substr(instr(zip_field, ' ')+1) like
'9%'.
Some thoughts, hope they help.
God bless America.
Yosi
Jeff Wiegard wrote:
> I've been asked to review some troublesome SQL queries, and since I
> don't know what to do with this one, I thought I'd see what you all
> can come up with.
>
> They are doing the following:
>
> select A.value 1, C.value2, A.value3
> from Table A, Table B, Table C
> where A.id = B.id
> and B.id = C.id
> and (A.ZIPS like ('%54016%')
> or A.ZIPS like ( '%54021%')
> or A.ZIPS like ( '%54351%')
> or A.ZIPS like ( '%54025%')
> or A.ZIPS like ( '%54246%')
> or A.ZIPS like ( '%54071%')
> or A.ZIPS like ( '%54023%')
> or A.ZIPS like ( '%54029%')
> or A.ZIPS like ( '%54078%')
> or A.ZIPS like ( '%54651%')
> or A.ZIPS like ( '%54901%')
> or A.ZIPS like ( '%55514%'))
>
> The only problem is that the actual data in the ZIPS field could be
> in the format of one of the following 3 samples:
>
> 55306:50
>
> 55358:100 56601:100
>
> 56301:25 56304:25 56379:25
>
> The joins are on 400,000 row tables, and it's doing a full table
> scan on all three tables because of the first % wildcard in the like
> clause. It would be easy to get the values if they were all like the
> first format, because I could use 'substr(A.zips,1,5) = '55514'',
> but I don't know what to do with the second two samples, where there
> is more than one zipcode in the field.
>
> I would like to be able to find the ':' character and subtract 5 to
> get the zipcode, but there could be 3 ':' characters corresponding
> to 3 zips in one field. Any ideas?
>
> Thanks,
>
> Jeff
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Yosi Greenfield
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Re: SQL Loader questions
Lisa, No and no. Loader loads rows into tables. If you ask nicely, it will clean out the table completely before it does that. That's all it does. And it does it pretty well. It does not let users redefine tables. And it does not do selective update and delete based on the incoming data file. Other loading tools do that (I know DataJunction does, and others) but not Loader. Yosi YTTRI Lisa wrote: > Hi everyone - > > I need some help. We have an application running on 8.0.5 on NT. My > programmer tells me that she should be able to add columns to a table simply > by changing the sql loader control file definition of the input. I have > looked through the documentation and tried several tests, but I can't see > any way that this would work. > > Is this actually possible with SQL Loader? > > Also, she tells me that if a record exists in the table and she has the same > record (key value only) in the input file, that SQL Loader should update the > record with any changed field values. Is there a special keyword to do this > - I can't seem to find anything on that either? > > Thanks in advance for any help you can give me. > > Lisa -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yosi Greenfield INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Question about temporary segments
Mike, When it creates an index, Oracle doesn't make it visible as it's being built. So basically, Oracle creates the index as a temporary segment in the location it will belong when it's done being created. When Oracle finishes creating the index, Oracle then makes the index 'un-temporary', gives it its specified index name, and leaves it where it is. The alternative would be to create the index in TEMP and then take the extra step of moving the index to its final destination. Oracle doesn't do that. Note that these are different temp segments than the ones Oracle uses to sort the data in order to build the index. Those are, as you noted, stored in TEMP. HTH, Yosi "Petrus, Mike (CAP, GEFA)" wrote: > Greetings All; > I am confused and hope someone can straighten me out. > > My confusion surrounds temporary segments and where they are created. I had > assumed that temporary segments were created in a user's, assigned temporary > tablespace. However when I have a creation failure, for example, if I am > attempting to rebuild an index that is currently in tablespace aww_index1, I > received the following error: (ORA-1652: unable to extend temp segment by > 1280 in tablespace AWW_INDEX1), this is telling me that the temp segment is > being created in the tablespace that the permanent object exists in. Is > this always the case? Is the only purpose of the user's, assigned > "TEMPORARY" table space for sorting. Can I tell Oracle to redirect the > creation of the temp segment to a different tablespace? If so how is that > accomplished? > > Thanks in advance. > > Michael L. Petrus > GE Auto Warranty Services > 7125 W. Jefferson Av. #200 > Lakewood, CO 80235 > > Database Administrator > > Phone: (303) 987 4129 > Fax: (303) 987 4298 > Email: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yosi Greenfield INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: CTAS use of rollback
Confirmed. "Nicoll, Iain (Calanais)" wrote: > Could anyone tell me whether Create table .. as select .. uses rollback. > > I initially thought it would (despite being a cross between ddl and dml) but > having created a 3.5 million row table and checked the sum of the writes in > v$rollstat it had only done ~130k writes between the start of the ctas and > the end. It also doesn't create the table initially but just has a numbered > object which it seems to rename only at the very end, so if it fails I would > have though it would just drop that object and if it completes successfully > then a commit would be done because of the ddl aspects of the command. > > I tried inserting 10k rows into the same table and this came back with about > 25k writes (seemed reasonable if it's only storing the rowid). Given this > it doesn't seem to be using rollback (other than recording changes to > extents etc) but I'd appreciate confirmation. > > Iain Nicoll > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Nicoll, Iain (Calanais) > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Thanks, Yosi - Yosi Greenfield Oracle Certified DBA [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yosi Greenfield INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: weekends/holidays
Lyuda,
For weekends, you can check to_char('&date', 'D'). The 'D'
format returns the day of the week. A 1 or a 7 would indicate
Sunday or Saturday. For holidays, you'd have to write your
own function. You could set up a table of legal holiday dates,
that you would have to populate. Truth be told, there are lots
of holidays, some more observed than others. So you'd really
have to define for yourself which holidays count and which don't.
Then write a function is_holiday to return true if a specific date
is found in the holidays table, or false if its not.
hth,
Yosi
[EMAIL PROTECTED] wrote:
> Hi list,
> Is there a function in Oracle that will determine if particular calendar day
> is weekend or a US holiday. I need to write a function that will check the
> data integrity of my db. It will check data entered into the system and
> notice any gaps. I have to go by days(i.e. every day there should be an
> entry/ies unless it is a weekend or holiday.)
> Thank you in advance,
>
> Lyuda Hoska
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Yosi Greenfield
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Re: Package standard - 9i for W2000 installation
SP2-0310: unable to open file "dbmsany.sql" > SP2-0310: unable to open file "prvtany.plb" > SP2-0310: unable to open file "catxml.sql" > SP2-0310: unable to open file "utlcxml.sql" > SP2-0310: unable to open file "prvtcxml.plb" > SP2-0310: unable to open file "dbmsmeta.sql" > SP2-0310: unable to open file "catmeta.sql" > SP2-0310: unable to open file "prvtmeta.plb" > SP2-0310: unable to open file "initmeta.sql" > SP2-0310: unable to open file "dbmscdcu.sql" > SP2-0310: unable to open file "dbmscdcp.sql" > SP2-0310: unable to open file "dbmscdcs.sql" > SP2-0310: unable to open file "prvtcdcu.plb" > SP2-0310: unable to open file "prvtcdcp.plb" > SP2-0310: unable to open file "prvtcdcs.plb" > SP2-0310: unable to open file "catfga.sql" > SP2-0310: unable to open file "dbmsfga.sql" > SP2-0310: unable to open file "prvtfga.plb" > SP2-0310: unable to open file "dbmsjdwp.sql" > SP2-0310: unable to open file "prvtjdwp.plb" > SP2-0310: unable to open file "dbmsjdcu.sql" > SP2-0310: unable to open file "dbmslms.sql" > SP2-0310: unable to open file "prvtlms.plb" > SP2-0310: unable to open file "dbmstypu.sql" > SP2-0310: unable to open file "prvttypu.plb" > drop package sys.wpiutl > * > ERROR at line 1: > ORA-00604: error occurred at recursive SQL level 1 > ORA-06553: PLS-213: package STANDARD not accessible > > SP2-0310: unable to open file "wpiutil.sql" > SP2-0310: unable to open file "dbmsepgc.sql" > SP2-0310: unable to open file "prvtepgc.plb" > SP2-0310: unable to open file "owainst.sql" > SP2-0310: unable to open file "dbmspump.sql" > SP2-0310: unable to open file "dbmsres.sql" > SP2-0310: unable to open file "prvtres.plb" > SP2-0310: unable to open file "dbmssjty.sql" > SP2-0310: unable to open file "prvtsjty.plb" > SP2-0310: unable to open file "dbmsdrs.sql" > SP2-0310: unable to open file "prvtdrs.plb" > SP2-0310: unable to open file "catrep.sql" > > - Original Message - > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Sunday, September 30, 2001 3:30 PM > > > > > run ORACLE_HOME/rdbms/admin/catproc.sql > > > > That should have been run when the database was created. > > > > Jared > > > > On Saturday 29 September 2001 19:25, Joe LaCascio wrote: > > > I've just installed 8.1.6.2.0, created a database and found that > > > dbms_standard is not there. When I try to run utlrp.sql I get the > > > message STANDARD is not available. I found this out because DBMS_PIPE > > > is missing and can't create created unles DBMS_STANDARD is there. > > > > > > Any help would be appreciated. > > > > > > Joe -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yosi Greenfield INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: !! *Very* important Oracle-L message !!
Nope, not really nearby. Same state and all that, but not nearby. Heck, we barely visited the people on the farm up the road. But I'm sure the Albacore misses you! Ken Janusz wrote: > Did you stop by Portsmouth and visit my old friend the USS Albacore > (AGSS-569)? > > Ken Janusz, CPIM > Database Conversion Lead > Sufficient Systems, Inc. > > -Original Message- > Sent: Wednesday, September 05, 2001 11:16 AM > To: Multiple recipients of list ORACLE-L > > I was away, and when I came back responded with the > following, which the list bounced because of the V-word! > > How dare I take a v.! > > Here it was, with a few words now slightly touched up: > > Aw man, I was on v*a*c_a.t_i*o*n and missed the whole thing! > > Perkins Pond, Sunapee, New Hampshire. Absolutely marvelous > place! I'm in a good mood now after a relaxing week. I'm in. I'd > stay in even if I had a cruddy week. > > Oh - thanks for not making it pay-per-view. I like the public > radio model, - and yes, I donate to public radio - some people > like it and value it more than others, and are more able or willing > to contribute. They cover for those who can't. > > Thanks to Jared and Bruce, as always, for their tremendous > work. > > Yosi > > Anybody ever visit the Sunapee area? > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yosi Greenfield INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: !! *Very* important Oracle-L message !!
I was away, and when I came back responded with the following, which the list bounced because of the V-word! How dare I take a v.! Here it was, with a few words now slightly touched up: Aw man, I was on v*a*c_a.t_i*o*n and missed the whole thing! Perkins Pond, Sunapee, New Hampshire. Absolutely marvelous place! I'm in a good mood now after a relaxing week. I'm in. I'd stay in even if I had a cruddy week. Oh - thanks for not making it pay-per-view. I like the public radio model, - and yes, I donate to public radio - some people like it and value it more than others, and are more able or willing to contribute. They cover for those who can't. Thanks to Jared and Bruce, as always, for their tremendous work. Yosi Anybody ever visit the Sunapee area? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yosi Greenfield INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Notification when something changes in the DB
ng). > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Thanks, Yosi - Yosi Greenfield Oracle Certified DBA [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yosi Greenfield INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: How do you audit a DBA?
iego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Thanks, Yosi - Yosi Greenfield Oracle Certified DBA [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yosi Greenfield INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Append date/time stamp to logfile name (NT 4.0)
Chuck, It's doable, and I've seen scripts on the net that do it, but it's a bit cumbersome. However, you could also do it in sqlplus, using spool, where the name of the spool file is taken from a new_value of a date query, i.e., col x new_value fn select to_char (sysdate, 'DDMMHHMI') || '.txt' x from dual; spool &fn hth, yosi "Speaks, Chuck W." wrote: > OS: NT 4.0 > > I have scheduled a query against a database that pipes results to a log > file. > > Ex. Select * from any_table; >logfile.txt > > Since I need a trend on this query I need to keep the logfile names unique. > Best case scenario is to append a date/time stamp to the logfile name as in > 230820011200.txt (daymonthyeartime). Does anyone know how to do this with > NT scripting? Any help would be greatly appreciated. > > Thanks, > > Chuck Speaks > Database Administrator > Lithonia Lighting > 770-860-3450 > http://www.lithonia.com > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Speaks, Chuck W. > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Thanks, Yosi --------- Yosi Greenfield Oracle Certified DBA [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yosi Greenfield INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Memory Sizing
Did you maybe use a different init file? Did you check the parameters in your email from sql or from the init file you think you're using to start the database? Just a sanity check, I'm sure you did all the right things... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yosi Greenfield INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: SQL Question
Bill, How about inserting all the words from title and subject into the keywords table? You can do this using triggers on those tables. Second, maintain your keyword table so that each keyword record contains the id and a single word, not groups of words. Do this with triggers too, on the keyword table. Then, you can index the keyword table, get rid of the % signs around the query so that it'll use the index, query only the keyword table, and you can query for both existence or non-existence within the keyword table. hth, Yosi Bill Tantzen wrote: > Greetings! > > I don't see a lot of general sql questions on this list, so if this is the > wrong place to post this sort of thing, just let me know! This will > hopefully seem like a simple question, but I am a relative novice in sql > programming! > > Here is the (simplified) scenario with three tables: > > biblio table > id integer > isbn varchar2 > title varchar2 > > subject table (0 or many per id) > id integer (fk biblio.id) > subject varchar2 > > keyword table (0 or many per id) > id integer (fk biblio.id) > keyword varchar2 > > I wish to find all the id's that contain a given word in any of the varchar > fields. My approach has been something like: > > select id from biblio > where title like '%word%' > union > select id from subject > where subject like '%word%' > union > select id from keyword > where keyword like '%word%' > > First question: do you think this is a good way to do it? Is there a > better way? > Second question, how do I do a negative search, that is, find all the id's > that DO NOT contain a given word in any of the varchar fields. Using an > approach similar to the previous sql (using intersect instead of union) does > not work, since there may be biblio records that do not have corresponding > subject or keyword records. > > Perhaps there is not a simple query that will do the trick and I should be > using a stored procedure? > > Thanks in advance for any advice > Bill > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Bill Tantzen > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Thanks, Yosi - Yosi Greenfield Oracle Certified DBA [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yosi Greenfield INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: sqlloader stops
So again I ask, how about running something while running your batched loads, so you can see - and even maybe let us know - what it's getting stuck on. You may even find that it's got NO sql session running, and the problem is in your batch process. That really sounds like your next step in debugging. Check it out, it might help. y lyudah wrote: > If I execute one load at the time maually it loads fine. It gives me hard > time when I try to run multiple loads(one after another) through the batch > file. > - Original Message - > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Tuesday, August 07, 2001 9:05 PM > > > How about using some GUI tool (or even SQL) to see what > > SQL its running, if any, and what counters and waits are > > incrementing... > > > > Good luck, keep in touch :-) > > > > Yosi > > > > > > [EMAIL PROTECTED] wrote: > > > > > Thanks Yosi. > > > No, that is not the case..:-( > > > > > > -Original Message- > > > Sent: Tuesday, August 07, 2001 5:37 PM > > > To: Multiple recipients of list ORACLE-L > > > > > > Silly ol' me. Are you out of space in your archive log destination? > > > > > > This is like a guessing game. :-) > > > > > > [EMAIL PROTECTED] wrote: > > > > > > > Hi List, > > > > I have another problem. > > > > I have a process that loads multiple (~ 20 ) files through sqlloader. > It > > > > works fine on other servers. There is this one server that is giving > me a > > > > hard time. It loads 3 files and then stops. I commented out the > third > > > call > > > > to sqlloader thinking may be there is something wrong with a third > text > > > > file. It loaded 3 files again and stopped on the forth one. > > > > There is nothing in alert log (no errors). Also, there is enough > space on > > > > the drive where the logs are going. > > > > Oracle 7.3.4 on NT. > > > > If anyone has any idea please let me know... > > > > > > > > Lyuda Hoska > > > > (703)797-8656 > > > > > > -- > > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > > -- > > > Author: Yosi Greenfield > > > INET: [EMAIL PROTECTED] > > > > > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > > > San Diego, California-- Public Internet access / Mailing Lists > > > > > > To REMOVE yourself from this mailing list, send an E-Mail message > > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > > the message BODY, include a line containing: UNSUB ORACLE-L > > > (or the name of mailing list you want to be removed from). You may > > > also send the HELP command for other information (like subscribing). > > > -- > > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > > -- > > > Author: > > > INET: [EMAIL PROTECTED] > > > > > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > > > San Diego, California-- Public Internet access / Mailing Lists > > > ---- > > > To REMOVE yourself from this mailing list, send an E-Mail message > > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > > the message BODY, include a line containing: UNSUB ORACLE-L > > > (or the name of mailing list you want to be removed from). You may > > > also send the HELP command for other information (like subscribing). > > > > -- > > Thanks, > > > > Yosi > > > > > > - > > Yosi Greenfield > > Oracle Certified DBA > > [EMAIL PROTECTED] > > > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Yosi Greenfield > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > > San Diego, California-- Public Internet access / Mailing Lists > > > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, in
Re: Unix and Oracle
How in the world did you come up with a subject line of 'Unix and Oracle?' I can't help you get that counter column on top of the buy and sell header line, you may want to put its column to the left of Officer, and maybe BREAK on it to not print duplicate values. And you may have to change some formatting to get the columns how and where you want them, and you can try using the TTITLE command to print column headers and not print column headers themselves (SET HEAD OFF). All that said, as far as the SQL is concerned, here: SELECT counter, officer, sum ( decode ( type, 'BUY', 1, 0) * Price ) Buy, sum ( decode ( type, 'SELL', 1, 0) * Price ) Sell FROMsome_table GROUP BY counter, officer / hth, Yosi Sinardy wrote: > Hi all, > > I have a table with 3 columns which are Counter, Officer, TYPE, PRICE, > Counter number 4 > TYPE is only contain either Sell or Buy > Officer number 4 > price number 11 > > I want to spool out report with SQL to be like this > example > > Counter : 0 > -Buy- -Sell- > Officer > == > 10 11 > 12 13 > 1212 0 1 > 1213 0 0 > > Total 22 25 > > I have a problem combining buy and sell column can someone help me please > > Thank you > > Sinardy > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Sinardy > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Thanks, Yosi --------- Yosi Greenfield Oracle Certified DBA [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yosi Greenfield INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: sqlloader stops
How about using some GUI tool (or even SQL) to see what SQL its running, if any, and what counters and waits are incrementing... Good luck, keep in touch :-) Yosi [EMAIL PROTECTED] wrote: > Thanks Yosi. > No, that is not the case..:-( > > -Original Message- > Sent: Tuesday, August 07, 2001 5:37 PM > To: Multiple recipients of list ORACLE-L > > Silly ol' me. Are you out of space in your archive log destination? > > This is like a guessing game. :-) > > [EMAIL PROTECTED] wrote: > > > Hi List, > > I have another problem. > > I have a process that loads multiple (~ 20 ) files through sqlloader. It > > works fine on other servers. There is this one server that is giving me a > > hard time. It loads 3 files and then stops. I commented out the third > call > > to sqlloader thinking may be there is something wrong with a third text > > file. It loaded 3 files again and stopped on the forth one. > > There is nothing in alert log (no errors). Also, there is enough space on > > the drive where the logs are going. > > Oracle 7.3.4 on NT. > > If anyone has any idea please let me know... > > > > Lyuda Hoska > > (703)797-8656 > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Yosi Greenfield > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Thanks, Yosi - Yosi Greenfield Oracle Certified DBA [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yosi Greenfield INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: sqlloader stops
Silly ol' me. Are you out of space in your archive log destination? This is like a guessing game. :-) [EMAIL PROTECTED] wrote: > Hi List, > I have another problem. > I have a process that loads multiple (~ 20 ) files through sqlloader. It > works fine on other servers. There is this one server that is giving me a > hard time. It loads 3 files and then stops. I commented out the third call > to sqlloader thinking may be there is something wrong with a third text > file. It loaded 3 files again and stopped on the forth one. > There is nothing in alert log (no errors). Also, there is enough space on > the drive where the logs are going. > Oracle 7.3.4 on NT. > If anyone has any idea please let me know... > > Lyuda Hoska > (703)797-8656 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yosi Greenfield INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: OT : Way OT
My guess is that everyone's got too much time on their hands these days...
The market'll pick up, and the list will soften up.
I hope, on both counts.
Yosi
Kevin Kostyszyn wrote:
> Wow!!! You're correct sir!!:)
> KK
>
> -Original Message-
> Thomas F
> Sent: Monday, August 06, 2001 2:42 PM
> To: Multiple recipients of list ORACLE-L
>
> Wow!
>
> you can tell we are approaching a full moon. this list is getting a bit
> nasty!
>
> Tom Mercadante
> {Very Humble} Oracle Certified Professional
> --
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Yosi Greenfield
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Re: completely off-topic question...
Oy - I could NOT get through The Silmarillion, even though I loved the Hobbit (I was but a kid), and I really liked the Trilogy (although I admit to skipping lots of the songs and such...) Some people really read The Silmarillion, huh? Rachel Carmichael wrote: > at least I read all of them, I even read The Silmarillion (sp?) before > deciding that these were books that were never going to be on my "to be > re-read" list > > I remember, from the animated Hobbit, the face of Frodo, and Gollum saying > over and over "MY Preciouss" and "SNEAKING!" > > it sometimes amazes me what I can dredge up from the depths of the black > hole I call my memory... I haven't seen that in at least 20 years, and I > haven't read the books in longer than that. And no, I'm not going to try to > read them again now to see if they are better than I remember. Too much to > read, too little time to read it in > > >From: Jared Still <[EMAIL PROTECTED]> > >Reply-To: [EMAIL PROTECTED] > >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > >Subject: Re: completely off-topic question... > >Date: Sun, 05 Aug 2001 14:50:23 -0800 > > > >On Saturday 04 August 2001 16:25, Rachel Carmichael wrote: > > > > > > > > > > > > I am NOT a fan of Tolkein. I have read the Lord of the Rings trilogy and > > > The Hobbit, seen the Bakshi version of the trilogy and the cartoon > >version > > > of The Hobbit. Sorry, he just doesn't do it for me > > > > > > > > > >Oh my, it's a good thing this is via email. > > > >Just wait till the next IOUG and I'll slip my ring on... > > > >Jared > > > > > > > > Rachel > > > > > > From: "Thater, William" <[EMAIL PROTECTED]> > > > > > > >Reply-To: [EMAIL PROTECTED] > > > >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > > > >Subject: Re: completely off-topic question... > > > >Date: Sat, 04 Aug 2001 10:46:04 -0800 > > > > > > > >Rachel Carmichael wrote: > > > > > oh, my library is relatively small -- when you add in all technical, > > > > > fiction, science fiction, mystery, craft books, throw in the > >knitting > > > > > magazines I still only have about 7 bookcases. > > > > > > > >only 7?;-) sadly my collection was ... um... dispatched by a > > > >vindictive first wife so i have nothing left.:-( > > > > > > > >i miss many of them including "stranger in a strange land" and a boxed > > > >set of hobbit and lord of the rings. *sigh* > > > > > > > >i guess if i had the time i should start hunting in the second hand > >book > > > >shops. > > > > > > > >maybe later today if i get out of work in time. > > > > > > > >having "fun" playing with 9iAS and portal.;-) > > > > > > > > > > > >-- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yosi Greenfield INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Bozeman
Walt (the resident Bozemanian), and All, I don't know if you heard or saw, the cover story in Inc magazine this week was all about Bozeman (and some other places). Some absolutely beautiful pictures in there too. (I shoulda posted this on Friday. When you're on extended vacation, Friday is much the same as Monday, and Friday I was out mostly.) Yosi -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yosi Greenfield INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: OT -- suggestions to ensure nerdiness in potential IT
> > > 3) What company made the first "Portable" (luggable) computers? > It was either Kaypro or Osborne. The Ozzy had a little tiny 40-column > screen and dual 5.25" floppies. The Kaypro had an 80-column screen > and dual floppies. > I had a compaq 'portable' that was the size of an old, big, not-yet invented 486, but had a monitor embedded in the box. 15 years later, my brother tried to use this computer for something real, and I had to explain to him why I couldn't shlep around this thing, and why it wouldn't do that much for him altogether. He probably still has it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yosi Greenfield INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: truncate during query
Ben,
You could test this yourself in about a minute. I don't have a db in front
of me, but I'm pretty sure the truncate, or any ddl operation, will fail
telling you it couldn't get a nowait lock.
Try it. Create a table, say t (a varchar2(1)); Then, insert into t ('x');
Then insert into t select * from t; Do this many, many times until
it takes several seconds to execute. (If you commit between those
inserts, it'll be easier on your rollbacks.)
When you have all these rows inserted, open another SQL session.
Type truncate table t; but DONT press enter yet.
Back in the first window, run a long query on t, maybe union the
query with itself a few times, so that the query takes 10 or 11 seconds
to execute; that should give you enough time to switch to the truncate
window and hit enter.
Then see what happens, and you'll have your answer.
Simple, no?
Ben Poels wrote:
> Hi
>
> What happens if you truncate a table, or drop an index, that
> is currently in use by a long running query? Does the query
> fail or does the truncate/drop hang up?
> Thanks in advance,
>
> Ben
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Yosi Greenfield
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Re: OT -- suggestions to ensure nerdiness in potential IT
I taught a high school class to program Turbo Pascal running on CP/M. Now that was a program. There was one kid in the class who knew way more about this stuff than I did. They all got As. > > If I remember correctly, Microsoft bought QDOS from Seattle Computer Works > for around $50k so they could have an O/S for IBM's first PC. I cannot > remember the name of the guy who owned CP/M, but they would not sign IBM's > non-disclosure agreement, and sent IBM to Gates. MS had nothing to lose > so they signed and the rest is history. > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yosi Greenfield INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: SQL Question
Darren, Just as the % character is a wildcard that matches any number of characters, the _ character is a wildcard that matches any single character. So it matches the S in WORKSTATION, and then the % sign matches TATION_LOCATION. hth, Yosi "Browett, Darren" wrote: > I have a simple query, but the results are somewhat puzzling > > select table_name from dba_tables where table_name like 'EDL_WORK_%' > and I received the following > > TABLE_NAME > - > EDL_WORKSTATION_LOCATION > EDL_WORK_AR_ENTITIES > > Why would I be receiving the first record (EDL_WORKSTATION) if I > try EDL_WORK_A% I get the correct result. > > Is there something about the _% combination ? > > To solve the problem I used the substr command as part of the where clause. > > Darren > > > - > Darren Browett P.EngThis message was > transmitted > Systems Admin/DBA using 100% recycled > electrons > Information and Communications Technology. > City of Coquitlam > P:(604) 927 - 3614 > E:[EMAIL PROTECTED] > > - > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Browett, Darren > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Thanks, Yosi --------- Yosi Greenfield Oracle Certified DBA [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yosi Greenfield INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Management server??
You need to install it. The Console talks to a Management Server, which in turn manages the agents and other processes that monitor the database etc. You really oughtta read the basic installation manual. Not much, just like the first page or two might help. Raghu Kota wrote: > Hi Friends > > When Iam starting my Enterprise Manger console, Its asking Oracle Management > server??? What is that?? I tried with giving host name, But it did't work?? > How to connect my EPM?? > > Thanks > Raghu. > > _ > Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Raghu Kota > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Thanks, Yosi - Yosi Greenfield Oracle Certified DBA [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yosi Greenfield INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: completely off-topic question...
hope this helps hth yosi Michael wrote: > ...which means it's probably going to start a great big thread :) I > see a lot of emails with HTH on them, seemingly some sort of way to > say "thankyou" or something... as they're always at the end of > somebodies message right before they sign off their name.. I have > pondered, and pondered as to what HTH could stand for, could somebody > be so kind as to fill me in ? Thanks,Michael. -- Thanks, Yosi ----- Yosi Greenfield Oracle Certified DBA [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yosi Greenfield INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: OT -- the volume of job postings is way down
As one who has searched these boards of late, I concur. Someone posted a while back a good summary that went something like this: ... The postings are the same ones that have been there for months, but they get a new date on them every three days, the jobs that the postings are for don't exist, if there ever is a real opening all the boards post it from several different recruiters (call them what you will), and for those real jobs they want someone who's done dba, Legato, Veritas, Perl (12 yrs), and Sybase and DB2 to boot. AND they're offering 30k less than you were making at your last job I paraphrased, but that's what I've found too. Also, aside from the poor market, its summertime. Not many new projects start in the summer. I have my *first* interview with an actual hiring company in several *months* of looking, and that didn't come off the standard job boards, nor did it come from a recruiter. Wish me luck. By the way, I've alternately referred to the dot-bomb I came from as dot-compost. It has a nice ring to it. Maybe I can coin the term and make the rent that way... Sigh. Yosi -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yosi Greenfield INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Data Modeling opinion? Help?
Chris, It sounds like the client feels that the Business Mailer is simply a customer, albeit a customer with special needs, and therefore special fields. In your summary, you wrote: Aside from the average consumer, a Business Mailer(BM) can also file a claim. The BM has a special agreement with the client and gets special treatment when filing claims, and therefore a Business Mailer profile is created. ... which actually sounds also like the BM is simply a customer. So I can hear their point of view. Then again, as you point out, the BM is not actually a customer tied to a claim, like most customers, he's a repeat customer. And that sounds like a whole different logical beast, a different logical entity. So, from here, I find it's hard to tell if the BM is simply another customer or a new beast entirely. This would seem to me to be the crux of the problem. So they want to define their relationship with their client, the BM. My gut then says let 'em. It's possible to accomodate a 'customer type' in a customer table, so think of BM as an extremely limited way to handle customer type. (I know that's not how one would implement customer type, but they've decided they ONLY allow two customer types, I think I can deal with that.) What I don't know is do you feel there are already existing specific functions or reports that their spec won't be able to handle? If there are, then I go back leaning towards your design, otherwise I'd let them define their relationship with the BM. (Now my KIDS' relationship with THEIR bm, that's a whole different story!) My2c fwiw. Good luck in general, and in getting out before their model falls apart in particular, Yosi - Yosi Greenfield Oracle Certified DBA [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yosi Greenfield INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Command History in SQL*PLUS
Bill, I'm on NT and the up and down arrows work peachy! That's one of the few things I don't miss about Unix. I didn't think there was anything additional running on my pc to allow the arrows to work, but they do for me. Hmm... Unless you're referring to the windows client. (I just thought of this right before clicking 'send.') I use the DOS client in a cmd window just for this reason. The Windows client doesn't use the arrow keys, the DOS version does. Is that what you meant? Yosi "Thater, William" wrote: > "Deshpande, Kirti" wrote: > > > On NT, I guess use your arrow keys... (Not sure of that, though).. > > nope, at least not with the 8.1.7 client. > > -- > Bill "Shrek" Thater Certifiable ORACLE DBA > Telergy, Inc.[EMAIL PROTECTED] > ~~ > You gotta program like you don't need the money, > You gotta compile like you'll never get hurt, > You gotta run like there's nobody watching, > It's gotta come from the heart if you want it to work. > ~~ > If a program is useful, it must be changed. > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Thater, William > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Thanks, Yosi ----- Yosi Greenfield Oracle Certified DBA [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yosi Greenfield INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: 9i standby
Mark Leith wrote: > No it is not the upgrade of OPS as I understand. They even put OPS down > themselves saying that it was sparsely used, and far to complicated to set > up. Th king is dead; long live the king! OPS was sparsely used, so they renamed it. I'm reading a book about the Communist system and the KGB in the USSR, and this sounds vaguely familiar. > > What RAC does, is essentially link every machine together in to a "cluster", > then each physical machine can touch the same database concurrently > (probably on a central storage unit). There is no actual "standby" when this > is in use, as all machines connected to the cluster work together - but if > one of the machines has a hardware failure, the load is simply spread > between the remaining machines.. Which is exactly what OPS did. You had several machines linked to a centrally stored db. One wen't down, the others picked up the slack. A fat lot I know, I never used it. But I'm pretty sure that's what OPS was all about. I'm sure they've added some functionality. At least, I *hope* they've added some functionality. When the central storage goes down, the RAC instances have nothing to run against. That's where standby comes in. It duplicates the central storage. As I said, I've never done either of these, AND I'm unemployed. So I MUST be an expert! Have a great weekend. Yosi -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yosi Greenfield INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: 9i standby
Mark, isn't RAC just the upgrade for OPS? Then that would make it a 'standby' for the instance, but not a standby for the database, no? Am I misunderstanding something? y Mark Leith wrote: > I attended the Oracle 9i opening yesterday at Oracle HQ in the UK, and one > of the main points they discussed about 9i, was the use of Real Application > Clusters (RAC). Of course you have to be running on Compaq hardware at the > moment, but it takes the need for a standby away, as you essentially just > plug the standby in to the cluster, and make use of it's computing power, > instead of having the standby just stood waiting for a failure.. > > Just a thought.. > > Mark > > -Original Message- > Turner > Sent: Thursday, July 12, 2001 08:26 > To: Multiple recipients of list ORACLE-L > > Anyone know if the standby in 9i can be in readonly mode while the logs are > being applied? I've heard about this as being the case and also that this > isn't > the case. > > Thanks, Dave Turner > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: David Turner > INET: [EMAIL PROTECTED] > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yosi Greenfield INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: MINUS--Sql help
Rivandra, The minus operator is a set operator. It subtracts one result set from another. That is, the rows from the second result set that exist in the first result set are removed from the first result set, and the remaining rows are returned. To substract one sql numeric result from another, use sqlplus variables. col a new_value a_hold select 15 a from dual; -- a_hold now contains 15 select 25 - &a_hold from dual; will provide the desired result. hth, Yosi Ravindra Basavaraja wrote: > I am writing a SQL query using the MINUS operator.Both the select statements > return a number result and I > am trying to get the o/p with the difference of both the queries using the > MINUS > between the two select statements.But I am getting the o/p of the first > query only > and the displayed result is not the subtracted value.Both select statements > give > different number o/p when run individually.What could be wrong. > > Is there anything that i am missing to consider when using the MINUS > operator. > > Pls help > > Thanks > Ravindra > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Ravindra Basavaraja > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yosi Greenfield INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Problem with performance
Alexander, All of the performance books you may one day read will tell you that before you tune waits, first make sure your SQL is good. That is, run explain plan (or any gui tool that will run explain plan for you) and make sure the sql is using the appropriate indexes, etc. If all that works, then try increasing your buffer cache. hth, Yosi Alexander Ordonez wrote: > Hi gurus, > > I have problem with the performance of the Database > the user report that db is very slow. > i check the statistics i get: > > free buffer waits in 72774 > buffer busy waits in 171940 > > this isthe only high..other is normal > > the dba shutdown every day in the night for backup > > somebody can help me!!! > > @lex > > Lic. Alexander Ordóñez Arroyo > Caja Costarricense del Seguro Social > Soporte Técnico - División de Informática > Telefono: 295-2004, San José, Costa Rica > [EMAIL PROTECTED] > > > UNIX is very user friendly, > It's just very particular about who it makes friends with. > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Alexander Ordonez > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Thanks, Yosi - Yosi Greenfield Oracle Certified DBA [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yosi Greenfield INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: sqlplus question ???
Yes, there is. You'll get at least 5 replies for this, 'cause it's an easy one, but maybe I'll be first. Sum computes on breakpoints, so you have to set the sum (which you did) and also set the breakpoint (which you did not). Add break on report to the sql file. Good luck, yosi Andrea Oracle wrote: > Hi all, > > I have these in sqlplus: > set pagesize 999 > Set linesize 100 > Col file_name format a50 > Col bytes format 999,999,999,999 > compute sum of bytes on report > select file_name, bytes from dba_data_files order by > file_name; > > The query returns all the data files back, but it did > NOT show the sum of the bytes. Is there anything I > forgot to set? Thank you. > > Andrea > > __ > Do You Yahoo!? > Get personalized email addresses from Yahoo! Mail > http://personal.mail.yahoo.com/ > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yosi Greenfield INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Politics vs. What's Right - long, sorry
Empathy oh empathy! Buckets and buckets of empathy! YOU candid and frank? No way!!! ;-)) y "Koivu, Lisa" wrote: > > > Happy Friday everyone > > I've gone from a fast paced environment (small company), to an > extremely fast paced environment (dot-com) , to my current employer > (large company) that is so bogged down in politics that nothing is > done 'right'. Even the tapes aren't switched for the backups on a > regular basis - it's so bad that the operators will pop a tape out and > push it right back in, and there's no protection on the backup files. > In other words, backups may or may not work. > > I am not the one responsible for the db I am referring to above. The > person who is claims that there's nothing much he can do other than > complain to his boss, who complains to someone else (in another state) > and suppossedly "comes down" on the operators. This has been going on > for months and months. So as we were talking, he says to me, What > would you do? Play the game, try to slowly change the system, or buck > it? Well, since he's been taking the route of slow change, I said > BUCK IT. I gave him three alternatives and even suggested either 1. > quantifying the loss of one day's worth of data, or even being down > for 10 minutes, or 2. flying out there and meeting the operators/their > manager face to face and explain what the impact is, or do both. He > said #2 would be viewed as going around his boss (well, don't do it > without talking to your boss first, you clown). I also said, What's > your #1 priority? He said, Keep my job. I said, yes, but a dba's job > is to always be able to recover, dude, you know that! > > There's a lot more than this situation above that is stuck in a > political game. Most notably, funds for the project I am suppossed to > work on - coincidentally, we have no hardware. > > I may be blowing off steam here, and if that's what you think I am > sorry. However I'd be interested in what angle you would take. I am > NOT a politician - I am very candid and frank. I am no buttkisser. > This is gonna be difficult and I honestly don't know if I want to > stick around for this. How many of you have been in this type of > situation? > > Thanks > > Lisa Koivu > Oracle DataBORED Administrator > 954-935-4117 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yosi Greenfield INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: * Oracle DBA Needed in Phoenix..
My turn. As someone with a current salary of $0.00, if I were to take a job with a 75k base, it would take _years_ to work my way back up to my most recent salary. (We're talking NY, so cost of living and salaries are higher than in many other places.) Although, as you write, Dick, I'm looking to the future with my seat firmly in the present. In the future I see a clear possibility of hungry children who need diapers, ambling about in tattered clothing. (Violins, anyone?) At which time, 75k may seem like alot. (Ok - it's really not that bad - only one of the kids needs diapers, the clothing shouldn't tatter for at least two or three months, and the kids are ALWAYS hungry anyway.) The question is a good one, 75k now or wait a few months, lose thousands and thousands of dollars, but get a salary commensurate with where I've been. A six month consulting gig would work awfully well now. Yosi [EMAIL PROTECTED] wrote: > OH, I've stayed out of this one, but I think a word or two should be acceptable. > > $75K with minimal relocation may be cheap upfront, but if your current salary is > $0.00 then this is better, even if the relocation $$$ are not what one would > expect. Besides, I started here at $36K some 9 years ago & pretty darn soon > their going to crack the $100K barrier. So look to the future, even if one must > live in the present (when one is at the bottom of the barrel, all roads point > up). > > Besides I understand Arizona is a low cost of living state. > > Dick Goulet > > Reply Separator > Author: "Koivu; Lisa" <[EMAIL PROTECTED]> > Date: 7/6/2001 12:09 PM > > Here we go again! OCP means You Read The Book and Passed 5 Tests, > Congratulations, Thank You for Your Money! > Experience is what counts. > > $75,000 is middle ground. Again, I say! Middle ground salary with menial > relocation package? CHEEAP! > > > -Original Message- > > From: ef 8454 [SMTP:[EMAIL PROTECTED]] > > Sent: Friday, July 06, 2001 2:42 PM > > To: Multiple recipients of list ORACLE-L > > Subject: RE: * Oracle DBA Needed in Phoenix.. > > > > $75,000 is pretty good. Our company (in Washington, DC) just hire a > > ORACLE > > DBA. He claimed he have OCP > > certificate and ONLY asked $60,000. > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yosi Greenfield INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Batch updates
We briefly thought of using Oracle Lite. It uses a subset of replication and advanced queueing to do its magic. It looked like it might have worked. But, as we wanted to sell a product, Oracle Lite licensing added like 300 bucks a seat to the product, so the boss decided not to go with it. Of course, 6 months later, that department is now dead, there is NO product, including no product that would have cost an extra 300 bucks. Yosi Guy Hammond wrote: > Does Oracle Lite do this? I remember attending a seminar where Oracle > were talking about running Lite on PDAs to support sales force > automation. They could take orders and check inventory on their PDAs, > query contacts and itineraries, etc, then it would replicate to real > Oracle in one batch when they connected to dial-up every day. There was > a mechanism for reconciling conflicts, for example if you had 100 units > in stock, salesman A sold 50 and B sold 60, maybe customer A would get > 45 units and B 55 until new inventory was ready. That sort of thing. > > g > > -Original Message- > Sent: Friday, July 06, 2001 4:41 PM > To: Multiple recipients of list ORACLE-L > > I'd appreciate hearing from folk what "solutions" there are for the > following scenario. Users with laptops want to be able to input data > whilst > not connected to database for subsequent upload to database. Apart from > developing PL/SQL code to realise this functionality with associated > integrity checks etc. are there other possible (3rd party) solutions? > > If database was small enough there has been some notion of copying > database > to laptop and subsequently re-synchronising when connecting to central > database. Are there solutions out there for this? > > I've a sneaking suspicion the solution to this is hidden in the caverns > of > my memory but it ain't coming out! > > Thanx in advance for anyone who takes time to reply :) > > Sean :) > > Rookie Data Base Administrator > [0%] OCP Oracle8i DBA > [0%] OCP Oracle9i DBA > > Organon (Ireland) Ltd. > E-mail: [EMAIL PROTECTED] [subscribed: Digest Mode] > > Visit: http://groups.yahoo.com/group/Oracle-OCP-DBA > > "Nobody loves me but my mother... and she could be jivin' too." - BB > King > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: O'Neill, Sean > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Guy Hammond > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Thanks, Yosi - Yosi Greenfield Oracle Certified DBA [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yosi Greenfield INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: sqlplus command
Milind, You can't do sqlplus from procedures. There are some ways to get output from pl/sql. One is to use the dbms_output package, which does send output to a sqlplus session if you have set serveroutput on. Another idea that's used might be to put your output lines into a staging table, each record containing a field with the sequence number of that line in the output. Then when the procedure finishes populating that table, simply select the data from the staging table. (Oracle 8i global temporary tables are good for that too.) Good luck, y milind ambegaoker wrote: > Dear mailing list, > is it possible to execute SQLPLUS commands from > subprograms like procedures and functions ? > If possible pl. send me how to do it ? > If not please tell me why and alternate way > as i want to write sub programs(procedures) that would > generate reports on the SQL prompt by using the > SQLPLUS formatting commands. > > > Do You Yahoo!? > For regular News updates go to http://in.news.yahoo.com > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: =?iso-8859-1?q?milind=20ambegaoker?= > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Thanks, Yosi - Yosi Greenfield Oracle Certified DBA [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yosi Greenfield INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: OFA (Optimal Flexible Architecture) in practice
Linda, Try ls -ltr /*/oradata/db_name1/* Didn't think of that, didja. It's actually pretty cool that (in Unix) you can actually reference all your data/log/control files with one filespec. Doesn't work well on NT, but it's better than non-OFA. HTH, Yosi "Hagedorn, Linda" wrote: Does anyone use OFA as their company standard? If so, are there any complaints about it's structure? For example, the commingling of different database subdirectories under a given mount point? e.g.. /u02/oradata/db_name1/userdata01.dbf /u02/oradata/db_name2/userdata01.dbf /u03/oradata/db_name1/userdata02.dbf /u03/oradata/db_name2/userdata02.dbf You cannot cd to a given subdirectory, ls -ltR | more to see all the datafiles associated with a given database. Instead, from / you have to ls -ltR | grep db_name1 to scan the full file system. Seems like there should be a better way. Any input, pro or con, is appreciated. Thanks, Linda -- Thanks, Yosi --------- Yosi Greenfield Oracle Certified DBA [EMAIL PROTECTED]
Re: * Sr. Oracle DBA Needed in Kansas City, Kansas area..
Oh c'mon guys. Don't stop. 4 years replication, 3 years data warehouses - minimum 2 terabytes; Erwin, Designer 2000. Toad is a plus. I go through 10 of these a day now. Ugh. Yosi [EMAIL PROTECTED] wrote: > Lisa: > > You need to update this. > > Must not be over 30 years old with a minimum of 15 years > of post graduate work as an Oracle DBA with a minimum of > 5 years of experience with 9i and 11i. etc. > > Ken Janusz, CPIM > > Requirements: > > Must be able to lift heavy database files. > > Must be at least 30 years old, having graduated from college and immediately > > become a DBA and put in your 7 years. > > > > This position is with a Great company offering: > > Base salary only. 110K is only to get your attention. > > The opportunity to become the most abused member of a team. > > The opportunity to live in Kansas City (is that good or bad?) > > > > I can't stand headhunters. They serve a real purpose but a majority of them > > are jerks. > > > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yosi Greenfield INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
New system, cart blanche, what to buy
All, For a position that would (possibly) like me to set up an Oracle infrastructure from scratch, on Unix. Given the opportunity to choose from any system, what hardware would you pick? >From the small bit of information I've been able to glean, it'll be fairly large, and need failover. I obviosuly can't guess the size of the system, but one part of the question is vendor. I'm familiar with Solaris, but HP seems to be platform of choice these days. And each vendor has their own storage methodologies, and their own HA clustering mechanisms. And there's always OPS. Any opinions, pointers, caveats? (Is this a broad enough question? :-) Yosi -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yosi Greenfield INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: duel error
Your email says duel. You created dual, with an a, right? And did you grant select on dual to public? And create a public synonym for it? HTH, Yosi Shirish Khapre wrote: > hi > i accidentally dropped duel table from sys..then recreated it. > now when i am using rman during running the catrman.sql for recovery_catalog > it is flashing error > > select '08.00.05' from dual > * > ERROR at line 2: > ORA-00942: table or view does not exist > > u'r help is highly appreciated > > Shirish Khapre, SE Rolta India Ltd. > Off Ph No. (+91) (022) 832,826,8300568 > Ext'n 2730 > Minds are like parachutes. They only function when they are open > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Shirish Khapre > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Thanks, Yosi - Yosi Greenfield Oracle Certified DBA [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yosi Greenfield INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Need Help
Ken, Welcome to the club. Are we starting a trend? At least we're not competing against each other. Good luck, Yosi [EMAIL PROTECTED] wrote: > I need some help. I was an Oracle DBA with ADC Telecomm > in Minnesota and was laid off along with 7,000 other ADC > employees. The job market here in the TCs has been > very slow. > > Any assistance finding another Oracle related position > would be greatly appreciated. Please contact me directly > at [EMAIL PROTECTED] > > Relocation from the Mpls / St. Paul, MN is not an option. > > Thanks much, > > Ken Janusz, CPIM > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Thanks, Yosi - Yosi Greenfield Database Architect Comhill Systems, Inc. [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yosi Greenfield INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: OT SPAM : Become an Oracle Certified DBA in 5 Weeks
Yup. And another one today also from a recruiter with a french name that I don't remember that sort of demanded I email him my current whereabouts, statistics and resume. Deleted them both - and I'm pretty desperately LOOKING for a job. How not to win friends and influence people. Yosi "Joe S. Testa" wrote: > Did anyone else on the list get this stupid spam besides me? > > thanks, joe > > -Original Message- > To: [EMAIL PROTECTED] > Sent: 6/12/01 5:48 PM > > OraKnowledge eBoot Camp for the Oracle8i DBA Track > > OraKnowledge has created a blended e-learning program that GUARANTEES > Oracle DBAs will become certified. The 5-week program combines the best > of self-paced and instructor-led e-learning utilizing: > > * Syllabus for Success > * Certification Exam Guides > * Pre-assessment tests > * Live, virtual classroom instruction from an OCP > * 24 x 7 OCP Mentoring > * eFlash Cards > * Hundreds of Practice Questions > * Guarantee > > Seats are available for our July 16th (EST) and July 18th (PST) start > dates!! > > Visit http://www.oraknowledge.com for more information. > > To UNSUBSCRIBE from our list, reply to this email and replace the > subject line with UNSUBSCRIBE. > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Joe S. Testa > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Thanks, Yosi ----- Yosi Greenfield Database Architect Comhill Systems, Inc. [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yosi Greenfield INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Job search on this list
Thanks to those who've responded so far. I forgot to mention I'm looking in the New York Metro area. Small market, no competition. Thanks. [EMAIL PROTECTED] wrote: > All, > > I hate interrupting all the scrumptious, gastronomic activity going on > today, but... > > How much of a no-no is it to use this list to declare myself officially > almost-unemployed and looking for work? The way I figure it > is that if one does this regularly and uses this board as a free > advertising forum, that would be bad, but to let everyone know > that the writing is on the wall, in bold, and I'll consider all offers > for food would be ok. > > Since that's how I figure it, here goes: > >For rent or sale: one 15-year Oracle dba / engineer >/ architect, with certification. Market-rate to >possibly pricey, communicates very well, and can >(usually) make the database sing. For details, >contact Yosi Greenfield at [EMAIL PROTECTED] (for a >LIMITED time!), or at [EMAIL PROTECTED] > > Any offers of employment will be considered - possibly gasped at with a > look of horror, but considered. Any offers of food will be queued until the > offers of employment run out. > > Ok y'all, really now, if anybody's got a need or a lead, lemme know. > > MUCH thanks, > > Yosi > > > Yosi Greenfield > [EMAIL PROTECTED] > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Thanks, Yosi ----- Yosi Greenfield Database Architect Comhill Systems, Inc. [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yosi Greenfield INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Basic logon architecture for multiple apps in a db
O Esteemed and Wise Colleagues, (My first sending of this didn't seem to make it to the list... Knowing our mail server it may show up in a few weeks!) How do application (Forms or other) users access your tables? Do they logon as themselves? Do you switch their logon behind their backs to that of the app owner (like Oracle Apps does?) I'm wrestling with this now. The way I see it, I've got two choices, with several subchoices: 1. User logs in as self and accesses the tables either: a. via synonyms (to tables or to table API package), or b. via full table path qualification, i.e., GL.ACCOUNT or GL.ACCOUNT_API (package). 2. User logs in (knowingly or unknowingly via behind the scenes smoke-and-mirrors) as app owner, and accesses tables directly. Peronally, I much prefer the logging in as self route. It's easier to trace users, sessions, security, access, performance, etc. I also prefer using synonyms, since most application design environments - including Forms - don't fully qualify tables or views by default. The problem is that synonym names can conflict between applications. One solution is to prefix the app_short_name to the name of each table or view. I hate that. Another thought is to create synonyms dynamically as the user logs on to an application. That's no good if the user logs on to two apps at the same time. If you go with relogging in as the app owner, you somehow have to keep track of who the user really is (some common package variable, most likely) and then use that info as needed. That sounds like lots of extra code. So, how do YOUR users access your apps? Any ideas? I need guidance, and I'll really, truly, honestly, very much appreciate any you can send my way. TIA, Yosi -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yosi Greenfield INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
More Metajunk frustration (at end of a long day...)
All, For those of us paying tens to hundreds of thousands of dollars for support, can we sue Oracle for not honoring support contracts and get rich quick? Considering that it's near impossible to create a tar, is this not a valid thought? And if we can't get rich quick, can we force them to no longer make us enter tars through Metamisery? Signed, Frustrated in Metaloo land. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yosi Greenfield INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
