How to remove the Ora & Lstn services from the WinNT

2001-03-24 Thread Nirmal Kumar Muthu Kumaran
Hi gurus, I'm tried to Install Oracle 816, as the learner i did mistakes during installation. Now i did sucessfully. But when i checked in the WindowsNT servies, i found many oracle services that i was tried before. Could you tell me, how to remove those things from ther serivce panel. Thanks

Re: APPEND hint (Was: Which is faster??)

2001-03-24 Thread yong huang
Hi, Connor, The append hint to insert does not disable generating rollback info. It does stop redo generation for a nologging table. Yong Huang [EMAIL PROTECTED] you wrote: If you're on 8.0 or higher, try insert /*+ APPEND */ into table select * from other_table; where "table" is defined as

Re: ksh version problem (Was: Which is faster??)

2001-03-24 Thread yong huang
Hi, Mandar, I think your ksh is not Version 93. Here's from UWin (Korn shell for Windows, www.research.att.com/sw/tools/uwin/): $ var=tester $ echo $var tester $ echo ${var//e/o} tostor Unfortunately, it's not easy to get ksh93 on a UNIX box due to (I believe) licensing issues. Yong Huang [EMA

RE: Single Code Table or Separate Code tables dilemma

2001-03-24 Thread Jared Still
A 'single' code table is something that Gurry and Corrigan favor as a performance enhancement. I have not tried it myself; I feel about it as you do. If I were trying to wring every last bit of performance out of an app though, I would probably give it a shot. Jared On Fri, 23 Mar 2001, Jacq

Re: perl problem on linux

2001-03-24 Thread Jared Still
On Fri, 23 Mar 2001, Adams, Matthew (GEA, 088130) wrote: > I've got some developers trying to get > perl's dbi/dbd stuff working on linux, > and they keep getting ORA-2035 every time > the execute from a for loop. > > Anybody seen this before? OK Matthew, I'll bite. Everytime they execute wh

Re: syntax for trigger

2001-03-24 Thread gints
Try set long size to apropriate value, assuming You are using SQL*Plus set long (more than 1000) I don't know exactly the maximum value Gints Plivna > Hi all, > > How to find out the whole syntax for a trigger? > > The dba/all/user_source view don't have text for > trigger. The trigger_body co

Re: Log Buffer

2001-03-24 Thread Kevin Kostyszyn
Hey all, I just wanted to say thanks to everyone who is discussing this with me, I am enjoying it. Anyway, I am assuming that the problem has to be disk contention. As I said earlier, I only have two hd's on one controller. I am going to try and increase the buffer a little bit and increase

Re: NT Server very slow

2001-03-24 Thread Kevin Kostyszyn
Hey Jerry, Is this hardware dependant in any way? I have several instances of 8.1.6.0 and none of them have ever done anything like that. Then again, we are not a 24/7 shop and I am running cold backups every night, maybe that is why. Kev - Original Message - To: Multiple recipients

Re[2]: Dumb question...

2001-03-24 Thread dgoulet
I've several snapshots like this. They all work just fine. The problem you mention occurs if your trying to create the snapshot with the "refresh fast" option. Dick Goulet -- Reply Separator -- Author: Oracle DBA <[EMAIL PROTECTED]> Date: 3/23/01 2:30

Re: Re: SUN vs. HP

2001-03-24 Thread Allan Nelson
HP at version 10 and better is yet another SYSVR4 system. From a users or programmers point of view it is very generic. Service Guard is HP fault tolerant solution where two boxes share disk and if one node fails the other can take over. It is fairly complex and requires a good UNIX sysadmin. O

RE: Tuning Matter ==> Parameter PCT_USED in a Table

2001-03-24 Thread VIVEK_SHARMA
Could NOT follow the Calculation too . Can any explain ? > -Original Message- > From: Tim Sawmiller [SMTP:[EMAIL PROTECTED]] > Sent: Friday, March 23, 2001 6:35 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: Tuning Matter ==> Parameter PCT_USED in a Table > > Ok, I'

Re: Utl_file question

2001-03-24 Thread Bryan Sirtosky
Did you have END; on line 11? Bryan - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Thursday, March 15, 2001 9:42 AM Hallo all experts, I have written this procedure but get this error message. What is wrong? 1 DECLARE 2 emp_data UTL

RE: Oracle_In_NT !!!

2001-03-24 Thread Nihar
hi guys what i found is you can stop the oracle service called "oraclecmadmin".In most of the cases this service takes around 99% of cpu. - NIHAR SANGHVI NetMagic Solutions Pvt. Ltd. 22,Nirlon Complex,Western Express Highway, Goregaon (E), Mumabai 400 063 Phone: 8723003 extn: 144 www.netmag

Re: DBMS_REPAIR package usage

2001-03-24 Thread Murali Vallath
Hi Yong, How does one subscribe to this ? Murali Vallath Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Date: Sat, 24 Mar 2001 05:05:21 -0800 Hi, Winnie, How did you find the file# to be 9 (unless you messed with your original error message)? I sugg

Oracle DBA needed in Cincinnati,Ohio

2001-03-24 Thread OraStaff
Cincinnati, Ohio retailer has a need for an Oracle DBA. This is a full time staff position for someone who knows their stuff. Relocation assistance is available. *Requirements: - 4+ yrs Oracle DBA experience is needed --no lightweights please. - U.S. citizenship or permanent residency is require

Re: DBMS_REPAIR package usage

2001-03-24 Thread yong huang
Hi, Winnie, How did you find the file# to be 9 (unless you messed with your original error message)? I suggest you post your message to news:comp.databases.oracle.server (or http://news.interbulletin.com/cgi-bin/ibwrn/post/comp.databases.oracle.server if your company doesn't have a news server).