Re: Another NT question

2001-06-27 Thread Bunyamin K. Karadeniz
We will try nearly 1000 concurent users. But not yet. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, June 27, 2001 12:32 AM Anybody currently have more than 500 concurrent users on an NT box? Just trying to validate a compaq claim that

RE: Data Transfer to Oracle 8i from SQL server 6.5 and back

2001-06-27 Thread paquette stephane
You can also have a look at heterogeneous services, I was able to run a stored proc in SQL Server 6.5 from Oracle 816/Sun using dynamic SQL but Oracle Support told me it was not support. --- Harvinder Singh [EMAIL PROTECTED] a écrit : u can use DTS provided by SQL server or migration utility

RE: trigger on user logoff session

2001-06-27 Thread Raymond Lee Meng Hong
Thank Stephane...it sound like a idea to work it out. -Original Message- Sent: Tuesday, June 26, 2001 7:26 PM To: Multiple recipients of list ORACLE-L Hello , Can I know whether is it possible for me to set up a trigger to activate if any user active this in-house logoff

No Subject

2001-06-27 Thread novicedba
LISTS

RE: OT RE: 24 x 7 on NT?

2001-06-27 Thread Peter McLarty
Whilst I wholeheartedly agree. Whoa less caffeine :-) Peter At 05:10 PM 26/06/2001 -0800, you wrote: Apparently you dont have any respect for the late Douglas Adams. Tisk Tisk! I'm certianly not saying that NT isnt good for what it was designed to do... workstation/end user platforms. Its a

Re: Common Oracle RDBMS Misconceptions

2001-06-27 Thread MHately
Sorry, that attempt at humour has been withdrawn due to quality control issues. Regards, Mike |+--- || novicedba | || novicedba@ho| || tmail.com | || | ||

RE: Install Database and Developer software on the same machine

2001-06-27 Thread Szecsy Tamas
You should put them into separate Oracle Homes. Tamas Szecsy -Original Message- Sent: Wednesday, June 27, 2001 10:10 AM To: Multiple recipients of list ORACLE-L machine Hello, here is the information you asked me for: developer version:2000 oracle version 8.1.6 OS version: NT /98 The

help

2001-06-27 Thread Adams, Simon
HELP ORACLE-L ** COLT Telecommunications Registered in England No. 2452736 Registered Office: Bishopsgate Court, 4 Norton Folgate, London E1 6DQ Tel. 020 7390 3900 This message is subject to and does not create or vary any

Re: 24 x 7 on NT?

2001-06-27 Thread Paul Drake
[EMAIL PROTECTED] wrote: Well, I guess so if that was the only occurrence. I'll never know and I doubt that they will fess-up. At any rate, If one wants to use NT or any other OS for that matter in a 24x7 guaranteed manner then one should look into making as much as possible redundant.

RE: OT RE: 24 x 7 on NT?

2001-06-27 Thread Mark Leith
I dont like to sit on my ass as others pass 3rd rate information about a 3rd rate os on to others... The idea that Bill Gates has appeared like a knight in shining armor to lead all customers out of a mire of technological chaos neatly ignores the fact that it was he who, by peddling second-

RE: OT RE: 24 x 7 on NT?

2001-06-27 Thread Rajesh Dayal
You know it make me laugh how a whole lot of people out there moan about point and click technology - YET the business that I am in - third party GUI tools for databases - is BOOMING! So what is it? DBA's don't like a point click O/S - but one to help them with their job, is OK... Just my 50p

Unix/HP-UX report for disk balancing

2001-06-27 Thread Adams, Simon
Hi all I have about 60 machines without any documentation at all, I want to get started on the hardware so I can then map on the database files. Does anyone no of a utility that will report on the disk architecture on the server that gives number of disks with there partitions and maybe other

RE: Common Oracle RDBMS Misconceptions

2001-06-27 Thread Garner, John (NESL-IT)
Tee hee Mike said spank hooo ho -Original Message- Sent: 26 June 2001 14:47 To: Multiple recipients of list ORACLE-L I've never found hot backups shocking myself. Is it possible that rather than visiting Jeremiah's site at www.speakeasy.net poor old novicedba visited

Re: PL/SQL (remote procedure call)

