RE: how to send messages to other users

2003-11-26 Thread nelson flores
Isn't the wall utility used to send a message to everyone in Unix/Linux? i.e wall This Database will Self Destruct in 5 seconds (although the utility has been removed from some systems due to some security problems a.k.a root exploit) p.d : What's Outlook Express??? ;) -Original

RE: Linking to a SQL Server

2003-11-26 Thread Weaver, Walt
I have. It works. The steps: 1. Connect to Oracle. 2. Connect to SQL Server. 3. Transfer data, maybe using Perl. Or Python (this is for my buddy Steve Orr). 4. If it doesn't work, contact a call center in India. They know everything. Generic connectivity is, indeed, supported on Linux. I'll bet

bcv copy - duplicate rows unique prim key

2003-11-26 Thread Jeroen van Sluisdam
Hi, When I issue an alter table move statement and afterwards an alter index rebuild for the primary key on this table I got an error duplicate rows found. This primary key is unique. The database has just been migrated for test purposes. In production we are still on oracle 7.3.4.

RE: Linking to a SQL Server

2003-11-26 Thread Shiva Maran
Wanted a way to connect from within the Oracle DB. Cannot write the application to move data the way you have indicated. I did try Generic connectivity. Am getting the error while accessing the link as: ORA-2854: error diagnosed by Net8 when connecting to an agent NCRO: Failed to make RSLV

RE: sql trace - recursive relationships

2003-11-26 Thread Jamadagni, Rajendra
Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- Sent: Monday, November

Re: Active Directory and ORACLE passwords

2003-11-26 Thread Yechiel Adar
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,

RE: sql trace - recursive relationships

2003-11-26 Thread Jamadagni, Rajendra
Sorry about the last empty email ... Cary is right, the EXEC at dep=0 is the database call you should be looking for, why? because until #1 is parsed, db has no way of finding what needs to do. And once it finds that Oh I must run a SQL, the dep increases. So, I'd look for a subsequent EXEC

when do you use v$statname?

2003-11-26 Thread ryan_oracle
This view seems to be a smaller subset of v$sysstat? When is it useful? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California--

RE: when do you use v$statname?

2003-11-26 Thread Hately, Mike (LogicaCMG)
v$statname is a lookup table for the statistic# that appears in v$sesstat and v$sysstat. You use it in most queries on those tables unless you're named Tanel and have memorised the statistic numbers. =) Cheers, Mike Hately -Original Message- Sent: 26 November 2003 13:24 To: Multiple

RE: when do you use v$statname?

2003-11-26 Thread Jamadagni, Rajendra
doesn't v$statname store the statistics# and statistics_name ... it's like a lookup table. v$sysstat is the actual values for each of statistic. Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed

Re: RE: when do you use v$statname?

2003-11-26 Thread ryan_oracle
both store that info SQL desc v$statname Name Null?Type - STATISTIC# NUMBER NAME

RE: RE: when do you use v$statname?

2003-11-26 Thread Jamadagni, Rajendra
but only v$sysstat has the value column ... Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art !

Re: RE: when do you use v$statname?

2003-11-26 Thread ryan_oracle
v$sysstat has the NAME column also? From: Hately, Mike (LogicaCMG) [EMAIL PROTECTED] Date: 2003/11/26 Wed AM 08:34:26 EST To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: when do you use v$statname? v$statname is a lookup table for the statistic# that appears in

RE: RE: when do you use v$statname?

2003-11-26 Thread ryan_oracle
right, then why do we have v$statname? From: Jamadagni, Rajendra [EMAIL PROTECTED] Date: 2003/11/26 Wed AM 08:44:25 EST To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: RE: when do you use v$statname? but only v$sysstat has the value column ... Raj

RE: RE: when do you use v$statname?

2003-11-26 Thread Suhen Pather (S)
Ryan, V$sysstat is system wide statistics. It contains name, value and statistic# and class. V$statname is used mostly as a lookup. V$sesstat is session stats which does not contain the *statistic name* column. When joined with v$statname (statistic# column), the statistic name and values can

RE: UNIX OT: exclude files in tar

2003-11-26 Thread Stephen.Lee
Expanding the logic to its logical conclusion, we produce philosophies similar to that found at www.despair.com. CONSULTING: If you aren't part of the solution, then there is good money to be made in prolonging the problem. -Original Message- I like that logic! I might just start

Query temp segments blank

