Hello Gaja
I checked the report from YAPP and library cache load lock accounts
only to 0.75% of the wait time. 28 seconds during 6100 seconds between
snaps.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Wednesday, Ap
Hello
What version of toad are you using.
I downloaded version 7.2 a few days
ago.
Connected as sys, activated schema browser and got
all sys tables in the list.
I also got all the users in the drop list to select
user.
Yechiel Adar
Mehish
- Original Message -
From
Well, sitting here at 11:00 PM on Saturday night building
replication
for 8.1.6 DB and having a nice time catching up on the
postings,
I am very interested in your postings.
Please keep it up.
Yechiel Adar
Mehish
- Original Message -
From:
Jamadagni, Rajendra
To
Hello Stephen
Thanks for the link.
The article is very illuminating.
As we have some loader tuning to do I thank you for
sharing the knowledge.
Yechiel Adar
Mehish
- Original Message -
From:
Stephen Andert
To: Multiple recipients of list ORACLE-L
Sent: Friday, April
this is just to simplify the new
install.
We have a NT server with oracle 7.3.4 and 8.1.6
installed in two homes and there are no problems.
Yechiel Adar
Mehish
- Original Message -
From:
Eriovaldo
Andrietta
To: Multiple recipients of list ORACLE-L
Sent: Sunday, April
Are you working with toad version 7.2?
I compared 2 schemas and got a complete list of differences.
Right click on the difference and you get the SQL to implement it.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent:
statistics are for you and use them only
quarterly for management.
If you can add a graph for important
applications.
Yechiel Adar
Mehish
- Original Message -
From:
Yuval
Arnon
To: Multiple recipients of list ORACLE-L
Sent: Monday, April 29, 2002 7:23
PM
Subject
Do you know how to see the threads in NT?
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Monday, April 29, 2002 8:24 PM
> oracle.exe spawns out threads, which you will not see running in the task
> manager.
---
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).
Hello Rick
Of course some 9i components are still in.
The installer itself is the version that come with 9i.
Fun aside, What components are still installed?
Yechiel Adar,
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Tuesday, Ap
Thanks for the links.
We are now in the process of tuning a database, on NT, without any option
to change the application code (3rd party).
I downloaded the docs and hope they will help me.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EM
Hello Rick
I think that you should start with DBCA and remove
your 9i DB
and then follow the steps in John
letter.
Yechiel Adar
Mehish
- Original Message -
From:
Ora NT
DBA
To: Multiple recipients of list ORACLE-L
Sent: Tuesday, April 30, 2002 4:59
PM
Hello Peter
A good source if the calls themselves.
After each call analyze the root cause and start checking for it.
This way you will be able in a short time to eliminate a lot of problems.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EM
Monitor.
>
> Igor Neyman, OCP DBA
> [EMAIL PROTECTED]
>
--
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 Inte
them.
Just my 2$ (inflation, you know)
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Wednesday, May 01, 2002 7:48 PM
> Whatever happend to COBOL anyway?? That was so easy to code, along with
> Fortran, BASIC, Pascal
down to 9k from about 10,000k.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Wednesday, May 01, 2002 7:58 PM
If you are running Oracle on Windoze, you have to stop the listener service,
then rename the listener.log, then
AS on the mainframe I can activate a user exit that gets the command
that
the user send to the database and change it (Not only can, but we are doing
it!).
Is there a way to do the same with SQL in Oracle?
In the server (preferably) or in the client.
Thanks
Yechiel Adar
Mehish
--
Please se
AS on the mainframe I can activate a user exit that gets the command
that
the user send to the database and change it (Not only can, but we are doing
it!).
Is there a way to do the same with SQL in Oracle?
In the server (preferably) or in the client.
Thanks
Yechiel Adar
Mehish
--
Please se
Hello Joe
Just took a peek.
Looks illuminating.
Keep up the good work.
Yechiel Adar
Mehish
- Original Message -
From:
JOE
TESTA
To: Multiple recipients of list ORACLE-L
Sent: Thursday, May 02, 2002 3:48
PM
Subject: 9i new features update
I finally got the
Thanks for the idea Tim but I am thinking about adding hints
to the sql or changing the FROM table.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Thursday, May 02, 2002 4:48 PM
> The Virtual Private Database (VPD)
Hello Anjo
If you know of a way to change the SQL at the client side I would LOVE to
know it.
We where thinking about changing the connections string on the fly (not this
fly)
And this can help a lot.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L
Hello Ray
I think that the intent is for you to burn the gz file and expand it on the
target system.
I installed today upgrade 9.0.1.3 for NT that came in the same way.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Th
Hello Ron
I was just looking at Joe new oracle 9i features at
http://www.oracle-dba.com
I saw that log miner gives you something like:
update "SCOTT"."TEST_LOG" set "C2" = '10'
What happens if you extract this info and erd tool moved a column?
Inq
ch old data new tricks
(or new structure).
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Thursday, May 02, 2002 8:48 PM
Yechiel,
In the instance that you refer to it could present a problem if you
use the "changed&q
the
following policy:
Every application has two user id's:
Owner, with password known only to the DBA group.
User with rights for select, insert, update, delete ONLY.
It works.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTE
or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Yechiel Adar
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858
Hello Dennis
SAS has progressed a little in the last years and now offer a complete
DW solution, including ETL tools.
You can use their tools also to populate and query oracle.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Well , just to keep things jumping.
Last week I deviated from our rule and gave a responsible user
that needed truncate on tables the password for the owner of the schema.
Guess what? Today he comes to me to recreate 2 tables that he dropped.
Go figure.
Yechiel Adar
Mehish
- Original
Hello Lisa
I think that using :
SQL> SELECT COUNT(*)
2 from leisure_plan_master_temp
3 where membership_class = 'D'
4 AND (pay_METHOD NOT IN ('C','P')
5 or pay_method is null)
will give you the correct result.
Yechiel Adar
Mehish
- Or
Hello James
In the last 2 years I did about 5-6 migrations from 7.3.4 to 8.1.6.0
and 10-12 from 8.1.6.0 to 8.1.6.3.4.
All done on NT with upgrades.
No scratch and rebuild. No problems at all.
Sorry to disappoint you.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of
but I was not involved
in the programming side.
I checked with the programmer and he told me that in the little testing
he did ( system still in test) SAS worked quickly and nicely
with oracle, including graphs. SAS has a nice graph generating option.
Yechiel Adar
Mehish
- Original Message
o the user.
Any better ideas?
BTW - I did not wrote that he dropped the tables using some developing tool
called magic
because he forgot to switch back to the regular user after the truncate.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PRO
Right
BUT: make sure you do not use any option that does not exist in the standard
edition
but existed in the enterprise edition.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Sent: Tuesday, May 07, 2002 12:18 PM
>
Sorry to disappoint you all.
I gave him the password so he can connect as the owner and then he can
do truncate.
I scanned the list later and found the discussion on the subject
and I am going to replace that with a procedure that he will be granted
execute.
Yechiel Adar
Mehish
- Original
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
First I second Mladen recommendation to install
9.2.
IIRC there is one KIT file on the installation disk that
you need to rename for the installation to succeed.
Also you can use lsnrctl to install the listener
service.
do: lsnrctl start listener and it will install the service
for you (if t
OOPs - It is JIT file.
Yechiel AdarMehish
- Original Message -
From:
Yechiel
Adar
To: Multiple recipients of list ORACLE-L
Sent: Sunday, November 23, 2003 5:49
PM
Subject: Re: Oracle 8i installation
First I second Mladen recommendation to install
9.2
You need SMTP server and it is a different kind of server from the e-mail
server.
Yechiel Adar
Mehish
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Monday, November 24, 2003 11:24 AM
> Hello!
> It's me else on
: Multiple recipients of list ORACLE-L
Sent: Monday, November 24, 2003 1:59
PM
Subject: Re: Oracle 8i installation
what do you mean by JIT file??
how can i solve my
problem?
- Original Message -
From:
Yechiel
Adar
To: Multiple recipients of
Title: Active Directory and ORACLE passwords
There is a product called MIIS ( Microsoft Integration
Information Server) that synchronize between Ad and Oracle LDAP. One of the
companies in Israel is checking it out now.
Yechiel AdarMehish
- Original Message -
From:
Bartolo,
have an information security guy, teach him how to add users and
grant the application user role.
The schema owner password need to be a closely held secret of the dba group.
Yechiel Adar
Mehish
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]&
. You can use
the multiple into table format of SQLLDR and load into the same table, each
time with different fields.
Yechiel Adar
Mehish
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, November 26, 2003 11:34 PM
> Hi
Hello John
From you description of the problem I suspect that you use
7.3 client.
See note 172179.1
on metalink about which client connect to which server.
Yechiel AdarMehish
- Original Message -
From:
John
To: Multiple recipients of list ORACLE-L
Sent: Saturday, No
-
From:
Yechiel
Adar
To: Multiple recipients of list ORACLE-L
Sent: Sunday, November 30, 2003 1:04
PM
Subject: Re: FRM-41072
Hello John
From you description of the problem I suspect that you
use 7.3 client.
See note 172179.1 on
If we are talking about two sql only, maybe you can use stored outline.
Yechiel Adar
Mehish
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, December 02, 2003 8:34 AM
> Hi, list friends:
> We are using partit
I checked for 8.1.6.3.4 and 8.1.7.0 on windows. Not
there.
Yechiel AdarMehish
- Original Message -
From:
[EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L
Sent: Wednesday, December 03, 2003 12:19
AM
Subject: dbms_support on 8i
Does anyone know which p
.
Yechiel Adar
Mehish
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Tuesday, December 02, 2003 3:04 PM
> Hello List,
>
> The Company I work for is planning to go the Active Directory route. Does
> anyone know of any issues wi
Is there any way to decrease the initial extent allocated to a table.
It is one of the system tables, so I do not want to drop and recreate it.
I can not export/import as it appear in noexp$.
It has long field so I can not do alter table move.
Yechiel Adar
Mehish
--
Please see the official
Thank you.
OK. Another 130MB down the drain.
Yechiel Adar
Mehish
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Wednesday, December 03, 2003 8:49 PM
> You can move it after you convert the long field to LOB. As it is one
>
welcome ideas how to make oracle use the index on the remote side.
Yechiel Adar
Mehish
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Yechiel Adar
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California
.
Yechiel Adar
Mehish
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, December 04, 2003 12:19 AM
> I don't understand. Here is what manual says:
>
> deallocate_unused_clause
>
> Use the deallocate_unused_cl
join between FTS on local table and remote (in/out =
serial).
Yechiel Adar
Mehish
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Yechiel Adar
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California
What about session UGA memory?
Do where name like 'session %ga%');
Yechiel Adar
Mehish
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, December 04, 2003 3:24 PM
> Hi, friends:
> Several months ago
I do not see the problem.
SGA is 970M + PGA (20*40) 800 MB + executables and you got about 2GB which
is the upper limit on NT, unless you used special startup parameter.
Yechiel Adar
Mehish
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
nt: Wednesday, December 03, 2003 10:09 AM
> > To: Multiple recipients of list ORACLE-L
> > > >
> > Is there any way to decrease the initial
extent allocated to a table. > > It is one of
the system tables, so I do not want to drop and recreate
1 - 100 of 524 matches
Mail list logo