2001-06-27 Thread G . Plivna
You should call it using parameters at the very end For example my remote procedure is: create or replace procedure qaqa (in_bzz IN varchar2 default 'bzzz') is begin insert into qaqa1 values (in_bzz); commit; end; / On current server execute such statements: SQL exec qaqa@repsislink PL/SQL

RE: Common Oracle RDBMS Misconceptions

2001-06-27 Thread Nikolay Kumanov
Yes, but look also at bug 1176609. Dr. Nikolay Kumanov MIS Manager, Zeitungsgruppe Bulgarien GmbH 47, Tsarigradsko chaussee, Sofia 1504, Bulgaria phone: +(359-2)4339-643, fax: +(359-2)946-1286 mailto:[EMAIL PROTECTED] Show me a completely smooth operation and I'll show you someone who's

RE: Common Oracle RDBMS Misconceptions

2001-06-27 Thread Ravinder_Bahadur
I guess so .. as when I told the new guys at my place about they very much went into defensive mode on this one. Christopher

Re: EMN0 process problem

2001-06-27 Thread Ravinder_Bahadur
Could it be that your OEM is starting the event monitor process. Just guessing Ravinder Stephane

DESIGN suggestions needed.

2001-06-27 Thread Andrey Bronfin
Title: DESIGN suggestions needed. Dear all ! We have a client-server application which runs agains one Oracle DB. Now , we've got a requiremenet to split our DB into 3 databases ( one for each country we support - don't ask me why ) . So , we need to design it the way our existing

Re: EMN0 process problem

2001-06-27 Thread A. Bardeen
It's a harmless, but misleading error message. The EMN0 process (new in 8i) is the Event Monitor process used by AQ (see note 105067.1 What is the EMN0 process? for more details). I believe it's not started unless AQ_TM_PROCESSES 0. Like PQ processes that are idle long enough it will

RE: Install Database and Developer software on the same machine

2001-06-27 Thread Mark Leith
Have you tried installing the developer software in to seperate Oracle_Home - call it Dev_home or something.. It is the same with OEM anyway.. HTH Mark -Original Message- Martinez Jimenez Sent: Wednesday, June 27, 2001 09:10 To: Multiple recipients of list ORACLE-L Hello, here is

Re: OT: Re: Common Oracle RDBMS Misconceptions

2001-06-27 Thread Rachel Carmichael
Joe, Oops, not that I forgot, I don't think I knew. okay KEVIN!!! :) Will send him a new copy to put up there. Rachel From: [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: OT: Re: Common Oracle RDBMS

RE: help

2001-06-27 Thread Mark Leith
Are you an idiot? :) Redirect this mail to [EMAIL PROTECTED] my friend.. Dorothy -Original Message- Simon Sent: Wednesday, June 27, 2001 10:27 To: Multiple recipients of list ORACLE-L HELP ORACLE-L ** COLT

Function slows the select

