Re: Simple question: remove a a datafile from a tablespace

From: Andy Hardy <aph_at_glink.net.hk>
Date: 9 Sep 1998 04:20:47 GMT
Message-ID: <01bddb8d$a92ad470$c70c400a@cms_bssup>

Winnie Liu <oracle_dba_at_zdnetmail.com> wrote in article <6sq0pp$bul_at_dfw-ixnews6.ix.netcom.com>...
> There is no safe way to remove a datafile from a tablespace. Because
> whenever you add a datafile to the database, even though you know that
> particular datafile is empty, ORacle had already added this file to its
list
> when they search for free blocks. So, you cannot use offline drop. The
only
> way is to export all the object in that tablespace and then reimport it
back
>

That's weird... so what is the offline drop command for?

Andy Received on Tue Sep 08 1998 - 23:20:47 CDT

This message: [ Message body ]
Next message: Andy Hardy: "Re: Which datafiles are my tables in?"
Previous message: Winnie Liu: "Re: HELP ---- Changes needed to SQLNET for 2 Oracle Instances (different boxs) to communicate <<====================================================================="
In reply to: Winnie Liu: "Re: Simple question: remove a a datafile from a tablespace"
Next in thread: Winnie Liu: "Re: Simple question: remove a a datafile from a tablespace"
Reply: Winnie Liu: "Re: Simple question: remove a a datafile 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