Re: Delete a datafile from a tablespace

Hanne Iren Midttun wrote:

> I have by accident added a datafile to the wrong tablespace. Can
> somebody tip me on how can I delete it again?

Look at the ALTER DATABASE command. You can offline/drop the file, or shrink it.

> (Never - ever start working before 1 cup of coffee :-)

In my case it is never post here until I have at least 2 or 3 cups.. or else I go thread hunting with a lead pipe... ;-)

--
Billy