2001-06-27 Thread Csillag Zsolt
Hi, In the following select statement I have a function GetSid that slows the update for hours even if the Link_keszit updatable table consists of a few rows. Update UpdateTable--Varosokat updatel Set UpdateTable_Column1= -- ( Select distinct 'Some string

RE: DUPLICATE VALUE CHECK

2001-06-27 Thread Shirish Khapre
hi all thanx for all those who contributed... my prob is solved now.. special thanks to rudy zung.. thanks again Shirish Khapre, SE Rolta India Ltd. Off Ph No. (+91) (022) 832,826,8300568 Ext'n 2730 Minds are like parachutes. They only function when they are open -- Please see the

RE: OT RE: 24 x 7 on NT?

2001-06-27 Thread Mark Leith
Oh I agree with what you are saying there - and that is EXACTLY why we don't deal with any tools that actually touch user data (unless you count reorganizing tables/tablespaces etc..). And I'm not sure which tool you are actually talking about, there are good and bad in the market place.. I

RE: DUPLICATE VALUE CHECK

2001-06-27 Thread Shirish Khapre
Title: RE: DUPLICATE VALUE CHECK is it possible in oracle 8.0.5? shirish -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Koivu, LisaSent: Wednesday, June 27, 2001 12:37 AMTo: Multiple recipients of list ORACLE-LSubject: RE: DUPLICATE VALUE

Re: OT RE: 24 x 7 on NT?

2001-06-27 Thread Gregory Conron
On June 27, 2001 07:55 am, Mark Leith wrote: slapping developers - what's the problem with them? No problem slapping developers rather enjoy it actually The issue I have with point click is the increasing number of database admins who can only use these tools. Put them in front of a

RE: Re[2]: OT RE: 24 x 7 on NT?

2001-06-27 Thread Peter McLarty
Hi Try checking out all of your drivers. A mate of mine recently purchased a new motherboard and Athlon 900, firstly it seemed to run like a dog, after a bit of looking around he found out that it was probably the VIA chipset, so on went the new drivers, seemed to run better but still not

Re: Install Database and Developer software on the same machine

2001-06-27 Thread Beatriz Martínez Jiménez
Yes, I have tried this. I select a different route for the developer during its installation. I get first an alert saying that if I select an installation location different from the one already set, I will deactive the products installed on it. Despite of this, I select this different folder,

RE: Re[2]: OT RE: 24 x 7 on NT?

2001-06-27 Thread Mark Leith
I think I came across the route of the problem now. I have in fact installed all updated drivers from VIA, flashed the BIOS, switched IRQ's for my network card (it was in the adjacent PCI slot to the AGP slot) so there are no IRQ conflicts. I went on to the ELSA web support page, and discovered

RE: OT RE: 24 x 7 on NT?

2001-06-27 Thread Rachel Carmichael
Mark, My only problem with GUI tools (and as an aside it was I believe Oracle's Migration GUI that failed for that member of the list) is that newbies use the tools and don't learn the underlying structure and data beneath them I think GUI tools are a great boon. If nothing else, it gives

Re: OT RE: 24 x 7 on NT?

2001-06-27 Thread Peter McLarty
Oh I agree As a newbie to the Oracle fold I found it oh so easy to dive into stuff with the DBA Studio, I suppose the thing that stops me is some 7 or more years hacking around Linux and Unix systems. Graphical tools are great for some things but you just cant beat the capabilities of a good

Re: 24 x 7 on NT?

2001-06-27 Thread Peter McLarty
Interesting rambling, I had never seen a fault tree before but had in some way used one at times without understanding how to really use what i was doing, I will have to study these links some more Peter At 01:21 AM 27/06/2001 -0800, you wrote: [EMAIL PROTECTED] wrote: Well, I guess so

Re: OT RE: 24 x 7 on NT?

2001-06-27 Thread MHately
More on the same vein. Sorry if this thread is developing a me too feel. I'm happy to use GUI tools when they save me time. I know what they're doing and how they achieve their results. The availability of GUI tools is however a huge disincentive for new DBAs to find out how the database

RE: NT Script ?

2001-06-27 Thread Mercadante, Thomas F
Kevin, Sorry, I thought I sent you what I had. The script below will return the hour and minute, but getting the seconds are difficult, unless you use a Perl script. Secondly, the script below does not distinguish between 8AM and 8PM - both are returned as 8, another reason that I don't think

listener.log

2001-06-27 Thread Farnsworth, Dave
I have a listener.log that is rather large. I want to archive the current one and create a new one. From what I can tell is that I have two options. 1) -Shut down the listener service (8.1.7 on NT 4.0) -rename the current log -startup the listener service again and

direct I/O with VxFS

2001-06-27 Thread KC
Dear list, Our shop is running Solaris 2.6, Oracle database 8.0.6 and Veritas VxFS file system. At present, all database file access thru the file system buffer cache, we decided to use the direct I/O mount option with VxFS for performance reason. There is one issue I am not sure about and

RE: OT RE: 24 x 7 on NT?

2001-06-27 Thread Thater, William
On Tue, 26 Jun 2001,Kevin Kostyszyn scribbled on the wall in glitter crayon: -Oooh...wow! Quick, maybe we should run out and convince 90% of the -business world that their entire infrastructure is a complete and udder pipe -dream and that the idea of trying to simplify our lives with the

RE: Common Oracle RDBMS Misconceptions - standby db?

2001-06-27 Thread Koivu, Lisa
Title: RE: Common Oracle RDBMS Misconceptions - standby db? I guess that's the scenario I was thinking of, Stephane. Primary completely hosed and needing modification in one way or the other... and several hours between failover and switching back with the possibility of a few lost

RE: Sqlplus--how to suppress Connected.

2001-06-27 Thread Deshpande, Kirti
Care to share a working example? Thanks, - Kirti Deshpande Verizon Information Services http://www.superpages.com -Original Message- From: Khedr, Waleed [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, June 26, 2001 7:07 PM To: Multiple recipients of list ORACLE-L Subject:

RE: OT RE: 24 x 7 on NT?

2001-06-27 Thread antonio . belloni
Hi, The GUI is nice and very productive , but how an OS could pretend to be 24x7 when if you change configuration you must restart the computer. Regards, Antonio Belloni Sherman, Edward [EMAIL PROTECTED]@fatcity.com on 26/06/2001 19:42:48 Please respond to [EMAIL PROTECTED] Sent by:

Re: JDeveloper Connection to Oracle DB

2001-06-27 Thread Don Jerman
JDeveloper may not have installed in the same oracle home as your regular Oracle client, first see if you have more than one Oracle home directory on your computer, either by checking the registry under HKEY_LOCAL_MACHINE/Software/Oracle or by searching for the TNSNAMES.ORA file. Then ensure

RE: Common Oracle RDBMS Misconceptions - standby db?

2001-06-27 Thread Koivu, Lisa
Title: RE: Common Oracle RDBMS Misconceptions - standby db? Thank you Jeremiah for your explanation. But to clarify, you can't have both databases open at the same time, can you? That's where I hosed stuff up the first time, and I realized why it didn't work immediately after seeing my error

RE: OT: Re: Common Oracle RDBMS Misconceptions

2001-06-27 Thread Toepke, Kevin M
Rachel: The problem seems to be the ftp from work to the OOUG web site (it gets corrupted in the transfer.) I'll try again later from home. Kevin -Original Message- Sent: Wednesday, June 27, 2001 6:45 AM To: Multiple recipients of list ORACLE-L Joe, Oops, not that I forgot, I don't

RE: OT.OT.OTRE: DUPLICATE VALUE CHECK is Clumsy

2001-06-27 Thread Thater, William
On Tue, 26 Jun 2001,Mohan, Ross scribbled on the wall in glitter crayon: -[Mohan, Ross] Depends on the instructor...classvibe. For something -like that, i usually follow suit rather than try to train my fellow -classmates to see the same level and type of humor that I do. I find I -can

Re: OT RE: 24 x 7 on NT?

2001-06-27 Thread JOE TESTA
Mike, i'm with you there. alter database datafile '/fill/in/name/here' resize 200m; or right click in OEM and change the size. As long as you can do the previous then might as well use the latter :) joe [EMAIL PROTECTED] 06/27/01 09:26AM More on the same vein. Sorry if this thread is

RE: Another NT question

2001-06-27 Thread Thater, William
On Tue, 26 Jun 2001,Mohan, Ross scribbled on the wall in glitter crayon: -Does it matter NT/Alpha or NT/Intel? alpha is no more... intel bought it out and shut it down. -- Bill Shrek Thater Certifiable ORACLE DBA Telergy, Inc.[EMAIL PROTECTED]

RE: Unix/HP-UX report for disk balancing

2001-06-27 Thread Sherman, Edward
You might try the cfg2html script It dumps the ioscan,bdf,lvdisplay,pvdisplay,etc. as well as a lot of other information about the machine, into an html file that you can view on your browser. It might be a quick way to get some documentation on your 60 machines. You can download it at:

RE: Install Database and Developer software on the same machine

2001-06-27 Thread Kevin Kostyszyn
This is what I do, first I install Developer, make sure it is installed into the DEFAULT_HOME. After that I install Oracle into a new home, Ora81. This has always worked for me, just remember that it is a multi homed machine, so there may be some tweaking involved, but the Oracle Home Selector

RE: listener.log

2001-06-27 Thread Hallas John
Dave, This came from the list a few weeks ago. I amended it slightly but it still all works. John #!/bin/ksh # Script to copy out listener.log and compress it. ORACLE_BASE=/u01/app/oracle export ORACLE_BASE ORACLE_HOME=$ORACLE_BASE/product/8.1.6 export ORACLE_HOME

RE: OT.OT.OTRE: DUPLICATE VALUE CHECK is Clumsy

2001-06-27 Thread Thater, William
On Tue, 26 Jun 2001,[EMAIL PROTECTED] scribbled on the wall in glitter crayon: -them and it should be fun. (unless you are training to be an assassin -because they have to be mean). no, an assassin must NOT be mean... you must be neutral and unemotional. trust me. -- Bill Shrek Thater

RE: DESIGN suggestions needed.

2001-06-27 Thread Jack C. Applewhite
Title: DESIGN suggestions needed. Andrey, Perhaps 3 physical DBs are unnecessary. Have you investigated Oracle8i's "Virtual Private Database" feature - AKA Fine-Grained Access Control or Row Level Security? It allows you to guarantee that each User has access to only the data to which she

RE: Griping about auditing (not the Oracle Kind)

2001-06-27 Thread Richard Ji
That's actually a good idea. We can control the world by taking over all the data. We will be so powerful. :) [EMAIL PROTECTED] 06/25/01 11:45AM A non-DBA? Is that because we stick together like the Mafia or something?! g -Original Message- Sent: Monday, June 25, 2001 3:32 PM To:

RE: OT RE: 24 x 7 on NT?

2001-06-27 Thread Mark Leith
EXACTLY!! I never say that a tool should be used instead of command line - I'm a great believer of having to know both - as there are pros and cons for both sides of the coin! There are times when the back end agent of a monitoring tool, monitoring on regular basis and alerting you by your mobile

Oracle DBA with CRM needed in California..

2001-06-27 Thread OraStaff
Oracle DBA with CRM experience (Seibel strongly preferred) Newport Beach, CA. Base Salary up to 100K- D.O.E. This is a full time staff position so no sub-contractors or third parties please. Please do not send a resume if you are not in the U.S. and/or need sponsorship. For immediate

IOT or not IOT : second post

2001-06-27 Thread paquette stephane
This is a second post, I thought I would have more than 1 answer Hi all, Vacation is over ! We'll have some tables with a PK and between 1 and 3 other fields . Those tables will be insert once and read 2 to 7 times. I'm wandering about the use of IOT and done some tests. When inserting 700

RE: Sqlplus--how to suppress Connected.

2001-06-27 Thread Mark Leith
Could you not just : SET FEEDBACK OFF CONNECT / AS SYSDBA ?? -Original Message- Kirti Sent: Wednesday, June 27, 2001 02:21 To: Multiple recipients of list ORACLE-L Care to share a working example? Thanks, - Kirti Deshpande Verizon Information Services

Re: EMN0 process problem

2001-06-27 Thread Richard Ji
EMN0 is for advanced queueing, are you using AQ or uses something that might use AQ? Richard [EMAIL PROTECTED] 06/27/01 06:30AM Could it be that your OEM is starting the event monitor process. Just guessing Ravinder

RE: OT RE: 24 x 7 on NT?

2001-06-27 Thread Richard Ji
I think GUI tools are a great boon. If nothing else, it gives damagement a pretty screen to look at while I am working on something else :) But isn't it better to let the damagement see me furiously typing at the keyboard? :-) If the damagement see you solved the problem by couple of clicks,

