Re: Unknown Oracle user

Might be someone cud have created the user and granted the DBA privileges. I have 8.1.7 db under winNT and Linux, I have not come across this user. Sys,system,outln are the 3 users created by default. HTH -- On Mon, 14 May 2001 21:45:21 Louis Avrami wrote: Hello all, I was scanning

RE: File open event

Hi Arun, Foreground processes open the datafiles only when they need to read from them (or write to them in the case of a sort). The 'file open' wait event represents the opening of and typically the first I/O operation against that datafile, however, sometimes a few extraneous I/O operations

Load a textfile

Hallo, How can I load a textfile into the database, the text file is semicolonseparated and I only need to impor two fields inthe database and not all records of thoss fields. Give me an example please Roland Sköldblom -- Please see the official ORACLE-L FAQ: http://www.orafaq.com --

RE: Can I partition my primary key constraint index?

What is the behavior difference of using a non-unique index to enforce a unique/primary key constraint when inserting a duplicate value ? Index range scan ? --- Brian MacLean [EMAIL PROTECTED] a écrit : ahhh, mostly right. I found in v8.1.6 that if I use a non-unique index to

RE: unable to create spatial index via dynamic_sql

May be like the reply to your previous question in that you may be able to create an index through a role from sqlplus but from pl/sql the privilege has to be granted directly to the user. Cheers Iain -Original Message- Sent: 15 May 2001 06:45 To: Multiple recipients of list ORACLE-L

OT: idle and non-idle waits on Unix

Hi, do you know how to seperate non-idle waits from idle-waits in OS level. For example, we can accept cron waits as idle waits because of nothing to do until expiration; we can accept IO waits as idle because of waiting something to do. or, can you send me a direction such as links, forums

RE: Unix

Use textedit -Message d'origine- De : [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Envoyé : lundi 14 mai 2001 16:01 À : Multiple recipients of list ORACLE-L Objet : Unix How can I modify a Unix file in an other editor not using vi, for instance I would like to use a Windows based

RE: Export question.

Well back down to earth with a bang again, back to work and the weather is miserable. I didn't see any replies to this last mail so I will repost. Any help or insight would be greatly appreciated. Regards Lee -Original Message- Sent: 11 May 2001 15:51 To: Multiple recipients of list

dbms_alert and dbms_mail utilities

Hi, Gurus, My client wants me to alert him from the application or send an email of spesific rows of a table daily. I have email programs but I want to do it with oracle packages. But I could not find documentation on dbms_alert and dbms_mail utilities .How will I do it ? Can you help

RE: SQL statement performance

