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