OT Start Button

2001-09-16 Thread Swapna_Chinnagangannagari
Title: OT Start Button Hello All, Sorry for posting a OT. How can i change the text of the START button. I'm using windows'95. Regards Swapna

Re: PL/SQL stment

2001-09-16 Thread Konrad BKo
Hi Make define p_empno in the header of script and undefine in the end then it's work's ! Regards - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Sunday, September 16, 2001 7:15 AM Hi lists the flwng DECLARE V_sal emp.sal%type; BEGIN

Re: Read only snapshot

2001-09-16 Thread Konrad BüKo
Hi What is exactly your Problem ? With which Oracle - Versions ? Regards Rudi - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Saturday, September 15, 2001 1:35 AM !! Please do not post Off Topic to this List !! All, We are trying to

RE: OT Start Button

2001-09-16 Thread Walthour, Jon (GEAE, Compaq)
Title: Message You can't. Jon Walthour -Original Message-From: Swapna_Chinnagangannagari [mailto:[EMAIL PROTECTED]] Sent: Sunday, September 16, 2001 3:50 AMTo: Multiple recipients of list ORACLE-LSubject: OT Start Button Hello All, Sorry for posting a OT.

Re: OT Start Button

2001-09-16 Thread Jan Pruner
No, it is possible. 4-5 years ago I was using W95 and there was a small 'tuning' utility to change look of Windows GUI. Take a look on skinning of Windows software and you will find something. Best regards JP On Sun 16. September 2001 14:20, you wrote: You can't. Jon Walthour

Re: truncating snapshots

2001-09-16 Thread A. Bardeen
Henry, I'm not sure what you're trying to accomplish by truncating the snapshot. The whole point of the refresh process is to keep the snapshot in sync with the master site. Presumably you are doing a CTAS off of the snapshot to do your manipulations, so what is the point in truncating the

RE: OT Start Button

2001-09-16 Thread Walthour, Jon (GEAE, Compaq)
I stand corrected. Upon further exploration of this subject, I found these on the Internet: http://registry.winguides.com/display.php/791 Or http://www.inquirer.net/infotech/jan2000wk2/info_5.htm Jon Walthour -Original Message- Sent: Sunday, September 16, 2001 9:40 AM To: Multiple

PL/SQL procedure to return multiple rows

2001-09-16 Thread Andrey Bronfin
Dear DBAs ! I need to write a stored proc that will do the following : -- open a cursor ; -- loop over the rows returned by the cursor , filter out some of the rows that do not match a certain criteria , do some processing on other rows (that match the criteria) and

Re: PL/SQL procedure to return multiple rows

2001-09-16 Thread Deepak Thapliyal
hi Andrew, consider using a array (pl/sql table) as a return datatype of your function. Inside the function open ur cursor and populate that set of rows u wanna return into the return datatype.. which would be an array in this case. note that u must define a global array in some package first so

Re: RE: OPS instalation - pretty urgent

2001-09-16 Thread Scott
Cyral, The frame is nothing more than the component that holds the equipment. Oracle can support upto 256 instances in a RS6000/SP environment. I have setup 16 instances on 16 nodes in SP environment and have seen upto 100 instances on 100 nodes. This is the long answer to you question which is

RE: PL/SQL procedure to return multiple rows

2001-09-16 Thread Walthour, Jon (GEAE, Compaq)
Audrey: What you want is a cursor variable. A cursor variable references a cursor object and may refer to different SQL statements at different times. In your case, the most important benefit of the cursor variable would be that it provides a mechanism for passing results of queries (the rows

RE: database disaster recovery

2001-09-16 Thread Sinardy
Hi, Try the story of Chicago flood, NY WTC bombing 199x, They are one technique which is using mobile server, server in mobile container batteries and satellite communication. is impossible for terrorists to attack this facility. Sinardy -Original Message- Gennick Sent: Friday, 14

Re: EBU Question

2001-09-16 Thread Jeram
Title: RE: EBU Question Hi... I have been working with EBU, in DEC Alpha with Oracle 7.3.4, EBU is just like RMAN in Oracle 8 and 8i, it is using catalog server to store all the information about Backup operations. You can find out all the Scripts and Command in $ORACLE_HOME/obackup

Re: ORA-04030 error

2001-09-16 Thread Jeram
Have applied oracle Patch set for 8.1.7.? Rgds/jeram -Original Message-From: Big Planet [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]Date: Saturday, September 15, 2001 8:13 AMSubject: ORA-04030 error Hi All , I am

Re: Fast Refresh of Snaphots Locking?

2001-09-16 Thread A. Bardeen
Tracy, Exclusive locks are not held on the master tables during the refresh so I don't think that's the culprit. I suspect it may be a problem with deleting a large number of rows from the snapshot log that is causing contention. The first thing that comes to mind is transactions waiting for

RE: The DBA in the IS organization

2001-09-16 Thread CHAN Chor Ling Catherine (CSC)
Hi Dave, Our department (appro. 40 staff) is divided into 3 sections : application, network and end-user All our DBAs are under the applications support group. All of us report to the applications head. Our title is Systems Analyst. We don't have root access to the Unix servers. Besides,

1259157 1275224

2001-09-16 Thread Amar Kumar Padhi
Title: 1259157 1275224 Could some one send me notes on the bugs 1259157 1275224 from metalink. I don't have access. rgds amar

RE: Oracle on OS390/MVS

2001-09-16 Thread Brian MacLean
Call this guy, tell him he owes me for continuing to refer people (lol) http://www.oramain.com/ -Original Message- Sent: Friday, September 14, 2001 11:36 AM To: Multiple recipients of list ORACLE-L !! Please do not post Off Topic to this List !! We're looking at possibly