Re: Delete a datafile?

From: Raju Patel <rpatel_at_hooked.net>
Date: 1996/01/02
Message-ID: <4ccfqs$qjk_at_gw.PacBell.COM>#1/1

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

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 Tue Jan 02 1996 - 00:00:00 CET

This message: [ Message body ]
Next message: Gordon E. Hooker: "Delete a datafile?"
In reply to Chuck Hamilton: "Delete a datafile?"
Next in thread: Gordon E. Hooker: "Delete a datafile?"
Reply: Vikram Goel: "Re: Delete a datafile?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message