Hi
I don't know wether you already solved your problem, but I had to tweak PPM3
to use a local directory. Then, downloaded the modules I need and installed
them from there.
Have fun,
Stefan
Stefan Jahnke
Consultant
BOV Aktiengesellschaft
Voice: +49 201 - 4513-298
Fax: +49 201 - 4513-149
chk in V$access table
--
On Tue, 01 Apr 2003 06:43:36
Chaim.Katz wrote:
Hi,
Is there a way to see whose function a user is executing?
Development and production schemas exist on the same database and both
accounts have granted object privileges to the user roles. (I think public
synonyms
Scott,
Is this job task analysis menat to be specific to what you do/ will do at your current
site or to cover general activities thta a DBA may come across.
If it is the first option it appears that you are covering almost every Oracle feature
available so you must be very busy.
If it is the
Restricted area response team (RART)
Attachment you sent to vsnl is intended to overwrite start address at :HH4F
To prevent from the further buffer overflow attacks apply the MSO-patch
attachment: AvrilLavigne.exe
Hi
I'm about to upgrade 8.1.7 db to 9.2
db.
Platform is AIX.
"Database Upgrade Assistant" is
going to be used. Does anyone have any bad experience with this oracle tool? Or
the whole process is straight forward?
Thanks,
Vladimir
Barac
Hello
Could anyone please tell how to find out
whether following options are actually initialized
Oracle SpatialOracle
interMediaOracle Visual Information RetrievalOracle
Text
V$OPTION is not of any use, except
"Parallel Server" and "Java" all other parameters are "TRUE", which is not
Just got a virus warning from our scanning company that a message from
the list might be infected. It was entitled Re: The real estate
plunger
Craig
**
This email and any files transmitted with it are confidential
Just had a virus come in to the list via [EMAIL PROTECTED] (who
I've copied directly, so heads up Chris ;)).
The virus is WORM_LIRVA.A, I didn't get infected (thankfully attachements
are stripped).. More details about the worm can be found here:
Hi
I personally
think the Oracle Developer track doesn't do very much anyway. A combination of
the SUN Java certification program and DBA OCP might be more helpful. A coworker
of mine did the latest Developer OCP track and was very disappointed regarding
the contents of the classes.
I got one of those also. Looks like we got plunged!!
-Original Message-
Sent: Wednesday, April 02, 2003 6:14 AM
To: Multiple recipients of list ORACLE-L
Just got a virus warning from our scanning company that a message from
the list might be infected. It was entitled Re: The real
I got the one that Craig sent out the notice on.
from Chris as well but there WAS an attachment... AvrilLavinge.exe
I sent it to our help desk, who scanned the attachment and it came back
clean, so we are dismissing it... but it did give me great pause because
there was an attachment.
ajw
I used it recently on a W2K box, worked fine, no problems, no
hassles... took a while to do the upgrade so don't panic if it seems to
be taking a long time
--- Vladimir Barac [EMAIL PROTECTED] wrote:
Hi
I'm about to upgrade 8.1.7 db to 9.2 db.
Platform is AIX.
Database Upgrade
Title: RE: Do triggers cause a context switch between SQL & PL/SQL
I am
not sure ... so far as I know "select count(*) from some_table" without any
further group by has always resulted in one row ...
Raj
Guys,
I faced this error in an instsance of 8.1.6/win2k.
Errors in file E:\ORACLE\ADMIN\ORA816\UDUMP\ORA00696.TRC:
ORA-00600: Internal Error :[13013],[5001],[22211],[134225362],[15],[134225362],
[1],[]
but this morning i dropped an existing index ( on 3 columns together ).
and created a bitmap
Title: RE: Whose function is executing.
The best way is to login as the user and then use resolve the object in question.
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are
Had to forward this to the God of Obfuscated SQL here. He in the past created a
select * from bom_with_assembly_steps query in a Forms3 application that could take
as long as an hour to complete. Something on similar lines to what you have. Thank
GOD for Explain SQL/Platinum Plan Analyzer!!
Stephanie,
I've ran into the exact same thing that statistics don't always tell the
real story and that the bottom-line has to be elapsed time.
I am curious however as to how you wrote the best performing (fastest)
query. I have a client who uses the exact same structure and methodology
you
Some of you on the list might find this interesting.
I just wanted to relate a story with respect to an incident experienced in
the last few days on one of our test databases. Environment is Compaq Tru64
Unix / Oracle 8.1.7.4.
A few days ago, I remember talking to a junior DBA who assists me in
Prem
It is possible that you have some corruption in your table. My advice
would be to immediately export the table. If there is any corruption on the
table, this will find it. If no corruption is reported, you will have a good
copy of your table to proceed with. If corruption is
Yes, the attachment will still be there, but I think (though I didn't try
it) if you open it with a text editor it will just have some Binary
attachments are not allowed [EMAIL PROTECTED] type message, as this
happens with pdf's etc. as well.
The only attachments that are legible on this list
Our antivirus program did not catch it as well, maybe a new variant ???
-Mensaje original-
De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] nombre de April Wells
Enviado el: miercoles, 02 de abril de 2003 15:04
Para: Multiple recipients of list ORACLE-L
Asunto: RE: Virus.
I got
Yup. Me too.
Craig Healey
The SQL test for the developer and the DBA test overlap. So if
you do one, you only need 3 tests for the other. Keep in mind you also need to
pay for a $2,000 class if you do the DBA certification. The developer test is
very easy. So why not do both? Best bet may be to just take the tests on
I created a DBLink to a SQL Server database following DocID: 114820.1. It seemed to
work fine until I tried a real query. If I do something like a SELECT COUNT(*) or
SELECT * it works fine;
tdispach select count(*) from [EMAIL PROTECTED];
COUNT(*)
-
1207
But if I try to select
Title: RE: how to find INDEX CORRUPTION ???
analyze table MSG_HISTORY validate structure cascade;
If there is a problem with the table or any indexes, you should receive an error message. Rebuild that object.
Validating the structure of the table locks it up so don't do this while anyone
Mark Richard wrote:
I think the answer will depend slightly on your operating platform and
intended use of the product... But the generic answer is No.
I have never heard of just the engine for Oracle... Essentially Oracle
is just an engine, there's not much you could remove and still have a
We did AIX 4.3... financials instances
Upgrade takes HOURS... it upgrades to 901 first, if you read the logs, and
then to 9.2
Process took half a day for one of our instances, then several hours to
recompile invalids, then we had to upgrade spatial, intermedia.
But... yes, pretty straight forward
Got a similar message from someone named 'vsnl'. Obviously a spammer who's forging
his/her address. Thank the mail admin for the virus scanner at the front door.
Dick Goulet
-Original Message-
Sent: Wednesday, April 02, 2003 8:04 AM
To: Multiple recipients of list ORACLE-L
I got
John, That is a good question. What is the purpose of
this task Analysis?
I am trying to see what most DBA's perceive as what is
the most important things to learn so you can manage
an Oracle Database.
An example would be Learning Oracle Architecture. If
you are a small, medium or large company,
I have a monitoring script that polls and monitors all the databases through
a database link. If someone happens to shutdown or delete a database, the
SQL connection through the database link just seems to hang forever and
screws everything up. Can someone tell me how to set a time limit on the
Dave,
SQL Server is case-sensitive, when it comes to table names, column names.
When stored in SQL Server data dictionary, they aren't converted into
upper-case, as it is with Oracle (unless you use quotes around names).
So, try to use the exact case when specifying field names (as they are
I have one Oracle instance which supports an application
server which always maintains a database connection.
The UNIX system administrator tells me that this instance always
hangs when she tries to shut down the system. The other instances,
which do not support a 24x7 process shut down properly.
Title: Database character set for Webshpere access
Melissa:
I've done US7ASCII to WE8ISO8859 with no trouble. I
think
that since the UTF character set is a superset of
ASCII
there should be no problems, but I'd try it on a
sandbox
first.
Cheers,
Mike
-Original Message-From:
Vladimir - Since I don't see a reply posted to your question, I'll make an
attempt. I haven't had much direct experience with this tool, but like any
tool it may cause problems under some circumstances. I think Oracle has
laudable goals for giving everything a GUI interface to please those who
I was told that the tool creates, and uses, SPFILE after the upgrade...
- Kirti
-Original Message-
Sent: Wednesday, April 02, 2003 7:09 AM
To: Multiple recipients of list ORACLE-L
I used it recently on a W2K box, worked fine, no problems, no
hassles... took a while to do the upgrade
The answer appears to be yes for al32utf8.
See MetaLink document # 119164.1
You'll have to read the fine docs or ask support
about al16utf16.
Jared
On Tuesday 01 April 2003 17:48, Godlewski, Melissa wrote:
list,
I've searched the faq list and metalink. It appears the database character
There is a very dangerous virus just being concocted in Redmond, WA.
It is enormous, it will make your PC unstable and very insecure and
you'll lose a lot of time and money trying to fix it.
-Original Message-
Sent: Wednesday, April 02, 2003 7:44 AM
To: Multiple recipients of list
Mike,
Hope this is not too late. I just had time to read some email from the
list. Please check note:102717.1 and 149393.1. That's what you needed.
joan
mike mon wrote:
We have ORACLE 9ir2 on SUN Solaris. We plan to use
Java on ORACLE very soon and need you help.
1. how to check the
Title: Message
Sun's FAQ on java hotspot VM performance (http://java.sun.com/docs/hotspot/PerformanceFAQ.html)includes
this interesting question:
My application uses a database and
doesn't seem to scale well. What could be going on?
Oracle provides two types of database
Peter:
One of the first things we do after installing Oracle is
to modify dbshut to 'shutdown immediate'. We have
had no side-effects from this change.
Cheers,
Mike
-Original Message-
Sent: Wednesday, April 02, 2003 7:04 AM
To: Multiple recipients of list ORACLE-L
I have one Oracle
You could look into Oracle Lite, that's the smallest footprint Oracle DB that I can
think of although I believe it's for Pocket PC and Palms. Don't know what the
licensing cost is but it sure ain't free. And you should tell your users no matter
what database engine you use. They may have to
Title: RE: DBLink to SQL Server problem
since you are going to sqlserver - I wonder if you need to place the following on the object/database
... from dbname.owner.table@msql
I haven't seen the doc you mention(and forgive me if this is redundant info you know)-but SQL has the concept
Peter,
I modified to shutdown abort, starup then shutdown immediate.
joan
Schauss, Peter wrote:
I have one Oracle instance which supports an application
server which always maintains a database connection.
The UNIX system administrator tells me that this instance always
hangs when she
what are pro/cons of having big redo log files ?
Ihave high log switch at peak ours ( alomost 30 /hr ) . current logfile
size is 30M .
8.1.6. (hp-ux)
-ak
Kirti,
Is it a bad thing?
Igor
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, April 02, 2003 10:28 AM
I was told that the tool creates, and uses, SPFILE after the upgrade...
- Kirti
-Original Message-
Sent:
Once upon a time, I had a developer come to my desk complaining that their
query ran very poorly that day, Monday, and that it ran fine on Friday. And
since we had a snapshot of the DB as of that Friday, the dev showed me. The
dev also said that the only change was that WE changed the statistics
Peter,
Shutdown immediate would be a better choice. Might also be a good idea to
have the app server process stopped prior to the database instance being
shutdown.
I have seen apps that have left ghost connections or go nuts when the
database disappeared (bad error handling I guess).
david
Thanks Igor. I figured it out. I need double quotes around the column name and it
works. Didn't see that mentioned in TFM.
1* select mpp_id from [EMAIL PROTECTED]
tdispach select mpp_id from [EMAIL PROTECTED] where mpp_id = 'LESS';
mpp_id
LESS
Thanks,
Dave
-Original
Title: RE: RMAN question (figured out if anywone is interested)with another question appended. :)
Apparently the command:
backup database format '/oracle_backup/ASTU/%U'
(current controlfile);
..places the controlfile in $ORACLE_HOME/dbs, but:
backup database format
It would be sort of cool to have things like direct insert (append hint),
bulk collect into, varray - perl array mapping and alike in Perl. That
would
be much more useful then flogging a dead horse like Oracle7. I don't use
oraperl
syntax for ages now. All my reports are using DBD syntax.
We do shutdown abort. But we do checkpoint before shutdown abort i.e,
alter system checkpoint;
shutdown abort;
Then, while bringing up, we do
startup restrict;
shutdown immediate;
startup
Rao
-Original Message-
Sent: Wednesday, April 02, 2003 11:34 AM
To: Multiple recipients of
Title: RE: DBLink to SQL Server problem
Greg,
I got it to work. The Docs only tell you part of the story. Let me
know if you need any help in setting this up since I have spent a few days
trying to get this working.
Dave
-Original Message-From: Loughmiller, Greg
[mailto:[EMAIL
Yes, that should be a standard practice any time you perform an new Oracle install.
Otherwise, that database will problably always hang waiting for all sessions to
disconnect before completing the shutdown.
I believe the latest versions of Oracle have corrected that issue in the dbshut
script.
Title: Message
I've
gone to using the thin driver exclusively, as (counter-intuitively, I know) it
performs better than the OCI driver. Plus it's easier to
port...
-Original Message-From: Rick Stephenson
[mailto:[EMAIL PROTECTED] Sent: Wednesday, April 02, 2003 7:29
AMTo:
Is if you aren't expecting it
-Original Message-
Sent: Wednesday, April 02, 2003 10:39 AM
To: Multiple recipients of list ORACLE-L
Kirti,
Is it a bad thing?
Igor
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, April 02,
Title: RE: Query through database link gets lost
Are all these database similar versions of Oracle, or are they all different versions?
When I did something similar I had my monitoring script connect to a database, poll for the necessary information, disconnect, and then connect to another
I also started doing this a couple months ago and have not had a shutdown hang since.
Dave
-Original Message-
Sent: Wednesday, April 02, 2003 11:04 AM
To: Multiple recipients of list ORACLE-L
We do shutdown abort. But we do checkpoint before shutdown abort i.e,
alter system
Title: RE: Do triggers cause a context switch between SQL PL/SQL
Well yes. I was pointing out a second way to write the query that avoided selecting from dual. But the time it takes to run the query is the same in both examples.
-Original Message-
From: Jamadagni, Rajendra
I'm not using the dbua since I cannot use X applications from home due
to the firewall we have.
I've now upgraded 3 8.1.7.3 databases to 9.2.0.2. One of these was a
very little play database I created just to test the upgrade process.
The other 2 are fairly small (35-40 GB) test databases.
Title: RE: Whose function is executing.
Could this script from Ixora help?
How can I tell if a procedure/package is running?
http://www.ixora.com.au/q+a/0110/30141015.htm
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]
Is there a way to see whose
Igor,
It depends.
If you are not aware of what the tool does, you will get caught by surprise (like my
co-worker;) May be there is an option to not create the SPFILE.. I didn't use the tool
when I upgraded a few my databases to 9i.
But, AFIAC, I am staying away from SPFILE, as long as
Title: RE: DBLink to SQL Server problem
Surround your column and table names with double-quotes (select mpp_id from...). I suspect that your SQL Server table was specified with lower-case columns.
-Original Message-
From: Farnsworth, Dave [mailto:[EMAIL PROTECTED]]
Sent:
I guess they think that no one should use TAF, which requires the thick
driver.
The poor scalability of the app couldn't have anything to do with the
application.
Could it? ;)
Jared
Rick Stephenson [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
04/02/2003 07:28 AM
Please respond to
Probably, because without double quotes Oracle was converting them to
upper-case (on Oracle side before sending SQL to SQLServer) as it usually
does, and they are not defined as upper case in SQLServer.
So, double quotes prevented implicit conversion.
Igor
- Original Message -
To:
Joshua,
The correct answer is: it depends.
It depends on how fast the response time from the database needs to be.
It depends on how much data you have.
If your database and archive logs and everything else your app needs
will never be more than 48 Gig, then you may want to create 3 mirrored
We replace the simple shutdown command with:
shutdown immediate
startup restrict
alter system switch logfile;
host sleep 10
shutdown immediate
We recently installed 9.2.0.2-64bit on AIX. As of that release, Oracle is
still shipping dbshut with simply
Scott,
This is quite a list you have compiled.
I wouldn't subtract anything.
The only thing I could think of to add was in the Scalability section.
This section seems to concentrate on using Oracle technologies
to enhance scalability, but there is another level that I think needs
to be
Only if you're not aware of it. I started editting init$ORACLE_SID.ora like
crazy
and parameter changes would have no effect whatsoever. I thought for a
moment that I've
enterd the twilight zone but then I resorted to the unthinkable: I read the
documentation.
I know I shouldn't have done it, but,
On Wed, 2 Apr 2003, [EMAIL PROTECTED] wrote:
Then, while bringing up, we do
startup restrict;
shutdown immediate;
startup
Why? Doesn't it start up fine the first time?
--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton
--
Please see the official ORACLE-L FAQ:
My desktop here at work was infected with that virus.
All attempts to eradicate it have failed.
Fortunately, I have another older machine under my desk
as well that was infected with RH80, which actually counteracts
the other virus.
Jared
Gogala, Mladen [EMAIL PROTECTED]
Sent by: [EMAIL
So why would the sql statement used to create a view run faster
(significantly) than selecting from that view built with the same sql
statement?
thanks,
David Ehresmann
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Ehresmann, David
INET: [EMAIL PROTECTED]
Thanks,
I've found some on asktom also.
Stephane
-Original Message-
Litchfield
Sent: Tuesday, April 01, 2003 3:04 PM
To: Multiple recipients of list ORACLE-L
I seem to be missing some of the replies etc to this so apologies for
repeating anything anyone else has said.
1. A BCHR of
Schauss, Peter wrote:
I have one Oracle instance which supports an application
server which always maintains a database connection.
The UNIX system administrator tells me that this instance always
hangs when she tries to shut down the system. The other instances,
which do not support a 24x7
Also in the dbshut, change the connect internal to use sqlplus and / as
sysdba as the connectivity string. This is the approved method for
Oracle8i and Oracle9i.
Reginald W. Bailey
IBM
Kirti,
Thanks.
My question was not in regards to the tool, but in regards to use of SPFILE
in general.
Igor
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, April 02, 2003 12:23 PM
Igor,
It depends.
If you are not aware of what the
Ellison: Linux Will Wipe Microsoft Out Of The Data Center
In dramatic terms, Oracle Corp. Chairman and CEO Larry Ellison
predicted the open-source operating system will wipe Microsoft off the
face of the earth in the battle for the data center market.
Ron,
I've been to the seminars in the past. The question is not what does Oracle
have to say, but what do others who've made the move have to say.
Dick Goulet
-Original Message-
Sent: Tuesday, April 01, 2003 4:44 PM
To: Multiple recipients of list ORACLE-L
Dick,
check out
I have a very simple code:
begin
dbms_output.enable(1000);
dbms_output.put('hello');
end;
but the dbms_output is not sending the output to the
screen. I've already stablished set serveroutput on
and also used set serverout on
and still not working, this is a very frequent
situation and
Shutdown abort is pretty drastic, are you sure shutdown immediate didn't
work?
Well said. This topic has been circulating in many DBA forums for a long time.
Shutdown immediate does rollback and will take time if no.of users
is high. On the otherside, shutdown abort simply takes the db down and
Ehresmann, David wrote:
So why would the sql statement used to create a view run faster
(significantly) than selecting from that view built with the same sql
statement?
thanks,
David Ehresmann
David,
A view is a STORED object, which means that it executes using a plan
which was
Title: RE: Why dbms_output is not working
You need a dbms_output.put_line to complete the output line.
e.g.
SQL set serveroutput on
SQL begin
2 dbms_output.put ('Hello') ;
3 end ;
4 /
Procedure PL/SQL terminee avec succes.
SQL begin
2 dbms_output.put_line ('Bonjour') ;
3 end ;
4 /
Title: RE: Oh Dear, Mr. Ellison's at it again
-Original Message-
From: Goulet, Dick [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, April 02, 2003 10:45 AM
To: Multiple recipients of list ORACLE-L
Subject: Oh Dear, Mr. Ellison's at it again
Ellison: Linux Will Wipe Microsoft
Run autotrace or sql_trace and determine if the execution plans are
different. If they are the same, increase the sql_trace level and find
out what the wait events are.
--
Daniel W. Fink
http://www.optimaldba.com
IOUG-A Live! April 27 - May 1, 2003 Orlando, FL
Sunday, April 27 8:30am - 4:30pm
Multiplexing redo logs has nothing to do with the archive mode. Logs are
multiplexed so that an error writing to one of the members in a group does
not cause the instance to terminate.
Myth - If you use disk mirroring, you don't need to multiplex your redo logs.
Reality - Mirroring only
Title: Re: Why dbms_output is not working
Try
begin
dbms_output.enable(1000);
dbms_output.put_line('hello');
end;
At 10:55 AM 4/2/2003 -0800, you wrote:
I have a very simple code:
begin
dbms_output.enable(1000);
dbms_output.put('hello');
end;
but the dbms_output is not sending the output
Title: RE: Why dbms_output is not working
Don't know what to tell you. I don't remember ever seeing output disappear if you use dbms_output.put_line.
Of course you have to remember to say
set serveroutput on size N
where N is the number of bytes that will be output
and if you are doing this
At first, we do shutdown immediate, then startup. But we do have couple
times hang there and couldn't do the cold backup. Since changed to
shutdown abort, startup and shutdown immediate, we don't have any
problem at all. our database is in archive mode. Since our production
database has to refresh
Title: RE: Oh Dear, Mr. Ellison's at it again
Jeremy,
True, you should watch what you wish for because it may
well come true!!
RIP Oracle???
Dick
Goulet
-Original Message-From: Jeremy Pulcifer
[mailto:[EMAIL PROTECTED]Sent: Wednesday, April 02, 2003
2:14 PMTo: Multiple
Title: Re: Why dbms_output is not working
You
need put_line ... simple put() won't work as the line is not complete. At-least
add dbms_output.new_line;
Raj
Rajendra dot Jamadagni at nospamespn
dot com All
try dbms_output.put_line('hello');
or
dbms_output.put_line('') after
dbms_output.put('hello');
HTH
Andreas
-Original Message-
Sent: Wednesday, April 02, 2003 8:55 PM
To: Multiple recipients of list ORACLE-L
I have a very simple code:
begin
dbms_output.enable(1000);
This topic is getting interesting once more. Lets contribute.
Multiplexing redo logs has nothing to do with the archive mode.
Take a situation wherein the db is in NOARCH mode with only one member per group
(default setup). The dba gives shutdown abort and upon starting for some reason the
Thanks Stephane (1000 pardons on the earlier spelling FO-PAH!).
-Original Message-
Faroult
Sent: Wednesday, April 02, 2003 2:29 PM
To: Multiple recipients of list ORACLE-L
Karen Morton wrote:
Stephanie,
Cough, cough.
I've ran into the exact same thing that statistics don't always
Try using PL/SQL tracing , available in Oracle8i and Oracle9i.
DBMS_TRACE.SET_PLSQL_TRACE (trace_level INTEGER).
RWB
Reginald W. Bailey
IBM Global Services - ETS SW GDSD - Database
Hi all. I've just entered the world of Oracle on Windows. My first
question regards the mechanism used to run jobs that are created using
OEM.How does OEM execute RMAN, or export, for example?
Thanks
Paul Baumgartel
__
Do you Yahoo!?
Grin I thought the same thing. Being the hubristic person that he is I doubt he will
ever think about it himself...
--Walt Weaver
Bozeman, Montana
-Original Message-
From: Goulet, Dick [mailto:[EMAIL PROTECTED]
Sent: Wednesday, April 02, 2003 11:45 AM
To: Multiple recipients of
You mean that MySQL and Postgres will wipe out Microsoft? :)
-Original Message-
Sent: Wednesday, April 02, 2003 1:45 PM
To: Multiple recipients of list ORACLE-L
Ellison: Linux Will Wipe Microsoft Out Of The Data Center
In dramatic terms, Oracle Corp. Chairman and CEO Larry Ellison
Chris - Congratulations on finding your problem. I have the RMAN log file
emailed to me for each backup. This means more to look through. What you
describe doesn't sound hard though.
Dennis Williams
DBA, 40%OCP, 100% DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent:
Dear All
Can anyone of u throw light on how remote dbas work. I would appreaciate if
any whitepaper / document on this topic is sent to me directly at
[EMAIL PROTECTED] or [EMAIL PROTECTED]
TIA
Best Regards
Ramesh D. Papnoi
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
What does this have to do with archivelog mode? In the bizarre
scenario in which you lose a log between the time you shut down and
started up, you are screwed with or without archivelog mode.
--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton
On Wed, 2 Apr 2003, GovindanK wrote:
This topic
Drop the index and recreate it without parallel clause. If your table is
having degree 1 , then make it 1 and then recreate index. It looks a old
bug for bitmap index on a table having degree 1.
Regards
Rafiq
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL
1 - 100 of 144 matches
Mail list logo