OT: Re: 10g new features question for beta testers

2003-12-29 Thread Mogens Nørgaard
Oh yes, the RDD story is good. Carel-Jan and I were in Paris for Oracle World, sharing the horrendous costs of a hotel room, and having one final beer when the phone rang at 2 am. It was a Dane, and it was also one of Miracle's support customers. Since our motto for Miracle Support is Call us

Re: 10g new features question for beta testers

2003-12-27 Thread Tim Gorman
software on it. If your on SAN, you dont install SAN software on it. From: Goulet, Dick [EMAIL PROTECTED] Date: 2003/12/19 Fri AM 09:14:27 EST To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: 10g new features question

Re: 10g new features question for beta testers

2003-12-22 Thread Connor McDonald
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: 10g new features question for beta testers That is not exactly a new feature. Oracle 9i has Oracle Managed Files where you give it a directory and then just build tablespaces

RE: 10g new features question for beta testers

2003-12-22 Thread Pete Sharman
software on it. If your on SAN, you dont install SAN software on it. From: Goulet, Dick [EMAIL PROTECTED] Date: 2003/12/19 Fri AM 09:14:27 EST To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: 10g new features question for beta testers

RE: 10g new features question for beta testers

2003-12-22 Thread Carel-Jan Engel
-Original Message- Mogens Nørgaard Sent: Sunday, December 21, 2003 10:14 PM To: Multiple recipients of list ORACLE-L It's the Best of Breed versus One Vendor debate, and there are pros and cons galore. The perfect scenario, of course, is when they combine, so one vendor delivers the

Re: 10g new features question for beta testers

2003-12-22 Thread Mogens Nørgaard
: 10g new features question for beta testers That is not exactly a new feature. Oracle 9i has Oracle Managed Files where you give it a directory and then just build tablespaces. The database picks the filenames for you. Now mind you it does work, but I'll

Re: 10g new features question for beta testers

2003-12-21 Thread Mogens Nørgaard
] Date: 2003/12/19 Fri AM 09:14:27 EST To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: 10g new features question for beta testers That is not exactly a new feature. Oracle 9i has Oracle Managed Files where you give it a directory and then just build

RE: 10g new features question for beta testers

2003-12-19 Thread Goulet, Dick
That is not exactly a new feature. Oracle 9i has Oracle Managed Files where you give it a directory and then just build tablespaces. The database picks the filenames for you. Now mind you it does work, but I'll be damned if I use it in anything other than a development environment. For some

Re: RE: 10g new features question for beta testers

2003-12-19 Thread ryan_oracle
dont install SAN software on it. From: Goulet, Dick [EMAIL PROTECTED] Date: 2003/12/19 Fri AM 09:14:27 EST To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: 10g new features question for beta testers That is not exactly a new feature. Oracle 9i has Oracle Managed Files

RE: RE: 10g new features question for beta testers

2003-12-19 Thread Goulet, Dick
, Dick [EMAIL PROTECTED] Date: 2003/12/19 Fri AM 09:14:27 EST To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: 10g new features question for beta testers That is not exactly a new feature. Oracle 9i has Oracle Managed Files where you give it a directory and then just

Re: RE: 10g new features question for beta testers

2003-12-19 Thread Connor McDonald
recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: 10g new features question for beta testers That is not exactly a new feature. Oracle 9i has Oracle Managed Files where you give it a directory and then just build tablespaces. The database picks the filenames for you. Now mind

RE: RE: 10g new features question for beta testers

2003-12-19 Thread Goulet, Dick
/19 Fri AM 09:14:27 EST To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: 10g new features question for beta testers That is not exactly a new feature. Oracle 9i has Oracle Managed Files where you give it a directory and then just build tablespaces. The database

RE: RE: 10g new features question for beta testers

2003-12-19 Thread Joe Frohne
software on it. If your on SAN, you dont install SAN software on it. From: Goulet, Dick [EMAIL PROTECTED] Date: 2003/12/19 Fri AM 09:14:27 EST To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: 10g new features question for beta testers That is not exactly a new feature

RE: RE: 10g new features question for beta testers

2003-12-19 Thread Pete Sharman
software on it. From: Goulet, Dick [EMAIL PROTECTED] Date: 2003/12/19 Fri AM 09:14:27 EST To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: 10g new features question for beta testers That is not exactly a new feature. Oracle 9i has Oracle Managed Files where

RE: 10g new features question for beta testers

2003-12-19 Thread Michael Thomas
I was in Reston last night, too. Also, Tom repeatedly emphasized RMAN, which I've not spent enough time mastering, will be even more important in 10g. Does everyone here use RMAN that is using 9i currently? BTW. Tom mentioned SAME, as you say, but I can not remember what he said about it. Sorry.

RE: RE: 10g new features question for beta testers

2003-12-19 Thread Jared . Still
PROTECTED] 12/19/2003 10:09 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: RE: 10g new features question for beta testers Just a couple of comments on this which hopefully won't go down the Marketing track too

