Re: Possible 10.2.0.2 Bug - Can someone confirm this?

Things don't look right to me in your test. You should receive an error when trying to drop the default permanent tablespace:

SQL> create tablespace test_ts

   2 datafile '/edcsns20/oradata36/gasq/test_ts01.dbf' size 1m    3 segment space management auto;

Tablespace created.

SQL> alter database default tablespace test_ts;

Database altered.

SQL> drop tablespace test_ts including contents and datafiles; drop tablespace test_ts including contents and datafiles
*

ERROR at line 1:
ORA-12919: Can not drop the default permanent tablespace

I even tried to rename the tablespace and then drop it:

SQL> alter tablespace test_ts rename to foo_ts;

Tablespace altered.

SQL> drop tablespace foo_ts including contents and datafiles; drop tablespace foo_ts including contents and datafiles
*

ERROR at line 1:
ORA-12919: Can not drop the default permanent tablespace

Same error.

Cheers,
Brian

-- 
===================================================================

Brian Peasland
dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown