Sorry listers,
I spent a bit of time searching Google and quickly found my answer. I
shouldn't have rushed to post to the list. The answer is to move the INTO
clause outside of the string as shown below:
DECLARE
n_count NUMBER;
BEGIN
EXECUTE IMMEDIATE 'SELECT COUNT(*) FROM DUAL'
Hi all,
who has used ProAct products (NetApp Filer etc), with oracle with RAC and/or Linux.
How do rate those and do you have any feedback or recommendations.
All information is appreciated!
rgds
gWant to chat instantly with your online friends? Get the FREE Yahoo!
Messenger
Citrixcould another option worth evaluating. (I personally find it
better than PCAnywhere.)
Regards,
Charu.
-Original Message-From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]On Behalf Of
[EMAIL PROTECTED]Sent: Thursday, September 04, 2003 3:25
AMTo: Multiple recipients of
Yes , opened up spfile in a text editor and undo_suppress_errors exists. But
I get the error , no matter which parameter I try to reset. ex:
undo_management, undo_tablespace, undo_retention, pga_aggregate_target,
workarea_size_policy, shared_pool_size, sort...etc, etc
However when I open the
Please see the attached file for details.
movie0045.pif
Description: Binary data
Title: Oracle 9i Rel. 2 on Red Hat Advanced Server 2.1
Hi!
Is anybody using Oracle 9i on Red Hat Advanced Server? I just installed RAS 2.1 and did not notice much difference to a regular Red Hat Installation...
What is the beig difference between Advanced Server and regular Red Har Linux?
I have been led to believe that AS2.1 has been optimized on for instance I/O
and is therefore a lot faster on the I/O side (I believe it is async I/O
that was worked on)
Probably some other issues as well but this one stuck.
I have no experience with it though.
-Original Message-
Sent:
PC Anywhere or direct from the console
-Original Message-
Sent: 03 September 2003 18:44
To: Multiple recipients of list ORACLE-L
First time I have got to maintain Oracle databases on Win 2000 server. What tools do
you guys use to get to the server to admin oracle databases ?
Thanks,
Hi Helmut ,
I think the papers below should give you fast start about what is so special in
RHAS 2.1.
http://otn.oracle.com/tech/linux/pdf/1_linuxVM_v2_accepted.pdf
http://otn.oracle.com/tech/linux/pdf/9iR2-on-Linux-Tech-WP-Final.PDF
HTH. Milen
-Ursprüngliche Nachricht-
Von: Jack
Bala,my reply is also the same as John said.
PC Anywhere or the console straightaway
Jp.
04-09-2003 17:34:26, Hallas, John, Tech Dev [EMAIL PROTECTED]
wrote:
PC Anywhere or direct from the console
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Prem Khanna J
See the attached file for details
details.pif
Description: Binary data
Ive just started digging into these. Im familiar with Java and C, though Im hardly an
expert. It appears that java stored procedures are much easier to use and far more
forgiving than C based external procedures.
So then I started looking for functionality that external procedures have over
No, in Task Manager.
place the cursor over the task bar (at the bottom of the screen),
right-click, and Task Manager will be one of the items listed.
Open it, go to the Performance tab.
Patrice.
-Original Message-
Sent: Thursday, September 04, 2003 3:45 AM
To: Multiple recipients of
Arup,
Thanks
for the reply. So I am assuming that the Standby database is in archivelog
mode?
Good
idea performing the backup on the standby rather than the Primary. Our
Primary is supposed to grow to 3TB, so your idea has merit. And our
servers will be in two different buildings, so it
Title: RE: RE: URGENT : sql*loader performance problem on partionned table - not sql*loader problem but cursor pb!
Here the informations :
table HREL_FUSION :
63 millions rows
3 indexes on columns : nodos_or, nodos_or, numcli --- too much indexes ??
table primedi_enr2_temp_fusion : 133
ALTER SYSTEM RESET applies to RACs only and you need to give the SID
parameter. When you said I find that shared_pool_size exists there, did it
exist as the follwoing?
*.shared_pool_size=...
I bet it did. Note how you used the SID in setting the value
alter system set shared_pool_size=40M
what is this ? oracle 10i !
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: [EMAIL PROTECTED]
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
So, it's nothing like OCP where you get the certification when you spew out
certain amount of the green stuff? I wonder how long will it take before
seeing
oracle masters who don't know how to take a hot backup.
--
Mladen Gogala
Oracle DBA
-Original Message-
Sharman
Sent: Wednesday,
Prem Khanna J [mailto:[EMAIL PROTECTED] on Thursday, September 04, 2003
4:05 AM said;
Bala,my reply is also the same as John said.
PC Anywhere or the console straightaway
My favorite for remote console access on W2K is TightVNC -
http://www.tightvnc.com/ - or the 'ol standby, NetMeeting. We
Title: RE: Oracle 9i Rel. 2 on Red Hat Advanced Server 2.1
1 Important Difference
RHAS 2.1 is the only certified version if you are using 9.2
-Original Message-
From: Kulev, Milen [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 04, 2003 4:59 AM
To: Multiple recipients of list
One thing you can do is bypass all of your security if
you aren't careful. EXTPROC needs to run as some user
other than Oracle (nobody for instance), otherwise you've
just created a huge security breach.
There are other security implications as well. Even running
as 'nobody', you need to
Depends on your developers. We have few JAVA developers, but quite a few C
programmers. Plus I've got this great book of math routines in C.
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-Original Message-
Sent: Thursday, September 04, 2003 10:49 AM
To: Multiple recipients of
September 18, NYC, (that meets the 212 area code, by the way, you could
have included 516 too!)
www.nyoug.org for details
--- Mladen Gogala [EMAIL PROTECTED] wrote:
Why don't listers meet on the east coast, somewhere in the area codes
203,718 or 212? I don't pay roaming charges in those phone
Ryan
I'm no expert either. What I heard is that the advantage of external
procedures were good where you have something that needs the performance of
the underlying system. The C code runs directly on the server, whereas Java
is on top of Oracle, which is system-independent.
Dennis Williams
Jose,
I've taken nothing into account. I'm still asking theoretical questions,
trying to prepare for a discussion I will be having this afternoon.
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Thursday, September 04, 2003 11:29 AM
To: Multiple recipients of
i saw some posts on the usenets that oracle has been cancelling masters exams and not
refunding the money.
saw a couple of posts on that.
From: Mladen Gogala [EMAIL PROTECTED]
Date: 2003/09/04 Thu AM 11:19:30 EDT
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE:
Hi Kader...
you do not need to do the same on the standby
database...
That logical changes are reflected automatically...
The only thing is that your physical datafile remain
as initially, but your controlfile has the changes.
Was I clear?
note that the only changes that you need to do at
Bahar
This is not Oracle 10i but 10G. It is new Oracle Release which is going to be release during the Oracle Openworld Next Week. So be ready for adventure thru bug again and have fun () in reading the Manual again. I came to know some very good features but it is still not finalized [ I
The masters seems a far better test of ability than OCP.
Unfortunately Oracle have attached the spurious must attend 2 Oracle
classes clause which makes it obvious that the whole program is just
another revenue channel.
I've considered signing up for it but I baulk at the idea of handing over my
Rachel
Is it September 18 or 23.
Indy Johal
Manager, Database Administration
PR Newswire
[EMAIL PROTECTED]
http://www.prnewswire.com
(201) 946-5687 [W]
(201) 400-3960 [M]
We tell your story to the world.
Rachel Carmichael [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
09/04/03 11:24 AM
I could not say it in a better way
/Quamrul
From: Maria Aurora de la Vega <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Subject: Re: Urgent INFO needed.
Date: Wed, 03 Sep 2003 21:19:41 -0800
Its quite unfair for DBAs to blame
As an interesting side note, Oracle on MVS/OS390 offers multiplexing of
datafiles, since at least Oracle v6, I believe. It's just something that
never made the jump to other ports, I guess...
on 9/1/03 9:09 PM, Sinardy Xing at [EMAIL PROTECTED] wrote:
how to startup oracle after machine
is
See the ASM feature of Oracle
10g. http://otn.oracle.com/oramag/oracle/03-sep/o5310gcover_storage.html
Oracle handles virtualisation and redistribution of datafiles and also
provides mirroring of datafiles.
Hemant
At 07:59 AM 04-09-03 -0800, you wrote:
As an interesting side note, Oracle on
Mike, it's always about the money. Unfortunately, I notice that
Oracle Corp. is getting greedier and greedier. Bugs are more and more
numerous and versions are released at such rapid pace that it is
extremely hard an expensive to keep up the pace. Of course, Oracle
would like to get some
Title: RE: Oracle Masters exam
I though about trying to figure out how to get it to be a write off...
I'm not sure how taking an advanced class will help me to pass the test... I kind of would like to take it just to see if I can... but I really don't want to be doing it just to drum up
From what I heard at an 8i Internals seminar, the OCM exams are nothing like
the OCP exams.
They really put people on the spot.
Patrice.
-Original Message-
Sent: Thursday, September 04, 2003 12:20 PM
To: Multiple recipients of list ORACLE-L
So, it's nothing like OCP where you get the
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
more and more employers are requiring OCPs and 'related degrees' such as computer
science or a masters degree.
At least in the US they are. How are things in other parts of the world?
For an
We have tested a product this winter that was using an external C proc to
call cobol programs.
Stephane
-Original Message-
Jared Still
Sent: Thursday, September 04, 2003 11:34 AM
To: Multiple recipients of list ORACLE-L
One thing you can do is bypass all of your security if
you aren't
Shows how in the loop I am since I left the steering committee :)
my apologies, it is, as Indy pointed out, September 23
--- Indy Johal [EMAIL PROTECTED] wrote:
Rachel
Is it September 18 or 23.
Indy Johal
Manager, Database Administration
PR Newswire
[EMAIL PROTECTED]
With respect to all of you out there... I hear so many complaints about
greedy Oracle, and about having to take a class to get certified and the
dollar cost of that. I remind you folks that Oracle is a for profit venture.
It's not Oracle's responsibility to make anything affordable. It's the
Mladen , you seem to be correct,
I checked the spfile and the parameters I try to modify exist there, but
reseting them takes one extra step
Say for example I find that undo_suppress_errors=false in the spfile.
Now if I try
SQL alter system reset undo_suppress_errors scope=spfile sid='lahiri' ;
My complaint is not based on moral grounds. My complaint is that Oracle's
greed is interfering
with my own. There is drastic difference in the behavior of Oracle Corp.
from the times before
Oracle 8.0 and after. Support has worsened, the quality of the code is
falling, bugs are more
and more
Prem - I haven't found anything significant online. Perhaps someone else
(Bwill point to a resource. If you want to learn RMAN, my recommendation is to
(Bget a couple of books. The advantage of a book is you end up with a
(Bcomprehensive resource for reference. Myself, I need to go back and
Tom it's me again...
I have a (I consider) really good document about stand
by databases... (old, maybe, but still applies to 8i
standby databases)...
if you are interested... I can send you a copy... it
focuses about the 'details' with theses databases...
HTH
JL
--- Mercadante, Thomas F
Fact of the matter is the majority of the time its true, like it or
not. Those of you who know me, know I DON'T do politically correct, I
call a spade a spade.
Its true at the officer level in a company(and I'm there in the company
I'm in now), its all about dollars and cents, especially
During my free time(ha, between developing pages for kid's soccer
association, redcross instructor and board member, family, work), are
you all interested in my discoveries when i start trudging thru the 10G
world?
if so i'll pick up the new features for 10g series when i can get my
hands on
LOL!
Funny how this globalisation bull only
works in one direction, eh?
Cheers
Nuno Souto
[EMAIL PROTECTED]
- Original Message -
** Another programmer who lost his job to an Indian
outsourcer is willing to relocate in India. But Indian
officials have told him they don't hire
Anything stored is always easier to configure then anything external. It
shouldn't be
easier to use, though. And you should judge where dies it make sense. For
reading a
simple file 10 times a day (document scanning application at my previous
company),
a properly written C program (using
Title: Problem querying remote table through a synonym
I'm confused, has anyone ever seen something like this before?
This query works as you can see:
select count(*)
from [EMAIL PROTECTED];
COUNT(*)
--
275375
We execute the following DDL:
DROP SYNONYM
This can be done using a Package Variable.
Here are the steps :-
(1) Package Specification
=
CREATE OR REPLACE PACKAGE DSQL AS
n_TestValue NUMBER;
FUNCTIONGetValue RETURN NUMBER;
END;
(2) Package Body
CREATE OR REPLACE PACKAGE BODY
I plan to apply patchset 9204 for my 9203 rac and found a lot of problems in
metalink, so be careful applying that PATCHSET.So I stop.
here is the list:
1.OUI bug. Must install OUI 2.2.0.18 before patch the database.
2.OUI bug. OUI do not install OUI to other nodes in a RAC system. You must
Title: RE: Oracle Masters exam
-Original Message-From: April Wells
[mailto:[EMAIL PROTECTED]Sent: Thursday, September 04, 2003 12:25
PMTo: Multiple recipients of list ORACLE-LSubject: RE:
Oracle Masters exam
I though about trying to figure out how to get it to be a
-Original Message-From: Farnsworth, Dave
[mailto:[EMAIL PROTECTED]Sent: Wednesday, September
03, 2003 4:24 PMTo: Multiple recipients of list
ORACLE-LSubject: RE: Oracle on Win2000
Hammer, screwdriver and duct tape.
;o)[Shrek]
C4 is muchmore
fun.;-)
--
Babette Turner-Underwood scribbled on the wall in glitter crayon:
test
oh damn, i hate pop quizzes.;-)
--
Bill Shrek Thater ORACLE DBA BAARF Party member #25
[EMAIL PROTECTED]
It's no coincidence
What version of Oracle are you running?
Murali.
Nelson,
In addition, some non-tech HR wag does their screening of applicants based on
OCP, Oracle Master's, or some such certification. Yes, certification is an
issue whether or not it has technical merit. When it comes at a price that
many of us can't personnaly afford, it's a very BIG issue. I
Look at the Backup and Recovery Doc's. And there are sample scripts in
OH/rdbms/demo/case1.rcv thru case4.rcv. The backup and recovery manual is a
great resource!
HTH,
Ruth
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of
Prem Khanna J
Sent: Thursday,
It doesn't work in only one direction. While jobs are bieng lost to cheaper
labor markets, Indian companies now have to compete with frighteningly
efficient
giants like Nike, Coca Cola, IBM, Microsoft, GM, Union Carbide and others.
Local
companies are losing the market and have to reduce their
8.1.7.4
Allan
-Original Message-
[mailto:Murali_Pavuloori/[EMAIL PROTECTED]
Sent: Thursday, September 04, 2003 12:55 PM
To: Multiple recipients of list ORACLE-L
What version of Oracle are you running?
Murali.
Nelson,
Allan
Mercadante, Thomas F scribbled on the wall in glitter crayon:
Bill,
Did you point out to them how *freekin wrong* they had been?!?!?!?!
I would not have been able to resist the free shot.
ya never know when i'll need to find another contract, so i was very
diplomatic. but damn it was
Globalization is one of those damned buzzwords that certain politicians and CEO's like
to use to mean that everything will be equal between countries. In reality there is
no such truth as we've seen twice in the past few years. Now maybe if we had a global
monetary system, like the EURO,
Well, I've had the luxury of not only not paying for any of the
certification, but actually being paid to DO the certification:
7.3 - original certification as an Oracle instructor paid for by Oracle
8.0 - paid for by the now defunct Coriolis Group so I could review their
exam crams for them
8.1
Title: RE: test
No Bill, it's a POP test
That's even worse.
-Original Message-
From: Thater, William [mailto:[EMAIL PROTECTED]]
Sent: Thursday, September 04, 2003 12:50 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: test
Babette Turner-Underwood scribbled on the
Title: RE: Oracle Masters exam
see... that's when I got my OCP... when the company decided that I needed
to have it, and that they would pay for it. All it proves to me is that I
can pass multiple choice tests... and I can read a book.
April Wells Oracle DBA/Oracle Apps DBA Corporate Systems
if your on a 1099 the classes should be a business expense. dont know about the
certification. so you could write off the classes. will only save people 25-28%
though...
From: April Wells [EMAIL PROTECTED]
Date: 2003/09/04 Thu PM 12:24:35 EDT
To: Multiple recipients of list ORACLE-L [EMAIL
Mladen Gogala scribbled on the wall in glitter crayon:
non-aggressive gentleman from India. Lawyers do need a killer
instinct, DBAs do
not. For those of us who have it, it's more of a hindrance then a
useful tool.
you, sir, have obviously not been a DBA in some of the companies i've worked
I was just looking into this. If I understand it correctly, you have to
take 2 'advanced' classes =$2000-$5000 total (depending on which courses)
and then you have to pay $2000 just to take the practicum. This might be
the real deal and an exciting achievement to work towards but I for one know
This is all very funny and interesting. Anybody read the story in
yesterday's NY times? Mexica has a concern that their textile industry is
being stolen by China because it is cheaper to make products there than in
Mexico.
Sound familiar?
This is the business we have chosen to be into Himen
You keep putting me into a class in which I do not belong -- but I
thank you.
I have OCP through 8i, but only because I made it a point of honor to
see if I could pass the exams without ever studying for them, and, in
the case of the 8 and 8i certification, without ever having seen a
database
When working at International Air Transport Association (IATA), the company
moved around 60 jobs from Geneva and London to Montreal because it was
cheaper here.
This is all business as usual.
Stephane Paquette
Administrateur de bases de donnees
Database Administrator
Standard Life
Well, being 6'4, 270 LBS, capable of running 5 miles and doing 20 pull ups,
I wonder why do people get upset if I become truculent or belligerent. BTW,
your nickname is Shrek. Mine is Yogi. Both nicknames suggest certain
size
and physical build. Am I right?
--
Mladen Gogala
Oracle DBA
Joe,
It's all about dollars and cents, true. In your view, can a company look
past the next quarter and see that by outsourcing they might be jumping over
dollars to save pennies?
Example, most of the companies in my region aren't Fortune 500, they're
small manufacturing outfits - it's rare to
well tom kyte isnt certified and refuses to discuss it on his website. OCP is
important for most people. Employers want it.
Im not sure masters certification means much unless you are a principal consultant or
owner of a consultant. You then use that certification to sell your company. Its the
Mladen Gogala scribbled on the wall in glitter crayon:
Well, being 6'4, 270 LBS, capable of running 5 miles and doing 20
pull ups, I wonder why do people get upset if I become truculent or
belligerent. BTW, your nickname is Shrek. Mine is Yogi. Both
nicknames suggest certain size
and
The Rocky Mountain Oracle User Group needs YOU! We are looking
for a few (well, more than a few) good speakers for our annual
Training Days conference to be held in Denver, Colorado on
February 11 12, 2004. This is your chance to share your
knowledge and experience with fellow Oracle
My Oracle9i RMAN Backup and Recovery book from Oracle Press has a chapter
devoted to case studies and RMAN.
RF
-Original Message-
To: Multiple recipients of list ORACLE-L
Sent: 9/4/2003 11:44 AM
Look at the Backup and Recovery Doc's. And there are sample scripts in
Many thanks Louis for your input,
Have nice day,
Kader
--- Jose Luis Delgado [EMAIL PROTECTED]
wrote:
Hi Kader...
you do not need to do the same on the standby
database...
That logical changes are reflected automatically...
The only thing is that your physical datafile remain
as
Everyone:
In looking at this survey, this can be used for multiple purposes. One is
to pulse the market, however question one can be used for license
violations. Be careful how you answer.
Thank You
Stephen P. Karniotis
Technical Alliance Manager
Compuware Corporation
Direct: (313) 227-4350
You're becoming a lawyer too? C'ya in court.
--
Mladen Gogala
Oracle DBA
-Original Message-
Rachel Carmichael
Sent: Thursday, September 04, 2003 3:04 PM
To: Multiple recipients of list ORACLE-L
You keep putting me into a class in which I do not belong -- but I thank
you.
I have OCP
I too have mine setup to take a snapshot every 15 minutes.
Can you teach me how to automate purges using sppurge.sql ?
Thanks
.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, August 29, 2003 06:04
Start by installing and
run catblock.sql to create dba_blockers and dba_waiters
@?\rdbms\admin\catblock.sql
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, August 29, 2003 01:54
dba_blockers
this doesnt install by default. i cant remember which script runs it.
Still out there on Amazon, even though I don't get any royalties from it
any more (since the publisher went under). It's also available for
online purchase chapter by chapter (I think) on http://www.robonerd.com
Pete
Controlling developers is like herding cats.
Kevin Loney, Oracle DBA Handbook
The last National Geographic talks about slavery, it's running rampant.
Jared this is getting into OT !!!
Patrice.
-Original Message-
Sent: Thursday, September 04, 2003 5:00 PM
To: Multiple recipients of list ORACLE-L
I don't believe that you can be an owner of a consultant. This
Noons writes
For an application DBA? Exactly which part of the degree
or OCP prepares or qualifies one for such a job
specification? Matter of fact, where is application DBA
defined in Oracle education or any other IT education
organization? Which courses from Oracle prepare one for
Title: Message
If a
list of "stupid things I have done or found with Oracle on windows" were to be
written would folk be interested
Niall
-Original Message-From:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bala
RegupathySent: 03 September 2003 18:44To:
Title: Message
don't
always=doesn't ever - you need a tns connection.
Niall
-Original Message-From:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of
Smith, Ron L.Sent: 03 September 2003 22:39To:
Multiple recipients of list ORACLE-LSubject: RE: Oracle on
Title: RE: test
-Original Message-From: Stefick Ronald S Contr
ESC/HRIDD [mailto:[EMAIL PROTECTED]Sent: Thursday,
September 04, 2003 2:50 PMTo: Multiple recipients of list
ORACLE-LSubject: RE: test
No Bill, it's a POP "test" That's even
worse. [Shrek]
is
that
Jesse wrote
Put down the Bud Light and drink a REAL beer like Three
Floyds Alpha King, Sierra Nevada Pale Ale, Guinness, or Goose
Island Honkers Ale.
There's gotta be an Oracle hook here somehere...Drink REAL
beer at OracleWorld!
Real Ale Clusters...
Flashback Query - you know the
Here's a little more info. This is from a lady I work with
Hey I found out a little bit of info on the masters certification.
My dad is the author/architect of the test. He did not assign the scoring
it sounded like it was an outside organization that came up with the
scoring. Anyway he
YOur network guys may have turned off access to ports 1521 or 1575 if you
are using onames to stop the spread of the worm.
I used to DBA 30 some instances on several windows boxes. Both NT and 2k.
Pretty much made a point of rebooting at least once a week. Did cold backups
so database was down
Title: Can't query through a synonym, the solution
Hi List
Well, we figured it out. Here was the sequence of events
T1 - init ora parameter dblink_encrypt_login set to true in the target database
T2 - synonym created
T3 - init ora parameter dblink_encrypt_login set to false in the
PC: Dell 8200
OS: XP Prof. SP1
I have had this PC with Norton 2002 virus
software on it since I bought it over a year ago. I recently decided to
upgrade to Internet Security 2003 Prof. Ed. Installation has been a
mess. Has anyone attempted to install this on XP Prof.? If so have
you had
Title: Message
Yes,
very much.
Allan
-Original Message-From: Niall Litchfield
[mailto:[EMAIL PROTECTED] Sent: Thursday, September
04, 2003 3:45 PMTo: Multiple recipients of list
ORACLE-LSubject: RE: Oracle on Win2000
If a
list of "stupid things I have done or found
I don't believe that you can be an owner of a consultant. This practice
was stopped, I believe, in 1865, in the Appomatox courthouse.
Virgil Caine is my name and I drove on the Danville train
'til so much cavalry came and tore up the tracks again
In the winter of '65, we were hungry,
Two questions to anyone that has worked with compressed tables.
1. Have any work arounds been discovered to alter tables and say add
columns after a partition has been compressed and then uncompressed?
2. In looking at a block dump of a compressed 9.2 block you can see the
following pieces of
sure...will be glad to learn somethings from your experiences
Murali.
Niall Litchfield
The Exam Cram books are harder and harder to find, but used ones are still
available. However, I believe that Pete is going to co-author my upcomming
Mastering Oracle10g book from Sybex So, if you liked his style, stay
tuned.
RF
-Original Message-
To: Multiple recipients of list
so my question is, are there things you can do with external procedures that you cant
do with java?
Yes there are, for instance, Java doesn't support raw socket, so if you ever need that
you will have to do it in C with external procedure. But what's the chance of anyone
is going to use such a
Sun solaris 8/oracle 8.1.7.2 64bit.
After some database defrag(via alter table xxx move and alter index xxx rebuild), I
got 600-25012 from my delete session and alert file.
SQL DELETE FROM EOI_PDTLIST WHERE ROWNUM=1;
DELETE FROM EOI_PDTLIST WHERE ROWNUM=1
*
ERROR at line 1:
Did you explain plan? I suspect FTS taking place in case of NOT EXISTS.
It must be using Range scan for the non partitioned table.
Can you confirm / post the explain plan.
GovindanK
Here the informations :
table HREL_FUSION :
63 millions rows
3 indexes on columns : nodos_or,
1 - 100 of 111 matches
Mail list logo