RE: Another NT question

2001-06-27 Thread Mohan, Ross
Do you think that has anything to do with the size of the user base reporting those bugs? -Original Message- Sent: Tuesday, June 26, 2001 7:10 PM To: Multiple recipients of list ORACLE-L I believe Oracle on NT/Alpha has fewer bug reports against it than Oracle on NT/Intel.

RE: Deadlock Detection - Resolved

2001-06-27 Thread Mercadante, Thomas F
All, thanks to Anita, Waleed, Riyaj, Vladimir and Ravinder for pointing me to Bug #132899 in regard to my Deadlock problem. I upgraded the database from release 8.1.6 to 8.1.7.1 (on NT) and the problem went away. thanks again Tom Mercadante Oracle Certified Professional

RE: NT Script ?

2001-06-27 Thread Kevin Kostyszyn
Once again Tom, can't thank you enough for this:) KK -Original Message- Thomas F Sent: Wednesday, June 27, 2001 8:57 AM To: Multiple recipients of list ORACLE-L Kevin, Sorry, I thought I sent you what I had. The script below will return the hour and minute, but getting the seconds

RE: OT.OT.OTRE: DUPLICATE VALUE CHECK is Clumsy

2001-06-27 Thread Koivu, Lisa
Title: RE: OT.OT.OTRE: DUPLICATE VALUE CHECK is Clumsy I can't imagine you shutting your mouth Ross... really! Sorry, couldn't resist :) -Original Message- From: Mohan, Ross [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, June 26, 2001 6:12 PM To: Multiple recipients of list ORACLE-L

RE: OT RE: 24 x 7 on NT?

2001-06-27 Thread Ron Rogers
Come on get real.. Who has had a Unix box for 88 years? Unless of course the box in a satellite circling the earth and the crossing of the dateline constitutes a day ROR mª¿ªm [EMAIL PROTECTED] 06/26/01 03:18PM Here's my Unix box: # uptime 12:09 pm up 32,245 days, 1:01, 14543 users,

Re: direct I/O with VxFS

2001-06-27 Thread Connor McDonald
The argument for direct io is that if you already have a large cache (the oracle one), then its not much use having a second copy of that cache (the unix one) - that memory could possibly be better used elsewhere (supporting more users, large sort sizes etc etc etc) So having direct io is giving

EXECUTING DOS COMMAND IN A STORED PROC?

2001-06-27 Thread Bunyamin K. Karadeniz
Hi gurus, I want to create a stored procedure to move some files to a different location. CREATE OR REPLACE PROCEDUREmove_file (file_name varchar2) IS begin host copy C:\file_name.txt D:\file_name.txt; end; / But does not recognize COPY command here. How can I do that?? Thank you

RE: Common Oracle RDBMS Misconceptions - standby db?

2001-06-27 Thread mohammed bhatti
tears of happiness thank you, thank you, thank you... /tears of happiness --- Jeremiah Wilton [EMAIL PROTECTED] wrote: With graceful standby failover (I demo'd it last year at OOW), you can switch back and forth, back and forth as many times as you want without recopying any database.

HOW TO SUBSTR INSTR THIS LIST

2001-06-27 Thread Stas
Hey all, I've got this list of names. It's not a very structured list. So my question would be how do I get this names in a select statement and break them up in columns: first name (is the first name in list), last name (last one), middle name (everything in between first and last names) I

RE: listener.log

2001-06-27 Thread Robertson Lee - lerobe
All, Can someone explain to me if there is anything wrong with the following as I don't issue the lsnrctl set log_file command. I seem to remember someone saying in the original thread that this can cause problems. I have been running the following method for months with no ill effects. cp the

RE: OT RE: 24 x 7 on NT?

2001-06-27 Thread Rachel Carmichael
no, THEY look at the screen, while I type away in any case, no matter what I do, they think it's easy. I think I do my job a little *too* well (kidding!) From: Richard Ji [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: OT

how to know latest file creation on a partition

2001-06-27 Thread Seema Singh
Hi How to know the latest file generated in single partition? Suppose /root is one partition. I want to know what are the files generated since 50 days.IS there any command to know? Thanks -Seema _ Get your FREE download of MSN

RE: Install Database and Developer software on the same machine

2001-06-27 Thread Mike J Kurth
I believe you need to install products that do not use the universal installer first (Developer), then install products that do use the universal installer (rdbms). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mike J Kurth INET: [EMAIL PROTECTED] Fat City

FW: Sqlplus--how to suppress Connected.

2001-06-27 Thread Mark Leith
Ba, forget I said this - case of fingers kicking in before the brain I'm afraid:) -Original Message- Sent: Wednesday, June 27, 2001 03:16 To: [EMAIL PROTECTED] Could you not just : SET FEEDBACK OFF CONNECT / AS SYSDBA ?? -Original Message- Kirti Sent: Wednesday, June 27,

LISTENER.LOG file compress

2001-06-27 Thread Seema Singh
Hi My Listener.log file big.I want to rename the listener.log file.Can you please suggest the steps. Thanks -Seema _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ:

RE: LISTENER.LOG file compress

2001-06-27 Thread Mark Leith
Look in the thread just opened, and answered called listener.log answered by John Hallas. -Original Message- Sent: Wednesday, June 27, 2001 04:36 To: Multiple recipients of list ORACLE-L Hi My Listener.log file big.I want to rename the listener.log file.Can you please suggest the

RE: OT.OT.OTRE: DUPLICATE VALUE CHECK is Clumsy

2001-06-27 Thread Mark Leith
And here's me thinking that the great US of A had an Executive Order banning them from ever taking part in any assassination - ever.. :) Or do you mean of the military kind Shrek? As an aside Bill, how did you go from being a SEAL to a DBA?? I have to say - Huge Respect!! -Original

RE: Sqlplus--how to suppress Connected.

2001-06-27 Thread Deshpande, Kirti
hps1 [DBOP]: sqlplus -s /nolog set feedback off connect / as sysdba Connected. NEXT !!! :) - Kirti Deshpande Verizon Information Services http://www.superpages.com -Original Message- From: Mark Leith [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, June 27, 2001 10:21 AM To:

RE: 24 x 7 on NT?

2001-06-27 Thread Mohan, Ross
*VERY* Interesting! Thanks, Paul. (where is Eric?) -Original Message- Sent: Wednesday, June 27, 2001 5:21 AM To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] wrote: Well, I guess so if that was the only occurrence. I'll never know and I doubt that they will

