how is this possible??

hello... i am faced with an enigma. SQL select * from p_sku@shopowner_lnk where sku_cd not in 2 (select sku_cd from p_sku); no rows selected SQL delete from p_sku@shopowner_lnk where sku_cd not in ( 2 select sku_cd from p_sku); 2 rows deleted. there are no triggers on any of these

Fast Refresh of Snaphots Locking?

When we do a fast refresh of a snapshot and the number of entries in the log are high (750,000+) our users complain about poor performance for approximately a 5 - 10 minute period. (This occurs in the database where the master resides) As of yet I have not been notified in a timely manner to

RE: Snapshot performance issue

I forgot to tell you that I'm working on release 8.1.7 and if I'm not mistaken indexes like 'SNAP_$' do no more exist. Please, correct me if I'm mistaken. -Message d'origine- De : Mike J Kurth [mailto:[EMAIL PROTECTED]] Envoyé : mardi 11 septembre 2001 08:25 À : Multiple recipients of

Query from access to oracle

Hallo, Anyone who can help me, I have this query in Ms Access: How should I write this sql statement in oracle. SELECT RIK2.LEV.LEVNR, RIK2.VARE.EAN_NR, RIK2.VARE.VARENAVN, RIK2.AVD.KJEDE, Sum(BRT.BRTOMS_DAG.ANT) AS ANT, Sum(BRT.BRTOMS_DAG.UTVERDI) AS UTVERDI, BRT.BRTOMS_DAG.DATO,

RE: User Query Tools

It's your worst nightmare come true!!! The users want to do it 'cause a) IS charge to much for the work b) All it is is a bunch of stuff in a big file thing, how difficult could it be? c) Isn't it just like a big spreadsheet only different? d) I built one at home so I know what to look for

RE: export user definitions

something like this i have found on teamdba.com select 'create user '||username||' identified by values ' ||chr(39)||password||chr(39)|| ' default tablespace '||default_tablespace || ' temporary tablespace '|| temporary_tablespace||' ;' from dba_users where username not in

RE: What's wrong with this query

Anne, Upon first glance I wondered if it's because you are not specifing the Index to use for b. Possibly, you don't have a clause in your where statement that filters the number of records you're trying to get back from ucc_master_amendment m. In the statement: d.document_number =

DBMS_JOB statement

Hallo, Can anyone tell me a example on a script which does the following: - Starts a job, a pl/sql-procedur, at 6 pm every day, - If something goes wrong then I want information to be logged. (Should I include the logging in the pl/sql procedur) Thanks in advance Roland S --

Migration from Informix to oracle

Hi All, Can anybody suggest me the steps to migrate to oracle database from Informix ? Can it be done simply by using sqlloader oracle utility ? Kindly reply. Regards, Deepender

RE: query for top customer

Thanks Greg, ;-) I needed that! I just got into PL/SQL mode and went for itLOL Cheers, Kev. hit any user to continue __ Kevin Thomas Technical Analyst Deregulation Services Calanais Ltd. (2nd Floor East - Weirs Building) Tel: 0141 568 2377 Fax: 0141 568 2366

too high load on Linux

Hello! I'm new in this list and I sorry for easy and stupid questions and my English. :) I have a 8.1.7 database on Debian 2.2 and the oracle session use nearly 100 percent of CPU. I listed v$session view and noticed one session do that! But how can I get more information for this session ?

NLS_ Client settings

Hi All, Someone came up to me today with a list of 17 NLS parameters and wanted to know what the settings were on our clients. I have been able to find some of the parameters in the v$nls_parameters view and asssume that these are client/session related since they change with alter session

ORA-12705 - REALLY URGENT

Hello all, I am getting an error, ORA-12705, could you please advise what steps I can take to set the NLS_LANG properly, this is what it says is needed. Also please tell me what are the possible solutions to this problem? This is really urgent, please help. rgds, raja Get 250 color

