Re: how to drop a data file from a tablespace

From: Reinhard Wahl <wahl_at_zv.fhg.de>
Date: Tue, 01 Jun 1999 13:39:58 +0200
Message-ID: <3753C68E.D0ECB584@zv.fhg.de>

Xu Jun wrote:
>
> Hi,
> Could anyone tell me how to drop a data file from a tablespaces?
> Thx.

If you are running RDBMS-Release <8 then it's not possible! You may only decrease size of this datafile or backup/export, drop and create again the whole tablespace.

With Oracle 8.x I have no experience yet.

Hope this helps,

Reinhard Received on Tue Jun 01 1999 - 06:39:58 CDT

This message: [ Message body ]
Next message: Michel Gauthier: "Re: Running a script on shutdown/startup"
Previous message: Peter Laursen: "InitSID.ora"
In reply to: Xu Jun: "how to drop a data file from a tablespace"

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US