Problems with hot backup via BCV's...

2001-04-27 Thread Jim Hawkins
, but these are the easiest and most timely). Thanks, Jim Jim Hawkins Lead SAPR/3 Oracle Database Administrator MEMC Electronic Materials, Inc. 600 Pearl Drive St. Louis, MO 633376 9636) 474-7832 [EMAIL PROTECTED] (work) [EMAIL PROTECTED] (home) -- Please see the official ORACLE-L FAQ: http

RE: Linux

2002-10-23 Thread Jim Hawkins
We have Oracle 8.1.7 and 9.2.0 running on Red Hat Linux 7.2 - and love it. It is not a production box though. We are still in test mode. Jim Hawkins Oracle Database Administrator St. Louis, MO Turner, Christine [EMAIL PROTECTED] wrote: Greetings ALL! Have a question for anyone who

RE: Rollback segment shrinks

2002-06-05 Thread Jim Hawkins
, 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). -- _ Jim Hawkins Oracle Database Administrator [EMAIL PROTECTED] St. Louis, MO  USA

32-bit vs. 64-bit on HP-UX 11.0

2002-03-29 Thread Jim Hawkins
-- _ Jim Hawkins Oracle Database Administrator [EMAIL PROTECTED] St. Louis, MO  USA __ Your favorite stores, helpful shopping tools and great gift ideas. Experience the convenience of buying online with Shop@Netscape! http

RE: RE: Deleting old archive log files.

2002-04-04 Thread Jim Hawkins
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). -- _ Jim Hawkins Oracle Database Administrator

Symbolic links for datafiles...

2002-04-17 Thread Jim Hawkins
the names in DBA_DATA_FILES to actual mount points? I need this very quickly. Thanks in advance, Jim -- _ Jim Hawkins Oracle Database Administrator [EMAIL PROTECTED] St. Louis, MO  USA __ Your favorite

World's largest database...

2002-04-18 Thread Jim Hawkins
http://www.computerworld.com/storyba/0,4125,NAV47_STO70250,00.html I thought we had someone on this list from this group, and was just wondering if this particular database was in Oracle or not. Jim -- _ Jim Hawkins Oracle Database Administrator [EMAIL PROTECTED

RE: RE: World's largest database...

2002-04-18 Thread Jim Hawkins
-- _ Jim Hawkins Oracle Database Administrator [EMAIL PROTECTED] St. Louis, MO  USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J  INET: [EMAIL PROTECTED] Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051

RE: RE: RE: World's largest database...

2002-04-18 Thread Jim Hawkins
if this particular database was in Oracle or not. Jim -- _ Jim Hawkins Oracle Database Administrator [EMAIL PROTECTED] St. Louis, MO  USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J  INET: [EMAIL PROTECTED] Fat City

RE: Re: How come I don't get postings

2002-04-27 Thread Jim Hawkins
of mailing list you want to be removed from).  You may also send the HELP command for other information (like subscribing). -- _ Jim Hawkins Oracle Database Administrator [EMAIL PROTECTED] St. Louis, MO  USA

RE: export tables from sql Server to Oracle

2002-05-01 Thread Jim Hawkins
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). -- _ Jim Hawkins Oracle Database Administrator [EMAIL PROTECTED] St. Louis, MO  USA

RE: RE: Using procedures instead of coding update/insert

2002-01-15 Thread Jim Hawkins
://www.orafaq.com -- Author: Jim Hawkins 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

RE: Re: Which Character set?

2002-01-16 Thread Jim Hawkins
Mail account today at http://webmail.netscape.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jim Hawkins INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing

Re: MICROSOFTDTPROPERTIES

2001-05-23 Thread Jim Hawkins
subscribing). -- Jim Hawkins Lead SAPR/3 Oracle Database Administrator MEMC Electronic Materials, Inc. 600 Pearl Drive St. Louis, MO 633376 9636) 474-7832 [EMAIL PROTECTED] (work) [EMAIL PROTECTED] (home) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jim Hawkins

RE: Another Database Down

2001-05-25 Thread Jim Hawkins
. By the way, as soon as our RS/6000 SA upgraded our version of PowerPath, the bug went away, we have consistent mirror splits, and all is well on the SAP backup/restore front... Sorry if I threw you way off on a tangent on this one. Jim Jim Hawkins Lead SAPR/3 Oracle Database Administrator MEMC

Re: OT: My bad

