rtion.
Searches on Metalink and Google both came up with nothing of relevance. I
would assume that with an Oracle8i client it shouldn't be a problem, but I
haven't worked with Forms at all since v3.0 and she is adamant that it is
simply impossible - with no explanation of why.
Don Grana
NULL (meaning perhaps "PROCESSED") and a small percentage
of the records have other non-null values for STATUS ("PENDING","APPROVED",
etc.).
Don Granaman
certified OraSaurus
- Original Message -
From:
AK
To: Multiple recipients of list ORACLE-L
0% OCP (8i + 9i) in about three weeks in
November, perhaps now I can say "OCP doesn't mean squat - except to HR
checklists" - without appearing to be just another crusty old curmudgeon -
or jealous/nervous/worried/antiquated/whatever. If one is really new to
this stuff, then pe
] (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 offi
initialization parameters.
Please see the documentation for your version for options.
Good luck!
Don Granaman
certified OraSaurus
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Monday, February 24, 2003 12:39 PM
> Redhat
is really a
surrogate key?
If so you are in luck! Drop and recreate the sequence with:
create sequence MY_SEQ increment by -1 start with 0 ...
(Add whatever else is appropriate - cache 100, etc.)
Don Granaman
OraSaurus
- Original Message -
To: "Multiple recipients of list ORAC
What platform is this? Windows?
Don Granaman
OraSaurus
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, February 21, 2003 5:48 PM
> Hi listers,
>
> Here is a question my client asked me, that I can't s
system was idle except for
me and a few background processes.)
Agh!
Guess what? It was a bug. When I later found and applied patch
#2773907, the problem disappeared entirely - the query went
from >6.5 sec to 0.01-0.02 sec. All the nonsense that support
suggested or asked for was entir
nia will demand that it be changed to
CF. All that adding a surrogate key here does is complicate the
application. The vast majority of users will never need to drill down to
see what CA means, but to display anything useful on a screen or report, the
surrogate key will always require a join.
Don Gra
1) select * from v$database;
Note: Picky perhaps, but "instance" and "database" may be different.
...
3) grant create session to scott;
Note: CONNECT is a role that includes the create session system privilege
and a LOT more. It is NOT a synonym for "create session&quo
o-back Oracle "certified" configuration
from a major vendor. [In hindsight, I should have been more suspicious when
they used the "c" word so often and so loudly...]
Don Granaman (reluctant OCP)
OraSaurus resurrected
- Original Message -
To: "Multiple recipients of
"automatic with conference registration". I'm not quite sure what that
means if one is already in IOUG, but I suspect that it means there is no
discount!
Don Granaman
[OraSaurus]
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]&g
Detailed plan for transition from order clerk to DBA: OCP
How to become an order clerk: More difficult (no certification exams...
yet!)
Don Granaman
[certifiable OraSaurus & reluctant OCP]
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECT
.1 on Linux - exclusive and RAC - but not yet production. On the
9.2.0.1 RAC nodes, I'm getting tons of trace files with CMInit warnings, but
support said "Don't worry. Be happy. Its OK" Searching for patches for
9.2.0.1 on Linux, I get 22 hits. Most are related to some bug ;)
few months ago a "registration"
for a "trial download" on the web lead only to a marketing call.
No thanks... I feel a bit queasy even now just thinking about it.
Don Granaman
[certifiable OraSaurus]
- Original Message -
To: "Multiple recipients of list ORACLE-L"
e to be granted to the user or to
a role granted to the user. However, public synonyms can be a performance
issue and *may* be undesirable for other reasons.
Don Granaman
[OraSaurus]
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: T
Unfortunately, we have no choice but to use the java-infested, half-baked
ruinStaller.
Don't even get me started about the DataBase Cremation Assistant!
Don Granaman
[OraSaurus]
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
S
tting the situation become so
bad soon that it forces a better, more permanent solution - before the
rapidly increasing transaction volume REALLY hits the fan. The
CURSOR_SHARING=FORCE safety valve is something we are reserving as a last,
temporary resort.
Don Granaman
[OraSaurus]
BTW: Hi Mike!
ctually shut down
the listener on a node other than the one intended? This kind of stuff
probably happens a million times more often than things like SQL injection
attacks.
Sound security practices make both accidental and malicious damage much more
difficult.
Don Granaman
[OraSaurus]
-
I'm still working out the basic cluster quirks - like why
softdog wants to reboot the nodes several times per week! (The most recent,
about 48 hours ago, was because nts hiccuped and the clocks on the two nodes
got about 1/2 hour out of synch.)
Don Granaman
[OraSaurus]
- Original M
AD_ONE, tables with primary or unique key constraint indexes
in BAD_ONE, etc.). There are a few variations on the theme for step 5 - for
example, "recover datafile" perhaps if all the datafiles for the tablespace
are not corrupted.
Don Granaman
[certifiable OraSaurus]
- Original Message -
than a computer search - and with a lot less extraneous
(click/point/scroll/type) activity.
6) Highlighters, margin notes, and sticky-note bookmarks don't work at all
with CDs
I miss hardcopy manuals!
Don Granaman
[certifiable OraSaurus]
- Original Message -
To: "Multiple rec
#x27; though. Example, ORDERS table with a STATUS column -
98% 'Closed', 2% ('New' | 'Pending' | 'Whatever...'). Change the logical to
interprete NULL as 'Closed' and create an index on ORDERS.STATUS. Queries
for open orders - ('Closed&#
nerate the
list in pseudo-random order as a hierarchical tree ("diff" doesn't work very
well).]
After the first dozen or so attempts (on several different platforms, with
several different versions of Oracle8 & 8i), I simply decided that I
wouldn't bother attempting another cl
---
> 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
7;m pretty
sure it existed then also.
Don Granaman
[OraSaurus]
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Sunday, July 07, 2002 5:13 PM
at least... I can't remember now, but I think there was a version of
copy at least a
r" or "more reliable" until I have some first-hand empirical evidence.]
Don Granaman
[OraSaurus]
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Monday, July 08, 2002 5:13 AM
Hi everybody,
Currently we are using Oracle 8
Absolutely! I should have read more closely!
Don Granaman
[Orasaurus]
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Monday, July 01, 2002 1:41 AM
For the reported problem, (1) is the only option as (2) is not possible wit
vast majority of cases, (2) is preferred.
Don Granaman
[certifiable OraSaurus]
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Saturday, June 29, 2002 11:53 PM
Hello,
Running Oracle 7.3.4.4 on Win2k.
Trying to implement unlimite
l still be in
effect!
Don Granaman
[certifiable OraSaurus]
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Saturday, June 29, 2002 9:38 PM
Don,
9i has system managed undo -- you don't think it works yet?
Rachel
--- Don Gra
many use the
"manual shrink" method. My philosophy differs in that not setting OPTIMAL
should be a last resort, not a blanket policy.
Don Granaman
[OraSaurus]
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, June 27,
need any more flaming hoops to jump
through. I imagine there are a lot of people like me out there who feel the
same way.
Don Granaman
[OraSaurus]
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, June 27, 2002 4:33 AM
I&
her than the totally artifical value
of being a common checklist item for hiring authorities now) is to get
people to study, learn, and try things out. However, those things don't
really require a certificate, ILT classes, or checks made out to Oracle.
I agree that this thread is worn out.
I thought is was BOB -("Big Orange Button"). As in "systems administration
by BOB".
Don Granaman
[OraSaurus]
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, June 26, 2002 3:54 PM
th
mirk disappeared, his jaw dropped and he just sat there
staring at me with the best "deer in the headlights" look I've ever seen.
[It must not have been in the Self Test Software Practice Exams or the Exam
Cram books.]
BTW: Grant: Can I buy that .sig from you?
Don Granaman
[OraS
>From my experience with a few DBAs that waved their OCP around like it was a
Nobel prize, some probably should have malpractice insurance. Lots of it.
Don Granaman
[Certifiable OraSaurus - NOCP]
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL
t;learner's permit". The Chauncey certification was more
like a chauffeur's license.
Don Granaman
[OraSaurus - Just say NO(CP)]
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, June 26, 2002 9:33 AM
Well that ex
tion
e) billing rate
[...]
Don Granaman
[certifiable OraSaurus - nOCP]
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, June 26, 2002 6:25 PM
Work experience is better than certification but ...
Getting certified is hard
e mothership to go to the
conference. I always seem to get chances to drag them off for a little
one-on-one time or at least some ad hoc small group discussion. (Its nice
to have friends in low places!)
Don Granaman
[certifiable OraSaurus]
- Original Message -
To: "Multiple recipi
?) executable within a
segmented 16-bit architecture. [These young whipper-snappers today have it
SO easy!]
Don Granaman
[OraSaurus]
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, June 26, 2002 6:20 AM
As I recall,
Two words: "wait events"
I'll forward, in private mail, a posting I made here on April 21, 2002 with
some pointers to sites...
(The subject line was "Re: ioug-a question")
Don Granaman
[certifiable OraSaurus]
- Original Message -
To: "Multiple recipi
low!" Me: "No, its actually
running much faster than normal. It seems that the app isn't submitting
any/much work."]
Another possible alternative is the "Etch-a-Sketch" approach. Give them
whatever kind of nonsense appeases them to get them off your back so you c
I missed this part in my previous response...
Does anyone remember why there never was a 9.1?
We seem to have gone directly from 9.0.x to 9.2.0!
[Did I miss somethng while taking a nap sometime recently?]
Don Granaman
[certifiable OraSaurus]
- Original Message -
To: "Mul
AX
cluster was the granddaddy of OPS]. I don't know about 6.1, but if there
ever was such a critter, I suspect that it was VMS-only also.
Don Granaman
[OraSaurus]
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, June
. (Does anyone else remember the Oracle Developer Programme?
Evidently, it didn't turn out to be the cash cow it was expected to be, so
it quietly disappeared. Don't know about anyone else, but I didn't get a
refund.)
Don Granaman
[Curmudgeon OraSaurus]
- Original Message -
atafiles, redo log groups, and a control file. Just
slap them down, copy redo members & control if necessary, and startup. Very
handy for repeating variations of tests from the same consistent known
state.
Don Granaman
[OraSaurus - Oracle 6 backup habits die hard!]
- Original Message
ing that to 8i OCP obtained prior
to, oh say, June 15, 2002? September 2002?
Don Granaman
[OraSaurus - with more disdain than ever for the evil vampire Larry's OCP
DBA tax]
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Fri
abelas.com/ - bottom left side, under "About Us" ->
Careers -> DB2/Oracle DBA ... or:
http://www.cabelas.com/cabelas/en/templates/community/aboutus/career-details
.jhtml?contentId=MIS_DB2_Oracle_DBA&hierarchyId=10708
Don Granaman
[OraSaurus]
- Original Message -
To: "
that it will
actually do what you need before seriously considering it.
Don Granaman
[OraSaurus]
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, June 04, 2002 1:09 PM
> Cache? What is cache?
>
> -Original Messa
To steal a quote from Matt Adam's white board (sorry Matt!):
"You gotta stop thinking logically, and start thinking Oracley" - Jim Droppa
Don Granaman
[OraSaurus]
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent:
your payroll details for the last five years - I'll pick an
appropriate salary
from the list".
Don Granaman
[OraSaurus]
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, May 22, 2002 8:28 PM
> ...and y
"martyr", but quite a number of others also resigned
within the next
few months (none so flamboyantly though). Of the group (ET) of twenty that I was in,
well over half
had left (voluntarily) within a year. Matt was among the "defectors", as was our
manager and a
large percenta
equire efficient planning and execution. Most
of what is
sometimes blamed on conspiracy is often the result of natural entropy - aided by the
catalytic
agents stupidity, ignorance, greed, et cetera.
Don Granaman
[OraSaurus]
- Original Message -
To: "Multiple recipients of list ORACL
Outstanding response!
Don Granaman
[certified skeptic]
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, May 09, 2002 9:13 AM
> no - DBAs would be skeptical of conspiracy theories.
>
> -Original Message--
.]
---
PS: If the above spawns a witch hunt for any particular parties, you have missed the
point. I
regard the current manager and past managers of the database group as all very good and
well-intentioned. I think that this is true of the vast majority of the people with
whom I have
worked whi
rchives at www.orafaq.com .
Thanks!
Don Granaman
[OraSaurus]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Don Granaman
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mai
v$database will always show one and only one database - the database to
which the instance you are running the query against is attached. As for
how to find out on Windows, I'll leave that to someone who knows Windows
better than I.
Don Granaman
[OraSaurus]
- Original Message ---
! (To make this "fair", compared to
other tools, don't give them any documentation other than the online help,
but start it up and connect it to a database before you turn it over). It
could be days, perhaps weeks!
Don Granaman
[OraSaurus]
- Original Message -
To: &q
discuss the current hot topics on the list. Some of the best "technical
sessions" this year were essentially ad hoc gatherings of ORACLE-L members -
on the sun deck, in Starbucks, and in the hallways.
Don Granaman
[OraSaurus]
- Original Message -
To: "Multiple recipients o
OPS (uh.. RAC), etc.
Don Granaman
[OraSaurus]
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, April 30, 2002 12:59 PM
> Chris,
>
> "alphabet soup, XML, XDK, XSQL, XSLT, XPath, SOAP, ASP, ADO, EJB, BC4J,
&g
s communication
internal to compilers and other tools. In Oracle, DIANA is an intermediate
representation of a PL/SQL program unit, generated by the compiler (SYS.DIANA
package). The Diana includes syntactic and semantic information for a compiled
program unit."
Don Granaman
[OraSauru
adds "requires
two years experience" to anything mentioned in the posting. The recruiters,
with their astounding knowledge of the IT industry, simply typed it up and
submitted it to the web sites. (That is what those big commissions are for
isn't it? ;-)
Don Granaman
[OraSaurus]
-
as the web
site(s). If that isn't *totally* clueless, then what might be? I tried to
explain to them that anyone who said they were "qualified" should be
disqualified - as blatantly dishonest.
Don Granaman
[OraSaurus]
- Original Message -
To: "Multiple recipients of li
nough, that made it MUCH
worse! ;-)
In this case, the flushing "solution" was just barely survival. And,
obviously, it did nothing to avoid the wildly excessive parsing.
In other words, "I agree" - flushing the shared pool is curing symptoms, not
the disease.
Don Granaman
[c
... Probably not really necessary. I'd settle for the LRU bias.)
Don Granaman
[OraSaurus]
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, April 24, 2002 11:03 PM
I think an excellent Oracle kernel enhancement would
%.
Any CEO waits are considered unacceptable.
Don Granaman
[OraSaurus]
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, April 23, 2002 3:33 AM
[...]
> I would also like to point out that not all 'hit ratios'
#x27;F's to pass! However, I AM looking forward to the Oracle10i OCW
(Oracle Certified Wizard) exams - the only ones that will still REALLY mean
anything two years from now. ;-)
Don Granaman
[OraSaurus and curmudgeon in good standing]
PS: I just found my medication (Jack Daniels) and shouldn
Do these qualify?
* Far too much emphasis on Oracle's GUI tools (OEM, DBCA, etc.)
* Too little emphasis on understanding & too much on "knowledge" (i.e. rote
memorization)
* Treating ratios as the holy grail of tuning
* etc...
Don Granaman
[certifiable OraSaurus]
- Origin
e is the other significant
component. I like Craig Shallahamer's anallogy - in the grocery store, one
"waits" in line, then gets "serviced" by the checkout clerk. Even if the
wait is moderate, overall response time (grocery store checkout line enqueue
to checkout complet
t" ... and probably other places on the site...
Note that many of these people are active participants in ORACLE-L. Hotsos
(Milsap) and OraPub (Shallahamer) both offer training in these techniques.
Also, another esteemed list member, Kirti Deshpande, did an excellent "Quick
Tips" ses
:
<[EMAIL PROTECTED]>
=
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Don Granaman
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Pu
one's
insert/delete criteria.
Also, PCTFREE can be set extremely low (1,5,?) for some kinds of objects -
static tables, indexes with strictly inorder data (CREATE_DATE, SEQUENCE#,
etc.).
I agree with always setting PCTINCREASE =0
Don Granaman
[OraSaurus - Honk if you remember UFI !]
-
lementing RAC on a Dell RAC-certified
configuration (Dell 6450 nodes running RedHat 7.1 SBE with an EMC FC4700
array). It will likely go into production within 2-3 months.
Don Granaman
[certifiable OraSaurus]
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EM
unce on
it immediately with a somewhat critical database and has just received all
the hardware this week. I am likely going to try to defer a production date
until after the June release comes out.
Don Granaman
[certifiable OraSaurus]
- Original Message -
To: "Multiple recipients o
Recursion - it called itself endlessly. $HOME/bin (where it lived) was the
leading element of $PATH. After a minute or less, it was thousands of
processes deep. After changing it to "/bin/rm -i $*" it worked as intended.
Don Granaman
[certifiable OraSaurus]
- Original Messag
I don't know about performance, but thick and OCI add one important
element - TAF. I am working now on converting an exclusive Oracle8i system
to 9i RAC, but the front end is thin client (i.e. no TAF).
Don Granaman
[certifiable OraSaurus]
- Original Message -
To: "Multiple
what happened the first time I ran it - processes were
spawning faster than I could kill them, even with a script... It was admin
by BOB time. (BOB=Big Orange Button.) Fortunately, it was on a development
server!
Don Granaman
[certifiable OraSaurus]
- Original Message -
To: "Multipl
go up by as much as 8x.
See Gaja's whitepaper on RAID at http://www.quest.com/whitepapers/Raid1.pdf
.
Don Granaman
[certifiable oraSaurus]
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, April 10, 2002 10:38 AM
I don't think this is true anymore. At one time, PCTUSED had to be set to
"1", but as of 8i, at least, it will be put back on the freelist when empty
if PCTUSED=0. (I haven't tested it myself, but I believe Dave Ensor.)
-Don Granaman
[OraSaurus]
- Original Message
ion of OPS, but perhaps the
magnitude of the delta does justify a name change (e.g. humanoid -> human).
[Note that this is a slight divergence from my previous position.
"Consistency is the virtue of the small mind." - Confucius]. However, I
still think that the main motivation for the name
for now" and "optimal". I
would rather build it better from the start, even if I don't need the
performance immediately, than wait until its a crisis and only then
frantically rebuild everything.
See Gaja's paper on RAID at http://www.quest.com/whitepapers/Raid1.pdf
.
-D
ew years ago, I thought that Dilbert was comic exaggeration.
I have since come to the profound realization that it is subtle
understatement.
-Don Granaman
[OraSaurus]
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, December
and get the file list dynamically from
v$datafile - so no "new" datafiles are overlooked. They also do
archive log cleanup, can verify the backup by reading it off of the
tape, and some other stuff. These scripts may or may not be
appropriate for your case.
Don Granaman
[OraSaurus]
the answer is 42 (x 10 GB). However, that answer
is now obsolete.
-Don Granaman
[OraSaurus]
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, December 06, 2001 3:55 PM
> Informal survey: Datawarehousing.
>
>
reat protection against instance or system failure
and none against media or site failure. It can be part of a hybrid
solution to provide complete protection.
-Don Granaman
[OraSaurus]
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent:
at.${JDATE}.dmp ...
Of course, Julian date (%j) is not what you asked for. See: $ man
date The possibities are endless.
-Don Granaman
[OraSaurus]
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, December 04, 2001 11:0
One page?!?!!? My one page resume would have to just say "Call me for
details"! Two would be cutting to the bone!
-Don Granaman
[OraSaurus]
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, November 30, 2001 1
etely independent of OPS/RAC - which shares a single database.
It could be a standby database, geo-mirroring, ...
The term "mirror accessible" sounds like it came from one of those
pseudo-technical trade magazine articles that are famous for
misinforming senior IT management.
se builds upon the previous. Remember, they are blueprints, not
commandments. Nobody ever builds a house without modifications to the
standard model, and nobody is likely to build an infrastructure that
way either. The concepts can be adapted to other "components" (e.g.
WebLogic and/or Tu
s at:
http://technet.oracle.com/doc/server.815/a68020/ch2.htm#113030
-Don Granaman
[OraSaurus]
PS: This is a joke, right?
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, November 27, 2001 8:30 AM
between oracle 8i and 9i,
Run sqlldr from the OS command line, not from SQL*Plus.
-Don Granaman
[OraSaurus]
- Original Message -
To: "Oracle DBA List (E-mail)" <[EMAIL PROTECTED]>; "Oracle
SQL*Loader E-Mail List (E-mail)" <[EMAIL PROTECTED]>; "Oracle-L
(E-mail)" <
cific view.
Do you have an aps7 or other aps* directory in the tree under
$ORACLE_BASE? Are there other aps* objects that might shed a
clue?
-Don Granaman
[OraSaurus]
- Original Message -
From:
Nirmal Kumar
Muthu Kumaran
To: Multiple recipients of list ORACLE-L
Se
There are N-1 ways to pronounce it.
>
> :^)
Let's call the whole thing off!
-Don Granaman
[OraSaurus]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Don Granaman
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 53
demanding systems it is
still important to segregate some physical I/O to distinct
disks/disksets to reduce contention - and in the case of EMC, to
better utilize the cache.
I agree whole-heartedly on PowerPath!
As always, I would recommend reading Gaja's paper at
http://www.quest.com/whitepapers/
27;t you? If not, you will need a consultant!
This isn't particularly easy for the uninitiated. It will probably
not be particularly fast either - depending on quite a number of
factors (space, size, prior planning for this contingency, ...).
-Don Granaman
[OraSaurus]
- Original Messa
estinations on shared storage - and on shared filesystems if
possible. Also, test the bejeebers out of backup/restore/recovery.
(Very likely, there WILL be initial bejeebers!)
Only (N*10**M - 10) more potential pitfalls to consider...
(Want to hire a consultant? I'm available! ;-)
-Don Granama
my does recover and demand goes back up.
Frankly, I'm almost ready to join Jenny and make a radical career
change. My uncle wants to retire from his successful hardware store
business. I'm considering buying it. (Hmmm... What about he
Menards/HomeDepot/... effect?)
-Don Granaman
[Or
That doesn't sound at all right.
30 minutes is outrageous!
Try Mladen's suggestion.
-Don Granaman
[OraSaurus]
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, November 09, 2001 1:50 PM
> I have LOG_C
; -f2 |
sqlplus -s sys@${tnsalias} @scriptname.sql
done
(If the @ symbols cause grief, just escape them with \ )
BTW: I just used sys as an example. I am not encouraging you to do
everything as sys!
-Don Granaman
[OraSaurus]
- Original Message -
To: "Multiple recipients of list ORA
n the book. The examples
don't even mention some significant options - like striping. This is
not to fault the examples though, for the reasons stated earlier.
There are very few canned answers in this business. Understanding is
infinitely more valuable than "knowledge".
-Don Gr
1 - 100 of 188 matches
Mail list logo
