Re: Oracle 11g new features

Matthias Hoys wrote:
> How about:
>
> CREATE USER LIKE ...
> FLASHBACK SCHEMA ...
> select * from v$alertlog (ok, this one can be easily made with external
> tables :-))
>
>
> Matthias
>
>

What about:

DROP TABLESPACE ts_name INCLUDING DATAFILES;

The above would throw an exception if the tablespace was non-empty. I like to have Oracle automatically remove the datafiles when I drop a tablespace, but I want some level of protection that I'm also not dropping segments. So I'd like to leave out INCLUDING CONTENTS. But if you want datafiles, you have to include CONTENTS.

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

-- 
Posted via a free Usenet account from http://www.teranews.com