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

RE: db version control - schemas, code

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 C

db version control - schemas, code

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

Re: Change PCTINCREAE for SYSTEM Tablespace

ing 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:

Re: Another Oracle DBA gets "The Bullet" in the UK - Seeking an Oracle

ough 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 of

Re: Messy Messy SQL

'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 ':

Re: SQL Loader questions

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 -

Re: Question about temporary segments

00 > 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

Re: CTAS use of rollback

MAIL 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

Re: weekends/holidays

ystem 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

Re: Package standard - 9i for W2000 installation

n 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 fil

Re: !! *Very* important Oracle-L message !!

, 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:/

Re: !! *Very* important Oracle-L message !!

ue 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.

Re: Notification when something changes in the DB

: > 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 li

Re: How do you audit a DBA?

-- > 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 wan

Re: Append date/time stamp to logfile name (NT 4.0)

CTED] (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

Re: Memory Sizing

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 ma

Re: SQL Question

ling 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 ---

Re: sqlloader stops

d 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 (n

Re: Unix and Oracle

E-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 -- Autho

Re: sqlloader stops

ny 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) 53

Re: sqlloader stops

(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 Greenfi

Re: OT : Way OT

; 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 th

Re: completely off-topic question...

; > > >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

Bozeman

ay 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 Inter

Re: OT -- suggestions to ensure nerdiness in potential IT

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, Cal

Re: truncate during query

? 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:

Re: OT -- suggestions to ensure nerdiness in potential IT

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 -

Re: SQL Question

E-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 -- Autho

Re: Management server??

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 -

Re: completely off-topic question...

ssage 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

Re: OT -- the volume of job postings is way down

tandard 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: htt

Re: Data Modeling opinion? Help?

s 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 -

Re: Command History in SQL*PLUS

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 D

Re: 9i standby

entral 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

Re: 9i standby

avid 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

Re: MINUS--Sql help

end 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 acces

Re: Problem with performance

CLE-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 th

Re: sqlplus question ???

rom 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 F

Re: Politics vs. What's Right - long, sorry

t'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 o

Re: * Oracle DBA Needed in Phoenix..

4 [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 > &

Re: Batch updates

g 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

Re: sqlplus command

ou 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

Re: OFA (Optimal Flexible Architecture) in practice

tter 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..

t; > 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 G

New system, cart blanche, what to buy

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

Re: duel error

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 ---

Re: Need Help

(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]

Re: OT SPAM : Become an Oracle Certified DBA in 5 Weeks

lling 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 ---

Re: Job search on this list

s 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.

Basic logon architecture for multiple apps in a db

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 --

More Metajunk frustration (at end of a long day...)

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,