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 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 morning. <i>homo sapien</i> think better during the day. > > Yong > > > --- Jared Still <[EMAIL PROTECTED]> wrote: > > 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 wrote: > > > 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 'diskb:tbs_f5.dat' to 'diska:tbs_f5.dat': > > > > > > If you only read the subtitle here (first line), you *will* be surprised. > > > > > > Yong > > > > > > --- Mladen Gogala <[EMAIL PROTECTED]> wrote: > > > > 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 rename to test01 > > > > * > > > > ERROR at line 1: > > > > ORA-01904: DATAFILE keyword expected > > > > > > > > > > > > SQL> > > > > > > > > > > > > So, what did you mean? > > > > > > > > On 2003.11.03 21:59, K Gopalakrishnan wrote: > > > > > 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 > > > > > Subject: 10g new features > > > > > > > > > > > > > > > > > > > > Found a site with some 10g new features. > > > > > > > > > > http://www.adp-gmbh.ch/ora/misc/10g.html > > > > > > > > > > I'm sure some will like the new 'alter tablespace rename' > > > > > > > > > > http://www.adp-gmbh.ch/ora/concepts/tablespaces.html#sysaux > > > > > > > > > > > > > > > Jared > > > > > > > > -- > > > > Mladen Gogala > > > > Oracle DBA > > > > -- > > > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > > > -- > > > > Author: Mladen Gogala > > > > INET: [EMAIL PROTECTED] > > > > > > > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > > > > San Diego, California -- Mailing list and web hosting services > > > > --------------------------------------------------------------------- > > > > To REMOVE yourself from this mailing list, send an E-Mail message > > > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > > > the message BODY, include a line containing: UNSUB ORACLE-L > > > > (or the name of mailing list you want to be removed from). You may > > > > also send the HELP command for other information (like subscribing). > > > > > > > > > __________________________________ > > > Do you Yahoo!? > > > Protect your identity with Yahoo! Mail AddressGuard > > > http://antispam.yahoo.com/whatsnewfree > > > -- > > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > > -- > > > Author: Yong Huang > > > INET: [EMAIL PROTECTED] > > > > > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > > > San Diego, California -- Mailing list and web hosting services > > > --------------------------------------------------------------------- > > > To REMOVE yourself from this mailing list, send an E-Mail message > > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > > the message BODY, include a line containing: UNSUB ORACLE-L > > > (or the name of mailing list you want to be removed from). You may > > > also send the HELP command for other information (like subscribing). > > > > > > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > -- > > Author: Jared Still > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > > San Diego, California -- Mailing list and web hosting services > > --------------------------------------------------------------------- > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (or the name of mailing list you want to be removed from). You may > > also send the HELP command for other information (like subscribing). > > > __________________________________ > Do you Yahoo!? > Protect your identity with Yahoo! Mail AddressGuard > http://antispam.yahoo.com/whatsnewfree > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Yong Huang > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > San Diego, California -- Mailing list and web hosting services > --------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).