2003-11-26 Thread mkline1
It appears one database I can not query the temp tablespace. It's local, unform extents, but nothing shows up in dba_segments or any where I have found thus far. Has this progressed to a trust me type of situation? Even TOAD gives me nothing but blanks on objects in TEMP yet on other databases

RE: RE: when do you use v$statname?

2003-11-26 Thread Igor Neyman
You are right, that v$statname is not needed when querying v$sysstat, since v$sysstat has name column. But, if you look at v$sesstat: SQL describe v$sesstat; Name SID STATISTIC# VALUE

Re: sql trace - recursive relationships

2003-11-26 Thread Daniel Fink
But the previous email was a shining example of brevity in action! ;) I'll have to wait for Cary, et.al. as well as my understanding is the exact same as yours. Daniel Jamadagni, Rajendra wrote: Sorry about the last empty email ... Cary is right, the EXEC at dep=0 is the database call you

RE: sql trace - recursive relationships

2003-11-26 Thread Boris Dali
Thanks, Raj. So yes, as I said in my other email - the rule stated in the book seem to apply to EXEC db calls only (in case of SQL fired from PL/SQL). I guess I misinterpreted it the way that it applies to ALL db calls for recursive cursors. Thanks, Boris Dali. --- Jamadagni, Rajendra [EMAIL

Disadvantages of Remote Servers

2003-11-26 Thread WEBBER, VALERIE
What are the disadvantages to managing/deploying applications with a remote iAS server? Are there significant reason to try to have it local to the development? Thanks in advance! Valerie Valerie H. Webber Valspar Corporation 7930 W. Kenton Circle Huntersville, NC 28078 800-241-4568 ext.

RE: Linking to a SQL Server

2003-11-26 Thread Thompson, Todd
Walt- What version of Linux are you running?? As of RH 8.0 generic HS services were not supported by Oracle. In fact the hsodbc exe does NOT exist at $ORACLE_HOME/bin. Using Perl or Python does not qualify for generic connectivity in my book.. -Original Message- Sent:

RE: RE: when do you use v$statname?

2003-11-26 Thread Hately, Mike (LogicaCMG)
Good point. I'd forgotten that. Just a lookup for v$sesstat then. Cheers, Mike -Original Message- Sent: 26 November 2003 13:39 To: Multiple recipients of list ORACLE-L both store that info SQL desc v$statname Name Null?Type

Re: how to send messages to other users

2003-11-26 Thread Mladen Gogala
Well, init takes one numeric argument (level) and ignores everything else. That means that the command init 0 Please log off the database has the same effect as init 0. Trust me, users will get the message. Did you see the BOFH/BOFH flags? On 11/26/2003 02:09:24 AM, nelson flores wrote: Isn't the

Re: insert in batch loading

2003-11-26 Thread David Boyd
Janne, Thanks very much for your wonderful detail suggestion. I'll definitely use it to analyze the redo. David From: Jan Korecki [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: insert in batch loading Date: Tue, 25 Nov

RE: Disadvantages of Remote Servers

2003-11-26 Thread Stephane Faroult
Valerie, It depends on who you are, how remote is remote and the OS you are using. I guess that if you are a production DBA, the farther away from development the better. If you are a developer, you may be blocked by those mundane IT problems which spice our otherwise so dull lives, ie

RAC and parallelism

2003-11-26 Thread Bruno Vanters
Hi, While trying to import a dump, i got an error during create index: IMP-3: ORACLE error 1115 encountered ORA-01115: IO error reading block from file 23 (block # 47913) ORA-01110: data file 23: '/data/oracle/DEV/IS_D2C_02.DBF' ORA-27091: skgfqio: unable to queue I/O ORA-27072: skgfdisp: I/O

ORA-1000 and pl/sql cursor cache

2003-11-26 Thread Lord David
Hi Does anyone know whether its possible to control the size of the pl/sql static cursor cache. I'm running into ORA-01000: maximum number of open cursors exceeded errors and part of the problem (apart from the usual developers not closing explicit cursors) is that _all_ static sql statements in

Happy Thanksgiving

2003-11-26 Thread Paula_Stankus
Guys, Happy Thanksgiving to everyone. May your bellies be full but your waistline not expand, may you enjoy the time with your family and friends and avoid any of the other drama Thanks so much to everyone for their help and camaraderie. Just enjoy yaself! -- Please see the official

RE: Query temp segments blank

2003-11-26 Thread Vergara, Michael (TEM)
Well, you could try... select view_name from all_views where view_name like '%TEMP%'; ..and see what you get. I have lots of views that give me information about the TEMP tablespace. YMMV, but it's a place to start. Cheers, Mike -Original Message- Sent: Wednesday, November 26, 2003

migration sequence oci problem

2003-11-26 Thread Jeroen van Sluisdam
Hi, We're testing an oracle 9.2.0.4 database with an oracle 7 client. This is a C++ client, using OCI to go to oracle. We see strange behaviour when using a sequence which worked nicely before. The sequence is not incremented when issueing select res_id.nextval from dual When

RE: how to send messages to other users

2003-11-26 Thread Jamadagni, Rajendra
if the messages are sent over WAN, don't you think 1 minute is inadequate time? There is no built in utility in oracle to do what you need. You can however design something using a small java applet that uses dbms_alert and display the message. Raj

RE: Happy Thanksgiving

2003-11-26 Thread Jamadagni, Rajendra
Come to think of it, out fitness center has a special program ... it runs for 8 weeks and the aim is maintaining the weight ... no points for loosing any. bi-weekly weight watch and help to maintain weight is included. Happy Thanksgiving everyone ... Raj

RE: Happy Thanksgiving

2003-11-26 Thread Goulet, Dick
And may you all be back here on Monday, in one piece, safe sound. No DWI's now, you hear! Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 26, 2003 10:34 AM To: Multiple recipients of list ORACLE-L Guys,

RE: how to send messages to other users

2003-11-26 Thread Vergara, Michael (TEM)
If your users are part of your local network, you can use the Windoze NET SEND command. I have recently found that to be useful. UNIX/Linux utilities like 'wall' only send a message to users who are telnet'ed or rlogin'ed to the system. To send a message to a browser is not something I know how

RE: Happy Thanksgiving

2003-11-26 Thread Quintin, Richard
DWI = DDL while inebriated? On Wed, 2003-11-26 at 10:49, Goulet, Dick wrote: And may you all be back here on Monday, in one piece, safe sound. No DWI's now, you hear! Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- [mailto:[EMAIL PROTECTED] Sent:

RE: Happy Thanksgiving

2003-11-26 Thread Paula_Stankus
- yes esp. during the after-football game libations. -Original Message- Sent: Wednesday, November 26, 2003 10:50 AM To: Multiple recipients of list ORACLE-L And may you all be back here on Monday, in one piece, safe sound. No DWI's now, you hear! Dick Goulet Senior Oracle DBA Oracle

RE: Happy Thanksgiving

2003-11-26 Thread Mercadante, Thomas F
how 'bout a little DUI? -Original Message- Sent: Wednesday, November 26, 2003 10:50 AM To: Multiple recipients of list ORACLE-L And may you all be back here on Monday, in one piece, safe sound. No DWI's now, you hear! Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA

RE: Happy Thanksgiving

2003-11-26 Thread Paula_Stankus
Man - I need to switch jobs. -Original Message- Sent: Wednesday, November 26, 2003 10:50 AM To: Multiple recipients of list ORACLE-L Come to think of it, out fitness center has a special program ... it runs for 8 weeks and the aim is maintaining the weight ... no points for loosing

RE: Happy Thanksgiving

2003-11-26 Thread Jamadagni, Rajendra
Works too. Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- Sent:

RE: Happy Thanksgiving

2003-11-26 Thread Robertson Lee - lerobe
I reckon its DRIVING WHILE INTOXICATED but I woudn't swear to it as I am in the UK -Original Message- Quintin, Richard Sent: 26 November 2003 15:59 To: Multiple recipients of list ORACLE-L DWI = DDL while inebriated? On Wed, 2003-11-26 at 10:49, Goulet, Dick wrote: And may you all be

RE: Happy Thanksgiving

2003-11-26 Thread Goulet, Dick
In the UK I believe you simply classify it as driving without due care don't you?? Damn, wish the police around here had that capability. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Wednesday, November 26, 2003 11:10 AM To: Multiple recipients of list

Re: Happy Thanksgiving

2003-11-26 Thread Mladen Gogala
Happy Thanksgiving to everybody. As for maintaining the weight, that precisely is the problem. I am unable to lose weight, not to maintain it. There quite an abundance of me, I want to shrink. Does anyone know if oracle 10g has any options for shrinking DBAs? Something like ALTER DBA SET

Re: ORA-1000 and pl/sql cursor cache

2003-11-26 Thread Barbara Baker
David: I don't really know if this will help you, but it might be worth a try. You could try setting session_cached_cursors. Bjørn Engsig's white paper Efficient use of bind variables, cursor_sharing and related cursor parameters describes this parameter a bit. It can be found at

RE: Happy Thanksgiving

2003-11-26 Thread Igor Neyman
Mladen, You should be writing specs for Oracle11 -:) Happy Thanksgiving everyone... Igor Neyman, OCP DBA [EMAIL PROTECTED] -Original Message- Mladen Gogala Sent: Wednesday, November 26, 2003 11:44 AM To: Multiple recipients of list ORACLE-L Happy Thanksgiving to everybody. As for

RE: Query temp segments blank

2003-11-26 Thread mkline1
Below was the closest I got, but it still pretty much shows everything empty sort of. Guess it's okay, I'll monitor. This is a warehouse so it's hard to say. So close to the holidays, it's possible they aren't using a lot of temp. set linesize 162 set pagesize 30 column tablespace_name format

RE: Happy Thanksgiving

2003-11-26 Thread Paula_Stankus
No - but seriously - and I am not kidding my Dad sells Herbalife products and could probably actually help you with this Mladen. Frankly I think the stress - sitting our jobs entails adds a lot to this. Exercise we all probably really need because our jobs are so sedentary. Anyway, hang

RE: Happy Thanksgiving

2003-11-26 Thread rpr
Happy Thanksgiving to all I think it is DUI - driving under influence (of alcohol or watever )"Goulet, Dick" [EMAIL PROTECTED] wrote: In the UK I believe you simply classify it as "driving without due care" don't you?? Damn, wish the police around here had that capability.Dick GouletSenior Oracle

RE: Happy Thanksgiving

2003-11-26 Thread Robertson Lee - lerobe
nope. Drink driving -Original Message- Goulet, Dick Sent: 26 November 2003 16:34 To: Multiple recipients of list ORACLE-L In the UK I believe you simply classify it as driving without due care don't you?? Damn, wish the police around here had that capability. Dick Goulet Senior

Re: ORA-1000 and pl/sql cursor cache

2003-11-26 Thread ryan_oracle
are you looking for the init.ora max_open_cursors(dont think i typed it exactly right). even if the cursors are cached, they should not be counted as open. they doesnt make sense from an oracle design standpoint. From: Lord David [EMAIL PROTECTED] Date: 2003/11/26 Wed AM 10:34:34 EST To:

RE: when do you use v$statname?

2003-11-26 Thread Jeremiah Wilton
On Wed, 26 Nov 2003, Hately, Mike (LogicaCMG) wrote: v$statname is a lookup table for the statistic# that appears in v$sesstat and v$sysstat. You use it in most queries on those tables unless you're named Tanel and have memorised the statistic numbers. =) Remember Oracle likes to change

RE: Happy Thanksgiving

2003-11-26 Thread Bellow, Bambi
Oh, hell, I posted this privately to Mladen, but here it is for low-carb consumption... --- I've lost 50 lbs on Atkins, if that helps. It's really quite easy and haven't run into any of the pitfalls you hear about... oh, except the third day... that's hard. Bambi. -Original

Walt Weaver Family

2003-11-26 Thread Daniel Fink
I know this is OT and Jared has been kind enough to approve it. Many of us on the list have come to know and respect Walt Weaver. He and his family (wife Kathy, daughters Jenny and Caitlin) are currently enduring a very difficult situation. Jenny has recently undergone a bone marrow transplant in

Off-topic and off-color... the morning after

2003-11-26 Thread Bellow, Bambi
Friends -- Thanks for the responses... I have compiled them (and slightly edited some of them), and, at Jared's request, I have posted them elsewhere... www.eclec.com/jobpost.html Please post all flames to me directly. I can take it. Happy Turkey Day to everyone in the US, and Turkey, of

Parse Vs Execute

2003-11-26 Thread jaysingh1
Hi List, Almost fro all SQLs I am getting Prase count is same as Execute count. How to reduce parse count? 1) We are using bind variable 2) session_cached_cursors set to 100 call count cpuelapsed disk querycurrentrows --- --

