Sorry
I meant to say partitioning is not available in SE - not replication.
Yechiel Adar
Mehish
- Original Message -
To: <[EMAIL PROTECTED]>
Sent: Thursday, May 09, 2002 3:21 PM
Yechiel - Do you have more information (9i and replication)? Previously
there was a document on Or
drive).
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Friday, May 10, 2002 12:47 AM
We have an 8.1.7 SE database on a server which is currently NT4 SP6. The
System Admin group wish to upgrade the server to W2K and propose
quarter.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Friday, May 10, 2002 5:58 PM
> Are these addons to OEM worth buying?
>
> Thanks
> Peter Schauss
> Northrop Grumman Corporation
> [EMAIL PROTECTED
Hello Andrey
KISS - Why write code to do what oracle does for you?
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Monday, May 13, 2002 6:23 PM
> Dear list !
> I need a very simple thing : each time a certain f
Hello Andrey
KISS - Why write code to do what oracle does for you?
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Monday, May 13, 2002 6:23 PM
> Dear list !
> I need a very simple thing : each time a certain f
Peter thanks.
I forgot that null insert is not converted to the default.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Monday, May 13, 2002 11:03 PM
> Hello Andrey
>
> The correct answer depends on what you
Got Oracle Update from Xephon today (May
2002).
The lead article is about online redefinition by Sameer
Wadhwa
from NuGenesis Technologies.
His article agrees with you.
Yechiel AdarMehish
- Original Message -
From:
JOE
TESTA
To: Multiple recipients of list ORACLE-L
Chris
You wrote "I just want to call it and get the one value it returns."
I think that procedure does not return values, functions does.
If you want to get value from a procedure you have to pass
a parameter that the procedure will return the value in.
Yechiel Adar
Mehish
round, Thomas Jefferson picks him up
and hurls him back to the gate to be judged.
As Osama awaits his journey to his final very hot destination, he
screams "This is not what I was promised!"
An angel replies "I told you there would be 72 Virginians waiting for
you. What did yo
At last something that I have experience in.
Just do the following:
On the target database issue the following:
Alter database rename global_name to donot_trigger;
We had the same problem. This solves it.
The global name has no other influence.
Yechiel Adar
Mehish
- Original Message
Title: Message
None
It is an option (Means you pay).
Yechiel AdarMehish
- Original Message -
From:
Cunningham, Gerald
To: Multiple recipients of list ORACLE-L
Sent: Wednesday, May 22, 2002 6:38
PM
Subject: partitioning
Hi
all,
Does anybody know
wi
users ( parameter in the
application)
to the backup machine and they worked without problems, although the global
name was different.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Wednesday, May 22, 2002 7:28 PM
> Yec
I think that this db will be among the last to upgrade.
Any bugs and (wolla) no more OEM or no more backups and restore. !
Yechiel Adar
Mehish
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Yechiel Adar
INET: [EMAIL PROTECTED]
Fat City Network Services
How about using external table?
You define the table as external having one field.
I think that select * from such table will bring you the lines in order
and then you can do whatever you want with the data.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE
IBM mainframe. Nothing beats these dinosaurs.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Thursday, May 23, 2002 6:08 AM
> Our data warehouse box is nearing it's max capacity so we are looking for
> optio
Upgrade to 9iR2 today.
Rename column does not work in 9.0.1.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Wednesday, May 22, 2002 9:30 PM
> If those times are right... its a functionality you
> should not live
I am looking for the address of oracle news server.
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 FAX: (858) 538-5051
San Diego, California-- Public
Been there, Done that, Works in production.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Thursday, May 23, 2002 3:33 PM
>
> I'd never have thought that this was possible
> in Advanced Replication
That's not panicking, just common sense.
Too many data warehouse projects went down the drain
so you need to learn all you can before starting such project.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Thursday, M
Hello Joe
I think that the main reason is response
time.
An NT machine can get only 4 CPUs.
If you have all the CPUs and memory and the NT does
not carry the load
then it is time to consider a change.
A change can be to Unix or to
clustering.
If you are all NT shop then I would consider
Sorry, I wish that e-mails had a way to attach what I wanted
to say.
I meant news group on the subject of oracle.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Thursday, May 23, 2002 3:53 PM
>
> On 2002
Thanks Joe
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Thursday, May 23, 2002 6:23 PM
> comp.databases.oracle.server
> comp.databases.oracle.tools
> comp.databases.oracle.misc
> comp.databases.oracle.
Title: RE: Database backup question.
You missed the last one. He is PHB
again.
Yechiel AdarMehish
- Original Message -
From:
Whittle Jerome Contr NCI
To: Multiple recipients of list ORACLE-L
Sent: Friday, May 24, 2002 11:43 PM
Subject: RE: Database backup
question.
Hello All
How can I covert all the names from tnsnames.ora to OID?
I do not feel like entering all this data again, by hand, one by one.
Yechiel Adar
Mehish
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Yechiel Adar
INET: [EMAIL PROTECTED]
Fat City Network
working
with machines that are less then P4.
Make them prove their point. !!!
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Monday, May 27, 2002 10:18 AM
> We have outsourced implementation and setup of a sc
I already replaced the three IN with 3 = select count() where month in
(2,3,4)
and it works, but I would like to know why the original didn't.
Yechiel Adar
Mehish
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Yechiel Adar
INET: [EMAIL PROTECTED]
Fat City Ne
Hello
Very simple. Select sample_size from all_tables.
The field contain NULL for unanalyzed tables,
0 (zero) for compute statistics
and sample size from estimate statistics.
Oracle 8.1.6.3.4
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EM
put them on low resource group so one Cartesian select will
not bring the production to halt.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Wednesday, May 29, 2002 12:25 AM
> Hi folks -
> I have received
TED]
618-622-4145
-Original
Message----- From: Yechiel Adar [SMTP:[EMAIL PROTECTED]]
Hello list
I need help in solving ORA-918:
Ambiguous field reference. All the fields are
schema.tablename.fieldname. The SQL has 3 inline queries that are the same but
Hello Gurus
I got this link through SAG-L. Have a try.
www.quest-pipelines.com/newsletter-v3/Crossword_Puzzles/puzzle0502.html
Yechiel Adar
Mehish
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Yechiel Adar
INET: [EMAIL PROTECTED]
Fat City Network Services
before the update:
Select count(*) from table where ...
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Thursday, May 30, 2002 3:48 PM
Hi All!
My client run big update 20,000 statements. I need to know how many ro
Title: how can listener list on two ports for the same db?
Hello Helmut
You need to configure the listener to listen on ONE host
with 2 ports.
The machine name is the same.
You separate the connections via tnsnames.ora on the
client side.
I got a call today that one of our application
ser
.
Boy was he suprised.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Thursday, May 30, 2002 6:51 PM
Gene - C'mon ya gotta give us more details. I have heard that most DBAs
either come from developers or sys admins,
Dave
I do not get these.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Thursday, May 30, 2002 4:43 PM
Jared,
I have been getting these for a few weeks now on all of my posts. It is
only for the name listed belo
I am the one that started it.
I saw that each select from dual cost about 4-5 buffer gets.
Define view on x$dual and select from that view, no buffer gets.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Thursday, May 30,
OPS, sorry
I thought that you mean one update that updates about 20,000 rows.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Thursday, May 30, 2002 5:04 PM
> before the update:
> Select count(*) from
Salary !
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Thursday, May 30, 2002 8:08 PM
> Hello:
> Out of curiosity how would you classify a Jr. DBA, a Mid Level DBA, and a
> Sr. DBA? I know how our HR d
her
than senior DBA's maxing out at infinity? :)
-Original Message- From:
Yechiel Adar [mailto:[EMAIL PROTECTED]]
Sent: Thursday, May 30, 2002 3:10 PM To: Multiple recipients of list ORACLE-L Subject: Re: Jr.DBA, Mid level DBA, Sr.DBA
Salary !!!!!
Yechiel Adar Mehish
So, If I am working a long time why should I now quit and move to work with
them?
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Friday, May 31, 2002 4:19 PM
> Great Company located in Greater Dallas, Texas area (R
Hello Itiu
You wrote:
We have a saying: zillions flies can not be wrong, eat shit.
BTW - We use NT servers.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Sunday, June 02, 2002 2:43 AM
> What's wrong w
Look in v$database column log_mode.
Tested on 7.3.4 on NT.
Work also in 8.1.6 and 9.0.1
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Wednesday, June 05, 2002 7:13 PM
> Anybody knows how to get status of archive
.
TIA
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Thursday, June 06, 2002 4:32 PM
(online redo logs)
NB_ RESENDING in plain text - sorry, Outlook keeps seinding in html no
matter what default i set!
Hi lists,
I am
In NT use task manager and kill it.
In Win95/8 do Alt-Ctrl-Del and kill the dos session.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Monday, June 10, 2002 7:08 PM
> how do you stop an command-line export? pr
are thinking about adding asynchronous replication to replicate
> > the
> > > changes
> > > across wan to a remote site. The problem is that this will load the
> > > production system and the network link (wan is expensive), as the
> > system
> > > gener
Title: Newline char in oracle files
Hello Beth
Had the same problem after upgrading from 81600 to
81634.
I downloaded textpad from the internet and it solved the
problem.
It is also much nicer then wordpad.
Yechiel AdarMehish
- Original Message -
From:
Seefelt, Beth
To:
verify
that the problem is not a bad block/sector on the disk itself.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Tuesday, June 11, 2002 7:28 PM
> I have a system when I issued a select statement, I get the follow
Hello Hanna
Why do not write the data that you want to output to your own table.
Give everyone insert permission and the trigger will write the data.
Later you can query it and see the output.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EM
Hello Bp
The topic was discussed on the list some time
ago.
The trade off seems to be memory vs. CPU.
If I recall correctly MTS use more resources
and dedicated connection use about 3MB for each connection
on NT.
Yechiel AdarMehish
- Original Message -
From:
BigP
To: M
You can see the character set in the export log file.
I browsed one of my exports (816 on NT) and did not see
any indication of character set in the export file itself.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: T
t; > To return to my original
question: > Quest Shareplex - > Any success stories? > Why use this
and not replication? > Ant performance tests
between Shareplex and Oracle replication? > > Yechiel Adar > Mehish > - Original Message
- >
ter one or two days
you do not solve the problem open a TAR.
Why are we paying so much $? Let them work !!!
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
Hello Bp
If you use the sequence for unique identifiers
only,
you do not need to worry about this.
At most the numbers will go from 1234 to 11234
and
continue from there. So what?
Yechiel AdarMehish
- Original Message -
From:
BigP
To: Multiple recipients of list ORACLE
Also thing big $$.
Business Objects is much more expansive.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Friday, June 21, 2002 12:50 AM
> Business Objects is good although the learning curve is p
RS wrote: What kinda name is dual...sounds suspicious..;)
Especially when you consider that DUAL has ONE record only :-))
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Friday, June 21, 2002 5:58 AM
> While you
Title: RE: Textfile into oracle
There is an option for filler fields in sqlldr
control fields.
This way you can skip unwanted fields in the csv
file.
Found it the other day when someone sent me a file to
load
with an extra field in the beginning of the
record.
The format for the field is:
Hello Sam
Why do not restore the archive logs manually?
Ask RMAN to restore the database and then issue
the recover until yourself.
Then you have time to explore RMAN behavior.
BTW - did you backup the 2 weekly archive logs with RMAN
or was it a separate netbackup file backup?
Yechiel Adar
Well, DBMS do NOT always have relational
attribute.
In the good old days there where DBMS like Total
or IMS
which are hierarchical DBMS
I am working on ADABAS on the mainframe.
This DBMS have array and array of structure that exclude
it
from the relational model. One of the fastest in the
Maybe you can get faster results with minus:
select distinct personid from persons
minus
select distinct personid from phones
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Tuesday, June 25, 2002 3:08 PM
>
>
&g
Why do not bring down the DB and then copy the whole directory
to another place on the disk.
In case of trouble just copy back.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Tuesday, June 25, 2002 5:23 PM
Ok Oracl
overdoing it.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Tuesday, June 25, 2002 5:23 PM
> that of which is happening today, tech support is busy answering RTFM
> questions like:
>
> What is a database, wh
Also check if auto archive log switching is on.
maybe all redo logs are full.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Tuesday, June 25, 2002 6:23 PM
>
> Check if the Database is in ARCHIVELOG
Based on 30 years of working with
developers,
I think that you should check what changed
in the application. Do not accept: We did not change
anything,
because more often then not it is:
We did not change anything, EXCEPT
Yechiel AdarMehish
- Original Message -
From:
Ch
Hello Bunyamin
I seem to miss something here.
If you have up to 50 concurrent users why do you use min_servers =100?
I think that you waste a lot of storage this way
and this can cause the computer to page a lot.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list
How did you solved it?
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Friday, June 28, 2002 4:03 PM
> FINALLY ,
> Everything is good now.
> Thank you for your replies.
>
> Bunyamin
>
>
>
>
Hello Cherie
I think that I saw somewhere that support for 9.0.1 will go away
about June 2003 while support for 9iR2 will be until 2005.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Tuesday, July 02, 2002 4:53 PM
&g
No problem.
Just use infra red glasses.
Question:
What are infra red glasses?
Where can I get one.
Can someone give me an example?
:-)))
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Wednesday, July 03, 2002 5
) I was told that having 4 control files solves some contention.
Anybody encountered this?
Oracle 8.1.6.3.4 on NT4 SP6 server.
Yechiel Adar
Mehish
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Yechiel Adar
INET: [EMAIL PROTECTED]
Fat City Network Services
I checked the docs for 8.1.6 and
9.0.1.
I think that the copy command is new in 9i.
make sure that you are logged on to 9i sqlplus when you
issue this command.
Yechiel AdarMehish
- Original Message -
From:
Ramon E. Estevez
To: Multiple recipients of list ORACLE-L
Sent:
I stand corrected.
I looked in the oracle database doc index.
As Jared pointed to me it is in the sqlplus docs.
Sorry.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Sunday, July 07, 2002 4:53 PM
> Moi used it in
Use DBA studio.
Under storage you can see the redo log groups and their status.
You can add and delete as you like, no problems.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Monday, July 08, 2002 6:33 PM
>
the CD, so
you can not change their block size.
When I choose general database, step 7 did not gave me
an option to change the db_block_size.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Monday, July 08, 2002 7:48 PM
Check the archives.
I think there was a long discussion on this topic not long ago.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Tuesday, July 09, 2002 6:38 PM
> Hi all.
>
> I am in the midst of designing an
How about:
delete from table
where userid = 'whatever'
and created = select min(created) from table
where userid = 'whatever';
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Tuesday, Ju
Igor, since you wanted it to be as before,
you would like to hear that my DBCA on the last screen
gives also an option to create the scripts.
It bombed on some Java error so I can not verify
that the scripts are created ok, but the screen is there.
Yechiel Adar
Mehish
- Original Message
Hello Mitchell
You need to run those scripts as user sys.
As Kevin pointed when you connect system as sysdba
your user become sys. I tried it with another userid
connected as sysdba and the user and default_schema
are sys.
So I think that ANY user connected as sysdba become sys.
Yechiel Adar
Hello Kevin
I did a little test. I think that ANY user connected as sysdba
become user sys.
I connected with another user as sysdba (not system) and the
user and current_schema are sys.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTEC
I also got it.
Their web site looks legitimate.
I do not think that someone will go to all this trouble
just to get your opinion.
I do not see the hoax value in this.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Wed
The same point of buying a family car to go to
work
even if you can not do cross country races in
it.
The fact that you can not do something does not
invalidate
the other cases where it is valid.
Yechiel AdarMehish
- Original Message -
From:
Jalil
Zabourdine
To: Mul
development
Java is the tool to save on resources.
3) Any machine that's need to run a production database
should be strong enough to run Java ok.
Yechiel Adar (not an oracle employee)
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent
Dennis, thanks for the tip.
I checked the site, oracle-dba, and found a lot of interesting articles.
I printed them and will go over then when I have time .
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Wednesday, J
Hello Kavi
Connect system/manager as sysdba,
do: select user from dual.
reply: SYS
Your system user become sys when connect as sysdba.
The default schema is also sys so be careful when creating
objects while connected as sysdba.
Yechiel Adar
Mehish
- Original Message -
To: Multiple
I would go with the second option.
Better yet, get also three controllers, one for each logical drive.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Thursday, July 11, 2002 3:43 PM
Raid 1 ?
For performance , Which Opt
It is Friday here already.
You do not need 5000 named users license.
They will license for all the e-mail address that CAN send you mail.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Thursday, July 11, 2002 7:18 PM
Yes, I can see the picture:
PHB comes in with a new install:
Hey Yechiel, install this and check it out.
If it works OK you are going to be fired.
YES SIR, I drop everything else and make myself unemployed.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list
she said she did not check
lately but she heard that they fired all the R&D people.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Friday, July 12, 2002 10:08 PM
>
> The "model" for running a technol
Well, at least they already got out the program that warn the English that
there is No Tea in their cup.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Thursday, July 11, 2002 11:14 PM
> Hannah,
>
> Fri
. If there is a need I develop scripts that do the
work, but they are running it.
5) DBA team creates the databases. They only install the software.
In fact, I am replying to this mail while there is DBCA running on one
server.
Yechiel Adar
Mehish
- Original Message -
To: Multiple
Can you send more details:
Which mainframe, what type of systems,
how many machines, staff reduction, costs etc
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Monday, July 15, 2002 7:58 PM
> Actually they were re
to pay, from his own money, all the people that got hurt by this.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Tuesday, July 16, 2002 7:13 AM
> trying again...
>
> --- Forwarded message follows ---
&
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 Guy
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
n 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 ba
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
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 "p
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 p
client 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 &l
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
AT&T
Database Admini
Eric, thank you for your illuminating notes on the
reason they hate us.
Just 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
should ha
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 of
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 dat
401 - 500 of 524 matches
Mail list logo