nd be unavailable to archive local logs? do archivers give priority to local logs somehow? Is there a way to separate local archive processes vs. remote archive processes? I do not want to increase the number of archivers because this will only saturate the network more...
Thanks!
Jim
here but so far it has been a real pain to keep track of all the backups running in our enterprise.
TIA
Jim
Do you Yahoo!?
The New Yahoo! Search - Faster. Easier. Bingo.
I want to change TRANSACTIONS_PER_ROLLBACK_SEGMENT default parameters of rbs segments.
but i don't know where this parameter is, how can i deal with it?
¡¡¡¡¡¡¡¡Jim
[EMAIL PROTECTED]
2003-01-02
--
Please see the official ORACLE-L FAQ:
, but worked finally after a
while, I got lots of those messages from alert.log file. what's the exact meaning of
those messages? My Oracle is 8.1.7.3.0. and OS is aix 5.1
Thanks in advance.
¡¡¡¡¡¡¡¡Jim
[EMAIL PROTECTED]
2002-12-30
--
Plea
Where can i find any softcopy or hardcopy books containing explanations or details of
all data dictionary table?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Jim
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San
how to modify the default vaule for v$log_history?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Jim
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
I've been told the same thing, but the reasoning was that they couldn't guarantee what
was put out for download was actually the correct build. Not sure that's very
reassuring, either.
Jim
-Original Message-
Sent: Thursday, November 14, 2002 12:34 PM
To: Multiple rec
like to work something out? Obviously, we are looking for
the authors, Guru's, IOUG presenters, other User Group presenters, etc.
Thanks,
Jim
--
▪▪▪▪
Jim Hawkins
Oracle© / MS SQL*Server© Database Administration
St.
have their own orahome with
apache. iAS Release 2 is smart enough to keep its various apaches, etc on
diffferent ports but the 9.2 DB install might not be.
Jim
-Original Message-From: Don Malzahn
[mailto:[EMAIL PROTECTED]]Sent: Monday, November 11, 2002
5:44 PMTo: Mul
x27;m sure here's some
gotchas involved but some variation on that theme might
work.
Jim
-Original Message-From: Tim Gorman
[mailto:[EMAIL PROTECTED]]Sent: Wednesday, November 06, 2002 8:49
AMTo: Multiple recipients of list ORACLE-LSubject: Re:
Data Purging
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
Wow. That is a perfectly logical and amazingly simple explanation I would never have
thought of. I am in awe.
Jim
Chris,
The answer may be in what occurs below the water. Remember that
RESOURCE is a bit special (here for Oracle 5 compatibility reasons),
that it is one of the two (I
.
Poor Mr. Tech Lead, another sleepless night. I logged off, turned out the light, and
slept like a baby.
Next morning, hangover. The phone rings. I snatch it up angrily...
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Conboy, Jim
INET: [EMAIL PROTECTED]
Fat City Netw
anges on a server can
trigger the problem. Not a reassuring scenario for disaster recovery, eh?
Jim
-Original Message-
Sent: Tuesday, September 17, 2002 6:13 PM
To: Multiple recipients of list ORACLE-L
Thanks to everyone who suggested ideas for my "emergency" yesterday. The
hell do they show in metalink
searches if we can't see them?). And the developers, if you can ever get to them,
know their stuff and are a pretty decent bunch.
Jim
-Original Message-
Sent: Wednesday, August 14, 2002 5:18 PM
To: Multiple recipients of list ORACLE-L
Well, that's
Now please, please tell me you don't REALLY talk about this geeky stuff at parties!
Jim
-Original Message-
Sent: Monday, July 22, 2002 9:53 PM
To: Multiple recipients of list ORACLE-L
Wish I could. This was at a party, and the person speaking was an
Oracle employee. We were ta
but only until reboot, SCOPE SPFILE changes the
initialization file but won't take effect until reboot.
Jim
-Original Message-
Sent: Thursday, July 11, 2002 11:43 AM
To: Multiple recipients of list ORACLE-L
For Oracle 9.2 (Solaris), can anyone tell me where Oracle is expectin
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).
--
Pl
Terry,
What do you have "optimal" set to? I believe shrink only shrinks to the optimal size.
Jim
"Ball, Terry" <[EMAIL PROTECTED]> wrote:
>Oracle 8.1.6.3 on Sun Solaris 2.6.
>
>The rollback tablespace filled up last night and the rollback segments
If you are on SQL*Server 2000, you can use DTS (Data Transformation Services) to
unload data to Oracle.
Jim
Kader Ben <[EMAIL PROTECTED]> wrote:
>Hi listers,
>
>Can someone tell me how import tables from SQLServer
>to Oracle.
>
>Than
solely on these calculators needs their head examined. But
they can in fact provide useful information. $75K in Spartanburg doesn't look to be
below-market.
Jim
-Original Message-
Sent: Monday, April 29, 2002 3:28 PM
To: Multiple recipients of list ORACLE-L
The only problem with this
As evidence of this, HomeFair.com's salary calculator says a salary of $100,000 in
Manhattan is equivalent to $32,000 in Spartanburg. Doubt this is accurate to the
penny, but if even close it sounds like $75K has you living like a king (or queen) in
Spartanburg.
Jim
-Original Me
And new ones joining every day!
Wow!
Jim
bill thater <[EMAIL PROTECTED]> wrote:
>[EMAIL PROTECTED] wrote:
>
>> oh oh, lisa has a fan club :-)
>
>
>with lots of members.;-)
>
>
>
>--
>--
>Bill "Shrek" Thater
Are there any jobs running? There's a couple of init.ora parameters that must be set
first.
Jim
-Original Message-
Sent: Friday, April 19, 2002 2:04 PM
To: Multiple recipients of list ORACLE-L
If the parameters suggested are already set up right , I have one more thing
to ask.
Ian,
Thanks for the info. Very interesting.
Jim
"MacGregor, Ian A." <[EMAIL PROTECTED]> wrote:
>The 0.5 petabyte database at SLAC does not use Oracle; it uses Objectivity.
>Objectivity is a small company which makes an OODB. When the project started there
>was
I can believe that - I think they are the group that offers all the geneaology
services to track family histories. I'll bet that's one heck of database too!
Jim
"Boivin, Patrice J" <[EMAIL PROTECTED]> wrote:
>At the Oracle Technology Day here they mentioned that
Note 159801.1 (Full JVM Removal on 8.1.7) on Metalink may help. Haven't tried it
myself but I fear I'm about to.
Jim
-Original Message-
Sent: Wednesday, April 17, 2002 12:08 AM
To: Multiple recipients of list ORACLE-L
Hi All
I am trying to add Java support to one of the
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
e 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
__
You
You can recover just one or a set of datafiles with RMAN. I've had to do that for a
recovery before. It will recover just the datafiles you need plus the necessary
archive logs.
Jim
"Koivu, Lisa" <[EMAIL PROTECTED]> wrote:
>No, not from what I saw. I may b
We currently have PeopleSoft running on HP-UX 11.0 64-bit OS and Oracle 8.1.6 32-bit.
We want to upgrade to Oracle 8.1.7.3 on the same OS, but the question is, do we go
with 32-bit or 64-bit Oracle? Any feedback or information would be much appreciated.
Jim
g and an overall higher cost.
Oracle has 20,000 database customers in the United States.
"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
thi
s -s scott/tiger
produces the following output:
D
-
X
****
Jim
-Original Message-
Sent: Thursday, March 14, 2002 8:33 AM
To: Multiple recipients of list ORACLE-L
!/bin/ksh
sqlplus / <>> [EMAIL PROTECTED] 03/14/02 06:26AM &g
u there
are some on this list who've just realized they've been tricked into
using an expensive add-on product they may not be able to back out of at
this point.
Jim
-Original Message-
Sent: Wednesday, March 13, 2002 3:29 PM
To: Multiple recipients of list ORACLE-L
While I a
But if using a backup catalog, doesn't the catalog have to be the same exact version
of the database being backed up? That is, RMAN 9i may be used to do the backups as
long as it writes to an appropriately versioned catalog. Is my thinking correct?
Jim
"Freeman, Robert " &l
This may have already been stated, but how about:
Making your SGA size bigger will always yield performance gains.
There is a Law of Diminishing Returns at work when all the latches, free lists, etc.
are taken into account for managing such a large SGA...
Jim
"Orr, Steve" <[EM
;NO!"
And also, thanks for the other information about finding speakers.
Jim
P.S. Our website is www.sloug.org in case you are interested.
Rachel Carmichael <[EMAIL PROTECTED]> wrote:
>Jim,
>
>I might be interested in speaking, depends on dates and if the user
>group pays
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 is for this,
as well as if you would be interested in speaking?
:)
Jim
Rachel Carmichael <[EMAIL PROTECTED]> wrote:
>well
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
Rick,
This is what our corporation uses as a standard. We are not having any of the
problems you describe, however, we are on HP, AIX, Tru64, and NT, not Solaris.
Jim
[EMAIL PROTECTED] wrote:
>Is anyone using this combination? We're having problems getting backups to work with
for SQL*Server. Based 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
tandby and primary in sync meta-data wise is not possible
with SharePlex. Just something to consider. If you have a very active environment,
this becomes a nightmare.
Jim
Oracle Database Administrator
Nick Wagner <[EMAIL PROTECTED]> wrote:
>Not yet, support for those objects are schedu
r.
*When txn log fills up, have to just "truncate" the log 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 Administra
Holy cow Mladen, what a memory!
Does anybody else remember (or admit to) using UFI?
Jim
**
...does anybody still remember VAX/VMS, ORACLE$BI, IOR and ODT?...
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author
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?
J
I was once told with certainty from an Oracle instructor that Scott was
an early developer, and Tiger was his cat. But without actually meeting
Scott I take this with a grain of salt. I expect there are many urban
legends surrounding this.
Jim
-Original Message-
Sent: Wednesday
or us. As far as cost, HP wasn't competitive, Sun was much
cheaper. Due to the cost difference we probably wouldn't be buying any
more HPs, except when a certain product is only certified on HP or when
the purchase decision is made by an HP-centric manager.
Jim
-Original Messa
We use WE8ISO8859P1 as a corporate standard for all databases globally with no
problem. Haven't tried UTF8 yet though.
Jim
"Ron Thomas" <[EMAIL PROTECTED]> wrote:
>
>Unless you have the need to support other languages other than English or need to
>support ch
I would also add that since stored procedures are "stored" in the database, they are
backed up in the database as well. This has saved me a few times...
Jim
[EMAIL PROTECTED] wrote:
>So what is the basis for the case by case judgement. I'm not being flip -
>I really
You darn skippy, Bambi. We never got specific error messages,
either. Just got something like 'patch failed' with no reference to where
or why. The world's gone soft since the days when 'computer people' all
wore white smocks and carried boxes of punch card
we had to get our usage licenses directly from Oracle.
But since we had a corporate agreement with Oracle which covered these users
anyway I never pursued that issue and can't vouch for it.
Jim>>> [EMAIL PROTECTED] 10/26/01 05:55PM
>>>
When you say for SAP only do you
lity I'd appreciate hearing from you. Thanks.
Jim
>>> [EMAIL PROTECTED] 10/26/01 02:51PM
>>>
Take a look at
OrionServer (www.orionserver.com)
at $1,500 / server and 5x faster
than Web Logic, I would wonder why people would use others. And OAS9i uses Orion as the core
n
d 9i came with a new
servlet. I looked on Metalink and couldn't tell, is that 'new' java
servlet really Tomcat?
Jim
>>> [EMAIL PROTECTED] 10/26/01 10:50AM >>>
:-) Wait 2 weeks and I will tell you how
is it running up to 500 people.
"Oracle and BEA who
en go
with one of the big boys for the production system. Have you - or anyone
else - had Tomcat working in a production environment with, say, 100-200
concurrent users? Thanks.
Jim>>> [EMAIL PROTECTED] 10/26/01 08:35AM
>>>
PL/SQL. Java code only on Tomcat-Jakarta
(
luding indexes' made this
work like a charm for me.
Jim>>> [EMAIL PROTECTED] 10/24/01 11:25AM
>>>
I
couldn't verify that the non-partitioned indexes become unusable after
exchanging the partition for the normal table. In the sample I posted
I snipped the output
Y'know, Bambi is such a gentle name, but you're scaring me with this
in-depth knowledge. :-)
JIm>>> [EMAIL PROTECTED] 10/19/01 03:59PM
>>>
Yes, well, I think that they thought that was a pretty snazzy
way not to pay on life insurance. In practice,
though, if
I think you can run an "analyze index validate structure" on all the indexes
in the tablespace associated with that datafile. Once you identify the
corrupted index(es), you can drop/recreate them.
Jim
> I have a corrupt block according to DBVERIFY. The block is on an inde
I think you can run an "analyze index validate structure" on all the indexes
in the tablespace associated with that datafile. Once you identify the
corrupted index(es), you can drop/recreate them.
Jim
> I have a corrupt block according to DBVERIFY. The block is on an inde
r a nice fee, of course). They found nothing wrong with our
configuration, set-up, platform, etc. Their answer? Let's run this during
times of low database use. I'm still laughing...I guess times of low use
can span weeks in a large corporation!
Jim
> Jim,
>
> I d
le BTABD, STABD, etc.
tablespaces. That would be the only thing I can see SAP being nervous
about. In order to do table reorgs, I do this in the sense that I have a
BTABD and a BTAB2D tablespace that I reorg the table to/from. Sorry if you
already knew all this, but maybe others would benefit.
Preferably with no close friends or relatives, nobody to notice if you
just...disappear.
Jim>>> [EMAIL PROTECTED] 07/06/01 09:10AM
>>>>orastaff wrote:>We would like to submit someone
who is a renter and who is interested>in Phoenix but has not applied to
P
dept_one)
union
(select emp_id, dept from dept_three minus
(select emp_id, dept from
dept_two union select emp_id, dept from dept_one))
/
and then go for some coffee if these tables are large at all.
Jim
Hello listI have a scenario in which I have to check three
tables. If there is
Isn't SYSTEM the original locally managed tablespace? (lower case anyways)
%^)
Jim
-Original Message-
Carmichael
Sent: Monday, July 02, 2001 4:10 AM
To: Multiple recipients of list ORACLE-L
Justin,
You can't make the SYSTEM tablespace a locally managed tablespace. Oracle
w
* from
temp;T-bbb3 rows selected.SVRMGR>
Maybe some unwanted overhead with the
view, but it might help out.
Jim
>>> [EMAIL PROTECTED] 06/30/01 04:56PM
>>>Is there a way to do what would be an ALTER SYNONYM?I've
got a synonym created that rotates between pointing
they should. Just wanted to
point that out, because Joe as provided the definitive answer, but only if you
can read his entire response! Weird.
Jim
>>> [EMAIL PROTECTED] 06/28/01 11:06AM
>>>
ok lets cover this again on unrecoverable/nologging(yes i've
done the researc
llion row table this
method was very fast compared to DELETE.
Jim
>>> [EMAIL PROTECTED] 06/28/01 10:58AM
>>>
Yes that is right. rgds amar -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, June 28, 2001 6:25 PM To: Multiple recipients o
No, buffer is ignored for
DIRECT=Y. But RECORDLENGTH should be set to DB_BLOCK_SIZE, or a multiple
of it. I've had dramatic gains in performance doing this.
Also, pre-8i you couldn't do
direct-mode export of LONG fields. As of sometime in 8i you can (I know it
works in 8.1
He also included something like "in the
Congress" in his statement, so it was pretty clear he was speaking about
providing political support as opposed to technological innovation. If you
read the transcript there's not much confusion. But it does make for some
go
Were you looking for something like this?
export PS1='$PWD:[$ORACLE_SID]:'
Jim
-Original Message-
Alex
Sent: Wednesday, June 20, 2001 1:26 PM
To: Multiple recipients of list ORACLE-L
Anybody knows how to show current working directory and in general shell
variable in Korn
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: Jim Newman
INET: [EMAIL PROTECTED]
Has the larger use of memory resulted in swapping? That could slow things
down.
Jim
-Original Message-
Poovathummoottil
Sent: Wednesday, June 20, 2001 11:26 AM
To: Multiple recipients of list ORACLE-L
Hi All,
We have small data warehouse database. Some queries
against some fact
Agreed, _Oracle_ users BSIDBA and OPS$BSIDBA are not the same (spelled and
pronounced differently :>) , even though the _UNIX_ user BSIDBA would run as
OPS$BSIDBA.
Can you select count(*) from BSIDBA.FA_IDNT?
If so, you could try creating a synonym FA_IDNT for BSIDBA.FA_IDNT.
Jim
-Origi
l off;
2) In your script have two commands:
sqlplus user/password start rename.sql
call rename_export.bat
HTH, Jim
-Original Message-
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Date: Monday, June 18, 2001 9:56 AM
>Hello all,
> I know, I know, NT. A
rchive logs for transactions posted against the table being reorg'd is
in SharePlex. All three are separately sold products.
Hope that helps.
Jim
> Sun Sparc Solaris 2.6/8
> Oracle DB 8.0.6, 8.0.5
> Oracle Apps 11.0.3
>
> My client and I are currently planning on re-orging some
Together we have 2 square feet. I smell corporate take-over!
Jim
Jim Hawkins
Owner(1 Square Foot)
Laphroaig Distillery
Isle of Islay, Scotland
> I own 1 square foot as well, got my certificate at home to prove it. Hmmm
> nice.
>
> - Mike.
>
> -Original Message-
&g
in the DBA
movie series - the same way big-time movie directors always stick with the
same actors (Tarentino comes to mind).
Jim
> well, I have to agree with Ross, I do not like peaty Scotch (and Laphroaig
> was the first single malt I ever tried -- it almost stopped me completely)
>
Laphroiagies stick together.
Jim
> Damn! You took the bullet that was meant for Jared.
>
> Drats, Foiled Again!
>
>
>
> -Original Message-
> Sent: Wednesday, June 13, 2001 10:55 AM
> To: Multiple recipients of list ORACLE-L
>
>
> Ross,
Maybe idiot was the wrong word, because I do love Laphroaig. I meant that I
was kind of childish, like when they used to send in proof-of-purchases for
secret decoder rings back in the '50's.
Jim
> I don't know if that makes you an idiot, unless you hate the Scottish and
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
>
Always glad to spread some semi-on-topic humor on Fridays. It helps me out
of the daily drone mode...
By Monday, I'll be back to my serious, helpful, wannabe-guru self!
Cheers, everyoneand another round of virtual Guiness on me!
Jim
>
> Oh god Jim, this is the best laugh I
ds
> || under age 4), so
> || I've decided to follow the other camp's suggestion. That's
> || right, we're
> || going straight to the big screen. Join me in next year's
> || Cannes Festival in
> || southern France (yeah, they'll love an invasion of
ed me from his yacht and really wants to add
another character:
Bill Gates as The Extortionist.
I'm now taking bids on who gets to ax this guy in the movie...
Jim
> How about the films theme song?
>
> I vote for "Database Writer" : sung to the tune the Beatle
That's perfect! Bartender...another Guiness for Lee, please.
> No doubt 8192 Century Blox
>
> Lee
>
>
> >Virtual Guiness Stout to all on the list, compliments of my new film
> >company.
>
> Jim
>
> --
> Jim Hawkins
> Lead SAPR/3 Oracle
uot;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 assassin with a compassionate
heart)
*Ross Mohan as Hannibal (spee
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
hed some light?
>
> Thanks,
>
> Muths
>
> "Do not go where the path may lead, go instead where there is no path
> and leave a trail."
>
>
--
Jim Hawkins
Lead SAPR/3 Oracle Database Administrator
MEMC Electronic Materials, Inc.
600 Pearl Drive
That's funny, 'cause if you ask the developers, I'm the stupid "dunkey"
(Eddie Murphy's donkey character). Is that why they keep saying I'm
an "ass"?
Jim
> Actually I'm torn... I REALLY want to be the wicked witch.
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 Dat
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 SAP
My bumper sticker:
"If you make it idiot-proof, they will build a better idiot."
(Note: can be paraphrased with the word "developer")
Jim
>
> >It got me thinking that it would be fun to have some bumper
> stickers made up for
> >m
with files
over 2GB. Our EDM tape server cannot backup files larger than 2GB.
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)
>
> A general ru
t; 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 Electron
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 Oracl
Sorry - that's what I meant. No archive log generation. NOT no redo log
generation. Thanks for pointing that out. Is it Friday yet?
Jim
> Why putting DB in noarchivelog will avoid redo generation? There will be
no
> archiving, but redo will continue to be generated.
>
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
Rachel,
Sorry for the confusion - I meant that my sales rep got Eyal to reply to
this, and then sent me the informative email. I did not, however, know
that I was getting it from the VP for Technology! I guess I should have
been really impressed with my sales reps leg-work!
Jim
>
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
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
p. I
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]
I call for your immediate removal from this list. We do not tolerate
mistakes. Goodbye - you are the weakest link!
Just kidding...welcome.
Jim
> I didn't mean to reply-all. That's my bad.
>
> Chuck Speaks, MCSE
> Database Administrator
> Lithonia Lighting
>
1 - 100 of 129 matches
Mail list logo