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).
Received on Mon Nov 03 2003 - 22:09:24 CST