behind as you will lose
the data in case of power failure.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, September 23, 2002 6:53 PM
Cache Management on Storage Box :-
Qs Which is Better ? Write-Behind OR AUTO
Title: OT: MIcrosoft Blackmail
What exactly is your problem?
Lets say that you are a factory that sells paper.
You need to buy a computer system.
One supplier also sell printers and the other advocate
paperless office.
All things being equal, which one will you give your
business to??
Hello Peter
We have an infrastructure division that divides into two departments:
system programming and DBA.
Organization chart for us will be:
CEO - CIO - Infrastructure - DBA.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent
have the right to tell a PRIVATE
company who to deal with?
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, September 26, 2002 5:18 PM
Yechiel - But all things are NEVER equal. So companies end up doing stupid
things
I think that this require a deeper investigation.
Last night I tried to use alter system sql_trace=true and it did not work
either.
I had to put sql_trace=true in init.ora and to bounce the database.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL
Add a local disk to one of the machines and put your Rman catalog there.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, October 04, 2002 8:31 PM
List,
With all of the recent discussion and the forth coming books
Just deny login if your trigger does not know the program.
Check the archives for example scripts for login triggers.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, October 03, 2002 8:08 PM
Oups ! you're right
Maybe he got the wrong name.
Can you connect via SQLPLUS from his machine?
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, October 08, 2002 7:33 PM
I don't work with Oracle Reports but one of my co-workers does. His
Title: Message
Hello all
HELP - and I am not an idiot.
Oracle 8.1.6.3.4 on NT.
We have a problem that the datafile for the
application tables autoextended from 3.9 GB to 4.1 GB.
We are getting ora-01115 errors and the datafile is
offline.
We tried export but it gets the same error.
The
I think that you will have an update to the
sequence number EVERY time instead of every 20 times. That's mean I/o for every
nextval.
Yechiel AdarMehish
- Original Message -
From:
Tim Gorman
To: Multiple recipients of list ORACLE-L
Sent: Thursday, October 10, 2002
Title: Message
Thanks for all the replies.
We called Oracle support and they come with the DUL
utility and
extracted the data.
As Iwrite this e-mail imports are
running.
Concurrently wetried to restore the last full backup
from more then 2 weeks ago\
and found about 1 day worth of archive
build database and import
again 2-3 hours more. So I am stuck here at least until 22:00 to 23:00.
RR
Yechiel Adar
Mehish
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Yechiel Adar
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538
The studies I remember on the subject say that talking while driving put you
in the same risk factor as drunk driving .
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, October 15, 2002 12:03 PM
There's always some
Forgive me for asking, but if you have enough CPU for all why do you need
control?
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, October 15, 2002 12:03 AM
Thats what we are planning on doing here with our data
we can return
to replication.
Yechiel AdarMehish
- Original Message -
From:
Yechiel
Adar
To: Multiple recipients of list ORACLE-L
Sent: Thursday, October 10, 2002 11:53
PM
Subject: Re: ora-01115 after datafile
autoexetend from 3.9 GB to 4.1 GB
Thanks for all
I now this thing. Had it two weeks ago.
Call Oracle and ask them to come with the DUL (database unload) utility.
Your database is OUT.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, October 23, 2002 8:58 AM
OS:WIN2K
they will not get ORA-N but will give nice error messages
to the users, but put checks into the database.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, October 23, 2002 7:45 PM
The developers working on our new VB app are also
Thanks Mladen and Lee
I am always amazed by the ability and knowledge of the people on this list.
You guys (all the list members) always come up with many options to do
something so if some option does not work you have others.
Yechiel Adar
Mehish
- Original Message -
To: Multiple
Hello Viktor
I think that the problem is not with oracle.
If you have the same nls_lang on the client and the
database
oracle will not do translation but will work on the
principal
of GIGO (garbage in, garbage out), meaning what you put
in
is what you get.
You need a program on the client
Title: Archive files and their Management
Our policy is to keep archive for the last 2 days
at least.
We are doing daily backup so it gives us the option to
restore from the last backup or the one before
without
restoring archive logs.
Yechiel AdarMehish
- Original Message -
Hello George
I think that you need to tune the first statement the do the most gets and
the most i/o.
The same statement also access the most rows.
It is fired up about every 5 seconds and is very resource consuming.
I am not a tuning expert but this is my 0.01$ worth.
Yechiel Adar
Mehish
Hello Tim
I beg to differ. Without raid it is better to put indexes
and tables on different disks and controllers.
This way Oracle can do I/O to a table for user A while
doing I/O to the index for user B.
It is better if you can find the high I/O areas of the
database and split them across
Hello Bob
We are working with 8163 on NT and windows 2000 and the status is that they
will help you find patches but will not backport or develop new patches for
this release.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday
and Smith using this application you have 3 named
users.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, October 22, 2002 1:58 PM
Thanks folks for your replies on my initial query. Just to clarify by
example, how many named
Welcome
Yechiel Adar
Mehish, Israel
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, October 22, 2002 11:18 AM
On Monday 21 October 2002 18:38, Ball, Terry wrote:
I haven't recieved anything from this list since friday evening. I know
What kind of client do you have?
Maybe the install installed only net8 without the utilities?
Check if you have exp*.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, October 22, 2002 3:14 PM
but my friend...
i gave
Known problem with P4 is the Java jit.
Copy the installation CD to disk, rename symcjit.dll to symcjit.old and try
again.
If still not working modify oraparm.ini (in the install directory) to:
jre_memory_options=-nojit -ms16m -mx32m.
Worked for me.
Yechiel Adar
Mehish
- Original Message
ifferent tablespaces, but for decisions on placement
of datafiles upon devices, use empirical performance data only.
- Original Message -----
From:
Yechiel
Adar
To: Multiple
recipients of list ORACLE-L
Sent: Tuesday, October 22, 2002 3:43
AM
Subject:
ng mentality~ (no pun intended).
ORACLE will feast on a disk cache especially with 11i applications,
butthats not to say it doesn't
help.
Please correct me as i'm looking for guidance.
=)
-----Original Message-From: Yechiel Adar
[mailto:[EMAIL PROTECTED]]Sent:
I/O they
generate.
By focusing on the I/O statistics rather than
whether they are tables or indexes, one can make better determinations on how
to distribute I/O across non-RAID devices.
Hope this helps...
-Tim
----- Original Message -
From:
Yechiel
Adar
we had the same problem and we found that oracle use the standard port only
to make the initial connection. All the traffic after that is done on
different ports. So you need to open the range that oracle use in the
firewall.
Yechiel Adar
Mehish
- Original Message -
To: Multiple
Hire a special company that handle this.
We are doing it to see how unbreakable are our servers.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, October 24, 2002 2:08 PM
Hi,
how can I be sure
Title: Flat file generation integrity ideas...
I do not see how the file can get
"scrambled".
You write it out ok.
The ftp is guaranteed.
So what is the problem.
I will go along with the suggestion to zip it. It saves on
the ftp time and also gives you some protection.
Yechiel AdarMehish
with
the DUL utility to help get the data out and rebuild the database.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, October 24, 2002 8:26 PM
Hello All,
I have heard several times that if the SYSTEM tablespace runs out
Full import will rebuild the tablespaces.
browse the export file and you will see the commands inside.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, October 24, 2002 9:25 PM
To do an import from a full export
Where?
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, October 24, 2002 4:44 PM
Just a note that my new book Oracle9i RMAN Backup and Recovery (with
co-author Matthew Hart) is out now! Enjoy!
And remember, if you like
Hello all
How can I run startup.bat file when database is up.
I tried using the HOST command in trigger but it does not work.
Something like: 'host d:\oracle\scripts\startup.bat' in the trigger.
Win2000, Oracle 8.1.7 or 9.2.0.
Yechiel Adar
Mehish
--
Please see the official ORACLE-L FAQ: http
to a
standby database.
Maybe this method can work for you.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, October 24, 2002 6:58 PM
Could you use an external procedure or java call? Metalink Tom Kyte's
book
have good
the new DB.
If I can decrease the initial extents then I will export and import the
whole schema and have enough space.
Yechiel Adar
Mehish
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Yechiel Adar
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051
.
Yechiel Adar
Mehish
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Yechiel Adar
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
select add_month(sysdate,-7*12) from dual;
HTH
Don't ask for details. That was 7 years ago. I don't even remember how
old I was then.
Yechiel Adar
Mehish
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Yechiel Adar
INET: [EMAIL PROTECTED]
Fat City Network
But he was talking about sending, not receiving.
and he says that the ftp is assured to work ok.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, October 25, 2002 2:48 AM
Unfortunately it is a trust issue...
Trust me
is empty.
If you are on windows check that values in the registery for oracle home.
Look for name=ora_sid_pfile. The value points to the pfile.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Saturday, October 26, 2002 5:43 PM
My
We had to decide the same thing.
As soon as I saw that support is down in 9 months I decided to go with 9.2.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, October 29, 2002 3:53 AM
Thanx Joe.
let me think about
Title: RE: List of Rows Updated
I think that it depends or the needs.
If you need a running log then auditing may me
better,
but if you need to find who has done what from time to
time
I think that logminer is better as it does not use
resources
all the time.
Of course, do not forget that
Not a silly analogy - a very good one.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, October 30, 2002 3:29 AM
As with any cached I/O subsystem technology (i.e. RAID-S, NetApps, etc),
please visualize a water tank
Here is a message I found in my mail.
Change the:IF loc_username='TESTLOGIN' THEN RAISE kill_Login;
to whatever test you need.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, August 09, 2002 8:13 PM
Dick,
Here
When you get files from an external source no amount of checking is enough.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, October 29, 2002 6:19 PM
Actually, I am sending and receiving files.
They will be handling
We have an OLTP system that I thought will benefit from first rows.
The sad fact is that when I set optimization to first rows the response
sucks.
Do some testing, as you can change this anytime.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL
1/1000 chance
to get wrong data.
Which odds will you bet on?
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, October 29, 2002 2:18 PM
List,
I'm always keen to refresh on database comparisons so thanks for
everyone's
That was exactly my point.
It is NOT 6 of one , half dozen of the other.
You commit 1000's of times for each rollback.
So the data you read is incorrect while you read it with enormous odds that
the changes will be committed.
Yechiel Adar
Mehish
- Original Message -
To: Multiple
on the drive.
Has anybody encountered this problem?
Do you know what can cause it?
What I need to do in order to prevent this from happening again?
Yechiel Adar
Mehish
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Yechiel Adar
INET: [EMAIL PROTECTED]
Fat City
then you will probably get a more specified answer.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, November 05, 2002 2:13 PM
hi,
can anyone suggestion w/c platform should i used to run oracle? wat are
the
things
are on 8.1.6 on NT and we do not use global names = true.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, November 05, 2002 4:53 PM
Hello
We currently have two Identical servers (identical in terms of both
Hardware
mem# 0:
D:\ORACLE\ORADATA\MUSK135\DATABASE\LOG10.ORA
Sun Nov 03 11:39:07 2002
ARC1: Beginning to archive log# 7 seq# 4154
ARC1: Archiving not possible: No primary destinations
ARC1: Failed to archive log# 7 seq# 4154
Yechiel Adar
Mehish
- Original Message -
To: ORACLE-L [EMAIL PROTECTED]
Cc
the
archive log, like when the disk is full. Then the redo log will fill up and
the instance will stop.
After I connect as internal and do:
archive log stop;
archive log all;
archive log start;
everything is back to normal.
Yechiel Adar
Mehish
- Original Message -
To: [EMAIL PROTECTED
There is another view, DBA_2PC_NEIGHBORS.
Maybe there is some info there.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, November 05, 2002 5:58 PM
On Tue, Nov 05, 2002 at 06:33:44AM -0800, [EMAIL PROTECTED]
wrote
(archive log stop; archive log all; archive log start;)
and the database continued to work.
Yechiel Adar
Mehish
- Original Message -
To: ORACLE-L [EMAIL PROTECTED]
Cc: Yechiel Adar [EMAIL PROTECTED]
Sent: Tuesday, November 05, 2002 8:17 PM
Yechiel,
No OS errors here. You may want to look
version 5 to version 7
Propogating archive 3 destination version 5 to version 7
Propogating archive 3 state version 5 to version 7
Propogating archive 4 destination version 5 to version 7
Propogating archive 4 state version 5 to version 7
Yechiel Adar
Mehish
- Original Message -
To: Multiple
First rule: Do not mix OLTP and datamart.
Datamart access is very heavy and complex SQL's that will impact your OLTP
system.
I think that an NT with 2-4 CPUs and a lot of memory will do (a not so
educated guess).
Controller with a lot of cache memory and fast disks (15,000 rpm).
Yechiel Adar
The list of 9i options can be found at:
http://www.oracle.com/ip/deploy/database/oracle9i/index.html?packagingandopt
ions.html
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, November 06, 2002 4:49 PM
I have given up
If I remember correctly ( a big if) there is an option in the OEM menus to
set the preferred credentials.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, November 06, 2002 5:04 PM
Come on folks...Help me, I am stuck
Hi Tim
We just signed a contract for external storage system from EMC and the
configuration is going to be:
Regular servers - connect as Nas
Database servers - connect as San.
If I remember correctly Nas use SCSI connections while San use fiber.
Yechiel Adar
Mehish
- Original Message
Hi Paulo
When creating an index, or CTAS, oracle use temp segments
while building and rename them after the build finish. So if you do not have
enough space you will get: unable to allocate TEMP segment.
Yechiel AdarMehish
- Original Message -
From:
Paulo Gomes
To:
Title: Adding more space to server
Is the server dedicated to Oracle data files or you
have more data in it.
We have for each server a lot of data that was loaded in
the database
+ a daily export.
I saved a lot of space by compressing the folders for the
data and the export.
Yechiel
You do not need to change the primary key unless different user names can
have the same userid.
Just add a unique + not null constraint on the user name column.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, November 07
problems. There is a
reference to doc# 66320.1 in this document. The 66320.1 document will
explain to you how to change the character set. It worked for me in 8.1.6 on
NT.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday
on
the historical data so the structure will remain the same as in production.
We are doing it in ADABAS on the mainframe.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, November 07, 2002 11:24 PM
Well, if worst comes to worst
My guess will be that PHYRDS is the count of start i/o's. Each start i/o
read mutilblock_read_count blocks from the disk.
The data buffer that you read with each start i/o is the same: 8 blocks of
8k or 16 blocks of 4k. So you get the same number of start i/o's.
Yechiel Adar
Mehish
- Original
Title: sqlplus ~no~output
To do it in a command file -
@sfsfasdf.sql.
Set termout off does not work for commands executed from
the command line.
Yechiel AdarMehish
- Original Message -
From:
Markham, Richard
To: Multiple recipients of list ORACLE-L
Sent: Monday,
Thanks for the link Jared.
For now, I just bookmarker it.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, November 13, 2002 3:23 PM
Check out OraC, written in Perl of course. :)
http://www.tux.org/orac-dba
I heard in Oracle Week in Israel that Oracle is planing to add Linux to
their supported products and provide help desk for it.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, November 13, 2002 4:48 PM
You're right
Check what SP is installed on the server.
This is a common problem with Y2K SP1.
Upgrade to SP2.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, November 13, 2002 5:18 PM
All
Ive finally returned to my desk from
Title: How-To or Good Practices on Code Releases
Whenever I install a new release of software my
boss wants to know:
How do you return to the old version if this does not
work?
For each install script require an undo
script.
We are using toad to compare schemas and it can also
generate
,
but having an opinion is an
art!
-Original Message-From: Yechiel Adar
[mailto:[EMAIL PROTECTED]]Sent: Wednesday, November 13, 2002
11:04 AMTo: Multiple recipients of list
ORACLE-LSubject: Re: How-To or Good Practices on Code
Releases
Whenever I install a new release
No matter how you do it, do it in parallel.
Export and import, or CTAS, by schema or tables so you can run them in
parallel.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, November 13, 2002 7:03 PM
Qs What would
Run your script at 23:58 :-)
Yechiel AdarMehish
- Original Message -
From:
Barbara
Baker
To: Multiple recipients of list ORACLE-L
Sent: Wednesday, November 13, 2002 8:24
PM
Subject: OT ksh day of week
yesterday
Will someone take pity on this poor VMS'er
Hi Bob
I took a look at the database service one of our servers.
service properties:
startup program: d:\oracle\ora816\bin\oracle.exe abcd (the sid of the
database).
startup mode = automatic.
logon as local system account.
allow service to interact with desktop.
Yechiel Adar
.
Yechiel Adar (who does not have any hidden/unhidden connections to DataBee)
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, November 13, 2002 9:23 PM
one of the things I'm experimenting with right now, based on a request
from
clients
.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, November 14, 2002 12:03 PM
Hi all,
A 3rd-party software vendor is coming in to install their application on a
new Windows 2000 server. This application uses Oracle, so
Put a copy of tnsnames where MS ODBC wants it?
Check if MS ODBC support name server or Directory services?
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, November 15, 2002 4:58 PM
We are testing the ORACLE 9iR2
that I know use DB2. I
have not heard of anyone using Oracle on mainframe (at least under IBM MVS).
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Saturday, November 16, 2002 12:24 AM
I just found out today that we have a major
does not do recovery. You need to restore the archive logs
that you think you need and then do recovery yourself.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, November 18, 2002 12:23 PM
Is no-one out there using
Thanks for a clear and illuminating article;
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, November 18, 2002 7:08 PM
One thing my article did not cover was of course the
possibility that you end with up
log that were created during the backup.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, November 18, 2002 12:23 PM
Is no-one out there using NetBackup???.
Without wishing to sound rude I'll assume a non-response indicates
if my questions are somewhat trivial but we need a decision tomorrow
morning (in 18 hours) as they start doing some training session on the
system on Sunday and time is short.
TIA
Yechiel Adar
Mehish
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Yechiel Adar
INET
We just bought EMC Cellero.
I do not know the reasons, just that they won the contract.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, November 19, 2002 8:49 PM
Hi All,
We are considering the following 3 SAN
We just bought EMC Cellero.
I do not know the reasons, just that they won the contract.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, November 19, 2002 8:49 PM
Hi All,
We are considering the following 3 SAN
If you can take the database down for 1.25 hours.
I will hesitate to startup the database with time
less then last closing time.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, July 22, 2002 8:33 PM
Hi Guys,
I need
On the subject on analyzed:
We are doing analyze compute statistics and it takes about an hour.
Do you know of ways to speed it up?
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, July 24, 2002 3:54 PM
On Wed, Jul 24
and / or system, that can go wrong in
this situation.
To be on the safe side shut the database down for 1.25 hours.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, July 24, 2002 3:38 PM
yes , but time based incomplete
Thanks all for your advice. Will check an option to do estimate.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, July 24, 2002 7:23 PM
At the last Open World I attended a couple of sessions
where the general advice
Thanks Ian.
Have a beer on me, you earned it with this info.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, July 24, 2002 11:51 PM
Ian,
You are likely to win the wager on this one. I discovered the public
when i
Have you checked the regional settings on the server.
Make sure you install the client with language=English USA.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, July 25, 2002 1:08 PM
Hello,
We are on Intel pentium 4
to stop the DB for 1.25 hours So the 2-20 minutes savings
can become a lengthy process.
I will use abort in the rare cases where there is no other option but not as
everyday practice.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent
We used it in testing and had no problems.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, July 25, 2002 5:58 PM
We're doing that and haven't had any problems.
Bill Carle
ATT
Database Administrator
816-995-3922
Eric, thank you for your illuminating notes on the
reason they hate us.
blowing steamJust two
points:
1)A few days ago a bomb explode in India killing 50
people.
I did not heard ANY remarks from
anybody condemning this.
2) All the people who cry for the Palestinians and demand
they
Hello Leslie
Did you remember to clean up c:\program files\oracle as well.
This is where Oracle keeps the install log and files.
I think that if you delete also this folder Oracle will start the install
from fresh.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients
Did you check the registry on the machine that you execute sqlplus on to see
if there is nls_date_format there?
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, July 30, 2002 7:38 AM
Hi,
The default date format
I agree. If you have one client record and one supplier record put the
address there without the need for separate tables.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, August 01, 2002 1:02 AM
If this is the way you
1 - 100 of 505 matches
Mail list logo