Re: Solaris Hang

Hi, take a look at the SUN System Administrator Guide. Here's an excerpt: Every other leap year, your CDE hangs on the 2nd full moon night of September after you try to write more then 4 files to a floppy disk. To fix this problem, you have to go to store.sun.com and buy even more memory.

Re: ORA-12705 - REALLY URGENT

Hi, What is exactly that you are trying to do. Alter session? What syntax? Start the database? What O/S? What is your environment like (on UNIX env |grep nls) Jack Viraj Luthra [EMAIL PROTECTED]@fatcity.com on 11-09-2001 12:05:26 Please respond to [EMAIL PROTECTED] Sent by: [EMAIL

RE: too high load on Linux

Hi Andras, Firstly, welcome to the list, and your English is fine!! For a good session detail run the following query: --Sessions.sql--- select s.sid sid, s.serial# serial#, s.lockwait lockwait, 0 blkby, 0 blkcnt, s.username session_user,

RE: DBMS_JOB statement

Hi Roland, declare l_job number; begin dbms_job.submit( l_job, 'procedure;', trunc(sysdate)+18/24, 'trunc(sysdate)+18/24' ); end; This runs at exactly 6pm every day (18 hours into the day, replace procedure with the name of the stored procedure that you want to run.

Re: ORA-12705 - REALLY URGENT

Problem is resolved. The NLS_LANG was not set correctly in the environment. Thanks for all help. rgds, raja -- On Tue, 11 Sep 2001 02:30:38 nlzanen1 wrote: Hi, What is exactly that you are trying to do. Alter session? What syntax? Start the database? What O/S? What is your

Replication ??

Hi Gurus We are considering implementing replication, on our server. Microsoft 2000 Oracle 816. Does anyone know of any problems, or I wish I had known that before. type of issues of doing this? Many Thanks Denham -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author:

RE: query problem

Or set define off.. -Original Message- Sent: Monday, September 10, 2001 21:56 To: Multiple recipients of list ORACLE-L or .. If you are doing it in SQLPLUS you can do set scan off That way it will not look for variables. -Original Message- Sent: Monday, September 10,

Copying backups across a narrow pipe.

Hi Gurus I have a problem in that I have to copy my backups across a wan connection to a remote server. However the copy ( using xcopy) in the microsoft NT environment, keeps on dropping or times out. So the success rate is very low, the Boss is now becoming difficult about it. Does anyone know

Ftp from Oracle

Hallo, Is it possible to do ftp commands directly from PL/SQL procedur? Including logon to the ftp server.? Give me an example please if possible. Thanks in advance Roland -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City

Differential Backup

Hi all, we have oracle server version 8.1.7 on windows NT. We take daily full backup of our data. Now we want to take differential backup with respect to last backup taken. So if any help possible it will be great to me. Thanks. -Ketan _ Do

RE: OT RE: Interesting News..

Ok guys, now tell us how you really feel. :o) I just about choked from laughing. Dave -Original Message- Sent: Monday, September 10, 2001 4:36 PM To: Multiple recipients of list ORACLE-L Eric, I join with you in emptying the contents of my venom sac deep into the putrid flesh of

RE: Re[2]: RE: Interesting News..

Why is it that flames rarely have the letters OT in the subject line... Patrice Boivin Systems Analyst (Oracle Certified DBA) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051

Re: ORA-12705 - REALLY URGENT

You should look at the values of NLS_LANG and ORA_NLS33 or ORA_NLS32 in the client. If it is an NT's client, the values must be defined once and not in each HOME. Regards. --- Viraj Luthra [EMAIL PROTECTED] wrote: Hello all, I am getting an error, ORA-12705, could you please advise what

Downloading from Oracle

Sometimes when I download files from the Oracle web sites, I can't use Download Accelerator Plus. I like that utility, it downloads files in parallel. When I try to download using IE, 90% of the time the large .zip file is corrupt and unusable. Has anyone found a way to download the

RE: nvl not using index

Big Planet wrote -I am writing this proc does a searchin databasebased on these in parameters and returns a ref cursor . Now one moreofthesein parameters can be null and my query should return data neglecting null parameters . So I use nvl in the query as shown below Big Planet, small

RE: Downloading from Oracle

I am too in the same shoes. Any help from others?? Rajesh -Original Message- Patrice J Sent: Tuesday, September 11, 2001 4:35 PM To: Multiple recipients of list ORACLE-L Sometimes when I download files from the Oracle web sites, I can't use Download Accelerator Plus. I

Inserting records into a table without creating indexes

List, Environment: Solaris 7 : Oracle 817 : OLTP system with stringent throughput requirements A transaction inserts a record into 4 tables. After successful insert into all the four tables, the transaction issues a commit. Many alternate index keys (AK's) are defined on each table. Expected

Re: Copying backups across a narrow pipe.

Hi, take a look at connect direct. It's a data transfer tool that is scriptable and can handle high volumes at a high transfer rate. Denham Eva schrieb: Hi Gurus I have a problem in that I have to copy my backups across a wan connection to a remote server. However the copy ( using

Re: Differential Backup

Try with RMAN. Regards. --- Ketan Patel [EMAIL PROTECTED] wrote: Hi all, we have oracle server version 8.1.7 on windows NT. We take daily full backup of our data. Now we want to take differential backup with respect to last backup taken. So if any help possible it will be great to me.

Re: Differential Backup

Take a look at the fine documentation on RMAN. It can do different levels of incremental backup. -Joe - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, September 11, 2001 8:30 AM Hi all, we have oracle server version 8.1.7 on windows NT.

Re: Replication ??

Hi, it depends on what kind of replication you want. We're using normal snapshots (read only and updatable) and multi master replication. There is an organisational issue concerning multi master replication. You have to be sure about how you want to replicate. We went with asynchronous

RE: Downloading from Oracle

At 09:15 AM 9/11/2001, you wrote: I am too in the same shoes. Any help from others?? Rajesh i use getright. seems to work ok for me. -- Bill Shrek Thater ORACLE DBA Telergy,Inc. [EMAIL PROTECTED]

Re: [Fwd: Re: patch question]

Anjan, Thanks, what I thought is I installed the 8170, apply patch 8172, then upgrade db from 816 to 817.2 directly. (not apply a 817 patch to 816 db) Anyway, I think I will upgrade first to 817.0 and apply patch to 817.2. Thanks, Joan Anjan Thakuria wrote: Upgrade and then apply patch.

RE: Ftp from Oracle

Not that I know of through PL/SQL, but you can use Java Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73

RE: Do fast full index scans do physical disk reads?

If you read the email as I wrote it, it was a sarcastic response to someone elses posts. And a few emails later I reiterated that it was only meant sarcastically. But take it as you may. Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are

RE: Copying backups across a narrow pipe.

And where can I get that look? Alex Hillman -Original Message- Sent: Tuesday, September 11, 2001 9:10 AM To: Multiple recipients of list ORACLE-L Hi, take a look at connect direct. It's a data transfer tool that is scriptable and can handle high volumes at a high transfer rate.

RE: OT RE: Interesting News..

Now for my encore, I'll crash into the World Trade Center. EG -Original Message- Sent: Tuesday, September 11, 2001 8:00 AM To: Multiple recipients of list ORACLE-L Ok guys, now tell us how you really feel. :o) I just about choked from laughing. Dave -Original Message-

RE: Downloading from Oracle

What is the problem with using DAP to do the download? Failing getting this working - as it almost guarantees a valid download - have you also tried some of the other download aids (getright, or real download for example)? I do agree, DAP is the best I have come across so far.. What is the

RE: STOP THE PRESS!!

The BBC seems to have more info than the U.S. web sites. Tuesday, 11 September, 2001, 13:35 GMT 14:35 UK Planes 'attack' World Trade Center A huge explosion rocks one of towers Two

FW: nvl not using index

Title: FW: nvl not using index BigPee, Have you tried a function-based index yet? (8i) You'll need to grant query rewrite privilege to the user creating the index. Lisa Koivu Glorified Typist and DBA Ft. Lauderdale, FL, USA -Original Message- From: Farnsworth, Dave [SMTP:[EMAIL

OT: STOP THE PRESS!!

List, I am sure many of you Americans will have woken to this news, or maybe you got to work before it happened: I just saw on the news the World Trade Centre in NY, has just taken two direct hits from two separate aeroplanes!! Suspected to be a terrorist assault. Full video the lot!! They hit

RE: What's wrong with this query

Thanks Thomas, Lisa, Attached is the TKPROF EXPLAIN PLAN for this query.Please review. Many thanks, TKPROF: Release 8.0.6.3.0 - Production on Tue Sep 11 07:38:26 2001 (c) Copyright 1999 Oracle Corporation. All rights reserved. Trace file: texasprd_ora_24718.trc Sort options:

RE: Ftp from Oracle

Hi Roland, Yes it is possible, I have got a piece of code that I got from the site asktom.oracle.com, that allows you to send Unix commands to the shell from within SQL. I'm making the assumption that it's a Unix environment you want to make the call within? If it is, give me a shout and I'll

Re: Downloading from Oracle

r all our friends OK in WTC disaster ?? Srini - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, September 11, 2001 9:55 AM At 09:15 AM 9/11/2001, you wrote: I am too in the same shoes. Any help from others?? Rajesh

Re: Snapshot Refresh Process ??

I'm interested in the cutover point. Our snapshots are set up with FORCE, which allows Oracle to choose between a FAST or a COMPLETE. But at what point does Oracle decide that it will be faster to do the complete? Does Oracle need to have the tables analyzed so that it has some statistics to

How can I read this dump

Hi list I've done a sql_trace_in_session of a user process and I'm getting a big dump. I'm just curious about this line in particular: PARSE #34:c=7,e=8,p=0,cr=8,cu=2,mis=1,r=0,dep=0,og=3,tim=1236949953 What does tim mean? How can I read it? TIA

RE: Interesting News..

So, as you devote the extra minutes to your job, does this mean COMPAQ customer service will get better or worse? EG -Original Message- Sent: Monday, September 10, 2001 10:50 PM To: Multiple recipients of list ORACLE-L After thinking about this whole thing further, I realize I've made

New York/East Coast !!!!

I sure hope our members on the East Coast are ok. If anyone is out there and has access, I'd be happy to pass along any messages to family, etc. Let us know if you guys are ok. Stephen Andert -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Andert INET:

Re: OT: STOP THE PRESS!!

Looks like the Pentagon was also just bombed. Denise Gwinn [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet

RE: OT RE: Interesting News..

very inappropriate, considering the situation Mohan, Ross

OT

Title: OT I hope everyone on this list in the New York area is safe I am so scared. Lisa Koivu Oracle Database Administrator Fairfield Resorts, Inc. 954-935-4117

Sad News - Jets crashed into World Trade Center

Did anyone see this? 2 small jets crashed into World Trade Center in NY shortly before 9am. I feel horrible and sorry for all the people suffered. Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com

RE: Do fast full index scans do physical disk reads?

Awww, come on, Chris. You're starting to sound like a COMPAQ customer service rep. ;-) -Original Message- Sent: Tuesday, September 11, 2001 9:50 AM To: Multiple recipients of list ORACLE-L If you read the email as I wrote it, it was a sarcastic response to someone elses posts. And

RE: OT RE: Interesting News..

Not funny, Ross. --Walt Weaver Bozeman, Montana -Original Message- Sent: Tuesday, September 11, 2001 8:35 AM To: Multiple recipients of list ORACLE-L Now for my encore, I'll crash into the World Trade Center. EG -Original Message- Sent: Tuesday, September 11, 2001 8:00

RE: Ftp from Oracle

The only way I would think would be an External Procedure. -Original Message- Sent: Tuesday, September 11, 2001 8:45 AM To: Multiple recipients of list ORACLE-L Not that I know of through PL/SQL, but you can use Java Do not criticize someone until you walked a mile in their shoes,

today is disaster recovery drill day

burn your .dmp to CDs and head for the hills. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Drake INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing

RE: STOP THE PRESS!!

Capitol Hill? Are you sure? Pat. -Original Message- From: Robertson Lee - lerobe [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, September 11, 2001 12:31 PM To: Multiple recipients of list ORACLE-L Subject: RE: STOP THE PRESS!! The south Tower of the World Trade Center is no

OT Breaking News

Off topic and serious for once; The World Trade Towers, the Pentagon, the USA Today building have all been hit by bombs. The first is quite major. There is word here in DC that they are evacuating people from around the White House. -- Please see the official ORACLE-L FAQ:

RE: Sad News - Jets crashed into World Trade Center

Small... 1 DC-3 and one Boeing 767. Pat. -Original Message- From: Jamadagni, Rajendra [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, September 11, 2001 11:15 AM To: Multiple recipients of list ORACLE-L Subject: Sad News - Jets crashed into World Trade Center Did anyone see this?

RE: OT RE: Interesting News..

Agreed 110%, that was just wrong. Friends have died this event. Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot

RE: Ftp from Oracle

It's possible if you setup a shell script which continually polls for information coming through on a DBMS_PIPE. A procedure within the database sends messages onto the pipe (the messages being Unix commands), the shell script then takes these commands from the pipe and builds another shell

RE: Ftp from Oracle

Hi Kev, Mind just posting the code to the list? I'm sure there will be many responses to yourself asking for this code, so it may be easier just to post it directly.. Cheers Mark -Original Message- Kevin Sent: Tuesday, September 11, 2001 15:00 To: Multiple recipients of list ORACLE-L

RE: New York/East Coast !!!!

Is there anyway we can submit names of family members in NY -Original Message- From: Stephen Andert [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, September 11, 2001 11:25 AM To: Multiple recipients of list ORACLE-L Subject: New York/East Coast I sure hope our members on the

RE: Ftp from Oracle

Are my emails getting through to this list??? I did send a couple of responses regarding this one but I haven't personally seen them.. K. :( -Original Message- Sent: 11 September 2001 15:50 To: Multiple recipients of list ORACLE-L The only way I would think would be an External

RE: STOP THE PRESS!!

The south Tower of the World Trade Center is no more. and Capitol Hill and the Pentagon have been hit also. hope all from the list who work in the vicinity are OK. -Original Message- Sent: 11 September 2001 15:25 To: Multiple recipients of list ORACLE-L List, I am sure many of you

RE: STOP THE PRESS!!

Its now 1. BOTH tower have fallen. 2. Pentagon hit by a plane. 3. All flights in US grounded And I am sure more to follow -Original Message- Sent: Tuesday, September 11, 2001 9:55 AM To: Multiple recipients of list ORACLE-L The BBC seems to have more

Re: OT: STOP THE PRESS!!

we just lost the 2nd tower. Mark Leith wrote: List, I am sure many of you Americans will have woken to this news, or maybe you got to work before it happened: I just saw on the news the World Trade Centre in NY, has just taken two direct hits from two separate aeroplanes!! Suspected

RE: Downloading from Oracle

No, DAP just doesn't kick in, even when it is browser enabled. I have been able to use DAP for many Oracle files, but it's that server in the east that doesn't allow DAP. The server hosts the Applications maintenance sets. Pat. -Original Message- From: Mark Leith [SMTP:[EMAIL

Re:User Query Tools

Stephen, We are in the end of just such a task for our end users. Consequently I'm going to forward your message to the project lead here. We looked at Brio Reports, Oracle's Discoverer 4i and Cognos Query. We limited our search to these for certain reasons, which I won't elaborate on.

RE: OT

Title: Message Similar wishes here. I wish the best for all involved. "Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes." Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax: (707) 885-2275

RE: STOP THE PRESS!!

Both buildings have now completely collapsed. I first found out about it when I stepped out of the PATH train station and saw the flames. Currently I'm stranded in New Jersey and going a little crazy about some friends that work in dowtown NYC, but otherwise I'm fine. My prayers are with all

Re: OT: STOP THE PRESS!!

Actually the World Trade Center is no more. Both towers have collapsed in on themselves. As for the economy, it will have global implications. Rachel, are you on today? How close is all this to you? Rodd Original Message On 9/11/01, 9:25:27 AM, Mark Leith [EMAIL PROTECTED] wrote

RE: OT

Title: OT this is the most bizarre day of my entire life. I watched the second tower collapse from my office window. I basically just feel completely sick to my stomach right now. I hope that there is no one on this list from NYC. kk -Original Message-From: [EMAIL PROTECTED]

RE: OT Breaking News

They were actually planes and not bombs. Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73 Princeton Street

RE: STOP THE PRESS!!

Yep, according to the live news Lee -Original Message- Sent: 11 September 2001 15:48 To: '[EMAIL PROTECTED]' Cc: '[EMAIL PROTECTED]' Capitol Hill? Are you sure? Pat. -Original Message- From: Robertson Lee - lerobe [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, September 11,

unable to insert into table with datatype raw

create table ff (dd raw(16)); SQL insert into ff (select hex_to_raw('234') from dual); insert into ff (select hex_to_raw('234') from dual) * ERROR at line 1: ORA-01465: invalid hex number SQL select hex_to_raw('234') from dual; HEX_TO_RAW('234')

RE: STOP THE PRESS!!

I am wondering whether this was an attack from outside, or from people like Timothy McVeigh. It seems to be awfully well co-ordinated, how could they breach security to that extent. Regards, Patrice Boivin Systems Analyst (Oracle DBA) Bedford Institute of Oceanography Fisheries and Oceans

RE: STOP THE PRESS!!

They found out the planes were not from boston (10 miles from me). I can't remember where they claimed to come from. Pentagon was confirmed not bomb, but 2 planes crashed into it, minor damage. Claim is when the market open (today or other) will open rock bottom and crashed. Claim for Martial

db link from oracle 8.1.7 to 8.0.5

Title: db link from oracle 8.1.7 to 8.0.5 hi list, i am trying to make a database link from oracle 8.1.7 to oracle 8.0.5, but its failing, giving message DB LINK NOT ACTIVE global_names parameter is false on both the database, the schema in which its being created exists in both the

RE: Do fast full index scans do physical disk reads?

Well thanks for you comment, but you are no means the list master. Why don't you send this useless email to everyone who posts off topic. Have a nice day -Original Message- Sent: Tuesday, September 11, 2001 10:12 AM To: [EMAIL PROTECTED] Apparently you never learned the lesson that

RE: STOP THE PRESS!!

According to AP. It looks like the entire island of Manhatten is one big ball of black smoke. AA Flt. 11 from Boston hit one WTC. UA FLt. 175 from boston hit the other. AA Flt. 77 hit the Pentagon. UA Flt 93 crashed in Pittsburg - questionable target?? Untold numbers of people dead in the

Terrorist Attacks.

...about two hours ago...when people were clustered around radios...not quite believing...hearing rumors...someone lost a quarter in the soda machine, which is quite heavy. As they shook it, the floor and walls rumbled. It sounded like a distant explosion. I found out at that moment how scared

Re: Inserting records into a table without creating indexes

No. There is no provision for deferred index creation in Oracle. Having faced similar issues with large, hot OKTP systems, I can sympathize. Be very picky about what indexes are allowed on tables with high insert rates. Careful segregation of the affected segments between disks.can help also.

News

Another plane crash in Pennsylvania. Take care friends Ramon E. Estevez [EMAIL PROTECTED] Dominican Republic 809-565-3121

Re[2]: Re[2]: RE: Interesting News..

Eric, One of these days some genius will figure out how we can do e-mail with video and audio vs. just plain text characters. Then the non-verbal messages maybe able to make the transit as well as the text which will kill a lot of these misunderstandings. Dick Goulet

RE: STOP THE PRESS!!

The first tower is down, the second one is falling, the Pentagon had two planes crash into it as well. Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher R. Spence Oracle DBA Phone: (978)

RE: OT: STOP THE PRESS!!

Terror attacks hit U.S. September 11, 2001 Posted: 1457 GMT People walk away from the World Trade Center as ash rains down. NEW YORK (CNN) -- Terrorists struck the United States Tuesday morning in harrowing, widespread attacks that included at least three commercial jet

RE: OT: STOP THE PRESS!!

and the State Department in DC. WTC 1 and 2 are down pray for the familes.. -Original Message- Sent: Tuesday, September 11, 2001 10:45 AM To: Multiple recipients of list ORACLE-L Looks like the Pentagon was also just bombed. Denise Gwinn [EMAIL PROTECTED] -- Please see the

Re: OT Terrorist Acts

At 12:15 PM 9/11/2001, you wrote: Yes, I see that and wish i could remove it. Consider it done We've just heard the towers went downjust incredible..i had never thought that i'd be there at the start of World War III. And wanted very badly to fight in it. to you all: someone once

TERRORIST ACTS

This Reuters report is spot on accurate from my seat, in downtown DC, about five blocks from White House. I am going out to have another look now, and will report back, but ...I have NEVER seen anything like this...people are shocked...there is NO business as usual attitude here. more

RE: OT RE: Interesting News..

Feeling Good. Keep it up. Ok guys, now tell us how you really feel. :o) I just about choked from laughing. Dave -Original Message- Sent: Monday, September 10, 2001 4:36 PM To: Multiple recipients of list ORACLE-L Eric, I join with you in emptying the contents of my venom sac

RE: What's wrong with this query

Thanks Lisa, I have been a system dba from many years. This is my very first involvement with the pl/sql.The application was created by an Oracle consultant Co I'm just monitoring the system and feel funny about this query.There is nothing I can change. -Original

RE: STOP THE PRESS!!

Forget the economy. Its going to piss off some Americans. There are other stories about other sites being hit, Pentagon, State Department, etc. It will probably take sometime to sort everything out from the rumors. -Original Message- Sent: Tuesday, September 11, 2001 10:25 AM To:

RE: OT

Title: OT Hey List I'm at work in downtown DC and its really weird. Most public building are evacuating. The subways are closed so the streets are very busy with cars and pedestrians. I could see the smoke from the Pentagon fire from my office and heard the sonic boom from the military

RE: OT Breaking News

The Financial Markets are shut down indefinitely My friends at NASDAQ are being sent home... The WTC was a massive massive center for pricing for an enormous variety of financial instruments. This will be hard to recover from quickly. But the money is nothing compared to the hollow heavy

RE: OT: STOP THE PRESS!!

Re. NY, a canadian news site posted this phone number if you have friends / relatives in NYC: FRIENDS/FAMILY IN NYC ? CALL 1-800-387-3124 The url for this site is www.bourque.com Pat. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL

RE: STOP THE PRESS!!

Title: RE: STOP THE PRESS!! The State Department was NOT hit. There was just an update... The attack on the Pentagon, however, was quite serious. .there were 50,000 people in the World Trade Center. -Original Message-From: Adams, Matthew (GEA, 088130)

  1   2   3   >