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

>> I used DBCA to create a "general" database, and I noticed a large
>> (~150MB) tablespace named "EXAMPLE".

>> Can I safely get rid of that tablespace (to get the 150MB back)? If so,
>> what's the easiest way to accomplish that?

Oracle version?

Anyway, if you're sure you don't need it, of course you can drop it. I'd probably double-check with the following couple of queries:

select username
from dba_users
where default_tablespace='EXAMPLE';

and

select owner, segment_name, segment_type from dba_segments
where tablespace_name='EXAMPLE';

If you're then sure you want to drop it:

drop tablespace EXAMPLE;

Depending on the version of Oracle, "and datafiles" can be added to the statement to delete the associated O/S file as well.

HTH -g Received on Wed Jan 11 2006 - 03:52:31 CST