Quotes in Oracle

2001-06-27 Thread C.S.Venkata Subramanian
Hi All, In my appln I want to insert quotes along with the data ie like abc's from the application. Quotes may be there in some data but not there in some data. Any idea how to Achieve this from any frontend. TIA Regards Venkat Get 250 color business cards for FREE!

Re: Legato NetWorker RMAN: A troublesome pair?

2001-06-27 Thread Tommy Pham
Ed, I use cron. One of the requirement for scheduling through Lagato's GUI is that you must keep the backup scripts in the /nsr/../bin/ (this's where all the nsr executables are found). I am attempting to try this option but, haven't have time yet. Also, the main backup script must be

Mark's Wild A** Vid Card

2001-06-27 Thread Mohan, Ross
Mark, I bow at your feet. I also got a big kick out of: heads will roll.. Not sure who's yet.. But OH BY GOD - HEADS WILL ROLL.. I like this thread alotit shows the system nature of things, more than the isolated analysis we can all get stuck in. Robert Pirsig called those gumption

RE: OT RE: 24 x 7 on NT?

2001-06-27 Thread Rachel Carmichael
Mark, You list ALL the SQL the blocker has or only the SQL that is doing the blocking? I've been looking for a tool that does the latter for a long time and never found one that can identify the statement, if other SQL has happened in the meantime Rachel From: Mark Leith [EMAIL PROTECTED]