Re: Re[2]: Deleting partitioned data

2003-11-26 Thread Tim Gorman
In addition to the effect on the optimizer, there is also the issue of the granularity of object locking. Explicitly naming a partition in a DML statement places a TM enqueue (a.k.a. DML lock) on just the partition. So, conflicting operations such as INSERT /*+ APPEND */ against other partitions

Re: sql trace - XCTEND rlbk=1, rd_only=1

2003-11-26 Thread Boris Dali
Thanks, Jared. Yes, running select vs select+rollback in a loop of 1000 iterations I got similar results (average over 3 runs): STAT...user rollbacks 0 1,000 1,000 LATCH...enqueues 570 1,574 1,004 LATCH...shared pool7,434 9,063 1,629 STAT...recursive 7,754 10,264

Re: Bad performance because of wrong characterset?

2003-11-26 Thread Tim Gorman
Pure bvllsh1t. Slap a sql trace on the process and find out what's actually going on. Stop the madness before some damager makes a stupid decision... In the end, they might be right. But isn't it better to be certain? on 11/17/03 3:49 AM, Carel-Jan Engel at [EMAIL PROTECTED] wrote: Hi

Re: Oracle networking temp files in /tmp

2003-11-26 Thread Pete Finnigan
Hi Rich Try lsof or fuser on them?, if you get the process ID you could try attaching truss to it and see what its being used for. IPC springs to mind? kind regards Pete -- Pete Finnigan email:[EMAIL PROTECTED] Web site: http://www.petefinnigan.com - Oracle security audit specialists

