Re: deleting tablespace datafile

In article <3a2352c1$0$3432$4dbef881_at_businessnews.de.uu.net>,   "Michael Lütz" <Michael_Luetz_at_georg.com> wrote:
> Hi all,
>
> how can I delete a datafile from a tablespace who has several
 datafiles ?
>
> We use Oracle 7.3.4 on HP/UX 10.
>
> Please help.
>
> ---
> Michael Lütz
>
>

If there is any data in the datafile, it cannot be deleted.

One method is to
shut down the database
create a complete backup of the system
startup the database
export all the data from the tablespace
delete the data
disconnect the datafiles from the tablespace delete the physical files
assign new datafiles to the tablesspace
import the data

If the tablespace is only holding rollback segments, you can just take the tablespace off line -- delete the tablespace and the files and restore in the latest configuration.

If the tablespace is holding only indexes, you could just drop the indexes without backing up the information. Reinstalling the data means rebuilding the indexes.

Sounds like a lot of work? Yes it is. That is why you are incouraged to develop the logical and physical environment before you put data in it, and carefully work on any expansion.

--
Michael Krolewski
Rosetta Inpharmatics
mkrolewski_at_rosetta.org
              Ususual disclaimers


Sent via Deja.com http://www.deja.com/
Before you buy.