Hi Guang, Try something like this: select distinct(spid) spid,name,commonname from ( select distinct(spid) spid,name,commonname from results a , species where a.queryspid = species.id union all select distinct(spid) spid,name,commonname from results b , species where

Re: Dead Lock in Temporary Tables 8.1.6 ... HELP !

Hi Vadim, Thanks for the reply. But, there is no index objects on that temporary table. Arul. Vadim Gorbounov wrote: Hi, Arul, Do you have index on this table? If yes, can you drop this index and try how it works? You may hit a bug. HTH Vadim -Original Message- Sent: Monday,

RMAN Catalog - Backup Strategy

DBAs I am taking the export backup of RMAN catalog DB from the Target DB server , immediately after the target DB RMAN backup. Is it a decent way or can it be done better? Cheers Raj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raj Gopalan INET: [EMAIL

file output of a SP

Hi Gurus, I have a problem, I am trying to output a txt file of my query results. But all these will be in a stored procedure, Andinthe procedure , how will I open a file and write to it and then close it ? Thanks

RE: DBSNMP user?

Yup it certainly is! Mark -Original Message- L. Sent: Monday, May 14, 2001 03:31 To: Multiple recipients of list ORACLE-L Is OracleOraHome81Agent the OEM agent? -Original Message- Sent: Monday, May 14, 2001 8:05 AM To: Multiple recipients of list ORACLE-L You can run the

RE: SQL statement performance

Here's another version of the query that has only 1 sort. SELECT a.spid, s.name, s.commonname FROM (SELECT /+* NO_MERGE(b) */ DISTINCT spid FROM (SELECT r.queryspid AS spid FROM results r ,species

Re: unable to create spatial index via dynamic_sql

Is the user executing the procedure the same user who owns the table for which the index is intended? [EMAIL PROTECTED] 05/15/01 01:45AM hi list, I am able to create index from Sqlplus as... create index i_sptl_test on ADDRESSED_PROPERTY_(polygon_geometry) indextype is

I need 1 file from you...

Hi guys, Could you please attach ora.hlp file for me (Ms version not an UNIX version) Or do you know where is this file located (unfortunately the CDs is not with me anymore). Thank you Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy Xing INET:

RE: I need 1 file from you...

Oh. ya... I am using Solaris 2.7 -Original Message- Sent: Tuesday, 15 May 2001 7:24 PM To: LazyDBA.com Discussion Hi guys, Could you please attach ora.hlp file for me (Ms version not an UNIX version) Or do you know where is this file located (unfortunately the CDs is not with me

RE: Tomato Story

Hi all, I found my job from internet... : ) Sinardy -Original Message- [EMAIL PROTECTED] Sent: Tuesday, 15 May 2001 5:56 AM To: Multiple recipients of list ORACLE-L Dick, That's the best parable I've read in longer than I can remember... grin Thanks, Scott Shafer San Antonio, TX

RE: Export question.

Ok, I'll pretend I'm from Missouri (the Show Me State). What's the database block size? What's the average row size? How many rows? What are the pctused and pctfree values? Are you using any weird data types (like LONG, RAW, that kind of stuff). Are you sure you are only exporting the

Re: strange problem

Hey Kirti! Congrats on your accomplishment of Tuning book. Must have been a gratifying experience. Keep the good work up! -Rahul Dandekar -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul Dandekar INET: [EMAIL PROTECTED] Fat City Network Services-- (858)

Reporting Solutions

For reporting we are currently using Oracle Reports and Seagate Info. Would like to know with which other products you've made good experiences. Martin -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thielenhaus, Martin INET: [EMAIL PROTECTED] Fat City Network

RE: file output of a SP

Look up UTL_FILE in your documentation set - it should handle this nicely. Ron Morton -Original Message- From: Bunyamin K. Karadeniz [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, May 15, 2001 7:35 AM To: Multiple recipients of list ORACLE-L Subject: file output of a SP Hi

Re: file output of a SP

Bunyamin, Check the UTL_FILE Oracle-supplied package references on OTN. You'll need to set a directory(directories) in your initSID.ora file to use the package which means you'll need to bounce the DB. Regards David A. Barbour Bunyamin K. Karadeniz wrote: Hi Gurus, I have a problem, I

RE: Export question.

OK here goes and thanks for the response Definitely one table and from the top :-) DB Block size = 8192 Avg. Row Size = 6 Num Rows = 57351031 Pct free = 0 Pct Used = 40 Table definition (column names removed) = Type NOT NULL NUMBER(9) NOT NULL NUMBER(9) NOT NULL NUMBER(9) NOT

RE: file output of a SP

The utl_file package has the functions procedures you need. From SQL*Plus, just do a describe on utl_file to get the entire list of functions procedures. HTH Prakash -Original Message- Sent: Tuesday, May 15, 2001 7:35 AM To: Multiple recipients of list ORACLE-L Hi Gurus, I have a

Re: file output of a SP

Thanks , I have done it. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, May 15, 2001 5:00 PM Bunyamin, Check the UTL_FILE Oracle-supplied package references on OTN. You'll need to set a directory(directories) in your initSID.ora

Re: Reporting Solutions

I had good experience using Brio's reporting solution. Richard Ji 387 Park Ave. New York City, NY 10010 [EMAIL PROTECTED] 05/15/01 09:20AM For reporting we are currently using Oracle Reports and Seagate Info. Would like to know with which other products you've made good experiences. Martin

RE: cdump, bdump, udump

Ron, You would not be able free the disk space even if alert.log is deleted. For example, if alert.log file size is 500 MB size and then you delete the alert.log, still you would not be able to get a disk free space of 500 MB. This space would be released once you bounce the database. The above

RE: Export question.

Lee, What version of the db is this? Bug 766095 generates inaccurate avg_row_len for tables over 4GB (fixed in 8.0.6). Is this a partitioned table and are you using FGAC (fine grained access control)? There's a bug where the entire table gets exported in the partition. I can't remember

RE: Load a textfile

Roland, SQL*Loader can do this, you will need to create a control file specifying FIELDS TERMINATED BY ';' and the fields you would like to import - something like: copy to .ctl file in notepad- LOAD DATA INFILE 'path/to/your/file/file_name.txt' Your text file

RE: Export question.

No kidding...it's got to be at least 38. 38 * 57351031 = 2.03 gigabytes, and I'm sure it's bigger than that... [EMAIL PROTECTED] 05/15/01 10:25AM OK here goes and thanks for the response Definitely one table and from the top :-) DB Block size = 8192 Avg. Row Size = 6 Num Rows = 57351031

RE: Export question.

Lee, Definitely sounds like bug 766095. It isn't listed in the patchset readme file for 8.0.5.2.1 so it doesn't appear to be fixed in 8.0.5, although there might be a patchset exception for your platform (check with support). The workaround is to estimate statistics using a percentage which

RE: Export question.

Many thanks, I will give this a try. Regards Lee -Original Message- Sent: 15 May 2001 15:04 To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Lee, Definitely sounds like bug 766095. It isn't listed in the patchset readme file for 8.0.5.2.1 so it doesn't appear to be fixed in 8.0.5,

Re: cdump, bdump, udump

On Solaris 2.5, 2.6 and 2.7, as well as AIX we have removed the alert.log and space has immediately become free. (Not true with the listener.log however). Terry Rao, Maheswara wrote: Ron, You would not be able free the disk space even if alert.log is deleted. For example, if alert.log

RE: Mean/Median

geez louise, Median := avg(Max,Min) || -Original Message- || From: Pat Hildebrand [mailto:[EMAIL PROTECTED]] || Sent: Monday, May 14, 2001 10:56 PM || To: Multiple recipients of list ORACLE-L || Subject: Re: Mean/Median || || || || || Any scripts (sql or pl/sql) out there to

Re: does oracle supports oracle 8.1.7. on sun solaris 8 (64bit) - pro

Oracle 817 is not available yet on Solaris. I asked Oracle support a while ago and they told me it would be for the beginning of may. I check yesterday at Oracle store and it was not available. I'll probably go for the 817 32bit. --- Narender Akula [EMAIL PROTECTED] a écrit : hi Gurus,

RE: Mean/Median

Are you stupid? evil grin Scott Shafer San Antonio, TX 210-581-6217 -Original Message- From: Mohan, Ross [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, May 15, 2001 12:27 PM To: Multiple recipients of list ORACLE-L Subject: RE: Mean/Median geez louise, Median :=

RE: Mean/Median

Thanks to all... -Original Message- Sent: Tuesday, May 15, 2001 10:27 AM To: Multiple recipients of list ORACLE-L geez louise, Median := avg(Max,Min) || -Original Message- || From: Pat Hildebrand [mailto:[EMAIL PROTECTED]] || Sent: Monday, May 14, 2001 10:56 PM || To:

Re: cdump, bdump, udump

The space is freed when the process accessing the file ends. In the case of the alert.log, it is accessed infrequently. The listener.log is constantly being updated on an active database and may not release as quickly. There are Unix commands which will show the pid accessing each file,

RE: Mean/Median

Oops, this only works for *even* numbers of samplesgeez || -Original Message- || From: Mohan, Ross || Sent: Tuesday, May 15, 2001 12:28 PM || To: '[EMAIL PROTECTED]' || Subject: RE: Mean/Median || || || geez louise, || || Median := avg(Max,Min) || || || -Original

RE: Running remote scripts

Put the ssh calls inside a Perl script using the Expect module for a very nice package indeed. Gerardo -Original Message- Sent: Monday, May 14, 2001 11:06 AM To: Multiple recipients of list ORACLE-L ssh is your friend. oli [EMAIL PROTECTED] wrote Hi All, Env. is TRU64 Unix

Script that will remove redundant rows from table

Title: auditing tables A few months ago I remember seeing a script that enabled the removal of redundant rows in a table. Can someone please forward or point me to such a script. I have an Oracle Names server that stores the database connect descriptors in a table within the Region

Script that will remove redundant rows from table

A few months ago I remember seeing a script that enabled the removal of redundant rows in a table. Can someone please forward or point me to such a script. I have an Oracle Names server that stores the database connect descriptors in a table within the Region Database. I've loaded these connect

RE: DB Link Between Prod and Test?

If all he needs is select he cannot corrupt the DB if the DBA does not grant unnecessary privileges. Folks use dblinks all the time. Rick -Original Message- Sent: Tuesday, May 15, 2001 2:26 PM To: Multiple recipients of list ORACLE-L One of our development DBAs suggested today to

RE: Mean/Median

I differ If your dataset was: 1, 1, 2, 3, 4, 10, 11 Min = 1 Max = 11 Avg = 4.5+ Avg(Min,Max) = Avg(1,11) = 6 Median = 3 (central value in the dataset) -Original Message- Sent: Tuesday, May 15, 2001 7:27 PM To: Multiple recipients of list ORACLE-L geez louise, Median := avg(Max,Min)

RE: Mean/Median - how to be wrong multiple times

Cripes, it doesn't work at all! LoL...i pulled the trigger way too fast on this one. || -Original Message- || From: Mohan, Ross || Sent: Tuesday, May 15, 2001 12:36 PM || To: '[EMAIL PROTECTED]' || Subject: RE: Mean/Median || || || Oops, this only works for *even* numbers of

RE: DB Link Between Prod and Test?

Can he be trusted NOT to run some horrible query that would bring Prod to its knees? [EMAIL PROTECTED] 05/15/01 03:00PM If all he needs is select he cannot corrupt the DB if the DBA does not grant unnecessary privileges. Folks use dblinks all the time. Rick -Original Message- Sent:

RE: file output of a SP

UTL_FILE is the package you should be looking for HTH Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any

Re: cdump, bdump, udump

On Tuesday 15 May 2001 11:36, Thater, William wrote: On Tue, 15 May 2001,Peter Barnett scribbled on the wall in glitter crayon: -There are Unix commands which will show the pid accessing each file, -including those supposedly deleted, but it has been a long time since I -was a sys admin.

enqueue waits

Hi List, I'm trying to identify the possible cause of contention in a database: Oracle 7.3.4.0.0 // HP-UX 10.20 // FINANCIALS As far I can see, event "enqueue" is on top (followed by some buffer busy waits) EVENT TIME_WAITED AVERAGE_WAITenqueue 854176 3746.39 (why is the

RE: Mean/Median

I did a procedure for median some time back. Here is the algorithm that I used. 1. Define a Cursor - Dont forget to use the Order by Column while defining. Ofcourse, U should order by the column on which you need median. 2. Get a count of records that cursor would return ( Regarding How to get

RE: Can I partition my primary key constraint index?

Title: RE: Can I partition my primary key constraint index? I don't know. I made the non-unique index by mistake and noticed that the index did not drop when I was correcting the mistake. -Original Message- From: paquette stephane [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 15,

RE: sys.IDL_UB1$

Thanks to everyone who replied! -Original Message- Sent: Monday, May 14, 2001 6:31 PM To: Multiple recipients of list ORACLE-L Hi Jay, Does anyone know what the SYS.IDL_UB1$ table is? It suddenly grew to app. 100Meg in my Development database. I tried searching on it on Ixora on

Re: Mean/Median

I'm not familiar with that syntax, is it one of the 9i self-tuning, self-managing feathures? On 14 May 2001, at 22:15, Jared Still wrote: Here's the script I have for median. ... Aˤ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eric D. Pierce INET:

OT: Heard of Peregrine Power Enterprise?

Anyone out there had experience with Peregrine Software's Power Enterprise? I just started at a new client and got thrown onto a project which will be using this on Oracle. They chose this package, don't have technical details about it, don't have the software but the developers plan on

RE: Mean/Median - how to be wrong multiple times

If you don't like the last one I sent try this one 1: #include stdio.h 2: exec sql include sqlca; /* communication area */ 4: main() 5: { 6: exec sql begin declare section; 7: VARCHAR cid[5], user_name[20], user_pwd[10]; 8: double

RES: Script that will remove redundant rows from table

--- BEGIN LOOP DELETE FROM table_name WHERE ROWID IN (SELECT MIN (ROWID) FROM table_name GROUP BY column_list HAVING COUNT (*) 1); EXIT WHEN SQL%NOTFOUND; END LOOP; COMMIT; END;

FORALL / bulk bind insert

I am trying, for the first time, to use bulk binding on insert. Assuming I have a type defined as MESSAGE_CONTENT%ROWTYPE INDEX BY BINARY_INTEGER, and a variable, v_message_content, of that type: I've tried the insert as FORALL i in 1..fcount insert into message_content values

RE: FORALL / bulk bind insert

You have to have 1 collection (index by table) per column. In your example, you would need to have 3 index by tables: v_order_event_idmessage_contentorder_event_id%TYPE INDEX BY BINARY_INTEGER; v_message_field_id message_field_id%TYPE INDEX BY BINARY_INTEGER;

RE: DB Link Between Prod and Test?

Yes, we were doing the same thing. Until I found the links. I've been trying in vain to explain what an FTS of our 6 million row G/L does to a production database. Did I mention that there was an ORDER BY clause on that query? sigh Good luck! Rich Jesse

RE: Mean/Median

Well, no, it doesn't work at all. The definition of Median is a value where half your list of values is above, and half is below. If the values all tend toward the mininum or the maximum, this equation would be way out of line. [EMAIL PROTECTED] 05/15/01 01:35PM Oops, this only works for

RE: does oracle supports oracle 8.1.7. on sun solaris 8 (64bit) - pro

I am confused again... I thought Oracle was developed on solaris, then ported to the other UNIX flavours? I would have expected them to have the latest version available for solaris before any other OS. Although lately they seem to be putting the emphasis on development for NT, which confuses

Re: cdump, bdump, udump

Do you have frequest writes to your alert log? If you try to remove will it is being written to, it will not release the space. We tend to remove our logs during periods of low acitivity, so the file is not likely to be being written to. So we have not seen the space not released. Terry Rao,

ADMIN: 2nd Beta of web-based ODTUG archives now available

Hello everyone... I have just finished making some changes to the ListGuru web-based archive facility (http://www.fatcity.com/ListGuru), if anyone would like to try it out. There are about 180 people who have signed up for the first beta, so I know some of you should be able to give it a whirl.

Re: DB Link Between Prod and Test?

On Tue, 15 May 2001,[EMAIL PROTECTED] scribbled on the wall in glitter crayon: -One of our development DBAs suggested today to build a private database -link between production and test database so that he can run some -queries against both at the same time. I am a little concerned because he

RE: Mean/Median

try this float salary[100]; /* populate the host array */ EXEC SQL EXECUTE DECLARE TYPE NumTabTyp IS TABLE OF REAL INDEX BY BINARY_INTEGER; median_salary REAL; n BINARY_INTEGER; ... FUNCTION median (num_tab NumTabTyp, n INTEGER) RETURN REAL IS BEGIN

Re: imp/exp privilege ?

Glasrot, Nechama wrote: How can I create the environment that allows UserA to export his schema, and UserB can import fromuser=UserA touser=UserB. I think the BECOME USER privilege might possibly be what you're looking for. GRANT BECOME USER TO userb; Does that do what you want? It is

RE: Load a textfile

http://otn.oracle.com/doc/server.804/a58244/ch04.htm (free registration still required?) ps, I have *not* been able to figure out how to get to the _Utilities Manual_ on http://docs.oracle.com , which is *very* annoying. On 15 May 2001, at 7:10, Mark Leith wrote: Date sent:

RE: DB Link Between Prod and Test?

Title: RE: DB Link Between Prod and Test? I created a 'READER' id on production for our datawarehouse guys. The dblink connects from dw to production as user READER, and READER has select authority on the specific prod tables that they are supposed to be looking at. DW has multiple ids. The

RE: DB Link Between Prod and Test?

Title: RE: DB Link Between Prod and Test? Is he an idiot? (I couldn't resist) We go to extreme lengths to ensure that nobody can link our devlopement and production databases together in any shape or form. It's just a bad idea. R. Matt Adams - GE Appliances - [EMAIL PROTECTED]

RE: enqueue waits

see p2text and p3text for more. Sounds like a one-time long-held table/row lock to me. If you can, bounce the instance and recheck for reoccurence hth Ross I wish I could do statistics Mohan -Original Message- Sent: Tuesday, May 15, 2001 2:50 PM To: Multiple recipients of list

RE: enqueue waits

Hi Diego, Without going into details, an 'enqueue' wait is mostly due to a user/program initated transaction lock and I see it a lot in Financial databases (I see you are on 10.7?). I deduce you were looking at V$SYSTEM_EVENT - If a user locked one row (probably queried a row in Forms,

/TEST/IDIOT/Re: ADMIN: 2nd Beta of web-based ODTUG archives now available

/TEST/IDIOT/ On 15 May 2001, at 11:16, Bruce Bergman wrote: Date sent: Tue, 15 May 2001 11:16:15 -0800 To: Multiple recipients of list ODTUG-DEV2K-L [EMAIL PROTECTED] I have just finished making some changes to the ListGuru web-based archive facility

RE: DB Link Between Prod and Test?

Title: RE: DB Link Between Prod and Test? I agree with that Matthew. But if you still have touse the link make sure you give the user the appropiate provilegesand assign him a "profile" to limit the ammount of resources he can consume with his queries. This way he can't slow down the prod

RE: Duplicate keys message two

borrowed from Ari Kaplan of this list: delete from table_name a where rowid (select min(rowid) from table_name b where a.column_name=b.column_name) / Original message rejected due to Binaries ROR mª¿ªm -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers

RE: Load a textfile

Eric, AFAIK, all of the manuals are not available at http://docs.oracle.com Mainly installation and client manuals along with a smattering of other manuals for which I haven't quite figured out the rationale determining their inclusion. In any event, your best bet is either technet or metalink.

RE: cdump, bdump, udump

1. Space occupied by alert.log is freed once you delete the file. 2. You may not see an immediate reclamation of free space. Try to do sync ( In solaris) and notice the free space. Also, try more than one method of free space checking - Using du, bdf, sam or sysadmin tools. -Original

Re: Script that will remove redundant rows from table

I use this one that Araplan posted a while back: delete from table_name a where rowid (select min(rowid) from table_name b where a.column_name=b.column_name) / From: Haskins, Ed [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject:

RE: Mean/Median

doesn't work AT ALL? Ha! Gotcha! It works when N=2! I call it my highly-specialized e-commerce predictor solution sound of mad laffter; running down the street || -Original Message- || From: Tim Sawmiller [mailto:[EMAIL PROTECTED]] || Sent: Tuesday, May 15, 2001 3:27 PM ||

RE: Mean/Median

Are you an idiot? ;- || -Original Message- || From: Eric D. Pierce [mailto:[EMAIL PROTECTED]] || Sent: Tuesday, May 15, 2001 4:01 PM || To: Multiple recipients of list ORACLE-L || Subject: Re: Mean/Median || || || I'm not familiar with that syntax, is it one of the 9i ||

No Subject

set oracle-l digest -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith Goad INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Re: DB Link Between Prod and Test?

Bill, Thanks for the info. You just provided me some ammo to shoot this one down :) Dennis Meng Database Administrator Focal Communications 847-954-8328 Thater,

Re: does oracle supports oracle 8.1.7. on sun solaris 8 (64bit) - pro

According to a presentation by an Oracle salesperson at the last Upstate New York Oracle User's Group meeting (held at Oracle in Rochester), Oracle no longer develops on Sun. They have changed their development platform to HP-UX. Boivin, Patrice J wrote: I am confused again... I thought

RE: FORALL / bulk bind insert

That's what I figured out while I waited for my email to hit the list! Thanks! -Original Message- Sent: Tuesday, May 15, 2001 4:31 PM To: Multiple recipients of list ORACLE-L You have to have 1 collection (index by table) per column. In your example, you would need to have 3 index by

OT RE: Mean/Median

ROFL! I am an idiot || -Original Message- || From: [EMAIL PROTECTED] || [mailto:[EMAIL PROTECTED]] || Sent: Tuesday, May 15, 2001 2:11 PM || To: Multiple recipients of list ORACLE-L || Subject: RE: Mean/Median || || || Are you stupid? || || evil grin || || Scott Shafer || San

RE: Load a textfile

A., That's what I thought, but I wanted to remain open to celebrating the positive possibility of a nurturing, benovolent universe were rational behavior is unconstrained by the vagaries and vicissitudes of the dark side of the farce. Or maybe I was hoping that I'd get a secret, mystical

RE: Script that will remove redundant rows from table

Sorry for the multiple posts...I first sent this message yesterday and it never posted...I tried a couple times today. Looks like there was some sort of backup between my mail server and the Lists'. I've also received a solution!! Thanks, Ed Haskins Oracle DBA Verizon Wireless -Original

Fwd: Re: How to find DUPLICATE KEYS FOUND

Hope this is what you were looking for. message two to follow. ROR mª¿ªm how about select rowid,p_id,p_name from p_answer pa where rowid (select min(pa2.rowid) from p_answer pa2 where pa.p_id = pa2.p_id and pa.p_name = pa2.p_name) This will display the p_id,p_name and rowid of all the

RE: cdump, bdump, udump

OK. I would test this. scheduled a cron to run in the night to remove alert.log (of course after copying!!). Rao [EMAIL PROTECTED] -Original Message- Sent: Tuesday, May 15, 2001 4:55 PM To: Multiple recipients of list ORACLE-L Do you have frequest writes to your alert log? If you

Fwd: Re: How to find DUPLICATE KEYS FOUND message two

encoded content removed -- binaries not allowed by ListGuru The previous attachment was filtered out by the ListGuru mailing software at fatcity.com because binary attachments are not appropriate for mailing lists. If you want a copy of the attachment which was removed, contact the sender

Re: Mean/Median

No, Median := avg(Max,Min) does not work (not for 'even', nor for 'odd' numbers of samples). Igor Neyman, OCP DBA Perceptron, Inc. (734)414-4627 [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, May 15, 2001 1:35 PM

RE: Mean/Median

HELP Are you stupid? -- 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: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Re: DB Link Between Prod and Test?

How about creating a user that only has read-only rights? --- [EMAIL PROTECTED] wrote: One of our development DBAs suggested today to build a private database link between production and test database so that he can run some queries against both at the same time. I am a little concerned

RE: DB Link Between Prod and Test?

Well, you could create a user in the production database that only has select privileges and then create the database link to access that account. The big thing you'd have to be careful of here is that the person doesn't try to run some crazy query that bogs down the production system (but you

RE: cdump, bdump, udump

Rao, I didnt follow this thread from the beginnig, but if you primary task is to release disk space, try echo alert.log (or cat /dev/null listener.log) instead of rm. HTH Vadim Gorbounov Oracle DBA -Original Message- Sent: Tuesday, May 15, 2001 2:50 PM To: Multiple recipients of list

RE: DB Link Between Prod and Test?

Dennis, We use DB links to allow selects where data info is needed on two instances. One is a report type and the other is being updated by the users all day. They work great. To keep the table naming simple and allow the application to be written on one development instance, I use synonyms to

TNG vs BMC Patrol

Hi All, I am looking for opnion on using CA's TNG for monitoring Oracle. I have used BMC Patrol before but never TNG. If anyone has used or evaluated both products, please let me know what you think of it. Thanks Richard Ji 387 Park Ave. New York City, NY 10010 -- Please see the official

RE: cdump, bdump, udump

Look like this message did not get thru.. sending again. Pl. Ignore if repeat 1. Space occupied by alert.log is freed once you delete the file. 2. You may not see an immediate reclamation of free space. Try to do sync ( In solaris) and notice the free space. Also, try more than one

RE: Mean/Median

HELP Aˤ On 15 May 2001, at 12:55, Mohan, Ross wrote: Are you an idiot? ... || I'm not familiar with that syntax, is it one of the 9i || self-tuning, self-managing feathures? ... || Here's the script I have for median. || || ... || || || Aˤ -- Please see the official

  1   2   >