Re: Bad performance because of wrong characterset?

2003-11-26 Thread Carel-Jan
Hi Tim, and all others for your replies. Reminds me I've forgotten to close this thread. Some 'specialist' of the reseller came along, still convinced the characterset was wrong. Until he had to admit that he'd forgotten to create an index.. I was just asking the question to the List

Re: Happy Thanksgiving

2003-11-26 Thread Carel-Jan
Mladen wrote: ALTER DBA SET WEIGHT=240LBS BANK_ACCOUNT=10M DROP POINTS FROM DRIVERS LICENSE; Is there an undocumented _NLS_WEIGHT parameter to translate this LBS stuff to KG (Dumb metric units)? Regards, Carel-Jan -- There will allwasy be another 10 last bugs -- -- Please see the official

Re: when do you use v$statname?

2003-11-26 Thread Tanel Poder
:) Btw, I advise against memorizing statistic numbers, because they change over versions... Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, November 26, 2003 3:34 PM v$statname is a lookup table for the statistic# that appears

Re: RE: when do you use v$statname?

2003-11-26 Thread Tanel Poder
Hi! Lookup from v$statname must also be used for v$px_sesstat.. Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, November 26, 2003 4:34 PM Good point. I'd forgotten that. Just a lookup for v$sesstat then. Cheers, Mike

