Re: 10g new features

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 <jkstill_at_cybcon.com> 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 <mgogala_at_adelphia.net> 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: Jared.Still_at_radisys.com
> > > > > 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: mgogala_at_adelphia.net
> > > >
> > > > 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: ListGuru_at_fatcity.com (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: yong321_at_yahoo.com
> > >
> > > 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: ListGuru_at_fatcity.com (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: jkstill_at_cybcon.com
> >
> > 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: ListGuru_at_fatcity.com (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: yong321_at_yahoo.com
>
> 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: ListGuru_at_fatcity.com (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: jkstill_at_cybcon.com

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: ListGuru_at_fatcity.com (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).