RE: Common Oracle RDBMS Misconceptions - standby db?

2001-06-27 Thread Winnie_Liu
Also check out the notes on metalink: #90817.1. It states all the steps and concept clearly! Winnie -- \ /~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~`~~``~ (@ @) @}-`-,-`-,--- Winnie Liu ---'-,-'-,-{@`~`~ / V \ Oracle Database Administrator`~`~

RE: listener.log

2001-06-27 Thread Mohan, Ross
won't LSNRCTL RELOAD do this trick? -Original Message- Sent: Wednesday, June 27, 2001 9:36 AM To: Multiple recipients of list ORACLE-L I have a listener.log that is rather large. I want to archive the current one and create a new one. From what I can tell is that I have two

OT:OT: LITTLE HUMOR:)

2001-06-27 Thread Kevin Kostyszyn
Don't know if anyone has seen this, but I thought it was sort of funny:) And no, this is not serious and has nothing to do with my beliefs, my friends beliefs, my parents beliefs, my company's beliefs or my pets or anything else that I am affiliated or otherwise associated with:) Interesting

RE: Another NT question

2001-06-27 Thread Mohan, Ross
Not so fast, there, Cisco Kid. It's not quite dead. There is some talk about doing the EV7 thing all the way, and even if the branding goes away, the technology is likely to migrate. Alpha has/had some killer memes. They won't die. -Original Message- Sent: Wednesday, June 27, 2001

