Re: Delete a datafile?

From: Chris Bosch <cbosch_at_oracle.co.za>
Date: 1996/01/04
Message-ID: <30EC44D7.6A0B_at_oracle.co.za>#1/1

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?

I know you don't want to hear this, but the only way I know is : Export all tables in the tablespace (COMPRESS = Y) Drop the tablespace
Delete its datafiles on OS level
Recreate the tablespace with 1 large datafile and import the tables.

-- 
Chris Bosch
cbosch_at_oracle.co.za
---- Opinions expressed here are my own views, not my employer's. ----

Received on Thu Jan 04 1996 - 00:00:00 CET

This message: [ Message body ]
Next message: Randy Dewoolfson: "Re: Join/Datatype Performance Considerations"
Previous message: Robert C. Nix: "Re: Forms 4.5 : Viewing any tables"
In reply to: Chuck Hamilton: "Delete a datafile?"
Next in thread: Randy Dewoolfson: "Re: Join/Datatype Performance Considerations"

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

Original text of this message