RE: AW: Cannot delete datafile from O/S -- Help !!

2003-03-08 Thread Turner, Adrian A SITI-ITPSIE
My workaround is to offline the tablespace first; seems to work and havent experienced any issues - but then maybe I'm just lucky. ;-) -Original Message- Sent: 07 March 2003 15:54 To: Multiple recipients of list ORACLE-L Though this is how it works on NT, I was pleasantly surprised the

Re: nt script

2003-03-08 Thread Jay
You might want to look at VBScript, it is easy to learn and can be executed on any Win platform. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, March 07, 2003 2:48 PM One bump you might encounter is some of the more useful NT shell

RE: Oracle position on hints

2003-03-08 Thread Nicoll, Iain
Given the attitude of most dba's that you should always use bind variables where possible I can't see how you'd cope with skewed data without them. Most developers should know a databases's data better than the optimiser and certainly when building queries it's always worthwhile seeing where data

RE: Oracle on a SAN.... Good, Bad or Proceed with caution?

2003-03-08 Thread Brian Dunbar
-Original Message- Sent: Friday, March 07, 2003 4:44 PM To: Multiple recipients of list ORACLE-L NetApp SAN? My understanding of NetApps was that is strictly NAS: Network Attached Storage. Basically, JBOD with NIC. SAN's offer quite a few more management and configuration options

RE: Oracle position on hints

2003-03-08 Thread DENNIS WILLIAMS
Stephane I don't see how Oracle could ever have an official position on hints. If they say hints are going away, many developers panic. If they say hints are great, then Oracle competitors will claim Oracle has a bad optimizer. A key political issue in some shops is Using hints makes our

RE: Who Owns Unix?

2003-03-08 Thread DENNIS WILLIAMS
I think the underlying issue is Linux. The SCO people are seeing their licensing fees slip away to the free Linux. As far as I've seen, every major vendor has a Linux strategy. This is SCO's effort to strike back, discourage defections. I think it is pretty dumb. We have been on DEC/Compaq/HP

RE: Oracle position on hints

2003-03-08 Thread Khedr, Waleed
It's like the Auto-pilot -Original Message- To: Multiple recipients of list ORACLE-L Sent: 3/8/03 2:13 PM Stephane I don't see how Oracle could ever have an official position on hints. If they say hints are going away, many developers panic. If they say hints are great, then Oracle

RE: Oracle position on hints

2003-03-08 Thread Connor McDonald
Just to add my meaningless diatribe to the discussion, I think that there are good hints and bad hints. For example, first_rows(n) is a good hint, in that you are giving the optimizer more information as to what your motivations are for this query, without stifling it into a choice that may not

RE: Oracle position on hints

2003-03-08 Thread Pete Sharman
Connor, what can we say? You have gotta getta life! Well, since you're getting a wife instead, that should take care of that anyway. Best wishes to you and Gillian, hope the day is all you want it to be. Pete Controlling developers is like herding cats. Kevin Loney, Oracle DBA Handbook Oh no,

RE: Oracle position on hints

2003-03-08 Thread Grabowy, Chris
Congratulations Connor!!! This is a great day in your life, although some guys would not agree... And thanks for sharing your knowledge about Oracle. -Original Message- Sent: Saturday, March 08, 2003 8:54 PM To: Multiple recipients of list ORACLE-L Just to add my meaningless diatribe

RE: Oracle position on hints

2003-03-08 Thread Khedr, Waleed
Congratulations! No hints for you:) Regards, Waleed -Original Message- To: Multiple recipients of list ORACLE-L Sent: 3/8/03 8:53 PM Just to add my meaningless diatribe to the discussion, I think that there are good hints and bad hints. For example, first_rows(n) is a good hint,