One of our web developers tells me that the values he is
getting back from a REF CURSOR (dynamic SQL in 8.1.7 stored proc) is not
returning the expected values.
Naturally, all the blame is placed on the database and the
"stupid" Oracle stored procedure, because it all works just fine in $QL
Vivek,
You left a few things out.
What's 'intensive'?
As in how many rows are affected?
How big are the transactions?
Updates and deletes?
11 gig doesn't sound like all that much to me
if it's you're doing massive dml.
I had 1 gig logs on a similar hardware setup on a DW
that would easily
You can check alter index clause and you will find parallel option. You may
use parallel 5 safely being default in initSID.ora. However it will start
building 5 times extent in temp tablespace before completion of rebuilding.
With rebuilding large indexes on regular basis we have to use all suc
I had filed down their horns at the time...
--Scott
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, August 03, 2001 4:44 PM
> I've met those hellspawn... NOT!
>
>
> >From: Scott Shafer <[EMAIL PROTECTED]>
> >Reply-To: [EMAIL PROTECTED]
Title: RE: completely off-topic question...
Whoops! I'm tempted to say "damn you, US measurement system" (when is the USA going to switch to metric anyway?), but the fact of the matter is my brain was on the fritz. Thank you for correcting my mistake Mr. Norrell.
All right then, perhaps the 9
-6 month old? congratulations on the soon to be arrival :)
if 34 = teen
then late 20's = pre-teen/adolescent
early 20's = child
and I am ready for the old age home :)
>From: "Anderson, Brian" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL P
you are mixing up two of my favorite authors :)
e.e. cummings (never used uppercase)... was a poet. He wrote my most
favorite poem... somewhere i have never travelled
E.E. "Doc" Smith wrote the Lensmen series -- yes, I have a complete set in
paperback
>From: "Thater, William" <[EMAIL PROTECT
Hi Gurus,
I have a problem, perhaps someone can shed some light on this, please,
I have a temporary Tablespace, which keeps on running out of space. At first
I would increase the size, yet it still keeps filling up. Failing to be able
to extend, until I increase it again.
The object in the tables
Oracle techs constantly encouraged me to upgrade the Oracle agents, I can
say from experience that it's probably the right thing to do - the newer
agents are easier to work with. Post 7.3 that is.
Once you create events or jobs, you should remember whenever you do work on
those databases or befo
Thanks for the reply but if that is all you have to offer please keep it to
yourself.
-Original Message-
Sent: Thursday, August 02, 2001 5:14 PM
To: Multiple recipients of list ORACLE-L
By loosing a gig or two of information.
> -Original Message-
> From: Cale, Rick T (Richard)
ROFL - rolling on the floor laughing
I believe there actually is a web site somewhere that keeps track of these
acronyms.
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
-Original Message-
From: Babette Turner-Underwood [SMTP:[EMAIL PROTECTED]]
Sent:
Title: RE: Unix terminal question
You can also do a "last |more"
Kevin Naik
-Original Message-
From: Aldi Barco [mailto:[EMAIL PROTECTED]]
Sent: 03 August, 2001 00:52
To: Multiple recipients of list ORACLE-L
Subject: Unix terminal question
Hi List,
I have turned on the datab
This Is a simple one: BTW-bye the way.
I visited www.acronymfinder.com. Here is something I wanted to share.
/SOS [not an acronym] a common misconception is that SOS means Save Our
Ship/Souls (a distress call); the letters don't actually stand for
anything./
I always wanted to know what SOS r
For those interested
A site containing acronyms
http://www.sharpened.net/glossary/acronyms.php
http://www.magicpub.com/netprimer/acronyms.html
http://www.kellywebworks.com/acronyms.htm
Rick
-Original Message-
Sent: Friday, August 03, 2001 7:56 AM
To: Multiple recipients of list ORACLE-L
did you do a:
set -o vi
>>> [EMAIL PROTECTED] 08/03/01 03:00AM >>>
I'm using ksh. From the Unix prompt I do history which displays the last
170 commands I did.
I would like to re-run #55 in the list (which happens to be a rm with a lot
of arguments). How do I do it?
I tried doing ESC-K t
Hope This Helps
>From: "Michael" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: completely off-topic question...
>Date: Thu, 02 Aug 2001 19:45:33 -0800
>
>...which means it's probably going to start a great big thread :)
>
now i thought it meant 'Same Old Sh*t' or what we would have for breakfast in the corp
'Sh*t on Shingle' :)
>>> [EMAIL PROTECTED] 08/03/01 08:51AM >>>
This Is a simple one: BTW-bye the way.
I visited www.acronymfinder.com. Here is something I wanted to share.
/SOS [not an acronym] a common m
I highly believe SOS means save our soul.
That sites gives no reasoning behind their claim, no one just picks letters
for no reasoning.
"Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes."
Christopher R
That's right Babette, tell all my secrets to the world :)
I always sit in the front row (or as close to the front as I can) at my
friends presentations. Usually you can only really see the first few rows in
those rooms, so this way there is a guarantee of a friendly face to present
to.
Speaki
WOW, now I feel like slacker:)
KK
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Friday, August 03, 2001 7:51 AM
> Cheers Lee!
>
> Out of curiosity how old did you think I was? I was actually turned down
for
> cigarettes a few months back!! I coul
Thanx for valueble information.It's working fine now.
Regards,
Anand.
-Original Message-
[EMAIL PROTECTED]
Sent: Thursday, August 02, 2001 7:00 AM
To: Multiple recipients of list ORACLE-L
If you're on NT/2000 you'll have to edit the registry, make sure you're not
using terminal servic
I had a VIC-20 with a TTY terminal emulator and a 300 buad modem that I
used to access IBM mainframes from home (so I wouldn't have to drive 20
miles on a Saturday). The company found out that I was using my own
equiptment to access their computers and "loaned" me a TI Silent 700 to use
instead.
Rick,
One way of doing this is:
Add a new column to the table with a type of Varchar2.
Write a PL/SQL routine to convert the long to a varchar2. You can do this
simply by assigning the long data type to a varchar2 variable:
create table tomtest(col1 long, col2 varchar2(100));
1 declare
2
now we are talking, honeymooners, benny hill, outer limits, and my favorite twilight
zone.
>>> [EMAIL PROTECTED] 08/03/01 09:00AM >>>
It look likes there are more of us older folks than one might think. And I
loved Bullwinkle, Davy Crockett and Red Skelton and Danny Kaye movies. My
husband is
Gene.
Are you a JARHEAD too!. USMC "Unlimited S### and Mass Confision" or
"Uncle Sam's Misguided Children"
ROR mª¿ªm
>>> [EMAIL PROTECTED] 08/03/01 09:40AM >>>
now i thought it meant 'Same Old Sh*t' or what we would have for breakfast in the corp
'Sh*t on Shingle' :)
--
Please see the offici
No, Srini,
It's not friday, simply there is no view like this...
Check Metalink Note:132629.1, this may help if you do really want all locks.
HTH
Vadim Gorbounov
Oracle DBA
-Original Message-
Sent: Thursday, August 02, 2001 7:43 PM
To: Multiple recipients of list ORACLE-L
Folks,
How
Well, I do remember enough Morse code to say that SOS is "dit-dit-dit,
dah-dah-dah, dit-dit-dit". It's very easy to remember and recognize.
There was a universal distress signal before that (1912 - HMS Titanic was
the first ship to send an SOS) but I don't remember what it was. It was
changed to
Another book to add to my "wish list", dang I need to retire RIGHT NOW
and start reading. Good thing I read fast. Now if they would just stop
publishing new books, so I could catch up :)
>From: "Adams, Matthew (GEA, 088130)" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple r
Or the now famous SSDD.
-Original Message-
Sent: Friday, 03 August 2001 14:41
To: Multiple recipients of list ORACLE-L
now i thought it meant 'Same Old Sh*t' or what we would have for breakfast
in the corp 'Sh*t on Shingle' :)
>>> [EMAIL PROTECTED] 08/03/01 08:51AM >>>
This Is a simple
Go for it.
30 years from now your graduates will be on this list bragging about how
they started and bragging about how thier first server only had 1G of RAM.
[EMAIL PROTECTED]
AH SO, we go back to the idea of BIF & AIF files again?? Sound like old Oracle
4 idea!! Oracle into re-cycling too then!! :)
Dick Goulet
Reply Separator
Author: "Deshpande; Kirti" <[EMAIL PROTECTED]>
Date: 8/2/2001 1:14 PM
With 9i, we have a choi
I got one, but I am sure it will be answered in no time. Does anyone know
where the terms "ok" and "going the whole nine yards" came from. Right now
I am a little shady on the ok, but I will remember it soon:)
KK
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROT
Out of the night, when the full moon is bright, rides a horse man is known
as Zorro!
Did you happen to catch the recent Zorro movie?
Ruth
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, August 03, 2001 9:35 AM
Or Zorro, or My Friend Fli
Hmmm
SQL> select to_char(sysdate,'SSDD') from dual;
TO_C
3903
: )
Brian
--
--
| Brian McGraw -- Oracle DBA |
| Central Alabama Oracle Users Group |
||
| mailto:[EMAIL PROTECTED] |
| http://bmcgraw.home
Kevin,
Have you actually done this?
I have a test copy of the database now and have been testing this.
I successfully created a locally partitioned index and then tried
to add the primary key constraint to the same table using the same
columns (in the same order) as the index was created using
The whole nine yards comes from the length of the ammo belts used on machine
guns. If you fired all of the ammo is was the 'whole nine yards'. I don't
know where OK comes from.
Ruth
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, August 0
Some of us remember Elvis on Ed Sullivan.Ruth
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, August 03, 2001 9:46 AM
>-That ran the same time a "bullwinkle". How about Fess Parker as Davy
>-Crocket. Or Red Skelton's show with Freddy
Can someone tell me how to find the support matrix on Metalink for Oracle 8,
all versions?
-Original Message-
Sent: Friday, August 03, 2001 9:16 AM
To: Multiple recipients of list ORACLE-L
Out of the night, when the full moon is bright, rides a horse man is known
as Zorro!
Did you happ
Cherie,
I handle it a bit differently.
Here is what I have been using with no problems.
ALTER TABLE DBM.CUST_CATEGORY_TOTALS
ADD CONSTRAINT CUSTCT_PK PRIMARY KEY
(
DIR_PUB_YR, <- This is partitioning key for the table partitions
DIR_NUM,
CUST_ID,
ITEM_TYPE
To add to this thread, you can make it only return the second record by changing
the statement to:
select table_name from dba_tables
where table_name like 'EDL\_WORK\_%' escape '\';
This will force the _ character to be used as a literal.
Yosi Greenfield wrote:
> Darren,
>
> Just as the % char
SOS - scatter or suffocate
-Original Message-
Sent: Friday, August 03, 2001 8:51 AM
To: Multiple recipients of list ORACLE-L
This Is a simple one: BTW-bye the way.
I visited www.acronymfinder.com. Here is something I wanted to share.
/SOS [not an acronym] a common misconception is t
I have oracle 8.1.7.1b running on redhat linux 6.2. Every time I start the
oms with 'oemctrl start oms' at the command line, I get multiple jre
process running ( around 60 of them). Does anyone have a remedy for this?
Thanks,
Barry Stubbs
Windham School District
--
Please see the official OR
Would appreciate feedback, good or bad, from those on the list using
Precise/Pulse and Precise/SQL. From those who "looked" at it but did not go
for it, why not?
Sean :)
Rookie Data Base Administrator
Oracle 7.3.3, 8.0.5, 8.1.7 - NT, W2K
[0%] OCP Oracle8i DBA
[0%] OCP Oracle9i DBA
within protocol.ora
tcp.excluded_nodes=(a.b.c.d, w.x.y.z, clientA.mydomain.com)
HTH & YMMV!
Xiaohong Yang wrote:
>
> Hi Gurus,
>
> I would like to get your recommendation for connection restriction to the
> databases via tcp/ip based on ip addresses. The restriction is required
> for only th
Night Gallery!
-Original Message-
Sent: Friday, August 03, 2001 8:58 AM
To: Multiple recipients of list ORACLE-L
now we are talking, honeymooners, benny hill, outer limits, and my favorite
twilight zone.
>>> [EMAIL PROTECTED] 08/03/01 09:00AM >>>
It look likes there are more of us olde
W-H-A-T.T-H-E.F-U.
is probably what the captain shouted at the top of his voice
-Original Message-
Sent: 03 August 2001 15:36
To: Multiple recipients of list ORACLE-L
Well, I do remember enough Morse code to say that SOS is "dit-dit-dit,
dah-dah-dah, dit-dit-dit". It's very
But Kevin, having all under his belt doesn't mean he's ever used it. Maybe
we're not slackers afterall.
Ruth
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Friday, August 03, 2001 10:15 AM
> WOW, now I feel like slacker:)
> KK
> - Original
"everything old is new again"
it's called nostalgia, and retro :)
>From: [EMAIL PROTECTED]
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: Re:RE: 9i
>Date: Fri, 03 Aug 2001 06:28:12 -0800
>
>AH SO, we go back to the idea of BIF & AIF files ag
SOS were picked because they are easy to send and understand in Morse code
even by people who do not "know" Morse code.
Brian Norrell
Manager, MPI Development
QuadraMed
511 E John Carpenter Frwy, Su 500
Irving, TX 75062
(972) 831-6600
-Original Message-
Sent: Friday, August 03, 2001 8:4
To avoid this problem on cleaning Registry what I do know (after painful
rebuilds of machines) is before I install any new Oracle Software, I export
(Backup) the oracle key from the registry and save it with a proper description
i.e.. Reg_before_9iAS, then I proceed to do the installs etc. etc.
If
With Sean Connery, Antonio Banderas & Katherine Zeta-Jones?
It was fun, but pretty predictable. Antonio & Katherine together was fun to
watch. The sword fight was cute.
"Did you happen to catch the recent Zorro movie?"
Tom Mercadante
Oracle Certified Professional
-Original Message-
Its not a bad Idea but I was trying to get away from specifying any fields
at all in the insert so that there are no changes if we add fields to the
table.
If I
Insert into table1 as select
decode(key_field,old_value,new_value,old_value), field2, field3 from table1
where old_value = 1;
Then I
Title: RE: computer history stories - Now: Age discrimination?
okay fellow geezershaven't you adopted the "I'm only 29" phrase yet?
It also gets you alot of 30th birthday parties where you can continue to claim 29, just have to change jobs alot.
Jon
-Original Message-
From
Title: RE: completely off-topic question...
Check
your math:
.311 * 250
inches = 77.75 INCHES, = 2.15
yards.
That is for the projectile alone. The cartridge
is larger than that, plus a sizable gap between them could conceivably get you
to 9.
Brian Norrell Manager, MPI Development QuadraMed
Is anyone out there using advanced queuing for replication?
Dave
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: David Turner
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet
List,
I am looking for a position as an Oracle DBA with Sys Admin knowledge in the
Jacksonville - Orlanda Florida area. Does anybody have any contact information for
openings. The headhunters have been sharing the postings for the past 3 - 6 months and
nothing new has appeared.
I would great
While Running a Set of BATCH Processing JOBs , Archived Redo of 11 GB is
being Generated over a 6 Hours Run on a E6500 Server .
NOTE - The batch jobs are DML intensive in nature indeed .
Online Redo Logfile Size = 175 MB
LOG_CHECKPOINT_INTERVAL= 40
Qs Is there any way to know whether this R
Dave,
Oracle's Advanced Replication uses AQ as the
propagation mechanism for asynchronous parallel
propagation (serial and synchronous use the two-phase
commit process). Or are you asking if anyone has
written their own custom replication using AQ?
HTH,
-- Anita
--- David Turner <[EMAIL PROTE
I'm 34 with a 10 and 11 year old, and recently a -6 month old, and I
sure feel old sometimes.
But in this discussion, I guess I'm a teen.
BLA
> -Original Message-
> From: Ron Rogers [mailto:[EMAIL PROTECTED]]
> Sent: Friday, August 03, 2001 12:47 PM
> To: Multiple recipients of list ORA
oh yeah. you guys know that they published a book of the Fractured Fairy
Tales? Yes, I have it. You had to ask?
>From: [EMAIL PROTECTED]
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: OT -- suggestions to ensure nerdiness in potenti
High School ('70), I took a computer class -- we used a Hewlett Packard
9100B -- it was the size of a typewriter, had a memory that could hold
14x14 instructions. Just enough space to write a tic-tac-toe program. The
smallest HP calculator today has infinitely more power that than thing did.
"Fractured Fairy Tales" was a PART of the "Rocky and Bullwinkle Show", as
well as
"There's no need to fear, UnderDog is Here!" - the Underdog Show.
"Nor plane nor bird nor even fog, it's just little old me, Underdog".
-Original Message-
Sent: Thursday, August 02, 2001 3:04 PM
To: Multip
I didn't see my first color tv until 1978, when I bought one as an
engagement present for my fiance.
I always did wonder what all the fuss was about The Wizard of Oz before that
:)
>From: "Farnsworth, Dave" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORAC
The sad thing is, it really didn't matter back then! Character mode coming
back to a orange or green monitor (at least on the Compaq), it didn't do too
bad keeping up with typing. Or so it seemed, until the next boost came out
then woohoo! look how fast I can go! Now if I'm not on cable or a T
It's so much nicer for kids and college students alike today. Think of how
awesome the computers are that they are getting(and were talking pc's nto
servers). I love it now, I could build a sweet AMD machine for so cheap
it's disgusting and sad, but pleasantly wonderful at the same time.
I know
very well carry on:(
-Original Message-
Carmichael
Sent: Thursday, August 02, 2001 3:45 PM
To: Multiple recipients of list ORACLE-L
young whippersnapper! quiet down and let us old fogies reminisce :)
>From: "Kevin Kostyszyn" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multi
dewd,
to me grits is something you eat with poke salad, black eye peas and
okra!
during part of my wasted youth i lived in a cowboy shack on a ranch
in the northern sierra nevada (plumas county, gennessee valley). tin
roof, uninsulated walls/floor, cold water in winter, a small wood
burning
No, it's not possible - use 'before' trigger.
I think, I read you can use function as default in
9i.
Igor Neyman, OCP DBAPerceptron, Inc.(734)414-4627[EMAIL PROTECTED]
- Original Message -
From:
Harvinder Singh
To: Multiple recipients of list ORACLE-L
Sent: Friday
Methuselah's Children
>From: "Vergara, Michael (TEM)" <[EMAIL PROTECTED]>
>Reply-To: [EMAIL PROTECTED]
>To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
>Subject: RE: completely off-topic question...
>Date: Fri, 03 Aug 2001 11:32:47 -0800
>
>...and...oh PIQQ...I can't remember the na
Cherie,
I may be completely wrong on this, but I seem to remember my Intro to
SQL instructor at Oracle Ed telling the class that a MS SQL inner join
was the same as just a normal join in Oracle.
HTH (List please correct me if I'm wrong)
Rodd
On 03 Aug 2001 09:10:42 -0800, [EMAIL PROTECTED] wrot
My apologies to the entire list for these last two messages
I meant to send them to Rachel personally and I forgot that
since the listserv changed a while ago I cannot hit "reply"
(Need to open e-mail, right click properties in the title and get
the address)
go ahead and flame me all you want, .
I joined the USN in 1966 to avoid the draft.
I got sent to Data Systems Technician school for computer training.
We used a Univac CADET (Can't Add & Doesn't Even Try); which used
a lookup matrix in place of real adder logic. It had 4K worth of
18 bit word magnetic core RAM. The programs were enter
Doh! Never mind. I just discovered how to use the scroll bar on my browser
;-)
(I was looking under one of the main all day events and not under the
general section)
- Babette
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Babette Turner-Underwood
INET: [EMAIL PROT
>
> > 3) What company made the first "Portable" (luggable) computers?
> It was either Kaypro or Osborne. The Ozzy had a little tiny 40-column
> screen and dual 5.25" floppies. The Kaypro had an 80-column screen
> and dual floppies.
>
I had a compaq 'portable' that was the size of an old, big, n
Joe,
That's true, but only if the current logs are not
needed for instance or media recovery.
For example if you want to open from a cold backup and
you don't have the online logs you can fake recovery
and then open resetlogs and it will recreate them for
you:
startup mount
recover database u
Title: RE: OT -- suggestions to ensure nerdiness in potential IT staff
Famous...I hope at least recognized by my deeds. It's funny this is coming up, I am currently in the middle of starting a dream of mine.
Basically I am starting a non profit organization designed to teach these hot in de
Lyuda,
You didn't say if you have other disk space available or not. If you do I would create
the index/indexes tablespace/s on different drives then drop them from the original
location. After you get breathing room you can reorg the database to a more
comfortable setup. When you have removed
Ben,
You could test this yourself in about a minute. I don't have a db in front
of me, but I'm pretty sure the truncate, or any ddl operation, will fail
telling you it couldn't get a nowait lock.
Try it. Create a table, say t (a varchar2(1)); Then, insert into t ('x');
Then insert into t select
Since I don't think this got a usable reply on list it came from and
it sounds like some people on this list had a Kaypro, I decided to see
if we are geeky enough that someone has an answer. The closest I got
to finding a solution at the time was someone who said it sounded
familiar - didn't have
computer trivia from the pre-PC days:
"what computer company had the first huge marketing success
advertising its word processing system on TV during the
Superbowl football game?"
--
> From: "Boivin, Patrice J" <[EMAIL PROTECTED]>
> Date: Wed, 01 Aug 2001 16:20:48
It's an optional either/or thing Kevin.
Alchohol induced?
I dunno, anything you wanna tell us? ;)
Jared
On Thursday 02 August 2001 12:55, Kevin Kostyszyn wrote:
> Uhhh...I thought that 9i wasn't going to be using rollback segments
> anymore? Am I wrong, was this alcohol induced dream or som
Hi List,
I have turned on the database audit and found that
someone from terminal pts/1 deleted a record yesterday.
How to know in Unix (Solaris) who (osuser and workstation) was login using
pts/1 yesterday ?
Or also can we find it from oracle audit (sys.aud$, etc) ?
Tia for any clue.
Aldi
___
You mean that they didn't have PCs, internet, MS Windows and Night Show
with Ed Sullivan back there at Alamo? What in the world has prompted Santa
Anna
to attack, then?
> -Original Message-
> From: Terry Ball [mailto:[EMAIL PROTECTED]]
> Sent: Friday, August 03, 2001 1:36 PM
> To: Mu
Hi Lyuda
This is not a nice situation to bee in, but the god new is that oracle can help
you since you are using version 8.1.6 !
You can use the "ALTER INDEX REBUILD TABLESPACE
;" to move the index to a new tablespace and this can even
be don online with "ALTER INDEX REBUILD ONLINE TABLESPACE
Fractured Fairy Tales and "Mr. Peabody and Sherman" on Bullwinkle.
-Original Message-
Sent: Thursday, August 02, 2001 1:12 PM
To: Multiple recipients of list ORACLE-L
Okay, who remembers "Fractured Fairy Tales" and the Professor and his boy
Sherman?
>From: "Farnsworth, Dave" <[EMAIL
I can't really tell if no more answers are coming in or things are
just very slow but I'll try to fill in the answers to my questions
that have not been answered.
Looks like the questions about the floppy drive (or should I say
drives as I had the luxury of dual drives) are the ones that need som
Paul;
There are a lot more of us around than the youngsters like to acknowledge
.
My first and only programming course was at Texas A&M University, a
fortran course where we had to do our programs on Punch Cards everything
else is self taught. I got my Degrees in Nuclear Engineering a
Lyuda;
1. Create a new tablespace for the indexes on a seperate drive. Make sure
you do this with a much more reasonable datafile size. (Watch it here
maybe they did the big size because they were running out of possible files
-- see the max_datafiles parm on the Create Database command)
On Thu, 2 Aug 2001,Rachel Carmichael scribbled on the wall in glitter crayon:
->oh yeah. you guys know that they published a book of the Fractured Fairy
->Tales? Yes, I have it. You had to ask?
yes and no, i expected it.;-)
--
Bill "Shrek" Thater ORACLE DBA
Telergy,Inc.
>From what I read, Oracle9i supports rollback segments if you
want to use them. Using them is now referred to as manual
undo management. You also have the option of using an "undo
tablespace", which is referred to as automatic undo
management. I think you need to use undo tablespaces if you
wish t
Can you insert an entire record into a table without having to specify each
individual field ??
I need to copy multiple rows in a table after I have modified its key. I do
not want to have to specify each field. Is there a way just to select the
record, modify the particular field, and then in
"Oracle wanted a consolidated infrasture...some
junk..and Oracle chose HP"
is flashing in Oracle website (www.oramag.com)
Looks like oracle-sun honeymoon is over.. any one has
more info what happened behind the doors?
=
Have a nice day !!
-
I taught a high school class to program Turbo Pascal running on CP/M.
Now that was a program.
There was one kid in the class who knew way more about this stuff than I
did.
They all got As.
>
> If I remember correctly, Microsoft bought QDOS from Seattle Computer Works
> for around $50k so they
Folks,
How can I determine rowids of rows locked by a given SID using V$ or DBA*
or X$ views ? Can't think anymore today :-)
DB Version is 8.1.6.
TIA
Srini Chavali
Oracle DBA
Cummins Inc
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat
Hi Friends
When Iam starting my Enterprise Manger console, Its asking Oracle Management
server??? What is that?? I tried with giving host name, But it did't work??
How to connect my EPM??
Thanks
Raghu.
_
Get your FREE download
I just started looking into Advanced Queues and I'm wondering what types
of apps they're used for? What would be their biggest advantage?
Dave Turner
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: David Turner
INET: [EMAIL PROTECTED]
Fat City Network Services
And this 300/1200 Boud rate modems were without error correction mode
resulting lot of garbage in between specially working from subcontinent to
dialin in UK or USA machines...Same modems were working well if worked
within USA or UKThat was 1990-91 era
MOHAMMAD RAFIQ
Reply-To: [EMAI
Helen:
How about a select statement that will do it for
you instead of all the looping? Does this work?
select
asset_num , decode(min(num), 1,
'DHI', 2, 'AHI', 3, 'CHI', '???') as company_id from
(select asset_num
,
decode(company_id, 'DHI', 1, 'AHI',2, 'CHI',
Thank you everyone who replied. All suggestions were very helpful. I am
bebuilding my indexes in a different tablespace. It runs very very slow..
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, August 02, 2001 3:51 PM
> Lyuda;
> 1.
...which means it's probably going to start a great
big thread :)
I see a lot of emails with HTH on them, seemingly
some sort of way to say "thankyou" or something... as they're always at the end
of somebodies message right before they sign off their name..
I have pondered, and pondered
1 - 100 of 165 matches
Mail list logo