Stephane...
Thanks for the reply.
>> SELECT sequence.nextval FROM table WHERE ROWNUM < x
>> It just seems too kludgy, and I didn't think creating a table with
>> dummy data for the count would be a good way to go. Any suggestions?
> Why 'too kludgy' ? If you are inside a PL/SQL package have yo
At 07:28 AM 9/27/2002, you wrote:
>I'm trying to get information of the limitations of ODBC drivers,
>specifically Oracle's and Microsoft's drivers for Oracle.
>Things like maximum no. of records they can fetch etc.
I don't believe there's any limitation in the number of records you can get
thro
On 2002.09.27 20:33 tony ynot wrote:
> Is Select ... For Update;
> a cheap table lock?
> It seems whenever code uses this statement
> all the records in the cursor are locked
> until the cursor is closed.
>
Fancy that! It works as described in the manual! Who would say?
--
Mladen Gogala
--
P
It would appear you don't know the pw of sys, or maybe the capslock is
on ;) If you can sqlplus /nolog can connect and alter the sys pw.
Then you will know the sys pw and can use it on imp cmd.
$ sqlplus /nolog
SQL*Plus: Release 8.1.7.0.0 - Production on Fri Sep 27 19:36:42 2002
(c) Copyrigh
Is Select ... For Update;
a cheap table lock?
It seems whenever code uses this statement
all the records in the cursor are locked
until the cursor is closed.
__
Do you Yahoo!?
New DSL Internet Access from SBC & Yahoo!
http://sbc.yahoo.com
--
Please
Me too.
Bing Wong
Open Systems Database Administrator
This e-mail may contain material that is confidential. Any review, reliance
or distribution by others or forwarding without express permission is
strictly prohibited. If you are not the intended recipient, please contact
the sender and delet
I would love to read that .
bp
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, September 27, 2002 11:08 AM
Hand
> Yes, I would like that too. A lot of people are awaiting your book, btw.
> Ruth
> - Original Message -
> To: "Multi
And besides, the "Are you an idiot?" question is redundant. After all, this
*is* a DBA list...
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
> Sent: Friday, September 27, 2002 5:19 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE:
>
>
> Bob,
>
I tried to do full database import use "sys" ID and have error come
out. for "sqlplus" I can use "sqlplus /nolog" to avoid it, but on
import/export how to avoid it?
RSS::/home/app/oracle/admin/db92/export[173]% imp
Import: Release 9.2.0.1.0 - Production on Fri Sep 27 17:36:13 2002
Copyright (
How many went back to their old non-IT jobs before they moved into IT
during the boom years when IT sucked people from the non-IT sector?
ltiu
DENNIS WILLIAMS wrote:
>List - We have discussed the employment situation a lot over the past year,
>and I am still dismayed to hear of Oracle DBAs out
Greg, For the most part RAW is still a requirement for
RAC. There are more Cluster File system Options now
then there where 6 months ago.
Windows/2000 - Oracle now provides a CFS. I believe
you can download it from OTN. I don't have NT
installed so I can't comment on its reliability or
stability.
Gary Chambers wrote:
>
> > I created a package that would easily loop thru and select x number of
> > entries, but not return them in a select to you. This way, you can
> > make 1 simple call passing it X. Is that what you wanted ??? Or do you
> > have to have them as returned values of a select
List - We have discussed the employment situation a lot over the past year,
and I am still dismayed to hear of Oracle DBAs out of work. I found some
interesting statistics that put the situation in perspective:
In 2001, there were an estimated 10.4 million IT workers in the U.S.
In
Bob,
The 'ARE YOU AN IDIOT?' reply is required on this list
when one encounters a help command sent to the list
rather than the list manager software.
It's from a thread from some time ago, and is meant
in jest. Dave knows it, as well as many others.
Now, you know it too. :)
Jared
"Bo
Thanks all! I've already got the doc d/l'd -- I just couldn't remember
where I saw the numbers. All I could remember was "Goldilocks"! :)
Hmmm...could be a case for an Oracle-based PDM ;)
Rich Jesse System/Database Administrator
[EMAIL PROTECTED] Qu
Title: RE: Setting Cursor Sharing = Force in 8.1.7.3
We had problems with FORCE setting on 901x. The query it was changing to bind variables was
select to_char(sysdate,:b1)
from dual
/
Now :b1 is a format mask supplied by developer. Initially it would work fine and then start throwing OR
This is from Steve Adam's Oracle 8i Internal Services(page 50-51)
Library cache locks are held in shared mode during parse operation.
A pin is applied to the library cache object for a PL/SQL program unit
or SQL statement while it is being compiled, parsed or executed. Pins
are normally held in
I recently used it on 8.1.7.4 and 9i.
I gained 33% performance gain. It would be different depending on how
much literal SQL is used in your code.
My process ran fine, and I was able to load the data. However, I have
not fully checked the data yet.
Shakir
--- "Johnson, Michael " <[EMAIL PROTEC
Rich - The paper that started it all (as far as I know), "How to Stop
Defragmenting and Start Living" posted at:
http://otn.oracle.com/deploy/availability/pdf/defrag.pdf
Suggests for Oracle 8 and above that the uniform extents be one of three
sizes: 128k, 4m, and 128m, and it explains why you shou
> OK, here's the obligatory,
>
> ARE YOU AN IDIOT?
>
> HELP
>
> SET ORACLE-L NOMAIL
>
I think what Jared may have meant to say is
All LIST commands should be sent to
[EMAIL PROTECTED]
NOT
[EMAIL PROTECTED]
You recied a help message whan you subscribed to the effect
Bob
Have a g
Juan Loaiza, Rosanne Toohey, and Bhaskar Himatsingka.
The paper's online at www.hotsos.com/catalog.
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events:
- Hotsos Clinic, Oct 1-3 San Francisco, Oct 15-17 Dallas, Dec 9-11
Honolulu
- 2003 Hotsos Symposium on OracleR System
Reminds of a user who wanted to "ungrade" to Win98. They didn't know how
right they were.
Rajesh.Rao
Make them use bind variables. Even if cursor_sharing did work correctly
(it might in 8.1.7, but I don't remember), using bind variables will
relieve the Oracle kernel of a lot of work (i.e., response time).
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events:
- Hotsos Cl
I went thru this recently ...
The best thing to do is to FORCE the developers to use
bind variables and then this is no longer an issue.
If you do set it to FORCE , I believe there is a problem
with it in versions 8.1.6 and before and it should not be
used.Double Check with Metalink on thi
Nat
You may want to take a look at:
http://www.interealm.com/roby/technotes/cursor_sharing.html
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Friday, September 27, 2002 3:13 PM
To: Multiple recipients of list ORACLE-L
We are looking into setting up
Your update is updating all rows in table1. Is that
what you want ?
nologging only works with direct path insert, not with
update.
--- Gurelei <[EMAIL PROTECTED]> a écrit : > Hi.
>
> I want to update a table based on data in another
> table. Something like:
>
> update table1 a set f1 =
> (s
>
> Can someone please repost the Goldilocks LMT Sizing
> Guideline?
That's from a tar on Metalink... doc 12988.2 (I think)
;->
bob
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Bob Metelsky
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051
For what it's worth, we use 128k, 4m, and 128m. Those numbers were taken
from the paper "How to Stop Defragmenting and Start Living". Can't
remember the author but I'm sure someone will chime in as it's a well-known
paper.
Cherie Machler
Oracle DBA
Gelco Information Network
Exactly... I had to face this at my current job... I have a separate alter
to read only job... Basically, it is a script that calls a stored
procedure... I put the script in cron to run every 12 hours... The stored
procedure alters eligible tablespaces to read only (eligible as defined by
the
NOLOGGING does not work on "update", period. has nothing to do with
aliases.
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, September 27, 2002 3:48 PM
> Hi.
>
> I want to update a table based o
H...even after flushing the cache, MS is still the top link for me on
Google (except for the news stories).
Rich
> -Original Message-
> From: Thomas Day [mailto:[EMAIL PROTECTED]]
> Sent: Friday, September 27, 2002 2:33 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: OT:
> I created a package that would easily loop thru and select x number of
> entries, but not return them in a select to you. This way, you can
> make 1 simple call passing it X. Is that what you wanted ??? Or do you
> have to have them as returned values of a select ?
I would need the values retu
What do you expect? When the god Gates speaks the feeble move.
Reply Separator
Author: "Thomas Day" <[EMAIL PROTECTED]>
Date: 9/27/2002 11:33 AM
They got that changed rather quickly. MS is no where on the first page
now. IF you combine "go to hel
Title: extremely long parse time
Matt,
Is it
Oracle 9?
If
yes, time is in microseconds.
Alex.
-Original Message-From: Adams, Matthew (GEA, MABG,
088130) [mailto:[EMAIL PROTECTED]]Sent: Thursday, September
26, 2002 10:30 AMTo: Multiple recipients of list
ORACLE-LSubjec
I have been asked by damagement on the possibility of of linking Oracle to DB2 so that
an Oracle trigger can update a DB2 table. I have been reading some of the fine manual
along with reading stuff on metalink. >From what I can tell in order to connect to
nonOracle data I need to use Oracles
I'm here.. was away for a day but you guys flood my inbox :)
goldilocks was the name I gave to the methodology of
"small"/"medium"/"large" tablespace sizing. There was no hard and fast
rule for how big each of these tablespaces should be, nor was there one
for the extent sizes.
Just that if a t
We are looking into setting up cursor_sharing parameter to FORCE. Has
anyone seen any bad effects of setting Cursor_sharing=FORCE. Are there any
real bad effects of setting it..?
I was thinking of going back to my developers and make them use bind
variables in their code.
If I set the above pa
Hi.
I want to update a table based on data in another
table. Something like:
update table1 a set f1 =
(select f2
from table2
where table2.f3 = table1.f3
and table2.f4 = table1.f4);
this seems to work, but generates a lot of redo logs.
So I tried to add NOLOGGING. Alas, seems like
NOLOGGING
an
this is the first time I've NOT figured the file size the AR way :)
--- [EMAIL PROTECTED] wrote:
> If I'm feeling particularly AR, or just want to revel in
> the fact that I can do simple multiplication and addition
> without error, I'll figure the datafile size to the byte.
>
> e.g. 200m + 64
The app was getting an ORA-600, which metalink identified as a 'bug' in 9i.
The app uses persistent connections and the 'login' package had been
recompiled without removing the connections. All of a sudden the ORA-600s
started being thrown.
It made me curious (call me George) as to how Oracle han
I created a package that would easily loop thru and select x number of
entries, but not return them in a select to you. This way, you can make 1
simple call passing it X.
Is that what you wanted ??? Or do you have to have them as returned values
of a select ?
Kevin
-Original Message---
Thanks, I'll take a look..
-Original Message-
Sent: Friday, September 27, 2002 12:03 PM
To: Multiple recipients of list ORACLE-L
Dan,
The default is for oracle to determine this by timestamp.
You may want to experiment with the REMOTE_DEPENDENCIES_MODE parameter.
This may not apply t
Thanks. I believe that's how it works on 8.1.6 as well. Of course if someone has
walked away without committing a transaction then one is still stuck. There is also
the problem of distributed queries. If on database A, one selects from
@B. An entry is made into the transaction table on
Thanks Ruth, I may have some legal issues with posting it on the
newsgroup, and I'm trying to work that out with OP right now.
They want to post it, but I have to have the list owner agree to
it, and the item posted has to go through some changes. With the
nature of news groups, it may not be pr
They got that changed rather quickly. MS is no where on the first page
now. IF you combine "go to hell" with Microsoft you get 7 hits but the top
2 are sites commenting on this story.
Ain't it great to have clout.
Anjo...
Thanks for the reply!!
> If X is fixed for all sessions, do a step increase of X so that you
> only have to select 1 row from dual.
Unfortunately, I don't feel I can do that. I'm using the returned
values as unique identifiers to protect against duplicate database
submissions from a we
Oracle seems to be inconsistant in the way it names
roles:
SQL> select role, GRANTED_ROLE from ROLE_ROLE_PRIVS;
ROLE GRANTED_ROLE
-- --
DBADELETE_CATALOG_ROLE
DBA
Can someone please repost the Goldilocks LMT Sizing Guideline? I can't find
it in the fatcity.com archives (search is subject-only!), and I'm guessing
that Rachel's offline, given Her recent post.
As I'm delving into this, I seem to remember from those posts that we're too
small for a Papa Bear
Jared, Thank You .
Tom Kytes book pages 108 to 111 goes into this.
I will continue to follow this advice.
Mike
-Original Message-
Sent: Friday, September 27, 2002 8:43 AM
To: Multiple recipients of list ORACLE-L
I always use indexes on FK's.
If it's a table with many updat
Dan,
The default is for oracle to determine this by timestamp.
You may want to experiment with the REMOTE_DEPENDENCIES_MODE parameter.
This may not apply to your situation as I don't know if it applies to
dependencies on
a local database as well.
e.g. ALTER SESSION SET REMOTE_DEPENDENCIES_MOD
but your outbid already by someone in the UK :)
joe
Adams, Matthew (GEA, MABG, 088130) wrote:
> I got the first bid in!!!
>
>
>
>
>
> Matt Adams - GE Appliances - [EMAIL PROTECTED]
> Their fundamental design flaws are completely
> hidden by their superficial design flaws.
>
Yes, I would like that too. A lot of people are awaiting your book, btw.
Ruth
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, September 26, 2002 4:30 PM
> I was wondering if anyone would be interested in me posting one chapter
from
> O
Hi Ian...
I can tell you how it works in 8.1.7...
You can alter a tablespace to read only with transactions in the database
and the steps are as follows:
You issue the alter to read only command and it will wait for EVERY
transaction in the database that started BEFORE you issued the command
yes, but not recommended for busy systems.
ok for "sandbox" though.
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, September 27, 2002 11:56 AM
> Can Oracle 8.1.7 and SQL Server 2000 be installed on the same box or will
they
> conflict?
If I'm feeling particularly AR, or just want to revel in
the fact that I can do simple multiplication and addition
without error, I'll figure the datafile size to the byte.
e.g. 200m + 64k for an LMT is 2097217536 bytes.
On NT I tend to use NNNMm on 8.0 and NNNM
on 8i LMT's where the extent si
Oracle won't care, but I can't speak for SQL*server. MicroSoft has a habit of
being non-compatible.
Dick Goulet
Reply Separator
Author: "Farnsworth; Dave" <[EMAIL PROTECTED]>
Date: 9/27/2002 9:19 AM
They can be on the same box but memory and CPU ma
OK, here's the obligatory,
ARE YOU AN IDIOT?
"Farnsworth, Dave" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
09/27/2002 08:43 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject:RE:
HELP
-O
and as long as we're coming clean, i too plagiarized. mine from the very
first post in the BOFH saga i believe.
but blame Mladen - he got us started.
--- Original Message ---
Date: Fri, 27 Sep 2002 08:49:06 -0800
With regards to any creativity embedded in the BDBAFH thread that I might
have c
They can be on the same box but memory and CPU may be an issue since they both like
hog each.
Dave
-Original Message-
Sent: Friday, September 27, 2002 11:56 AM
To: Multiple recipients of list ORACLE-L
Can Oracle 8.1.7 and SQL Server 2000 be installed on the same box or will they
confl
I tried to post this in response to the "Best Practices" thread, but for unkown
reasons it didn't seem to make it. My apologies if this is a repeat.
It had been stated that placing each partition in a separate tablespace allowed one
to make a tablespace read only once that partition would n
Can Oracle 8.1.7 and SQL Server 2000 be installed on the same box or will they
conflict?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Eric Richmon
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California
Thank you dear. I take it as the best apology I can get on that subject
-Original Message-
Sent: Friday, September 27, 2002 12:04 PM
To: Multiple recipients of list ORACLE-L
I believe that BASTARD can be applied equally to male or female. From
Webster (slightly edited):
1 : an illegitim
Raj,
if it is a smallish database (or it is running on a fast server). You might
be able to create a separate 8.0.6 instance and leave it running with all
the accounts tablespaces etc. Then if the need arises you do an export from
the new version and import into the old version with the full opt
With regards to any creativity embedded in the BDBAFH thread that I might
have contributed, those who have read the BOFH saga will recognize that I
copied a segment (almost!) word-for-word from Simon Travaglia's original
text. If you haven't read the BOFH sagas, they are a scream (flash to
visual
and #3 is the best fit (for DBAs)
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, September 27, 2002 12:04 PM
I believe that BASTARD can be applied equally to male or female. From
Webster (slight
My issue is that you are among the "technological elite". First of all you
are sophisticated enough to recognize that Microsoft isn't the only
alternative. Second, you are competent to install an alternative solution
and put up with any deficiencies. Everyone like yourselves could switch to
OpenOf
Of course, I meant downgrade. Could you hire me to work for you? ;-)
Connor
Title: RE:
F1
-Original Message-
From: Farnsworth, Dave [SMTP:[EMAIL PROTECTED]]
HELP
-Original Message-
Sent: Friday, September 27, 2002 10:13 AM
To: Multiple recipients of list ORACLE-L
Subject:
SET ORACLE-L NOMAIL
Raj,
The customer needs a fallback strategy with "no data loss" upto 3 weeks
after the cutover.
Thanks
Raj
One attachment (0k)
"Jamadagni,
I believe that BASTARD can be applied equally to male or female. From
Webster (slightly edited):
1 : an illegitimate child
2 : something that is spurious, irregular, inferior, or of questionable
origin
3 : an offensive or disagreeable person -- used as a generalized term of
abuse
-Original Me
On Wednesday 25 September 2002 12:33, Hand, Michael T wrote:
> Got a couple of questions for those of you dealing with SAP:
> 1) Has anyone heard of a timeline as to when (or if) SAP R3 will support
> Oracle 9.x? And,
No, and I doubt it.
> 2) Has anyone implemented table partitions as a method o
Unless it's a text file, it won't make it through the list
software, as binary attachments are deleted.
Maybe put the chapter at an obscure web address
for a limited time instead?
Jared
On Thursday 26 September 2002 13:30, Freeman, Robert wrote:
> I was wondering if anyone would be interested
I always use indexes on FK's.
If it's a table with many updates, it needs them to
avoid locks on the table.
If the table doesn't have many updates, it's not really
necessary, but it doesn't hurt either, and that way I
don't have to figure out if it's busy enough to warrant
the index. :)
Jare
HELP
-Original Message-
Sent: Friday, September 27, 2002 10:13 AM
To: Multiple recipients of list ORACLE-L
Subject:
SET ORACLE-L NOMAIL
_
This email is confidential and intended solely for the use of the
individual to whom it
It will be more work, but still can be done.
Use Win32::TieRegistry in Perl to deal with the registry entries.
Jared
On Friday 27 September 2002 04:58, Kieran Murray wrote:
> Thanks for this Gerardo,
> I forgot to mention, but unfortunately this activity will have to
> be carried out on NT rat
On a more serious note:
- a voice mail should be sufficient
- next morning:
-- a one page post mortem document
-- a note inviting interested parties to a post mortem meeting
A formal post mortem process benefits:
- if a problem re-occurs it is easier to deal with it
- there may be a permane
Jesse,
I agree with you on the third party tools and OEM. I haven't found one that
handles everything I want in an Oracle monitor. I first ran into the problem in
1992, too many 2x4's in the face before coffee! So I wrote my own in Pro*C.
Still use it, but it has grown.
DickG.
_
http://cgi.ebay.com/ws/eBayISAPI.dll?ViewItem&item=2057533249
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Mark LeithSent:
Friday, September 27, 2002 9:38 AMTo: Multiple recipients of list
ORACLE-LSubject: RE: oracle-dba.com domain
anyone
SET ORACLE-L NOMAIL
_
This email is confidential and intended solely for the use of the
individual to whom it is addressed. Any views or opinions presented are
solely those of the author and do not necessarily represent those of
Schlum
The Database Character Set and the National Character Set are different.
Your DB CharSet could be UTF8 but the National CharSet AL16UTF16 .
[I believe that when you create a database without specifying charsets,
the default DB CharSet is still US7ASCII but the NationalCharSet is
AL16]
Where y
For any indexes on the table ,LOCAL prefixed indexes (b*tree/bitmap) is the preferred
way to go !
-Original Message-
Sent: Friday, September 27, 2002 7:18 AM
To: Multiple recipients of list ORACLE-L
tablespace,
That is the recommended way. I have a 6 partition table with each partitio
anyone have a specific URL for the "lot"?
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Adams, Matthew (GEA, MABG,
088130)Sent: 27 September 2002 14:18To: Multiple
recipients of list ORACLE-LSubject: RE: oracle-dba.com
domain
I got th
Yes, we use it for our Winders/Linux/Solaris/HPUX boxes. It's actually used
by our parent company, which also does our networking, MS sExchange
administration, and Windows server admin. I'm on the mailing list for when
server in our building isn't pingable.
Unlike OEM, I've had no problems with
I found that query-only applications seemed to run OK against 8.x.x
databases,
but update applications encountered locking problems because of the expanded
rowid.
(I think Forms 3.0 stores the rowids within the form and only stores part of
the
expanded rowid).
I don't know how you could possibly
That is the recommended way. I have a 6 partition table with each partition
in a different tablespace and each table space on a different drive. It's
working well!
Ruth
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, September 25, 200
Setting LOAD_BALANCING=ON parameter in listener.ora Versus tnsnames.ora .
Which is Better & Why ?
Any Docs , Links ?
Thanks
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: VIVEK_SHARMA
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.
Title: RE: Degrade a database??
I have no fresh ideas but how about keeping a file system backup of your oracle installation and 3 copies (in different locations of course) of a complete cold backup before the upgrade?
Or copy the existing database on a similar but separate machine, ready to
...I feel degraded just reading about it (but that's voyeurism for you)...
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, September 27, 2002 3:28 AM
> If I wanted to "degrade" a database, I'd take it out
> to a cheap pub, get it drunk,
I got the first bid in!!!
Matt Adams - GE Appliances - [EMAIL PROTECTED]Their
fundamental design flaws are completelyhidden by their superficial design
flaws. - Douglas Adams
-Original Message-From: JOE
TESTA [mailto:[EMAIL PROTECTED]]Sent: Thursday, September 2
Perhaps this is a rudimentary question but I haven't
found any good info on this topic. Would someone
please explain the difference between a library cache
lock and a library cache pin?
Is the first simply a dictionary lock on a physical
object (i.e. table) whereas the second is a dictionary
Hi Peter,
FWIW, in our org (pharmaceutical manufacturing) the DBA role sits in the
Information Technology section of the Business Systems & Information
Technology Department. Senior DBA reports to IT Manager who in turn reports
to Chief Information Officer (CIO). The CIO is a senior manager who
I'm trying to get information of the limitations of ODBC drivers,
specifically Oracle's and Microsoft's drivers for Oracle.
Things like maximum no. of records they can fetch etc. As I know very
little about ODBC (which might be reflected in the nature of my question) I
hope I'm asking a sensible
yea i'm interested by all means.
joe
Freeman, Robert wrote:
>I was wondering if anyone would be interested in me posting one chapter from
>Oracle9i RMAN Backup and Recovery
>by Mathew Hart and Myself. I don't want to just force it on you all, or make
>it seem like a marketing ploy. So, if ther
Must say I liked Inka's notion of calling all interested parties with
details, though it could be income threatening =:-0
Maybe a compromise would be to agree some type of SOP for such situations
and have the "interested callers" list put in there. I mean if they are so
keen to know first thing ne
Push the question about the requirement of RAW devices.. and ask if
Veritas's product can work without any restrictions.. The veritas clustered
file system is supposedly "ok" to use with RAC where you can take advantage
of using file systems. But I haven't seen confirmation of that. also-ask
abou
yea i'm interested by all means.
joe
Freeman, Robert wrote:
>I was wondering if anyone would be interested in me posting one chapter from
>Oracle9i RMAN Backup and Recovery
>by Mathew Hart and Myself. I don't want to just force it on you all, or make
>it seem like a marketing ploy. So, if ther
Thanks for this Gerardo,
I forgot to mention, but unfortunately this activity will have to
be carried out on NT rather than Unix. I guess it would be more
complicated as the registry and services would come into play aswell.
Cheers,
Kieran
-Original Message-
Sent: Thursday, September 26
>
> Have you gone through "what's the difference between an
> application DBA and
> a database DBA?" yet?
Oh yes, and a logical dba, and a physical dba ... you name it, we found it
... which rather confirms the point Jared was making - 'We fit everywhere,
and nowhere.'
peter
edinburgh
**
Give me a break - I'm looking for solutions, not to compound the problem!!
peter
edinburgh
> -Original Message-
> From: Inka Bezdziecka [mailto:[EMAIL PROTECTED]]
> Sent: 26 September 2002 20:05
> To: Multiple recipients of list ORACLE-L
> Subject: RE: DBA place in the business (was RE:
ALL_INDEXES is a 9-way table join (some outer) with a
few correlated subqueries. ALL_IND_COLUMNS is a 8-way
table join with a few correlated subqueries as well.
That's a lot of work to churn through...
hth
connor
--- "Adams, Matthew (GEA, MABG, 088130)"
<[EMAIL PROTECTED]> wrote: > why would
1 - 100 of 103 matches
Mail list logo
