Re: Delete a datafile?

In article <4ccfqs$qjk_at_gw.PacBell.COM>, Raju Patel <rpatel_at_hooked.net> writes:
>In Oracle, there is no way to delete a datafile once it has been added to
>a tablespace. Only option is to export all objects in the tablespace
>then recreate the tablespace. Of course, you cannot use this option for
>the System tablespace.
>
>Raju Patel
>
Raju,

See my posting in the forum. There is a documented way in Oracle. I suggest you read the SQL language reference for Oracle, under the command ALTER DATABASE. Thanks,

VIKRAM GOEL Sr, DBA

Aerotek Inc., Florida

Responses to : vgoel_at_emi.net

>
>
>
>chuckh_at_ix.netcom.com (Chuck Hamilton) wrote:
>>How do you delete a datafile from a tablespace?
>>
>>Is there an easy way if you know that no extents have been allocated
>>from that datafile?
>>--
>>Chuck Hamilton
>>chuckh_at_ix.netcom.com
>>
>>Never share a foxhole with anyone braver than yourself!
>>
>
>
Received on Wed Jan 03 1996 - 00:00:00 CET