Removing datafiles

Hi all,

Yeah yeah, I should know this, but I'm just out of a two weeks 'Forget it all'-vacation, and I simply can't remember and don't have the necessary docs to find it.

There are several tablespaces that I want to export, drop everything and recreate with an import.

Dropping everything is very easy using : Drop User ... cascade ; When the datafiles are empty, I want to remove them so that I can replace and resize them more appropriately.

Is it as simple is I think it is : Alter Tablespace ... Remove datafile '...' ;

Thanx for your attention!

Greets, Received on Wed Jul 26 2000 - 03:35:24 CDT