2001-05-25 Thread Jim Hawkins
subscribing). -- Jim Hawkins Lead SAPR/3 Oracle Database Administrator MEMC Electronic Materials, Inc. 600 Pearl Drive St. Louis, MO 633376 9636) 474-7832 [EMAIL PROTECTED] (work) [EMAIL PROTECTED] (home) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jim Hawkins INET

Re:Your views on Quest - Shareplex

2001-05-29 Thread Jim Hawkins
thought all would be interested in the reply. It is a in-line reply to an Oracle MetaLink document. Jim Hawkins Lead SAPR/3 Oracle Database Administrator MEMC Electronic Materials, Inc. 600 Pearl Drive St. Louis, MO 633376 9636) 474-7832 [EMAIL PROTECTED] (work) [EMAIL PROTECTED] (home

Re:Your views on Quest - Shareplex

2001-05-29 Thread Jim Hawkins
Jared, That's a really good question! I don't know the answer... Sorry, Jim On Tuesday 29 May 2001 12:01, Jim Hawkins wrote: From note on MetaLink: 1) There is not sufficient information in the logs to logically replicate transactions, so the data applied to the destination

Re:Your views on Quest - Shareplex

2001-05-29 Thread Jim Hawkins
Jared, That's a really good question! I don't know the answer... Sorry, Jim On Tuesday 29 May 2001 12:01, Jim Hawkins wrote: From note on MetaLink: 1) There is not sufficient information in the logs to logically replicate transactions, so the data applied to the destination

Re:Your views on Quest - Shareplex

2001-05-29 Thread Jim Hawkins
: Jim Hawkins [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re:Your views on Quest - Shareplex Date: Tue, 29 May 2001 11:01:21 -0800 All, We are currently as customer of Quest Software using LiveReorg and Spotlight

Re: Performance tuning

2001-05-30 Thread Jim Hawkins
Azhar, Just two thoughts off the top of my head to improve loading of records: 1. Put database in noarchivelog mode to avoid redo generation (if possible). 2. Drop all indexes on target tables (if possible), then load data, then recreate all indexes on target tables. Jim Jim Hawkins Lead

RE: Performance tuning

2001-05-30 Thread Jim Hawkins
on target tables (if possible), then load data, then recreate all indexes on target tables. Jim Jim Hawkins Lead SAPR/3 Oracle Database Administrator MEMC Electronic Materials, Inc. 600 Pearl Drive St. Louis, MO 633376 9636) 474-7832 [EMAIL PROTECTED] (work) [EMAIL PROTECTED] (home

RE: Your views on Quest - Shareplex

2001-05-30 Thread Jim Hawkins
I verified this today actually. I had a conference call with Quest regarding SharePlex, and asked specifically about the chained rows. They said there is a reorganization step on the target database, so chained rows are not a problem. Jim Jim Hawkins Lead SAPR/3 Oracle Database

Re: HELP! / RE: OT: Archiving not possible with SQL Server?

2001-06-01 Thread Jim Hawkins
the HELP command for other information (like subscribing). -- Jim Hawkins Lead SAPR/3 Oracle Database Administrator MEMC Electronic Materials, Inc. 600 Pearl Drive St. Louis, MO 633376 9636) 474-7832 [EMAIL PROTECTED] (work) [EMAIL PROTECTED] (home) -- Please see the official ORACLE-L FAQ

Re: How to prevent oracle from committing a transaction?

2001-06-05 Thread Jim Hawkins
Keep in mind that if at any point you issue any DDL command, a commit is automatically performed. For example, if you open a SQL*Plus session, insert a few records, then do an alter table ..., those records will be committed. Just a thought... Jim -- Jim Hawkins Lead SAPR/3 Oracle

RE: OT RE: SUMMARY: Thanks everyone - tru64

2001-06-06 Thread Jim Hawkins
I don't really care who's what, as long as I can still play Pink Floyd's Dark Side of the Moon to it. But since we're lobbying for parts, I guess I'll audition for the Tin Man due to his lack of heart ;) Jim -- Jim Hawkins Lead SAPR/3 Oracle Database Administrator MEMC Electronic Materials

RE: OT RE: SUMMARY: Thanks everyone - tru64

