Re: 10g new features

From: Mladen Gogala <mgogala_at_adelphia.net>
Date: Mon, 03 Nov 2003 19:49:25 -0800
Message-ID: <F001.005D57AE.20031103194925@fatcity.com>

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).

Received on Mon Nov 03 2003 - 21:49:25 CST