RE: how to know latest file creation on a partition

2001-06-27 Thread Tirumala, Surendra
Try this: find /root -mtime -50 -print fyi, this gives the files that have been created/modified in last 50 days. -Original Message- Sent: Wednesday, June 27, 2001 11:41 AM To: Multiple recipients of list ORACLE-L Hi How to know the latest file generated in single partition? Suppose

RE: Sqlplus--how to suppress Connected.

2001-06-27 Thread Tirumala, Surendra
Try this: sqlplus -s /nolog 1/dev/null 2/dev/null connect / as sysdba HTH, Suren Consultant DBA, Sony -Original Message- Sent: Wednesday, June 27, 2001 12:01 PM To: Multiple recipients of list ORACLE-L hps1 [DBOP]: sqlplus -s /nolog set feedback off connect / as sysdba Connected.

Virus?

2001-06-27 Thread Kevin Kostyszyn
Hey, did anyone recieve a bunch of emails for a Venkata Apparao N with attachments. It appears to just be peaces of emails and then a see attached and an attachement? Yeah, I'll get right on opening that up. Sincerely, Kevin Kostyszyn DBA Dulcian, Inc www.dulcian.com [EMAIL PROTECTED] --

Re: Sqlplus--how to suppress Connected.

2001-06-27 Thread Vladimir Begun
On Jun 27, 2001 at 08:01:03AM, Deshpande, Kirti wrote: hps1 [DBOP]: sqlplus -s /nolog set feedback off connect / as sysdba Connected. NEXT !!! :) [0][box:pts006][~](8) sqlplus -S /NOLOG @dummy Emulating... SLOGAN --- I'm doing something usefull

