Re: How do I delete a data file from a tablespace but still keep its data into other data files of this tablespace?

Home -> Community -> Usenet -> c.d.o.server -> Re: How do I delete a data file from a tablespace but still keep its data into other data files of this tablespace?

From: Md Irfan <irfan_pk_at_hotmail.com>
Date: 2 May 2002 01:42:07 -0700
Message-ID: <c42168e7.0205020042.17dca679@posting.google.com>

"Liu, Wallace" <LiuW_at_Sydney.BTAP.BT.com> wrote in message news:<aaq3po$bh5$1_at_pheidippides.axion.bt.co.uk>...
> Dear Oracle gurus,
>
> I am going to rearrange my Oracle database. My Oracle database runs in
> NOARCHIVE mode. I want to delete one data file from one tablespace. The
> tablespace is only 30% full. How do I remove one data file but keep the
> data(if any stored in this data file) to other part of the tablespace?
>

Check out Tom's solution here:

http://asktom.oracle.com/pls/ask/f?p=4950:8:762467::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:515222144417,%7Bhow%7D%20and%20%7Bto%7D%20and%20%7Bdrop%7D%20and%20%7Ba%7D%20and%20%7Bdata%7D%20and%20%7Bfile%7D

Regards/Irfan
> Cheers
>
> Wallace Liu (wallace.liu_at_ap.att.com)
Received on Thu May 02 2002 - 03:42:07 CDT