Title: RE: Imedia query tuning
Hello,
Thanks
Lisa for your comment but.
I try
to always use an index hint to return the rows in the required
order. This avoids a sort
if
it's possible to use an index which can avoid both sort and table access - and
it often won't be possible - the
Friends,
I have the classic case of a comma separated text file which I want to upload
and I need to know how can I enforce the following behavior of the SQL Loader:
1. To ignore the first row of the data file (which contains the column titles)
2. Avoid uploading of a column from the middle
I disagree. Some of this information may be very useful for people thinking
of going to work in Saudi Arabia. The only way it will trigger flames is if
someone takes it upon themselves to have a sly crack at the culture over
there.
However we are all way too professional to do something like
thank you john,
bunyamin
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, May 16, 2001 10:32 PM
Bunyamin,
Conditions cut both ways - depends on how you see it... Loss of religious,
social and cultural freedom against the possibility of
Yep, I've done it before without any problems
-Original Message-
Sent: 17 May 2001 05:06
To: Multiple recipients of list ORACLE-L
Thank you so much for the info, DC.
I have another stupid question. Can I have two different ports for two
database in the same tnsname.ora on the same
you can use the skip option of the sql loader. in ur case it should be
skip=1(if headings are also separated by commas)
can have the full help by typing sqlldr help=y at the command prompt.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday,
Hi List,
I've made two corresponding dumps and ... I must admit I have much less
understanding than I had before.
Please look at them.
=
PARSING IN CURSOR #1 len=68 dep=0 uid=32 oct=3 lid=32 tim=219058914
hv=168660475 ad='aa69f79c'
select /*+ INDEX(documents pk_documents) */
Thank you all gurus,
Here there are a lot of professionals working world wide.And This is a
good thing to ask directly to people who lived the experience.
Yes this is a mail list but I guarantee if somebody want to relocate in
Turkey , I will help him/her to learn quicker about the
Hi Gurus !
Is there any function that can be used in PL/SQL and just works the way as
DECODE does in Sql?
Thanks in Advance
Gyula
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Andor, Gyula
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051
Hi Diego,
If lock type is 'TX', rollback segment number = trunc(p2/65536)
and slot number = p2 - 65536*trunc(p2/65536).
May I know which table you are looking at to get the following
detailed info about enqueue waits?
Enqueue Stats
--
TY GETS WAITS
Could you not simply open the .csv file and manually delete the first row?
As for your second question, I believe you can just not mention the column
you want to leave out in the control file.
HTH
Mark
-Original Message-
[EMAIL PROTECTED]
Sent: Thursday, May 17, 2001 08:35
To:
Hey Lee...just don't go there man (oops, I didn't mean don't go THERE,
I meant don't discuss it.arghh now I'm in trouble :-) )
Martin
-Original Message-
Sent: 17 May 2001 08:45
To: Multiple recipients of list ORACLE-L
I disagree. Some of this information may be very useful for
In a recent mail on a similar topic someone said that in 8i there is a
FILLER field in SQL*Loader that allows you to jump over a column. Prior to
8i you are stuck.
I have been recommended a brand new book on SQL*Loader. Not yet bought or
read it.
Jonathan Gennick Sanjay Mishra
O'Reilly
Similarly the input text length needs to be a multiple
of 8 - a sample of how to do this is on my site
somewhere (see sig)
hth
connor
--- A. Bardeen [EMAIL PROTECTED] wrote: You
can encrypt using only a 56-bit key (the key
length limitation is a requirement of US regulations
governing the
Feuerstein recommends replacing with IF statements. Page 517 Oracle PL/SLQ
Programming.
Simon Fox
Room 205
Rail House
Gresty Road
CREWE
Cheshire
CW2 6EA
England
01270 533997
-Original Message-
Sent: 17 May 2001 10:26
To: Multiple recipients of list ORACLE-L
Hi Gurus !
Is there
I think they may have changed that last year, didn't the Clinton
Administration approve a bill re this?
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
-Original Message-
From: A. Bardeen [SMTP:[EMAIL PROTECTED]]
Sent: Thursday, May 17, 2001 12:06 AM
there is also the case of trying to enable a unique constraint on the
underlying table using the exeption option and creating an exception
table(utlexcpt.sql). The unique constraint will of caurse fail but inside
the exeption table the duplicate rowids will be written . Using this input
you can
Title: unhandled user-defined exception
I am attaching the source
code of the trigger ,Please let me know where I made mistake
.Thanks..
Venu
-Original Message-From: Venugopal, R (GEP,
Contractor) Sent: Thursday, May 17, 2001 7:25 PMTo:
Multiple recipients of
Title: Build my own aggregate function
Dear gurus,
How to build a function that work like aggregate function(SUM,COUNT,..).
TIA,
Ahmadsyah Alghozi Nugroho
Database Engineering Specialist
PT Infoglobal AutOptima
Jl. Baruk Tengah I/49
Surabaya - Jawa Timur
phone : +62 (31) 8708456 ext.113
Title: RE: ??? strange database link problem
Check out the global_name init.ora parameter.
It is probably set to true, which forces the name of the
database link to be the same as the alias.
R. Matt Adams - GE Appliances - [EMAIL PROTECTED]
Meddle not in the affairs of troff,
for
Title: unhandled user-defined exception
Add
an EXCEPTION to your code and try to trap the error 6510
-Message d'origine-De: Venugopal, R (GEP,
Contractor) [mailto:[EMAIL PROTECTED]]Envoyé: jeudi 17
mai 2001 13:25À: Multiple recipients of list
ORACLE-LObjet: unhandled
Hi,
You have to handle the exception explicitly. You can handle them by
trapping When too_many_rows, when no_data_found, when zero_divide.
After using these exceptions also if you get the error again, then you
can go for when others as a final resort.
Hope this helps,
Muthaiah
At 03:25 AM
Gyula,
I understand, that you want to apply DECODE function to some local variables
in your pl/sql block (and not to some columns in some table).
The trick is: you can always run DECODE() against 'dual' table:
select DECODE(base_expr, compare1, value1, compare2, value2,... default )
into
to carry this forward (hey Paul and Anita!)
you can also look at:
http://www.cybcon.com/~jkstill/util/encryption/encryption.html
Jared's site with some VERY easy to understand explanations on how to use
encryption
and yes the string length has to be a multiple of 8 characters
Rachel
From:
SunOS 5.8 , ORA 8.1.7.1
For Creating a NEW Database ( 1st Time )
SVRMGR connect internal;
connected
SVRMGR startup nomount pfile=/in1/ora817/dbs/initfin61.ora;
ORA-03113 end-of-file on communication channel
RESULT Database NOT Coming to NOMOUNT
OBSERVATIOM - core of 9MB Dumped in the
Rachel,
Your scripts are so slick. I have been using them for 2 years now. I
haven't tried any of the others but 'if it's not broke done fix it!'. I am
going to be on 8.0.6.3 forever because out vendors won't certify the
application for 8i, so yours scripts are a life saver.
Ruth
-
Title: RE: ??? strange database link problem
Check
NAMES.DEFAULT_DOMAIN in
sqlnet.ora
Regards
Ivo
Libal
-Original Message-From: Adams, Matthew (GEA, 088130)
[mailto:[EMAIL PROTECTED]]Sent: Thursday, May 17, 2001 03:55
PMTo: Multiple recipients of list ORACLE-LSubject: RE:
I have two Oracle 8.1.6 database on different servers. I created a link on
server 'A'
called 'instance_link' whish point to the Instance 'B' on server 'B'. It
works fine. I
then created a link on server 'B' called 'instance_link' that point to
Instance 'A' on
server 'A'. When I tried the
I
would say that the problem is with 'w' parameter of fopen function if the file
already exists. Try tu usest like this:
Kind
Regards
Ivo
Libal
traceFileName := NVL(traceFile,'TRACE_'||TO_CHAR(SYSDATE,'MMDD')||'.OUT');
BEGIN
iFile :=
UTL_FILE.fopen(iPath, traceFileName, 'a');
Wow, you're absolutely right ()
-Original Message-
Sent: Wednesday, May 16, 2001 11:31 PM
To: Multiple recipients of list ORACLE-L
oh you silly person... it is ALWAYS the DBA's fault, whether or not it has
to do with the database, whether or not the DBA was even employed by the
Hi Vivek,
I had a simular problem on DG/UX. It turned out that the shared memory was
the problem: after freeing shared memory that had no processes connected to
it, the problem was solved.
HTH, Remco
-Oorspronkelijk bericht-
Van: VIVEK_SHARMA [mailto:[EMAIL PROTECTED]]
Verzonden:
The parameter is the same on both servers. I changed the link name from
instance_link to instance and it worked fine. Why is it
complaining about the _link in the name?
Ron
-Original Message-
Sent: Thursday, May 17, 2001 9:41 AM
To: Multiple recipients of list ORACLE-L
Check
On Wed, 16 May 2001,Rachel Carmichael scribbled on the wall in glitter crayon:
-de nada -- just trying to beat my fan club (thanks Ruth and Bill :) ) to
-the punch.
Hi, I'm Bill and I'm a Goddess Groupie.;-)
-
-Now. in 8i (not sure which flavor) you can have export do the split as
-part
Title: RE: ??? strange database link problem
# Global Naming -- enforce that a dblink has same
name as the db it connects toglobal_names = true
Your problem is this.
make it to false or obey the rules.
- Original Message -
From:
Libal, Ivo
To: Multiple recipients of list
Title: unhandled user-defined exception
Hi
Venu,
Did
you set the database parameter utl_file_dir ?
Remco
-Oorspronkelijk bericht-Van: Venugopal, R (GEP,
Contractor) [mailto:[EMAIL PROTECTED]]Verzonden: donderdag
17 mei 2001 14:52Aan: Multiple recipients of list
Maybe workaround is to precreate files and when creating temporary
tablespaces use precreated files with reuse.
Alex Hillman
-Original Message-
Sent: Thursday, May 17, 2001 10:05 AM
To: Multiple recipients of list ORACLE-L
Hi,
After reading Steve Adams' tip on making temp files
Eric,
Yes they did...I am not resending this message. Either the List software is
screwing up, or my Company's email servers suck.
Ed Haskins
Oracle DBA
Verizon Wireless
-Original Message-
Sent: Wednesday, May 16, 2001 9:45 PM
To: Multiple recipients of list ORACLE-L
didn't 27 1/2
PCT_USED = PCT_FREE + 1 row sizePCT_USED +
PCT_FREE 100 Are the rules .
But what does 1 row size mean here?
For ex . My pctfree=30
1 row
size (avg.) = 150 bytes .
Then
what is PCT_USED ?
TIA
Hello:
Please help me on this crisis! What is the steps and safe procedures to downgrade database from 8.1.5 to 8.0.6 ??? I need to have this done by noon today.
I have database 8.1.5 with all schemas and data. But the application can not support 8.1.5.I have to install 8.0.6.(new one) Then I
Hello DBAs:
Please help me on this crisis! What is the steps and safe procedures to downgrade database from 8.1.5 to 8.0.6 ??? I need to have this done by noon today.
I have database 8.1.5 with all schemas and data. But the application can not support 8.1.5. I have to install 8.0.6.(new one) Then
The upgrade doco also has the downgrade steps. Check your documentation.
-Original Message-
Sent: Thursday, May 17, 2001 9:56 AM
To: Multiple recipients of list ORACLE-L
Hoo boy...I guess the safest approach is to run the catalog script against
the 8.1.6 database that changes the
That was it.
Thanks!
-Original Message-
Sent: Thursday, May 17, 2001 10:31 AM
To: Multiple recipients of list ORACLE-L
# Global Naming -- enforce that a dblink has same name as the db it connects
to
global_names = true
Your problem is this.
make it to false or obey the rules.
Who was the half person?
-Original Message-
Sent: Wednesday, May 16, 2001 9:37 PM
To: Multiple recipients of list ORACLE-L
now now, don't exaggerate it was only 25 1/4 people
From: Eric D. Pierce [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list
The trigger code would probably help...
--- Venugopal, R (GEP, Contractor)
[EMAIL PROTECTED] wrote: Hi Gurus
I am getting the error attached below when
trigger fires. what could be
the reasons
for this error.
DB error: ORA-06510: PL/SQL: unhandled user-defined
exception
The
safest way is to do a full database export, to create a new 8.0.6 database
instance and to import the datain the new database. You have to see
for inter-version specifics - you might need to use 8.1.5 import version to
import in the 8.0.6 database - you have to check that, but it is for
How about we split the difference?
| 1* select (25.25+27.5)/2 from dual
|SQL /
|
|(25.25+27.5)/2
|--
|26.375
|
(no this is not the mean)
On 16 May 2001, at 19:36, Rachel Carmichael wrote:
now now, don't exaggerate it was only 25 1/4 people
...
didn't 27 1/2
You haven't been a DBA too long have you?
... if you manage the db, you are responsible. period.
at least that's the way it's been everywhere for me, but I could be wrong...
-Original Message-
Sent: Wednesday, May 16, 2001 2:51 PM
To: Multiple recipients of list ORACLE-L
One
I have a data file that looks like this;
100Memo line 1 information.
100more information for record 100.
100extra information again.
200Memo for 200.
200more info for 200
300info for 300
300next memo
300and more
300yet more again.
I want to load to a table
Export/Import
this was actually mentioned in chapter 3 in the Oracle8i Migration Release
(A76957-01)
Hello:
Please help me on this crisis! What is the steps and safe procedures to
downgrade database from 8.1.5 to 8.0.6 ??? I need to have this done by noon
today.
I have database 8.1.5
A.,
Just out of curiosity, is your paper pertinent to NT/Win2K? Is the
replication done strictly within Oracle?
what about stuff like this?:
http://www.nsisw.com/main/pages/products.html
regarding your private question about rifts in space/time continuums,
the world is probably safe for
Does anybody know if a gateway exists between the Oracle database and
Progress database?
Thanks.
Sam Bootsma
Technical Support Analyst
CPAS Systems Inc.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Sam Bootsma
INET: [EMAIL PROTECTED]
Fat City Network Services
We are planning to upgrade our databases to 8.1.6. or 8.1.7, and I am trying
to figure out which OAS/iAS, Forms / Reports and RDBMS versions go together
best.
This is my list so far (RDBMS -- Developer/Forms/Reports -- OWS/OAS/iAS
-- OEM):
Oracle 7.3.3. -- Developer 1.6.1 -- n/a -- n/a
Oracle
Thanks for the TX information Jeffery.
But my question about CI enqueue still remains.
Here's the query to get enqueue waits statistics, it's from Steve Adams'
site.
select
q.ksqsttyp type,
q.ksqstget gets,
q.ksqstwat waits
from
sys.x_$ksqst q
where
q.ksqstget 0
/
thanks again
Yes you can encrypt the data, or you could invest in Trusted Oracle. But the
question really becomes one of what are you trying to do. If the problem is
that you question the integrity of the DBA that becomes a management problem.
On the other hand, if you don't question his/her integrity then
Hi Ed
I think, For full index scan, oracle server process reads the root block and branch blocks 1 block at a time. It reads the leaf blocks at a db file multiblock -read count blocks per read call. For the fast full scan, it reads all the block from the segment header to high water mark at a
Are you an idiot? :-)
Alex Hillman
-Original Message-
Sent: Thursday, May 17, 2001 2:07 PM
To: Multiple recipients of list ORACLE-L
HELP
|| -Original Message-
|| From: Eric D. Pierce [mailto:[EMAIL PROTECTED]]
|| Sent: Thursday, May 17, 2001 1:32 PM
|| To: Multiple
Allright,
We are physically moving our office, and have an OLTP application that needs
to be up and running with minimal downtime. The current plan is to use the
development computer as the production platform while the Primary computer
is physically moved to the new location. The development
Gurus
I want to truncate listener.log file.I am using oracle 8.1.5 and 8.1.7 on
solaris 8.Plese suggest.As I understand
go to listener.log file directory
copy listener.log listener.old
tail -10 listener.log
Thanks in advance.
-seema
Are you an idiot?
( oh god, I can't believe I said that. might as well finish it )
ALL YOUR BASE ARE BELONG TO US
;^{)
On Thursday 17 May 2001 11:07, Mohan, Ross wrote:
HELP
|| -Original Message-
|| From: Eric D. Pierce [mailto:[EMAIL PROTECTED]]
|| Sent: Thursday, May 17,
I logged a TAR with Oracle, and their Metalink technician replied that...
all the current versions are certified to work together.
I knew that.
What I want to know is, which versions of OAS , OEM or Developer were
designed on concert with which version of the RDBMS.
E.g. as part of the server
Deal! :)
From: Eric D. Pierce [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: Script that will remove redundant rows from table
Date: Thu, 17 May 2001 09:31:33 -0800
How about we split the difference?
| 1* select
Mr. Rhet Device
(rhet oracle device, that is)
On 17 May 2001, at 8:21, Alan Aschenbrenner wrote:
Who was the half person?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Eric D. Pierce
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX:
Sounds like a job for Perl.
Here's an example of cleaning up this data before you
send it to the database.
Really, this is much easier than doing it with PL/SQL or Java.
Jared
--
#!/usr/bin/perl
our %hashData;
while(DATA) {
my($key,
I think this will work fine. You could play with doing it with a standby
database, the only advantage to that is that you could start the backup and
move of files earlier in the process and just keep recovering the archived
logs as you ship them across.
This has the advantage of giving you
Hi seema,
you can do:
echo '' listener.log
On Thu, 17 May 2001, Seema Singh wrote:
Gurus
I want to truncate listener.log file.I am using oracle 8.1.5 and 8.1.7 on
solaris 8.Plese suggest.As I understand
go to listener.log file directory
copy listener.log listener.old
tail -10
oops!
My previous post said that the key must be on 8 byte boundaries.
That is incorrect. I believe the data must be on 8 byte boundaries.
Guess I should re-read my own article.
Jared
On Wednesday 16 May 2001 18:30, Ahmadsyah Algozhi Nugroho wrote:
I'm using Oracle 8.1.7.
there was an
Many professional women in the USA have found it necessary to
purchase handguns to protect themselves from criminal elements in
public places. Children are constantly under psychological assault
being exposed to media violence. The liberal education system is
devoted to indoctrinating
The key must be on 8 byte boundaries.
See my article on encryption at www.cybcon.com/~jkstill/util
Jared
On Wednesday 16 May 2001 18:30, Ahmadsyah Algozhi Nugroho wrote:
I'm using Oracle 8.1.7.
there was an error
ERROR at line 1:
ORA-28232: invalid input length for obfuscation toolkit
All mighty and powerful DBA supremes !
Do any of you have a drop schema script that would be willing to share
??
It'll be greatly appreciated
T I A
begin:vcard
n:de Urioste;Luis Octavio
tel;fax:850.455.0673
tel;work:850.457.3218
x-mozilla-html:FALSE
org:Raytheon Aerospace;IT
version:2.1
Re the 'scattered read' for full index scan.
This term is counter intuitive at first glance, and is commonly
seen on full table scans. It makes sense that it would show up
on full index scans as well.
Here's an explanation of 'scattered read' found at
It takes a lot of digging for multiple versions, but on Metalink,
under product life cycle there is a certification facility with
various levels of drill-down.
regards,
ep
--
Certify - Certification Matrix: Oracle Forms 6i on
How about:
drop user username cascade;
--- Luis DeUrioste [EMAIL PROTECTED] wrote:
All mighty and powerful DBA supremes !
Do any of you have a drop schema script that would be willing to share
??
It'll be greatly appreciated
T I A
begin:vcard
n:de Urioste;Luis Octavio
Title: RE: Moving a database to a different machine
Hi Steve,
I used this same strategy with a migration last month. It minimized our database related downtime to 30 minutes (and then they unplugged the symmetrix and the app server was down for 12 hours. Oh well)
This plan will work.
Login in as system:
drop user user_name cascade;
-Original Message-
Sent: Thursday, May 17, 2001 12:26 PM
To: Multiple recipients of list ORACLE-L
All mighty and powerful DBA supremes !
Do any of you have a drop schema script that would be willing to share
??
It'll be greatly
As usual, thanks for the answer Steve.
I'll try to reduce the number of shrinks in the rollback segments, so this
is going to impact on CI enqueue waits.
What do you think about Metalink DOC ID 1020355.102 recomendation?
(from my previous email)
I've also read a metalink document
This Client in the Cleveland Ohio area, is dedicated to creating a work
environment
enabling ALL employees to contribute and to grow into their fullest potential.
They have a full-time staff opportunity available for an Oracle DBA.
This is a full time staff position so no sub-contractors or
Or...may be
select 'drop user '||username||' cascade;'
from dba_users
where username not in ('SYS','SYSTEM'); --and perhaps some other user you'd
like to conserve
...and then run the spool.
hope it helps
DC
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL
Title: RE: job offer from SAUDI ARABIA
God I live in an awful country. I'm sorry for all the tyranny my country has put the world through. I guess I'll just shoot myself.
Seriously. I encourage the individual that is looking at working in Saudi Arabia to do so if that is the experiences he
From InformationWeek:
** Oracle Hooks NATO On 11i
The North Atlantic Treaty Organization has begun implementing
Oracle's 11i E-business software in its 19 regional headquarters.
NATO program director David Oakley says NATO's new Automated
Financial System will incorporate Oracle's
rant on
ep,
Any idiot can see we're the freest country in the world!
Free to do what is expected, or get thrown in jail at a
rate exceeding most other civilized nations. Free to
subsidize tobacco and alcohol (and related deaths) and
throw dangerous criminals in jail for using cannabis.
GROAN
From: Eric D. Pierce [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: Script that will remove redundant rows from table
Date: Thu, 17 May 2001 10:50:39 -0800
Mr. Rhet Device
(rhet oracle device, that is)
On 17 May
uhhh DUHHH !
I could write the algorithm to solve the logarithm .. IF I ONLY HAD A
BRAIN ..
Thank you to all of you, and special thanks for not bashing me
Luis Octavio
Luis DeUrioste wrote:
All mighty and powerful DBA supremes !
Do any of you have a drop schema script that would
Hi guys!
Since the upgrade of my Oracle server to the version 8.1.6 (I applied all
the patches) and the rebuild of the clients applications with the libraries
from the same version, the column PROGRAM of the view v_$session is empty.
If the application is using the old libs, the program apears
And freedom to leave the country any time you wish. Have a nice flight.
--- Mohan, Ross [EMAIL PROTECTED] wrote:
rant on
ep,
Any idiot can see we're the freest country in the world!
Free to do what is expected, or get thrown in jail at a
rate exceeding most other civilized nations.
Brian of MacLean,
I guess that's a good way of putting it, too. Sometimes I like to rant about
( i.e. for ) Amerikkka, but that's usually when she's under attack, in a
way that is
perceived by me as being unfair or
misinformed.
- Ross
-Original Message-
Sent: Thursday, May 17,
Koivu, Lisa said
A word of warning, and you probably already know this: you can't have both
databases open at the same time or you will end up with incompatible archive
logs and control files. Good luck !
hehe I did know, but upon reading your warning it still frightened me for a
moment.
WOW!! I need to pay more attantion, what the hay is going on here?
-Original Message-
Sent: Thursday, May 17, 2001 4:14 PM
To: Multiple recipients of list ORACLE-L
rant on
ep,
Any idiot can see we're the freest country in the world!
Free to do what is expected, or get thrown in
It's started. After slick willy was invited to speak the kickbacks are showing up.
Oracle will be running the Government. Slick move... you don't dare bust up the
monopoly that is running the Governmential department's programs. Will the NEW
controling body be called the
Don't I feel silly! I didn't even know that 9i was out yet, much less 10i
or 11i! I guess I don't dare blink.
DM
-Original Message-
[EMAIL PROTECTED]
Sent: Thursday, May 17, 2001 1:09 PM
To: Multiple recipients of list ORACLE-L
From InformationWeek:
** Oracle Hooks NATO On 11i
The
Only in America, can you rant! Try to criticize China while living there. I have a
friend there, her mail is read before she gets it. All she can write is general
stuff, nothing negative, fearful of her life. The best thing about America is that
you can b*tch if you want. I served for
Not sorry if I touched a nerve, Rocky.
That's what it's all about. It's democracy,
suck it up, or spit it out.
|| -Original Message-
|| From: Rocky Welch [mailto:[EMAIL PROTECTED]]
|| Sent: Thursday, May 17, 2001 4:36 PM
|| To: Multiple recipients of list ORACLE-L
|| Subject: Re:
Well...technically it's not out yet. Like alot
of list member's, I got my copies about a month
ago in the mail, and the general availability (GA)
date is June 10th ( I think..I could be confusing
that with IBM's next release ).
I wouldn't feel silly. A bunch of us around here
in this shop are
Actually NATO has been using Oracle's RDBMS product for years.
Original Message
On 5/17/01, 4:01:34 PM, Ron Rogers [EMAIL PROTECTED] wrote regarding
Re: Another big bang for Larry:
It's started. After slick willy was invited to speak the kickbacks
are showing up. Oracle will be
I think it is Oracle Applications ver 11i and not an Oracle server release.
-Original Message-
Sent: Thursday, May 17, 2001 4:09 PM
To: Multiple recipients of list ORACLE-L
From InformationWeek:
** Oracle Hooks NATO On 11i
The North Atlantic Treaty Organization has begun implementing
Gene,
Being part of a nation with people (such as yourself)
who have a willingness to let other's have their opinions
-- some of who are a part of the military force that
defends that right -- is why all my tickets out of town
are always marked round trip.
Above all, thanks for your
Hi,
We are planning to do two-phase data migration - split by data.
In first phase, about 10% of the data will be moved as is -
without changing the primary keys (generated from sequences).
Once we start using the database with phase 1 data, sequences
will generate new primary keys and add to
E-Business is the new term for Oracle Applications, and yes, 11i has been
out awhile, running against an 8i database.
It's a full time job just keeping up with Oracle's naming convention!
Linda
-Original Message-
Sent: Thursday, May 17, 2001 2:56 PM
To: Multiple recipients of list
Praful,
This is a bit of a shot from the hip, but.
the gap shouldn't make much of a difference in
the end.
I'd be more concerned about allocating space for
all your stuff initially, not just the first 10%.
The gaps should be handled seamlessly by indexes
(the way a b*tree works...) and
Hi Riyaj,
Thanks for your response. Very interesting! I
completely agree with you about index fast full scan.
But I'm still unclear about index full scan.
I've always thought that this operation is serviced with
1-block reads. So it would bepossible
to go through 2-way list of leaf
Um, I can critize Canada all I want. Matter of fact, its kind
of a requirement. So your first sentence is wrong. I asked one
of the guys I work with here if he drinks a lot when he goes out
and he said Well, not for a Canadian. He is Canadian. (As am I)
-Original Message-
Sent:
1 - 100 of 129 matches
Mail list logo