Re: Can I delete a datafile not used?

From: AlBeRt tHe GoD <albewong_at_wam.umd.edu>
Date: 1996/10/27
Message-ID: <550h1t$pgr_at_dailyplanet.wam.umd.edu>#1/1


Joel Garry (joelga_at_rossinc.com) wrote:
: In article <542j70$8fv_at_eccdb1.pms.ford.com> usfmd2ya_at_ibmmail.com (Alberto Rivera) writes:
: >I make a mistake and add a datafile to a wrong
: >tablespace.
: >
: >The datafile is not used by any segment because
: >the tablespace already had enough free space with
: >another datafiles.
: >
: >So I want to delete such datafile or assign it
: >to the right tablespace. It's possible?
 

: It appears whoever designed the "ALTER TABLESPACE" command decided that
: this would never happen, so there is no trivial way to drop a data file.
 

: >
: >Thanks in advance.
: >

: --
: Joel Garry joelga_at_rossinc.com Compuserve 70661,1534
: These are my opinions, not necessarily those of Ross Systems, Inc. <> <>
: %DCL-W-SOFTONEDGEDONTPUSH, Software On Edge - Don't Push. \ V /
: panic: ifree: freeing free inodes... O
  Received on Sun Oct 27 1996 - 00:00:00 CEST

Original text of this message