RE: Another NT question

2001-06-27 Thread A. Bardeen
Ross, It is as far as Oracle is concerned. Compaq Alpha NT was desupported as of 4/30/01 (see note 93651.1). -- Anita --- Mohan, Ross [EMAIL PROTECTED] wrote: Not so fast, there, Cisco Kid. It's not quite dead. There is some talk about doing the EV7 thing all the way, and even if the

RE: NT Script ?

2001-06-27 Thread Mercadante, Thomas F
Kevin, did you see Bruce's script he sent on Tuesday? It does exactly what you want (and what I didn't know how to do!). It is included below - thanks Bruce - I tried it and it works like a charm. Who says we need Perl (Jared) :) Tom Mercadante Oracle Certified Professional

RE: Deadlock Detection - Resolved

2001-06-27 Thread Kevin Kostyszyn
Sorry to butt in guys, but what is Bug #132899 , I can't find it on Metalink? Kev -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Mercadante, Thomas FSent: Wednesday, June 27, 2001 12:09 PMTo: Multiple recipients of list ORACLE-LSubject:

RE: EMN0 process problem

2001-06-27 Thread Farnsworth, Dave
Seema, I also am having this exact same problem. It happened last night during the nightly backup scripts which issue a shutdown immediate and then I get the Restarting dead background process EMN0 message in my SIDAlert.log and then my database hangs. I am currently searching metastink. I

RE: Another NT question

2001-06-27 Thread Mohan, Ross
yes no i am not making clear what i am saying.yes Alpha will die, fairly soon yes iTanium is the latest/next best/greatest, etcbut no Alpha technology...advances...will be rolled into future Intel Chips...no doubts -Original Message- Sent: Wednesday, June 27, 2001 11:43

RE: RE: Horrifically, Vertiginously OT RE: NT Script

2001-06-27 Thread Mohan, Ross
Watch Out!! VENKATA APPARAO is sending out Viral attachments. I have mailed him already, but feel free to do so yourself! YIKES! -Original Message- Sent: Wednesday, June 27, 2001 12:34 PM To: [EMAIL PROTECTED] 'Mohan, Ross' wrote: - LoL! - - Every sect needs its special

RE: OT RE: 24 x 7 on NT?

2001-06-27 Thread Sherman, Edward
Been running since 1913. Cool! In 1919 E. 0. Carissan (1880-1925) built a factoring machine http://www.math.uwaterloo.ca/~shallit/Papers/carissan.html -Original Message- Sent: Wednesday, June 27, 2001 12:14 PM To: Multiple recipients of list ORACLE-L Come on get real.. Who has had a

Global edit of table

2001-06-27 Thread John Dunn
I would like to be able to amend all occurences of a string in all columns of all rows of a table. Can I do this, without specifying individual column names? Please note that the string may include forward slashes / John -- Please see the official ORACLE-L FAQ: http://www.orafaq.com --

Virus Warning on mail from this List

2001-06-27 Thread Kevin Lange
Guys; I just recieved a virus sent from Venkata Apparao N Please do not open any mail from this person up .. and definitely not the attachments. Good thing my e-mail scanner is working. -Original Message- Sent: Wednesday, June 27, 2001 11:14 AM To: Multiple recipients

RE: LISTENER.LOG file compress

2001-06-27 Thread Farnsworth, Dave
Seema, I just posted a question on this earlier today. If you are on unix I was given this suggestion from John. #!/bin/ksh # Script to copy out listener.log and compress it. ORACLE_BASE=/u01/app/oracle export ORACLE_BASE ORACLE_HOME=$ORACLE_BASE/product/8.1.6 export ORACLE_HOME

  1   2   3   >