RE: RE: 10g new features question for beta testers

2003-12-19 Thread AdamDonahue
by: [EMAIL PROTECTED] 12/19/2003 07:49 AM Please respond to [EMAIL PROTECTED] To Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc Subject RE: RE: 10g new features question for beta testers And the more that vendor, namely the database in this case, controls more and more of the stack

Re: RE: 10g new features question for beta testers

2003-12-19 Thread ryan_oracle
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: 10g new features question for beta testers I was in Reston last night, too. Also, Tom repeatedly emphasized RMAN, which I've not spent enough time mastering, will be even more important in 10g. Does everyone here use RMAN

Re: 10g new features (was: dc_used_extents ,dc_free_extents

2003-12-12 Thread Ron Rogers
Tanel, Thanks for sharing the presentation in the 10g features. I started looking at the slides and I have a question about the cross platform transportable tablespaces and the command you used. From what I gather in the command I can take a Unix based datafile and convert it to a Microsoft

Re: 10g new features (was: dc_used_extents ,dc_free_extents

2003-12-12 Thread Tanel Poder
Hi! Tanel, Thanks for sharing the presentation in the 10g features. I started looking at the slides and I have a question about the cross platform transportable tablespaces and the command you used. From what I gather in the command I can take a Unix based datafile and convert it to a

Re: 10g new features (was: dc_used_extents ,dc_free_extents and d

2003-12-11 Thread Yechiel Adar
I concur. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, December 10, 2003 11:44 PM Excellent slide show Tanel! Robert -Original Message- To: Multiple recipients of list ORACLE-L Sent: 12/10/2003

RE: 10g new features (was: dc_used_extents ,dc_free_extents and d

2003-12-11 Thread GovindanK
Yes .. that is good. GovindanK On Wed, 10 Dec 2003 13:44:34 -0800, Freeman Robert - IL [EMAIL PROTECTED] said: Excellent slide show Tanel! Robert -Original Message- To: Multiple recipients of list ORACLE-L Sent: 12/10/2003 3:34 PM dc_histogram_defs) Pete, I'd like to

Re: 10g new features (was: dc_used_extents ,dc_free_extents and dc_histogram_defs)

2003-12-10 Thread Tanel Poder
Pete, I'd like to clarify my position first: I don't have any burning problem that would compel me to start testing 10g. I want only to learn the new features. Btw, if you want to learn some of the 10g database engine new features (not the marketing buzzwords), then check out one of my

RE: 10g new features (was: dc_used_extents ,dc_free_extents and d

2003-12-10 Thread Freeman Robert - IL
Excellent slide show Tanel! Robert -Original Message- To: Multiple recipients of list ORACLE-L Sent: 12/10/2003 3:34 PM dc_histogram_defs) Pete, I'd like to clarify my position first: I don't have any burning problem that would compel me to start testing 10g. I want only to learn the

RE: 10g new features (was: dc_used_extents ,dc_free_extents and d

2003-12-10 Thread Goulet, Dick
Tanel, Whthough they may not have the sqlplusw.exe for windoes is the sqlplus.exe still there? Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Wednesday, December 10, 2003 4:45 PM To: Multiple recipients of list ORACLE-L d Excellent slide show

Re: 10g new features (was: dc_used_extents ,dc_free_extents and dc_histogram_defs)

2003-12-10 Thread Mladen Gogala
On 12/10/2003 04:34:25 PM, Tanel Poder wrote: Pete, I'd like to clarify my position first: I don't have any burning problem that would compel me to start testing 10g. I want only to learn the new features. Btw, if you want to learn some of the 10g database engine new features (not the

Re: 10g new features (was: dc_used_extents ,dc_free_extents and dc_histogram_defs)

2003-12-10 Thread Jared . Still
. Jared Tanel Poder [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/10/2003 01:34 PM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: 10g new features (was: dc_used_extents ,dc_free_extents and dc_histogram_defs

RE: 10g new features (was: dc_used_extents ,dc_free_extents and d

2003-12-10 Thread Freeman Robert - IL
PROTECTED] Sent by: [EMAIL PROTECTED] 12/10/2003 01:34 PM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: 10g new features (was: dc_used_extents ,dc_free_extents and dc_histogram_defs

RE: 10g new features (was: dc_used_extents ,dc_free_extents and d

2003-12-10 Thread Pete Sharman
recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: 10g new features (was: dc_used_extents ,dc_free_extents and dc_histogram_defs) Pete, I'd like to clarify my position first: I don't have any burning problem that would compel me to start testing 10g

Re: 10g new features (was: dc_used_extents ,dc_free_extents and d

2003-12-10 Thread Tanel Poder
Yep, sqlplus.exe will still be there. Otherwise one wouln't be able to run any automated sql scripts, because isqlplus can't do it as far as I understand. Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, December 11, 2003 12:04 AM

Re: 10g new features

2003-11-05 Thread zhu chao
Hi, Gopa: I ever saw you can rename tablespace via transportable tablespace via edit the dmp file and reimport metadata into database. But it is not one command line. How do you rename tablespace in 9i? I tested rename tablespace in 10i beta1 and found rename tablespace does update

Re: 10g new features

2003-11-04 Thread K Gopalakrishnan
Yong: I was not joking. Actually there is a command to rename tablespaces in 9i and that is undocumented. IIRC it is with some FROM and TO options or something similar to that. Let me check that come back to you offline.. KG - Original Message - To: Multiple recipients of list

Re: 10g new features

2003-11-04 Thread Pete Finnigan
I was not joking. Actually there is a command to rename tablespaces in 9i and that is undocumented. IIRC it is with some FROM and TO options or something similar to that. Let me check that come back to you offline.. ^^ Gopal, please let us all

Re: 10g new features

2003-11-04 Thread Jared . Still
: Subject:Re: 10g new features Yong: I was not joking. Actually there is a command to rename tablespaces in 9i and that is undocumented. IIRC it is with some FROM and TO options or something similar to that. Let me check that come back to you offline.. KG - Original Message

RE: 10g new features

2003-11-04 Thread Jamadagni, Rajendra
Oh My ... 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

Re: 10g new features

2003-11-04 Thread Tanel Poder
essage - From: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L Sent: Tuesday, November 04, 2003 7:24 PM Subject: Re: 10g new features OK KG, the cat is out of the bag. Now you have to tell all of us. Especially Raj. :) Jared "

Re: 10g new features

2003-11-04 Thread Tanel Poder
, 2003 8:04 PM Subject: RE: 10g new features Oh My ... Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts

Re: 10g new features

2003-11-04 Thread Jared . Still
PROTECTED] 11/04/2003 12:04 PM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: 10g new features Btw, bold guys from Polish Oracle User Group have put out Oracle's 10g New Features beta documentation at their website

Re: 10g new features

2003-11-04 Thread Tanel Poder
, November 04, 2003 10:49 PM Subject: Re: 10g new features The link is dead. :( But thanks to the googlecache effect, you can still see the doc: http://216.239.57.104/search?q=cache:UVsNMDV-OBIJ:www.ploug.org.pl/konf_03/Oracle10g_New_Features.pdf+Oracle10g_New_Features.pdfhl=enie=UTF-8

Re: 10g new features

2003-11-04 Thread Jared . Still
... and now printed and nicely bound. :) Tanel Poder [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 11/04/2003 02:59 PM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: 10g new features Exactly, until the doc

Re: 10g new features

2003-11-03 Thread Yong Huang
That's a nice article. The author could have enhanced it by adding or changing some wording. The buffer cache can be flushed with alter system flush buffer_cache. - ... instead of using the undocumented alter session set events = 'immediate trace name flush_cache' in 9i SQL: Regular Expressions

Re: 10g new features

2003-11-03 Thread K Gopalakrishnan
Jared: 'alter tablespace rename' is not the REAL 10g feature. It is available from 9.2 onwards... :) Hope you know what I mean,, KG - Original Message - From: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L Sent: Tuesday, November 04, 2003 12:54 AM

Re: 10g new features

2003-11-03 Thread Mladen Gogala
Actually, I don't understand what you mean. Here is 9.2: SQL create tablespace test datafile '/data/oradata/data/test01.dbf' 2 size 10M extent management local autoallocate 3 segment space management auto; Tablespace created. SQL alter tablespace test rename to test01; alter tablespace test

Re: 10g new features

2003-11-03 Thread Yong Huang
Gopal was joking about the fact that Jared only said 'alter tablespace rename' instead of ALTER TABLESPACE RENAME DATAFILE. In fact, 9.2 SQL Reference has this Moving and Renaming Tablespaces: Example This example moves and renames a datafile associated with the tbs_01 tablespace from

Re: 10g new features

2003-11-03 Thread Jared Still
Not sure I get it either. :) The command listed on the 10g site that I referred to is this: alter tablespace ts_user rename to ts_user_01; Renaming a tablespace is apparently possible with 10g. Must be a joke here somewhere I'm missing. Jared On Mon, 2003-11-03 at 20:09, Yong Huang

Re: 10g new features

2003-11-03 Thread Yong Huang
How can *you* not get it? Gopal says in Oracle 9.2, 'alter tablespace rename' is possible. Of course. The full syntax is alter tablespace mytablespace rename datafile '/path/file.dbf' to '/path/newfile.dbf'. You see the three words 'alter', 'tablespace' and 'rename' in there? You'll get it in the

Re: 10g new features

2003-11-03 Thread Jared Still
Yes, I think you must be right. It's late, and I've been playing with indexes for a couple hours. Jared On Mon, 2003-11-03 at 20:44, Yong Huang wrote: How can *you* not get it? Gopal says in Oracle 9.2, 'alter tablespace rename' is possible. Of course. The full syntax is alter tablespace