Once you are sure there is nothing in the tablespace:
- take the tablespace offline.
- drop the tablespace
- remove the associated files with your favorite OS command.
"Vince Laurent" <eAddict_at_yahoo.com> wrote in message
news:9ded3v4ajn3k5lil868tj7v6pt4jdtqaic_at_4ax.com...
> On our SAP system, we have a few tablespaces that are made up of MANY
> datafiles. I have managed (via a 3rd party tool) to reorganize the
> largest tables into thier own tablespacs. Now the original tablespace
> is sitting very empty BUT the physical datafiles are still there. Is
> there a way to drop them?
>
> I found this for growing them but nothing for removing them. I would
> like to reclaim the space.
>
> Since I can apparently ADD space to a datafile as well as remove
> space, can I remove the datafile?
>
> ----------------------------------------------------------------
> One can manually increase or decrease the size of a datafile from
> Oracle 7.2 using the
>
> ALTER DATABASE DATAFILE 'filename2' RESIZE 100M;
>
> command.
> Because you can change the sizes of datafiles, you can add more space
> to your database without adding more datafiles. This is beneficial if
> you are concerned about reaching the maximum number of datafiles
> allowed in your database.
>
> Manually reducing the sizes of datafiles allows you to reclaim unused
> space in the database. This is useful for correcting errors in
> estimations of space requirements.
> ----------------------------------------------------------------
>
> Thanks!
> Vince Laurent
> p.s We are running Oracle 8.1.7.3 on HP-UX 11.0
Received on Tue Jan 28 2003 - 11:54:52 CST