2001-06-06 Thread Jim Hawkins
(or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Jim Hawkins Lead SAPR/3 Oracle Database Administrator MEMC Electronic Materials, Inc. 600 Pearl Drive St. Louis, MO 633376 9636) 474-7832 [EMAIL

RE: What stands for i in Oracle 8i

2001-06-06 Thread Jim Hawkins
and leave a trail. -- Jim Hawkins Lead SAPR/3 Oracle Database Administrator MEMC Electronic Materials, Inc. 600 Pearl Drive St. Louis, MO 633376 9636) 474-7832 [EMAIL PROTECTED] (work) [EMAIL PROTECTED] (home) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jim

Serious Question (believe it or not)...

2001-06-06 Thread Jim Hawkins
do this. Jim Jim Hawkins Lead SAPR/3 Oracle Database Administrator MEMC Electronic Materials, Inc. 600 Pearl Drive St. Louis, MO 633376 9636) 474-7832 [EMAIL PROTECTED] (work) [EMAIL PROTECTED] (home) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jim Hawkins INET

OT - Wrap-up of Serious Question (believe it or not)...

2001-06-08 Thread Jim Hawkins
I Learned to Love the Larry directed by Jim Hawkins. Starring (not in order of importance): *Larry Ellison as God *Bill Shrek Thater as The Enforcer (a gentle assassin with a compassionate heart) *Ross Mohan as Hannibal (speedo-wearing cannibal) *Rachel Carmichael as The Goddess (a do-good angel

RE: OT - Wrap-up of 'Serious Question (believe it or not)...'

2001-06-08 Thread Jim Hawkins
the Larry directed by Jim Hawkins. Starring (not in order of importance): *Larry Ellison as God *Bill Shrek Thater as The Enforcer (a gentle assassin with a compassionate heart) *Ross Mohan as Hannibal (speedo-wearing cannibal) *Rachel Carmichael as The Goddess (a do-good angel caught

RE: OT - Wrap-up of 'Serious Question (believe it or not)...'

2001-06-08 Thread Jim Hawkins
, they'll love an invasion of drunk || Oracle DBA's). || || Hidden Parameter, Crouching Developer - or How I Learned to || Love the Larry || directed by Jim Hawkins. || || Starring (not in order of importance): || *Larry Ellison as God || *Bill Shrek Thater as The Enforcer (a gentle

Re: OT - Wrap-up of 'Serious Question (believe it or not)...'

2001-06-08 Thread Jim Hawkins
in days! Thank you, thank you, thank you! Jared ( still laughing ) On Friday 08 June 2001 08:47, Jim Hawkins wrote: Hidden Parameter, Crouching Developer - or How I Learned to Love the Larry directed by Jim Hawkins. Starring (not in order of importance): *Larry Ellison as God

Re: Digestive

2001-06-13 Thread Jim Hawkins
Ross, As part owner of the Laphroaig distillery (see previous post for details), I am highly offended by your description of my product ;) Jim Hawkins Owner(1 Square Foot) Laphroaig Distillery Isle of Islay, Scotland Them's fighten' words friend! Jared On Tuesday 12 June 2001 14:18

RE: Digestive

2001-06-13 Thread Jim Hawkins
, Laphroaig gave away 1 square foot of their distillery if you bought a bottle and filled out all the paperwork. Well, I did it, and am the proud owner of 1 square foot of the Laphroaig distillery! Cheers! Jim ^ Jim Hawkins Lead SAPR/3 Oracle Database

RE: Digestive

2001-06-13 Thread Jim Hawkins
(see previous post for details), I am highly offended by your description of my product ;) Jim Hawkins Owner(1 Square Foot) Laphroaig Distillery Isle of Islay, Scotland Them's fighten' words friend! Jared On Tuesday 12 June 2001 14:18, Mohan, Ross wrote: Lagavulin

Re: Digestive

2001-06-13 Thread Jim Hawkins
this mean I can no longer star in your movie? Rachel From: Jim Hawkins [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: Digestive Date: Wed, 13 Jun 2001 06:55:25 -0800 Ross, As part owner of the Laphroaig distillery

Re: Space Manager vs. Live ReOrg vs TS ReOrg

2001-06-15 Thread Jim Hawkins
to be removed from). You may also send the HELP command for other information (like subscribing). -- Jim Hawkins Lead SAPR/3 Oracle Database Administrator MEMC Electronic Materials, Inc. 600 Pearl Drive St. Louis, MO 633376 9636) 474-7832 [EMAIL PROTECTED] (work) [EMAIL PROTECTED] (home) -- Please

RE: The use of schemas

