Sorry, I don't have any example. However what I did when I had to was INSERT
/*+ APPEND */ select.
Regards.
-Mensaje original-
De: VIVEK_SHARMA [SMTP:[EMAIL PROTECTED]]
Enviado el: mircoles 14 de febrero de 2001 14:22
Para: '[EMAIL PROTECTED]'; '[EMAIL PROTECTED]'
Asunto:
[EMAIL PROTECTED] wrote:
Seriously, has anyone successfully used LogMiner for auditing
in a production database.
is this auditing, or just finger pointing? are your duhvelpoers just
trying to duck the blame?
--
Bill Thater Sr. ORACLE DBA
Telergy, Inc [EMAIL PROTECTED]
Hi guys gals,
Looking in to the system tablespace I have noticed that in 8.1.6, the SYSTEM
tablespace has a default PCTINCREASE of 50%, BUT OBJ$ has one specified of
0! Now, on 7.3.4 if "my" memory serves me right, this was also set to the
default of 50%.
My problem is that on a database
Would anyone know what this refers to?
I have a trace file with cryptic information in it, and can't make sense of
it.
I thought perhaps I could figure out what this is by looking in the Oracle
Internals book by O'Reilly, but no success. It does say that KS is a layer
used by the other layers
Dear all
!
Sorry for this
off-topic :
i have several
years of UNIX play-around experience .
I'd like to learn
some advanced UNIX , including system administration .
Can U please
advice on some free learning paths , web sources , etc ...
Please note that i
can
From within a stored procedure, if I was given a userid and password (as
parameters), is there any way to verify if this userid/password combination is
valid on my database? That is, can I do something like a "connect" within a
stored procedure or somehow use the encrypted password in the
and I totally love Cat (but then, I love all cats :) )
I am a huge Hitchhiker fan, as friends can attest (3 hour radio show on
tape, 6 hour show on tape, 3 hour VHS of the tv show, my business line
answering machine message.oh, and two of my cats are named Trillian and
Arthur) and 42
Try some of theses:
http://www.stokely.com/unix.sysadm.resources/index.html
http://spiral2.its.latrobe.edu.au/~ccam/sysadmin/sysadmin.html
http://www.samag.com/
http://www.ugu.com/sui/ugu/show?ugu
http://www.cyber-matrix.com/unix.htm
Good Luck!
--
Please see the official ORACLE-L FAQ:
I still watch the red dwarf episodes on BBC2 and while I was in Spain for 3
months, i was able to see it on BBC Prime by satelite.
I don't know all the persons by heart but i love the black guy who also
presents robot-wars ( another great program by the BBC ), it's david lister
i think.
any
Title: RE: Set Autotrace on
I understood it too.
But i need to do it with a simple user
...
How can I do it ?
Eriovaldo do Carmo AndriettaLimeira/SP - Brasil
- Original Message -
From:
Jacques Kilchoer
To: Multiple recipients of list ORACLE-L
Sent: Wednesday, February
Title: RE: Set Autotrace on
Hi friends :
How can I do for put the summary information in the
diagram model.
I wrote in the File / Summary
Information
but
i don´t know how put it in the
diagram.
thanks
Eriovaldo do Carmo AndriettaLimeira/SP - Brasil
- Original Message -
From:
What errors do you get?
Going on no other info, I'd say first thing is to check that the Oracle LIBs
and INCLUDES are in the MS VC path.
Dan
-Original Message-
Sent: Thursday, February 15, 2001 12:50 AM
To: Multiple recipients of list ORACLE-L
I have VC++ copy.Using which I'm able to
Mark Leith wrote:
I have only seen a couple of the Hitchhiker TV shows, but I have read the
book, and what a great one it is!! Pure genius in a backwards kinda way :)
What I wouldn't give to be sat in a restaurant at the end of the universe!!
check out _The Long Dark Tea time of the Soul_.
you can change the storage parameters. I had heard from oracle support that
you could edit the storage parameters (but nothing else!) in the sql.bsq
file before creating the database... so if you can edit it there, it stands
to reason (okay, sits, I'm tired this morning) that you can change
FWIW - I get very little SPAM to this, my work, email address
because I try hard to limit its exposure. Last night I got a
SPAM from a company that was hawking its web based OCP training
course. I'm not mentioning their name because I refuse to assist
spammer is gaining more visibility.
I'm
Now somebody has got WAY too much free time on their hands!!! Otherwise, pretty
cool. Thanks I needed that.
Dick Goulet
Reply Separator
Author: "Saurabh Sharma" [EMAIL PROTECTED]
Date: 2/14/2001 8:20 PM
this was fabulous..how could u do it.
pls
A little more info from the customer:
This was originally a 7.3.4 database which was MIGRATED to 8.1.6. The
decision was taken to export/import the full database. Before this was done,
it was copied over to become the "Training" database.
The storage parameters for OBJ$ and its sibling in it
HUMMM, Have you done this before? It would appear from your emails that you
have not. Anyway, Pro*C converts a source file containing embedded SQL
statements (typically with a file extension of .pc) into a C language source
file with the..c extension. You them have to compile the .c file using
Something like:
create table keys(
key_id char(8) primary key,
key_val raw(128) not null);
where key_id is rawtohex(the 32-bit key id) and key_val is the 1024bit
key... although it's technically feasable to generate duplicate key id's
(especially with this sample size) it's probably not good
I have only seen a couple of the Hitchhiker TV shows, but I have read the
book, and what a great one it is!! Pure genius in a backwards kinda way :)
What I wouldn't give to be sat in a restaurant at the end of the universe!!
-Original Message-
Carmichael
Sent: Thursday, February 15, 2001
Hello,
Look our homepage : www.anoto.com (Each pen will have a Key).
If we have 50 000 000 pen then we will have 50 000 000 keys.
50 000 000 pen is if map to 5% of the mobil phone owner in the world
Regards
Henrik
P.S If you need more info about our tech mail me directly ( It is not a
Viraj:
In your case, oracle8 should be a valid UNIX user who is also the owner of your
database. Is that true?
I do not know if I understand you. But I test this
su - oracle -c $ORACLE_HOME/bin/lsnrctl in my system. it worked fine without
asking password, instead it broght up the LSNRCTL prompt.
I too
have received this today, and thought it was from somewhere other than the list,
you have just confirmed this!
A
message has gone to their "Sales" team voicing my "humble" opinion
:)
Thanks
Dennis
Mark
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL
Message for magesh:
SELECT TRANSLATE(')81$!.;%-', '1234567890!@#$%^*()-=_+;,.',
'ABCDEFGHIJKLMNOPQRSTUVWXYZ ' )
from dual;
Thanks
Riyaj "Re-yas" Shamsudeen
Certified Oracle DBA
i2 technologies www.i2.com
use
select
lpad(object,254)||lpad(type,24)||lpad(sid,7)||lpad(owner,64)
from
blah blah
etc.
Dan
-Original Message-
Sent: Wednesday, February 14, 2001 8:25 PM
To: Multiple recipients of list ORACLE-L
statement - please help
The output looks like this if I did what I
I confess I'm not a heavy UTL_FILE user but I've never heard of anyone who
really enjoys it.
If you're using version 8.1 or later, I would seriously look at creating a
wrapper around some of Java's built-in I/O features. Read Steven
Feuerstein's article at
Yup, I'm also a Robot Wars fan as well. You cant beat a good bit of
wholesome mechanic violence!! Some of the things they build are weird and
many time wonderful!! Sir Kill-A-Lot has to be the most awesome robot built!
The black guys name is Craig Charles, and yeah it is Lister..
-Original
Viraj:
One more mention. To test su - oracle -c $ORACLE_HOME/bin/lsnrctl, you must be
a root user first.
|+---
|| "Viraj |
|| Luthra" |
|| viraj999@lyc|
|| os.com |
||
SELECT TRANSLATE('=5*;.3@5=5*', '1234567890!@#$%^*()-=_+;,.',
'ABCDEFGHIJKLMNOPQRSTUVWXYZ ' )
from dual;
-Original Message-
[EMAIL PROTECTED]
Sent: Thursday, February 15, 2001 03:16
To: Multiple recipients of list ORACLE-L
Message for magesh:
SELECT TRANSLATE(')81$!.;%-',
I would suggest that you start researching PKI
( public key infrastructure )
There is a *lot* of info available. Just use
your favorite search engine.
Also check out Oracle Advanced Security at
technet.oracle.com.
This is a very big subject.
What are you doing that you plan to have
It looks like this company has harvested addresses from this newsgroup in order to send out spam (my 'ismgr' address is only used on mailing lists and internally). If anyone else has gotten this, I hope you will send them an indication of your displeasure.
My policy (and I have the authority to
I
would say to much spare time on his hands:-)
-Original Message-From: Saurabh Sharma
[mailto:[EMAIL PROTECTED]]Sent: Wednesday, February 14, 2001 8:21
PMTo: Multiple recipients of list ORACLE-LSubject: Re:
Off Topic: Message for you
this was fabulous..how could u do
I think they look both the same, therefore, either should be just as fast,
but bear in mind, if you run proc.sql, then proc1.sql afterwards, it will
already be parsed, so proc1.sql will run marginally faster :)
(If they run at all :^) )
You would be much better off pasting the content of the
I've now moved away from sci-fi, to gripping action - Tom Clancy, and a hell
of a lot of the SAS guys books, that have come out over the past couple of
years - Andy McNab (Bravo Two Zero) amongst others, Johnny "Two Combs" Boat
Troop etc. and Chris Ryan (The One that got away) and again a few
Title: RE: ksedmp
Kernel Services Error DuMP or somesuch.
shows up in virtually all traces i have seen .
-Original Message-
From: Boivin, Patrice J [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 15, 2001 7:05 AM
To: Multiple recipients of list ORACLE-L
Subject: ksedmp
Mark,
Appology accepted ;-)
Some people flame me because they did not read my post
carefully. I said that for optimal performance the
number of extents with an 8K blocksize was 505. People
thought that was a maximum.
2147483645 is a theoritical limit. It's like the
maximum Oracle database
The HOST_NAME column of V$INSTANCE contains the machine where the database
is running.
Michael Armstead
Database Administrator, OCP-Certified
Corporate Finance Information Systems
Glaxo SmithKline
-Original Message-
From: bipin sahani [SMTP:[EMAIL PROTECTED]]
Sent: Thursday,
On Wed, 14 Feb 2001, Rachel Carmichael wrote:
Oh Jared, no.. Hitchhiker is way different (although also a Britcom)
Red Dwarf is total insanity... and it is on my PBS station on Friday nights
:)
Totally different, but the same insane wacky British humor. :)
Jared
--
Please see the
I have been given a choice. Let the DBA setup OEM and monitor the NT4
Servers we have Oracle 8.1.6 running on, or I can do all the monitoring
remotely using my preferred SNMP tools and MIBS. I do not know much about
Oracle. Which is going to be 'better'? We have our dev DB system to do
first,
SELECT TRANSLATE('5$%-78.1@*514;', '1234567890!@#$%^*()-=_+;,.',
'ABCDEFGHIJKLMNOPQRSTUVWXYZ ' )
from dual;
-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 2/15/01 10:55 AM
SELECT TRANSLATE('=5*;.3@5=5*', '1234567890!@#$%^*()-=_+;,.',
Hi,
Below is a mail that I had posted regarding LMTs and how many extents they
can track. As you can see from the mail, there is a maximum as to the number
of extents tracked and for 8K blocksize its 380928. I am not sure what
happens if you add more space after this.
Any thoughts will be
i personally don't get enough spam, and almost forgot
how to use the "del" key, so i was overwhelmed with
gratitude that they gave me the opportunity to practice
using the "del" key. :)
ep
On 15 Feb 2001, at 7:26, Dennis Taylor wrote:
To: Multiple recipients of list ORACLE-L
another fun thing: there used to be a web site (an/or
utility program) that would randomly insert "zippy
the pin-head"isms into a web page, or email. good
revenge would be to "ZIPPYize" the content of their
message, and send it back asking if they could train
a couple of hundred developers in how
OK Magesh, back to work!
You obviously have too much time on your hands. ;)
Jared
On Wed, 14 Feb 2001, magesh wrote:
Dear All
Execute the statement on a SEQUEL prompt and see the message for you.
SELECT TRANSLATE('_9(8.-.=5*;.81^^;.=1@5$)9$5.41;',
'1234567890!@#$%^*()-=_+;,.',
Dang it, that should be RPAD.
-Original Message-
Sent: Thursday, February 15, 2001 9:41 AM
To: Multiple recipients of list ORACLE-L
stat
use
select
lpad(object,254)||lpad(type,24)||lpad(sid,7)||lpad(owner,64)
from
blah blah
etc.
Dan
-Original Message-
Sent:
changing sql.bsq only helps at the point when you are creating the
database past that it's never run again
From: "Mark Leith" [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: OBJ$ - PCTINCREASE 0
Date: Thu, 15 Feb 2001
I didn't know there were so many Douglas Adams fans out there on the list,
I've been following the hitchhikers guide since it first appeared as a radio
show
back in the UK, the TV show never did justice to the books or the radio show but
was till fantastic.
I love all of Douglas Adams stuff.
See www.lokigames.com
Try Heavy Gear II and Quake III...they run well on my box.
Kevin Kostyszyn wrote:
What about Mechwarrior or Quake II, can I run that on Unix and will it run
smoothly? This is a fun debate, but I do agree there will never be a
winner.
-Original Message-
And a 1000 for Rachel as well!
Jared
On Wed, 14 Feb 2001, Rachel Carmichael wrote:
British Comedy Red Dwarf
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San
Title: RE: ksedmp
Hi
Patrice,
Ross
is right. Sorry that you did not find anything helpful in my book. I did not
include the error handling module in the scope for my book, because I don't
think it's very interesting. Here is what the introduction of my book says about
the services layer
Title: RE: Off Topic: Row Locking - Row Id
No, please 100 for Ms. Carmichael!
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 15, 2001 12:46 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Off Topic: Row Locking - Row Id
Connect, resource. When I run as set sql trace
only then it gives all the statistics as well.
Shakeel
--- Eriovaldo do Carmo Andrietta [EMAIL PROTECTED]
wrote:
but,
Whish privileges this schema has ?
DBA ?
In simple user it doesn´t run correctly ..
Eriovaldo do Carmo Andrietta
Hi Gurus
I have a big fat Indexes, I need to recalculate their storage clauses, What
is best approach to calculate next extent, min extents and other stuff like
pctfree and pctused. I hope mine is insert based database with 150gigs data,
I need to set up pctused @30-40.
Any body can threw
Title: RE: Are you ready to become SPAM certified?
LOL!!!
-Original Message-
From: Eric D. Pierce [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 15, 2001 12:41 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: Are you ready to become SPAM certified?
i personally
Actually if you look over there website you will see that Edward Haskins
is responsible. Does anyone know this person???
Is he part of this list? They have a phone number listed,
609.698.0332. Has anyone called him??
-Original Message-From: Mark Leith
[mailto:[EMAIL
Title: OT: this is the last thing we need
Just what we needed, Clinton on Oracle's board of directors
Clinton to kick off Oracle AppsWorld
Former President Bill Clinton will be the keynote speaker
at Oracle's AppsWorldin New
No finger pointing here.
I have not met any duhvelopers at this company. (yet)
Plenty at the previous job.
This is a fictional scenario.
Jared
On Thu, 15 Feb 2001, Thater, William wrote:
[EMAIL PROTECTED] wrote:
Seriously, has anyone successfully used LogMiner for auditing
in a
Hi All,
That storage clause was adopted for 8.0 to reduce the risk of SYSTEM tablespace
fragmentation making OBJ$ unable to extend. Of course, somebody should have
changed it for 8.1 now that OBJ$ get littered with so much more stuff.
If you are going to rebuild this database and want to choose
hhm, I agree to an "extent":). Any good DBA should check for all objects
in a database reaching MAXEXTENTS, on a fairly regular basis. I DIDNT say
that MAXEXTENTS should have a default of 2000 for a LMT just because I'm too
lazy too get of my slim a$$ to check every now and then, I said
At 09:41 AM 2/15/01 -0800, you wrote:
i personally don't get enough spam, and almost forgot
how to use the "del" key, so i was overwhelmed with
gratitude that they gave me the opportunity to practice
using the "del" key. :)
My mail server blocks anywhere from 20-50 spams per weekday, at least
If you have lots of money, call Oracle. They will bring a tool and get
your data our of the old datafiles. It costs big bucks but worth it if you
have to get the data.
Ruth
- Original Message -
To: "Multiple recipients of list ORACLE-L" [EMAIL PROTECTED]
Sent: Wednesday, February 14,
COULD IT BE???
squid pro quo for the justice department's investigation
of Microsoft??
On 15 Feb 2001, at 10:31, Adams, Matthew wrote:
Date sent: Thu, 15 Feb 2001 10:31:42 -0800
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Title: RE: ksedmp
Note
to list
Many
moons ago, before Steve got anywhere near finishing his book,
it was
to be a glorious oeuvre, a Magnus Opus, a.well, nevermind,
but it
was going to be big Big BIG. Including everything about Oracle.
(Steve
had even decided to include a section
Title: OT: this is the last thing we need
Ellison and Clinton... "Birds of a feather flock
together?" Got cigar?
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Adams, Matthew (GEA,
088130)Sent: Thursday, February 15, 2001 10:32 AMTo:
Title: RE: Are you ready to become SPAM certified?
Along Dennis' thought linespicture this, if you will.
A simple man...an internet user...perhaps even an Oracle DBA
...who receives so much spam every weekday that he wears off not
only his fingerprints, but eventually his fingers,
I just
sent out a team of hunter/killer mercenaries to kill
EVERYONE
associated with Eddy Haskell, OraKnowledge, OCP, Oracle, and
having
anything to do with data, information, or the Internet in
general.
We'll
teach those RAT-B#STARDS not to spam, if it's the last thing we do.
Sorry, it was auctioned off ! ( To pay Bill's bills).
-Original Message-
From: Steve Orr [SMTP:[EMAIL PROTECTED]]
Sent: Thursday, February 15, 2001 1:31 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: this is the last thing we need
Ellison and Clinton... "Birds of
First it was the GATES era then the MONICA era and now it looks like the BILL era.
My wife called and said that I should change professions when she heard the news about
Bill %$%$##. Will Oracle stock certificates become "JUNK BONDS" ???
ROR m? m something stinks here!!!
[EMAIL
I'm new to Java in the DB. Once a class or source has been loaded into
Oracle, is there any way to get it back out?
Thanks.
Paul Baumgartel
InstiPro, Inc.
[EMAIL PROTECTED]
212 813-0829 x103 (office)
917 549-4717 (mobile)
--
Please see the official ORACLE-L FAQ:
Is that the Eddy Haskell from the BEAVER
[EMAIL PROTECTED] 02/15/01 02:19PM
I just sent out a team of hunter/killer mercenaries to kill EVERYONE
associated with Eddy Haskell, OraKnowledge, OCP, Oracle, and having
anything to do with data, information, or the Internet in general.
We'll
AFAIK - The spammer's home info is
800 Michelle Court
Lanoka Harbor, NJ 08734-1828
609 971 7296
Below is the reponse I got from my nasty-gram to [EMAIL PROTECTED]
I hope that he's learned his lesson won't spam us again.
Thank
It would have gone to user defalut tablespace, had I
not given specific tablespaces for the partitions.
Is there a data dictionary view which tells the
default tablespace of a table?
--- Ruth Gramolini [EMAIL PROTECTED] wrote:
It will go into the default tablespace of the
creator of the
Dear List,
Here's a problem that a fellow DBA is experiencing, and
for which I have not been much help. :(
This is the situation:
A session is started and the following query is issued:
select log_record, raw_log_data_id
from raw_log_data
where status = 'U' and
Not a bad thought, Ross.
Both Steve Adams' and Jonathan Lewis' books are
by far the best literature out there on Oracle.
Most of the other publications (not detracting
from the effort and knowledge of other authors)
are merely rehashes of the Oracle documentation.
Whilst I am sure that us (the
At 12:16 PM 2/15/01 -0800, you wrote:
No offense all, but I don't see why everyone is so upset about this email.
It pertained to Oracle and we recieved it once. It's as if I recieved an
interesting email and sent it to all of you, why so upset?
If it was just once, no-one would care. But SPAM
I was thinking the same.
--
Chris J. Guidry P.Eng.
ATCO Electric, Metering Services
Phone: (780) 420-4142
Fax: (780) 420-3854
Email: [EMAIL PROTECTED]
-Original Message-
From: Ron Rogers [SMTP:[EMAIL PROTECTED]]
Sent: Thursday, February 15, 2001 12:58 PM
To: Multiple recipients
I will throw in some money for this worthy cause.
-Original Message-
Sent: Thursday, February 15, 2001 3:23 PM
To: Multiple recipients of list ORACLE-L
Can someone organize taking collections for a "thank you"
gift for the spammer (or if he was fired, for the officers
at the
H...
"Primative (excessive) but effective"
-Original Message-
Sent: Thursday, February 15, 2001 12:45 PM
To: Multiple recipients of list ORACLE-L
I think publishing the spammer's home address and phone number is excessive.
What do you think, that we're all going to go over there
What, now you are getting squeamish, just because he was on leave it to
beaver? Just let him do his job and next time they will think twice when
they spam someone!
From: "Ron Rogers" [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Do you mean that other than the FACT that this SPAMMER directly violated
his contract with both @HOME and INSYNC.NET; who is his ISP?
Do you mean other than the fact that this LUSER consumed MY bandwidth,
MY disk storage, my CPU cycles without MY consent to deliver his SPAMvertizement?
Such
SWEET MERCIFUL CRAP!! that's a lot of spam, however, I only recieved this
one once.
-Original Message-
Taylor
Sent: Thursday, February 15, 2001 3:39 PM
To: Multiple recipients of list ORACLE-L
At 12:16 PM 2/15/01 -0800, you wrote:
No offense all, but I don't see why everyone is so
You mean, drop? dropjava.
-Original Message-
Sent: Thursday, February 15, 2001 3:02 PM
To: Multiple recipients of list ORACLE-L
I'm new to Java in the DB. Once a class or source has been loaded into
Oracle, is there any way to get it back out?
Thanks.
Paul Baumgartel
InstiPro, Inc.
Those are all very excellent points there Charlie, but if this is how angry
you get when you get spam I would hate to see what you are like when
something really bad happens. Give me a break already, go ahead and get
some proof of all of those laws in all of those states, then go ahead and
try
Title: RE: OFFTOPIC: Spam.
ROFLMAO
Grey Poupon, Paul.
-Original Message-
From: Paul Baumgartel [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 15, 2001 3:45 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: OFFTOPIC: Spam.
I think publishing the spammer's home
Title: RE: OFFTOPIC: Spam, Death, the Universe, and Everything
Give that man a Cigar!
(heh heh heh.)
-Original Message-
From: Ron Rogers [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 15, 2001 2:58 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: OFFTOPIC: Spam,
select default_tablespace from dba_users where user_name='YOUR_USER';
If this is not where you want stuff created then you can change the default
tablespace:
alter user 'YOUR_USER' default tablespace 'DESIRED_TABLESPACE';
hth,
Ruth
- Original Message -
To: "Multiple recipients of list
No, I wasn't clear enough; I mean retrieve into a file.
Paul Baumgartel
InstiPro, Inc.
[EMAIL PROTECTED]
212 813-0829 x103 (office)
917 549-4717 (mobile)
-Original Message-
Sent: Thursday, February 15, 2001 4:16 PM
To: Multiple recipients of list ORACLE-L
You mean, drop?
Hi Kevin,
I think we would have tolerated a post to this list pretending that he was
sharing interesting information. But his email indicates that he has added us to
a different (his own) mailing list without our consent, and that we need to
"unsubscribe" to avoid getting more mail. That's
This LUSER made it public information by registering his SPAMvertized domain,
and it is easily cross confirmed from www.anywho.com
If he did not want folks to contact him, maybe he should have not SPAMMED folks.
When a SPAMMER willfully violates his contract with his ISP,
why should anyone
Steve,
Here's what I did to test Select...For Update Skip Locked.
The same ORA-03113 happens running SQL*Plus 8.1.6 or 8.1.7
(both window and command line versions) against either
Oracle8i EE 8.1.6.0.0 or 8.1.7.0.0. SQL*Plus and the
databases are running under Windows2000. Both the simple
Title: OFFTOPIC RE: Need help in moving LOB index
How far away is the tablespace?
You need to know this, because first you need to compute
tablespaces/mile before activating the LOB-Velocity filter.
This is a new 8i feature that some of the list gurus might
be able to help you with.
Daniel,
I happen to be both the DBA and the NT administrator of our Oracle NT
servers.
I would suggest that you may want both types of monitoring and that in fact
OEM can report its events to your standard SNMP monitoring tool (not that I
have done this yet).
For example, you may want to know
Title: OFF TOPICRE: Get Java from database?
Oh, you mean drinkjava.
-Original Message-
From: Paul Baumgartel [mailto:[EMAIL PROTECTED]]
Sent: Thursday, February 15, 2001 4:42 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Get Java from database?
No, I wasn't clear
Lighten up Francis.
From: "Charlie Mengler" [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: OFFTOPIC: Spam.
Date: Thu, 15 Feb 2001 13:42:30 -0800
This LUSER made it public information by registering his SPAMvertized
domain,
Winnie,
According to the SQL Reference for 8.1.6 (Create Table):
LOB_index_clause
This clause is deprecated as of Oracle8i. Oracle generates
an index for each LOB column. Oracle names and manages the
LOB indexes internally.
Although it is still possible for you to specify this
clause, Oracle
Title: OFF TOPICRE: Get Java from database?
Someone has been
drinking *too much* java, methinks.
Paul Baumgartel InstiPro, Inc. [EMAIL PROTECTED] 212
813-0829 x103 (office) 917
549-4717 (mobile)
-Original Message-From: Mohan, Ross
[mailto:[EMAIL PROTECTED]]Sent: Thursday,
Oracle recommends against this.
LOB_index_clause
This clause is deprecated as of Oracle8i. Oracle generates anindex for each LOB
column. The LOB indexes are system named
and system managed, and reside in the same tablespace as the LOB data segments. It is
Wasn't Eddy Haskell the friend of Wally on "Leave it to Beaver" who always
caused trouble.
-Original Message-
I just sent out a team of hunter/killer mercenaries to kill EVERYONE
associated with Eddy Haskell, OraKnowledge, OCP, Oracle, and having
anything to do with data, information,
Steve,
Yes, it does work, but not on our Documents table, which is
partitioned! After getting your reply I tried it again on
another table (Documents is our main table and I just tend
to have Documents on the brain - that's why I picked it
originally) and it worked on the other, non-partitioned
Hi Jack,
If it works as expected, option 1 is no doubt the neatest. However, remember
that this is an undocumented feature, so play with it by all means, but don't
build it into anything important. If you were to hit problems (like your
ORA-3113 error) once it was in production, you would have a
1 - 100 of 103 matches
Mail list logo