Re: How to drop a datafile permanently?

On 11 Nov 2000, argosy22_at_my-deja.com wrote:

> I can easily create a tablespace:

[snip CREATE TABLESPACE ...]

> and add a datafile:

[snip ALTER DATABASE CREATE DATAFILE ...]

> But, how can I drop this datafile by itself?

[snip ALTER DATABASE DATAFILE ... OFFLINE]

> Is there a way to permanently drop this datafile from the database?

When you create a tablespace in the way that you show, Oracle creates a file in the filesystem and associates the tablespace with it.

You don't normally need to use the 'ALTER DATABASE CREATE DATAFILE' command to create datafiles. That command is normally used when you have lost a file, e.g. disk failure, and you are recovering it from archived redo logs.

If you want to drop a tablespace, use the DROP TABLESPACE command. Note that this does not delete the associated data file from the filesystem -- you need to use operating system commands to do that.

-- 
Regards,

Richard Senior
Mill Dam Consulting Limited
http://www.milldam.com