RE: Temporary tablespace for SYS

Hi Steve,

I've just done a test on both 7.3.4 and 8.1.5 and and have been able to confirm that you CAN drop a tablespace that has previously been the temporary tablespace for SYS. So I don't know what version of Oracle this theory may have come from.

Rgs,

Leng.

        H815.SYS> alter user sys temporary tablespace OEM_REPOSITORY;

        User altered.

        select username, default_tablespace, temporary_tablespace from dba_users

        where username = 'SYS';

        USERNAME DEFAULT_TABLESPACE TEMPORARY_TABLESPACE

• ------------------------------