alter tablespace offline

[Jeroen van Sluisdam]

Hi,   This weekend I was migrating an oracle 7.3.4 environment to oracle 9.2.0.4 and we encountered a strange problem in issueing alter tablespace name offline. I had to reorganize tablespace and when testing this I did this manually and no problem at all. I put the statements in a script.   Executing the script put the tablespace offlline with exactly : alter tablespace name offline Moving the file with os and then starting up the database in mount phase lead to the problem it would not do this.   Backtracking this to a test environment and rereading the docs lead me to that I should have used alter tablespace name offline normal   I cannot remember whether I did this ok in the first tests but I might have copied it wrong into my script. What is the problem in issueing a alter tablespace name offline so without the normal clause?   Details: HP-UX11.11, Oracle 9.2.0.4   Regards,   Jeroen