Re: Parse Vs Execute

2003-11-26 Thread Stephen Andert
Here is what I use to monitor my cursor use. If session_cached_cursors is at or near 100%, I increase is and continue to monitor. On the system I just checked I'm up to 500. This reduced my parse counts for some operations. The other thing is whether there are any compiler flags that need to

Re: Happy Thanksgiving

2003-11-26 Thread Tanel Poder
Happy Thanksgiving to everybody. As for maintaining the weight, that precisely is the problem. I am unable to lose weight, not to maintain it. There quite an abundance of me, I want to shrink. Does anyone know if oracle 10g has any options for shrinking DBAs? Something like ALTER DBA SET

Re: RAC and parallelism

2003-11-26 Thread Tanel Poder
Could anyone explain me the cause of this error? I am using RAC over NFSv3, 9.2.0.4, kernel 2.6.0-test6 This last line is your problem. I certainly hope you aren't running a production system on this configuration. Tanel. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net --

RE: Happy Thanksgiving

2003-11-26 Thread Nelson, Allan
42 pounds here on the same diet since August 25 -Original Message- Bellow, Bambi Sent: Wednesday, November 26, 2003 11:59 AM To: Multiple recipients of list ORACLE-L Oh, hell, I posted this privately to Mladen, but here it is for low-carb consumption... --- I've lost 50 lbs on

RE: what is oracle rdb?

2003-11-26 Thread Thater, William
Mogens Nørgaard scribbled on the wall in glitter crayon: That's how I came to deliver the first-ever course at Lego in their HQ in Denmark (in a town called Billund, but certainly not named after The Bill). yes i'm sure it's not named after me... oh you meant the other bill.;-) Oracle has