2002-02-13 Thread Jim Hawkins
Check your consultant's credentials. From what you've indicated, there is absolutely no reason to do this. Tell him he will get to do all the management of synonyms, permissions, and schema exports. I suppose he also wants separate tablespaces for each of these schemas as well? Jim Hawkins

Just got back from SQL*Server 2000 training...

2002-02-18 Thread Jim Hawkins
in order for processing to continue. Leaves system vulnerable until you get a full DB backup. *If you have a 100GB DB that is full, your backup will be 100GB. No compression of backups! Jim Oracle Database Administrator -- _ Jim Hawkins Oracle Database Administrator

RE: RE: Oracle Advanced Replication

2002-02-18 Thread Jim Hawkins
') 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). -- _ Jim Hawkins Oracle Database Administrator [EMAIL PROTECTED

RE: Re: Fw: Just got back from SQL*Server 2000 training...

2002-02-19 Thread Jim Hawkins
on the nature of your system, you could gear the equivalent of an SGA accordingly. I almost spit up my two cups of coffee when the instructor showed me the GUI slide-bar that controls memory allocation to SQL*Server. If you need more, just slide the bar to the right... I still chuckle... Jim Hawkins

RE: 8i and Veritas NetBackup

2002-02-22 Thread Jim Hawkins
to be removed from). You may also send the HELP command for other information (like subscribing). -- _ Jim Hawkins Oracle Database Administrator [EMAIL PROTECTED] St. Louis, MO USA __ Your favorite stores

OT-Genesis of a DBA Universe

2002-03-06 Thread Jim Hawkins
of the creation. And his pager did ring and he ceased from resting and did spend his sabbath on the telephone with Oracle support. And by the time the DBA got through to someone who knew wherof they spake behold it was day and it was evening of the eighth day. And the DBA waxed wroth. Jim Hawkins

RE: Re: NYOUG

2002-03-11 Thread Jim Hawkins
for other information (like subscribing). -- _ Jim Hawkins Oracle Database Administrator [EMAIL PROTECTED] St. Louis, MO USA __ Your favorite stores, helpful shopping tools and great gift ideas

RE: RE: Re: NYOUG

2002-03-13 Thread Jim Hawkins
, persuade) people they meet to get in touch with me for possible presentations. Rachel --- Jim Hawkins [EMAIL PROTECTED] wrote: Rachel, On a related note, I am now on the St. Louis OUG board, and have the same responsibilities of arranging speakers. May I ask what your methodology

RE: RE: Fav. Urban Legend...

2002-03-13 Thread Jim Hawkins
also send the HELP command for other information (like subscribing). -- _ Jim Hawkins Oracle Database Administrator [EMAIL PROTECTED] St. Louis, MO USA __ Your favorite stores, helpful shopping tools

RE: RE: Do you use RMAN?

2002-03-13 Thread Jim Hawkins
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). -- _ Jim Hawkins

Big news regarding Oracle licensing...

2002-03-20 Thread Jim Hawkins
. We're not using this as some kind of revenue opportunity, said Woods. We've got a whole lot of other stuff to sell than a batch feed. We have a lot more to offer, and this is a blip in the radar screen. -- _ Jim Hawkins Oracle Database Administrator [EMAIL

Re: SAP R3 and Locally Managed Tablespaces

2001-07-06 Thread Jim Hawkins
the HELP command for other information (like subscribing). -- Jim Hawkins Lead SAPR/3 Oracle Database Administrator MEMC Electronic Materials, Inc. 600 Pearl Drive St. Louis, MO 633376 9636) 474-7832 [EMAIL PROTECTED] (work) [EMAIL PROTECTED] (home) -- Please see the official ORACLE-L FAQ

Re: Re[2]: SAP R3 and Locally Managed Tablespaces

2001-07-06 Thread Jim Hawkins
the tablespace! Not sure what version of SAP that was, but WOW!! Anyway we're on PeopleSoft right now although they do not support LMT's they don't care either. Dick Goulet Reply Separator Author: Jim Hawkins [EMAIL PROTECTED] Date: 7/6/2001 12:09 PM

Re: Corrupt block in DBVERIFY

2001-07-09 Thread Jim Hawkins
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). -- Jim Hawkins Lead SAPR/3 Oracle Database Administrator MEMC Electronic

Re: Corrupt block in DBVERIFY

2001-07-09 Thread Jim Hawkins
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). -- Jim Hawkins Lead SAPR/3 Oracle Database Administrator MEMC Electronic