Re: How to drop a datafile from tablespace?

From: Roger Redford <dba_222_at_yahoo.com>
Date: 19 Aug 2004 06:06:53 -0700
Message-ID: <a8c29269.0408190506.12ac8296@posting.google.com>

I don't think that it is possible. At least it wasn't in version 7.

Once you add a datafile to the tablespace, Oracle can put data there, and to the other file(s) too.

Dropping the datafile would violate the referential integrity.

cnwy_at_263.net (yoke wang) wrote in message news:<42c18ceb.0408182154.5cf02d58_at_posting.google.com>...
> I have added datafiles to a tablespace by mistake.Who can tell me how to drop them?
>
> Thanks.
>
> Yoke.
Received on Thu Aug 19 2004 - 08:06:53 CDT

This message: [ Message body ]
Next message: Roger Redford: "Re: How to use a row * AS a ROWTYPE parameter for a stored FUNCTION in a SELECT statement"
Previous message: Eric Parker: "Re: Convert Day of week (DY) to actual date"
In reply to: yoke wang: "How to drop a datafile from tablespace?"
Next in thread: Mark D Powell: "Re: How to drop a datafile from 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