RE: when do you use v$statname?

2003-11-26 Thread Cary Millsap
V$SYSSTAT has a NAME attribute. V$SESSTAT doesn't. So seeing the name when you're using V$SESSTAT requires a join with V$STATNAME. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Performance Diagnosis 101: 12/16 Detroit, 1/27 Atlanta - SQL Optimization 101: 12/8

RE: Parse Vs Execute

2003-11-26 Thread Cary Millsap
Don't do this: Loop Parse Execute Fetch End loop Do this: Parse Loop Execute Fetch End loop If you parse inside your loop, then all that using bind variables will gain you is

RE: Oracle networking temp files in /tmp

2003-11-26 Thread Jesse, Rich
Yup, tried those with no hits. Those processes must be long gone. I had mistakenly copied over my Windohs version of SQLNET.ORA, which the SQLNET.AUTHENTICATION_SERVICES parameter seems to have a problem on Linux. I tried re-enabling that, but am unable to recreate the dumps. I also see that

Re: RE: Parse Vs Execute

2003-11-26 Thread ryan_oracle
i remember in tom kytes new book there is a 'softer parse' he was referring to using dbms_sql instead of execute immediate. Im not referring to using dbms_sql when you have to loop and use the same cursor repeatedly so you eliminate all parsing. he didnt go into great detail on this just gave

RE: what is oracle rdb?

2003-11-26 Thread Jesse, Rich
Brilliant, as always. Well deserved award, IMHO. No Academy(R) nomination on the way just yet, though. ;) BTW, the largest RDB customers seems like they've had a different experience than the littler ones. When Oracle bought RDB, they came to our parent company with a huge increase in the

OT: Who Wrote ...

2003-11-26 Thread Vergara, Michael (TEM)
I remember seeing a paper delivered at an IOUG wa back, that spoke of the 22-disk solution. I know it's old and outdated, but I'd like to find a copy. Does anyone remember who wrote and presented this paper? Thanks, and Happy Thanksgiving! Mike ---

Cobol redefine in SQL

2003-11-26 Thread Stephane Paquette
Hi all, We'll do a conversion from IMS to Oracle (817). The conversion team wants to move data on Oracle then processed it. Off course, in the file format, the cobol redefine command is used on a filler field (20 times). There is also a redefine command in a redefine command. For the younger

RE: [***SPAM***] - Cobol redefine in SQL - Found word(s) to be removed remove list error e-mail in the Text body.

2003-11-26 Thread Tony Johnson
I went thru a conversion like this many moons ago but was to DB2 and not Oracle but in the end was the same. We looked at each and decided what needed to be defined as a seperate table ( ie the key and redefined portion became a table) and others where we had the key and a large binary field

RE: Oracle networking temp files in /tmp

2003-11-26 Thread Jesse, Rich
A-ha! Just when I'm on the virge of bashing them, Oracle Support comes thru (to be fair, I've had very good response from them lately). The files are leftovers from linking and can be safely deleted. Americans, Happy Thanksgiving! The rest of the world, enjoy working tomorrow. Rich Rich

How to stop XDB

2003-11-26 Thread DENNIS WILLIAMS
My networking people just notified me that XDB has port 8080 locked. Since I wasn't aware that Oracle 9.2 had an XDB running, this quite has me baffled. Is this something I can stop? Oracle has a lot of documentation on how to configure it, etc., but I don't see a thing on stopping it. Any

Re: Cobol redefine in SQL

2003-11-26 Thread Carel-Jan
At 13:34 26-11-03 -0800, you wrote: Hi all, We'll do a conversion from IMS to Oracle (817). The conversion team wants to move data on Oracle then processed it. Off course, in the file format, the cobol redefine command is used on a filler field (20 times). There is also a redefine command in a

Re: Oracle networking temp files in /tmp

2003-11-26 Thread Gilles PARC
Rich, Cannot verify now but if I remember correctly, these files are generated by a program in $ORACLE_HOME/bin Look for something like gen* (gennttab ??) This program is generally called during some oracle relink. HTH At 11:04 25/11/2003 -0800, you wrote: Hey all, Running Oracle 9.2.0.4 on

Re: How to stop XDB

