Re: Can I safely get rid of the EXAMPLE tablespace?

bdbafh_at_gmail.com wrote:
>
> well, if the database is in noarchivelog mode ... it will complain when
> you attempt to offline the tablespace (media recovery not enabled or
> something to that effect).
>
> if the poster is concerned about 150M, I would seriously doubt that
> this little testbed is running in archivelog mode.

Hi,

I put it offline, and didn't get any errors. So, do you all think it's ok if I do the:

drop tablespace EXAMPLE and datafiles;

??

Jim Received on Wed Jan 11 2006 - 17:50:23 CST