Solaris 7
-Message d'origine-
De : Henry Poras [mailto:[EMAIL PROTECTED]]
Envoy : lundi 26 mars 2001 17:58
: Multiple recipients of list ORACLE-L
Objet : RE: ORA-27101: shared memory realm does not exist
What is the OS?
-Original Message-
Sent: Monday, March 26, 2001 10:41 AM
Charlie Mengler wrote:
Solaris V2.6 Oracle V8.1.8
v8.1.8???
what what what?
I gots to get me one of dem dere sOlariz b0xen to get me up on dem gnu
releazes.
thinking that 8.1.7.0.2 on NT is the latest and greatest ...
Pd
PTDBAFB
part-time dba fh
--
Please see the official ORACLE-L
Issue "set role none" and then see if you can do it in
SQL Plus. This mimics the privs that you have within
a procedure - ie roles are not activated. You
probably need the 'create table' priv granted directly
(or select on the one you're reading from)
hth
connor
--- Charlie Mengler [EMAIL
Lee,
Thanks for your advise, for me this question is just kick off to the world
of ORACLE PL/SQL scripting,
I don't know why you think that I would like to ask from a Great and full of
experiance DBA like you Mr. Lee to spoon feeding me.
Again Thank You so much for your advise
Xing,
Look for "log buffer waits" in v$system_event. You'll
always get a few around a log switch, but if you're
got heaps, then you're log buffer may a little small -
or your log files too slow...
The alert log is a good place to check for log file
sizing - a commonly accepted rule of thumb is log
Lisa/List,
when we restore a datafile from a backup, oracle will check the change# in
the header of the datafile
and will try to match it with the one in the controlfile, correct ? that's
how oracle will know that the file
is out-of-sync, now oracle will prompt from the change# as well as the
Eh ???
I don't think there is any call for that. I told you whereabouts in the doc
set the manuals were and suggested that you look there.
I am certainly not a "Great and full of experience DBA" as you suggest but
was merely passing on what experience I do have whilst coming across a
similar
Anyone who can give me a link to a website, where I can see the description
of the Ora-errors I get in sql statements and pl/sql-code, so I understand what the
error is about and how to fix it.
Roland Skldblom
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
Hi Waleed,
Perhaps the best thing to do is to go to http://technet.oracle.com and then do
a search on "9i". You should get loads of pages back, but these are very
fluid, changing regularly. I've just done a search like this, and three you
may be interested in that came back were:
=
Hate to out a dampener on all of this but the guy could be blind.
-Original Message-
Sent: 29 March 2001 11:50
To: Multiple recipients of list ORACLE-L
You know he could be listening to it in his sleep too! Sub-conscious levels
and all that..
-Original Message-
Ghosalkar
Following is a script that will compare differences within a schema. If this
is too much, just edit out the table comparison scripts.
HTH
Mark
-
col table_name format a30
col column_nameformat a30
col medph2_format format a30
col med_test_formatformat
You know he could be listening to it in his sleep too! Sub-conscious levels
and all that..
-Original Message-
Ghosalkar
Sent: Thursday, March 29, 2001 04:45
To: Multiple recipients of list ORACLE-L
try
1. get one of those text to voice tools from download.com
2. next keep a tape
Hi !
Welcome to the world of DBAs. And you have got some
good suggestions too..
This mailing list a good place to ask questions (and
get answers). Read Kevin Loney and Rama Velpuri. The
titles are
Oracle 8i DBA Handbook and Oracle 8i Backup and
recovery hand book. Religiously try all the
From the command line do oerr prefix code error number
eg
For an Oracle error
# oerr ora 1658
01658, 0, "unable to create INITIAL extent for segment in tablespace %s"
// *Cause: Failed to find sufficient contiguous space to allocate INITIAL/
/ extent for segment being created.
There is a set of cd's that come with Oracle enterprise edition.
I think irs called Orale 8i client online Documentation cd.
It has all the error messages on it.
Thanks
Clint
-Original Message-
Sent: Thursday, March 29, 2001 12:20 PM
To: Multiple recipients of list ORACLE-L
Anyone
- Original Message -
To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED]
Sent: Thursday, March 29, 2001 13:20
Anyone who can give me a link to a website, where I can see the
description
of the Ora-errors I get in sql statements and pl/sql-code, so I
understand what the
Any suggestions for a particular product?
-Original Message-
Sent: Wednesday, March 28, 2001 06:16
To: Multiple recipients of list ORACLE-L
Mark,
I might suggest that you look into a "Ghost" product for making an image of
your PC. I "ghost" my pc and keep the image on the network
Install oracle documentation, there you can find explanations for all error
messages.
Regards
Volker Schn
E-Mail: mailto:[EMAIL PROTECTED]
http://www.inplan.de
-Ursprngliche Nachricht-
Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Gesendet: Donnerstag, 29. Mrz 2001 12:20
An:
I have a manual in the form of a pdf that has all the Oracle messages in it,
though I can't find the link on the technet documentation area for it at the
moment? If you want me to send it over by email away from the list, let me
know, as it's around 6.5 mb.
HTH
Mark
-Original Message-
Jeff,
We are using a Compaq SAN. It was running great for two months. Just last week we
began having some issues with databases hanging on our cluster. We haven't nailed
down the problem yet, so I am witholding my opinion.
Jay Hostetter
Oracle DBA
D. E. Communications
Ephrata, PA
Lee, i'm with you 200%,
oh and for the original addressee(and others) if you can't figure out
what the heck that simple pl/sql block is doing(or where to figure it
out), then quit diluting the OCP worthiness, people who study just to
take the OCP and have no experience just go to further the
You can also do it from UNIX prompt (if you have instaled Oracle
documentation):
$ oerr ora number_of_error
Sonja
-Original Message-
Sent: Thursday, March 29, 2001 12:56 PM
To: Multiple recipients of list ORACLE-L
There is a set of cd's that come with Oracle enterprise
I just migrated my database that supports Des/2000 version 2.1 from
7.3.4 to 8.1.5. I did not upgrade Designer and don't plan to at this
time.
Due to lack of any specific documentation anywhere on how to migrate
this database, I simply created a brand new database of the same
name on a
technet.oracle.com
there is an entire doc manual devoted to the error codes
well, except for PL/SQL... there you are on your own, there is no good
debugger for that as far as I know.
From: [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL
Mike,
If that's the worst you guys/gals call me I'll be extremely flattered. Over
the years I've had names tossed at me that are not normally usable in impolite
society! :-)
Dick Goulet
Reply Separator
Author: "Lanteigne; Mike" [EMAIL PROTECTED]
ooh goodie, now I don't have to do my OCP rant, you've done it for me :)
Joe, tell us how you REALLY feel, okay?
From: "Joseph S. Testa" [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: OT: RANT ABOUT OCP, Re: Small help
Date:
You may be running into a limitation of HP-UX that can cause this problem. In
HP-UX during any one time slice the SO will return a MAX of 32K of data from
disk. This does take a little thought to understand. The OS is multitasking
between all of the processes. To do so it breaks time up into
We are running an oracle database 8i, we have several Ms Access
applications connected by ODBC to this database. The database is very complex ,in
total about 300 tables and of course PL/SQL procedures We also have many different
schemas in this database. But we have a big problem, when we
I believe that it gets the log sequence number by comparing the change# to
the change# in the
v$log_history table.
Nancy
-Original Message-
Sent: Thursday, March 29, 2001 3:19 AM
To: Multiple recipients of list ORACLE-L
Lisa/List,
when we restore a datafile from a backup, oracle will
Anybody can give me a name for Performance Tuning book, my knowledge is
low and I am not dealing with Performance issue at my work. I am responsible
for backup and recover stuff. Now I think, I should update my knowledge on
Performance and Tuning.
Mark,
Not to plug a particuler product when there could be many alike products available.
We have a registered version of Ghost by Norton, Symantic Corp. I believe that there
is a trial version available at their site. It is simple, and easy to run. I prefer to
run it from a boot disk without
In /etc you should have an oratab file. It should look like this:
# oracle notes and stuff
#
# The line below with the * instead of a sid is for use with tools such as
# OEM and Orasoft. It can be used in scripts for setting the environment
# like the one shown below.
Anyone who's watched the list for a week will know me, no political
correctness here :) and thats probably the only reason i am OCP, the company
i worked for at the time, paid for the tests and gave me a bonus to complete
them. :)
joe
From: "Thater, William" [EMAIL PROTECTED]
Reply-To:
Lee Joe,
While I do agree that is possible one should try to figure these things out,
and this really is a simple one, there does come a time when asking for help is
appropriate. In this case Lee's answer is very much so. As far as taking an
OCP course, that does torque my jaws. Over the
TC is (Thread Checkpoint) enqueue it is related with the global checkpoints.
It is used to signal the file checkpoint completion.
Thx
Gautam
-Original Message-
Sent: Tuesday, February 27, 2001 11:46 AM
To: Multiple recipients of list ORACLE-L
"Hagedorn, Linda" posted a message a few
shameless plug
get the book _Oracle DBA 101_ it has not only that kind of list, but
lots and lots of other good stuff. and you can always ask one of the
authors questions right here on the list.;-)
/shameless plug
did i do good rachel?;-)
Question for the authors here (offline
Hi,
Further to the mail sent , I couldn't find the right one in Download.com
can you help me, to download the same.
S.S
[EMAIL PROTECTED] 03/29/01 05:50AM
You know he could be listening to it in his sleep too! Sub-conscious levels
and all that..
-Original Message-
Ghosalkar
Sent:
Dick/Lee/Joe,
I'm not trying to defend him but unless I have not yet recieved
a post in my mail, Xing never said he had an OCP. Plus, Lee,
I think you may need to define "silver bullet". It probably doesn't
translate for people who don't use English as a second language.
Cherie Machler
Does nvl have any effect on indexes. In other words would it slow down a
query if you used the nvl function in the where clause on an indexed field.
i.e.
select *
from foo
where indexField nvl(xfoo,0);
Thanks,
Eric
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
"very complex" at 300 tables.
I checked on mine, excluding SYS and SYSTEM, I have 3185 tables. 159
database links. 1064 views, again excluding SYS and SYSTEM.
This is on Oracle 7.3.4.
I am sure this is not the smallest db out there...
(It's my birthday, so what if I feel a bit competitive
Oracle Performance Tuning, 2nd Edition
by Mark Gurry Peter Corrigan
Published by O'Reilly
ISBN 1-56592-237-9
Syed Ahmed wrote:
Anybody can give me a name for Performance Tuning book, my knowledge is
low and I am not dealing with Performance issue at my work. I am responsible
for backup
--- Apps Sol [EMAIL PROTECTED] wrote:
Is there any place where we can get Oracle books on Tape (Audio
tapes or CD's)
RK
I doubt it. From what I understand, audio books are primarily made from
best-selling fiction. What non-fiction audio books exist are probably
limited to stuff with the
Same with me.
And as budgets dwindled, I stopped after getting my 'shingle' for Ora8
(upgrade, that is)..
- Kirti
-Original Message-
From: Joseph Testa [SMTP:[EMAIL PROTECTED]]
Sent: Thursday, March 29, 2001 8:06 AM
To: Multiple recipients of list ORACLE-L
Subject: Re:
Xing,
Your OCP course may mention the script (depends which course you plan to
take), but they will only mention it quickly.
You can look it up in the Oracle administration manuals, or in the O'Reilly
Oracle Built-In Packages book.
Basically it generates statistics for the optimizer within a
Hi, Rahul,
Unfortunately, there is no v$view. v$log_history also isn't a good
candidate - v$log_history data are stored in the controlfile, and
controlfile loss would make database unrecoverable (we know, this is not the
case).
My assumption is Oracle stores checkpoint
We need to move a 700g Oracle DW from SGI IRIX64 (SGI's 64 bit unix) to AIX and upgrade it from 7.3.3 to 8.1.7 at the same time. Anyone got any suggestions on how to do this quickly? I'd rather only use exp/imp as a last resort because it'll be so slow.
One idea we've thought about is to:1. Backup
Well done Bill...nicely handled...gotta remember that one!
[EMAIL PROTECTED] 03/29/01 08:00AM
"Joseph S. Testa" wrote:
Lee, i'm with you 200%,
oh and for the original addressee(and others) if you can't figure out
what the heck that simple pl/sql block is doing(or where to figure it
I'll be the first to admit that sometimes I ask a question when I should
probably look up the answer, but is it just me, or do about half the
messages on the list seem like they could be answered in about 5 minutes by
typing the question into google or RTFM. I mean seriously, I was running
into
There is a list of good books at www.OracleTuning.com
"Syed Ahmed"
balkhi@hotmaTo:
I have been experiencing some packages that cannot be automatically handled by Oracle
when they become invalidated. Here's the scenario: We have package1 that calls
package2 which, in turn, calls package3. Under normal circumstances, if package3's
specification gets recompiled,
package1(?)
This might have worked better had you created a repository from scratch in your new
8.1.5 database, then exported/imported the application systems from your old
repository to your new one. This is how I would have done it.
[EMAIL PROTECTED] 03/29/01 08:00AM
I just migrated my database
Yeph.. see I am blind and at the same time I can type too.. can U read
this???
rk
- Original Message -
To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED]
Sent: Thursday, March 29, 2001 6:15 AM
Hate to out a dampener on all of this but the guy could be blind.
Hi, Gurus,
Can you give me an advice about a performance
book.
I want to buy a oracle performance tuning
book where scripts are available and like a handbook.
What is
the name and ISDN of this book?
Thanks
bunyamin
At 03:50 PM 3/28/01 -0800, you wrote:
RE: Standard vs Enterprise Edition
[growl] This is sort of off topic, but on the subject of "Enterprise Edition"s As you may remember, I've been doing comparisons between Oracle, SQLServer, and DB2, pricewise and otherwise. I asked for prices on
Happy Birthday Patrice!
Here you go:
SQL select object_type, count(*)
2 from dba_objects
3 where owner != 'SYS'
4 andowner != 'SYSTEM'
5 andowner != 'CTXSYS'
6 andowner != 'DBSNMP'
7 group by object_type;
OBJECT_TYPE COUNT(*)
--- --
Also, for Oracle 7 at least, the documentation is about 10,000 pages long,
that would take a lot of tapes.
Regards,
Patrice Boivin
Systems Analyst (Oracle DBA)
Bedford Institute of Oceanography
Fisheries and Oceans Canada
-Original Message-
From: dana
Sent: Thursday, March 29,
Chuck Hamilton wrote:
We need to move a 700g Oracle DW from SGI IRIX64 (SGI's 64 bit unix)
to AIX and upgrade it from 7.3.3 to 8.1.7 at the same time. Anyone got
any suggestions on how to do this quickly? I'd rather only use exp/imp
as a last resort because it'll be so slow.
ifn it was me,
Eric, Oracle won't use the index in this case. Instead have a function-based
index.
Prakash
-Original Message-
Sent: Thursday, March 29, 2001 9:43 AM
To: Multiple recipients of list ORACLE-L
Does nvl have any effect on indexes. In other words would it slow down a
query if you used
"very complex" at 300 tables.
I checked on mine, excluding SYS and SYSTEM, I have 3185 tables. 159
database links. 1064 views, again excluding SYS and SYSTEM.
This is on Oracle 7.3.4.
I am sure this is not the smallest db out there...
(It's my birthday, so what if I feel a bit
Winnie
thanks for ur reply.
I am doing online backup by following steps.Is this way is correct or
not.Please correct me.
1)Archive log list
2)alter system switch logfile;
3)alter database backup controlfile to trace;
4)ALter tablespace and copy all datafiles one by one.
5)alter system switch
Dear me - is it my job today to get sarcastic jibes thrown at me. Whose turn
is it tomorrow.
You said originally
Is there any place where we can get Oracle books on Tape
(Audio tapes or CD's)
RK
You could have been getting them for a blind colleague.
Oh sod it - why do I bother.
Cherie,
OK, point well taken, so "silver bullet" would translate into "the one item
that will succeed when no other does", "magic formula".
And, no he never did say he had an OCP, but he did say he was taking a "course"
to get his OCP. To me having an OCP certificate without any
My grand-boss thinks that conferences are a waste of money and training classes are a
much better dollar value.
I probably took my last Oracle Education class about 10 years ago and have been to
every ECO conference except last year (and because of personal conflicts cannot do ECO
again this
You can search the Oracle Documentation online at
http://www.oracletuning.com
"Boivin, Patrice
Surely there's a Reader's Digest Condensed Version
Or how about Cliff Notes?
[EMAIL PROTECTED] 03/29/01 10:45AM
Also, for Oracle 7 at least, the documentation is about 10,000 pages long,
that would take a lot of tapes.
Regards,
Patrice Boivin
Systems Analyst (Oracle DBA)
Bedford
I am compelled to tell you this story...
Many years ago I had a gold fish that had some sort of parasite on it...it was green.
My gold fish book actually had a remedy for this. Take the fish out of the water,
remove the parasite with tweezers, apply a small drop of mecurchrome(sp?), then
Well, assuming xfoo is a variable, this is not correct...the function is not being
used on the indexed field in this case, so the index WILL be used. If xfoo is a
column in the table, then I would expect a full table scan to be used.
[EMAIL PROTECTED] 03/29/01 11:16AM
Eric, Oracle won't
Sarah,
Unfortunately, you wouldn't get to go to ECO this year no matter what.
Oracle User Resource has decided to discontinue that conference. ECO is
dead.
Personal opinion:
training classes teach you exactly what the trainers want you to see/know. A
conference, while it does not give you
"Dasko, Dan" wrote:
OK, now I have to ask a question. How did you(general) break into the DBA
i walked into work one day and found this pile of books on my desk. i
said "what's this?" and they said "you're the new DBA and it's broke so
fix it now!" and i was a contractor at the time.;-)
I see that a lot. I am starting to put my foot down. I can't
even install one product because it insists on 8.1.5. So either
get me a version that runs with 8.1.7 or go home. I am tired of
having 6 versions of Oracle in this shop. OK 6 may be high.
I got 7.3.3, 8.0.5, 8.0.6, 8.1.5, 8.1.6,
Oracle Support never replied satisfactorly on this issue. What I have seen
it is a result of some corruption at dictionery level and as a last
resort they recommend to run catalog.ora file to rebuild dictionery and
compile all resultant invalid objects and then they will compile without
any
dunno any votes for my shortbread cookie recipe?
From: lerobe - Lee Robertson [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: Oracle Books on Audio Tapes
Date: Thu, 29 Mar 2001 08:06:24 -0800
Dear me - is it my job today
I annoyed my managers until they realized that there was really
no one else to do it and then they gave in. I was really lucky
in that I got to work on an excellent project with some very
experienced DBAs. Stayed there for a while and picked up tones of
experience.
-Original
Eeeww!
OK, I am now grossed out.
At 08:48 AM 3/29/01 -0800, you wrote:
I am compelled to tell you this story...
Many years ago I had a gold fish that had some sort of parasite on it...it
was green. My gold fish book actually had a remedy for this. Take the
fish out of the water,
Being Optically challenged is not a problem for some people. At my last employer there
was a sharp programmer that worked on a national level project and he was good. If you
never met the man you would not know that he was blind and used a guide dog to get
around in the different cities and
Rachel Carmichael wrote:
dunno any votes for my shortbread cookie recipe?
i move we have the godess' shortbread recipe! seconds?;-) and why do i
think it's not going to be good for my diet?;-)
--
Bill Thater Certifiable ORACLE DBA
Telergy, Inc [EMAIL PROTECTED]
RDBMS 7.3.2.3
I am running this under SQLPLUS
set transaction use rollback segment BIG_ROLLBACK
select c1, c2
from giant_poorly_indexed_table
where unindexed_colum='';
exit;
I end up with "snapshot too old" rollback segment RB_07.
Why won't it use the giant rollback segment I created
I'll stick my hand up :
-Original Message-
Carmichael
Sent: Thursday, March 29, 2001 06:06
To: Multiple recipients of list ORACLE-L
dunno any votes for my shortbread cookie recipe?
From: lerobe - Lee Robertson [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients
I'll second that one! What diet? Ruth
- Original Message -
To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED]
Sent: Thursday, March 29, 2001 12:38 PM
Rachel Carmichael wrote:
dunno any votes for my shortbread cookie recipe?
i move we have the godess'
I started out as a Pro*C developer and helped out our help desk on
rotation when our product was released. This was the help desk that fielded
all the questions that the administrators out at all the sites needed help
finding answers to...kinda like this list (well except that I couldn't pick
I think the big rollback segment needs to be private.
[EMAIL PROTECTED] 03/29/01 12:50PM
RDBMS 7.3.2.3
I am running this under SQLPLUS
set transaction use rollback segment BIG_ROLLBACK
select c1, c2
from giant_poorly_indexed_table
where unindexed_colum='';
exit;
I end up with
Check the IOUG-A sessions again. The presenters from Oracle were added
later, after IOUG and Oracle Corp. reached a new "understanding". I looked
at the sessions this morning and there are now Oracle presenters in the mix.
Dean Jefferson
Database Administrator
State of Wisconsin
Office of
Might want to have a chat with Recording for the Blind and Dyslexic. They
might have such books, or they might advise you on how to structure an audio
for this purpose. It's convenient that the docs come as small HTML files all
linked together -- a voice-activated PC might be able to handle this
Hi Guys,
Did anyone do an upgrade from oracle 8.0.6 to 8.1.7 version in a Sun
Solaris envrionment ?? Can you send me step by step procedure on how
to do it, I cant find any good documents on metalink.
Thanks!
Pallav Kalva
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
Is there a session that is likewise accessing that table? What may have been
blown was not your rollback segment, but the one where the other session was
putting it's uncommitted changes.
Dick Goulet
Reply Separator
Author: [EMAIL PROTECTED]
Date:
Being the cookie monster that I am, I must second the motion!
"Thater, William" wrote:
Rachel Carmichael wrote:
dunno any votes for my shortbread cookie recipe?
i move we have the godess' shortbread recipe! seconds?;-) and why do i
think it's not going to be good for my
I agree.
I heard somewhere that the person who can read but doesn't delivers the same
results as someone who can't read at all.
So it's what we do, not the skill set we have in our portfolio that matters.
People too often base their opinions on appearance, hearsay, or what a
person could do
Specifying a transaction rollback segment only controls to which RBS
rollback information will be written. The "snapshot too old" arises when
the DBMS tries to construct a read-consistent block of a table; it goes to
the RBS that received rollback for some transaction that changed it, only to
Can you send it through as a .wav file?
: )
-Original Message-
From: Thater, William [SMTP:[EMAIL PROTECTED]]
Sent: Thursday, March 29, 2001 1:39 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: OT -- Friday Recipe was: Oracle Books on Audio Tapes
Rachel
You can save the Excel file in comma delimited formated, CSV and use
sql*loader to put the data into the database. You can just ftp it from the
machine which has Excel to the server housing the database.
HTH,
Ruth
- Original Message -
To: "Multiple recipients of list ORACLE-L" [EMAIL
I think what Lee's objection was (I know when I read Xing's reply it
got my goat), that Xing critized Lee for giving him a referance to look
the answer up himself. I realize that it did not answer in full the
actual question, but it asked Xing to do a little work on his own. If
someone taking a
I do not think it matters whether it is private or public. The only
difference if public it accessible but all instances.
I would try doing a commit right before the SET TRANSACTION... command.
Rick
-Original Message-
From: Tim Sawmiller [SMTP:[EMAIL PROTECTED]]
Sent: Thursday, March
I have a Excel file.How to port the data to Oracle table.
I read some artical about using ODBC and things like that.But
I am not clear.
How can we generate a dat file delimited with comas so that I can
use SQlLOADer to port the data.
Thanks
Ravindra
--
Please see the official ORACLE-L FAQ:
Ruth Gramolini wrote:
I'll second that one! What diet? Ruth
the one that's supposed to make me skinny and solve all my problems.;-)
scarstic mode
just look at the TV, if you're skinny you're smart, everyone likes you,
you get dates with the people you want, and all your problems get solved
(with apologies to the Cookie Monster) Cki!!
I love shortbread, go for it
[EMAIL PROTECTED] 03/29/01 01:12PM
Can you send it through as a .wav file?
: )
-Original Message-
From: Thater, William [SMTP:[EMAIL PROTECTED]]
Sent: Thursday, March 29, 2001 1:39 PM
To:
selected web sites containing info on "computer access"
technologies for disabled (visually impaired) users:
--- Forwarded message follows ---
T o : O D T U G - D E V 2 K - L @ f a t c i t y . c o m
Date sent: Tue, 6 Mar 2001 14:13:43 -0800
(fwiw)
I think these are some of
Under your situation of select only statement there is no use of rollback
segment whether big or small. This error is a result of some other long
running job using that rollback segment. Please advise relevant developer
to check his code doing some delete,update,insert and intoduce some commit
Pallav,
Go to http://otn.oracle.com and get the Oracle8i Migration document under
"Documentation". That will provide you with what you need!
Ed Haskins
Oracle DBA
Verizon Wireless
-Original Message-
Sent: Thursday, March 29, 2001 1:21 PM
To: Multiple recipients of list ORACLE-L
OOOHH, that one. Well I guess I will have to be the fat stupid one because
I love shortbread. Bring it on!
Ruth
- Original Message -
To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED]
Sent: Thursday, March 29, 2001 1:21 PM
Ruth Gramolini wrote:
I'll second that one!
Where is the transaction?
Alex Hillman
-Original Message-
From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]]
Sent: Thursday, March 29, 2001 12:51 PM
To: Multiple recipients of list ORACLE-L
Subject:Set transaction does not work
1 - 100 of 173 matches
Mail list logo