2003-11-26 Thread Tanel Poder
Hi! Check note 171658.1 from metalink, it has series of steps for removing XML stuff from database. Alternatively (if I recall correctly) you can just remove the XDB entry from listener.ora. Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent:

Oracle Version 8 as read only

2003-11-26 Thread Browett, Darren
We are in the process of upgrading our peoplesoft app, using an oracle database of 8.0.5 to 9i. During the upgrade we still need access to the old 8.0.5 database as readonly. I have read all the doc's but it appears I cannot open the database as read only. Looks like I could if the version was

RE: Oracle Version 8 as read only

2003-11-26 Thread nelson flores
Darren, Couldn't you just open the database with a user that has all the necessary privileges revoked? -Original Message- Browett, Darren Sent: Wednesday, November 26, 2003 3:44 PM To: Multiple recipients of list ORACLE-L We are in the process of upgrading our peoplesoft app, using an

Re: Oracle Version 8 as read only

2003-11-26 Thread Tim Gorman
You can't. Even if you were to set all possible tablespaces to READ ONLY, you'll find that it doesn't prevent folks from dropping objects. All you can do is restrict people to schemas/accounts which do not own any objects and do not have permissions to create any. That way, you can restrict

Re: OT: Who Wrote ...

2003-11-26 Thread Rachel Carmichael
Kevin Loney. And you can find the same information in the first version of the DBA Handbook --- Vergara, Michael (TEM) [EMAIL PROTECTED] wrote: I remember seeing a paper delivered at an IOUG wa back, that spoke of the 22-disk solution. I know it's old and outdated, but I'd like

Re: Cobol redefine in SQL

2003-11-26 Thread Jared Still
Oh, so *that's* what a cobol redefine is. How incredibly ugly. Must have been someone's crutch for poor (or no) design. Of course, I have seen this done in Oracle as well. Jared On Wed, 2003-11-26 at 13:34, Stephane Paquette wrote: Hi all, We'll do a conversion from IMS to Oracle (817).

Re: how to send messages to other users

2003-11-26 Thread mglim2
i can't use net send since not all users in the same local network. i can't also wall since all users are using win98. do u know any 3rd party software like winpop(forlocal network) that can send messages across the network? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net --

RE: how to send messages to other users

2003-11-26 Thread nelson flores
I think that you're going to have to take Mladen's advice and send an Email to everyone -Original Message- [EMAIL PROTECTED] Sent: Wednesday, November 26, 2003 5:14 PM To: Multiple recipients of list ORACLE-L i can't use net send since not all users in the same local network. i

RE: Oracle Version 8 as read only

2003-11-26 Thread Browett, Darren
Looks like that is what we will be doing, basically creating a generic user with read-only privileges. All the current users will have their password changed so they cannot access the system. Darren -Original Message- Sent: Wednesday, November 26, 2003 4:04 PM To: Multiple recipients

Re[2]: Cobol redefine in SQL

2003-11-26 Thread Jonathan Gennick
Wednesday, November 26, 2003, 7:44:25 PM, Jared Still ([EMAIL PROTECTED]) wrote: JS Oh, so *that's* what a cobol redefine is. JS How incredibly ugly. Must have been someone's JS crutch for poor (or no) design. No, no, no. REDEFINE is very powerful. It's part of the COBOL magic. Best regards,

O9i: MERGE tables across database links

2003-11-26 Thread MxmsG9
Hi, I am trying to merge data from two tables (over two servers, using dblink). Approx 40,000 records in each. Server1(source) and Server2(dest) On Server1, db-link dblink1 points to Server2 On Server2, db-link dblink1 points to Server1 Schema names are same on the two servers. PULL Data

RE: OT: Who Wrote ...

2003-11-26 Thread Vergara, Michael (TEM)
Thank You. -Original Message- Sent: Wednesday, November 26, 2003 4:24 PM To: Multiple recipients of list ORACLE-L Kevin Loney. And you can find the same information in the first version of the DBA Handbook --- Vergara, Michael (TEM) [EMAIL PROTECTED] wrote: I remember seeing a

Re: Oracle Version 8 as read only

2003-11-26 Thread Tim Gorman
Consider also using ALTER USER xxx ACCOUNT LOCK instead of changing the passwords... on 11/26/03 6:49 PM, Browett, Darren at [EMAIL PROTECTED] wrote: Looks like that is what we will be doing, basically creating a generic user with read-only privileges. All the current users will have their